Database Management Systems

  1. Data Warehousing and OLAP
    1. Data Warehousing Concepts
      1. Data Warehouse Definition
        1. Characteristics of Data Warehouses
          1. Subject-Oriented
            1. Integrated
              1. Time-Variant
                1. Non-Volatile
                2. Data Warehouse Architecture
                  1. Single-Tier Architecture
                    1. Two-Tier Architecture
                      1. Three-Tier Architecture
                    2. ETL Process
                      1. Extract Phase
                        1. Data Source Identification
                          1. Data Extraction Methods
                          2. Transform Phase
                            1. Data Cleaning
                              1. Data Integration
                                1. Data Transformation
                                2. Load Phase
                                  1. Initial Loading
                                    1. Incremental Loading
                                      1. Refresh Strategies
                                    2. Data Warehouse Schema Design
                                      1. Star Schema
                                        1. Fact Tables
                                          1. Dimension Tables
                                            1. Schema Characteristics
                                            2. Snowflake Schema
                                              1. Normalized Dimensions
                                                1. Schema Characteristics
                                                2. Galaxy Schema
                                                3. Online Analytical Processing
                                                  1. OLAP Concepts
                                                    1. OLAP Operations
                                                      1. Roll-Up Operation
                                                        1. Drill-Down Operation
                                                          1. Slice Operation
                                                            1. Dice Operation
                                                              1. Pivot Operation
                                                              2. OLAP Implementation
                                                                1. ROLAP
                                                                  1. MOLAP
                                                                    1. HOLAP
                                                                  2. Data Mining Integration
                                                                    1. Data Mining Process
                                                                      1. Knowledge Discovery
                                                                        1. Pattern Recognition

                                                                      Previous

                                                                      12. NoSQL Database Systems

                                                                      Go to top

                                                                      Next

                                                                      14. Emerging Database Technologies