Normalized referencing data model
• Transformation of Schema from Relational Database (RDB) to Document Store data model
• Transformation of Schema from Relational Database (RDB) to Graph data model
3
Transformation of Schema from 1-to-M Relational Data Model to Column Family Data Model
4
Transformation of Schema from 1-to-M Relational Data Model to Embedded Document Store Data Model
Transformation of Schema from 1-to-M Relational Data Model to Embedded Document Store data model
• Department Collection // if Employee is embedded in Department• {
• Dept_ID:
• Dept_Name:
• Dept_Location:
• Employee Collection
• {
• Emp_ID:
• Emp_Name:
• }
8 |
---|
Transformation of Schema from M-to-N Relational Data Model to NoSQL Data Model
10
Transformation of Schema from M-to-N Relational Data Model to Column Family Data Model
• Order_Detail Collection {
• Order Collection {
• Order_Number:
• Order_Date:
• }
• Item Collection {
• Item_Number:
• Item_Name:
• }
• Order_Number: // link to Order Collection
• Item_Number: // link to Item Collection
• Quantity_Order:
• Quantity_Ship:
• } 12Transformation of Schema from Relational Data Model to Graph data model
13
Question Types
XXXXX, XXXXX, XXXXX, XXXXX, XXXXX, XXXXX, XXXXX, XXXXX, XXXXX 14
Question Types
• B) SHORT DISCUSSION (THEORY RELATED)
E.g. Briefly explain XXXXXXXXXXXXXXXXXX.
• “MINI CASE STATEMENT FOR BUSINESS SCENARIO” is given
The following attributes are required to store in your database
17
• Object-relational design, relational vs object-relational design
• An Overview of the Column-Family Data Model: Use Cases, Databases and Tables, Columns, Types, Key Spaces, Replication, Hashing
• An Overview of the Graph Data Model: Vertices, Edges, Association, Use Cases, Querying Graphs
18 |
---|