Physical Database Design for Sybase SQL Server
Published on 1. September 1994
Book
Hardback
256 pages
978-0-13-161523-6 (ISBN)
Description
This is the first in a series of practical guidebooks - known as the Sybase Method Set - for database developers who are involved in designing and implementing client/server applications in the Sybase environment. Written by Sybase consulting engineers - who combine detailed knowledge of SQL Server with a real-world understanding of the issues involved in designing and implementing client/server solutions - it takes readers step-by-step from the logical-design stage to an optimized physical design for a single-server SQL Server database.
More details
Language
English
Place of publication
Upper Saddle River
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 240 mm
Width: 180 mm
Thickness: 15 mm
Weight
535 gr
ISBN-13
978-0-13-161523-6 (9780131615236)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Content
Introduction. 1. Defining Tables and Columns. 2. Defining Keys. 3. Identifying Critical Transactions. 4. Adding Redundant Columns. 5. Adding Derived Columns. 6. Collapsing Tables. 7. Splitting Tables. 8. Handling Supertypes and Subtypes. 9. Duplicating Parts of Tables. 10. Adding Tables for Derived Data. 11. Handling Vector Data. 12. Generating Sequence Numbers. 13. Specifying Indexes. 14. Maintaining Row Uniqueness. 15. Handling Domain Restrictions. 16. Handling Referential Integrity. 17. Maintaining Derived and Redundant Data. 18. Handling Complex Integrity Constraints. 19. Controlling Access to Data. 20. Managing Object Sizes. 21. Recommending Object Placement. Appendix A: Required Inputs to Physical Database Design. Appendix B: Physical Database Design Deliverables. Appendix C: Glossary.