Database System Concepts, Volume 1
The new edition of this book provides improved and extensive coverage of concepts, database system internals and new tools and techniques. It is intended for a first course in databases at the junior or senior undergraduate, or first-year graduate level, and offers a complete background in the basics of database design, language and system implementations. Concepts are presented using intuitive descriptions, and important theoretical results are covered, but formal proofs are omitted. The fundamental concepts and algorithms covered are based on those used in existing commercial or experimental database systems. The authors present these concepts and algorithms in a general setting that is not tied to one particular database system.
Results 1-3 of 68
A variety of data-access techniques are presented in Chapter 12, including
hashing, B+-tree indices, and grid file indices. Chapters 13 and 14 address query
-evaluation algorithms, and query optimization based on equivalence-preserving
The area of online analytical processing (OLAP) deals with tools and techniques
for data analysis that can give nearly instantaneous answers to queries
requesting summarized data, even though the database may be extremely large.
26.4.2 Join, Aggregation, and Set Operations DB2 supports a number of
techniques for join, aggregation and set operations. For join, DB2 can choose
between nested loops, sort merge, and hashing techniques. In describing the join
and set ...
What people are saying - Write a review
LibraryThing ReviewUser Review - IvanIdris - LibraryThing
This book teaches about the inner workings, the nuts and bolts of databases without requiring a lot of prior knowledge: Data Models Relational Databases Object Based Databases and XML Data Storage and ... Read full review