Table of Contents

Section I: Data Development Methodologies, Definitions, and Strategy 1. Database Development Methodology and Organization 2. A Review of Database System Terminology 3. Developing a Global Information Vision 4. An Approach for Establishing Enterprise Data Standards 5. Completeness, Context, and Proportion: Shaping Data Design to the Business 6. An Enterprise Decision Framework for System Selection the Importance of Data Architecture in a Client/Server Environment 7. Section II: Data Models and Modeling Techniques 8. Making Data Models Readable 9. Component Design for Relational Databases 10. Practices in Enterprise Data Modeling 11. Integrating Process and Data Models in a Horizontal Organization 12. Object-Oriented Aspects of Windows Component-Based Software 13. Data Warehouse Design: Issues in Dimensional Data Modeling Section III: Data Integrity and Quality Programming Data Constraints Using Microsoft SQL Server 14. Referential Integrity for Database Design 15. AR: An Expanded Version of Referential Integrity for Data Base 16. Data Quality: An Architectural Solution 17. Section IV: Data Administration, Security and Operations 18. Managing Database Backup and Recovery 19. Managing NT Domains for Enterprise Architecture 20. DBMS Recovery Procedures 21. Change Management Strategies for Data Administration 22. Database Security Controls 23. E-Mail Security and Privacy 24. Security Models for Object-Oriented Data Bases 25. Security Management for the World Wide Web 26. Section V: Data Migration and Conversion 27. A Practical Example of Data Conversion 28. Legacy Database Conversion 29. Data Conversion: Doing it Right the First Time 30. Migrating Files to Relational Data Bases Section VI: Database Servers and Universal Servers 31. Creating SQL Server Tables Using DDL Scripts 32. Microsoft SQL Server: Key Transact-SQL Features 33. Selecting Universal Data Server Technology 34. Managing Complex Data Types: Middleware, Universal Data, Data Servers, and Object-Oriented Data Servers