Muutke küpsiste eelistusi

E-raamat: Relational Database Design Clearly Explained

3.83/5 (62 hinnangut Goodreads-ist)
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 39,51 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Relational Database Design Clearly ExplainedSuurem pilt
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

In this revision of the 1999 edition, Harrington (computer science and information systems, Marist College) notes that her favorite opening line for her classes is: "Probably the most misunderstood term in all of business computing is database , followed closely by the word relational ." In a presentation not requiring special computing background, she does clearly cover theoretical and practical aspects of the relational data model and database design. Includes three database design case studies and a glossary of terms. Annotation c. Book News, Inc., Portland, OR (booknews.com)


Fully revised and updated, Relational Database Design, Second Edition is the most lucid and effective introduction to relational database design available. Here, you'll find the conceptual and practical information you need to develop a design that ensures data accuracy and user satisfaction while optimizing performance, regardless of your experience level or choice of DBMS.


Supporting the book's step-by-step instruction are three case studies illustrating the planning, analysis, and design steps involved in arriving at a sound design. These real-world examples include object-relational design techniques, which are addressed in greater detail in a new chapter devoted entirely to this timely subject.

* Concepts you need to master to put the book's practical instruction to work.
* Methods for tailoring your design to the environment in which the database will run and the uses to which it will be put.
* Design approaches that ensure data accuracy and consistency.
* Examples of how design can inhibit or boost database application performance.
* Object-relational design techniques, benefits, and examples.
* Instructions on how to choose and use a normalization technique.
* Guidelines for understanding and applying Codd's rules.
* Tools to implement a relational design using SQL.
* Techniques for using CASE tools for database design.

Muu info

* Concepts you need to master to put the book's practical instruction to work. * Methods for tailoring your design to the environment in which the database will run and the uses to which it will be put. * Design approaches that ensure data accuracy and consistency. * Examples of how design can inhibit or boost database application performance. * Object-relational design techniques, benefits, and examples. * Instructions on how to choose and use a normalization technique. * Guidelines for understanding and applying Codd's rules. * Tools to implement a relational design using SQL. * Techniques for using CASE tools for database design.
Preface to the Second Edition xiii
What You Need to Know xv
Acknowledgments xv
Part One: Theory
Introduction
3(8)
Effects of Poor Database Design
4(5)
Unnecessary Duplicated Data and Data Consistency
6(1)
Data Insertion Problems
7(1)
Data Deletion Problems
8(1)
Meaningful Identifiers
9(1)
What You Will Find in This Book
9(2)
Entities and Data Relationships
11(36)
Entities and Their Attributes
12(8)
Entity Identifiers
13(2)
Single-Valued versus Multivalued Attributes
15(2)
Avoiding Collections of Entities
17(1)
Documenting Logical Data Relationships
18(1)
Entities and Attributes for Lasers Only
19(1)
Domains
20(3)
Documenting Domains
21(1)
Practical Domain Choices
21(2)
Basic Data Relationships
23(10)
One-to-One Relationships
24(2)
One-to-Many Relationships
26(1)
Many-to-Many Relationships
27(1)
Weak Entities and Mandatory Relationships
27(1)
Documenting Relationships
28(4)
Basic Relationships for Lasers Only
32(1)
Dealing with Many-to-Many Relationships
33(4)
Composite Entities
34(2)
Documenting Composite Entities
36(1)
Resolving Lasers Only's Many-to-Many Relationships
36(1)
Relationships and Business Rules
37(2)
Data Modeling versus Data Flow
39(4)
Schemas
43(1)
For Further Reading
44(3)
Historical Antecedents
47(26)
File Processing Systems
48(6)
Early File Processing
48(2)
ISAM Files
50(2)
Limitations of File Processing
52(1)
File Processing on the Desktop
53(1)
The Hierarchical Data Model
54(5)
Characteristics of the Hierarchical Data Model
54(3)
IMS
57(2)
The Simple Network Data Model
59(6)
Characteristics of a Simple Network
59(3)
CODASYL
62(3)
The Complex Network Data Model
65(8)
The Relational Data Model
73(20)
Understanding Relations
74(3)
Columns and Column Characteristics
75(1)
Rows and Row Characteristics
76(1)
Types of Tables
76(1)
A Notation for Relations
77(1)
Primary Keys
77(5)
Primary Keys to Identify People
78(2)
Avoiding Meaningful Primary Keys
80(1)
Concatenated Primary Keys
81(1)
All-Key Relations
82(1)
Representing Data Relationships
82(4)
Referential Integrity
85(1)
Foreign Keys and Primary Keys in the Same Table
86(1)
Views
86(2)
The View Mechanism
86(1)
Why Use Views?
87(1)
The Data Dictionary
88(2)
Sample Data Dictionary Tables
89(1)
A Bit of History
90(2)
For Further Reading
92(1)
Normalization
93(28)
Translating an ER Diagram into Relations
94(1)
Normal Forms
95(1)
First Normal Form
96(6)
Understanding Repeating Groups
97(1)
Handling Repeating Groups
98(2)
Problems with First Normal Form
100(2)
Second Normal Form
102(4)
Understanding Functional Dependencies
103(1)
Using Functional Dependencies to Reach 2NF
104(1)
Problems with 2NF Relations
105(1)
Third Normal Form
106(2)
Transitive Dependencies
106(2)
Boyce--Codd Normal Form
108(2)
Fourth Normal Form
110(2)
Multivalued Dependencies
111(1)
Normalized Relations and Database Performance
112(7)
Equi-Joins
113(3)
What's Really Going On: PRODUCT and RESTRICT
116(3)
The Bottom Line
119(1)
For Further Reading
119(2)
Database Structure and Performance Tuning
121(8)
Indexing
122(2)
Deciding Which Indexes to Create
124(1)
Clustering
124(2)
Partitioning
126(2)
Horizontal Partitioning
126(1)
Vertical Partitioning
127(1)
For Further Reference
128(1)
Codd's Rules
129(14)
The Information Rule
130(2)
The Guaranteed Access Rule
132(1)
Systematic Treatment of Null Values
133(1)
Dynamic Online Catalog Based on the Relational Model
134(1)
The Comprehensive Data Sublanguage Rule
135(1)
The View Updating Rule
136(1)
High-Level Insert, Update, and Delete
137(1)
Physical Data Independence
138(1)
Logical Data Independence
139(1)
Integrity Independence
139(2)
Distribution Independence
141(1)
Nonsubversion Rule
142(1)
Integrating Objects
143(34)
An Introduction to Object-Oriented Concepts
144(22)
Writing Instructions
145(1)
Objects
146(5)
Classes
151(6)
Class Relationships
157(8)
Benefits of Object Orientation
165(1)
Integrating Objects into a Relational Database
166(1)
ER Diagrams for Object-Relational Designs
167(5)
For Further Reading
172(5)
Part Two: Practice
Using SQL to Implement a Relational Design
177(38)
Database Object Hierarchy
178(3)
Naming and Identifying Objects
179(2)
Schemas
181(2)
Creating a Schema
181(1)
Identifying the Schema You Want to Use
182(1)
Domains
183(1)
Tables
184(14)
Column Data Types
185(5)
Default Values
190(1)
NOT NULL Constraints
190(1)
Primary Keys
191(1)
Foreign Keys
191(3)
Additional Column Constraints
194(4)
Views
198(3)
Deciding Which Views to Create
198(1)
View Updatability Issues
199(1)
Creating Views
199(2)
Temporary Tables
201(3)
Creating Temporary Tables
202(1)
Loading Temporary Tables with Data
203(1)
Disposition of Temporary Table Rows
203(1)
Creating Indexes
204(1)
Modifying Database Elements
205(4)
Adding New Columns
205(1)
Adding Table Constraints
206(1)
Modifying Columns
206(1)
Deleting Elements
207(1)
Renaming Elements
208(1)
Deleting Database Elements
209(1)
Granting and Revoking Access Rights
209(4)
Types of Access Rights
210(1)
Storing Access Rights
210(1)
Granting Rights
211(1)
Revoking Rights
212(1)
Object-Relational Extensions
213(2)
Using Case Tools for Database Design
215(16)
CASE Capabilities
216(2)
ER Diagram Reports
218(2)
Data Flow Diagrams
220(2)
The Data Dictionary
222(3)
Code Generation
225(3)
Sample Input and Output Designs
228(1)
The Drawing Environment
229(1)
For Further Reading
230(1)
Database Design Case Study #1: Mighty-Mite Motors
231(50)
Corporate Overview
232(19)
Product Development Division
232(6)
Manufacturing Division
238(1)
Marketing & Sales Division
239(1)
Current Information Systems
239(1)
Reengineering Project
240(1)
New Information Systems Division
241(1)
Basic System Goals
241(1)
Current Business Processes
242(9)
Designing the Database
251(17)
Examining the Data Flows
253(3)
Creating the ER Diagram
256(5)
Creating the Tables
261(1)
Generating the SQL
262(6)
The Object-Relational Design
268(13)
Creating the Classes
273(2)
Using the Classes in the Schema
275(6)
Database Design Case Study #2: East Coast Aquarium
281(40)
Organizational Overview
282(8)
Animal Tracking Needs
284(4)
The Volunteer Organization
288(2)
The Volunteers Database
290(11)
Creating the Application Prototype
290(10)
Creating the ER Diagram
300(1)
Designing the Tables
300(1)
Generating the SQL
301(1)
The Animal Tracking Database
301(15)
Highlights of the Application Prototype
303(5)
Creating the ER Diagram
308(3)
Creating the Tables
311(1)
Generating the SQL
312(4)
The Object-Relational Design
316(5)
The Volunteers Database
316(1)
The Animal Tracking Database
317(4)
Database Design Case Study #3: Independent Intelligence Agency
321(54)
Organizational Overview
322(11)
Current Information Systems
324(3)
Summary of IS Needs
327(1)
System Specifications
328(5)
Designing the Database
333(22)
ER Diagram for People
334(3)
ER Diagram for Intelligence Gathering and Sales
337(3)
ER Diagram for System Security
340(1)
ER Diagram for Equipment Tracking
341(2)
Designing the Tables
343(1)
Generating the SQL
344(11)
The Object-Relational Design
355(20)
Creating the Classes
362(3)
Writing the Schema
365(10)
Glossary 375(12)
Index 387


Jan L. Harrington, the author of 30 books, including SQL, Clearly Explained (Academic Press), has been writing about databases since 1984. She is a professor and chair of the department of computer science and information systems at Marist College, where she teaches database design and management, object-oriented programming, data communications, and computer architecture.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97800805160662e.html
Märksõnad: