Rdbms

RDBMS

Organization need that Management Information Systems that would give them a “competitive strength”. Simply computerizing the back office or the front office operations is no longer sufficient. The need is to handle an on-line operations, mission control applications and exercise the operational and management control. The need demands a tool to effectively handle both the transaction processing and data processing requirements. It also requires the capability if dealing with hundreds of users who are using, and updating a large database. The need further demands the use of multiple database residing on the hardware platform situated at different locations-nearby sites and remote sites.

The decision making is required more in a real time environment where the decision process, right from the problem definition to solution, needs to be handled quickly. The business environment is distributed and decentralized requiring a real time resource(hardware, software, data, information) sharing with a complex data flow. All this demands the RDBMS which can serve both the decision support and the transaction processing requirements.

The latest RDBMS systems have two subsystems or parts. One deals with data management and transaction processing which is independent of its applications in the information processing. The second part provides a set of tools for developing and utilizing on-line applications for the decision support. This is handled by the client-server architecture which separates the data management functions from its applications. The data management function is handled by the server and the applications are handled by the client. The server centrally enforces for integrity, security and autonomy rules and the client(User) makes use of the databases over the networks of heterogeneous hardware.

The latest trend in the Information Technology is to make the end user competing simple, easy to understand and easy to use. The concept is extended to...