Drawbacks of the Vertical Table
March 10th, 2008 . by Henry
A strong data typing is lost with a vertical table, because the value column is of only one type and all values need to be either of that type or need to be converted back and forth during save and retrieve operations. Storing special data types like Blobs or Clobs is very impossible in the vertical table. Another drawback is the data consistency. The fact that all column names are entries in the key column makes it much easier for the users to store potentially identical data with differently called keys. Also, working with a vertical table is harder in finding the specific a logical row.
