Terms in this set (64)
volume, velocity, variety
Abstract Data Type (ADT)
- high-end storage system
- large number of controllers and cache memory
- large storage capacity
- large amounts of cache
- fault tolerance
- ability to handle large amounts of concurrent i/os
active passive arrays
- aka midrange storage system
- provide optimal storage solutions at a lower cost
- less storage capacity and cache than high-end storage
- fewer front-end ports
- ensure high redundancy and high performance for applications with predictable workloads
ad hoc query
A "spur-of-the-moment" question.
is a process of evaluating relationships or associations between data elements that demonstrate some kind of affinity between objects.
The SQL command used to make changes to table structure. When the command is followed by a keyword (ADD or MODIFY), it adds a column or changes column characteristics.
American National Standards Institute (ANSI)
The group that accepted the DBTG recommendations and augmented database standards in 1975 through its SPARC committee.
A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making.
it displays a record if more than one condition is true
Application Programming Interface (API)
Software through which programmers interact with middleware. An API allows the use of generic SQL code, thereby allowing client processes to be database server-independent.
Descriptive; discovers links or associations amongst data.
An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances.
An attribute that cannot be further subdivided to produce meaningful components. For example, a person's last name attribute cannot be meaningfully subdivided.
The transaction property that requires all parts of a transaction to be treated as a single, indivisible, logical unit of work. All parts of a transaction must be completed or the entire transaction is aborted.
an attribute is a property or characteristic of an entity
In the context of data security, it refers to the accessibility of data whenever required by authorized users and for authorized purposes.
- It returns the average value of a numeric column. SQL
Ensuring that the processing load is distributed evenly among multiple servers.
Benefits of Cloud Computing
- reduced it cost
- business agility
- flexible scaling
- high availability
In SQL it allows you to specify a range of numeric values in a search
A movement to find new and better ways to manage large amounts of web-generated data and derive business insight from it, while simultaneously providing high performance and scalability at a reasonable cost.
An ER term for an association (relationship) between two entities. For example, PROFESSOR teaches CLASS.
A branch of mathematics that uses the logical operators OR, AND, and NOT.
Boyce-Codd Normal Form (BCNF)
A special type of third normal form (3NF) in which every determinant is a candidate key. A table in BCNF must be in 3NF. See also determinant.
Business Intelligence (BI)
A comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information to support business decision making.
- If a relation has more than one attribute or minimum group of attributes that represents a way of uniquely identifying the entities, then they are each called a candidate key.
It is the maximum number of entities that can be involved in a particular relationship.
Usually the result of a missing join condition or a method of expanding the data of 1 table by the number of rows in the second table.
Will delete all records that reference the primary key
cascading order sequence
A nested ordering sequence for a set of rows, such as a list in which all last names are alphabetically ordered and, within the last names, all first names are ordered.
a database located at a single site
class diagram notation
The set of symbols used in the creation of class diagrams in UML object modeling.
task of taking a large collection of entities and dividing that collection into smaller groups of entities that exhibit some similarity
field or attribute
The SQL command that permanently writes data changes to a database.
Common DDL commands:
Common DML commands:
An object formed by several different objects in complex relationships. See also abstract data types.
An attribute that can be further subdivided to yield additional attributes. For example, a phone number such as 615-898-2368 may be divided into an area code (615), an exchange number (898), and a four-digit code (2368). Compare to simple attribute.
An entity designed to transform an M:N relationship into two 1:M relationships. The composite entity's primary key comprises at least the primary keys of the entities that it connects. Also known as a bridge entity. See also linking table.
A primary key that consists of more than one attribute.
The output of the conceptual design process. The conceptual model provides a global view of an entire database and describes the main data objects, avoiding details.
A representation of the conceptual model, usually expressed graphically. See also conceptual model.
- When two or more users are trying to update the same record simultaneously.
The type of relationship between entities. Classifications include 1:1, 1:M, and M:N.
A restriction placed on data, usually expressed in the form of rules. For example, "A student's GPA must be between 0.00 and 4.00." Constraints are important because they help to ensure data integrity.
A SQL aggregate function that outputs the number of rows containing not null values for a given column or expression, sometimes used in conjunction with the DISTINCT clause.
A SQL command that creates indexes on the basis of a selected attribute or attributes.
CREATE TABLE command
- The command that creates base tables and tells the system what attributes will be in them.
CREATE VIEW command
- Specifies the base tables on which the view is to be based and the attributes and rows of the table that are to be included in the view.
crow's foot notation
a representation of the entity relationship diagram that uses a three pronged symbol to represent the many sides of the relationship
a data abnormality in which inconsistent changes have been made to a database. for example an employee moves but the address changes is not corrected in all files in the database
one to many binary relationships
one salesperson sells to many customers
one to one binary relationship
one salesperson works in one sales office
many to many binary relationships
A sales person is authorized to sell many products, a product can be sold by many sales people
many to many unary relationships
a product can be part of no other products or part of several other products, a products can composed of no other products or several other products
one to many unary relationship
A sales person can manage zero to many other sales people. a sales person is managed by one exactly other sales person
one to one unary relationship
one sales person back up another sales person
sql CLAUSE THAT PRODUCES ONLY A LIST OF BALUES THAT ARE DIFFERENT FROM ONE ANOTHER AND IS USED TOELIMINATE DUPLICATE ROWS IN A QUERY RESULTS
a file having no internal hierarchy
is a field in one table that uniquely identifies a row of another table
sql a comparison operator that checks whether a subquery returns any rows
a file that has been encrypted for security purposes