Essay: Database Memorandum
Essay: Database Memorandum
Subject: Analyzing the use of databases used in US Army Corps of Engineers
Date: 24 August 2009
Today’s world is the world of information. Advent of computer has given a fast pace to everyday businesses which make decisions using the information they have gathered previously. The complexity of applications used to support decision demands a large amount of data available to them. Also, many websites on the internet require strict access control despite them being visited by millions of users (such as mail servers). This also requires a large amount of data to be stored in an organized way so that it can be accessed easily.
For these kinds of requirements, Database Management Systems (DBMS) are used. DBMS store data in a particular way on a computer machines so that it can be accessed quickly and accurately. The purpose of this memo is to analyze the use of databases used in US Army Corps of Engineers (USACE) and suggest any improvements. The Army core of Engineer (ACE) uses DBMS such Oracle, MS SQL Server and MS Access for various tasks within itself. (Stairs & Reynolds, 2006)
Oracle is the DBMS provided by Oracle Corporation. It is an enterprise class database which means it is able to hold and manipulate data on a very large scale. An Oracle DBMS Server is used a part of system which is used by ACE to monitor the geological conditions at different places in the US. (Azotech Inc., 2008). Another Server is also used to issue and track development projects at various places in the US. The US Army knowledge portal (AKO) also uses Oracle to store its information. The databases are accessed and manipulated in various ways. For managing development projects and for the AKO, a web based system is used. (Millin Publishing, 2003)The data collected during geological monitoring as added and manipulated remotely thorough specific application designed for data collection and storage. Further improvements to the capability of storing geological and geographical data by using Oracle Spatial.
MS SQL Server
MS SQL server is product of Microsoft Corporation. It is also an enterprise class database. It is a high performance multi user database. The main implementation of MS SQL server is with the servers of our external website. It is used to store user login credentials as well as other sensitive information. Access to server for users is through web servers, using ASP (Mills, 2009). It is also used as a part of system which provides support to Directorate of Contracting and its related offices. Here, it is also used in combination with web servers (Federal Business Opportunities Website, 2007). The drawback of using SQL server is that it has a lot of known bugs which incase of public access, can be exploited to gain access to other resources. This can be overcome by installing patches to security holes as soon as they are available.