Session A7: Telemetry Data and Database Management
Location
Groningen, The Netherlands
Event Website
http://fishpassage.umass.edu/
Start Date
24-6-2015 11:20 AM
End Date
24-6-2015 11:35 AM
Description
Abstract:
One of the most overlooked but critical component of telemetry studies is database management. Database management is the cornerstone to providing accurate and creditable data for analysis. In the last decade it has become a necessary element in fisheries research as different telemetry technologies and study designs require different database needs. Researchers can quickly become overwhelmed by the sheer volume and/or complexity of data without an appropriate system of management to organize, store and make vital data accessible in real-time. Some of the tools available for data management include the Microsoft SQL Server with front-end data access through Microsoft Access or WebFOCUS. These programs offer many important functions including the ability to query specific components of data sets, generate reports by pushbutton, run repeatable programming processes and validate data in an accurate and expeditious way. They also reduce the potential for human error by the organization and automation of the process and allows for robust quality control and assurance of data sets. Microsoft Access databases can be easily utilized in the field for data entry and pushbutton data validation and reporting. Microsoft SQL Server is a more complex system typically used for larger data sets and requires a more skilled manager for proper usage.
Session A7: Telemetry Data and Database Management
Groningen, The Netherlands
Abstract:
One of the most overlooked but critical component of telemetry studies is database management. Database management is the cornerstone to providing accurate and creditable data for analysis. In the last decade it has become a necessary element in fisheries research as different telemetry technologies and study designs require different database needs. Researchers can quickly become overwhelmed by the sheer volume and/or complexity of data without an appropriate system of management to organize, store and make vital data accessible in real-time. Some of the tools available for data management include the Microsoft SQL Server with front-end data access through Microsoft Access or WebFOCUS. These programs offer many important functions including the ability to query specific components of data sets, generate reports by pushbutton, run repeatable programming processes and validate data in an accurate and expeditious way. They also reduce the potential for human error by the organization and automation of the process and allows for robust quality control and assurance of data sets. Microsoft Access databases can be easily utilized in the field for data entry and pushbutton data validation and reporting. Microsoft SQL Server is a more complex system typically used for larger data sets and requires a more skilled manager for proper usage.
https://scholarworks.umass.edu/fishpassage_conference/2015/June24/83
Comments
Presenting Author Bio: Cindy Fitzgerald is a Database Manager with 15 years of experience, over half of which have been involved in biotelemetry evaluations assessing both upstream and downstream movement of fish at hydroelectric facilities. Cindy has been responsible for database design and programming, software development and analysis, and managing data and information technology systems as it relates to project objectives. Cindy has worked with scientists in all facets of data collection, processing and management. Her areas of expertise include quality control and assurance of large fisheries data sets through SQL Server and Microsoft Access and summarized data analysis reports (annual acoustic telemetry data sets that have exceeded 100 million records).