Updating relational databases through views single dating south

As we see in this illustration, the relational model conforms to a schema with a specified number of fields which represent a specific purpose and data type.

The equivalent document-based model has an individual document per beer; each document contains the same types of information for a specific beer.

The document-oriented approach provides several upsides compared to the traditional RDBMS model.

The problem with this approach is that when you change information across tables, you need to lock those tables simultaneously to ensure information changes across the table consistently.

Because you also spread information across a rigid structure, it makes it more difficult to change the structure during production, and it is also difficult to distribute the data across multiple servers.

The schema is the structure described in a formal language supported by the database and provides a blueprint for the tables in a database and the relationships between tables of data.

Within a table, you need to define constraints in terms of rows and named columns as well as the type of data that can be stored in each column.

In a document-oriented model, data objects are stored as documents; each document stores your data and enables you to update the data or delete it.

Instead of columns with names and data types, we describe the data in the document, and provide the value for that description.

Since records are contained within entire documents, it makes it easier to move, or replicate an entire object to another server.

The relational database has been the foundation of enterprise applications for decades, and since My SQL’s release in 1995 it has been a popular and inexpensive option, especially as part of the ubiquitous LAMP stack underpinning early web applications.

Mongo DB stores data as documents in a binary representation called BSON (Binary JSON).

Related information is stored together for fast query access through the Mongo DB query language.

In contrast, a document-oriented database contains , which are records that describe the data in the document, as well as the actual data.

Tags: , ,