Muutke küpsiste eelistusi

E-raamat: Data Analysis for Database Design

4.25/5 (8 hinnangut Goodreads-ist)
(Professor, formerly at Department of Computing, de Montfort University, UK)
  • Formaat: PDF+DRM
  • Ilmumisaeg: 31-May-2001
  • Kirjastus: Butterworth-Heinemann Ltd
  • Keel: eng
  • ISBN-13: 9780080503608
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 49,13 €*
  • * 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.
Data Analysis for Database DesignSuurem pilt
  • Formaat: PDF+DRM
  • Ilmumisaeg: 31-May-2001
  • Kirjastus: Butterworth-Heinemann Ltd
  • Keel: eng
  • ISBN-13: 9780080503608
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. 

Data analysis for database design is a subject of great practical value to systems analysts and designers. This classic text has been updated to include chapters on distributed database systems, query optimisation and object-orientation.The SQL content now includes features of SQL92 and SQL 99.

With new databases coming online all the time and the general expansion of the information age, it is increasingly important to ensure that the analysis and model of a database design is accurate and robust. This is an ideal book for helping you to ensure that your database is well designed and therefore user friendly.



Increased material on SQL including the latest developments
Practical approach to explaining techniques and concepts
Contains many questions and answer pointers


Data analysis for database design is a subject of great practical value to systems analysts and designers. This classic text has been updated to include chapters on distributed database systems, query optimisation and object-orientation.The SQL content now includes features of SQL92 and SQL 99.

With new databases coming online all the time and the general expansion of the information age, it is increasingly important to ensure that the analysis and model of a database design is accurate and robust. This is an ideal book for helping you to ensure that your database is well designed and therefore user friendly.

Increased material on SQL including the latest developments
Practical approach to explaining techniques and concepts
Contains many questions and answer pointers

Arvustused

"... It has the very specific aim of explaining techniques and concepts. It does so from a very practical standpoint by drawing on reasonably small-scale examples. To allow the reader to measure comprehension at each stage selected exercises are provided. The 'answer pointers' at the end of the chapter readily reveal any lack of comprehension... This book is strongly recommended to serious students..... It is able to delve thoroughly into the area of data analysis and model design." --The Computer Journal. (Of the first edition)

Preface to the Third Edition ix
Readership
Scope
Structure and content
Terminology
Questions and Assignments
Comparison with the second edition
Acknowledgements
Part A: Introduction 1(12)
Database
Torg Ltd
Analysis
Answer Pointers
Part 1: Database and database management Systems 13(20)
Database systems
15(9)
The database approach
Program/data independence
Other database management system facilities
What constitutes a database management system?
Disadvantages
Database vs database management system
Scope of a database
Assignment
Answer Pointers
Database management system architecture
24(9)
Introduction
A three-level architecture
The conceptual schema
The external schema
The internal schema
Mapping
DBMS components
Advantages of three-level architecture
Data administration
Model vs schema
Terminology
Assignments
Answer pointers
Part 2: Relational modeling 33(56)
Tables
35(4)
Introduction
Tables
Nulls
Normalisation
Answer pointers
Redundant vs duplicated data
39(8)
Introduction
Redundant vs duplicated data
Elimination of redundancy
Deceptive appearances
Enterprise rules
Answer pointers
Repeating groups
47(10)
Introduction
Repeating groups
Elimination of repeating groups (normalisation)
Assignments
Separate attribute types
Answer pointers
Determinants and identifiers
57(23)
Introduction
Determinants
Superfluous attributes
Determinancy diagrams
Composite determinants
Transitive determinants
Terminology
Assignment
Identifiers
Determinancy diagrams and redundancy
Transformation into well-normalised tables
Notation
Assignment
Answer pointers
Fully-normalised tables
80(9)
Introduction
Hidden transitive dependency
Multi-valued determinancy
Advantages of full normalisation
Normal forms
Assignments
Answer pointers
Part 3: Entity-relationship modelling 89(98)
Introduction to entity-relationship modelling
91(7)
Bottom-up data modelling
Entity-relationship modelling
Type vs occurrence
Identifiers
Entity-relationship diagrams
Answer pointers
Properties of relationships
98(11)
The degree of a relationship
Determinancy constraints
Participation conditions
Multiplicity
Choices of notation
Answer pointers
Decomposition of many:many relationships
109(7)
Decomposition
Answer pointers
Connection traps
116(13)
Introduction
Misinterpretation
Fan traps
Chasm traps
Further fan traps
Decomposition of complex relationships
Summary
Answer pointers
Skeleton entity-relationship models
129(18)
Introduction
Representation of 1:1 relationships
Representation of 1: many relationships
Representation of many: many relationships
Preposted identifiers
Skeleton tables
Relationship identifiers
Relationship vs row identifiers
Review
Recursive relationships
Answer pointers
Attribute assignment
147(12)
Assignment rules
1:1 relationships
1:many relationships
Many:many relationships
Extending the skeleton model
Superfluous entity tables
Entity subtypes
Answer pointers
First-level design
159(12)
Introduction
First-level design procedure
First-level design example
Answer pointers
Second-level design
171(16)
Introduction
Flexing by table elimination
Flexing by splitting
Derivable attributes
Assignment
Second-level design example
Answer pointers
Part 4: Further topics 187(88)
Distributed database systems
189(8)
Introduction
An extended library scenario
A distributed database design
Distributed data independence
Avoiding complications
Answer pointers
Relational algebra
197(16)
Table-at-a-time processing
Relational algebra operations
Sample queries
Further join operations
Union, intersection and difference
Division
Extended Cartesian product
Update
Nested operations
Assignment
Answer pointers
Query optimisation
213(15)
Query processing
Query plans
Storage structures
Optimisation
Distributed database optimisation
Summary
Answer pointers
The SQL language
228(33)
Introduction
Table creation
Retrieving data
Updating data
Views
Drop
Alter
Granting and revoking privileges
Embedded SQL
Some SQL issues
Answer pointers
Object-orientation
261(14)
Introduction Overview of object-orientation
Class diagrams
Object-oriented developments
Further data types
SQL99 inheritance
User defined types
Answer pointers
Appendix A: The Codasyl (network) model 275(42)
Acknowledgements to Codasyl
A1: Basic of the Codasyl (network) model
A2: Further Codasyl schema facilities
A3: Further Codasyl DML facilities
Bibliography 317(2)
Index 319
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97800805036082e.html
Märksõnad: