lOMoARcPSD|28964921
Data Management Terms
Data Management Foundations (Western Governors University)
Studocu is not sponsored or endorsed by any college or university
Downloaded by john gatheca ()
, lOMoARcPSD|28964921
Three basic characteristics of Big Data databases: volume, velocity,
3 Vs and variety.
Data type that describes a set of similar objects with shared and
abstract data
encapsulated data representation and methods. An abstract data
type (ADT) type is generally used to describe complex objects. See also class.
ad hoc query A "spur-of-the-moment" question.
alias An alternative name for a column or table in a SQL statement.
The SQL command used to make changes to table structure. When
ALTER TABLE the command is followed by a keyword (ADD or MODIFY), it adds a
column or changes column characteristics.
American
The group that accepted the DBTG recommendations and
National
augmented database standards in 1975 through its SPARC
Standards committee.
Institute (ANSI)
analytical A database focused primarily on storing historical data and business
database metrics used for tactical or strategic decision making.
The SQL logical operator used to link multiple conditional
AND expressions in a WHERE or HAVING clause. It requires that all
conditional expressions evaluate to true.
application Software through which programmers interact with middleware. An
programming API allows the use of generic SQL code, thereby allowing client
interface (API) processes to be database server-independent.
An attribute that cannot be further subdivided to produce meaningful
atomic attribute 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
atomicity treated as a single, indivisible, logical unit of work. All parts of a
transaction must be completed or the entire transaction is aborted.
A characteristic of an entity or object. An attribute has a name and a
attribute data type.
In the context of data security, it refers to the accessibility of data
availability whenever required by authorized users and for authorized purposes.
A SQL aggregate function that outputs the mean average for a
AVG specified column or expression.
Ensuring that the processing load is distributed evenly among
balancing multiple servers.
Downloaded by john gatheca ()
, lOMoARcPSD|28964921
In SQL, a special comparison operator used to check whether a
BETWEEN value is within a range of specified values.
A movement to find new and better ways to manage large amounts
of web-generated data and derive business insight from it, while
Big Data simultaneously providing high performance and scalability at a
reasonable cost.
binary An ER term for an association (relationship) between two entities.
relationship For example, PROFESSOR teaches CLASS.
A branch of mathematics that uses the logical operators OR, AND,
Boolean algebra and NOT.
Boyce-Codd A special type of third normal form (3NF) in which every determinant
normal form is a candidate key. A table in BCNF must be in 3NF. See
(BCNF) also determinant.
A comprehensive, cohesive, and integrated set of tools and
Business processes used to capture, collect, integrate, store, and analyze
intelligence (BI) data with the purpose of generating and presenting information to
support business decision making.
A description of a policy, procedure, or principle within an
organization. For example, a pilot cannot be on duty for more than
business rule 10 hours during a 24-hour period, or a professor may teach up to
four classes during a semester.
A minimal superkey; that is, a key that does not contain a subset of
candidate key attributes that is itself a superkey. See key.
A property that assigns a specific value to connectivity and
cardinality expresses the range of allowed entity occurrences associated with a
single occurrence of the related entity.
A nested ordering sequence for a set of rows, such as a list in which
cascading order
all last names are alphabetically ordered and, within the last names,
sequence all first names are ordered.
A collection of similar objects with shared structure (attributes) and
behavior (methods). A class encapsulates an object's data
class representation and a method's implementation. Classes are
organized in a class hierarchy.
class diagram The set of symbols used in the creation of class diagrams in UML
notation object modeling.
A diagram used to represent data and their relationships in UML
class diagrams object notation.
The organization of classes in a hierarchical tree in which each
class hierarchy parent class is a superclass and each child class is a subclass. See
also inheritance.
Any process that requests specific services from server processes in
client a client/server environment.
One of three types of nodes used in the Hadoop Distributed File
System (HDFS). The client node acts as the interface between the
client node user application and the HDFS. See also name node and data
node.
A database that is created and maintained using cloud services,
cloud database such as Microsoft Azure or Amazon AWS.
Downloaded by john gatheca ()
Data Management Terms
Data Management Foundations (Western Governors University)
Studocu is not sponsored or endorsed by any college or university
Downloaded by john gatheca ()
, lOMoARcPSD|28964921
Three basic characteristics of Big Data databases: volume, velocity,
3 Vs and variety.
Data type that describes a set of similar objects with shared and
abstract data
encapsulated data representation and methods. An abstract data
type (ADT) type is generally used to describe complex objects. See also class.
ad hoc query A "spur-of-the-moment" question.
alias An alternative name for a column or table in a SQL statement.
The SQL command used to make changes to table structure. When
ALTER TABLE the command is followed by a keyword (ADD or MODIFY), it adds a
column or changes column characteristics.
American
The group that accepted the DBTG recommendations and
National
augmented database standards in 1975 through its SPARC
Standards committee.
Institute (ANSI)
analytical A database focused primarily on storing historical data and business
database metrics used for tactical or strategic decision making.
The SQL logical operator used to link multiple conditional
AND expressions in a WHERE or HAVING clause. It requires that all
conditional expressions evaluate to true.
application Software through which programmers interact with middleware. An
programming API allows the use of generic SQL code, thereby allowing client
interface (API) processes to be database server-independent.
An attribute that cannot be further subdivided to produce meaningful
atomic attribute 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
atomicity treated as a single, indivisible, logical unit of work. All parts of a
transaction must be completed or the entire transaction is aborted.
A characteristic of an entity or object. An attribute has a name and a
attribute data type.
In the context of data security, it refers to the accessibility of data
availability whenever required by authorized users and for authorized purposes.
A SQL aggregate function that outputs the mean average for a
AVG specified column or expression.
Ensuring that the processing load is distributed evenly among
balancing multiple servers.
Downloaded by john gatheca ()
, lOMoARcPSD|28964921
In SQL, a special comparison operator used to check whether a
BETWEEN value is within a range of specified values.
A movement to find new and better ways to manage large amounts
of web-generated data and derive business insight from it, while
Big Data simultaneously providing high performance and scalability at a
reasonable cost.
binary An ER term for an association (relationship) between two entities.
relationship For example, PROFESSOR teaches CLASS.
A branch of mathematics that uses the logical operators OR, AND,
Boolean algebra and NOT.
Boyce-Codd A special type of third normal form (3NF) in which every determinant
normal form is a candidate key. A table in BCNF must be in 3NF. See
(BCNF) also determinant.
A comprehensive, cohesive, and integrated set of tools and
Business processes used to capture, collect, integrate, store, and analyze
intelligence (BI) data with the purpose of generating and presenting information to
support business decision making.
A description of a policy, procedure, or principle within an
organization. For example, a pilot cannot be on duty for more than
business rule 10 hours during a 24-hour period, or a professor may teach up to
four classes during a semester.
A minimal superkey; that is, a key that does not contain a subset of
candidate key attributes that is itself a superkey. See key.
A property that assigns a specific value to connectivity and
cardinality expresses the range of allowed entity occurrences associated with a
single occurrence of the related entity.
A nested ordering sequence for a set of rows, such as a list in which
cascading order
all last names are alphabetically ordered and, within the last names,
sequence all first names are ordered.
A collection of similar objects with shared structure (attributes) and
behavior (methods). A class encapsulates an object's data
class representation and a method's implementation. Classes are
organized in a class hierarchy.
class diagram The set of symbols used in the creation of class diagrams in UML
notation object modeling.
A diagram used to represent data and their relationships in UML
class diagrams object notation.
The organization of classes in a hierarchical tree in which each
class hierarchy parent class is a superclass and each child class is a subclass. See
also inheritance.
Any process that requests specific services from server processes in
client a client/server environment.
One of three types of nodes used in the Hadoop Distributed File
System (HDFS). The client node acts as the interface between the
client node user application and the HDFS. See also name node and data
node.
A database that is created and maintained using cloud services,
cloud database such as Microsoft Azure or Amazon AWS.
Downloaded by john gatheca ()
