Questions tagged [nosql]

A catch-all term describing database systems using various non-relational models. Such systems are usually engineered to be high-performance.

Filter by
Sorted by
Tagged with
0
votes
0answers
18 views

Is it time to move to nosql when table A is almost table B? [closed]

The data in my backend has changed a LOT since I built it when I knew almost nothing back in 2010. I still no almost nothing, except that it might be NoSQL time. My data (ie: tables) is 283 ...
0
votes
0answers
20 views

MongoDB generated ObjectID for arrays is descending instead of ascending

I have the following document in a collection in my MongoDB database: "_id":"5e2088563824e72ea5ee7095", "image":"xxx", "questions":[ { "_id":"5e2088563824e72ea5ee70c3", "text":"...
0
votes
0answers
49 views

Cascading One-to-Many relationships modeling

Are there any drawbacks or better alternatives of this non relational model ? I note that it remains easy to understand but the concern is with the code interacting with. First, as I was introduced ...
1
vote
1answer
46 views

The best practice for SQL + NoSQL database design [closed]

I’m in process of designing database architecture for my diploma project and I have second thoughts about different solutions. I know and understand all my objectives can be done within relational ...
1
vote
1answer
28 views

When is running a graph database like OrientDB in cluster mode required?

OrientDB can run in a distributed environment, supports ACID transactions and peer to peer replicaiton. According to the book "NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot ...
6
votes
0answers
36 views

Efficiently store large list structure in RocksDB so that the data can be retrieved in pages

Description: RocksDB is a key-value storage so we can simply serialise the list of objects & store the value corresponding to a key. This would be ok if the data in the list is small enough. ...
0
votes
0answers
22 views

How to structure cancelled orders?

I'm working with NoSQL Database "Firebase", and I have a node that contains 6 categories "services" in everyone I put an array of orders well? now when the user logged I get/fetch all orders bassed ...
0
votes
1answer
24 views

How to use variables in a mongodump query

I want to backup data of last day (Current Day-1) every day using cron tasks. In the mongo shell, I can query the data using variables as below: var start = new Date(); start.setHours(0,0,0,0); ...
0
votes
0answers
74 views

Dynamodb Adjacency List Design Pattern

I have been looking at some of the documentation for dynamodb best practices/design. Specifically Example of Modeling Relational Data in DynamoDB and Adjacency List Design Pattern. I see in the ...
0
votes
1answer
14 views

Modelling document sharing permissions with NoSQL

I'd like to use NoSQL databases for the first time and was going to use MongoDB. I have a project where an employee with @employeed_id can go to a web app and get a list of documents that he can read....
0
votes
2answers
151 views

Storing arrays in MYSQL?

I've googled I keep getting answers that have to do with a php function named, serialize. I won't be working with php, so that solution wont work for me sadly. I worked with a nosql db (mongodb I ...
0
votes
0answers
24 views

NoSQL and SQL databases together

I couldn't find any topic with my question, so I created my own question. I have a web application with big database which has not lot's of Update and Insert but has so many search (Select). This ...
0
votes
0answers
7 views

Guidance on my NoSQL Schema

I'm working on an application in which I'm in need of a database. I chose NoSQL (DynamoDB) for the app. My Unique ID is set to a user sub but its payload is a list of objects. There are 191 of these ...
1
vote
0answers
34 views

Database system to store lots of large dictionaries

I have an application requirement to store a large amount of dictionaries in a database for fast reading. I know beforehand the approximate size and number of data that needs to be stored. The ...
1
vote
1answer
91 views

Getting Nested query result from Cosmos DB with property named “Value”

I have Cosmos Db collection, I am trying to query the "Key" "Value" pair from. Working query: SELECT ed From c JOIN ed IN c.ExtendedData Where ed.Key = "MembershipTypeId" And got result: [ { ...
1
vote
0answers
33 views

Cassandra not returning the row of the specified primary key

First of all, my table is structured like this: CREATE TABLE timeseries_data.test_data ( date timestamp PRIMARY KEY, data1 float, data2 float ) WITH bloom_filter_fp_chance = 0.01 AND ...
0
votes
3answers
70 views

How to list connections in Secondary Nodes

In my cluster on Atlas, have a many connections in secondary nodes. How to list this connections? When execute this command, list the current connections in primary node. db.currentOp(true).inprog....
1
vote
1answer
29 views

How to convert a datefield from string to date?

Here is the query that I am using. What I need to extract is the data for the last 10 minutes. But no records found is the output for this query, I think this is due to the type of data that were ...
0
votes
0answers
11 views

Denormalisation of data for Firebase/Firestore NoSQL

I am having trouble working out how to efficiently query data in a similar structure to the below. This is just some test data I have thrown together. Im not even sure if it is possible in the way I ...
2
votes
0answers
33 views

Querying a High Cardinality Field

I am designing a data model for our orders for our upcoming Cassandra migration. An order has an orderId (arcane UUID field) and an orderNumber (user-friendly number). A getOrder query can be done by ...
1
vote
1answer
32 views

Design datastore persistence based on state of the Entity

I have an entity Content to persist in the database. The entity has an attribute LifeCycleState that denotes the present state of the content. For the sake of elaborating further, assume we have ...
0
votes
0answers
13 views

How do you merge older data with an apend only stream database?

I've been reading about streaming databases that record all events as immutable entries in an append-only log. Then map/reduce jobs or something like a "materialized view" is constructed reading the ...
0
votes
0answers
30 views

Storing objects in key/value stores - serialized or separate values?

I'm playing around with Go and BadgerDB, which is an embedded disk based (not in-memory like Redis) key/value store. There's just so little information about how to use key/values stores in general. ...
0
votes
0answers
28 views

NoSQL database for analytics

Need NoSQL database for analytics. Given: Large, partitioned Postgres(9.4) tables, with next structure: - device_id: UUID - monitored_date: TIMESTAMP - properties: jsonb (different keys) (...
0
votes
1answer
17 views

DynamoDB: How to model data that's shared and queried by all users?

I am very intrigued by DynamoDB, and it works incredibly well when I model the data for my main use case for my application. That being said, there is one specific use case that I can't wrap my head ...
0
votes
0answers
24 views

Are OLAP / NoSql / In-Memory database mutually exclusive concepts or can there be overlap between them?

I'm a data scientist with little knowledge of DB technology. I keep hearing 3 types of databases mentioned as key technologies for analytics and modeling solutions: NoSql databases OLAP cubes In-...
1
vote
0answers
26 views

Storing a large, sparse matrix in Apache Hbase? [closed]

I'm currently testing out Apache Hbase for our Matrix analytics service. I'm using a managed cluster running on AWS EMR. The matrices are sparse, and we have 50,000 columns, and up to 10 million ...
0
votes
1answer
37 views

What is a good practice for storing unstructured tables as a field in mongodb

Context: I am developing an application that requires handling tables that do not necessarily have an uniform structure (eg. different/extra columns). Those unstructured files also need to be grouped ...
1
vote
0answers
30 views

How to implement correctly from SQL to NoSQL (DynamoDB)?

I am just new in NoSQL and DynamoDB. I try to moving from using AWS RDS to DynamoDB. I have table user which can have more than one of work experiences and can have more than one of interest (table ...
0
votes
1answer
22 views

Spliting changes in separate collection/table or not?

I am using MongoDB to store products, user accounts and stuff on my server and so far it's going nice. But now I'm stuck deciding how do I "split" things apart, like: I have a database where ...
1
vote
0answers
25 views

Mongodb - Security weakness while using --authenticationDatabase admin? [duplicate]

I was trying to create a new Mongodb instance based on my old Mongo Database. In my current DB I have an user and password configured. So, I can access my database using: $ mongo --host $MONGO_HOST -...
0
votes
1answer
155 views

Multi-master (NoSQL) database solutions with cloud and no-premise option

We are currently investigating database options for distributed database (possibly globally distributed) where the data in general is stored in "cloud" (this would not be a special requirement). The ...
0
votes
1answer
27 views

Invoices kept in document with user information in no sql database is recommended?

I have a application which has tenant details like { "name" : "", "Address" : "" , ... Bills :[ current : {"rent":"" ,"electricity":"" ,"date":""}, previous : [{"rent":"" ,"electricity":"...
0
votes
0answers
342 views

What can Neo4j do that ArangoDB can't?

I'm in the process of choosing a database for a project related to biology and medicine. The main added value of a graph database will be the ability to explore and weight the relationship between ...
0
votes
0answers
112 views

How can I complete a full export and import of Google BigTable

!/bin/bash BigTable_ExportTest.sh Edited original source script with new bucket and jar file. This script will backup BigTable Data Table by table and store it into a destination location as ...
1
vote
1answer
53 views

Sharding the Existing MongoDB

I've got 3 dedicated non-virtual servers (srv1-3). On one of them (srv1) i've got MongoDB in production, that already have got really big amount of data. At the present time there is no sharding or ...
0
votes
1answer
255 views

Can't change MongoDB default DB path

I know there are multiple questions on the same issue and I followed them but not sure what is happening here. First of all I am trying to change the default db path to a a separate mounted disk. And ...
0
votes
1answer
22 views

Does any MariaDB engine have the option to declaratively or configuratively abstract highly-redundant data?

I have an application which is architected in a "NoSQL" style around one fully denormalized "main table" which currently just holds a primary key and one JSON-valued column. For reasons which are ...
0
votes
1answer
324 views

How to efficiently design Firebase database for Home service Booking application? [closed]

I'm planning to build my own app. It's a home service App to link users with other providers. I'm recently used a NoSQL database, Firebase, and I am stuck with the design of the database for my app. ...
1
vote
0answers
90 views

Metadata overhead warnings in couchbase web

I have 3 node couchbase cluster which is working fine but now days I am getting many alerts as "Metadata overhead warning. Over 54% RAM allocated to bucket" on couchabse web UI. Please help to supress ...
0
votes
0answers
50 views

replication type of dynamodb

What is the replication type of the DynamoDB system? Like is it master slave, peer to peer, multi master, or something else. I know that that for global tables, DynamoDB has cross replication with ...
1
vote
1answer
61 views

Should I use a RDBMS JSON field or a NoSQL database to store large JSON datasets that I don't need to query?

I am building a website that allows users to retrieve a bunch of open source chart (eg UN data). I don't need to be able to query the data itself. I will instead extract certain meta data (keywords, ...
-1
votes
1answer
359 views

MongoDB Performance of Overwriting an Array Field vs Individually Updating the items

The problem I am facing is basically updating the inventory when an order is received in a MongoDB database.The general hierarchy is as follows Manufacturer: { ... Items: [ ... ...
0
votes
2answers
2k views

Audit Trail in NoSQL vs. Relational DB, audit trail feature in MongoDB [closed]

Two questions regarding selection a DB type and engine for the scenario when the Audit Trail functionality is a must: Is there any preference in DB type (NoSQL/Relational) choice when the Audit Trail ...
2
votes
1answer
68 views

Microsoft Column Store Database?

Using Microsoft technologies/products is it possible to create a column store database with column family sets? That is each row being able to have a different number and type of columns. Colmun ...
0
votes
1answer
43 views

What is the best way to cross check the record in multiple collections

I am developing the application in which system will show the campaign content to users which he/s never seen. To keep the logs either the specific user seen the specific content or not, i am ...
1
vote
1answer
142 views

Hierarchical / tree data - which type of database to use & design?

For querying (and writing to) a hierarchical structure (like a folder containing files and other folders, up to n levels deep, where n is pretty small, probably around 10, and there would be lots of ...
3
votes
1answer
60 views

MySQL and PostgreSQL has JSON data types, is it the same as NoSQL database? [closed]

MySQL and PostgreSQL introduced JSON data types, is it the same as NoSQL database? Why? NoSQL here is a class of data bases similar to MongoDb and DynamoDB.
0
votes
4answers
189 views

How to tell if a project needs a NoSQL database solution? [closed]

How to tell if a project needs a NoSQL database solution? I think that SQL limits define it. If the project needs bigger database or bigger fields then it needs NoSQL. Am I right? I looked into ...
1
vote
0answers
16 views

How to store a multi-lingual “dictionnary” in a NoSQL database?

I hope this is the good Stack to ask this question, pardon me if it's not. I need to categorize images and need manipulate a lot of words. I'll explain what's bugging me first and then there is a ...