Operational AI WIKI

All 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Row-wise Data Format

Row-oriented databases are traditional databases such as Oracle, MySQL, Microsoft SQL Server, etc., which represent all data about a “thing,” i.e. all the details about a person, in a table stored by rows. Thus, a row and all its column values are physically stored together on disk, with the column values of the row stored adjacent to each other. These databases efficiently return the data for an entire row, making them best suited for accessing single or small subsets of records. Row-wise data formats are best-suited for transactional workloads (OLTP).

Related Terms

WIKI Contribution

  • Have a new word to add?
  • Have an updated definition?
Become a contributor