Joe Celko's Trees and hierarchies in SQL for smarties / Joe Celko.

By:

Celko, Joe

Contributor(s):

ScienceDirect eBooks

text

Media type:

computer

Carrier type:

online resource

ISBN:

1417537078
9781417537075
1592782426
9781592782420
9780080491691
0080491693

Other title:

Trees and hierarchies in SQL for smarties

Subject(s):

Genre/Form:

Electronic books.

Additional physical formats: Print version:: Joe Celko's Trees and hierarchies in SQL for smarties.LOC classification:

QA76.73.S67 C435 2004eb

Online resources:

Contents:

Graphs, trees, and hierarchies -- Adjacency list model -- Path enumeration models -- Nested set model of hierarchies -- Frequent insertion trees -- The linear version of the nested sets model -- Binary trees -- Other models for trees -- Proprietary extensions for trees -- Hierarchies in data modeling -- Hierarchical encoding schemes -- Hierarchical database systems (IMS).

Summary: Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioners guide to mastering the two most challenging aspects of developing database applications in SQL. In this book, Celko illustrates several major approaches to representing trees and hierarchies and related topics that should be of interest to the working database programmer. These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more. This book covers SQL-92 and SQL:1999. Includes graph theory and programming techniques. Running examples throughout the book help illustrate and tie concepts together. Loads of code, available for download from www.mkp.com.

Item type:

eBooks

Average rating: 0.0 (0 votes)

Holdings ( 0 )
Title notes ( 6 )

No physical items for this record

Includes bibliographical references (pages 215-216).

Print version record.

Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioners guide to mastering the two most challenging aspects of developing database applications in SQL. In this book, Celko illustrates several major approaches to representing trees and hierarchies and related topics that should be of interest to the working database programmer. These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more. This book covers SQL-92 and SQL:1999. Includes graph theory and programming techniques. Running examples throughout the book help illustrate and tie concepts together. Loads of code, available for download from www.mkp.com.

Safari Books Online Safari Tech Books Online

Elsevier ScienceDirect All Books