Vertical and horizontal databases
Vertical and horizontal databases
another thing that i would like some explanation about Is what are these concepts of horizontal and vertical databases in pattern mining?
Re: Vertical and horizontal databases
In frequent itemset mining, an horizontal database is a database where each record is a transactions containing several items.
A vertical database is a database where each record is an item containing a list of transactions.
The two representations are equivalent. There are two ways of representing the same data.
For example, an horizontal database:
Transaction 1: item1 item2 item4
Transaction 2: item2 item3 item4
and the corresponding vertical database:
item 1: transaction1
item 2: transaction1 transaction2
item 3: transaction2
item 4: transaction1 transaction2
A vertical database is a database where each record is an item containing a list of transactions.
The two representations are equivalent. There are two ways of representing the same data.
For example, an horizontal database:
Transaction 1: item1 item2 item4
Transaction 2: item2 item3 item4
and the corresponding vertical database:
item 1: transaction1
item 2: transaction1 transaction2
item 3: transaction2
item 4: transaction1 transaction2
Re: Vertical and horizontal databases
So basically they are almost the same..