Oracle Quick Guides - Part 2 - Oracle Database Design

by Malcolm Coxall, Guy Caswell (Editor)

Overview

This is Part 2 of a series of quick learning guides for Oracle designers, developers and managers. Part 2 introduces completely new entrants to concepts of Oracle database analysis and design, database normalisation, the logical datamodel, E-R modelling and diagrams, logical to physical transformation in Oracle Designer, physical database design, de-normalization, database design for performance, and building a physical database from a server model.

These guides are designed to rapidly deliver key information about Oracle to the following audience groups:

- Project Managers and Team Leaders who are new to Oracle and need rapid access to strategic information about the Oracle design and development environment.

- Business Analysts, Designers and Software developers who are new to Oracle and need to make first steps in gaining a detailed understanding of the design and development issues involved in Oracle.

Part 2 assumes that the reader has a basic knowledge of the relational model and a basic understanding of logical and physical design concepts. The contents of Part 2 include the following subject headings:

Preface and Audience
1. The Analysis phase - Separating Functional and Database Design
2. Introduction to Datamodelling and Database Design: Logical and Physical concepts of design
3. Practical Logical Design - Data-modelling
4. Practical Logical Design using Oracle Designer
5. Moving from the Logical to the Physical design
6. Practical Physical Design (using Oracle Designer)
7. Designing a database for Performance
8. Building the physical database from Designer
9. Managing Changes during development
10. Glossary of Terms

Product Details

BN ID:	2940149597000
Publisher:	Malcolm Coxall - Cornelio Books
Publication date:	05/13/2013
Series:	Doctor Who - Short Trips #5.11 , #2
Sold by:	Barnes & Noble
Format:	eBook
File size:	500 KB

About the Author

Malcolm Coxall, the author, is a business and IT systems analyst and consultant with more than 30 years freelance experience in Europe and the Middle East. Malcolm has worked in Oracle systems design and development for the last 25 years as a developer, business analyst, database designer, DBA, systems administrator, team lead and project manager.

With experience working for many of the world's largest corporate and institutional players, as well as for several government and international agencies, Malcolm has extensive hands-on experience in designing and building large-scale Oracle systems in many diverse vertical markets such as banking, oil, defence, telecoms, manufacturing, mining, food, agriculture, aerospace, and engineering.

Malcolm also writes and publishes books, papers and articles on human system design, sociology, environmental economics, sustainable technology and technology in environmental protection and food production.

Malcolm's company designed and built the Oracle systems known as BioTrack and EcoBase. BioTrack is an integrated agriculture and food production control and traceability system designed specifically for organic and other specially controlled food production industries. EcoBase is an environmental research database for bringing together environmental data with complex statistical analysis techniques. Both of these systems were designed and developed in Oracle 10g and are commercialised as cloud-based systems directly available to end-users.

Malcolm lives in southern Spain from where he continues his free-lance Oracle consultancy and his writing, whilst managing the family's organic farm.