|
<br />;/
<br />
<br />Task R6 - Revise CRDSS Software.
<br />
<br />Approach
<br />Software to be revised in this Task falls into two categories, l) Existing low-level DMI
<br />routines, and 2) DMI Utilities, All low-level DMI routines use embedded SQL that
<br />perform selects on the database, These routines are coded in ,ec files that are translated to
<br />C by the compiler and are then put into a DMI library,
<br />
<br />DMI Utilities call the low-level routines in standard C fashion, Ideally, only the low-
<br />level routines will need to be modified because the interfaces to the utilities are governed
<br />by functionality, not data storage, However, in some cases, the functionality of a DMI
<br />Utility may need to be revised because of a change in database structure, For example,
<br />additional data items may need to be passed to a DMI Utility or a DMI Utility may be
<br />able to take advantage of a derived table,
<br />
<br />In order to test and document the software revisions, RTi will
<br />. Based on the Exhibit l, verifY the Low Level DMI Routines that require
<br />modification, Exhibit 2 contains a preliminary list by table, Note that some routines
<br />are repeated for different tables,
<br />. Schedule modifications, if possible, such that incremental upgrades in the utilities can
<br />be made and tested, ln other words, if several routines hit a modified table and can be
<br />updated without totally disrupting all the utilities, do so,
<br />. Verify that the output of each revised utility is the same as the original version created
<br />using the CRDSS database in a memorandum,
<br />
<br />Low-level DMI Coding Changes, Exhibit 2 lists the low-level DMI routines that are
<br />expected to need revision because of a difference or enhancement between the HB -
<br />CRDSS and CRDSS designs, Anticipated changes include, at a minimum, revising table
<br />names and table attribute names in the embedded SQL select statements, Other changes
<br />which may result if a table structure and/or table relationships are changed include:
<br />. the embedded SQL,
<br />. the data structures used to pass information between DMI's and user utilities,
<br />. the DMI Utilities themselves,
<br />. new code development
<br />
<br />Because the overall functionality of the HB - CRDSS database is similar to the existing
<br />CRDSS database, relatively little new code development is expected,
<br />
<br />DMI Utility Code Changes, DMI Utilities that RTi will recompile, test and perhaps
<br />modify in this Task include demandts, netresev, watright, makenet, and crdssdb, the
<br />World Wide Web database interface program, It is anticipated that crdssdb will require
<br />the most testing,
<br />
<br />0928
<br />
<br />Scope of Work, HB - CROSS, 12/11/96
<br />
<br />8
<br />
|