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
What database consists of data residing on different machines
Distributed Databases
What database responsibility ensures that only authorized users have access to the database and fortifying it against unauthorized access
Database security
What database responsibility optimizes performance of database systems
Database tuning
What database responsibility makes replicas of databases available from various locations
High availability
What database responsibility continues core business operations effectively even with the disruption of some auxiliary services
Business continuity
What database responsibility plans for and executes adequate backup and recovery procedures
Backup and recovery
What database responsibility writes complex queries and generates records for users
Reporting
What database responsibility writes coding to interact with the database resources
Designing and developing database applications
