Questions tagged [document-oriented]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
27
votes
2answers
17k views

Using MongoDB and PostgreSQL together

My current project is essentially a run of the mill document management system. That said, there are some wrinkles (surprise, surprise). While some of the wrinkles are fairly specific to the project,...
18
votes
2answers
1k views

CouchDB vs MongoDB [closed]

Evaluating document-oriented storage, what are the pros and cons of CouchDB vs MongoDB?
12
votes
2answers
790 views

What are some good resources for learning about document oriented databases? [closed]

I'm interested in learning about NoSQL databases and I decided to start with document oriented databases. What are some good resources to learn the concepts and good design of this type of database?
5
votes
3answers
1k views

Replace relational database with “poor” design in software product with non-relational DB? [closed]

Edit: This question is about how to deal with many issues that arose from a overall system design, which made parts of the system deviate from common standards. For example, managing everything in the ...
4
votes
1answer
217 views

Numerical data with lots of NULLs: 6NF or document database?

I have a source of numerical data mostly comprised of sensor readings, physical quantities and flags. Each associated with a datetime. | id | timetag | sensor1 | sensor2 ...
3
votes
1answer
86 views

Do any document databases (noSQL) allow you to do cross database joins? [closed]

I am currently looking at MongoDB and ArangoDB as the database for our web application, but neither appear to support cross-database joins, does anyone know if there is such a document database that ...
2
votes
1answer
94 views

How to handle “or” possibilities in MongoDB

I'm new to MongoDB and by no means an expert in DB design in general. This feels like a really basic question that's probably been answered a million times, but I'm having a surprisingly hard time ...
2
votes
1answer
368 views

Switching to NoSQL for native JSON use?

I am rather comfortable writing concrete schemas with explicit primary keys, foreign keys, indexes, views and stored procedures. For queuing I use a NoSQL solution called: Redis. Recently I heard a ...
2
votes
0answers
474 views

OrientDB distributed architecture

Technically this question could relate to any database that performs in a similar distribute manner but given that I am specifically working with OrientDB I thought the question should be target as ...
1
vote
2answers
694 views

SQL Server vs SOLR (Or any document db)

I have my "customer" data in a normalized sql server database. Getting out the customer data in my app is taking too long. This is because I have to go to 10+ tables to get all the data I need. My ...
1
vote
1answer
231 views

Are most of the NoSQL databases key/value stores technically? [closed]

This video distinguishes between three (main) types of NoSQL databases: Key/Value store Tabular Document oriented Do these types differ in how they technically store their data or can they be ...
1
vote
1answer
140 views

The Logical Type of The Document in CouchBase

How should the logical type of a document get specified in CouchBase? Using a field for the type? Or employing separators in keys like product::app::123id? Currently I'm putting a document type, ...
1
vote
1answer
158 views

Document Design and Document IDs

I was wondering about specifying id's in CouchDB. For example: House - Rooms -- Kitchen -- Living room -- ... - Windows - Doors There are some documents, like "House", where there is and will only ...
1
vote
0answers
94 views

How do read queries against Postgres's JSONB type compare to Couchbase?

I'm working on a small project which would involve running queries against deeply-nested (up to 5 layers) keys in dictionaries. This would be specifically a read-heavy environment, with only one large ...
1
vote
0answers
99 views

What data store should I use for storing and querying a billion small (~2kb) JSON documents?

I'm trying to figure out which database to use for storing and querying on ~1 billion JSON documents about the size of 2KB each. About 2 TB of data. Nature of JSON documents: 3 types of documents (...
1
vote
0answers
51 views

Which Azure Storage / Database Technology to make use of for large scale logging

I am looking into making use of Azure hosting services in order to develop a logging service for our company. Azure has a number of storage options available (I have listed links below). However I am ...
1
vote
0answers
180 views

Can XML columns in Oracle/MS SQL Server replace document oriented databases to some extent?

Just a strategic question: I am currently working with frequently changing data schemas and it takes a lot to keep track of versions and specific content. I do, however, have a classic OLTP ...
0
votes
1answer
68 views

Many-to-many database [closed]

I am thinking about making a music database. Something where you can search by artist, album or song. This seems to be a Many-to-many model, as an album can have multiple songs, and the same song can ...
0
votes
2answers
2k views

No suitable driver found Orientdb jdbc driver

I have some problems with Orientdb driver for jdbc. i´m using Netbeans, i have include the library JDBC+OrientDB libraries (orientdb-jdbc-2.0.8-all.jar) in the directory and in netbeans, i have also ...
0
votes
1answer
270 views

RavenDB - Disaster Recovery on a Replicated Instance

EDIT: I'm encountering precisely the same issue. Assume that I have two RavenDB instances. Instance 1 contains one document: users/1. Instance 2 contains three documents: users/2, users/3, and users/...
0
votes
0answers
22 views

Can MongoDB support TTL per document, not per index?

I am trying to do a Redis-like collection in MongoDB. I need a collection of documents that expire and are automatically deleted after a certain time. I can use TTL Indexes but with this, every ...
0
votes
0answers
37 views

Do same PostgreSQL Limits apply for PostgreSQL 11 version?

I'm writing a research paper in which I've been using implementation of PostgreSQL, version 11.8 and what bothers me it's Docs about DB Limitations (at https://www.postgresql.org/docs/12/limits.html) ...
0
votes
1answer
551 views

Local Cosmos DB service unavailable

I've installed the azure cosmos db in my local machine but is not loading the explorer pages as shown below: Explicit error: Failed to get authorization headers for offers: {"readyState":4,"...
0
votes
1answer
71 views

Is storing redundant data part of the (CouchDB) self-contained data concept?

The CouchDB concept speaks about self-contained documents. In other words: ALL related data is stored in a single concept, instead of splitting them in multiple tables and reference each other using ...
0
votes
0answers
56 views

Is there a Document based nosql with deep json update?

I'm currently looking in a Document based nosql (possibly with sharding/replication/NSPOF) database that allow (is specialized in) deep json document update. By that I mean that I would like a nosql ...
-1
votes
1answer
598 views

document and edges in orientdb

I was playing around with OrientDB lately and was create some classes and edges. I was able to create edges between documents, is this something that is expected from OrientDB when edges are ...