You are previewing Selected Readings on Database Technologies and Applications.
O'Reilly logo
Selected Readings on Database Technologies and Applications

Book Description

Selected Readings on Database Technologies and Applications supplements course instruction and student research with quality articles focused on key issues concerning the development, design, and analysis of databases. Containing over 30 chapters from authors across the globe, these selected depict the most relevant and important areas of classroom discussion.

Table of Contents

  1. Copyright
  2. Prologue
  3. REFERENCES
  4. About the Editor
  5. Fundamental Concepts and Theories
    1. Conceptual Modeling Solutions for the Data Warehouse
      1. ABSTRACT
      2. INTRODUCTION
      3. RELATED LITERATURE
      4. THE DIMENSIONAL FACT MODEL: BASIC MODELING
      5. THE DIMENSIONAL FACT MODEL: ADVANCED MODELING
      6. APPROACHES TO CONCEPTUAL DESIGN
      7. OPEN ISSUES
      8. CONCLUSION
    2. REFERENCES
      1. ENDNOTE
    3. Databases Modeling of Engineering Information
      1. ABSTRACT
      2. INTRODUCTION
      3. NEEDS FOR ENGINEERING INFORMATION MODELING
      4. CURRENT DATABASE MODELS
      5. CONSTRUCTIONS OF DATABASE MODELS
      6. CONCLUSION
    4. REFERENCES
    5. An Overview of Learning Object Repositories
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. LOR'S REVIEW
      5. DISCUSSION AND FUTURE TRENDS
      6. CONCLUSION
    6. REFERENCES
      1. APPENDIX: RELATED WEB SITES
    7. Discovering Quality Knowledge from Relational Databases
      1. ABSTRACT
      2. INTRODUCTION
      3. KNOWLEDGE DISCOVERY PROCESS
      4. DATA WAREHOUSES
      5. INCORRECT KNOWLEDGE DISCOVERY
      6. USING HISTORICAL DATA FOR KNOWLEDGE DISCOVERY
      7. CONCLUSION AND FUTURE DIRECTION
    8. REFERENCES
  6. Development and Design Methodologies
    1. Business Data Warehouse: The Case of Wal-Mart
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. MAIN THRUST
      5. FUTURE TRENDS
      6. CONCLUSION
    2. REFERENCES
    3. A Database Project in a Small Company (or How the Real World Doesn't Always Follow the Book)
      1. EXECUTIVE SUMMARY
      2. ORGANIZATION BACKGROUND
      3. SETTING THE STAGE
      4. CASE DESCRIPTION
      5. CURRENT CHALLENGES / PROBLEMS FACING THE ORGANIZATION
    4. REFERENCES
      1. ENDNOTES
    5. Conceptual Modeling for XML: A Myth or a Reality
      1. ABSTRACT
      2. INTRODUCTION
      3. MOTIVATION
      4. MODELING ISSUES IN XML
      5. XML DTD
      6. RESEARCH SYSTEMS
      7. COMMERCIAL SYSTEMS
      8. DISCUSSION
      9. CONCLUSION
    6. REFERENCES
      1. ENDNOTE
    7. Designing Secure Data Warehouses
      1. ABSTRACT
      2. INTRODUCTION
      3. GENERAL DESCRIPTION OF METHODOLOGIES INCORPORATING SECURITY
      4. SUMMARY OF EACH METHODOLOGY'S CONTRIBUTIONS
      5. UML EXTENSION FOR SECURE MULTIDIMENSIONAL MODELING
      6. IMPLEMENTING SECURE DWS WITH OLS10G
      7. CONCLUSION
    8. REFERENCES
    9. Web Data Warehousing Convergence: From Schematic to Systematic
      1. ABSTRACT
      2. INTRODUCTION AND MOTIVATION
      3. A SURVEY OF EXISTING DATA WAREHOUSE INTEGRATION APPROACHES
      4. PROBLEM DEFINITION AND BACKGROUND
      5. INTEGRATION PROPOSED TECHNIQUE
      6. DISCUSSION AND ANALYSIS
      7. EXPERIMENTATIONS AND ANALYSIS RESULTS
      8. CONCLUSION AND FUTURE WORK
    10. REFERENCES
  7. Tools and Technologies
    1. Visual Query Languages, Representation Techniques, and Data Models
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. REPRESENTATION TECHNIQUES FOR VQLS
      5. DATA MODELS AND VQLS
      6. CONCLUSION
    2. REFERENCES
    3. Application of Decision Tree as a Data Mining Tool in a Manufacturing System
      1. ABSTRACT
      2. INTRODUCTION
      3. FINANCIAL DATA COLLECTED IN MANUFACTURING SYSTEMS
      4. METHODOLOGICAL FRAMEWORK
      5. CONCLUSION AND FUTURE DIRECTIONS
    4. REFERENCES
    5. A Scalable Middleware for Web Databases
      1. ABSTRACT
      2. INTRODUCTION
      3. RELATED WORK
      4. DESIGN PRINCIPLES OF WEBFINDIT
      5. WEBFINDIT ARCHITECTURE
      6. IMPLEMENTATION
      7. PERFORMANCE EVALUATION
      8. CONCLUSION AND FUTURE DIRECTIONS
      9. ACKNOWLEDGMENT
    6. REFERENCES
    7. A Formal Verification and Approach for Real-Time Databases
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. REAL-TIME DATABASE VERIFICATION AND VALIDATION METHOD
      5. FUTURE TRENDS
      6. CONCLUSION
    8. REFERENCES
    9. A Generalized Comparison of Open Source and Commercial Database Management Systems
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. MAIN THRUST OF THE CHAPTER
      5. FUTURE TRENDS
      6. CONCLUSION
    10. REFERENCES
      1. KEY TERMS
  8. Application and Utilization
    1. An Approach to Mining Crime Patterns
      1. ABSTRACT
      2. INTRODUCTION
      3. PREPROCESSING THE DATA
      4. PRESENTATION OF DERIVED GENERALIZATIONS
      5. ATTRIBUTE RELEVANCE ANALYSIS
      6. ASSOCIATION RULE MINING
      7. DECISION TREE ANALYSIS
      8. CLUSTERING
      9. CONCLUSION
      10. ACKNOWLEDGMENTS
    2. REFERENCES
    3. Bioinformatics Web Portals
      1. INTRODUCTION
      2. BACKGROUND
      3. REQUIREMENTS OF BIOINFORMATICS WEB PORTALS
      4. PROTEUS: A BIOINFORMATICS WEB PORTAL
      5. FUTURE TRENDS
      6. CONCLUSION
    4. REFERENCES
      1. KEY TERMS
      2. ENDNOTE
    5. An XML-Based Database for Knowledge Discovery: Definition and Implementation
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. MAIN THRUST OF THE CHAPTER
      5. DEALING WITH MULTIPLE FORMATS
      6. FUTURE TRENDS
      7. CONCLUSION
    6. REFERENCES
      1. APPENDIX
    7. Enhancing UML Models: A Domain Analysis Approach
      1. ABSTRACT
      2. INTRODUCTION
      3. LITERATURE REVIEW
      4. THE APPLICATION-BASED DOMAIN MODELING (ADOM) APPROACH
      5. THE EXPERIMENT
      6. SUMMARY AND FUTURE WORK
    8. REFERENCES
      1. APPENDIX A. THE ADOM-UML MODEL OF THE PCS DOMAIN
      2. APPENDIX B. THE ADOM-UML MODEL OF THE HCC APPLICATION
      3. APPENDIX C. THE ADOM-UML MODEL OF THE WLC APPLICATION
      4. APPENDIX D. THE EXPERIMENT QUESTIONS
    9. Seismological Data Warehousing and Mining: A Survey
      1. ABSTRACT
      2. INTRODUCTION
      3. THE ARCHITECTURE OF A SEISMIC DATA MANAGEMENT AND MINING SYSTEM
      4. QUERYING, OLAP ANALYSIS, AND MINING
      5. PROTOTYPE SYSTEMS AND TOOLS: A SURVEY
      6. GEODE
      7. CONCLUSION
    10. REFERENCES
  9. Critical Issues
    1. Business Information Integration from XML and Relational Databases Sources
      1. ABSTRACT
      2. INTRODUCTION
      3. RELATIONAL DATABASES AND XML
      4. COMPARATIVE STUDY OF THE ANALYZED TOOLS
      5. XDS: A NEW QUERY SYSTEM TO INTEGRATE AND OBTAIN XML DATA FROM RELATIONAL AND XML SOURCES
      6. FUTURE TRENDS
      7. CONCLUSION
    2. REFERENCES
    3. Security Threats in Web-Powered Databases and Web Portals
      1. INTRODUCTION
      2. BACKGROUND
      3. LEGALLY SENSITIVE WEB-POWERED DATABASES
      4. THREATS
      5. FUTURE TRENDS
      6. CONCLUSION
    4. REFERENCES
      1. KEY TERMS
    5. Empowering the OLAP Technology to Support Complex Dimension Hierarchies
      1. ABSTRACT
      2. INTRODUCTION
      3. TERMINOLOGY AND BASIC CONCEPTS
      4. OVERVIEW OF DIMENSIONAL HIERARCHIES: A CASE STUDY
      5. FROM CONCEPTUAL TO LOGICAL DESIGN
      6. NAVIGATION FRAMEWORK
      7. CONCLUSION AND FUTURE WORK
    6. REFERENCES
    7. NetCube: Fast, Approximate Database Queries Using Bayesian Networks
      1. ABSTRACT
      2. INTRODUCTION
      3. DATACUBES: PRECOMPUTING ALL POSSIBLE AGGREGATE QUERIES
      4. RELATION BETWEEN BAYESIAN NETWORKS AND DATACUBES
      5. LEARNING BAYESIAN NETWORKS FROM DATA
      6. NETCUBE: IMPLEMENTING THE DATACUBE USING A BAYESIAN NETWORK
      7. CASE STUDIES
      8. SUMMARY
      9. ACKNOWLEDGMENT
    8. REFERENCES
      1. ENDNOTES
    9. Node Partitioned Data Warehouses: Experimental Evidence and Improvements
      1. ABSTRACT
      2. INTRODUCTION
      3. RELATED WORK
      4. BASIC PARTITIONING IN NPDW
      5. BASIC PROCESSING IN NPDW
      6. ANALYZING BASIC PARTITIONING IN NPDW
      7. BASIC PARTITIONING RESULTS AND ANALYSIS
      8. PARTITIONING AND JOIN PROCESSING
      9. RELEVANT COSTS IN NPDW
      10. PROPOSED MODIFICATIONS TO NPDW
      11. EXPERIMENTS WITH THE MODIFIED SCHEMA
      12. CONCLUSION
      13. ACKNOWLEDGMENT
    10. REFERENCES
  10. Emerging Trends
    1. Rule Discovery from Textual Data
      1. ABSTRACT
      2. INTRODUCTION
      3. FORMAT OF TEXTUAL DATA
      4. FUZZY DECISION TREE
      5. RULE DISCOVERY BASED ON A KEY CONCEPT DICTIONARY
      6. RULE DISCOVERY BASED ON A KEY PHRASE PATTERN DICTIONARY
      7. APPLICATION TASKS
      8. CONCLUSION
      9. FUTURE RESEARCH DIRECTIONS
    2. REFERENCES
      1. Additional Reading
    3. Action Research with Internet Database Tools
      1. LEARNING OBJECTIVES
      2. ABSTRACT
      3. ACTION RESEARCH AND THE SCORM
      4. INSTRUCTIONAL ARTIFACTS
      5. STUDENT- AND TEACHER-MADE ARTIFACTS
      6. KINDS OF ARTIFACTS
      7. THE MULTI-PURPOSE WEB SITE FRAME AS AN INSTRUCTIONAL ARTIFACT
      8. LEARNING RESOURCES
      9. LEARNING OBJECTS
      10. INSTRUCTIONAL DEVICES
    4. REFERENCES
    5. Database High Availability: An Extended Survey
      1. ABSTRACT
      2. INTRODUCTION
      3. HIGH AVAILABILITY OVERVIEW
      4. HIGH AVAILABILITY ENVIRONMENT
      5. STRATEGIES FOR DATABASE AVAILABILITY
      6. STRATEGIES FOR DATABASE AVAILABILITY
      7. PERFORMANCE IMPACT ON AVAILABILITY
      8. DATABASE AVAILABILITY SOLUTIONS AVAILABLE FROM DBMS VENDORS
      9. AVAILABILITY BENCHMARKING METHODOLOGY
      10. CONCLUSION
    6. REFERENCES
  11. Index