Questions tagged [document-databases]
The document-databases tag has no usage guidance.
37 questions
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 ...
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 ...
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 ...
-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 ...
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 ...
-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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
-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, ...
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(...
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 ...
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 ...
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 ...
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. ...
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.
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
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?