Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
14 Cards in this Set
- Front
- Back
What is a hierarchical database structure?
|
-early DBMS structure
-records in tree structure -relationships are one to many |
|
What is a network database structure?
|
-used in some mainframe DBMS packages
-relationships are many to many |
|
What is a relational database structure?
|
-Data elements are stored in tables
-Row represents a record; column is a field -Can relate data in one file with data in another, if both files share a common data element |
|
What are the pros and cons of each database structure? Which one is most commonly used today?
|
hierarch: P = works for structured transactions. C = cant handle many to many
Network: P = more flexible than H. C = cant handle ad hoc requests Relational(best): P = handles ad hoc, easy to work & maintain. C = not as efficient as other 2 |
|
What is a record? An attribute? an entity?
|
: row in a table (grouping all fields of attributes of entity)
: a thing in record (characteristic/quality) : person, place, object |
|
What does OLAP stand for?
|
Online Analytical Processing
-it is part of Multidimensional structure |
|
What is encapsulation? Inheritance?
|
: combine data and operations
: new objects created by replicating characteristics of parent objects *apart of object-oriented structure |
|
What is DDL? What is metadata?
|
: data definition language used to develop & specify data contents, relationships, & structure (used by DBA)
: data about data ( apart of data dictionary) |
|
What is a data dictionary?
|
-metadata
-database of data definitions -database maintenance, security, requirements and descriptions for data and end users |
|
What is an operational database?
|
-stores info on business's operations and processes
-AKA: subject area/transaction/production databases -EX- inventory & HR |
|
What is a distributed database?
|
-spreads data to mult. sources
-improves performance, protection, & access -bad for data accuracy |
|
What is the primary purpose of a data warehouse?
|
-having a central source for analysis, research, etc.
-info needs to be cleaned, transformed, & cataloged first |
|
What is a data mart?
|
Subsets of data that focus on specific aspects of a company (department or business process)
|
|
What is SQL?
|
Structured Query language
-asking info from data -found in DBMS packages |