Section 6 Flashcards
What system converts large amounts of data into a usable format to help users make business decisions
Database management system
What database is multidimensional, allowing information to be accessed from various views through internal linking between entries
Relational databases
What database are one-dimensional and presents information from a single point of view and do not interact with other files/plain text file
Flat file system
What layer communicates with the end user and can be fairly complex
Application layer
What layer alters the database after receiving the request through the application layer
Database management layer
What is composed of records and fields that hold data
Database
What part of the database table represents fields
Columns
What part of the database table contains a single piece of data about the subject of a record
Field
What part of the database table is represented as rows in a table with related information
Records
What database is one of the oldest database models and is organized in a tree structure
Hierarchical database
What database contains tables that can be joined together in logical ways
Relational database
What data type is used for double-precision floating-point numbers
Double
What data type stores a series of characters, including numbers, letters, and special characters forming a phrase in programming
String
What data type is used for whole numbers
Integer
What data type is used to represent only two possible values, true or false
Boolean
What operation takes row from one table and creates a new table
Selection operation
What operation combines distinct fields from multiple tables that have the same set of attributes and data types
Union operation
What operation creates a result table that includes all of the attributes from the two tables
Product operation
What operation combines two table, but records are only appended when a matching criterion is met
Join operation
What database is a collection of objects, each with two components: data and instructions
Object-oriented (OO) databases
What database has each item stored as an attribute name together with its value
Key-value databases (Stores)
What database can accommodate a wide variety of data models, including key-value, document, columnar, and graph formats
NoSQL
What database is optimized to work in a cloud environment
Cloud databases
What is a system of data stored in raw format
Data lake
