Printer Friendly
The Free Library
14,381,205 articles and books
Member login
User name  
Password 
 
Join us Forgot password?

Security assistance automated resource management suite migrates to the web.


The internet continues to expand in capability and with it the federal government has expanded its E-government initiatives. Data that resided in one location and provided to other locations by mail can now be centrally located with access around the world via web-based databases. Government organizations are reviewing their data requirements and considering migration of stand-alone systems to web-based systems.

The Department of Defense (DoD) is tasked with implementing the United States United States, officially United States of America, republic (2005 est. pop. 295,734,000), 3,539,227 sq mi (9,166,598 sq km), North America. The United States is the world's third largest country in population and the fourth largest country in area.  Security Cooperation Program. The Department of Defense designated the Defense Security Cooperation Agency The Defense Security Cooperation Agency (DSCA), as part of the United States Department of Defense, provides financial and technical assistance, transfer of defense matériel, training and services to allies, and promotes military-to-military contacts.  (DSCA DSCA Defense Security Cooperation Agency
DSCA Defense Support of Civil Authorities
DSCA Differential Strain Curve Analysis
DSCA Deep Sound Channel Axis
DSCA Debt Service Coverage Account
DSCA Document Signer Certification Authority
) responsible for operational control and budgeting. DSCA utilizes security assistance organizations (SAOs) in over 105 countries around the world to help accomplish this mission. These organizations receive multiple fund allocations and are required to accurately account for all funds expended ex·pend  
tr.v. ex·pend·ed, ex·pend·ing, ex·pends
1. To lay out; spend: expending tax revenues on government operations. See Synonyms at spend.

2.
. The Department of State (DOS) budget and fiscal office provides the majority of the financial, acquisition, and contracting support. The SAO Sa´o

n. 1. (Zool.) Any marine annelid of the genus Hyalinæcia, especially H. tubicola of Europe, which inhabits a transparent movable tube resembling a quill in color and texture.
 is required to keep its own accounting records and feed them to the official accounting office, Defense Finance and Accounting Service-Denver Center (DFAS-DE DFAS-DE Defense Finance & Accounting Service - Denver (US DoD) ) in Denver, Colorado for security cooperation funds. There is a specified accounting office for each type of fund.

The Department of Defense uses a suite of software developed in-house on the Microsoft Access A database program for Windows, available separately or included in the Microsoft Office suite. Access is programmable using Visual Basic for Applications (VBA). Access can read Paradox, dBASE and Btrieve files, and using ODBC, Microsoft SQL Server, SYBASE SQL Server and Oracle data.  platform to provide feeder feeder

abbreviation for self-feeders. Used in feeding groups of animals at intervals of several days. Feed has to be dry and comminuted so that it will run down the spouts from the hopper into the troughs.
 accounting data to DFAS-DE. The software program is referred to as the Security Assistance Automated Resource Management Suite (SAARMS SAARMS Security Assistance Automated Resource Management Suite ). Each SAO is provided with a stand-alone version of this software. It can be used on one workstation or on multiple workstations connected via a local area network. United States combatant commands A unified or specified command with a broad continuing mission under a single commander established and so designated by the President, through the Secretary of Defense and with the advice and assistance of the Chairman of the Joint Chiefs of Staff.  believe that there are substantial benefits to migrating SAARMS from a stand-alone system into a web-based database with centralized processing Processing performed in one computer or in a cluster of coupled computers in a single location. Centralized processing evolved from the computers in the 1960s, which were stand-alone with all input and output in the same room.  and data storage [Marine, 2002]. This offering reviews the current database, and conducts a critical analysis of migrating SAARMS to the web. The current database review is based on the author's observations of the SAARMS program from 1995 through the present and interviews with current programmers This is a list of programmers notable for their contributions to software, either as original author or architect, or for later additions.

See also: Game programmer, List of computer scientists

 and users of the system.

Security Assistance Automated Resource Management Suite

The Security Assistance Automated Resource Management Suite is a suite of software modules to assist the SAO in managing their resources. The module designed to support the budget execution process is the only module considered in this analysis and will be hence forth be referred to simply as SAARMS. SAARMS is a database program developed using Microsoft Access. It is currently in the Access XP version. The Defense Institute of Security Assistance Management (DISAM DISAM Defense Institute of Security Assistance Management
DISAM Direct Indexed Sequential Access Method
) is responsible for development, administration, and training support of SAARMS. This module serves as the security assistance (SA) funds management system. It is also used to manage non-SA funds. The program records and limits total document value to the Obligation Authority/Fund Cite Authorization (OA/FCA OA/FCA Obligation Authority/Fund Certification Authorization ) amount and accomplishes fund control using management categories specified by the combatant commands. Obligations and disbursements are recorded in the system for internal management use and to be fed to the official accounting system.

The Security Assistance Automated Resource Management Suite serves as a feeder system for the DFAS-DE BQ accounting system. The Department of Defense considers the data residing in SAARMS as unofficial accounting information. The data in the DFAS-DE BQ system is accepted as the official accounting information. This system receives data from the DoS accounting system and SAARMS. The SAARMS feeder process is currently accomplished by the SAO generating an obligation dispersement report and data file and then transmitting those files to a central location on the Security Assistance Network (SAN). The SAN is a password protected website for use by the security cooperation community. The International Security Assistance Automated Resource Management Suite (ISAARMS ISAARMS Integrated Security Assistance Automated Resource Management Suite ) is a restricted access budget system within the SAN. Access to the SAN is limited to those with appropriate user identification and password with further access limited to ISAARMS according to according to
prep.
1. As stated or indicated by; on the authority of: according to historians.

2. In keeping with: according to instructions.

3.
 user requirements by tying access to the user identification. Country budget personnel are limited to accessing their country's data only. Unified command A command with a broad continuing mission under a single commander and composed of significant assigned components of two or more Military Departments that is established and so designated by the President, through the Secretary of Defense with the advice and assistance of the Chairman of  budget personnel are limited to accessing the data of the countries in their region. DFAS DFAS Defense Finance & Accounting Service (US DoD)
DFAS Decorative and Fine Arts Society (The Hague, Holland)
DFAS Dark Field Alignment System
DFAS Department of Fisheries and Aquatic Sciences
 budget personnel and select DISAM personnel have access to all countries' data. The SAN stores the appropriate files and then once a month consolidates all the accounting files for DFAS-DE to download into the DFAS-DE BQ accounting system.

This is a cumbersome cum·ber·some  
adj.
1. Difficult to handle because of weight or bulk. See Synonyms at heavy.

2. Troublesome or onerous.



cum
 and slow process prone to errors. DISAM receives numerous help desk requests for support at the end of each month during the upload process. The users have problems due to data corruption Data corruption refers to errors in computer data that occur during transmission or retrieval, introducing unintended changes to the original data. Computer storage and transmission systems use a number of measures to provide data integrity, the lack of errors. , internet connectivity, or operator errors from lack of continuous use. All countries are required to upload their data within a specified time frame during the month. The contractor supporting the ISAARMS is also required to process the consolidation of the countries for DFAS-DE to download within a specified time frame. If a country's data is not uploaded during the available window then the data will not be processed until the following month. DFAS-DE downloads the data and loads it into the DFAS-DE BQ accounting system. This data must also be processed in a specific time frame because DFAS-DE is required to provide the Office of Management and Budget The Office of Management and Budget (OMB), formerly the Bureau of the Budget, is an agency of the federal government that evaluates, formulates, and coordinates management procedures and program objectives within and among departments and agencies of the Executive Branch.  (OMB OMB
abbr.
Office of Management and Budget

Noun 1. OMB - the executive agency that advises the President on the federal budget
Office of Management and Budget
) with a report by a specific date each month. The feeder process is cumbersome and results in data generally being thirty days or more out of date.

Fielding routine software updates is just as cumbersome as the feeder data process. The software is only updated annually to limit the number of field installations. Each country is provided with copies of the software on CD-ROM CD-ROM: see compact disc.
CD-ROM
 in full compact disc read-only memory

Type of computer storage medium that is read optically (e.g., by a laser).
. One region of the world uses a contractor to manage their local area network (LAN (Local Area Network) A communications network that serves users within a confined geographical area. The "clients" are the user's workstations typically running Windows, although Mac and Linux clients are also used. ) and are the only ones authorized au·thor·ize  
tr.v. au·thor·ized, au·thor·iz·ing, au·thor·iz·es
1. To grant authority or power to.

2. To give permission for; sanction:
 to install software. The contractor installs software during field maintenance cycles or processes the installation for each country from a central location using remote software. When everything goes according to plan this process works fairly well. The other four regions of the world rely on the users to install their own software. The SAOs are offices of one to fifty people. The level of computer literacy Understanding computers and related systems. It includes a working vocabulary of computer and information system components, the fundamental principles of computer processing and a perspective for how non-technical people interact with technical people.  and technical support capabilities vary greatly from one country to another. The yearly installation process generally results in numerous help desk requests.

The installation of software updates is cumbersome, but the backup of data is crucial. An SAO may have thousands of transactions stored in their database. Each SAO performs a backup of their data and keeps it on a floppy disk in order to reconstitute re·con·sti·tute  
tr.v. re·con·sti·tut·ed, re·con·sti·tut·ing, re·con·sti·tutes
1. To provide with a new structure: The parks commission has been reconstituted.

2.
 their accounting data in the event the computer fails. The embassy bombing in Kenya identified the need to keep this backup file A file on a tape, removable disk or the fixed disk of another computer that is a copy kept for backup purposes. See backup types.  outside the SAO office [Marme, 2002]. The budget analyst was among those killed in the explosion. The computer housing SAARMS and the backup disk A disk used to hold duplicate copies of important files. A variety of removable media are used for backup, including floppy, Zip and Jaz disks, CD-Rs, CD-RWs and DVD-RAMs. See backup.  were destroyed in the blast along with all the original paper documents. Reconstructing the budget data was rendered impossible. Due to this catastrophe, new procedures were implemented that require the SAOs to make a backup of their data and upload it to ISAARMS at least once a month. This process is time consuming and prone to the same cumbersome tasks as the feeder data upload process. Reconstitution of data could also potentially lose data processed during the last thirty days.

Loading funding authorizations is another area that is not performed on a routine basis. The initial OA/FCA is loaded into SAARMS each October and then once each quarter. This process includes loading the legal funding limit, new expense codes, and funds allocations by OMB object class. Because this is only accomplished four times a year, the error rate is very high. SAARMS was modified to allow the unified command budget analysts to load each country's AO/FCA and email a file as an attachment to then be imported electronically into each countries SAARMS program. This has helped alleviate the errors, but is burdensome and time consuming for the combatant command. The combatant command has to load each country and create the import file one at a time. They often have to provide support via the telephone for the country budget analyst to import the file.

As noted, DFAS-DE uses the SAARMS data to feed their DFAS-DE BQ accounting system, but DSCA and the combatant commands use the data for financial analysis. DSCA and the combatant commands obtain their data from ISAARMS. Under this process the data being used is routinely up to thirty days out of date. The only way to get more timely data under the current system is to have each country upload their data more frequently. Additional uploads would require the countries to take time from other functions for the sole purpose of providing higher headquarters with more timely information.

The budget analysts in the SAOs routinely use various databases and regulations available on the internet. The current software cannot easily incorporate these resources because of the constant change in web addresses and inability of the program to initiate user access to the web when required. It is also difficult to interface multiple stand-alone databases with web-based databases. The new Defense Travel System scheduled for implementation at the SAOs next year is a prime example of a system that would benefit the SAOs if it could connect to the SAARMS.

In summary, SAARMS is a stand-alone database program with certain inherent limitations caused by lack of full interoperability The capability of two or more hardware devices or two or more software routines to work harmoniously together. For example, in an Ethernet network, display adapters, hubs, switches and routers from different vendors must conform to the Ethernet standard and interoperate with each other.  with all units involved in the budget process. Uploading feeder data information is awkward and requires monthly technical support by the users. Installation of software updates requires similar technical support. Loading OA/FCAs are prone to error and only partially helped with the unified command creating a file for import by the SAOs. Financial analysis of the countries accounting data by DSCA and the combatant commands is often limited to outdated out·dat·ed  
adj.
Out-of-date; old-fashioned.


outdated
Adjective

old-fashioned or obsolete

Adj. 1.
 information. SAARMS is also very limited in its ability to utilize available databases on the internet.

Advantages of a Web-based Security Assistance Automated Resource Management Suite

A web-based database has potential to expand the capability and effectiveness of SAARMS. Web-based databases have been efficient and effective for many public sector organizations. The internet and associated technologies can be essential tools to efficient operations of government organizations. Thuraisingham [1999] posits that electronic commerce is becoming the most important web-based information management application. Greenberg et al., [2000] demonstrated the efficiencies obtained by using an interact-based database to support Brownfield See greenfield.  redevelopment. The internet was used to efficiently and effectively input data and to interact with data input from multiple locations.

The US Department of Agriculture effectively used a web-based database to support the agrometerological field [Doraiswamy, et al, 2000]. This web-based database allowed users around the world to access the agrometerological data. It also allowed users to analyze the data using the more powerful processing capability of a central database. A web-based database containing soil test data was effectively used to provide increased access to data and faster processing to support laboratories and their clients [Motavalli et al., 2002]. The ability to work with the database via the web reduced the time required to process tests and allowed for faster more expansive analysis of available data.

Legacy databases are a valuable resource that could be better utilized if available to a broader audience using a web-based application See Web application.  [Jameson & Cook, 2002]. A web-based database can improve productivity, reduce costs, and make sharing information throughout the company easier. A web-based SAARMS would alleviate the need for users to upload feeder data and backup files through the ISAARMS system. The users in the SAOs and the combatant commands would have direct access to load data if required. This would allow the combatant commands to load the quarterly OA/FCAs in SAARMS reducing data entry errors and technical support for SAOs.

Accounting oversight is required for DFAS, DSCA, and the combatant commands. A web-based database with select queries can be used to provide accounting oversight and compliance assurance of field activities [Borthick, Jones, & Kim, 2001]. The existing SAARMS program requires each country to upload their data via the ISAARMS and the reviewing activity must download the data for each country to be analyzed an·a·lyze  
tr.v. an·a·lyzed, an·a·lyz·ing, an·a·lyz·es
1. To examine methodically by separating into parts and studying their interrelations.

2. Chemistry To make a chemical analysis of.

3.
. If the reviewing activity desires to analyze more than one country they are required to download each country's data and then merge the files together. The internet can be used to make an organization's database available throughout the world [Malaika et al., 2002]. The internet can therefore make the accounting data available to DSCA, DFAS, and the combatant commands in real time instead of the thirty day lag time currently experienced.

SAARMS is also very limited in its ability to utilize available databases on the internet. The majority of Department of Defense regulations, manuals, and publications are available on the internet. The new defense travel system will be available on the web. There are numerous government and commercial databases that are available on the internet as well. Hotel, rental car, airline, pay scales, and per diem per diem adj. or n. Latin for "per day," it is short for payment of daily expenses and/or fees of an employee or an agent.  rates are examples of databases that are utilized by the budget analysts in the SAOs. Currently SAARMS users must connect to the internet and locate these sources on their own.

Migrating SAARMS to the web would allow SAARMS to directly interact with other databases. The capability to connect multiple external databases to an organization's web-based database currently exists [Malaika et al., 2002]. A web-based SAARMS could therefore make interactions with some of these databases available to the users to obtain reference material. It could also connect directly with the databases and become integral parts of the program. This could greatly enhance the utility of SAARMS.

Security of the accounting data was identified early on in the development of SAARMS as a crucial requirement. This was achieved through the security provisions included in the database platform used in previous and existing versions of SAARMS for use on individual computers or local area networks only. Security on the intemet adds new dimensions to the problem and has been identified as a major concern when developing a web-based database [Thuraisingham, 1999], [Kulkarni & Marietta, 2000], [Papastavou et al., 2001], [Motavalli et al., 2002], [Bergstrom, 2002]. Additional security restrictions may be required to support data restriction and privacy protection [Motavalli et al., 2002].

The internet can allow an organization to share data across the organization at multiple locations with restricted access to all or portions of the data [Kulkarni & Marietta, 2000]. The web server can provide the domain level access control and user authentication See authentication. . Security can also be included at the database level. There are several database applications that support internal data security. Microsoft Access, Filemaker Pro, and Oracle all provide security within the database. Internet security ''This article or section is being rewritten at

Internet security is the process of protecting data and privacy of devices connected to internet from information robbery, hacking, malware infection and unwanted software.
 can be achieved with the aid of available applications as well. JAVA Applets A Java program that is downloaded from the server and run from the browser. The Java Virtual Machine built into the browser is interpreting the instructions. Contrast with Java application.  are one method to add security to the internet by the client downloading Refers to a software application that is downloaded from the Internet and installed in the user's computer. Although countless Internet-based applications can be performed from within a Web browser, there are many "rich client" applications that require a more powerful program in the  these applets to their computer. [Papastavou et al., 2001]. Implemented Secure Socket Layer to insure security of data as Statistics Norway This article or section needs sources or references that appear in reliable, third-party publications. Alone, primary sources and sources affiliated with the subject of this article are not sufficient for an accurate encyclopedia article.  did is another method of obtaining security [Bergstrom, 2002].

Installation of SAARMS software updates requires extensive technical support. The users would not need to install the SAARMS software on their computers if SAARMS were web-based. Bergstrom [2002] observed that installation in users computers was too complex and difficult for stand alone software but the use of the web alleviated the problem. Web technology is distributed throughout the world, it is not platform dependent, and web applications are easy to use [Jameson & Cook, 2002]. JAVA Applets could potentially be implemented for added security and would require the users to download and install [Papastavou et al., 2001]. This is one area that potentially could require some technical support. DISAM has experienced numerous download issues with JAVA Applets when clients attempted to use an Air Force developed computer security course on a database using these applets. The actual installation requirements for a web-based SAARMS would require additional research once a database platform was selected and appropriate security measures Noun 1. security measures - measures taken as a precaution against theft or espionage or sabotage etc.; "military security has been stepped up since the recent uprising"
security
 determined.

Developing a Web-based Security Assistance Automated Resource Management Suite

A web-based SAARMS will solve many problems currently associated with using a stand-alone database and provide for added efficiencies. There are costs associated with converting a legacy system to a web-based system and other issues that require consideration. Hardware, software, ease of implementation, portability, technology support, security, maintenance, and relative cost issues have all been identified as issues requiring consideration [Jameson & Cook, 2002]. Decisions on who will manage the program, who will code it, and the location of the server, will also need to be made.

DISAM centrally procures hardware for the SAOs. This hardware is configured con·fig·ure  
tr.v. con·fig·ured, con·fig·ur·ing, con·fig·ures
To design, arrange, set up, or shape with a view to specific applications or uses:
 to support running a Microsoft Access database. The SAO's would not need Microsoft Access loaded on their computer if they were only required to access the database using the internet. A lower level configuration would be adequate at the SAO level. A computer to host the server with enough capability to support a database accommodating over 100 countries' data and processing queries will be required.

Additional software will be required for loading on the server computer. There are several software programs to aid in web-based database development. Microsoft Access, Filemaker Pro, DB2, Approach, and Paradox can be used for this purpose. Microsoft Access and Filemaker Pro were identified as low cost database programs that offer easy user interface and require limited programming experience. [Kulkarni & Marietta, 2000]. Microsoft Access 97 was identified as a more powerful program for publishing on the internet than Approach 97 or Paradox 97 [Hayes & Hunton, 1999]. Microsoft Access and Filemaker Pro can be used for developing a web-based database but do not provide the best performance for searching large data fields [Kulkarni & Marietta, 2000]. DB2 supports web-based development as well [Malaika et al., 2002]. Additional research on the optimum database program will be required before selecting the appropriate development tool.

Ease of implementation is one of the drawbacks to the current SAARMS program. A web-based database could require nothing more than internet access See how to access the Internet.  and a web browser The program that serves as your front end to the Web on the Internet. In order to view a site, you type its address (URL) into the browser's Location field; for example, www.computerlanguage.com, and the home page of that site is downloaded to you.  to those items, plus some downloaded programs like JAVA Applets often required for security purposes when using JAVA. What is required to be loaded for implementation of a web-based SAARMS will be dependent on the database and Internet access programs An internet access program is a software program, generally included as part of the operating system, to access the Internet.

There are two main ways to access the Net.
  • Dial-up access; that generally uses a narrowband modem.
 used. A web-based SAARMS should be fairly easy to implement.

Portability is one of the best features of a web-based database. The SAOs, DFAS, DSCA, the combatant commands and DISAM will all have access to the same timely data from any location in the world with internet access. When a SAO's budget officer is on temporary duty at another location they can still access and update the data in SAARMS. The unified command budget officer can perform the budget functions in SAARMS for the SAO in the absence of the SAO budget officer.

Requirements for technology support would be reduced with a web-based SAARMS. Web technology is distributed throughout the world, it is not platform dependent, and web applications are easy to use [Jameson & Cook, 2002]. Technology support for users would be reduced, but additional support for the program and a new server would be required.

Security on the internet is an issue with any database. Security can be established at the database level and the domain. JAVA Applets can be used to provide security for internet access and the database development program can provide data security [Papastavou et al., 2001], [Kulkami & Marietta, 2000]. Additional research is required on the security requirements for SAARMS but will be dependent on the development program used and the security capabilities of the domain server.

Maintenance of a web-based SAARMS will be simpler than the existing program. Bug fixes A revised program file or patch that corrects a software bug. See bug, patch and hot fix.

(programming) bug fix - A change to a program or system intended to permanently cure a bug.
 can be made, tested, and immediately applied to the program without waiting for the annual release cycle. New enhancements can also be implemented when developed. There will be no requirement to provide any maintenance on programs loaded on users' computers in the field.

Who will write the code and manage the program are critical elements of developing a web-based SAARMS? SAARMS is currently managed by personnel at DISAM and could easily continue to be managed there. Writing the new code and maintaining the existing code could exceed the capacity of the small program office at DISAM. Reprioritizing workload at DISAM or contracting out the development are options that should be considered.

A decision on the location of the server is required before implementation of the program. DISAM and DSCA both have their own servers located at Wright-Patterson Air Force Base Wright-Patterson Air Force Base, U.S. military installation, 8,023 acres (3,247 hectares), W Ohio, NE of Dayton; est. 1917. One of the largest airport installations in the world, it is the air force's main research and development base, and the headquarters of the , Ohio. The Department of Defense has other sites that host servers and there are private contractors that could provide this support as well. Requirements for hours of operation, acceptable downtime The time during which a computer is not functioning due to hardware, operating system or application program failure. , and accessibility of the programmers are issues that need to be addressed before making a decision on server location.

Costs associated with any new information technology must be considered prior to development. The SAOs currently have internet access so no additional costs would be associated with use of the internet. Allocating space on an existing server would have no direct new costs, but if the purchase of a new server were required, the cost of the hardware, software and installation would have to be calculated. The maintenance costs associated with a web-based database should be similar to those of the existing program. There will be costs associated with the program effort required to modify the existing SAARMS program to make it web-based or to develop a new SAARMS program on a different database program that is web enabled. Further research is required to determine what level of security will be required to meet the users needs. Then the security costs could then be calculated.

Conclusion

The Defense Security Cooperation Agency can achieve efficiencies and increased accounting oversight of the Security Assistance Organizations' security cooperation funds through migration of the SAARMS to the web. Legacy databases like SAARMS are valuable resources that could be better utilized if available as a web-based application. [Jameson & Cook, 2002]. The internet has been successfully used to make information available for people working on Brownfield redevelopment. [Greenberg et al.., 2000]. The US Department of Agriculture was successful in the agrometerological field with the use of a web-based database as was the use of the web for soil test data [Doraiswamy et al., 2000], [Motavalli et al., 2002].

Several functions accomplished with the existing SAARMS could be done more efficiently through a web-based SAARMS. The existing system of uploading feeder data reports to the ISAARMS is slow, unwieldy, prone to errors, and the data is out of date when uploaded. A web-based SAARMS would not require the data to be uploaded because the data would be resident on the central server. This would make all the feeder data real time. Help desk requests should be reduced with the elimination of this complex process. Funding authorizations are currently loaded in the field with a high error rate. A web-based SAARMS would allow the combatant commands to load the data for the field allowing them more control of the funds and reduce the error rate. The combatant commands and DFAS are currently limited to performing accounting oversight reviews and other accounting analysis once a month. A web-based SAARMS would allow both organizations to conduct these functions at anytime with the most current information.

The existing data is vulnerable at the embassies. Time constraints In law, time constraints are placed on certain actions and filings in the interest of speedy justice, and additionally to prevent the evasion of the ends of justice by waiting until a matter is moot.  limit the number of off site backups of data to once a month by each SAO. The loss of data on site close to the end of the month would require the SAO to reconstruct re·con·struct  
tr.v. re·con·struct·ed, re·con·struct·ing, re·con·structs
1. To construct again; rebuild.

2.
 up to thirty days worth of data, if the backup documentation were available, and the complete loss of that data if the backup documentation were not available. The data on the server could be set to automatically backup locally and sent offsite as often as required.

Web-based database software could be updated as needed as needed prn. See prn order.  with bug fixes and enhancements available immediately instead of yearly with the existing difficult process of updating software. Databases and other resources available on the internet could be made available within a webbased database for enhanced features to support the SAO budget officer. SAARMS could be used from anywhere around the world. SAOs would have access to their program while on temporary duty or on leave. The combatant commands and other SAOs could perform accounting functions for another SAO while the budget officer is not available.

One problem to be addressed with the migration of SAARMS to a web-based application deals with security. Security becomes more difficult with a web-based application [Kulkarmi & Marietta, 2000]. Security at the database level and the domain level will need to be addressed. The level of security required will have to be determined based on DoD regulations and the requirements of the users. Once these requirements are determined then a decision will be required to determine the best methods to achieve that level of security.

There are four other major decisions that will have to be made prior to migration of SAARMS to a web-based application. SAARMS is currently managed by DISAM as a small database application. A decision will be required on who should manage this program in the future. The capabilities of DISAM personnel and the new requirements will need to be determined prior to this decision. A decision on who will write the code will also need to be made. DISAM does not have excess programming capacity and would require support or suspension of maintenance of the existing SAARMS in order to have time to write the new code. Depending on the software selected for development DISAM may not have the expertise to write the code. The software package for both the database and web interface will have to be decided. The location of the server will have to be determined as well.

A final consideration to make is the cost of the migration. Once the migration of SAARMS is completed the costs of maintenance should be similar to the current costs. Maintaining the database would cost the same with the exception of updates. The cost of producing and shipping CDs around the world and the time lost of help desk support for local installs would no longer exist. Added support costs would be associated with the maintenance of the server but much of this would be off set by the elimination of the requirement for the ISAARMS.

No attempt was made in this paper to make a cost analysis and financial business case for migration to the web. The available literature supports the conclusion that a web-based database can be an efficient and effective tool for public sector organizations. A web-based SAARMS offers several enhancements over the existing program. Several decisions need to be made prior to the migration of SAARMS to a web-based database. Additional research on these decision areas is required. A cost analysis considering all the costs associated with the migration and the added functionality should also be made prior to a final decision on migration of the Security Assistance Automate Resource Management Suite to a web-based application.

Bibliography bibliography. The listing of books is of ancient origin. Lists of clay tablets have been found at Nineveh and elsewhere; the library at Alexandria had subject lists of its books.  

Albers, M.J. (2000). "The Technical Editor and Document Databases: What the Future may Hold." Technical Communication Quarterly. 9 (2), 191-208.

Bergstrom, Y. (2002). "New Approaches to Data Exchange with Business." Statistics of the United Nations ECE ECE Electrical and Computer Engineering
ECE Economic Commission for Europe
ECE Ecole Centrale d'Electronique (France)
ECE Educational Credential Evaluators Inc
ECE East Central Europe
ECE Endothelin Converting Enzyme
. 19, 161-173.

Borthick, A.F., Jones, D.R., & Kim, R. (2001). "Developing Database Query Proficiency pro·fi·cien·cy  
n. pl. pro·fi·cien·cies
The state or quality of being proficient; competence.

Noun 1. proficiency - the quality of having great facility and competence
: Assuring Compliance for Response to Web Site Referrals." Journal of Information Systems. 15 (1), 35-57.

Brannon, A. (2001). "E-Government in California: Providing Service to Citizens through the Internet." Spectrum: Journal of State Government. 74 (2), 6-10.

Brown, C.C. (2002). "Building Your Database and Mounting It on the Web." Computers in Libraries. 22 (2), 10-12 & 54-56.

Cordier, E, Seo, H. & Magnenat-Thalmann, N. (2003). "Made-to-Measure Technologies for an On Line Clothing Store." IEEE Computer Society (body) IEEE Computer Society - The society of the IEEE which publishes the journal "Computer".

http://computer.org/.
. 23 (1), 38-48.

Hsieh, C. & Lin, B. (2003). "Web-Based Data Warehousing See data warehouse.

data warehousing - data warehouse
: Current Status and Perspective." Journal of Computer Information Systems. 43 (2), 1-9.

Doraiswamy, P.C. et al (2000). "Techniques for Methods of Collection, Database Management and Distribution of Agro Meteorological Data Meteorological facts pertaining to the atmosphere, such as wind, temperature, air density, and other phenomena that affect military operations. ." Agricultural and Forest Meteorology Agricultural and Forest Meteorology is an international journal for the publication of original articles and reviews on the inter-relationship between meteorology and the fields of plant, animal and soil sciences, ecology, and biogeochemistry[1] , 103, 83-97.

England, M. (2000). "A Low-Cost Library Database Solution." Information Technology and Libraries. 19 (1), 46-49.

Geerts, G.G., Waddington, B.A., & Dilley, S.C. (2000). "Sophisticated Web Design." Journal of Accountancy. 189 (4), 55-60.

Greenberg, M., Simon, D., Mayer, H. & Lowrie, K. (2000). "Internet Technology as an Aid to Neighborhood and Brownfields Redevelopment." Journal of Urban Technology, 7 (3), 19-31.

Hayes, D.C. & Hunton, J.E. (1999). "Choose the Database For You." Journal of Accountancy. 187 (1), 67-70.

Harris, S. (2003). "Managing Technology: Speaking the Same Language." Government Executive. 35 (6), 85-86.

Jameson, S. & Cook, G. (2002). "Web-Enabled Database Connectivity: A Comparison of Programming, Scripting, and Application-Based Access." Information Systems Management, 19 (1), 14-23.

Kulkarni, D. & Marietta R.B. (2000). "Integrated Functional and Executional Modeling of Software Using Web-Based Database." Transactions of the SDPS SDPS Society for Design and Process Science
SDPS Science Data Processing Segment (NASA)
SDPS Standard Data Processing System
SDPS Surface Deformation Prediction System (mining) 
. 4 (3), 1-12.

Malaika, S. et al., (2002). "DB2 and Web Services (1) Loosely, any online service delivered over the Web. Such usage appears in articles from non-technical sources, but not in IT-oriented publications, because definition #2 below describes the correct use of the term. ." IBM (International Business Machines Corporation, Armonk, NY, www.ibm.com) The world's largest computer company. IBM's product lines include the S/390 mainframes (zSeries), AS/400 midrange business systems (iSeries), RS/6000 workstations and servers (pSeries), Intel-based servers (xSeries)  Systems Journal. 41 (4), 666-686.

Marme, G.A. (2002). "Web-Based Security Assistance Automated Resource Management System." The DISAM Journal. 140-143.

McCallister, E.B. (2000). "Resource Management for the Security Assistance Organization." The DISAM Journal. 105-126.

Motavalli, P. et al (2002). "Increased Access to Soil Testing Databases Through the World Wide Web: Opportunities and Issues." Communications in Soil Science and Plant Analysis. 33 (7/8), 1157-1171.

Opasik, S.A. (2002). "Using Microsoft Access and HTML HTML
 in full HyperText Markup Language

Markup language derived from SGML that is used to prepare hypertext documents. Relatively easy for nonprogrammers to master, HTML is the language used for documents on the World Wide Web.
 to Produce Browseable Web Lists." Information Technology and Libraries. 21 (3), 127-134.

Papastavou, S. et al., (2001). "An Evaluation of the JAVA-based Approaches to Web Database Access." International Journal of Cooperative Information Systems (networking) Cooperative Information System - (CIS) Networked computers which support individual or collaborative human work, and manage access to information and computing services. . 10 (4), 401-423.

Papastavou, S., Samaras Samaras is the name of:
  • Adonis Samaras (1951-), a Greek politician
  • Antonis Samaras (1951-), a Greek politician
  • Georgios Samaras (1985-), a Greek footballer
  • Kosmos Samaras, an Australian political activist
, G. & Pitoura, E. (2000). "Mobile Agents for World Wide Web Distributed Database A database physically stored in two or more computer systems. Although geographically dispersed, a distributed database system manages and controls the entire database as a single collection of data.  Access." IEEE (Institute of Electrical and Electronics Engineers, New York, www.ieee.org) A membership organization that includes engineers, scientists and students in electronics and allied fields.  Transactions on Knowledge and Data Engineering. 12 (5), 802-820.

Rajib, P., Tiwari, D., & Srivastava, G. (2002). "Design and Development of an Integrated Supply Chain Management System in an Intemet Environment." Journal of Service Research. 2 (1), 75-94.

Roth, M.A. et al., (2002). "Information Integration: A New Generation of Information Technology." IBM Systems Journal. 41 (4), 563-577.

Sharman, C. (2002). "A Web-based Database on Australian Government and Politics." Australian Journal of Political Science. 37 (2), 347-352.

Somani, A., Choy, D. & Kleewein, J.C. (2002). "Bringing Together Content and Data Management Systems: Challenges and Opportunities." IBS IBS Irritable bowel syndrome, see there  Systems Journal. 41 (4), 686-695.

Thuraisingham, B. (1999). "Web Information Management and Its Application to Electronic Commerce." International Journal of Artificial Intelligence Tools. 8 (2), 107-118.

Tillman, B. "E-Government Bill Waits in the Wings." Information Management Journal. 36 (3), 10-14.

Westman, S. (2002). "Building Database-Backed Web Applications: Process and Issues." Information Technology and Libraries, 21 (2), 63-72.

Wolfendale, M. (2003). "Finance Portals: A View to Tomorrow's Business Strategies." Financial Executive. 19 (1), 45-48.

Wong, E.A. (2001). "How to Develop a Database for Forecasting Environmental Expenditures." Strategic Finance. 82 (9), 52-57.

Ernest B. McCallister is currently the Director of Academic Support at the Defense Institute of Security Assistance Management. He has over nine years of experience as an associate professor for the management of security assistance. His security cooperation and logistics experience includes five years at the Air Force Materiel Command Air Force Materiel Command (AFMC) is a major command of the United States Air Force.  and four years as a program and country manager at the Air Force Security Assistance Center. He has been involved with software programming and teaching of the Security Assistance Automated Resource Management Suite for over nine years. His education includes a Bachelor of Science Noun 1. Bachelor of Science - a bachelor's degree in science
BS, SB

bachelor's degree, baccalaureate - an academic degree conferred on someone who has successfully completed undergraduate studies
 from The Ohio State University Ohio State University, main campus at Columbus; land-grant and state supported; coeducational; chartered 1870, opened 1873 as Ohio Agricultural and Mechanical College, renamed 1878. There are also campuses at Lima, Mansfield, Marion, and Newark. , a Masters of Business Administration from the University of Toledo National recognition
In its 125-year history UT has garnered several national accolades. The University’s programs, faculty and facilities have been highlighted in the media, including
, and is currently a Doctoral Candidate at Walden University Walden University is a private, for-profit, specialized distance learning institution of higher learning. Headquartered in the Mills District in Minneapolis, Minnesota, Walden University embraces a post-baccalaureate educational system. .
COPYRIGHT 2003 Defense Institute of Security Assistance Management
No portion of this article can be reproduced without the express written permission from the copyright holder.
Copyright 2003, Gale Group. All rights reserved. Gale Group is a Thomson Corporation Company.

 Reader Opinion

Title:

Comment:



 

Article Details
Printer friendly Cite/link Email Feedback
Author:McCallister, Ernest B.
Publication:DISAM Journal
Date:Dec 22, 2003
Words:5234
Previous Article:Approaching the need for defense reform: early lessons learned in Estonia.(Perspectives)
Next Article:Parts repair ordering system.(Education And Training)
Topics:



Related Articles
Dave Carey.(Director of International Studies at Defense Institute of Security Assistance Management retires)(Brief Article)
Navigant International Implements Altiris Client Mgmt Suite to Deploy and Maintain Software Applications on Thousands of Travel Agent Desktops.
Powerquest Deploycenter 5.01 supports XP. (Tools).(Brief Article)(Product Announcement)
INTEGRIS Health Selects NetIQ Security Solutions for Fast Track to HIPAA Compliance.
Don't hesitate to automate: lower storage costs by automating storage resource and data management. (Automated Storage Management).
Best practices for implementing data lifecycle management solutions.(Tape/Disk/Optical Storage)
Marimba six.(IT News)
Newmerix Corporation Launches First Two Products in Its Automate! Software Suite.
Information lifecycle management: the next wave.(First In/First Out)
Case Execution Management System--a new direction.(EDUCATION AND TRAINING)

Terms of use | Copyright © 2009 Farlex, Inc. | Feedback | For webmasters | Submit articles