Physical database design for SYBASE SQL Server
Author(s)
Bibliographic Information
Physical database design for SYBASE SQL Server
Prentice Hall PTR, c1995
Available at / 1 libraries
-
No Libraries matched.
- Remove all filters.
Note
Includes index
Description and Table of Contents
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.
Table of Contents
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.
by "Nielsen BookData"