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
26 views

Which database is perfect fit for making writing application such as Pages(apple) [closed]

I want to make an application that helps writing. Clients need to write the answers to questions, or fill the blanks in the sentences. Then, those answers are needed to store in Database and can be ...
0
votes
0answers
16 views

Product Inventory Management System [closed]

I've been reading inventory management system tutorials for a while but still don't understand. Let's assume we are in charge of developing a typical crud API to serve a variety of products. At first, ...
0
votes
1answer
21 views

Inserting many documents in collection, but only unique elements, based on specific field

I cannot seem to find an answer on this anywhere. I need the following: Given an array of objects with the structure: { link: 'some-link', rating: 25, otherFields: '..', ...
6
votes
3answers
1k views

Is a single-table relational database similar to a simple NoSQL database?

One advantage touted for NoSQL databases is the lack of a schema. In the case of a single-table relational database, there are no relationships between multiple tables, and new columns can be easily ...
0
votes
1answer
19 views

Associating large numbers of Items with large numbers of Users in Mongo

Say I have tables Items and Users, which are both in the order of millions. Users can be associated with rows in Items via a 1 to many relationship. This is expected to be on average, a few thousand. ...
0
votes
1answer
18 views

NOSQL Manager for MongoDB throws command failed collection already exists

While copying collections from one MongoDB server hosted on A to another MongoDB server hosted on B using Copy collection to another database tool of NOSQL Manager we got an error "Command create ...
0
votes
0answers
31 views

narrow or wide - how to store huge amount of values

I think, I have two questions maybe in one (because they belong together and the first is priorized while the second is just an idea). The leading question is: Given billions of triplets (Timestamp, ...
1
vote
1answer
35 views

Is there a use case where RDBMS is the best data store for querying only? [closed]

I am trying to figure out whether there is any legitimate use case for Relational Data Store (like MySQL, PostgreSQL, etc) in DDD, Event sourcing and its projections. Hear me out. In event sourcing ...
0
votes
0answers
21 views

How do I plan out this MongoDB database?

Here's a simple hierarchy of how my data would be stored. jobs/ |---- movie1/ | |---- shot1/ | | |---- shot1_fx/ | | | |---- shot1_fx_v001/ | | | ...
0
votes
1answer
16 views

Creating a relationship between a document and a collection in MongoDB

I have no idea if this is even possible but I'd like to find out if there's some way to create a relationship between a document and a whole collection. I have a user schema that looks something like ...
0
votes
0answers
25 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
55 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
54 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
34 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
1answer
84 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
25 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
139 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
346 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
25 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
5k 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
34 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
8 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
38 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
265 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
40 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
117 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
34 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
16 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
36 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
34 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 ...
1
vote
1answer
57 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
30 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
23 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
35 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
43 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
41 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
32 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
26 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
188 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
29 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
476 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 ...
1
vote
1answer
54 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
452 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
29 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
438 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
143 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 ...
1
vote
1answer
86 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
606 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: [ ... ...

1
2 3 4 5
7