Reading...
Play button
Play button
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;
13 Cards in this Set
- Front
- Back
|
Describe the data-information-decision-making cycle.
|
The data user applies intelligence to data to produce information that is the basis of knowledge used in decision making by the user. This triggers actions and generate additional data.
|
|
|
What is the database's predominant role?
|
Database's predominant role is to support managerial decision making at all levels DBMS facilitates: Interpretation and presentation of data Distribution of data and information Preservation and monitoring of data Control over data duplication and use Three levels to organization management: Top, middle, operational
|
|
|
Describe data as a corporate asset.
|
Data are a valuable asset that require careful management Data are a valuable resource that translate into information Accurate, timely information triggers actions that enhance company's position and generate wealth
|
|
|
How does the introduction of a database affect an organisation?
|
Introduction of a DBMS is likely to have a profound impact Might be positive or negative, depending on how it is administered Three aspects to DBMS introduction: Technological Managerial Cultural One role of DBA department is to educate end users about system uses and benefits
|
|
|
How has the database administration function evolved?
|
Data administration has its roots in the old, decentralized world of the file system Advent of DBMS produced new level of data management sophistication DP department evolved into information systems (IS) department. Data management became increasingly complex: development of database administration function
|
|
|
What is the DBA's managerial role?
|
- Coordinating, monitoring, allocating resources
- Resources include people and data - Defining goals and formulating strategic plans - Interacts with end user by providing data and information - Enforces policies, standards, procedures - Manages security, privacy, integrity - Ensures data can be fully recovered - Ensures data distributed appropriately |
|
|
What is the DBA's technical role?
|
- Evaluates, selects, and installs DBMS and related utilities
- Designs and implements databases and applications - Tests and evaluates databases and applications - Operates DBMS, utilities, and applications - Trains and supports users - Maintains DBMS, utilities, and applications |
|
|
Describe the Data Administrator's role.
|
- The DA usually reports to top management and has higher degree of authority /responsibility
- responsible for overall corporate data resources not only computerised by also outside scope of DBMS |
|
|
Contrast DA's role with DBA.
|
- Does strategic planning
- sets long term goals - sets policies and standards - is broad in scope - focuses on the long term - managerial orientation - is DBMS-independent |
|
|
Contrast DBA role with DA's.
|
- controls and supervises
- executes plans to reach goals -enforces policies, procedures & programming standards - narrow in scope -short-term focus (daily ops) - technical orientation - DBMS-specific |
|
|
What are the three types of legally recognised privacy?
|
- Territorial (physical area around person, trespassing)
- Personal (protects individuals from undue interference, physical searches) - privacy in information context (illegal gathering, use and dissemination of info) |
|
|
Why is privacy an issue?
|
computers and databases make it easier to collect information and potentially breach privacy
|
|
|
What can a DBA do to protect privacy?
|
Utilities built-in protection mechanisms in DBMS:
- triggers for unauthorised activities - virtual views - r/w access control -user authentication - physical access to DBMS facilities - privacy legislation (has to be recognised and implemented by organisations) |
