Acronym 4 C182 Flashcards
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
What is an example of structured data
Tables
What is an example of unstructured data?
Audio and Video recordings
Consists of data residing on different machines
Distributed Databases
DBA
Database Administrator
(Database Administration (DBA) responsibilities)
Ensuring that only authorized users have access to the database and fortifying it against unauthorized access
Database Security
(Database Administration (DBA) responsibilities)
Optimizing performance of database systems
Database tuning
(Database Administration (DBA) responsibilities)
Making replicas of databases available from various locations
High Availability
(Database Administration (DBA) responsibilities)
Continuing core business operations effectively, even with the disruption of some auxiliary services
Business Continuity
(Database Administration (DBA) responsibilities)
Write complex queries and generating reports for users
Reporting
(Database Administration (DBA) responsibilities)
Writing code to interact with the database resources
Designing and Developing Database Applications
(Database Administration (DBA) responsibilities)
The translation of raw data into something useful.
Analyzing specific categories of historical information and making decisions based on that information.
Business Intelligence
BI
Business Intelligence
NoSQL
Not Only SQL
A domain-specified language used in programming and designed for managing data
SQL
SQL
Structured Query Langauge
Databases that can accommodate a wide variety of data models.
An alternative to traditional relational databases.
Useful for working with large sets of distributed data.
NoSQL
Databases optimized to work in a cloud environment
Cloud Databases
