-
Notifications
You must be signed in to change notification settings - Fork 7
Data Modeling With NoSQL Databases
all1124 edited this page Oct 12, 2019
·
4 revisions
- SQL databases are primarily called as Relational Databases
- NoSQL database are primarily called as non-relational or distributed database
- SQL databases are table based databases
- NoSQL databases are document based, key-value pairs, graph databases or wide-column stores
- NoSQL data modeling is typically driven by application-specific access patterns, i.e. the types of queries to be supported
- Denormalization can be defined as the copying of the same data into multiple documents or tables in order to simplify/optimize query processing or to fit the user’s data into a particular data model
- All major genres of NoSQL provide soft schema capabilities in one way or another
- Soft schema allows one to form classes of entities with complex internal structures (nested entities) and to vary the structure of particular entities
- Joins are rarely supported in NoSQL
- Entries can be partitioned across multiple servers by just hashing the key
- Dimensionality Reduction is a technique that allows one to map multidimensional data to a Key-Value model or to other non-multidimensional models
- Index Table is a very straightforward technique that allows one to take advantage of indexes in stores that do not support indexes internally