Progress reporting is an essential management function for supporting timely corrective actions that are necessary to achieve project targeted objectives. This reporting relies primarily on data collected from project site, which can then be stored in a centralized database and subsequently used to compare actual work performed to that planned. This paper presents a developed database, which was implemented in Microsoft Access to facilitate interaction with scheduling software systems such as Microsoft Project and Primavera. The database allows for capturing multimedia data files in the form of video clips, photo images and hand written notes. These files are stored and organized in tables to relate their respective data elements to project activities. The work presented here focuses on modeling the data collected using different data acquisition technologies that encompasses 3D laser scanners, photogrammetry, radio frequency identification (RFID), bar coding, and tablet computers. The paper describes the database management model, developed to organize, store, retrieve and to process the collected data to support project tracking and control. Numerical example of an actual project is used to demonstrate the essential features and capabilities of the developed database and illustrate its support role in tracking work on site and in generating progress reports.
展开▼