Use of Enterprise DBMS

¶ … Enterprise Database Management System This master's level paper discusses The Use Of Enterprise Database Management System and outlines the ways in which an enterprise DBMS may be used by a Government contracting Company to expand its business. The paper also highlights the attracting features and functionality offered by a DBMS. The Use Of Enterprise Database Management System Every organization in the world today stores, retrieves and manages colossal amount of data. The best way for an organization to manage data is to use Database Management Systems.

The DBMS is a complex software system, which constructs, expands and maintains the database. It also provides the link, or interface, between the user and the data in the base. The ability to store and access great amount of data in an efficient manner is being used to refine and improve activities at strategic, tactical and operational levels. For example, a Government Contracting Company, which is working with other contracting companies, may uses enterprise DBMS in marketing. With the help of DBMS, database marketing in retailing would be well developed.

While dealing with numerous other companies, a Government Contracting Company would have to be very particular about credit analysis, fraud detection, targeted marketing, banking and many other applications. Here, an enterprise DBMS could prove to be extremely useful for the organization. The three most attracting features of a Database Management System are as follows, Centralized data management, Data independence, and Systems integration (Gopal Gupta, Advantages Of Using A DBMS). DBMS renders the interface between the application program and the data.

If the Government Contracting Company plans to expand its business, then a DBMS would make the data representation for the users and the developers a lot easier. If any changes are made to the data representation, the metadata maintained by the DBMS would automatically be modified and the DBMS would persevere to render data to application programs in the usual manner. "Hence, unlike previous databases the DBMS handles the task of transformation of data wherever necessary" (Gopal Gupta, Advantages Of Using A DBMS).

The independence provided by the DBMS between the program and the data is referred to as data independence. Data independence can easily be understood by firstly considering its opposite. Applications that were implemented in the older systems were very much data dependent. The way the data was physically represented in the secondary storage and the techniques employed in accessing it, were both dictated by the requirements of the application under consideration, and moreover that knowledge of the physical representation and the access technique were built into the application code.

Gopal Gupta in his article states that, "Data independence is important because every time some change needs to be made to the data structure, the programs that were being used before the change would continue to work. To provide a high degree of data independence, a DBMS must include a sophisticated metadata management system" (Gopal Gupta, Advantages Of Using A DBMS). Hence, this feature would considerably be useful to the Government Contracting Company.

The employees working in the organization would not have to trained again and again if any changes were to be made to the data structure, since the applications employing it would continue to work in the previous way. Hence, the Government organization would not have to invest financially in order to train its workers. If the organization were to expand its business on the web, then every click of the customer may be recorded in the database with the help of an enterprise DBMS.

Hence, the enterprise DBMS would prove to be both responsive, timely and mission critical to uphold the corporate objectives. Expanding the business on the web would result in a lot of incoming data, since many people would be accessing a particular application at a time. Hence, the two attracting features of an enterprise DBMS that would really come in handy for an organization that is expanding business on the web, are scalability and efficiency. Enterprise DBMS provides the competency to perform analytic operations more efficiently.

The will greatly be beneficial for businesses. An enterprise DBMS can be employed to architect multitier applications. Another important use of an enterprise DBMS is redundancy check. In conventional data systems, an organization often builds a collection of application programs often created by different programmers and requiring different components of the operational data of the organization. The data in conventional data systems is often not centralized. Some applications may require data to be combined from several systems.

These several systems could well have data that is redundant as well as inconsistent. Data inconsistencies are often encountered in everyday life. For example, we have all come across situations when a new address is communicated to an organization that we deal with, we find that some of the communications from that organization are received at the new address while others continue to be mailed to the old address. Combining all the data in a database would involve reduction in redundancy as well as inconsistency.

It also is likely to reduce the costs for collection, storage and updating of data (Gopal Gupta, Advantages Of Using A DBMS). Enterprise DBMS aims at providing better services to its users. DBMS ripostes to any unexpected information requests. The ability to quickly obtain new and combined information is becoming increasingly important in an environment where various levels of governments are requiring organizations to provide more and more information about their activities.

An organization running a conventional data processing system would require new programs to be written to meet every new demand (Gopal Gupta, Advantages Of Using A DBMS). The cost of maintaining and developing a DBMS for any organization is not very costly. Hence, the government organization employing such a system would be able to attain maximum benefits with small investments. A DBMS provides both security and data integrity. "Setting up of a database makes it easier to enforce security restrictions since the data is now centralized.

It is easier to control who has access to what parts of the database. However, setting up a database can also make it easier for a determined person to breach security" (Gopal Gupta, Advantages Of Using A DBMS). Government Contracting Company working with other companies will surely constitute of many departments and units. Every department or unit considers its work most significant. "Hence,.