Mis Final Flashcards
Big data
Data so voluminous that conventional computing methods are not able to efficiently process and manage it
Business analytics
Uses data and statistical methods to gain insight into the data and provide decision makers with information they can act on
Data dictionary
Stores definitions, such as data types for fields, default values and validation rules for data in each field
Data hierarchy
The structure and organization of data, which involves fields, records and files
Data mart
Usually a smaller version of a data warehouse, used by a single department or function
Data model
Determines how data is created, represented, organized, and maintained. It usually contains data structure, operations, and integrity rules
Data warehouse
A collection of data from a variety of sources used to support decision making applications and generate business intelligence
Data driven web site
Acts as an interface to a database, retrieving data for users and allowing users to enter data in a database
Data mining analysis
Used to discover patterns and relationships
Database
A collection of related data that is stored in a central location or in multiple locations
Database administrator
Found in large organizations, design and set up databases, establish security measures, develop recovery procedures, evaluate database performances and add fine tune database functions
Database management system
Software for creating, storing, maintains and accessing database files. A DBMS makes using databases more efficient
Distributed database management system (DDBMS)
Stores data on multiple servers throughout an organization
Extractions, transformation and loading (ETL)
The processes used in a data warehouse . It includes extracting data from outside sources, transforming it to fit operational needs, and loading it into the end target (database or data warehouse)
Foreign key
A field in a relational table that matches the primary key column of another table. It can be used to cross reference tables
Fragmentation
Addresses how tables are divided among multiple locations. There are three variations: horizontal, vertical, and mixed
Normalization
Improves databases efficiency by eliminating redundant data and ensuring that only related data is stored in a table
Logical view
How information appears to users and how it can be organized and retrieved
Physical view
Involved how data is stored on and retrieved from storage media such as hard disks, magnetic tapes or cds
Primary key
Uniquely identifies every record in a relational database. Examples include student ID numbers, account numbers, social security numbers and invoice numbers
Query by example (QBE)
You request data from a database by constructing a statement made up of query forms. With current graphical databases, you simply click to select query forms instead of having to remember keywords, as you do with SQL. You can add AND, OR, and NOT operators to the QBE form to fine tune the query
Relational model
Uses a two-dimensional table of rows and columns of data. Rows and records (also called tuples) and columns are fields (also referred to as attributes)
Structured query language (SQL)
A standard fourth-generation query language used by many DBMS packages, such as oracle 11g and Microsoft SQL server. SQL consists of several key words specifying actions to take
Variable cell
An input cell whose values solver changes in order to reach a solution for the objective cell (EX 630)
