Structured Data


Structured data is data that is organized and stored in tables, in rows and columns.

  • fit neatly in a schema
    • A named container for database objects, which allows you to group objects into logical collections
  • can be restructured to fit into other structured data systems

Relational database is a structured database in which information is stored in tables where columns represent typed data fields and rows represent records.

  • most traditional store of structured data
  • Tables can have relationships
    • established by linking a unique primary key field in one table with the same value in a foreign key field in another table
  • overall structure of a particular database and its relations is called a schema