You are building a non-relational adjacency list model for your hierarchy. Don't. A chart of accounts is done with a hierarchical encoding scheme instead. If you do not have an accountant, then start with:
http://ift.tt/1npsIXd
--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties / SQL Programming Style / SQL Puzzles and Answers / Thinking in Sets / Trees and Hierarchies in SQL
No comments:
Post a Comment