Database, A highly organized, multi-table digital storage system designed to hold information on a computer, DBA, The IT role is responsible for the configuration, management, and support of database applications., Queries, A request for data from a database from an end-user, Reports, Easy to read and understand output from queries of databases, Structured data, Divides information into clear, separate categories, Non-structured Data, Information that doesn't have a clear order or pattern, Semi-structured Data, Data doesn't fit neatly into rows and columns like a table, but it still shares some common features., Relational database, Structured database in which information is stored in tables where columns represent typed data fields and rows represent records., Schema, The overall structure of a particular database and its relations (set of rules), Non-Relational db, Handles data in different formats, making it easier to organize semi-structured and unstructured data., Key-value database, A type of non-relational database. It stores data using a unique key that helps you find or save the matching value., Document database, A type of non-relational database manage and track data that doesn't fit into neat and orderly tables., Records, Rows in a database, Fields , Columns in a database, Primary Key, A special identifier that makes each record unique, Foreign Key, What the primary key from the other table is called.

Module 9 Databases

etter
Skriv ut
Innebygd

Ledertavle

Visuell stil

Alternativer

Bytt mal

)
Gjenopprett automatisk lagring: ?