You are previewing Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction.
O'Reilly logo
Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction

Book Description

Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction covers the process of analyzing data to extract, transform, load, and manage the essential components of a data warehousing system. A defining collection of field discoveries, this title provides industry solutions for those involved in this distinct research community.

Table of Contents

  1. Copyright
  2. Editorial Advisory Board
  3. List of Reviewers
  4. Preface
  5. Conceptual Design and Ontology–Based Integration
    1. From User Requirements to Conceptual Design in Data Warehouse Design A Survey
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. REQUIREMENT ANALYSIS TECHNIQUES
      5. CONCEPTUAL MODELS
      6. SOLUTIONS AND RECOMMENDATIONS
      7. FUTURE TRENDS
      8. CONCLUSION
      9. REFERENCES
      10. KEY TERMS AND DEFINITIONS
    2. Data Extraction, Transformation and Integration Guided by an Ontology
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. THE PICSEL3 DATA EXTRACTION, TRANSFORMATION AND INTEGRATION APPROACH
      5. FUTURE RESEARCH DIRECTIONS
      6. CONCLUSION
      7. REFERENCES
      8. ADDITIONAL READINGS
      9. KEY TERMS AND DEFINITIONS
      10. ENDNOTES
    3. X–WACoDa: An XML–Based Approach for Warehousing and Analyzing Complex Data
      1. ABSTRACT
      2. INTRODUCTION
      3. RELATED WORK
      4. XML WAREHOUSING AND ANALYSIS METHODOLOGY
      5. MODELING XML DATA WAREHOUSES
      6. SOFTWARE PLATFORM
      7. CONCLUSION AND PERSPECTIVES
      8. REFERENCES
      9. KEY TERMS AND DEFINITIONS
      10. ENDNOTES
    4. Designing Data Marts from XML and Relational Data Sources
      1. ABSTRACT
      2. INTRODUCTION
      3. CURRENT DATA WAREHOUSE DESIGN APPROACHES
      4. DATA MART DESIGN FOR RELATIONAL AND XML SOURCES
      5. DATA SOURCE PRETREATMENT
      6. RELATION CLASSIFICATION
      7. DM SCHEMA CONSTRUCTION
      8. CASE TOOLSET
      9. CONCLUSION
      10. REFERENCES
      11. KEY TERMS AND DEFINITIONS
    5. Ontology–Based Integration of Heterogeneous, Incomplete and Imprecise Data Dedicated to a Decision Support System for Food Safety
      1. ABSTRACT
      2. INTRODUCTION
      3. THE ONTOLOGY-BASED DATA INTEGRATION SYSTEM
      4. BACKGROUND
      5. FUTURE RESEARCH DIRECTIONS
      6. CONCLUSION
      7. REFERENCES
    6. On Modeling and Analysis of Multidimensional Geographic Databases
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. SPATIO-MULTIDIMENSIONAL DATABASES: MODELS AND TOOLS
      5. FUTURE RESEARCH DIRECTIONS
      6. CONCLUSION
      7. REFERENCES
      8. KEY TERMS AND DEFINITIONS
  6. Physical Design and Self Turning
    1. View Selection and Materialization
      1. ABSTRACT
      2. INTRODUCTION
      3. PRELIMINARIES
      4. VIEW SELECTION PROBLEM
      5. VIEW SELECTION STRATEGY
      6. OVERVIEW OF THE VIEW SELECTION ALGORITHMS
      7. IMPLEMENTATION
      8. RELATED WORK
      9. FUTURE TRENDS
      10. CONCLUSION AND FUTURE WORK
      11. REFERENCES
      12. KEY TERMS AND DEFINITIONS
      13. ENDNOTES
    2. ChunkSim: A Tool and Analysis of Performance and Availability Balancing
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. CHUNK-WISE ON-DEMAND QUERY PROCESSING
      5. CHUNKSIM PERFORMANCE AVAILABILITY ANALYSIS
      6. USING CHUNKSIM TO ANALYZE PERFORMANCE AND AVAILABILITY
      7. CONCLUSIONS AND FUTURE WORK
      8. REFERENCES
    3. QoS–Oriented Grid–Enabled Data Warehouses
      1. ABSTRACT
      2. INTRODUCTION
      3. DATA GRIDS AND GRID-ENABLED DATABASES
      4. THE DISTRIBUTED QOS-ORIENTED WAREHOUSE
      5. EVALUATING IF A SLO CAN BE ACHIEVED
      6. LOCAL SCHEDULERS AND SERVICE LEVEL AGREEMENTS
      7. INTER-SITE QOS-ORIENTED DYNAMIC REPLICATION
      8. LOCAL CACHING AND INTRA-SITE REPLICA CANDIDATES
      9. EXPERIMENTAL EVALUATION
      10. CONCLUSION
      11. REFERENCES
      12. KEY TERMS AND DEFINITIONS
  7. Evolution and Maintainance Management
    1. Data Warehouse Maintenance, Evolution and Versioning
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND: THE DATA WAREHOUSE MAINTENANCE PROBLEM
      4. THE COMET TEMPORAL DATA WAREHOUSE
      5. OTHER APPROACHES ADDRESSING THE MAINTENANCE PROBLEM
      6. FUTURE TRENDS
      7. CONCLUSION
      8. REFERENCES
    2. Construction and Maintenance of Heterogeneous Data Warehouses
      1. ABSTRACT
      2. INTRODUCTION
      3. HETEROGENEOUS DATA INTEGRATION: A FORMAL APPROACH
      4. A META-SCHEMA FOR TWO POSSIBLE PHYSICAL ARCHITECTURES
      5. INCREMENTAL MAINTENANCE OF DATA AND AGGREGATES
      6. CONCLUSION
      7. REFERENCES
  8. Exploitation of Data Warehouse
    1. On Querying Data and Metadata in Multiversion Data Warehouse *
      1. ABSTRACT
      2. INTRODUCTION
      3. MULTIVERSION DATA WAREHOUSE
      4. QUERYING THE CONTENT OF MULTIVERSION DATA WAREHOUSE
      5. QUERYING METADATA IN MULTIVERSION DATA WAREHOUSE
      6. PROTOTYPE IMPLEMENTATION OF MVDWQL
      7. SUMMARY
      8. REFERENCES
      9. ENDNOTES
    2. Ontology Query Languages for Ontology–Based Databases A Survey
      1. ABSTRACT
      2. INTRODUCTION
      3. DOMAIN ONTOLOGIES AND THEIR APPLICATION TO DATABASE
      4. REQUIREMENTS FOR AN EXPLOITATION LANGUAGE OF OBDB
      5. ANALYSIS OF SEMANTIC WEB ONTOLOGY QUERY LANGUAGES
      6. ANALYSIS OF DATABASE-ORIENTED ONTOLOGY QUERY LANGUAGES
      7. CONCLUSION
      8. REFERENCES
      9. KEY TERMS AND DEFINITIONS
      10. ENDNOTES
    3. Ontology–Based Database Approach for Handling Preferences
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. ONTOLOGY-BASED DATABASE WITH PREFERENCES
      5. IMPLEMENTING THE MODEL: THE HOLLIDAY BOOKING CASE STUDY
      6. CONCLUSION AND FUTURE WORK
      7. REFERENCES
      8. KEY TERMS AND DEFINITIONS
    4. Security in Data Warehouses
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. SCIENTIFIC CONCEPTS
      5. APPLICATIONS
      6. FUTURE TRENDS AND OUTLOOK
      7. REFERENCES
  9. Compilation of References
  10. About the Contributors
  11. Index