Chapter 6 PostRelational Databases SQL and No SQLDatabases

Chapter 6 – Post-Relational Databases SQL- and No. SQL-Databases © Springer 2016, Meier A. , Kaufmann M. : SQL & No. SQL-Databases

Fig. 6. 1: Horizontal fragmentation of the EMPLOYEE and DEPARTMENT tables © Springer 2016, Meier A. , Kaufmann M. : SQL & No. SQL-Databases

Fig. 6. 2: Optimized query tree for a distributed join strategy © Springer 2016, Meier A. , Kaufmann M. : SQL & No. SQL-Databases

Fig. 6. 3: EMPLOYEE table with data type DATE © Springer 2016, Meier A. , Kaufmann M. : SQL & No. SQL-Databases

Fig. 6. 4: Except from a temporal table TEMP_EMPLOYEE © Springer 2016, Meier A. , Kaufmann M. : SQL & No. SQL-Databases

Fig. 6. 5: Data cube with different analysis dimensions © Springer 2016, Meier A. , Kaufmann M. : SQL & No. SQL-Databases

Fig. 6. 6: Star schema for a multi-dimensional database © Springer 2016, Meier A. , Kaufmann M. : SQL & No. SQL-Databases

Fig. 6. 7: Implementation of a star schema using the relational model © Springer 2016, Meier A. , Kaufmann M. : SQL & No. SQL-Databases

Fig. 6. 8: Data warehouse in the context of business intelligence processes © Springer 2016, Meier A. , Kaufmann M. : SQL & No. SQL-Databases

Fig. 6. 9: Query of a structured object with and without implicit join operator © Springer 2016, Meier A. , Kaufmann M. : SQL & No. SQL-Databases

Fig. 6. 10: BOOK_OBJECT table with attributes of the relation type © Springer 2016, Meier A. , Kaufmann M. : SQL & No. SQL-Databases

Fig. 6. 15: Classification matrix with the attributes Revenue and Loyalty © Springer 2016, Meier A. , Kaufmann M. : SQL & No. SQL-Databases

Fig. 6. 16: Fuzzy partitioning of domains with membership functions © Springer 2016, Meier A. , Kaufmann M. : SQL & No. SQL-Databases