Quality data collection, processing, and analysis are foundational to good research, policy making and regulation development. With the rapid development of Connected Automated Vehicles (CAV) technologies, it is urgent for both researchers and policy makers to obtain and evaluate good quality CAV data to better understand CAV impacts. CAV hardware-in-the-loop (HIL) tests can expedite CAV performance evaluation and system implementation. This research aims at equipping an existing HIL test tool with data management functions. To this end, a database instance on MySQL has been integrated with an existing HIL test tool. The improved HIL test tool can greatly streamline CAV data collection and quality so that it is beneficial for performance analysis. A detailed comparison and selection of available database tools, database instance design and implementation have been performed to help other California institutes develop and improve their own systems. A user-friendly test tool setup guide and a specific user guide have been provided to enable potential users to easily get started using the data management functions. In addition, two example CAV tests are presented to demonstrate the detailed data collection and performance evaluation procedure. Those examples can serve as a guide to assist users in applying the HIL test tool in their own CAV tests.

Connected Automated Vehicles (CAVs) are similar to other automated vehicles with the distinguishing difference being that CAVs obtain information about road conditionsdirectly from other vehicles and infrastructure (e.g., traffic signals, road sensors) rather than relying solely on onboard sensors. Different CAV technologies are currently being tested and evaluated to assess the prospects for future implementation. These tests involve moving CAV-equipped vehicles on a physical test track and recording how the vehicles operate under different traffic conditions (Figure 1). Since it is difficult and expensive to recreate multiple real-world driving conditions on a single test track, virtual environments are typically used to simulate different traffic conditions, such as traffic signal operation, actions by other vehicles on the road, and other scenarios. These virtual hardware-in-the-loop (HIL) tests can expedite CAV performance evaluation and inform future system implementation; however, existing HIL test systems often lack the ability to manage large amounts of test data, which limits the value and use of these tests.