Laserfiche WebLink
a ~.. <br />O ~~ <br />Task 153 -Review and Test Stored Procedures for All Queries <br />Objective: <br />Review and test stored procedures for all CDSS tools that interact with HydroBase. <br />Background: <br />The State of Colorado has recommended using and begun development of stored <br />procedures to access data from HydroBase. Therefore the Sl?DSS Year 2 efforts <br />implemented a framework to support stored procedures in Java programs. However, <br />limited resources for State IT staff have prevented stored procedures from being reviewed <br />and tested (when implemented, the software will use them automatically). Also, software <br />such as TSTooI and StateView provide open-ended (dynam;ic) query abilities that are not <br />easily supported by stored procedures and need further revie;w. <br />Additionally, the State is moving away from Microsoft Acaess databases in favor of SQL <br />Server Express, for databases provided to non-state HydroBase users. The former does <br />not support stored procedures while the latter does. Moving; to SQL Server Express will <br />require system enhancements. <br />Approach: <br />The following activities will allow full support for stored procedures: <br />153.1 Review and Test Stored Procedures. Coordinate with State IT staff to review <br />and test the use of stored procedures in all CDSS software that interacts with <br />HydroBase (StateView/CWRAT, StateDMI, TSTooli), while enhancing some <br />query screens. <br />153.2 Support State During SQL Server Express Implementation. Provide support <br />to the State IT staff during the implementation of S~-L Server Express databases, <br />to replace Microsoft Access databases. This effort will include software <br />modifications to support database configurations. It is expected that this effort <br />will not include major modifications to software -only changes to allow <br />connections with the new databases will be implemented. <br />153.3 Documentation and Software Release. Update the software documentation and <br />issue a software release to the State of Colorado and CDSS contractors. <br />Deliverables: <br />153.1 Updated StateView/CWRAT, StateDMI, and TSTooI software, to support full <br />stored procedure use. The stored procedures developed by the State will be tested by <br />RTi. <br />153.2 Support provided to the State in order to implement :HydroBase in SQL Server <br />Express. <br />153.3 Updated Java software, with documentation. <br />16 <br />