Data Output Formats

Since the primary purpose of the Knowledge Manager is to enter and maintain data to be delivered as part of an NLM contract, it is essential to provide features for extracting data from the database and generating files in a well-known format to be transmitted and read at remote computers which do not have Sybase available.

Previously when doing this work, we have used a series of custom programs and scripts to copy raw data from the database and then perform manipulations to produce the required output structures. One of the major tasks is to retrieve rows from the LINKS table and produce a file containing a tree arranged hierarchically. This is also the primary focus of the Knowledge Manager software itself; so instead of doing the same job twice I've simply added a report-writing module that gives KMan the ability to write out its display data to static files. This gives some control to the user since the files can be generated based on just a subset of the available data instead of always dumping entire trees; what is shown on the display is what is recorded to the file. Files can be written in many different formats, with the field order, delimiter characters, and so forth being defined differently for different purposes.