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
  Aomori
  Iwate
  Miyagi
  Akita
  Yamagata
  Fukushima
  Ibaraki
  Tochigi
  Gunma
  Saitama
  Chiba
  Tokyo
  Kanagawa
  Niigata
  Toyama
  Ishikawa
  Fukui
  Yamanashi
  Nagano
  Gifu
  Shizuoka
  Aichi
  Mie
  Shiga
  Kyoto
  Osaka
  Hyogo
  Nara
  Wakayama
  Tottori
  Shimane
  Okayama
  Hiroshima
  Yamaguchi
  Tokushima
  Kagawa
  Ehime
  Kochi
  Fukuoka
  Saga
  Nagasaki
  Kumamoto
  Oita
  Miyazaki
  Kagoshima
  Okinawa
  Korea
  China
  Thailand
  United Kingdom
  Germany
  Switzerland
  France
  Belgium
  Netherlands
  Sweden
  Norway
  United States of America
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"