Database Management
data administration
a data resource management function that includes responsibility for developing and maintaining the organization’s data dictionary, designing and monitoring the performance of databases, and enforcing standards for database use and security
data dictionary
a software module and database containing descriptions and definitions concerning the structure, data elements, interrelationships, and other characteristics of an organization’s databases
data modeling
a process where the relationships between data elements are identified and defined to develop data models
data planning
a corporate planning and analysis function that focus on data resource management. It includes the responsibility for developing an overall information policy and data architecture for the firm’s data resources
data resource management
a managerial activity that applies information systems technology and management tools to the task of managing an organization’s data resources. Its three major components are database administration, data administration, and data planning.
database administration
a data resource management function that includes responsibility for developing and maintaining the organization’s data dictionary, designing and monitoring the performance of data bases, and enforcing standards for database use and security
database administrator
a specialist responsible for maintaining standards for the development, maintenance, and security of an organization’s databases
database management approach
an approach to the storage and processing of data in which independent files are consolidated into a common pool, or database, of records available to different application programs and end users for processing and data retrieval
database management system (DBMS)
a set of computer programs that controls the creation, maintenance, and utilization of the databases of an organization
database structures
hierarchical
a logical data structure in which the relationships between records form a hierarchy or tree structure. The relationships among records are one-to-many, since each data element is related only tone element above it
network
a logical data structure that allows many-to-many relationships among data records. It allows entry into a database at multiple points, because any data element or record can be related to many other data elements
multidimensional
a database model that uses multidimensional structures (such as cubes or cubes within cubes) to store data and relationships between data
object-oriented
relational
a logical data structure in which all data elements within the database are viewed as being stored in the form of simple tables. DBMS packages based on the relational model can link data elements from various tables as long as the tables share common data elements
database and file access
direct
a method of storage where each storage position has a unique address and can be individually accessed in approximately the same period of time without having to search through other storage positions
sequential
a sequential method of storing and retrieving data from a file
DBMS uses application development: developing information systems by a process of investigation, analysis, design, implementation, and maintenance. Also called systems development life cycle (SDLC), information systems development, or systems development
database development: database interrogation database maintenance
key field
one or more fields within a data record that are sued to identify it or control its use
logical data elements data elements that are independent of the physical media on which they are recorded character: the smallest data element field: a data element that consists of grouping of characters that describe a particular attribute of an entity. For example: the name field or salary field of an employee record: a collection of related data fields treated as a unit file: a collection of related data records treated as a unit. Sometimes called a data set. Database: a collection of logically related records or files. A database consolidates many records previously stored in separate files so that a common pool of data records serves many applications
query language
a high level, human like language provided by a database management system that enables users to easily extract data and information from a database
report generator
a feature of database management systems packages which allows an end user to quickly specify a report format for the display of information retrieved from a data base
types of databases
analytical: a database of data extracted from operational and external databases to provide data tailored to online analytical processing, decision support, and executive information systems
end user: external image data warehouse: a central source of data that has been extracted from various organizational databases and standardized and integrated for use throughout the organization
multimedia operational text
This page was created by David Lewis on 6/18/97