Database_Systems

Database systems help to organize information on a computer. Database systems allow an organization to be able to run smoothly, this means that database systems give a convenient way to handle business transactions. The Database systems that are used in my workplace are the DBMS. The DBMS helps us to support, organize, store, delete or retrieve the data in a database. Database architecture describes the architectures of data structures; this means that the database architecture describes the different aspects of a database and how it all put together or organized. For the database in my workplace the architecture they fall under is the DBMS architecture which consists of the external level, conceptual level, and the internal level. The external and conceptual levels focus on and serve the DBMS users while the internal level is effective implementation details. Relational database architecture is a protocol set that allows multiple database systems and application programs to work together. Database Management Systems data collection, organization, maintenance and, dissemination is crucial to an agencies daily operation and fiscal well-being. Operating Systems: The DBMS reside on two operating systems; AIX and Windows. The AIX mainframe maintains all of the patient’s information. The mainframe is ideal for this particular function since all users access one system, maintain the same patient data and, provides the output necessary to provide patient information and billing information. The Windows systems are also well suited for their functions. However, since various user interfaces or DBMS applications are used these management systems have differing operating system requirements for their respective databases. As such we have databases residing on three different versions of Windows; Windows 2000, Windows 2003 and, Windows 2008. Design and Function virtually all of the databases have three distinct versions. We maintain a test system, training system and, production system. The test system or test upgrade system exists primarily to test new modules and patches supplied by either the application vendor or the operating system vendors. The training and production systems are self-explanatory. These three systems, using a stepped approach, give us an opportunity to provide a measure of safety with software upgrades and user error before either affects the production systems. There is one AIX database, which is accessed via an application called CMHC. We also have nine SQL databases residing on our three database systems accessed by applications such as Mas500, Abra, and eRequester. We also utilize Active Directory and Microsoft Exchange for our domain and email services respectively. References: Date, C. J. An Introduction to Database Systems, Eighth Edition, Addison Wesley, 2003. Galindo, J., Ed. Handbook on Fuzzy Information Processing in Databases. Hershey, PA: Information Science Reference (an imprint of Idea Group Inc.), 2008. http://www.databasesystems.info/