scholarly journals Developing a Strategy for Imputing Missing Traffic Volume Data

Author(s):  
Mei Chen ◽  
Jingxin Xia ◽  
Rongfang (Rachel) Liu

Archived ITS-generated data can provide a potential resource for many long-term transportation applications. However, missing and suspicious data are inevitable due to detector and communication malfunctions. This paper presents a comparative analysis of various techniques for imputing missing traffic volume data in the archived data management system in Kentucky. The applicability of the techniques, as well as their reliability in terms of data requirement, is also discussed. An implementation strategy for the Kentucky archive data management system is then developed based on the performance and the applicability/reliability analyses.

2021 ◽  
Vol 28 (1) ◽  
pp. e100307
Author(s):  
Janice Miller ◽  
Frances Gunn ◽  
Malcolm G Dunlop ◽  
Farhat VN Din ◽  
Yasuko Maeda

ObjectivesA customised data management system was required for a rapidly implemented COVID-19-adapted colorectal cancer pathway in order to mitigate the risks of delayed and missed diagnoses during the pandemic. We assessed its performance and robustness.MethodsA system was developed using Microsoft Excel (2007) to retain the spreadsheets’ intuitiveness of direct data entry. Visual Basic for Applications (VBA) was used to construct a user-friendly interface to enhance efficiency of data entry and segregate the data for operational tasks.ResultsLarge data segregation was possible using VBA macros. Data validation and conditional formatting minimised data entry errors. Computation by the COUNT function facilitated live data monitoring.ConclusionIt is possible to rapidly implement a makeshift database system with clinicians’ regular input. Large-volume data management using a spreadsheet system is possible with appropriate data definition and VBA-programmed data segregation. The described concept is applicable to any data management system construction requiring speed and flexibility in a resource-limited situation.


1998 ◽  
Vol 87 (4) ◽  
pp. 837-842
Author(s):  
Jay D. McNitt ◽  
Eugene T. Bode ◽  
Richard E. Nelson

1998 ◽  
Vol 87 (4) ◽  
pp. 837-842 ◽  
Author(s):  
Jay D. McNitt ◽  
Eugene T. Bode ◽  
Richard E. Nelson

2006 ◽  
Vol 15 (02) ◽  
pp. 229-258 ◽  
Author(s):  
NUNO PREGUIÇA ◽  
J. LEGATHEAUX MARTINS ◽  
HENRIQUE JOÃO DOMINGOS ◽  
SÉRGIO DUARTE

It is common that, in a long-term asynchronous collaborative activity, groups of users engage in occasional synchronous sessions. In this paper, we analyze the data management requirements for supporting this common work practice in typical collaborative activities and applications. We call the applications that support such work practice multi-synchronous applications. This analysis shows that, as users interact in different ways in each setting, some applications have different requirements and need to rely on different data sharing techniques in synchronous and asynchronous settings. We present a data management system that allows to integrate a synchronous session in the context of a long-term asynchronous interaction, using the suitable data sharing techniques in each setting and an automatic mechanism to convert the long sequence of small updates produced in a synchronous session into a large asynchronous contribution. We exemplify the use of our approach with two multi-synchronous applications.


1981 ◽  
Vol 3 (3) ◽  
pp. 129-136 ◽  
Author(s):  
T. Ravenscroft ◽  
D.E. Smith

The paper describes the design and implementation of a clinical trial data management system at the Wellcome Research Laboratories. Based on an IBM 3031 computer, the system provides the capability for on-line data input, search ing and comprehensive data analysis. The database also performs an adverse reaction reporting function and provides for long term follow-up of patients.


2015 ◽  
Vol 39 (4) ◽  
pp. 840-841
Author(s):  
Victoria M. Hunt ◽  
Sarah K. Jacobi ◽  
Melinda G. Knutson ◽  
Eric V. Lonsdorf ◽  
Shawn Papon ◽  
...  

2020 ◽  
Author(s):  
Frances Gunn ◽  
Janice Miller ◽  
Malcolm G Dunlop ◽  
Farhat V N Din ◽  
Yasuko Maeda

AbstractPurposeThe COVID-19 pandemic posed an unprecedented challenge to healthcare systems around the world. To mitigate the risks of those referred with possible colorectal cancer during the pandemic we implemented a clinical pathway which required a customised data management system for robust operation. Here, we describe the principal concepts and evaluation of the performance of a spreadsheet-based data management system.MethodsA system was developed using Microsoft Excel® 2007 aiming to retain the spreadsheets inherent intuitiveness of direct data entry. Data was itemised limiting entry errors. Visual Basic for Applications (VBA) was used to construct a user-friendly interface to enhance efficiency of data entry and segregate the data required for operational tasks. This was done with built-in loop-back data entry. Finally data derivation and analysis was performed to facilitate pathway monitoring.ResultsFor a pathway which required rapid implementation and development of a customised data management system, the use of a spreadsheet was advantageous due to its user-friendly direct data entry capability. Its function was enhanced by UserForm and large data handling by data segregation using VBA macros. Data validation and conditional formatting minimised data entry errors. Computation by the COUNT function facilitated live data monitoring on a dashboard. During the three months the pathway ran for, the system processed 36 nodal data points for each of the included 837 patients. Data monitoring confirmed its accuracy.ConclusionLarge volume data management using a spreadsheet system is possible with appropriate data definition and VBA programmed data segregation. Clinicians’ regular input and optimisation made the system adaptable for rapid implementation.


2015 ◽  
Vol 39 (3) ◽  
pp. 464-471 ◽  
Author(s):  
Victoria M. Hunt ◽  
Sarah K. Jacobi ◽  
Melinda G. Knutson ◽  
Eric V. Lonsdorf ◽  
Shawn Papon ◽  
...  

1999 ◽  
Vol 43 (3) ◽  
pp. 137-138
Author(s):  
JAY D. McNITT ◽  
EUGENE T. BODE ◽  
RICHARD E. NELSON

2012 ◽  
Vol 83 ◽  
pp. 188-197
Author(s):  
Ke Chang Lin ◽  
Yi Qing Ni ◽  
Xiao Wei Ye ◽  
Kai Yuan Wong

The data management system (DMS) is an essential part for long-term structural health monitoring (SHM) systems, which stores a pool of monitoring data for various applications. A robust database within a DMS is generally used to archive, manage and update life-cycle information of civil structures. However, many applications especially those to large-scale structures provide little support for visualizing the long-term monitoring data. This paper presents the development of an efficient visualized DMS by integrating 4-dimension (4D) model technology, nested relational database, and virtual reality (VR) technology. Spatial data of the 4D model are organized in nested tables, while real-time (temporal) monitoring data are linked to the 4D model. The model is then reconstructed by use of an OpenSceneGraph 3D engine. A user interface is developed to query the database and display the data via the 4D model. To demonstrate its efficiency, the proposed method has been applied to the Canton Tower, a supertall tower-like structure instrumented with a long-term SHM system


Sign in / Sign up

Export Citation Format

Share Document