Database Answers Steps in Peacocks Pond, Florida, courtesy Robert Smith, Australia
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for User-Defined Hierarchies   
We would be glad to have your comments.
Oracle has extended ANSI-standard SQL with a CONNECT BY feature while the WITH keyword is a SQL standard and is implemented in
IBM DB2, Microsoft SQL Server, and the open-source PostgreSQL.

Master Hierarchy      

User-Defined Hierarchies - Before
The User makes a selection from the
complete Master Hierarchy on the left
to create the Selected Hierarchy on the right.

This right-hand Hierarchy is stored in a table
following the design in the Data Model below.
User-Specified Hierarchy      

User-Defined Hierarchies - After
Entity-Relationship Diagram (ERD)

ERD for Wealth Management

Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
March 21st. 2015

© DataBase Answers Ltd. 2015
About Us Contact Us