The Trouble Report Tracking System (TRTRACK) is a tracking, retrieval and reporting system designed to maintain Trouble Reports (TR’s) filed by one department against another.  A TR is a report of complaint filed by a department when a job, report or procedure created by another department fails its objective.  The department that owns the offending job, report or procedure then has to research and fix the broken process. Filing a TR,  working on a TR and closing a TR are procedures done using the TRTRACK system after userid and password authentication.  The system also provides for management reports that outline statistics, total hours worked on a TR by a resource(s), amongst others.  Administrative tasks can be performed, if the user logged in has administrative privileges.  Finally the user is logged out gracefully by committing all data to the database and de-authenticating the user from the system.

The entire system was implemented using Oracle Web dB 2.0 for Linux (front-end), Oracle Enterprise Server (back-end), Red Hat’s Linux 6.0 operating system and Netscape’s 4.0 browser.

Analyzing source code is an essential part of many software engineering tasks, ranging from program understanding to reverse engineering.  The purpose of the C++ Object-Relational Database is to provide software engineers with a means of generating design information from systems written in C++ in an expressive, yet non-cumbersome way.  The system consists of three components: the C++ Parser, the Program Database, and the client graphical user interface.

The system will parse programs written in C++, fill a database with the information gathered, and provide users with an interface to query the database.  Analyzing a system using compact and expressive SQL queries will allow software engineers to effectively determine design elements such as program organization, resource flow, control flow, and design metrics.