Correlation Database - Advantages and Disadvantages

Advantages and Disadvantages

For analytical data warehouse applications, a CDBMS has several advantages over alternative database structures. First, because the database engine itself indexes all data and auto-generates its own schema on the fly while loading, it can be implemented quickly and is easy to update. There is no need for physical pre-design and no need to ever restructure the database. Second, a CDBMS enables creation and execution of complex queries such as associative queries ("show everything that is related to x") that are difficult if not impossible to model in SQL. The primary advantage of the CDBMS is that it is optimized for executing ad hoc queries - queries not anticipated during the data warehouse design phase.

A CDBMS has two drawbacks in comparison to database alternatives. Unlike relational databases, which can be used in a wide variety of applications, a correlation database is designed specifically for analytical applications and does not provide transaction management features; it cannot be used for transactional processing. Second, because it indexes all data during the load process, the physical load speed of a CDBMS is slower than relational or column-oriented structures. However, because it eliminates the need for logical or physical pre-design, the overall "time to use" of a CDBMS is generally similar to or somewhat faster than alternative structures.

Read more about this topic:  Correlation Database

Other articles related to "advantages and disadvantages, disadvantages, advantage, advantages":

Learning By Teaching By Martin (LdL) - The LdL Approach - Advantages and Disadvantages
... They state the following advantages and disadvantages Advantages Student work is more motivated, efficient, active and intensive due to lowered inhibitions and an increased sense of purpose By eliminating the ... and moderation skills self-confidence Disadvantages The introduction of the method requires a lot of time ...
C-4 (explosive) - Characteristics and Uses - Advantages
... A major advantage of C4 is that it can easily be molded into any desired shape ... C4 can be pressed into gaps, cracks, holes and voids in buildings, bridges, equipment or machinery ...
Leather Currency - Advantages and Disadvantages
... Banknotes have a natural advantage over coins in that they are lighter to carry but are also less durable ... The different disadvantages between coins and banknotes imply that there may be an ongoing role for both forms of bearer money, each being used where its advantages outweigh its disadvantages ...
SQLJ Part 0 - Advantages and Disadvantages
... Some advantages of SQLJ over JDBC include SQLJ commands tend to be shorter than equivalent JDBC programs ... Disadvantages include SQLJ requires a preprocessing step ...

Famous quotes containing the word advantages:

    No advantages in this world are pure and unmixed.
    David Hume (1711–1776)