Acronym 4 C182 Flashcards
(41 cards)
Database applications have two major layers
Application Layer
Database Management Layer
Communicates with the end user and can be fairly complex
Application Layer
DBMS
Database Management System
The act of analyzing and converting data into information that can be used in decision-making
Database research
Types of Data
Integers
Floating Point Numbers
Characters
Character Strings
What type of data?
31068
Integers
What type of Data?
4.82
Floating Point Numbers
What type of data?
- Y
- #
- @
Characters
What type of data?
- FggsJ43!(08
- Mmfds59^;3#23edoO
- G2nS88^9(#@
Character Strings
What represents a truth value; that is, TRUE or FALSE
Boolean Value
What stores data in a plain text file? Each line of the text file holds one record.
Flat-File Database
Data is organized in a tree structure
Hierarchical Database (one of the oldest database models)
Contains database tables that can be joined together in logical ways
Relational Databases
What is a Primary Key?
A records unique identifier on a relational database
What is a Foreign Key?
A primary key of one table that appears as an attribute in another table
An activity through which users and applications access and manipulate data in relational databases
Database Operation
Queries
When a user or application sends a request to a database
SQL
Structured Query Language
Take rows from one table and create a new table.
Selection Operation
Combines distinct fields from multiple tables that have the same set of attributes and data types
Union Operation
Creating a result table that includes all of the attributes from the two tables; each row of the second table is added to each row of the first table
Product Operation
Combines two tables, but records are only appended when a matching criterion is met
Join Operation
Stores complex data and relationships between data directly without using inter-table relations.
Optimized to work in a cloud environment
Object-Oriented Database
Systems of data stored in raw format
Data Lakes
