c175 final
1. 3Vs: volume, velocity, variety
2. Abstract Data Type (ADT):
3. active-active array:
- 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
4. 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
5. ad hoc query: A "spur-of-the-moment" question.
6. affinity grouping: is a process of evaluating relationships or associations
between data elements that demonstrate some kind of affinity between objects.
7. ALTER TABLE: 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.
8. American National Standards Institute (ANSI): The group that accepted the
DBTG recommendations and augmented database standards in 1975 through
its SPARC committee.
9. analytical database: A database focused primarily on storing historical data
and business metrics used for tactical or strategic decision making.
10. and operator: it displays a record if more than one condition is true
11. 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.
12. Association Rules: Descriptive; discovers links or associations amongst data.
13. Associative Entity: 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.
1/5
, .
14. atomic attribute: An attribute that cannot be further subdivided to produce
meaningful components. For example, a person's last name attribute cannot be
meaningfully subdivided.
15. Atomicity: 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.
16 attribute: an attribute is a property or characteristic of an entity
17. availability: In the context of data security, it refers to the accessibility of
data whenever required by authorized users and for authorized purposes.
18. AVG() function: - It returns the average value of a numeric column. SQL
19. Balancing: Ensuring that the processing load is distributed evenly among
multiple servers.
20. Benefits of Cloud Computing:
- reduced it cost
- business agility
- flexible scaling
- high availability
21. between: In SQL it allows you to specify a range of numeric values in a
search
22. Big Data: 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.
23. binary relationship: An ER term for an association (relationship) between two
entities. For example, PROFESSOR teaches CLASS.
24. Boolean Algebra: A branch of mathematics that uses the logical operators OR,
AND, and NOT.
25. 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.
26. 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.
27. Candidate Key: - 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.
2/5
1. 3Vs: volume, velocity, variety
2. Abstract Data Type (ADT):
3. active-active array:
- 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
4. 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
5. ad hoc query: A "spur-of-the-moment" question.
6. affinity grouping: is a process of evaluating relationships or associations
between data elements that demonstrate some kind of affinity between objects.
7. ALTER TABLE: 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.
8. American National Standards Institute (ANSI): The group that accepted the
DBTG recommendations and augmented database standards in 1975 through
its SPARC committee.
9. analytical database: A database focused primarily on storing historical data
and business metrics used for tactical or strategic decision making.
10. and operator: it displays a record if more than one condition is true
11. 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.
12. Association Rules: Descriptive; discovers links or associations amongst data.
13. Associative Entity: 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.
1/5
, .
14. atomic attribute: An attribute that cannot be further subdivided to produce
meaningful components. For example, a person's last name attribute cannot be
meaningfully subdivided.
15. Atomicity: 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.
16 attribute: an attribute is a property or characteristic of an entity
17. availability: In the context of data security, it refers to the accessibility of
data whenever required by authorized users and for authorized purposes.
18. AVG() function: - It returns the average value of a numeric column. SQL
19. Balancing: Ensuring that the processing load is distributed evenly among
multiple servers.
20. Benefits of Cloud Computing:
- reduced it cost
- business agility
- flexible scaling
- high availability
21. between: In SQL it allows you to specify a range of numeric values in a
search
22. Big Data: 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.
23. binary relationship: An ER term for an association (relationship) between two
entities. For example, PROFESSOR teaches CLASS.
24. Boolean Algebra: A branch of mathematics that uses the logical operators OR,
AND, and NOT.
25. 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.
26. 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.
27. Candidate Key: - 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.
2/5
