Description: The ACS Seedpak™ archive utility allows for the data to be extracted from the production database and stored temporarily in tables only to be archived to ASCII files. A Byte of Advice has developed an archive utility that goes a step further, usability. The ArchiverTM allows the user to extract data from the production database and store the information in accessible tables. The current system you are running to access the production data is used to access the archived data. The ArchiverTM then allows the user to create ASCII data files to off-load the data onto tape or other devices. The ArchiverTM allows you to reverse the process. The Archiver can load the ASCII files back into the archive tables and load the archive data back onto the production tables. This complete functionality provides the required usability and control of all electronic data.

Audience: Who should use A Byte of Advice’s The ArchiverTM? Anyone who values their electronic data! The electronic data is used everyday in your laboratory for printing reports for clients and internal use. Historical data is often needed to report trends or even for clients who’ve lost reports and need copies. No need to rummage through your paper copies, just use The ArchiverTM to re-print them.

Recommended Knowledge: The user of The ArchiverTM needs only to understand how to fill in the blanks. A simple form with reports is how The ArchiverTM does its magic. Just tell The ArchiverTM start and end dates of data you want to archive then press the commit key. Its that simple.

Details: The ArchiverTM allows for complete control of your data. You supply the rules for what can be archived once and The ArchiverTM responds and follows the directions always. Grouping of data is usually by the received date and invoiced. Although, this can be altered to fit your laboratories methods and needs.

Over time, laboratories are forced to change data handling methods in order to evolve and maintain industrial compliance. This leads to problems extracting historical/archived data, slowing down production and/or increasing head count. Utilizing The ArchiverTM, complete data is archived including the maintenance tables. With all the tables in the archive database, the laboratory can access the data as if it were in the production tables allowing all the functionality of the production system whether changes/customizations have been made to the database or not.

The ArchiverTM creates readable ASCII files. These files can be used by other systems to load the data. This makes The ArchiverTM more than just an archive utility. Data can now be transferred, loaded and used by other systems. Or, just save the ASCII files onto another media to be used later or just to keep your database clean and running optimally.

Summary: The ArchiverTM is the way to go for archiving data and keeping the data usable and in reach. A clean production database will keep the day-to-day operations running faster and smoother. No more running out of disk space. No more running out of table space. No more running out of extents. The ArchiverTM keeps the database clean.

Realization: The ArchiverTM is an Oracle SQL*Forms™ and ACS IDXL™ script module that attaches to your existing ACS Seedpak™ system. All source code is yours and modifiable. The cost of The ArchiverTM is time and materials. Contact us to schedule loading The ArchiverTM onto your system.