Oracle Design: The Definitive Guide (Nutshell Handbooks)
Language: English
Published by O'Reilly Media, 1997
- Softcover
- Used
Seller: Wonder Book, Frederick, MD, U.S.A.Wonder Book
AbeBooks seller since November 1, 1997
Condition: Used - Good
£ 5.40
Quantity: 2 available
Add to basketItem description from seller
Good condition. A copy that has been read but remains intact. May contain markings such as bookplates, stamps, limited notes and highlighting, or a few light stains.
Seller Inventory # R06B-03553
- Title
- Oracle Design: The Definitive Guide (Nutshell Handbooks)
- Author
- Ensor, Dave, Stevenson, Ian
- Publisher
- O'Reilly Media
- Publication year
- 1997
- Condition
- Good
- Binding
- Soft cover
- Language
- English
- ISBN 10
- 1565922689
- ISBN 13
- 9781565922686
Oracle Design looks thoroughly at the field of Oracle relational database design. The design of both databases and applications is an often neglected area of Oracle, but one that has an enormous impact on the ultimate power and performance of a system. If the initial design is poor, then the most powerful hardware, the most sophisticated software tools, and the most highly tuned data and programs won't make your system run smoothly and efficiently. Indeed, applications that have been designed poorly will never be able to perform well, regardless of the tuning and retrofitting performed later on.There are three main areas of Oracle design:
- The design of the specific database objects (e.g., tables, views, indexes, stored functions) that will be implemented in a database.
- The design of the screens, reports, and programs that will maintain the data and allow inquiries against it.
- Under certain circumstances, the design must also be concerned with the specific environment or technology (e.g., the network topology, the hardware configuration, and the use of a client/server, parallel processing, or distributed database architecture).
- 1. Introduction
- 2. Why is Design so Important for Oracle?
- 3. Data Modeling
- 4. Deciding When to Denormalize
- 5. Choosing Data Types and NULLs
- 6. Choosing Keys and Indexes
- 7. Dealing with Temporal Data
- 8. Loading and Unloading Data
- 9. Deciding on Object Placement and Storage
- 10. Safeguarding Your Data
- 11. Designing for Client/Server
- 12. Designing Distributed Databases
- 13. Designing for Data Warehouse
- 14. Designing for Parallel Processing
- 15. Introduction to Code Design
- 16. Determining Where to Locate the Processing
- 17. Metrics, Prototypes, and Specifications
- 18. Locking
- 19. Selecting the Toolset
- 20. Designing Screens, Reports, Batch Programs, Error Handling, and Help
- A. Off-the-Shelf Packages
- B. Tricks of the Trade
"Synopsis" may belong to another edition of this title.
About the Author
Dave Ensor is manager of Worldwide Solutions, PATROL R&D, with BMC Software where his roles are to assist customers in their use of both BMC's PATROL product and the Oracle Server, and to feed the results of his field work back into product planning. He has more than 30 years of IT experience and has been involved with the design and performance issues surrounding Oracle since 1987. For many years he led Oracle Worldwide's Performance Studies Group based in the UK, which provided consultancy support to both customer and internal projects with critical performance requirements. Dave is well known as a speaker on performance management and design; he presents his papers at user conferences and writes and delivers one-day seminars. He lives in the UK just outside London, but spends much of the year traveling to user sites and meetings. In his spare time he also travels, but in this case without his laptop and with his wife. He can be reached at dave_ensor@compuserve.com. Ian Stevenson is a freelance consultant specializing in database design and development. He has worked with database technology for 19 years, starting with early hierarchical models. He worked for Oracle (UK) for two years in post-sales support and Human Resources Development. This is where he formed his friendship with Dave Ensor. Ian has a first-class honors degree in mathematics from the University of Southampton and is a member of the British Computer Society. He is married to Brenda and has two children, Todd and Tara. He is a fanatic supporter of the Southampton football club. He can be contacted via ian@westmail.demon.co.uk.
Ian Stevenson is a freelance consultant specializing in database design and development. He has worked with database technology for 19 years, starting with early hierarchical models. He worked for Oracle (UK) for two years in post-sales support and Human Resources Development. This is where he formed his friendship with Dave Ensor. Ian has a first-class honors degree in mathematics from the University of Southampton and is a member of the British Computer Society. He is married to Brenda and has two children, Todd and Tara. He is a fanatic supporter of the Southampton football club. He can be contacted via ian@westmail.demon.co.uk.
"About the title" may belong to another edition of this title.
Wonder Book
Frederick, MD, U.S.A.
Shipping rates within U.S.A.
| Item | 5 to 9 business days | 3 to 6 business days |
|---|---|---|
| First item | £ 0.00 | £ 8.23 |
Payment methods
Store description
With 3 stores less than 1 hour outside the DC/Metropolitan area (1 in Gaithersburg, 1 in Frederick and 1 in Hagerstown, MD), we have the largest selection of books in the tri-state area. Wonder Book and Video has been in business since 1980 and online since 1997. We have over 1 Million books for sale on our website and another 1 Million books for sale in our 3 locations. Items on Abe are not necessarily in stock at our retail locations. Please do not call the stores to place orders for Abe Books sales. We have a very active online inventory and as such, we can receive multiple orders for the same item. We fill those orders on a first come first serve basis, but will refund promptly any items that are out of stock. Since 1980 it has always been about the books. ALL kinds of books from 95 cent children's paperbacks to five figure rare and collectibles. A merging of the old and new is where we started, and it is where we are today. Our retail stores have always been places where a reader can rush in looking for a title needed for a term paper that is due the next day, or where bibliophiles can get lost "in the stacks" for as long as they wish. In 2002 USAToday recognized us as "1 of 10 Great Old Bookstores", and we have been featured in numerous other newspaper and TV stories including Washington Post and CSpan. Members ABAA, ILAB.…
Association member
Seller's business information
Wonder Book
Wonder Book and Video, 1550 Tilco Drive
Frederick, MD U.S.A. 21704
Terms of sale
We want you to be satisfied with the book you order. Our general description is
conservative and the book should be as good or better than our general
description
may indicate.
As we often get many requests for the same book, in some cases the book may
already be sold. We will email you regarding the availability.
RETURNS are cheerfully accepted up to 30 days. We ship out within 1-2 business
days and U.S. Standard Shipments usually arrive within 6-9 business days,
Priority 3-6. We want you to be satisfied with the book you order. Our general
description is conservative and the book should be as good or better than our
general description may indicate. We respond to every order inquiry within 2
business days, however our emails may occassionally get moved to spam/junk
folders or refused from your internet/email provider. IF YOU HAVE EMAILED US AND
HAVE NOT RECEIVED A RESPONSE - PLEASE CHECK YOUR SPAM SETTINGS AND/OR ADD OUR
EMAIL TO YOUR ADDRESS BOOK.
Right of withdrawal
If you are a consumer you can withdraw from the contract in accordance with the following. Consumer means any natural person who is acting for purposes which are outside his trade, business, craft or profession.
Information regarding the right of withdrawal
Statutory right to withdraw
You have the right to withdraw from this contract within 14 days without giving any reason.
The withdrawal period will expire after 14 days from the day on which you acquire, or a third party other than the carrier and indicated by you acquires, physical possession of the last good or the last lot or piece.
To exercise the right of withdrawal, electronically fill in and submit a clear statement on our website, under "My Purchases" in "My Account". We will communicate to you an acknowledgement of receipt of such a withdrawal on a durable medium (e.g. by e-mail) without delay.
To meet the withdrawal deadline, it is sufficient for you to send your communication concerning your exercise of the right of withdrawal before the withdrawal period has expired.
Effects of withdrawal
If you withdraw from this contract, we will reimburse to you all payments received from you, including the costs of delivery (except for the supplementary costs arising if you chose a type of delivery other than the least expensive type of standard delivery offered by us).
We may make a deduction from the reimbursement for loss in value of any goods supplied, if the loss is the result of unnecessary handling by you.
We will make the reimbursement without undue delay, and not later than 14 days after the day on which we are informed about your decision to withdraw from this contract.
We will make the reimbursement using the same means of payment as you used for the initial transaction, unless you have expressly agreed otherwise; in any event, you will not incur any fees as a result of such reimbursement.
We may withhold reimbursement until we have received the goods back, or you have supplied evidence of having sent back the goods, whichever is the earliest.
You shall send back the goods or hand them over to Wonder Book, Frederick, Maryland, U.S.A., without undue delay and in any event not later than 14 days from the day on which you communicate your withdrawal from this contract to us. The deadline is met if you send back the goods before the period of 14 days has expired. You will have to bear the direct cost of returning the goods. You are only liable for any diminished value of the goods resulting from the handling other than what is necessary to establish the nature, characteristics and functioning of the goods.
Exceptions to the right of withdrawal
The right of withdrawal does not apply to:
- The delivery of newspapers, journals or magazines with the exception of subscription contracts; and
- The supply of digital content which is not supplied on a tangible medium (e.g. on a CD or DVD) if you accepted when you placed your order that we could start to deliver it, and that you could not withdraw once delivery had started.
Shipping terms
STANDARD DOMESTIC U.S. SHIPPING IS FREE. Priority Shipping is only $6.99 for first item, $1 each additional. Orders ship within 2 business days. Shipping outside of U.S. is typically between $8-13 and takes between 8-15 business days. Heavier books may require additional shipping. Faster Needs Please Inquire.