Stack Overflow
Stack Overflow

Questions tagged [document-database]

A document database stores, retrieves, and manages document-oriented information, also known as semi-structured data. Document databases often store data in a denormalized fashion as opposed to normalized data, which would appear in a relational database.

An excerpt from Wikipedia:

The central concept of a document-oriented database is the notion of a document. While each document-oriented database implementation differs on the details of this definition, in general, they all assume documents encapsulate and encode data (or information) in some standard formats or encodings. Encodings in use include XML, YAML, JSON, and BSON, as well as binary forms like PDF and Microsoft Office documents (MS Word, Excel, and so on).

Examples of document databases:

232 questions
11
votes
4 answers

Sql Server XML columns substitute for Document DB?

Is it possible to use Sql Server XML columns as a substitute for a real Document DB (such as Couch or Mongo) ? If I were to create a table with a guid PK Id and an XML column for the document. What would be the main problems compared to using a…
Roger Johansson
  • 22,764
  • 18
  • 97
  • 193
10
votes
1 answer

Should I denormalize or run multiple queries in DocumentDb?

I'm learning about data modeling in DocumentDb. Here's where I need some advice Please see what my documents look like down below. I can take two approaches here both with pros and cons. Scenario 1: If I keep the data denormalized (see my documents…
Sam
  • 26,817
  • 58
  • 206
  • 383
9
votes
1 answer

What is the difference between object-oriented and document databases?

What is the difference between object-oriented and document databases? I didn't use object-oriented databases, but when I use document database (RavenDb) I store and read usual object-oriented classes without problems.
SiberianGuy
  • 24,674
  • 56
  • 152
  • 266
9
votes
2 answers

Is MongoDB thread-safe?

I'm running MongoDB on Windows. I have 1 or more threads that drop and recreate a collection. Using mongo.exe with the show collections() command, I'm seeing multiple collections with the same name (well over 1,000 collections with the same…
BGohil
  • 165
  • 1
  • 2
  • 5
9
votes
1 answer

Cosmos DB SQL Query for nested objects

I have accounts collection in Cosmos DB. I tried different queries but failed what will be equivalent SQL Query to fetch only accounts which has selected subscription. I tried this Query but failed SELECT * FROM account a JOIN s IN…
SOF User
  • 7,590
  • 22
  • 75
  • 121
7
votes
1 answer

Reading from RavenDb immediately after writing to it returns inconsistent data

I have a reconciliation process where by a background thread that periodically retrieves a list of object ids from an external webservice and attempts to add the missing entities to an embedded RavenDb database. The loop that performs this process…
ambog36
  • 301
  • 1
  • 2
  • 13
7
votes
2 answers

MongoDB: storage & when to use relationships

I'm new to MongoDB, so please bear with me. I have 2 questions: First, take the following: // add a record $obj = array( "title" => "Calvin and Hobbes", "author" => "Bill Watterson" ); Does MongoDB store "title" and "author" as text for every…
IamIC
  • 17,747
  • 20
  • 91
  • 154
7
votes
2 answers

When developing web applications when would you use a Graph database versus a Document database?

I am developing a web-based application using Rails. I am debating between using a Graph Database, such as InfoGrid, or a Document Database, such as MongoDB. My application will need to store both small sets of data, such as a URL, and very large…
Misha M
  • 10,979
  • 17
  • 53
  • 65
7
votes
2 answers

How would you implement a revision control system for your models in your prefered db paradigm?

I found out that RCS for models is an interesting problem to solve in the context of data persistence. They are several solution using the django ORM to achieve this django-reversion and AuditTrail each of which propose their own way to do it. Here…
amirouche
  • 7,682
  • 6
  • 40
  • 94
7
votes
2 answers

Using both graph db and document db

I'm considering a setup where I have entities stored both in a document db (e.g. CouchDB) and a graph db (e.g. Neo4j). The rationale is storing each entity information (data, blobs, values, complex internal structure) in the document db while…
Ran Biron
  • 6,317
  • 5
  • 37
  • 67
6
votes
1 answer

Best Data Store for huge data with large number of reads and writes

I need to store around 100 millions of records on the database. Around 60-70% of them will be deleted daily and same amount of records are inserted daily. I feel a document database like Hbase, Big Table would fit in this. There are many other data…
sravan_kumar
  • 1,129
  • 1
  • 13
  • 25
6
votes
1 answer

Get all fields from a DocumentDB joined query

I have a DocumentDB database in Azure which I access through the CosmosDB API. I'd like to get all the parent fields of a document with a simple query: SELECT p.id FROM parent p JOIN ch IN p.property1.child WHERE CONTAINS(UPPER(ch.name),…
Alpha75
  • 2,140
  • 1
  • 26
  • 49
6
votes
2 answers

How can I avoid duplicating data in a document database like RavenDB?

Given that document databases, such as RavenDB, are non-relational, how do you avoid duplicating data that multiple documents have in common? How do you maintain that data if it's okay to duplicate it?
John Nelson
  • 5,041
  • 6
  • 27
  • 34
6
votes
0 answers

Join multiple databases with CouchDB?

Tech being used: Node.js Nano CouchDB Disclaimer: I am very new to CouchDB. I am able to query views with Node.js and Nano just fine. I am looking for more of a conceptual solution then a syntax solution. Scenario: I am building a very basic web…
Phil
  • 10,948
  • 17
  • 69
  • 101
6
votes
2 answers

Scenario for Document vs Columnar DBs

NoSQL databases can be categorized as KV, Document, Columnar and Graph. I had been trying to figure out which NoSQL to use for different scenario, read a couple of blogs/articles and am a still confused. Lets say I want to store the Employee…
Praveen Sripati
  • 32,799
  • 16
  • 80
  • 117
1
2
3
…
15 16