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:

227 questions
5
votes
2 answers

RavenDB. How to load document with only 5 items from inner collection?

Here is a document in the store: { "Name": "Hibernating Rhinos", "Employees": [ { "Name": "Ayende" }, { "Name": "John" }, { "Name": "Bob" }, { "Name": "Tom" }, { "Name": "Lane" }, { "Name":…
Dmitry Schetnikovich
  • 1,692
  • 17
  • 25
5
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,007
  • 15
  • 62
  • 93
5
votes
1 answer

Saving data into multiple collections in DocumentDb

In DocumentDb, what is the best way and place to decouple data in order to save them in separate collections? So far, most of the examples of how to manage data with DocumentDb use simple objects but in real life, we hardly ever do. I just want to…
Sam
  • 19,814
  • 35
  • 141
  • 272
5
votes
1 answer

Need an efficient way to store/query json in a SQL database

I'm implementing a service where each user must have his own json/document database. Beyond letting the user to query json documents by example, the database must also support ACID transactions involving multiple documents, so I have discarded using…
Thiago de Arruda
  • 4,360
  • 5
  • 37
  • 66
4
votes
3 answers

CouchDB map/reduce by any document property at runtime?

I come from a SQL world where lookups are done by several object properties (published = TRUE or user_id = X) and there are no joins anywhere (because of the 1:1 cache layer). It seems that a document database would be a good fit for my data. I am…
Xeoncross
  • 50,836
  • 73
  • 238
  • 351
4
votes
1 answer

Multi-tentant model and nosql?

When doing multi-tenant applications using a RDMBS I use tenantId columns in each table to indicate which tenant a row belongs to. How would I do that in a DocumentDatabase? Let's take mongodb for instance. Is DBRef the way to go? Or am I stuck in…
jgauffin
  • 95,399
  • 41
  • 227
  • 352
4
votes
5 answers

Most efficient method for persisting complex types with variable schemas in SQL

What I'm doing I am creating an SQL table that will provide the back-end storage mechanism for complex-typed objects. I am trying to determine how to accomplish this with the best performance. I need to be able to query on each individual simple…
smartcaveman
  • 38,142
  • 26
  • 119
  • 203
4
votes
1 answer

Do any of the major document-oriented database systems compress keys within their JSON documents?

I would like to store a large number of JSON documents using a documented-oriented database, all with very similar schema (though not identical). One example document: { "firstName": "John", "lastName": "Smith", "age": 25, } Do any…
wodow
  • 2,807
  • 3
  • 25
  • 40
4
votes
3 answers

RavenDB ID for child documents

I like how cleanly an object is stored in ravenDB, but have a practical question for which I'm not sure of the best answer. Lets say i have a quote request: QuoteRequest.cs int Id; dateTime DateCreated; List Quotes; Quote.cs int…
ChickenMilkBomb
  • 937
  • 5
  • 18
4
votes
1 answer

Best Precision for String in DocumentDB Indexing Policies

I'm writing indexing policies for my collection, and trying to figure out what is the right "Precision" for String in Hash Index, i.e. collection.IndexingPolicy.IncludedPaths.Add( new IncludedPath { Path = "/customId/?", Indexes = new…
Vej
  • 378
  • 1
  • 6
  • 24
4
votes
1 answer

Spark Sql, unable to query multiple possible values in a array

I have the data schema of LinkeIn account as shown below. I need to query the skills which is in the for of array, where array may contains either JAVA OR java OR Java or JAVA developer OR Java developer. Dataset sqlDF = spark.sql("SELECT *…
AshisParajuli
  • 639
  • 6
  • 13
4
votes
3 answers

Business Intelligence and NoSQL

For a new project I'm working I have the need to store some data into a database. The type of data and access model fits well with the NoSQL model and document databases. We are considering things like MongoDB but are still yet undecided. One of the…
Chris Dail
  • 24,255
  • 9
  • 61
  • 73
4
votes
2 answers

How to model structures such as family trees in document databases

I have been looking into document databases, specifically RavenDb, and all the examples are clear and understandable. I just can't find any example where we do not know beforehand how many levels a given structure has. As an example how would you…
Rune Hammerskov
  • 85
  • 5
4
votes
1 answer

Fetch data from linked class in orientdb

Am new to OrientDB, i want to fetch data from class B which depends on the value of class A info class A --------------------------------+-------------+-------------------------------+- NAME | TYPE | LINKED…
Shri
  • 459
  • 3
  • 17
4
votes
3 answers

Are there any small scale, durable document/object databases?

I have a few .Net projects that would benefit from using a document/object database opposed to a relational one. I think that db4o would be a good choice, but we're not sure how much the cost is. I'd love to use MongoDB but it's design isn't for…
Joe Doyle
  • 6,223
  • 3
  • 38
  • 44
1 2
3
…
15 16