strategic planning, control, and ______
Efforts to control dirty data are generally
referred to as _____________.
_________ is a comprehensive approach to ensuring the accuracy, validity, and timeliness of the data
__________ consists of programs that gather statistics and analyze existing data sources.
Data profiling software
to prevent dirty data by coordinating common data across multiple systems
Master data management (MDM) software
provides a mastercopy of entities,
such as customers, that appear in numerous systems throughout the organization.
Used properly, the DBMS facilitates:
Interpretation and presentation of data in useful formats by transforming raw data into information.
Distribution of data and information to the right people at the right time.
Data preservation and monitoring the data usage for adequate periods of time.
Control over data duplication and use, both internally and externally.
database’s predominant role is
Provide access to external and internal data to identify growth opportunities and to chart the direction of such growth
Provide framework for defining and enforcing organizational policies
Improve the likelihood of a positive return on investment for the company by searching for new ways to reduce costs and/or by boosting productiv
- Deliver data neccessary for tactical decision making and planning.
- Monitor and control the use of company resources and evaluate the performance of various departments
- Provide a framework for ensuring the security and privacy of data in a database
protecting the data against accidental or intentional use by unauthorized users
PRivacy deals with
rights of individuals and the organization to determine the “who, what, when, where, and how” of data usage.
-Represent and support the company operations as closely as possible
- Produce query results within specified performance levels
- Enhance the company's short term operations ability by provideing timely information for customer support and for application development and computer operations
A general objective for any database is
to provide a seamless flow of information throughout the company.
The company’s database is also known as.
the company’s data representation that provides support for all present and expected future operations
The introduction of a DBMS into an organization has been described as a process that includes three important aspects:
Technological. DBMS software and hardware
Managerial. Administrative functions.
Cultural. Corporate resistance to change.
key technological consideration in the DBMS introduction
selecting, installing, configuring, and monitoring the DBMS to make sure that it
efficiently handles data storage, access, and security.
The DP department’s task was to
The responsibilities of the IS departmant were broadened to include
integrated application or management information systems.
The two possible DBA function placements are
Line authority position
Staff consulting postion
DBA function requires personnel to cover the following activities
Database planning, including the definition of standards, procedures, and enforcement.
Database requirements gathering and conceptual design.
Database logical and transaction design.Database physical design and implementation.
Database testing and debugging.Database operations and maintenance, including installation, conversion, and migration. Database training and support. Data quality monitoring and management.
The general coordinator of all
DBAs is sometimes known as the
The ____________is responsible for controlling the overall corporate data resources, both computerized and manual
Effective data administration requires both _____ and _______ skills.
Does strategic planning
Sets long-term goals
Sets policies and standards
Is broad in scope
Focuses on the long term
Has a managerial orientation
Controls and supervises
Executes plans to reach goals
Enforces policies and procedures
Enforces programming standards
Is narrow in scope
Focuses on the short term
Has a technical orientation
Is DBMS specific
Broad business understanding
Conflict resolution skills
Broad data-processing background
Structured methodologies: Data flow diagrams, structure charts, Programming languages
Databases Life Cycle management
Data modeling and design skills
Operational skills: Database implementation, data dictionary management, security, and so on
DBA is responsible for
end user support services include:
gathering user requirements
Builing end-user confidence
Resolving conflicts and problems
Finding solutions to information needs
Ensuring the quality and integrity of data and applications
Managing the training and support of DBMS users
_____________describe the minimum requirements of a given DBA activity; they are more detailed and specific
___________are written instructions that describe a series of steps to be followed during the performance of
a given activity.
enforce procedures that cover areas such as
End-user database requirements gathering.
Database design and modeling
Documentation and naming conventions
Design testing and coding of database applications
Database software selection
Database security and integrity
Database backup and recovery
Database maintenence and operation
Procedures and standards must be revised at least __________
A ________ loss might mean that the database continues to exist but its integrity is entirely lost
database security officer(DSO)
The management of database security, integrity, backup, and recovery
sole job is to ensure database security and integrity
disaster or a database integrity failure
backup and recovery measures must include at least
Periodic data and applications backups
Proper backup identification
Convenient and safe backup storage
Physical protection of both hardware and software
Personal access control to the software of a database
Insurance coverage for the data in a database
also includes the provision of a backup computer and DBMS to be used
in case of emergency.
The DBA must establish a back-up policy to respond to two
(1) Where are the backups to be stored? (2) How long are backups to be store
The DBA is responsible for.
data are distributed to the right people, at the right time, and in the right format
________________enable the DBA to educate end users to produce the required information without being
dependent on applications programmers
Current data distribution philosophy makes it easy for________-end users to access the database
the DBA’s technical activities include
The technical aspects of the DBA’s job are rooted in the following areas of operation
The first and most important step of the evaluation and acquisition plan
DBMS storage capacity
Application development support
Security and integrity
Backup and Recovery
Database administration tools
Interoperability and data distribution
Portability and Standards
Vendor training and support
Available third party tools
transactions. Such support services include reviewing the database application design to ensure that transactions are
An_____________is a set of instructions
generated at application compilation time that predetermines how the application will access the database at run time.
Testing usually starts with.
The evaluation process covers
-Technical aspects of both the applications and the database
-Evaluation of the written documentation to ensure that the documentation and procedures are accurate andeasy to followObservance of standards for naming, documenting, and coding
Data duplication conflicts with existing data
The enforcement of all data validation rules
DBMS operations can be divided into four main areas
_______________activities cover all tasks directly related to the day-to-day operations of the DBMS and its applications
filling out job logs, changing tape, and verifying the status of computer hardware, disk
packages, and emergency power source
special programs and resource configurations for new and/or upgraded versions of database applications
To carry out the erformance monitoring and tuning tasks, the DBA must
Establish DBMS performance goalsMonitor the DBMS to evaluate whether the performance objectives are being met. Isolate the problem and find solutions (if performance objectives are not met). Implement the selected performance solutions.
The most common
bottlenecks in DBMS performance tuning are related to
management of storage resources
configuration parameters can be used to determine
system components——must be backed up
an incremental backup requires the ________________
to be useful for recovery purposes.
privileges by programmers and end users.
The DBA must periodically generate an
______________to determine whether there have been actual or attempted security violations
______________-training covers the use of the DBMS tools as well as the procedures and standards required
for database programming.
One of the most
common maintenance activities is
Current-generation DBMSs support _____ as a standard format for data exchange among database systems
refers to activities and measures to ensure the confidentiality, integrity, and availability of an information system and its main asset, data
deals with ensuring that data is protected against unauthorized access
is concerned with keeping data consistent, free of errors, or
refers to the accessibility of data whenever required by authorized users and for authorized
refers to activities
undertaken to meet data privacy and security reporting guidelines.
Data must be evaluated and classified according to the level of
highly restricted (very few people have access), confidential (only certain groups have access),
and unrestricted (can be accessed by all users)
standards, policies, and procedures created to guarantee the security of a system and ensure auditing and compliance
"The semester I found StudyBlue, I went from a 2.8 to a 3.8, and graduated with honors!"Jennifer Colorado School of Mines