Method and system for agricultural data collection and management
View Patent ↗A system and method for agricultural data collection and management is described to provide quality assurance source verification data and performance tracking for agricultural items throughout the production cycle. Individual item data is efficiently collected, transferred, and shared in a transactional, event-oriented, row-oriented structure with few columns without need for creating relational structures. The system includes software components for data collection and real-time data lookup components; share, switch, route, and interface components; extract, transform, and load components; and report and analyze data components. Embodiments include data acquisition from multiple RFID reader locations; a web-based information system for a beef marketing alliance; value-based procurement, and supply chain management.
1. A method for tracking a product in a supply chain, the method comprising the steps of:
capturing identification data uniquely identifying the product and event data relating to a supply chain process step for the product, via a data collection tool;
establishing a data collection interface between the data collection tool and a relay database, the data collection interface providing the relay database with access to the identification data and the event data;
storing the identification data and the event data in the relay database;
receiving a product tracking request from a reporting tool;
establishing a data conversion interface between the relay database and the reporting tool, the data conversion interface providing the reporting tool with access to the identification data and the event data stored in the relay database; and
transmitting the identification data and/or the event data stored in the relay database to the reporting tool via the data conversion interface according to the product tracking request.
2. The method of claim 1 , further comprising the step of authenticating the product tracking request.
3. The method of claim 1 , further comprising the step of extracting the identification data and/or the event data from the relay database.
4. The method of claim 1 , further comprising the step of generating a report using the identification data and/or the event data according to the product tracking request.
5. The method of claim 1 , further comprising the step of mining the identification data and/or the event data stored in the relay database.
6. A system for tracking a product in a supply chain, comprising:
a relay database configured to store identification data uniquely identifying the product and event data relating to a supply chain process step for the product;
a data collection tool configured to capture the identification data and the event data;
a data collection interface between the data collection tool and the relay database, the data collection interface providing the relay database with access to the identification data and the event data; a reporting tool configured to generate a product tracking request; and
a data conversion interface between the relay database and the reporting tool, the data conversion interface providing the reporting tool with access to the identification data and the event data stored in the relay database, and transmitting the identification data and/or the event data stored in the relay database to the reporting tool according to the product tracking request.
7. The system of claim 6 , wherein the reporting tool is a software application.
8. The system of claim 6 , wherein the reporting tool is an enterprise resource planning (ERP) software application.
9. The system of claim 6 , wherein the reporting tool is a business-to-business software application.
10. The system of claim 6 , wherein the data collection tool further comprises a radio frequency identification (RFID) apparatus, and wherein the identification data further comprises an RFID tag number.
11. The system of claim 6 , wherein the identification data further comprises deoxyribonucleic acid (DNA) information.
12. The system of claim 6 , wherein the data collection tool further comprises a barcode reader apparatus, and wherein the identification data further comprises a barcode.
13. The system of claim 6 , wherein the product tracking request further comprises one of a bank request, an insurance request, a health request, a procurement request, or a marketing request.
14. The system of claim 6 , wherein the event data further comprises product weight data.
15. The system of claim 6 , wherein the event data further comprises product ultrasound data.
16. The system of claim 6 , wherein the data collection tool further comprises the AGINFOLINK™ BEEFLINK® data collection and management system.
17. The system of claim 6 , wherein the data conversion interface reformats the identification data and/or the event data based upon the reporting tool.
18. The system of claim 6 , wherein the data collection tool further comprises a manual input system.
19. The system of claim 18 , wherein the data collection tool further comprises the AGINFOLINK™ CATTLECARD™ data collection system.
20. The system of claim 6 , wherein the data conversion interface further comprises an authentication module.
21. The system of claim 6 , wherein the data conversion interface further comprises a data extraction module.
22. The system of claim 6 , wherein the data conversion interface further comprises a report generation module.
23. The system of claim 6 , wherein the date conversion interface further comprises a data mining module.