Advanced Database Technology & Design

By: Mario Piattini (Editor), Oscar Diaz (Editor)

Write A Review

Hardcover | 30 September 2000

At a Glance

Hardcover
558 Pages

Dimensions(cm)
22.86 x 15.88 x 3.18

Hardcover

$234.75

or 4 interest-free payments of $58.69 with

Ships in 15 to 25 business days

Here's a thorough introduction to the latest developments in database systems design presented from an applications point of view. Featuring contributions from well-known experts in the field, this new book pays special attention to issues raised by new trends in database design, and how these developments affect the programmer and database administrator. The authors and editors present concepts in an intuitive and motivating manner, making extensive use of examples, and including lists of references for additional study with each chapter.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Databases Database Design & Theory

This product is categorised by

Non-Fiction Computing & I.T.Databases Database Design & Theory

Preface	p. xv
Fundamentals	p. 1
Evolution and Trends of Database Technology	p. 3
Introduction	p. 3
Database Evolution	p. 4
Historical Overview: First and Second DB Generations	p. 4
Evolution of DB Design Methodologies	p. 8
The New DB Generation	p. 10
Problems of Current DBs	p. 11
Changes in Organizations and in Computers: The Impact on DBs	p. 11
Nontraditional Applications	p. 13
Research and Market Trends	p. 15
Performance	p. 16
Distribution and Integration	p. 17
Functionality and Intelligence	p. 18
Maturity of DB Technology	p. 20
References	p. 22
Selected Bibliography	p. 23
An Introduction to Conceptual Modeling of Information Systems	p. 25
The Functions of an Information System	p. 25
The Memory Function	p. 28
The Informative Function	p. 28
The Active Function	p. 30
Examples of ISs	p. 31
Conceptual Modeling	p. 33
Conceptual Schema of the State	p. 34
Information Base	p. 38
Conceptual Schema of the Behavior	p. 39
Integrity Constraints	p. 43
Derivation Rules	p. 45
Abstract Architecture of an IS	p. 46
Requirements Engineering	p. 51
Desirable Properties of Conceptual Schemas	p. 53
References	p. 56
Selected Bibliography	p. 57
Advanced Technologies	p. 59
Active Databases	p. 61
Introduction	p. 61
Example: University Database	p. 63
Analysis	p. 64
Recovering Business Policies	p. 64
Causal Business Policies	p. 67
Design	p. 69
Active Rules	p. 69
Supporting Recovering Business Policies Through Active Rules	p. 69
Supporting Causal Business Policies Through Active Rules	p. 73
Active Behavior	p. 76
Implementation Issues	p. 78
Active Rules in Oracle	p. 79
Active Rules in Use	p. 81
Standardizing Active Behavior in SQL: 1999	p. 85
Rule Maintenance	p. 85
Summary	p. 87
References	p. 88
Selected Bibliography	p. 89
Deductive Databases	p. 91
Introduction	p. 91
Basic Concepts of Deductive Databases	p. 93
Definition of a Deductive Database	p. 93
Semantics of Deductive Databases	p. 96
Advantages Provided by Views and Integrity Constraints	p. 98
Deductive Versus Relational Databases	p. 100
Query Processing	p. 102
Bottom-Up Query Evaluation	p. 103
Top-Down Query Evaluation	p. 105
Magic Sets	p. 107
Update Processing	p. 108
Change Computation	p. 109
View Updating	p. 114
Integrity Constraint Enforcement	p. 117
A Common Framework for Database Updating Problems	p. 119
Deductive Database System Prototypes	p. 128
Summary	p. 130
References	p. 131
Selected Bibliography	p. 136
Temporal Database Systems	p. 137
Introduction	p. 137
Temporal Data	p. 140
Some Basic Concepts and Questions	p. 142
What's the Problem?	p. 146
"Semitemporalizing" Suppliers and Parts	p. 147
Fully Temporalizing Suppliers and Parts	p. 149
Intervals	p. 154
Interval Types	p. 156
Scalar Operators on Intervals	p. 159
Aggregate Operators on Intervals	p. 160
Relational Operators Involving Intervals	p. 162
Constraints Involving Intervals	p. 170
Update Operators Involving Intervals	p. 174
Database Design Considerations	p. 176
"Horizontal" Decomposition	p. 177
"Vertical" Decomposition	p. 179
Further Points	p. 181
Summary	p. 182
References	p. 184
Selected Bibliography	p. 184
Object-Relational Database Systems	p. 189
Introduction	p. 189
A Quick Look at Relational and Object-Oriented Databases	p. 191
Contrasting the Major Features of Pure Relational and Object-Oriented Databases	p. 192
Drawbacks of Pure Relational and Object-Oriented Databases	p. 193
Technology Issues: Enabling Object Functionality in the Relational World	p. 195
Behavior	p. 196
Collection Types	p. 196
Encapsulation	p. 197
Polymorphism	p. 197
Inheritance	p. 197
Ordbms: A Closer Look at Characteristics in the Physical Implementation	p. 198
Design Issues: Capturing the Essence of the Object-Relational Paradigm	p. 201
An Object-Relational Example	p. 203
The ABC Corporation Example	p. 207
Summary	p. 208
Selected Bibliography	p. 208
Object-Oriented Database Systems	p. 211
Introduction and Motivation	p. 211
Basic Concepts of the Object-Oriented Data Model	p. 212
Objects and Object Identifiers	p. 214
Aggregation	p. 216
Methods	p. 217
Classes and Instantiation Mechanisms	p. 218
Inheritance	p. 219
Graphical Notation and Example	p. 220
ODMG Standard	p. 221
Objects and Literals	p. 222
Types: Classes and Interfaces	p. 222
Subtypes and Inheritance	p. 223
Extents	p. 223
Keys	p. 224
Collection and Structured Types	p. 224
Technology	p. 225
GemStone	p. 225
ObjectStore	p. 227
POET	p. 229
Object-Oriented Database Design	p. 230
Conceptual Design	p. 232
Standard Schema Design	p. 233
Implementation Schema Design	p. 242
Summary	p. 246
References	p. 248
Selected Bibliography	p. 249
Web Sites	p. 250
Multimedia Database Management Systems	p. 251
Introduction	p. 251
Diverse Nature of Media Objects	p. 251
Complexity and Multidimensionality	p. 252
A Sample IMD	p. 254
Design of an MM-DBMS for IMDs	p. 256
Modeling IMDs	p. 256
IMD Retrieval Issues	p. 266
Conclusions	p. 274
Main Achievements of MM-DBMS Technology	p. 274
Commercial Products and Research Prototypes	p. 280
Further Directions and Trends	p. 282
References	p. 286
Selected Bibliography	p. 289
Distributed Databases	p. 291
Introduction	p. 291
Distributed Database Architecture	p. 293
Five-Level Model for Heterogeneous Multi-DBMS	p. 296
Four-Level Model for Homogeneous Multi-DBMS	p. 298
Three-Level Model for Single-DBMS	p. 298
Physical Database Connectivity	p. 298
Distributed Data Independence	p. 299
Other Decentralized Database Architectures	p. 300
Distributed Database Design	p. 301
Data Fragmentation and Replication in Relational DDBs	p. 301
Top-Down Design of Relational DDBs	p. 304
Bottom-Up Design of Heterogeneous DDBs	p. 307
Distributed Query Processing	p. 310
Query Processing in Relational DDBs	p. 310
Query Processing in Heterogeneous DDBs	p. 314
Distributed Transaction Management	p. 315
Distributed Concurrency Control	p. 316
Distributed Commit	p. 319
Distributed Recovery	p. 322
Transaction Management in Heterogeneous DDBs	p. 322
Current Trends and Challenges	p. 323
Alternative Transaction Models	p. 323
Mediator Architectures	p. 324
Databases and the World Wide Web	p. 325
References	p. 325
Selected Bibliography	p. 327
Mobile Computing: Data Management Issues	p. 329
Introduction	p. 329
Motivation	p. 331
Architecture	p. 332
Technological Aspects: Wireless Networks	p. 334
Analog Cellular Networks	p. 334
Digital Cellular Networks	p. 334
Wireless Wide-Area Networks	p. 335
Wireless Local-Area Networks	p. 335
Satellite Networks	p. 335
The Future	p. 336
Special Issues for Consideration	p. 336
Mobility	p. 336
Wireless Medium	p. 336
Portability of Mobile Elements	p. 337
Impact of Mobile Computing on Data Management	p. 338
Transactions	p. 338
Data Dissemination by Broadcasting	p. 339
Query Processing	p. 340
Caching	p. 341
Database Interfaces	p. 341
Communication Models and Agents	p. 342
Communication Models	p. 342
Agents	p. 343
Mobile Computer Design Features for Accessing Data Services	p. 344
Summary	p. 347
References	p. 347
Selected Bibliography	p. 351
Secure Database Systems	p. 353
Introduction	p. 353
Access Control: Concepts and Policies	p. 354
Basic Concepts	p. 354
Access Control Policies	p. 355
Administration Policies	p. 360
Discretionary Access Control Models and Systems	p. 362
Authorization Models for Relational DBMSs	p. 363
Authorization Models for Object DBMSs	p. 366
Authorization Models for Active DBMSs	p. 369
Comparative Analysis of Authorization Models	p. 370
Discretionary Access Control in Commercial DBMSs	p. 370
Multilevel Security in Database Systems	p. 375
Multilevel Relational Data Model	p. 375
Architectures	p. 376
Prototypes	p. 380
Commercial Products	p. 384
Multilevel Object Data Models	p. 387
Design Issues	p. 392
Some Research Trends	p. 393
Digital Libraries	p. 394
Data Protection for Workflow Management Systems	p. 396
Data Protection for the World Wide Web	p. 397
Summary	p. 398
References	p. 399
Selected Bibliography	p. 402
Component Database Systems	p. 403
Introduction	p. 403
Motivation	p. 405
Principles of Component DBMSs	p. 409
DBMS Architecture	p. 409
Components and DBMS Architecture	p. 412
Typology of Component DBMSs	p. 413
Component Database Models	p. 416
Plug-In Components	p. 417
Middleware DBMS	p. 419
Service-Oriented DBMSs	p. 422
Configurable DBMSs	p. 423
Categories of Component DBMS Models	p. 424
Development of Component DBMSs and Their Applications	p. 424
Database Design for CDBMSs	p. 426
Development of CDBMS Components	p. 427
Related Work: The Roots of CDBMSs	p. 428
Summary	p. 430
References	p. 431
Advanced Design Issues	p. 437
CASE Tools: Computer Support for Conceptual Modeling	p. 439
Introduction to CASE Tools	p. 439
Functional Classification of CASE Tools	p. 440
Communication Between CASE Tools	p. 444
A CASE Framework for Database Design	p. 445
Conceptual Design Tools	p. 447
The Choice of the Conceptual Model	p. 448
Conceptual Modeling Tools	p. 449
Verification and Validation Tools	p. 455
Conceptual Design by Schema Integration	p. 463
Conceptual Design Based Upon Reusable Components	p. 467
Conclusion on the Conceptual Level	p. 468
Logical Design Tools	p. 469
Fundamentals of Relational Design	p. 469
Functional Dependency Acquisition	p. 470
Mapping From Conceptual Schema to Logical Schema	p. 473
Concluding Remarks on the Logical Design	p. 479
Summary	p. 479
References	p. 480
Selected Bibliography	p. 482
Database Quality	p. 485
Introduction	p. 485
Data Model Quality	p. 488
Quality Factors	p. 490
Stakeholders	p. 490
Quality Concepts	p. 492
Improvement Strategies	p. 493
Quality Metrics	p. 493
Weighting	p. 500
Data Quality	p. 501
Management Issues	p. 502
Design Issues	p. 504
Summary	p. 505
References	p. 506
Selected Bibliography	p. 509
About the Authors	p. 511
Index	p. 517
Table of Contents provided by Syndetics. All Rights Reserved.

Advanced Database Technology & Design

At a Glance

Hardcover

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Databases

SPSS Survival Manual

7th Edition - A step by step guide to data analysis using IBM SPSS

Foundations and Advances of Machine Learning in Official Statistics

Python All-in-One For Dummies

3rd Edition

Storytelling with Data

A Data Visualization Guide for Business Professionals, 10th Anniversary Edition

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

Database Systems

A Practical Approach

Tools and Applications of Data Mining

Big Data Analytics

A Practical Guide

The Data Science and Psychology

Data Mining

Concepts, Techniques and Applications

The Crypto Trader

How anyone can make money trading Bitcoin and other cryptocurrencies

Microsoft Excel 365 Bible

Bible

The Data Warehouse Toolkit 3ed

The Definitive Guide to Dimensional Modeling

Data Visualization with Microsoft Power Bi

How to Design Savvy Dashboards

SQL Cookbook

Query Solutions and Techniques for All SQL Users 2nd Edition

Hands-On Programming with R

Write Your Own Functions and Simulations

Designing Data-Intensive Applications

Big Ideas Behind Reliable, Scalable, and Maintainable Systems

Database Systems 6ed

A Practical Approach to Design, Implementation, and Management, Global Edition

Deciphering Data Architectures

Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh

Modern Data Analytics in Excel

Using Power Query, Power Pivot and More for Enhanced Data Analytics

Mindf*ck

Inside Cambridge Analytica's Plot to Break the World

The Data Hero Playbook

Developing Your Data Leadership Superpowers

Microsoft 365 Access For Dummies

Access for Dummies

Oracle in a Nutshell

In a Nutshell (O'Reilly)

This product is categorised by