Questions tagged [document-databases]

37 questions
33
votes
1 answer

When should you use a document vs relational vs graph database?

For the purposes of discussion let's consider a FourSquare scenario. Scenario Entities: Users Places Relationships: Checkins: users <-> places, many to many Friends: users <-> users, many to many Database Design These will most likely have…
8
votes
2 answers

When to use wide column stores instead of document based stores

I have some experience with document-based stores (MongoDB and CouchDB) and I am interested in exploring wide-column databases. Based on my initial exploration I can grasp a basic understanding of how wide column stores are different, but I do not…
SystematicFrank
  • 897
  • 8
  • 18
7
votes
2 answers

How do document-oriented databases implement references?

In relational world we have Foreign Keys to reference other entities. But how do document-oriented databases like MongoDb, CouchDb, RavenDb implement references among entities? Update. StackExchange related example. We have Question entity and its…
SiberianGuy
  • 4,753
  • 6
  • 34
  • 46
4
votes
1 answer

Self describing data with UI

I have a use case where my team owns a web UI to aggregate data from 10+ service teams and present it to the customer in order to collect more information . This data (which is in json format) is very dynamic (changes every other day) and is used…
user401445
  • 99
  • 3
4
votes
0 answers

NoSQL data modelling for multi level nested documents

What kind of NoSql data modelling is best suitable for the following requirement? This can be visualised (NoSQL-Document) as a Collection of Records where each Record contains nested Documents.The nested document entities at different levels are…
KDR
  • 153
  • 8
4
votes
1 answer

Votes database architecture

I want to create an app using MongoDB (NoSQL database) that allows people to vote on posts (simillar to Reddit). What's the recommended way to store votes for the users? Probably the database structure will have to quickly respond to queries…
4
votes
3 answers

NoSQL Document Database as a Message Queue

I am considering using a NoSQL Document database as a messaging queue. Here is why: I want a client to post a message (some serialized object) to the server and not have to wait for a synchronous response. I want to be able to pull messages off…
MattW
  • 879
  • 2
  • 10
  • 16
4
votes
1 answer

What is the recommended MongoDB schema for this quiz-engine scenario?

I'm working on a quiz engine for learning a foreign language. The engine shows users four images simultaneously and then plays an audio file. The user has to match the audio to the correct image. Below is my MongoDB document structure. Each…
hughesdan
  • 93
  • 1
  • 6
3
votes
1 answer

Implementing tags in object

In my app, I'm implementing a questionnaire system and I'd like to implement tags for questions -- very similar to tags in questions here or Stack Overflow. I wanted to get some advices on how to implement this as a property in my object. Should…
Sam
  • 403
  • 2
  • 6
  • 11
3
votes
4 answers

Using a relational and a non-relational database in the same project?

I ran into a problem on the project I'm working on right now. It is basically an app that stores a path based on GPS coordinates. The app runs on android an saves the GPS location every second and then sends it to on API. I think if I insert a…
3
votes
1 answer

What is the query router in mongodb architecture of sharding?

I have read the guide and they say Query Router Sharding is transparent to applications; whether there is one or one hundred shards, the application code for querying MongoDB is the same. Applications issue queries to a query router that …
Khan
  • 133
  • 1
  • 5
3
votes
1 answer

Standard API Protocol for ECM Systems?

I am wondering if there is an established standard or protocol when working with APIs for document management systems or ECMs. For example, let's say I'm working on a new product and I want it to have support for both FileNet and Documentum. Is…
3
votes
1 answer

Design considerations on JSON schema for scalars with a consistent attachment property

I'm trying to create a JSON schema for the results of doing statistical analysis based on disparate pieces of data. The current schema I have looks something like this: { // Basic key information. video :…
casperOne
  • 131
  • 7
2
votes
1 answer

How to scale transactional outbox pattern with document database?

I'm trying to understand CQRS, DDD by writing a small pet project which is somewhat similar to this great repo. I've come across Transactional Outbox pattern and as imo it was correctly pointed out in this article it looks hard to scale this…
2
votes
1 answer

Data modeling for NoSQL document database

Below are the common phases applied, for a real world requirement(data) map to DBMS specific schema. Conceptual models ER/EER/CODASYL/Hierarchical bridge the gap, in mapping the real world data(requirement) to DBMS specific schema. In RDBMS world,…
1
2 3