Tagged Questions
10
votes
7answers
282 views
Nested Entities and calculation on leaf entity property - SQL or NoSQL approach
I am working on a hobby project called Menu/Recipe Management.
This is how my entities and their relations look like.
A Nutrient has properties Code and Value
An Ingredient has a collection of ...
10
votes
4answers
2k views
Weaknesses with different types of NoSQL databases
Here's my question: What are the weaknesses with different types of NoSQL databases? Specifically, what're the weaknesses of key-value stores, graph data stores and document stores?
I've had an easy ...
10
votes
1answer
443 views
How much does the data model affect scalability and performance in so called “NoSQL” database?
You can't ever have a talk about so called "NoSQL" database without bringing the CAP theorem (Consistency, Availability, Partition : pick two). If you have to pick say, between MongoDB (Partition, ...
8
votes
3answers
1k views
Storing n-gram data
(hopefully I landed on the right stack exchange site)
I was hoping to brainstorm a little bit on the subject of storing n-gram data.
In my project, I am trying to solve linguistic problems where I ...
4
votes
2answers
5k views
Why NoSQL over SQL? [duplicate]
Possible Duplicate:
When would someone use MongoDB (or similar) over traditional RDMS?
How well the SQL and NoSQL go head-to-head. I read somewhere that SQL databases are not well for data ...
4
votes
4answers
243 views
Typed search over complex model. Possible CQRS / NoSQL solution
Given the following relational model:
I need to implement a typed search for hotels, which should be able to query on name, city, country, category, hoteltype, roomprice, customtype, room custom ...
3
votes
2answers
6k views
How to correctly design NoSql database schema? [closed]
I would like to learn something more about NoSQL databases, so I've chosen to create a new project from scratch to handle football results. In my traditional relational database, I have tournaments, ...
1
vote
2answers
440 views
Why OTServs have an item cloning problem if the server crashes? [closed]
OTServs are open source MMORPGs with a huge community. Mostly all of them have a serious problem: if the server crashes, people can clone items. This is a dirty trick that can be executed because the ...
1
vote
2answers
139 views
How to represent a tree structure in NoSQL
I'm new to NoSQL and have been playing around with a personal project on the MEAN stack (Mongo ExpressJs AngularJs NodeJs). I'm building a document editor of sorts that manages nodes of data. Each ...
1
vote
1answer
505 views
NoSQL as file meta database
I am trying to implement a virtual file system structure in front of an object storage (Openstack). For availability reasons we initially chose Cassandra, however while designing file system data ...
1
vote
1answer
501 views
NoSQL (Azure Table Storage) RowKey design for ordered data
I store large quantities of GPS data in storage tables. Each partition can reach up to 1 million entities. Each GPS entity that is inserted into the table is actually sequential to the previous data ...
1
vote
1answer
81 views
Azure Storage Table design with multiple query points
I have the following Azure Storage Table.
PositionData table:
PartitionKey: ClientID + VehicleID
RowKey: GUID
Properties: ClientID, VehicleID, DriverID, Date, GPSPosition
Each vehicle will log ...
0
votes
1answer
86 views
Dividing database between MySQL and NoSQL
Mine is a typical website developed with LAMP stack. Due to scalability issues we are planning to incorporate NoSQL for the application.
For the implementation, we are planning to implement hybrid ...
0
votes
1answer
113 views
Google Datastore and deep records
I'm in the beginning of creating a website that uses Google Datastore to store information related to clients and I'm curious if the record is too deep for NoSQL or if I'm fine.
Essentially I'll be ...
