liveBook · Manning

Document database

As explained in Effective Data Analysis

A document database is a database that stores complex nested records, typically in document formats with flexible or dynamic structures.

A document database stores complex, nested records in formats such as JSON or XML. Its schemaless structure can change over time, making it suitable for semistructured information that does not fit neatly into tables. section 11.2.2 section 11.5

Use document databases when data has varied or evolving properties, such as:

Document databases often use NoSQL to query key-value pairs, so analysts may need a specialized query language. Nested JSON also requires transformation into tabular data for analysis, while changing structures require quality checks such as null-record and schema-change checks. section 11.2.2

Figure 11.7 An example of a document structure in JSON that may exist in a document database.
figure

A JSON example makes the nested document structure visible and clarifies why later tabular transformation may be necessary. section 11.2.2

How Effective Data Analysis covers it

How deep it goes
Explains flexible structure, query implications, tabular transformation, and quality checks without detailing database implementation internals.
Examples
Uses IoT records, multimedia properties, employment documents, application logs, and nested JSON structures as examples.
What you can do after
Evaluate when flexible document storage fits and anticipate querying, tabular transformation, and data-quality requirements.
How it connects
Connects document databases with relational databases, NoSQL, JSON, XML, data warehouses, ETL, and data quality checks.

Also explained in

Compare how 3 books explain document database →

Related concepts

This explainer was generated by Manning's knowledge graph from the text of Effective Data Analysis. The section links point to the parts of the book it draws on.