When we insert data into a table, at back-end file, it stores data in row vice.
Suppose for an ex: Query: Who is my top Customer based on Amount? Ans: Cust: 5 AMT: 500. In order to get this answer, the system should scan entire file data.
The major disadvantage of storing data in row-oriented is, for irrelevant of question ( query ) system should scan entire file data. Because of this performance will reduce.
To over come this problem SAP introduced Column-Oriented DB.
Column-Oriented DB
In Column-Oriented database , each column data stores in separate file.
i.e
Suppose for an ex: same Query: Who is my top Customer based on Amount? Ans: Cust: 5 AMT: 500.
To get answer system scans the CUST file, skips PRD which is not required, scans AMT file and skips QTY file which is not required.
When storing data in column-oriented, system takes a short-cut to data. so performance increases.
No comments:
Post a Comment