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
6
votes
2 answers

RavenDB Connecting To Embedded Document Store During Unit Test

Edit Turns out I am storing the document correctly so the beginning part of this question is not correct, probably due to my inexperience with RavenDB. However I still have the question of being able to open the RavenDB Management Studio while…
Chad Wilkin
  • 311
  • 1
  • 5
  • 11
5
votes
1 answer

How to model "reference data" in a Document Database model?

I’m creating a document model of my entities to store in a Document Database (RavenDB). The domain I’m modeling revolves around Incidents. An incident has a source, a priority, a category, a level of impact and many other classification attributes.…
Sylvain
  • 19,099
  • 23
  • 96
  • 145
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,752
  • 17
  • 26
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
  • 26,817
  • 58
  • 206
  • 383
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 Padilha
  • 4,590
  • 5
  • 44
  • 69
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
  • 55,620
  • 80
  • 262
  • 364
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
  • 99,844
  • 45
  • 235
  • 372
4
votes
1 answer

Does Cosmos DB support cross partition transactions?

I'd like to move a document to another partition by changing the partition key. I have read somewhere that the document would have to be deleted first and a new one with the new partition key would have to be created. If that's the case, can this…
user246392
  • 2,661
  • 11
  • 54
  • 96
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
  • 41,281
  • 29
  • 127
  • 212
4
votes
2 answers

Azure documentDB - Resource with specified id or name already exists

In Azure Cosmo DocumentDB in my application, Am getting following error 2018-03-27 14:42:057 ERROR c.h.m.s.CosmosDBFruiteService - Could not add Fruites to Customer Reference : 11416e34-3620-45a4-b3be-b845bbf41762 Message: {"Errors":["Resource…
user3647764
  • 41
  • 1
  • 3
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
  • 3,871
  • 5
  • 33
  • 45
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
  • 939
  • 6
  • 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
  • 390
  • 1
  • 7
  • 28
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
  • 669
  • 6
  • 14
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
  • 25,715
  • 9
  • 65
  • 74
1 2
3
…
15 16