|
|||||
|
|||||
MANAGEMENT OPPORTUNITIES, CHALLENGES, AND SOLUTIONS
Opportunities Solution Guidelines The critical elements for creating a database environment are (1) data administration, (2) data-planning and modeling methodology, (3) database technology and management, and (4) users. This environment is depicted in Figure 7-18.
DATA ADMINISTRATION Database systems require that the organization recognize the strategic role of information and begin actively to manage and plan for information as a corporate resource. This means that the organization must develop a data administration function with the power to define information requirements for the entire company and with direct access to senior management. The chief information officer (CIO) or vice president of information becomes the primary advocate in the organization for database systems. Data administration is responsible for the specific policies and procedures through which data can be managed as an organizational resource. These responsibilities include developing information policy, planning for data, overseeing logical database design and data dictionary development, and monitoring how information systems specialists and end-user groups use data. The fundamental principle of data administration is that all data are the property of the organization as a whole. Data cannot belong exclusively to any one business area or organizational unit. All data should be available to any group that requires them to fulfill its mission. An organization needs to formulate an information policy that specifies its rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information throughout the organization. Information policy lays out specific procedures and accountabilities, specifying which organizational units share information, where information can be distributed, and who is responsible for updating and maintaining the information. Although data administration is a very important organizational function, it has proved very challenging to implement. DATA-PLANNING AND MODELING METHODOLOGY The organizational interests served by the DBMS are much broader than those in the traditional file environment; therefore, the organization requires enterprise-wide planning for data. Enterprise analysis, which addresses the information requirements of the entire organization (as opposed to the requirements of individual applications), is needed to develop databases. The purpose of enterprise analysis is to identify the key entities, attributes, and relationships that constitute the organization’s data. These techniques are described in greater detail in Chapter 14. DATABASE TECHNOLOGY, MANAGEMENT, AND USERS Databases require new software and a new staff specially trained in DBMS techniques, as well as new data management structures. Most corporations develop a database design and management group within the corporate information systems division that is responsible for defining and organizing the structure and content of the database and maintaining the database. In close cooperation with users, the design group establishes the physical database, the logical relations among elements, and the access rules and procedures. The functions it performs are called database administration. A database serves a wider community of users than traditional systems. Relational systems with user-friendly query languages permit employees who are not computer specialists to access large databases. In addition, users include trained computer specialists. To optimize access for nonspecialists, more resourcesmust be devoted to training end users. |