1/24
Looks like no tags are added yet.
Structured Data
Data that is organized and stored in tables, in rows and columns
Schema
A named container for database objects, which allows you to group objects into logical collections
Relational Database
Structured database in which information is stored in tables where columns represent typed data fields and rows represent records
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
Unstructured Data
Data that are not able to be stored in columns and rows, such as audio and video signals, large bodies of text, and webpages
Undefined Fields
Fields that are not defined in a database table
Data Lake
Large repository that holds unorganized data in its raw format until the data is needed
Semi-Structured Data
Data that is a mix of structured and unstructured but
Contains some sort of organization through tags, labels, or markers
Character Large Object (CLOB)
A data type used to store large amounts of character (text) data, specifically large bodies of text that exceed the storage capacity of standard text fields
Binary Large Object (BLOB)
Collection of binary data stored as a single object
Used for large files that don’t need to fit neatly into rows and columns
Tabular Schema
Format for storing data in tables within relational databased
Relational Database Management System (RDMS)
Software that maintains relational databases
Fields
Title for one type of data, held within a column
Record
The data from each field in one row
Primary Key
One field within the database, must be unique for each record
Identifier used for records
Foreign Key
Field within a database that relates the record from one table to the records within another table
Holds the primary key values from the related table
Atomicity, Consistency, Isolation, Durability (ACID)
Guide for dveeloping data systems that create complete transactions and reject partial transactions from being recorded
Atomicity
“All or nothing” approach
Either the whole transactions gets recorded or none of it gets recorded
Consistency
Ensures that all data is valid based on the defined rules
Transactions will not save if data does not follow field rules
Isolation
Transactions occur in a vacuum
One transaction cannot impact another
Durability
Once a transactions is committed it will remain in the system
If a system crashes, records committed just before will be recorded
NoSQL
A non-relational database
Document-Oriented Databases
store data in XML or JSON
Allow developers to reshape data in the needed format
Key-Value Stores
Stores each value with a key value
Similar to a table with just two columns
Column-Oriented Databases
Stores data in columns rather than rows
Sometimes makes for easier analysis (ex. counting total number of orders)
Graph Stores
Stores individual elements as nodes
Focuses on the relationships between data elements