Database Management Systems
Data collection, organization, maintenance and, dissemination is crucial to our agency's daily operation and fiscal well-being. Our database management systems (DBMS) maintain data on over 1300 employees, as well as, thousands of patients. The accuracy of our data is paramount to appropriate patient care and supporting ourselves financially.
Our DBMS reside on two operating systems; AIX and Windows. The AIX mainframe maintains all of our patient 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 our 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.
We have 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. These bear mentioning since they are both based on databases however,