Skip to main content

Questions tagged [document-databases]

Filter by
Sorted by
Tagged with
2 votes
1 answer
2k views

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 ...
gasabr's user avatar
  • 51
1 vote
2 answers
2k views

How to document a NoSQL document-based data model?

How do you document the logical data model of a document-oriented database like MongoDB? For relational databases, Entity-Relationship diagrams or UML class diagrams are used. What is the practice for ...
ssn's user avatar
  • 71
0 votes
2 answers
271 views

Saving & Referencing different Schema Types in MongoDB (e.g. for a CMS with Building Blocks)

Say I wanted to build my own CMS system and store data in MongoDB. I would like to have a Collection called BlogArticle. Each article can have a different structure, but will be put together by the ...
antonwilhelm's user avatar
-1 votes
1 answer
133 views

As a client; how to present database needs to perspective designers?

[I am preparing to solicit proposals for database/project management software design. I know that the quality of the final product will depend on how clearly and completely I can organize and explain ...
Casey's user avatar
  • 27
0 votes
1 answer
149 views

Database of big text documents many-to-many: one big relationship table, a lot of small ones, or a better way to link abstract text data?

so I am struggling a bit with a database setup. I found post with similar problems, but the reason behind the answers was not what I was looking for, hence I ask again with my specifics. I am building ...
Cerealz's user avatar
  • 31
-2 votes
5 answers
322 views

Why does today's companies follow old RFC's?

Let me start by saying that of course conventions are important, there should be a rule of thumb for some cases that is representing the best action to follow by, in order to prevent mistakes and make ...
moti shaku's user avatar
1 vote
2 answers
937 views

Is database linked list a good architecture for replies and reviews system when using mongodb?

I want to create a system of user reviews and replies to the reviews in a website. There can be replies to replies. I'm using mongodb database which I think is an important detail. The review ...
Yos's user avatar
  • 157
1 vote
3 answers
291 views

Query 30 million HTML documents

I have 30-ish million html documents in a file system. There is no emergency, the files are in a reasonable directory tree, it's not breaking the file system. But I'd like to be able to organize and ...
Martin K's user avatar
  • 2,917
0 votes
1 answer
791 views

Optimizing inserting/storing Large amount of data in database

We have a POST API that takes data from the Client and send it to different applications (Payment, Email, SMS). We also store all the data sent by the Client in a database for future analytics ...
Ahmad's user avatar
  • 139
0 votes
1 answer
139 views

Combining relational and document database for movies

As a architecture design brainstorm, I am pondering on how should I define schemas for movie database where heavy text searching is delegated to document based database (eg. elasticseach) while rdbms ...
Mike's user avatar
  • 103
1 vote
1 answer
507 views

Designing a Social Network with Graph Databases

I am prototyping a social network as part of a project I am working on and want to learn the right way to do it as if it were for an industry leading company. I've decided on implementing the social ...
lvoelk's user avatar
  • 71
1 vote
2 answers
105 views

Algorithm. Find the group of documents with the least amount of words

I need help with a problem which I have been working for the last month. I have a group of documents, each document has a set of unique words (if the word appears more than once in the document, I ...
julodnik's user avatar
  • 119
4 votes
1 answer
262 views

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 ...
user401445's user avatar
2 votes
2 answers
3k views

How to find matching profiles?

I'm developing backend for a dating app, in which each user has a profile of his/her characteristics a profile of ideal match's characteristics There are dozens of characteristics like gender, ...
Babr's user avatar
  • 139
4 votes
0 answers
2k views

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 ...
KDR's user avatar
  • 153
3 votes
1 answer
4k views

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 ...
Sam's user avatar
  • 413
4 votes
1 answer
1k views

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 ...
Cristy's user avatar
  • 219
-2 votes
1 answer
259 views

Architectural design of an SQL & Document Database based Web Application

I am designing a web application with Django as the backend. Overview of the system is as follows Data is collected from user related to different entities. Example : Plant, Project, Machine, Test, ...
Raghavendra Kumar's user avatar
2 votes
1 answer
501 views

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(...
overexchange's user avatar
  • 2,305
2 votes
1 answer
95 views

Deleting Users in document type database

I'm building a system using a document type database. The system has users. I was told that in production it is best to avoid making outright deletes. I understand the convention is to either mark ...
xerotolerant's user avatar
0 votes
2 answers
433 views

Questioning the impact of UUIDs

When I first played with a NoSQL database I become aware of the impact of UUIDs in a distributed system. MongoDB defaults to ObjectIDs, but I've always questioned in which cases UUID (RFC4122) would ...
SystematicFrank's user avatar
3 votes
4 answers
2k views

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 ...
Jonas Wirth's user avatar
3 votes
1 answer
3k views

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. ...
Khan's user avatar
  • 133
1 vote
1 answer
2k views

How to structure a reservations system in a document based database?

I really don't know if this is the right forum for this but I need help designing my database. Also I apologize for the horrible title: I don't know how to summarize the issue below in a single title. ...
Gasim's user avatar
  • 179
3 votes
1 answer
597 views

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 ...
Unknown Coder's user avatar
0 votes
1 answer
678 views

Planning complex Mongo (And possibly other NoSQL) Databases

There is no "right way" to do anything, but there are "better" and "worse" ways, as well as true and tested ways. I'm studying Mongo and considering it for a project. It's gonna start small but ...
Fernando Cordeiro's user avatar
1 vote
4 answers
2k views

Is there an accepted design pattern for storing a few global variables in a NoSQL database?

I'm wanting to create an admin dashboard for my app, and to show new events there. In order to know which events are new, I'll need to store at least one extra datapoint to the server: the last date ...
MalcolmOcean's user avatar
8 votes
2 answers
3k views

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 ...
SystematicFrank's user avatar
2 votes
1 answer
314 views

Would a model like this translate well to a document or graph database?

I'm trying to understand what types of models that I have traditionally persisted relationally would translate well to some kind of NoSQL database. Suppose I have a model with the following ...
Eric's user avatar
  • 123
4 votes
3 answers
6k views

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 ...
MattW's user avatar
  • 879
4 votes
1 answer
4k views

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. ...
hughesdan's user avatar
0 votes
1 answer
270 views

Would this data requirement suit a Document -Oriented database?

I have a requirement to allow users to fill in journal/diary entries per day. I want to provide a handful of known journal templates with x columns to fill in. An example might be a thought diary; a ...
codecowboy's user avatar
3 votes
1 answer
259 views

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 ...
casperOne's user avatar
  • 131
33 votes
1 answer
29k views

When should you use a document vs relational vs graph database? [closed]

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 ...
wting's user avatar
  • 1,044
1 vote
1 answer
2k views

Storing documents in Database vs CMS in JSF, Seam, Hibernate application on cloud

I am about to start with an application using JSF 2, Seam 3, Hibernate and Hibernate search with the following characteristics: Users will be uploading documents (pdf, doc). There can be millions of ...
Abdullah Shaikh's user avatar
7 votes
2 answers
2k views

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 ...
SiberianGuy's user avatar
  • 4,813
1 vote
3 answers
2k views

Is OrientDB document-database? or graph-database?

Some document says OrientDB is document-database, some others talks it's graph-database. What's right?
Eonil's user avatar
  • 1,739