Chapter 8. Hierarchical Queries

   

A relational database is based upon sets, with each table representing a set. However, there are some types of information that are not directly amenable to the set data structure. Think, for example, of an organization chart, a bill of material in a manufacturing and assembly plant, or a family tree. These types of information are hierarchical in nature, and most conveniently represented in a tree structure. In this chapter we discuss how to represent such hierarchical information in a relational table. We also discuss in detail various SQL constructs that you can use to extract hierarchical information from a relational table.

Previous page

Table of content

Next page

---

Mastering Oracle SQL, 2nd Edition

ISBN: 0596006322
EAN: 2147483647

Year: 2003
Pages: 154

Authors: Sanjay Mishra, Alan Beaulieu

BUY ON AMAZON

---

ERP and Data Warehousing in Organizations: Issues and Challenges

• The Effects of an Enterprise Resource Planning System (ERP) Implementation on Job Characteristics – A Study using the Hackman and Oldham Job Characteristics Model
• Distributed Data Warehouse for Geo-spatial Services
• Data Mining for Business Process Reengineering
• Relevance and Micro-Relevance for the Professional as Determinants of IT-Diffusion and IT-Use in Healthcare
• Development of Interactive Web Sites to Enhance Police/Community Relations

SQL Tips & Techniques (Miscellaneous)

• Creating Indexes for Fast Data Retrieval
• Working with Stored Procedures
• Repairing and Maintaining MS-SQL Server Database Files
• Exploiting MS-SQL Server Built-in Stored Procedures
• Working with SQL Database Data Across the Internet

Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference

• Internet Control Message Protocol (ICMP)
• Internet Protocol Version 6 (IPv6)
• User Datagram Protocol
• Transmission Control Protocol (TCP) Retransmission and Time-Out
• Windows Internet Name Service (WINS)

The Complete Cisco VPN Configuration Guide

• WebVPN Remote Access
• Summary
• Concentrator Tools
• Microsoft Client Connections
• Router Product Information

Programming Microsoft ASP.NET 3.5

• The Web Forms Model
• ASP.NET Core Server Controls
• Real-World Data Access
• Data-Bound and Templated Controls
• Working with Images in ASP.NET

Oracle SQL*Plus: The Definitive Guide (Definitive Guides)

• Creating and Loading the Sample Tables
• Executing the Statement in the Buffer
• Extracting the Data
• Environment Variables That Affect SQL*Plus
• Section B.2. Formatting Character Strings

flylib.com © 2008-2017.
If you may any questions please contact us: [e-mail]

Privacy policy

This website uses cookies. Click here to find out more.
Accept cookies