• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 3 out of 16 pages
Summary

Summary Data Management Terms

Document preview thumbnail
Preview 3 out of 16 pages

Data Management Terms

Content preview

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 ()

Document information

Uploaded on
January 13, 2024
Number of pages
16
Written in
2023/2024
Type
Summary
$40.49

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
johngatheca
2.5
(2)
Sold
21
Followers
25
Items
729
Last sold
1 year ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions