1.0 Data Structures

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/24

encourage image

There's no tags or description

Looks like no tags are added yet.

25 Terms

1
New cards

Structured Data

Data that is organized and stored in tables, in rows and columns

2
New cards

Schema

A named container for database objects, which allows you to group objects into logical collections

3
New cards

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

4
New cards

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

5
New cards

Undefined Fields

Fields that are not defined in a database table

6
New cards

Data Lake

Large repository that holds unorganized data in its raw format until the data is needed

7
New cards

Semi-Structured Data

Data that is a mix of structured and unstructured but

Contains some sort of organization through tags, labels, or markers

8
New cards

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

9
New cards

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

10
New cards

Tabular Schema

Format for storing data in tables within relational databased

11
New cards

Relational Database Management System (RDMS)

Software that maintains relational databases

12
New cards

Fields

Title for one type of data, held within a column

13
New cards

Record

The data from each field in one row

14
New cards

Primary Key

One field within the database, must be unique for each record

Identifier used for records

15
New cards

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

16
New cards

Atomicity, Consistency, Isolation, Durability (ACID)

Guide for dveeloping data systems that create complete transactions and reject partial transactions from being recorded

17
New cards

Atomicity

“All or nothing” approach

Either the whole transactions gets recorded or none of it gets recorded

18
New cards

Consistency

Ensures that all data is valid based on the defined rules

Transactions will not save if data does not follow field rules

19
New cards

Isolation

Transactions occur in a vacuum

One transaction cannot impact another

20
New cards

Durability

Once a transactions is committed it will remain in the system

If a system crashes, records committed just before will be recorded

21
New cards

NoSQL

A non-relational database

22
New cards

Document-Oriented Databases

store data in XML or JSON

Allow developers to reshape data in the needed format

23
New cards

Key-Value Stores

Stores each value with a key value

Similar to a table with just two columns

24
New cards

Column-Oriented Databases

Stores data in columns rather than rows

Sometimes makes for easier analysis (ex. counting total number of orders)

25
New cards

Graph Stores

Stores individual elements as nodes

Focuses on the relationships between data elements