Physical database design for SYBASE SQL Server
著者
書誌事項
Physical database design for SYBASE SQL Server
Prentice Hall PTR, c1995
大学図書館所蔵 件 / 全1件
-
該当する所蔵館はありません
- すべての絞り込み条件を解除する
注記
Includes index
内容説明・目次
内容説明
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.
目次
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.
「Nielsen BookData」 より