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
3
votes
1 answer

Is Powershell command available for retrieving Azure Document Database account key?

I am creating DocumentDB Account using ARM Template. Now want to get the Account Key once DocumentDB Account is created. I know we can get these details from https://portal.azure.com but I want a command which will give context ( ex. with…
Anil Patel
  • 71
  • 1
  • 10
3
votes
5 answers

SELECT with multiple values in DocumentDB

I have an Employees collection and I want to retrieve full documents of 10 employees whose ID's I'd like to send to my SQL SELECT. How do I do that? To further clarify, I have 10 EmployeeId's and I want pull these employees' information from my…
Sam
  • 26,817
  • 58
  • 206
  • 383
3
votes
2 answers

Many-to-many in document DBs

I am just starting out with MongoDB (Late to the party, I know...) I am still trying to get 10+ years of relational DBing out of my head when thinking of a document design. Lets say I have many users using many apps. Any user can use several apps,…
Elad Lachmi
  • 10,406
  • 13
  • 71
  • 133
3
votes
4 answers

Open Source .Net Object Database or Document Database for use in Hosted environment

I am looking at creating a web site and I want to try and learn either a Object Database or a Document Database. I am going to be using a hosting provider so I won't be able to install any software. I am unable to purchase any licensing so I need…
runxc1 Bret Ferrier
  • 8,096
  • 14
  • 61
  • 100
3
votes
1 answer

Designing data structure

I'm writing a hobby web application. It currently sends JSON objects to the client, which in turn creates them into blog posts. Currently the JSON object looks like this: {"id1": {"title": "title1", "content": "content1", ...}, "id2": {...},…
Mirzhan Irkegulov
  • 17,660
  • 12
  • 105
  • 166
3
votes
2 answers

Could one use Postgres as a document database?

Let's say we're building a DB for storing analytics from web sites or mobile apps. Transactions aren't important (it's ok to drop things) and only slow things down, supporting as many concurrent calls is, consistency can be eventual, and a part of…
3
votes
1 answer

Document database to store html content

I have been working on a project where user can create simple templates and develop his website pages.He can save them and also put it over the internet once completed.Now my problem When the user is working on his template he can save his copy of…
KillABug
  • 1,414
  • 6
  • 34
  • 69
2
votes
3 answers

Should we denormalize data in a Document to improve performance? (Document Database)

In my system Employees log Requests and Requests are about an Equipment. In order to avoid loading the Employee and Equipment documents each time I need to display a Request I want to denormalize the employee name and the equipment inventory…
Sylvain
  • 19,099
  • 23
  • 96
  • 145
2
votes
1 answer

Using polymorphic queries over interfaces in RavenDB

I'm interested in switching over our application (or parts of it) to use RavenDB from SQL server with NHibernate. The key feature that I can't seem to find in Raven is the usage of interfaces for queries eg: ISearchable { string Name…
Stu
  • 2,426
  • 2
  • 26
  • 42
2
votes
1 answer

document db - denormalized references - best practice

Yo - this is not a ravendb issue per se - it's another design question pertaining to document dbs in general. So I've been using DenormalizedReference quite a bit and it has just occured to me that in a lot of places this makes DDD rather hard. So,…
user156888
2
votes
1 answer

How does MongoDB cursor behave when the collection is being changed?

Suppose I'm using the cursor to iterate a subset of the documents, ordered by some field let's say. What happens if while iterating, a new document is being inserted or a current one is being deleted? Would that affect the cursor or does it MongoDB…
IsaacLevon
  • 2,260
  • 4
  • 41
  • 83
2
votes
2 answers

How do document databases deal with changing relationships between objects (or do they at all)?

Say, at the beginning of a project, I want to store a collection of Companies, and within each company, a collection of Employees. Since I'm using a document database (such as MongoDB), my structure might look something like this: + Customers[] …
Jonathan
  • 32,202
  • 38
  • 137
  • 208
2
votes
1 answer

How to partition my User Permission Data using CosmosDB

I have decided to use CosmosDB in order to store my users permissions data. Our permissions are very dynamic in nature and thus a non relational database makes sense. For a permission database, it would be very heavy on the query side and low on…
2
votes
2 answers

How could I filter by date and location availability in firestore?

In my Firebase project I need to query all users who are available on a certain date at a certain city and sort by some other criteria. Since we can't use multiple "array-contains" operations in one query, I tried the well known "map-trick" in…
2
votes
0 answers

2 phase commit implementation

I'm trying to implement a 2-phase commit over a document database which supports only single-phase commit using transaction info on the inserted data. I understand the theory behind 2-phase commit, but in practice there are a few obstacles. Let's…
Metheny
  • 1,112
  • 1
  • 11
  • 23