US 6,995,675 B2 · Method and system for agricultural data collection and management

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.

Claims32

Dependent claims

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.

14 more elements

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.

13 more elements

Dependencies are inferred from the claim text.

Method and system for agricultural data collection and management

Life of this patent

Method and system for agricultural data collection and management

Life of this patent

Abstract

Claims32