How does DBMS help as a tool in building application systems in an organization?
A DBMS provides
a base on which to build a management information system, a production
control system, a customer support system, or any application involving
substantial data handling. It is a tool for managing data in any sort
of application environment and making data available to the using environment.
Breaking down a DBMS into various functions reveals a collection of
tools tools for different types of users and tools for different
kinds of applications. Although a DBMS is used in building a management
information system, it alone does not constitute an MIS.
While a DBMS is not an MIS, the model presented here reflects the realities of business organizations, management information systems, and decision making. A DBMS is an application independent tool. It is general purpose tool for managing data in any environment to define, store retrieve update and redefine data. A DBMS by itself is like an empty box, it has form without content. There is no database, no defined, no defined update transactions and no reports. After acquiring a DBMS an organization first defines and creates a stored database, then defines the transactions to be processed and the reports to be produced and develops programs to perform the special application processing for the users in the organization. A DBMS with these additions yields a database oriented application system which can then serve the users in the organizational environment.
The functional completeness of the DBMS determines how much additional work the user must do to build a database application system. With a DBMS providing a low level of capability, the user must compensate by devoting more effort and resources to developing the application system. By analogy, a builder with sand, bricks, mortar, water, nails and wood has considerable flexibility but expends much effort in building a house. With prefabricated rooms walls cabinets etc, it takes much less effort to build a house. For that special room, you can still use the flexible, low level building blocks.
A Database Application
The concept of a
user role permits a separation of the person from the activities and
the skills needed. User roles have direct contact with the facilities
of the DBMS. The database administrator role differs from a user role
by acting as an agent for a community of users. User roles are divided
into nonprogramming and programming users, a distinction based upon
whether or not the user writes a program in the DBMS command language
or in a conventional programming language such a COBOL or FORTRAN. Generally
nonprogramming users would account for most system use. However the
programming user plays an important role.
Copyright - © 2005 - 2018 - www.management-hub.com