Oracle design. / (Record no. 7498)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 05092cam a22003137a 4500 |
| 001 - CONTROL NUMBER | |
| control field | 13899862 |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20210414114707.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 050315s2005 ne a 001 0 eng |
| 010 ## - LIBRARY OF CONGRESS CONTROL NUMBER | |
| LC control number | 2005272262 |
| 015 ## - NATIONAL BIBLIOGRAPHY NUMBER | |
| National bibliography number | GBA477400 |
| Source | bnb |
| 016 7# - NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER | |
| Record control number | 013023939 |
| Source | Uk |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781565922686 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (OCoLC)ocm56875856 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | UKM |
| Transcribing agency | UKM |
| Modifying agency | VPI |
| -- | DLC |
| 042 ## - AUTHENTICATION CODE | |
| Authentication code | lccopycat |
| 050 00 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | QA76.9.D26.E59 |
| 100 ## - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Ensor, Dave |
| 245 00 - TITLE STATEMENT | |
| Title | Oracle design. / |
| Statement of responsibility, etc. | Dave Ensor and Ian Stevenson |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. | |
| Place of publication, distribution, etc. | Amsterdam ; |
| -- | Sebastopol, California: |
| Name of publisher, distributor, etc. | O'Reilly & Associates, |
| Date of publication, distribution, etc. | 1997. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | xix, 526 p. : |
| Other physical details | ill. ; |
| 440 ## - SERIES STATEMENT/ADDED ENTRY--TITLE | |
| Title | Nutshell handbooks |
| 500 ## - GENERAL NOTE | |
| General note | Includes index. |
| 505 ## - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Contents: Preface. I. Getting Started With Design. 1. Introduction What Is Design? A Case Study Looking at Alternative Methods and Approaches Planning the Design Phase Design Tasks. 2. Why Is Design So Important for Oracle? Designing for Specific Architectures Designing for Performance Other Design Considerations Designing for Oracle7 Introducing Oracle8. 3. Data Modeling Types of Models What Is Data Modeling? Entity Relationship Diagrams Quality-Assuring the Conceptual Information Model Entity Life Histories and Data Flow Diagrams Data-Driven Design and Meta Models. II. Designing the Database. 4. Deciding When to Denormalize Denormalization: What, Why, and When? Methods of Implementing Denormalization Other Types of Denormalization. 5. Choosing Datatypes and Nulls Available Datatypes Numeric Data Date and Time (Temporal) Data String Data Unstructured Data and BLOBs Other Datatypes Null Values. 6. Choosing Keys and Indexes Primary Keys Other Keys Indexes: An Overview Index Types and Indexing Techniques. 7. Dealing with Temporal Data The Problem with Temporal Data Design Issues for Temporal Databases Temporal Data: A Summary. 8. Loading and Unloading Data Dealing with External Systems Data Compatibility Issues Data Migration Steps Data Transformation File Formats Ordering, Recovery, and Commit Frequency Using SQL*Loader Oracle7 to Oracle7: a Special Case Outbound Data. 9. Deciding on Object Placement and Storage Specifying Object Placement Sizing Specifying Storage Parameters Creating Scripts Implementation Planning. 10. Safeguarding Your Data Archiving Auditing Security Backup. III. Designing for Specific Architectures. 11. Designing for Client/Server Why Client/Server? What Is Client/Server? What Kind of Hardware? Basic Design Issues for Client/Server Designing for Client/Server SQL*Net Basics Anatomy of a SQL Statement Cutting in the Middle Man Special Design Considerations. 12. Designing for Distributed Databases When Should You Use Distributed Databases? Evolution of Oracle Support for Data Distribution Selecting a Data Distribution Strategy Example Scenarios Using Distributed Database for Fallback Other Design Considerations Data Distribution Summary. 13. Designing for Data Warehouses Why Data Warehouses? What Is a Data Warehouse? Design Issues for Data Warehouses Extracting and Loading the Data Meta Data Transformation Types and Methods Retrieving the Data via Data Mining and OLAP Tools. 14. Designing for Parallel Processing Why Do We Need Parallelism? Designing to Achieve Parallelism Parallel Query Option (PQO) Oracle Parallel Server (OPS). IV. Designing the Code Modules. 15. Introduction to Code Design Analysis Deliverables Mapping Functions to Modules Don't Forget the System Modules Source and Version Control Template Code Designing for Testing CASE Products in Run Unit Design. 16. Determining Where to Locate the Processing Data Rules vs. Process Rules vs. Interface Rules Logic Placement Locking Issues How Does This Relate to Three-Tier Architectures? 17. Metrics, Prototypes, and Specifications Developing Design and Build Metrics for Modules Banishing Megamodules Shall We Prototype? Where are my Specs? Guidelines for Module Specifications Specifying Screens and Reports Specifying Batch Processes. 18. Locking Locking Strategies Deadlocks Serializability Other Design Issues. 19. Selecting the Toolset Types of Tools Which Selection Criteria Are Important? Client/Server Tools Designing for the World Wide Web. 20. Designing Screens, Reports, Batch Programs, and More Designing Screens Designing Reports Designing Batch Programs Error Handling Navigation Online Help. V. Appendixes. A. Off-the-Shelf Packages Evaluating a Package Does It Fit? Can It Be Tailored? The Big Data Model Issue. B. Tricks of the Trade Fixing Those Mutating Tables Dealing with the Millennium Date Problem: An Oracle Perspective Providing User Extensibility. Index |
| 520 ## - SUMMARY, ETC. | |
| Summary, etc. | Covering database, code, and architecture design for the Oracle operating system, this text is arranged in four sections including an overview of Oracle and data modelling; and aspects of database design including denormalization, data types, nulls, keys and indexes. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Oracle (Computer file) |
| 700 ## - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Stevenson, Ian |
| 856 42 - ELECTRONIC LOCATION AND ACCESS | |
| Materials specified | Publisher description |
| Uniform Resource Identifier | <a href="http://www.loc.gov/catdir/enhancements/fy0626/2005272262-d.html">http://www.loc.gov/catdir/enhancements/fy0626/2005272262-d.html</a> |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Source of classification or shelving scheme | Library of Congress Classification |
| Koha item type | Books |
| Withdrawn status | Lost status | Source of classification or shelving scheme | Damaged status | Not for loan | Home library | Current library | Shelving location | Date acquired | Full call number | Barcode | Date last seen | Price effective from | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Library of Congress Classification | WISCONSIN INTERNATIONAL UNIVERSITY COLLEGE, GHANA KUMASI LIBRARY | WISCONSIN INTERNATIONAL UNIVERSITY COLLEGE, GHANA KUMASI LIBRARY | General Stacks | 15/11/2019 | QA76.9.D26.E59 | K/2443/2443/19 | 14/07/2020 | 14/07/2020 | Books |