Method and system for agricultural data collection and management
First Claim
1. A distributed transactional database to support an information backbone in an agricultural supply chain, the database comprising:
- a first database containing a first portion of data associated with a particular agricultural item, the first database comprising a plurality of rows, each row comprising A unique item identification element, A unique event identification element, A parent identification, A date and time of the event, An event, An event detail, and An entity identification; and
a second database containing a second portion of data associated with the item or a product transformation of the item, the second database comprising a plurality of rows, each row comprising A unique item identification element, A unique event identification element, A parent identification, A date and time of the event, An event, An event detail, and An entity identification.
3 Assignments
0 Petitions
Accused Products
Abstract
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.
224 Citations
32 Claims
-
1. A distributed transactional database to support an information backbone in an agricultural supply chain, the database comprising:
-
a first database containing a first portion of data associated with a particular agricultural item, the first database comprising a plurality of rows, each row comprising A unique item identification element, A unique event identification element, A parent identification, A date and time of the event, An event, An event detail, and An entity identification; and
a second database containing a second portion of data associated with the item or a product transformation of the item, the second database comprising a plurality of rows, each row comprising A unique item identification element, A unique event identification element, A parent identification, A date and time of the event, An event, An event detail, and An entity identification.
-
-
2. A system for sharing information in an agricultural supply chain, the system comprising:
-
a plurality of application programs associated with the supply chain;
at least one transactional event database comprising a plurality of rows, each row comprising a unique item identification element, a unique event identification element, a date and time of the event, an event, an event detail, and an entity identification; and
an information backbone connecting the event transactional database structure and the application programs with layered protocols and services including an interconnectivity means for connecting the database and each application program, an audit trail means for determining the integrity of the data records and the database, a means for processing the data, a means for routing the data to a user, a means for archiving data, a means for consolidating and reporting data, and a means for brokering private network links. - View Dependent Claims (3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A system for sharing information in an agricultural supply chain, the system comprising:
-
a plurality of application programs associated with the supply chain;
a plurality of transactional event databases, each database comprising a plurality of rows, each row comprising a unique item identification element, a unique event identification element, a date and time of the event, an event, an event detail, and an entity identification; and
an information backbone connecting the event transactional database structure and the application programs with a series of layered protocols and services including an application program interface, a secure socket layer, a data exchange protocol such as XML, a tamper-evident layer, a data integrity layer, a data filtering layer, a data map/translate/normalize layer, a data permission layer, a data routing layer, an archive and change management layer, an aggregation, consolidation, and reporting layer, a data benchmarking layer, and a brokering private network links layer. - View Dependent Claims (15, 16, 17)
-
-
18. A method for interconnecting application programs across different food production supply chain entities, the method comprising
providing at least one transactional event database, the database comprising a plurality of rows, each row comprising a unique item identification element, a unique event identification element, a date and time of the event, an event, an event detail, and an entity identification; - and
establishing an information backbone between the database and the application programs by providing a means for interconnectivity between the database and each application program, providing an audit trail means for determining the integrity of the data records and the database, providing a means for processing the data, providing a means for routing the data to a user, providing a means for archiving data, providing a means for consolidating and reporting data, and providing a means for brokering private network links. - View Dependent Claims (19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31)
- and
-
32. A method for interconnecting application programs across different food production supply chain entities, the method comprising
providing a plurality of one transactional event databases, each database comprising a plurality of rows, each row comprising a unique item identification element, a unique event identification element, a date and time of the event, an event, an event detail, and an entity identification; - and
connecting the event transactional database structure and the application programs with layered protocols and services by providing an application program interface, providing a secure socket layer, providing a data exchange protocol such as XML, providing a tamper-evident layer, providing a data integrity layer, providing a data filtering layer, providing a data map/translate/normalize layer, providing a data permission layer, providing a data routing layer, providing an archive and change management layer, providing an aggregation, consolidation, and reporting layer, providing a data benchmarking layer, and providing a brokering private network links layer.
- and
Specification