Tabular Database

Why Trust Techopedia

What Does Tabular Database Mean?

A tabular database, as the name implies is a database that is structured in a tabular form. It arranges data elements in vertical columns and horizontal rows. Each cell is formed by the intersection of a column and row. Each row and column is uniquely numbered to make it orderly and efficient. This type of database has a virtually infinite range for mass data storage.

Advertisements

Techopedia Explains Tabular Database

Structuring data in tabular form may be the oldest method used. It also simple. Elementary students are taught to organize data into tabular formats while high school students are taught to master various spreadsheet programs that are commonly laid out in table form.

Tabular databases include the following key properties:

  • They share the same set of properties per record. This means that every row has the same set of column titles. Each column is usually assigned with metadata as its header title. If one of the rows lacks data for a specific column, a missing value that is related to that column’s metadata will be stored in that cell.
  • They access records through identifiers. Each table in a tabular database contains a particular set of related information that is connected with the database subject through key fields, which describe each record (row) so that in the event of a query, the system can quickly locate the record.
Advertisements

Related Terms

Margaret Rouse
Editor

Margaret jest nagradzaną technical writerką, nauczycielką i wykładowczynią. Jest znana z tego, że potrafi w prostych słowach pzybliżyć złożone pojęcia techniczne słuchaczom ze świata biznesu. Od dwudziestu lat jej definicje pojęć z dziedziny IT są publikowane przez Que w encyklopedii terminów technologicznych, a także cytowane w artykułach ukazujących się w New York Times, w magazynie Time, USA Today, ZDNet, a także w magazynach PC i Discovery. Margaret dołączyła do zespołu Techopedii w roku 2011. Margaret lubi pomagać znaleźć wspólny język specjalistom ze świata biznesu i IT. W swojej pracy, jak sama mówi, buduje mosty między tymi dwiema domenami, w ten…