Using Vertical and Horizontal Table Structures in Oracle
Vertical Table Grouping
The variations of vertical data storage can include custom algorithms for aggregation of logical data rows. What this means is that more then on id column can be used to group properties. For example:
When a custom report is generated, it can be split easily into pages or sections based on the second "grouping" column. Therefore, a Vertical Table above can become this report:
|Machine: Dell 560|
|Machine: Dell 1750|
Note how different reports and pages have a diverse number of entries in them.
In this article, I have shown you different ways to persist data in a database table. The benefits and flexibility offered by a vertical data layout are often negated by its shortcomings. But, its flexibility is often the only way to design data organization. On the other hand, horizontal tables are better suited for data normalization and are a traditional way to persist data in RBMS. It will be up to software and database architects to decide what type of database table design is the right choice for a specific application need.
About the Author
Vlad Kofman works on enterprise-scale projects for the major Wall Street firms. He has also worked on defense contracts for the U.S. government. His main interests are object-oriented programming methodologies, UI, and design patterns.
Page 2 of 2