Methods and systems for reconciling data

Information

  • Patent Application
  • 20050283502
  • Publication Number
    20050283502
  • Date Filed
    June 18, 2004
    20 years ago
  • Date Published
    December 22, 2005
    18 years ago
Abstract
Systems and methods are disclosed for reconciling data. The disclosed systems and methods may include receiving a first data corresponding to an expected state of at least one of a plurality of objects. Furthermore, the disclosed systems and methods may include creating a second data corresponding to an actual state of the at least one of the plurality of objects and comparing the first data to the second data to determine if the actual state corresponds to the expected state. In addition, systems and methods are disclosed for determining and applying rules to data. The disclosed systems and methods may include receiving a data comprising a root element and at least one leaf element, the root element having attributes and the attributes comprising characteristics. Furthermore, the disclosed systems and methods may include selecting a condition table based upon the characteristics, selecting a first ruleset based upon the selected condition table, and applying rules defined by the selected first ruleset to the data.
Description
BACKGROUND OF THE INVENTION

I. Field of the Invention


The present invention generally relates to methods and systems for reconciling data. More particularly, the present invention relates to reconciling data and determining and applying rules to the data.


II. Background Information


Reconciling data and determining and applying rules to the data, for example, may be a process used in shipping and receiving objects. For example, this process may be used in packaging goods and sending the goods to a warehouse or retail store. In some situations, however, little attention may be paid to the receiver's expectations for the goods versus the sender's expectations for the goods as sent. For example, the sender may package the goods and send the package to the receiver with very little concern for how the goods are received. Thus, the conventional strategy is to ship goods from the sender to the receiver. This often causes problems because the conventional strategy, for example, may not efficiently reconcile the sender's and receiver's expectations.


In view of the foregoing, there is a need for methods and systems for reconciling data more optimally. Furthermore, there is a need for reconciling data and determining and applying rules to the data.


SUMMARY OF THE INVENTION

Consistent with embodiments of the present invention, systems and methods are disclosed for reconciling data and for determining and applying rules to the data.


In accordance with one embodiment, a method for reconciling data comprises receiving a first data corresponding to an expected state of at least one of a plurality of objects, creating a second data corresponding to an actual state of the at least one of the plurality of objects, and comparing the first data to the second data to determine if the actual state corresponds to the expected state.


According to another embodiment, a system for reconciling data comprises a memory storage for maintaining a database and a processing unit coupled to the memory storage, wherein the processing unit is operative to receive a first data corresponding to an expected state of at least one of a plurality of objects, create a second data corresponding to an actual state of the at least one of the plurality of objects, and compare the first data to the second data to determine if the actual state corresponds to the expected state.


In accordance with yet another embodiment, a computer-readable medium which stores a set of instructions which when executed performs a method for reconciling data, the method executed by the set of instructions comprises receiving a first data corresponding to an expected state of at least one of a plurality of objects, creating a second data corresponding to an actual state of the at least one of the plurality of objects, and comparing the first data to the second data to determine if the actual state corresponds to the expected state.


In accordance with yet another embodiment, a method for determining and applying rules to data comprises receiving a data comprising a root element and at least one leaf element, the root element having attributes, the attributes comprising characteristics, selecting a condition table based upon the characteristics, selecting a first ruleset based upon the selected condition table, and applying rules defined by the selected first ruleset to the data.


In accordance with yet another embodiment, a system for determining and applying rules to data comprises a memory storage for maintaining a database and a processing unit coupled to the memory storage, wherein the processing unit is operative to receive a data comprising a root element and at least one leaf element, the root element having attributes, the attributes comprising characteristics, select a condition table based upon the characteristics, select a first ruleset based upon the selected condition table, and apply rules defined by the selected first ruleset to the data.


In accordance with yet another embodiment, a computer-readable medium which stores a set of instructions which when executed performs a method for determining and applying rules to data, the method executed by the set of instructions comprises receiving a data comprising a root element and at least one leaf element, the root element having attributes, the attributes comprising characteristics, selecting a condition table based upon the characteristics, selecting a first ruleset based upon the selected condition table, and applying rules defined by the selected first ruleset to the data.


It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only, and should not be considered restrictive of the scope of the invention, as described and claimed. Further, features and/or variations may be provided in addition to those set forth herein. For example, embodiments of the invention may be directed to various combinations and sub-combinations of the features described in the detailed description.




BRIEF DESCRIPTION OF THE DRAWINGS

The accompanying drawings, which are incorporated in and constitute a part of this disclosure, illustrate various embodiments and aspects of the present invention. In the drawings:



FIG. 1 is a block diagram of an exemplary object delivery system consistent with an embodiment of the present invention;



FIG. 2 is a block diagram of an exemplary data processor consistent with an embodiment of the present invention;



FIG. 3 is a flow chart of an exemplary method for reconciling data consistent with an embodiment of the present invention;



FIG. 4 is a flow chart of an exemplary subroutine used in the exemplary method of FIG. 3 for creating the second data consistent with an embodiment of the present invention;



FIG. 5 illustrates an exemplary electronic product code consistent with embodiments of the present invention;



FIG. 6 is a flow chart of an exemplary method for determining and applying rules to data consistent with an embodiment of the present invention;



FIG. 7 illustrate an exemplary ruleset selection process consistent with embodiments of the present invention; and



FIG. 8 illustrate an exemplary ruleset application process consistent with embodiments of the present invention.




DETAILED DESCRIPTION

The following detailed description refers to the accompanying drawings. Wherever possible, the same reference numbers are used in the drawings and the following description to refer to the same or similar parts. While several exemplary embodiments and features of the invention are described herein, modifications, adaptations and other implementations are possible, without departing from the spirit and scope of the invention. For example, substitutions, additions or modifications may be made to the components illustrated in the drawings, and the exemplary methods described herein may be modified by substituting, reordering or adding steps to the disclosed methods. Accordingly, the following detailed description does not limit the invention. Instead, the proper scope of the invention is defined by the appended claims.


Systems and methods consistent with embodiments of the present invention may reconcile data. For example, FIG. 1 illustrates an exemplary object delivery system 100. As shown in FIG. 1, objects may be shipped from a central location, which may include an enterprise application integration processor 105, to a warehouse 110 or a retail store 115, for example. The objects may comprise any receivable element and, while warehouse 110 and retail store 115 are exemplary, the objects may be shipped to and received anywhere. When received at warehouse 110 or retail store 115, the objects may enter through gate 120 and 125 respectively. While the objects enter through the gates, indicia placed on the objects and/or on a container holding the objects may be read. For example, the indicia may comprise a bar code or a radio frequency identification (RFID) tag that may be read by the gates. Unlike a bar code, an RFID tag can be read through material such as cardboard and does not need to be read with a line-of-site laser.


After the indicia are read, data corresponding to the read indicia can be transmitted to a data processor such as data processors 130 and 130′. Among other things, the data transmitted to the data processors may indicate an actual state of the received objects as will be described below. Prior to the objects being received, however, processor 105 may transmit data to processors 130 and 130′ indicating a state in which the objects are expected to be received. Once processors 130 and 130′ have both the actual state data and the expected state data, these two data can be compared or reconciled to see if the two data agree or not. Processors 130 and 130′ may transmit the results of this comparison back to processor 105.


For example, a pallet (the container in this example) with an electronic product code (EPC) tag may be loaded with 20 cases (the objects in this example), each case also having an EPC tag. The cases, for example, may contain goods such as diapers or paper towels. The pallet may be shipped to warehouse 110 where it may pass through gate 120. The tags may be read by an RFID reader that may create, for example, either a single data message containing all EPCs in a hierarchical relation (i.e. smart message) or multiple data messages containing a partial list of EPCs without hierarchy (i.e. a flat message). For the smart message, an object structure with a pallet element as the root element and 20 case elements as leave elements may be constructed. For the flat messages, independent pallet/case elements may be constructed. The aforementioned data messages may be sent to processor 130 and may contain one or more EPCs and user data associated to one or more EPCs. The user data may describe additional process characteristics, the object(s), and/or the scanning or physical environment related to the received individual EPC. The user data may comprise, but is not limited to, an expiration date, batch numbers, descriptions, or a list of actions applied to the object(s) or container(s).


Continuing with this example, prior to receiving the objects at gate 120, an enterprise managing warehouse 110 may be advised by a vendor who shipped the pallet. The vendor may advise the enterprise (over a network 135 using processor 105) that the shipment should arrive at a certain time at gate 120. The enterprise now may create an action corresponding to an expected state for the pallet and for each of the 20 cases. This action may reflect that each object may have to be scanned at a particular receiving gate reader which then may generate a “goods receiving” action for each object or container received. Upon receipt of the pallet, this action may bring each object and the pallet into the current state “received at warehouse,” which corresponds to the expected state. The enterprise may then send a message to the vendor that the actual state and the received state have been reconciled. Furthermore, as discussed below, the objects may be received on multiple pallets and periodic updates may be made to the vendor regarding the shipment's receipt.


Moreover, systems and methods consistent with embodiments of the present invention may determine and apply rules to data. For example, the rules may be applied to data read and created regarding received objects and containers as described above. The data's hierarchy may comprise a top level element and may contain one or many dependent lower level elements in a tree representation. To each of these elements, rules may be applied to fulfill, for example, process evaluation, validation, communication, and status update activities. The rules for the current data hierarchy may be determined based on the characteristics of the top level element. Based on the top level element, a condition logic may be applied to find out which ruleset may be executed on the data hierarchy to fulfill, for example, business process steps needed for the particular situation.


Based on the characteristics of the top level element, the reader which created the object scan, the direction of the object passing the reader, and other flexibility definable criteria, for example, conditions may be setup using condition tables, which may be used to determine an appropriate ruleset. For one read, there may be one or many conditions evaluated to true, so that one or many rulesets may be executed in a sequence. The main rule determination may be applied to the top level element of the hierarchy, however, rules for the lower level tree elements may be carried out driven by activities that may trigger a new rule determination based on the currently handled data elements. This new rule processing may then include either the current data element or the current data element plus a lower level hierarchy data element.


After determining the ruleset to be used for processing a full or partial data hierarchy, the data and the ruleset may be processed by a rule processing software module. This software module may sequentially call each activity of the ruleset and hand over the data hierarchy to the activity. The activity may implement processing steps related to certain parts of the process. Examples for the process steps that may be implemented in activities may include:

    • Read data related to one or many objects of the object hierarchy from the database
    • Update information related to one or more objects of the object hierarchy on the database (e.g. current state)
    • Validate, verify, compare, calculate information of the object hierarchy with other information
    • Store information to be used in other activities of the current rule processing in the object context
    • Communicate information out of the object hierarchy, previous activities results, or related information from the database to other systems
    • Send status information to readers or device management systems
    • Give feedback to users
    • Prepare information for usage in key performance indicators


The aforementioned activities may return an execution status that may be used by the rule processing software module to do exception handling. Based on a configuration, for example, the rule processing can be either: i) interrupted by an exception and call an exception activity that handles the result of the current finished activity; or ii) the rule processing can go into exception handling and afterwards cancel execution of further activities. Each ruleset may be defined, for example, by users to meet specific business requirements. Also, any kind of activity may be implemented and added into new or existing rulesets.


An embodiment consistent with the invention may comprise a system for reconciling data. The system may comprise a memory storage for maintaining a database and a processing unit coupled to the memory storage. The processing unit may be operative to receive a first data corresponding to an expected state of at least one of a plurality of objects. Furthermore, the processing unit may be operative to create a second data corresponding to an actual state of the at least one of the plurality of objects and to compare the first data to the second data to determine if the actual state corresponds to the expected state.


Another embodiment consistent with the invention may comprise a system for determining and applying rules to data. This system may comprise a memory storage for maintaining a database and a processing unit coupled to the memory storage. The processing unit may be operative to receive data comprising a root element and at least one leaf element, the root element having attributes, the attributes comprising characteristics. Furthermore, the processing unit may be operative to select a condition table based upon the characteristics, select a first ruleset based upon the selected condition table, and apply rules defined by the selected first ruleset to the data.


Consistent with an embodiment of the present invention, the aforementioned memory, processing unit, and other components may be implemented in a data processor, such as the exemplary data processor 130 of FIG. 1. Any suitable combination of hardware, software and/or firmware may be used to implement the memory, processing unit, and/or other components. By way of example, the memory, processing unit, and/or other components may be implemented with enterprise application integration processor 105 and/or data processor 130, in combination with the components for system 100. The aforementioned system and processors are exemplary and other systems and processors may comprise the aforementioned memory, processing unit, and/or other components, consistent with embodiments of the present invention.


Furthermore, the invention may be practiced in an electrical circuit comprising discrete electronic elements, packaged or integrated electronic chips containing logic gates, a circuit utilizing a microprocessor, or on a single chip containing electronic elements or microprocessors. The invention may also be practiced using other technologies capable of performing logical operations such as, for example, AND, OR, and NOT, including but not limited to mechanical, optical, fluidic, and quantum technologies. In addition, the invention may be practiced within a general purpose computer or in any other circuits or systems.


By way of a non-limiting example, FIG. 2 illustrates exemplary processor in which the features and principles of the present invention may be implemented. As illustrated in the block diagram of FIG. 2, system 100 may include enterprise application integration processor 105, data processor 130, a user 205, and network 135. User 205 may be an individual, for example, desiring to reconcile or apply rules to data using data processor 130. User 205 may also represent an organization, enterprise, or any other entity having such desires or similar uses.


Data processor 130 may include a processing unit 225 and a memory 230. Memory 230 may include a reconciliation software module 235, rule processing software module 240, and a database 245. Reconciliation software module 235, residing in memory 130, may be executed on processing unit 225 and may access database 245. For example, reconciliation software module 235 may be executed on processing unit 225 to perform processes consistent with embodiments of the invention, such as processes consistent with the methods described below with respect to FIG. 3 and FIG. 4. Similarly, rule processing software module 240, residing in memory 130, may be executed on processing unit 225 and may access database 245. For example, rule processing software module 240 may be executed on processing unit 225 to perform processes consistent with embodiments of the invention, such as processes consistent with the methods described below with respect to FIG. 6.


Enterprise application integration processor 105 or data processor 130 (“the processors”) included in system 100 may be implemented using a personal computer, network computer, mainframe, or other similar microcomputer-based workstation. The processors may though comprise any type of computer operating environment, such as hand-held devices, multiprocessor systems, microprocessor-based or programmable sender electronic devices, minicomputers, mainframe computers, and the like. The processors may also be practiced in distributed computing environments where tasks are performed by remote processing devices. Furthermore, any of the processors may comprise a mobile terminal, such as a smart phone, a cellular telephone, a cellular telephone utilizing wireless application protocol (WAP), personal digital assistant (PDA), intelligent pager, portable computer, a hand held computer, a conventional telephone, or a facsimile machine. The aforementioned systems and devices are exemplary and the processor may comprise other systems or devices.


Network 135 may comprise, for example, a local area network (LAN) or a wide area network (WAN). Such networking environments are commonplace in offices, enterprise-wide computer networks, intranets, and the Internet, and are known by those skilled in the art. When a LAN is used as network 135, a network interface located at any of the processors may be used to interconnect any of the processors. When network 135 is implemented in a WAN networking environment, such as the Internet, the processors may typically include an internal or external modem (not shown) or other means for establishing communications over the WAN. Further, in utilizing network 135, data sent over network 135 may be encrypted to insure data security by using known encryption/decryption techniques.


In addition to utilizing a wire line communications system as network 135, a wireless communications system, or a combination of wire line and wireless may be utilized as network 135 in order to, for example, exchange web pages via the Internet, exchange e-mails via the Internet, or for utilizing other communications channels. Wireless can be defined as radio transmission via the airwaves. However, it may be appreciated that various other communication techniques can be used to provide wireless transmission, including infrared line of sight, cellular, microwave, satellite, packet radio, and spread spectrum radio. The processors in the wireless environment can be any mobile terminal, such as the mobile terminals described above. Wireless data may include, but is not limited to, paging, text messaging, e-mail, Internet access and other specialized data applications specifically excluding or including voice transmission.


System 100 may also transmit data by methods and processes other than, or in combination with, network 135. These methods and processes may include, but are not limited to, transferring data via, diskette, CD ROM, facsimile, conventional mail, an interactive voice response system (IVR), or via voice over a publicly switched telephone network.



FIG. 3 is a flow chart setting forth the general stages involved in an exemplary method 300 consistent with the invention for reconciling data using system 100 of FIG. 1. Exemplary ways to implement the stages of exemplary method 300 will be described in greater detail below. Exemplary method 300 may begin at starting block 305 and proceed to stage 310 where processor 130 may receive a first data corresponding to an expected state of at least one of a plurality of objects. For example, the plurality of objects may be shipped form a vendor operating processor 105. Prior to shipment, however, the vendor may send, over network 135, the first data corresponding to the expected state of the plurality of objects shipped. The first data may be received at processor 130 by an enterprise receiving or purchasing the objects. The first data may be sent in a first hierarchical data structure comprising, for example, a first data root element corresponding to a container associated with the plurality of objects sent. Moreover, the first hierarchical data structure may also include a first data leaf element corresponding to at least one of the plurality of objects sent. The first hierarchical data structure may also include other leaf element corresponding to others of the plurality of objects sent. Moreover, the expected state may comprise a condition in which the container associated with the at least one of the plurality of objects and the at least one of the plurality of objects are expected to be in at a future time. The future time may comprise, for example, the time when the plurality of objects are received at warehouse 110.


From stage 310, where processor 130 receives the first data corresponding to the expected state of at least one of the plurality of objects, exemplary method 300 may advance to exemplary subroutine 320 where processor 130 may create a second data corresponding to an actual state of the at least one of the plurality of objects. Exemplary ways to implement the stages of exemplary subroutine 320 will be described in greater detail below with respect to FIG. 4.


Once processor 130 creates the second data corresponding to an actual state of the at least one of the plurality of objects in exemplary subroutine 320, exemplary method 300 may continue to stage 330 where processor 130 may compare the first data to the second data to determine if the actual state corresponds to the expected state. For example, processor 130 determines if the first data root element included in the first data has a corresponding second data root element in the second data. Furthermore, processor 130 may determine if all first data leaf elements included in the first data have corresponding second data leaf elements in the second data.


After processor 130 compares the first data to the second data to determine if the actual state corresponds to the expected state in stage 330, exemplary method 300 may proceed to stage 340 where processor 130 may transmit a signal indicating a result of the comparison of the first data to the second data. For example, processor may transmit the signal over network 135 to processor 105 indicating that the objects' actual received state and the objects' expected state are congruent and thus reconciled. After processor 130 transmits the signal indicating the result of the comparison of the first data to the second data in stage 340, exemplary method 300 may then end at stage 350.



FIG. 4 is a flow chart setting forth the general stages involved in an exemplary subroutine 320 consistent with the invention for creating the second data using system 100 of FIG. 1. Exemplary ways to implement the stages of exemplary subroutine 320 will be described in greater detail below. Exemplary subroutine 320 may begin at starting block 405 and proceed to stage 410 where warehouse 110 may receive a container containing the at least one of the plurality of objects. For example, the container may comprise a pallet, a forklift, a case, or a storage bin. The aforementioned are exemplary and the container may comprise other devices.


From stage 410, where warehouse 110 receives the container containing the at least one of the plurality of objects, exemplary subroutine 320 may advance to stage 420 where processor 130 may read an object indicia corresponding to the at least one of the plurality of objects. For example, objects received on the container may each include their own indicia. As the container passes through gate 120, a scanner or other machine may read the indicia on any or all of the plurality of objects. For example, the gate may receive a signal associated with a radio frequency identification (RFID) tag or may scan a bar code from the plurality of objects and pallet. The aforementioned are exemplary and the indicia may comprise any indicia and may be read by any device. Once gate 120 reads the object indicia, data obtained from this read may be sent to processor 130.


Moreover, reading the object indicia may also comprise reading an electronic product code (EPC). As illustrated in FIG. 5, reading the object indicia may also comprise receiving object attributes comprising at least one of an object type 505 (for example, pallet or case), a vendor identification number 510 identifying, for example, the vendor who shipped the objects, a product identification number 515 identifying, for example, the product shipped, and a serial number 520. Furthermore, the EPC may also include an expiration date of the objects, a batch number, a description of the objects or container, and a list of actions applied to the objects or container. Any or all of the above attributes may be included in the EPC. Moreover, the aforementioned attributes are exemplary and others may be used.


Once processor 130 reads the object indicia corresponding to the at least one of the plurality of objects in stage 420, exemplary subroutine 320 may continue to stage 430 where processor 130 may read a container indicia corresponding to the container. For example, the received container may also include its own indicia. As the container passes through gate 120, for example, the scanner or other machine may read the indicia on container. The container indicia may comprise any indicia as described above with respect to the object indicia and may be read in a similar manner.


The plurality of objects may also be shipped and received on more than one container. For example, a second container may be shipped and received including objects associated with a first container that was previously shipped and received. An indicia on the second container may be read and may include data linking the second container to other containers (the first container, for example) containing associated objects. Processor 130, for example, may send updates to processor 105 corresponding to the receipt of the first container and the second container used to ship associated objects. Furthermore, the updates may reflect a time difference between receiving the two containers. One aspect of an expected state, for example, may include receiving the multiple containers having associated objects within a specific time frame.


After processor 130 reads the container indicia corresponding to the container in stage 430, exemplary subroutine 320 may proceed to stage 440 where processor 130 may establish the second data in a second hierarchical data structure. The second hierarchical data structure may comprise a second data root element corresponding to the read container indicia and a second data leaf element corresponding to the read object indicia. After processor 130 establishes the second data in the second hierarchical data structure in stage 440, exemplary subroutine 320 may then return to stage 330 of exemplary method 300 as shown in FIG. 3.



FIG. 6 is a flow chart setting forth the general stages involved in an exemplary method 600 consistent with the invention for determining and applying rules to data using system 100 of FIG. 1. Exemplary ways to implement the stages of exemplary method 600 will be described in greater detail below. Exemplary method 600 may begin at starting block 605 and proceed to stage 610 where processor 130 may receive a data comprising a root element and at least one leaf element. The root element may have attributes comprising characteristics. For example, the attributes may comprise characteristics comprising, for example, a direction (for example, in or out) the container was moving when an indicia associated with the container was read as it passed through gate 120. The attributes may also comprise a reader ID associated with a reader that read the indicia. For example, the reader ID may comprise an ID associated with gate 120. In addition, the attributes may also comprise an indication whether the reader (gate 120, for example) transformed flat data read into a hierarchical data structure.


The received data's root element may also correspond to the container associated with at least one of a plurality of objects received. Furthermore, the received data's leaf elements may correspond to the plurality of objects received. As shown in FIG. 7, the characteristics may comprise characteristics 705. For example, the reader ID may be “5”, the direction may be “in”, and the message type may be “smart” (corresponding to a hierarchical data structure rather than a flat data structure).


From stage 610, where processor 130 receives the data, exemplary method 600 may advance to stage 620 where processor 130 may select a condition table based upon the characteristics. For example, as shown in condition table determination 710 of FIG. 7, if reader=“5”, direction=“in”, and message type=“smart”, condition table A 715 is chosen. However, if reader=“5”, direction=“out”, and message type=“smart”, condition table “B” would have been chosen. Consequently, given characteristics 705, condition table A 715 is chosen in this example.


Once processor 130 selects the condition table based on the characteristics in stage 620, exemplary method 600 may continue to stage 630 where processor 130 may select a first ruleset based upon the selected condition table. For example, other data, such as vendor name and pallet type obtained from the attributes, for example, may be used along with condition table A 715 to select the first ruleset. As shown in FIG. 7, for vendor name “XYZ” and pallet type “standard”, the selected ruleset may comprise “inbound full” ruleset 720.


After processor 130 selects the first ruleset based upon the selected condition table in stage 630, exemplary method 600 may proceed to stage 640 where processor 130 may apply rules defined by the selected first ruleset to the data. For example, rule processing software module 240 may be executed on processing unit 225 to carry out the activities of ruleset 720. As shown in FIG. 8, activity 1 may comprise updating database 245. Activity 2 of ruleset 720 may cause processing unit 225 to send a message to a reader. Next, activity 3 may cause processing unit to perform a check and return if the check is positive. Activity 4, however, may cause processing unit to perform a check that is not positive, but negative instead. In this case, an error may be sent and processing unit may stop executing ruleset 720. Consequently, because an error was returned by activity 4, activity 5 may not be executed. However, if activity 4 had been error free, activity 5 may be executed by processing unit 225.


Generally, rules may be applied to perform process evaluation, validation, communication, and status update. Exemplary activities included in ruleset may include: i) applying at least one of reading data related to one or many objects of the object hierarchy from a database; ii) updating information related to one or more objects of an object hierarchy on the database; iii) validating information of the object hierarchy with other information; iv) verifying information of the object hierarchy with other information; v) comparing information of the object hierarchy with other information; vi) calculating information of the object hierarchy with other information; vii) storing information to be used in other activities of a current rule processing in an object context; viii) communicating information out of the object hierarchy; ix) sending status information to readers or device management systems; x) giving feedback to users; and xi) preparing information for usage in key performance indicators.


While not illustrated above, more than one ruleset may be selected and applied to one data structure. For example, a second ruleset may be selected based upon a selected condition table. The rules from this second ruleset may be applied to the data. After processor 130 applies rules defined by the selected first ruleset (and/or second ruleset) to the data in stage 640, exemplary method 600 may then end at stage 650.


While certain features and embodiments of the invention have been described, other embodiments of the invention will be apparent to those skilled in the art from consideration of the specification and practice of the embodiments of the invention disclosed herein. Furthermore, although embodiments of the present invention have been described as being associated with data stored in memory and other storage mediums, one skilled in the art will appreciate that these aspects can also be stored on or read from other types of computer-readable media, such as secondary storage devices, like hard disks, floppy disks, or a CD-ROM, a carrier wave from the Internet, or other forms of RAM or ROM. Further, the steps of the disclosed methods may be modified in any manner, including by reordering steps and/or inserting or deleting steps, without departing from the principles of the invention.


It is intended, therefore, that the specification and examples be considered as exemplary only, with a true scope and spirit of the invention being indicated by the following claims and their full scope of equivalents.

Claims
  • 1. A method for reconciling data, the method comprising: receiving a first data corresponding to an expected state of at least one of a plurality of objects; creating a second data corresponding to an actual state of the at least one of the plurality of objects; and comparing the first data to the second data to determine if the actual state corresponds to the expected state.
  • 2. The method of claim 1, wherein receiving the first data comprises receiving the first data from a vendor of the at least one of the plurality of objects.
  • 3. The method of claim 1, wherein receiving the first data comprises receiving the first data in a first hierarchical data structure comprising a first data root element corresponding to a container associated with the at least one of the plurality of objects and a first data leaf element corresponding to the at least one of the plurality of objects.
  • 4. The method of claim 1, wherein receiving the first data comprises receiving the first data wherein the expected state comprises a condition in which a container associated with the at least one of the plurality of objects and the at least one of the plurality of objects are expected to be in at a future time.
  • 5. The method of claim 1, wherein receiving the first data comprises receiving the first data wherein the expected state comprises a condition in which a container associated with the at least one of the plurality of objects and the at least one of the plurality of objects are expected to be in at a future time, the future time comprising when the container is to be received by a buyer.
  • 6. The method of claim 1, wherein creating the second data comprises: receiving a container containing the at least one of the plurality of objects; reading an object indicia corresponding to the at least one of the plurality of objects; reading a container indicia corresponding to the container; and establishing the second data in a second hierarchical data structure comprising a second data root element corresponding to the read container indicia and a second data leaf element corresponding to the read object indicia.
  • 7. The method of claim 6, wherein receiving the container comprises receiving the container comprising at least one of a pallet, a forklift, a case, and a storage bin.
  • 8. The method of claim 6, wherein reading the object indicia comprises machine reading the object indicia.
  • 9. The method of claim 8, wherein machine reading the object indicia comprises at least one of receiving a signal associated with a radio frequency identification (RFID) tag and scanning a bar code.
  • 10. The method of claim 6, wherein reading the object indicia comprises reading an electronic product code.
  • 11. The method of claim 6, wherein reading the object indicia comprises receiving object attributes comprising at least one of an object type, a vendor identification number, a product identification number, a serial number, an expiration date, a batch number, a description, and a list of actions applied.
  • 12. The method of claim 6, wherein reading the container indicia comprises machine reading the container indicia.
  • 13. The method of claim 12, wherein machine reading the container indicia comprises at least one of receiving a signal associated with a radio frequency identification (RFID) tag and scanning a bar code.
  • 14. The method of claim 6, wherein reading the container indicia comprises reading an electronic product code.
  • 15. The method of claim 6, wherein reading the container indicia comprises receiving container attributes comprising at least one of a container type, a vendor identification number, a product identification number, a serial number, an expiration date, a batch number, a description, and a list of actions applied.
  • 16. The method of claim 1, wherein creating the second data comprises: receiving, at a first time, a first container containing the at least one of the plurality of objects; reading a first object indicia corresponding to the at least one of the plurality of objects; reading a first container indicia corresponding to the first container; receiving, at a second time, a second container containing an other of the plurality of objects, the second time being subsequent to the first time; reading a second object indicia corresponding to the other of the plurality of objects; reading a second container indicia corresponding to the second container, the second container indicia containing data linking the second container to the first container; establishing the second data in a second hierarchical data structure comprising a second data root element corresponding to the read first container indicia and a second data leaf element corresponding to the read first object indicia, the second data further comprising an other data leaf element corresponding to the read second object indicia if the difference between the first time and the second time is less than a time threshold value; and wherein receiving the first data corresponding to the expected state of the at least one of a plurality of objects further comprises receiving the first data corresponding to the expected state of the other of the plurality of objects.
  • 17. The method of claim 16, further comprising proving an update indicating a status of at least one of the first container, the second container, and the plurality of objects.
  • 18. The method of claim 1, wherein comparing the first data to the second data to determine if the actual state corresponds to the expected state comprises: determining if a first data root element included in the first data has a corresponding second data root element in the second data; and determining if all first data leaf elements included in the first data have corresponding second data leaf elements in the second data.
  • 19. The method of claim 1, further comprising transmitting a signal indicating a result of the comparison of the first data to the second data.
  • 20. A system for reconciling data, the system comprising: a memory storage for maintaining a database; and a processing unit coupled to the memory storage, wherein the processing unit is operative to receive a first data corresponding to an expected state of at least one of a plurality of objects; create a second data corresponding to an actual state of the at least one of the plurality of objects; and compare the first data to the second data to determine if the actual state corresponds to the expected state.
  • 21. The system of claim 20, wherein the processing unit being operative to receive the first data comprises the processing unit being operative to receive the first data from a vendor of the at least one of the plurality of objects.
  • 22. The system of claim 20, wherein the processing unit being operative to receive the first data comprises the processing unit being operative to receive the first data in a first hierarchical data structure comprising a first data root element corresponding to a container associated with the at least one of the plurality of objects and a first data leaf element corresponding to the at least one of the plurality of objects.
  • 23. The system of claim 20, wherein the processing unit being operative to receive the first data comprises the processing unit being operative to receive the first data wherein the expected state comprises a condition in which a container associated with the at least one of the plurality of objects and the at least one of the plurality of objects are expected to be in at a future time.
  • 24. The system of claim 20, wherein the processing unit being operative to receive the first data comprises the processing unit being operative to receive the first data wherein the expected state comprises a condition in which a container associated with the at least one of the plurality of objects and the at least one of the plurality of objects are expected to be in at a future time, the future time comprising when the container is to be received by a buyer.
  • 25. The system of claim 20, wherein the processing unit being operative to create the second data comprises the processing unit being operative to: read an object indicia corresponding to the at least one of the plurality of objects; read a container indicia corresponding to a container; and establish the second data in a second hierarchical data structure comprising a second data root element corresponding to the read container indicia and a second data leaf element corresponding to the read object indicia.
  • 26. The system of claim 25, wherein the processing unit being operative to read the container indicia comprises the processing unit being operative to read the container indicia on a container comprising at least one of a pallet, a forklift, a case, and a storage bin.
  • 27. The system of claim 25, wherein the processing unit being operative to read the object indicia comprises the processing unit being operative to machine read the object indicia.
  • 28. The system of claim 27, wherein the processing unit being operative to machine read the object indicia comprises at least one of the processing unit being operative to receive a signal associated with a radio frequency identification (RFID) tag and the processing unit being operative to scan a bar code.
  • 29. The system of claim 25, wherein the processing unit being operative to read the object indicia comprises the processing unit being operative to read an electronic product code.
  • 30. The system of claim 25, wherein the processing unit being operative to read the object indicia comprises the processing unit being operative to receive object attributes comprising at least one of an object type, a vendor identification number, a product identification number, a serial number, an expiration date, a batch number, a description, and a list of actions applied.
  • 31. The system of claim 25, wherein the processing unit being operative to read the container indicia comprises the processing unit being operative to machine read the container indicia.
  • 32. The system of claim 31, wherein the processing unit being operative to machine read the container indicia comprises at least one of the processing unit being operative to receive a signal associated with a radio frequency identification (RFID) tag and the processing unit being operative to scan a bar code.
  • 33. The system of claim 25, wherein the processing unit being operative to read the container indicia comprises the processing unit being operative to read an electronic product code.
  • 34. The system of claim 25, wherein the processing unit being operative to read the container indicia comprises the processing unit being operative to receive container attributes comprising at least one of a container type, a vendor identification number, a product identification number, a serial number, an expiration date, a batch number, a description, and a list of actions applied.
  • 35. The system of claim 20, wherein the processing unit being operative to create the second data comprises the processing unit being operative to: read, at a first time, a first container indicia corresponding to a first container; read a first object indicia corresponding to the at least one of the plurality of objects; read, at second time, a second container indicia corresponding to a second container, the second container indicia containing data linking the second container to the first container; read, at a second time, a second object indicia corresponding to the another of the plurality of objects; and establish the second data in a second hierarchical data structure comprising a second data root element corresponding to the read first container indicia and a second data leaf element corresponding to the read first object indicia, the second data further comprising an other data leaf element corresponding to the read second object indicia if the difference between the first time and the second time is less than a time threshold value.
  • 36. The system of claim 35, further comprising the processing unit being operative to prove an update indicating a status of at least one of the first container, the second container, and the plurality of objects.
  • 37. The system of claim 20, wherein the processing unit being operative to compare the first data to the second data to determine if the actual state corresponds to the expected state comprises the processing unit being operative to: determine if a first data root element included in the first data has a corresponding second data root element in the second data; and determine if all first data leaf elements included in the first data have corresponding second data leaf elements in the second data.
  • 38. The system of claim 20, further comprising the processing unit being operative to transmit a signal indicating a result of the comparison of the first data to the second data.
  • 39. A computer-readable medium which stores a set of instructions which when executed performs a method for reconciling data, the method executed by the set of instructions comprising: receiving a first data corresponding to an expected state of at least one of a plurality of objects; creating a second data corresponding to an actual state of the at least one of the plurality of objects; and comparing the first data to the second data to determine if the actual state corresponds to the expected state.
  • 40. The computer-readable medium of claim 39, wherein receiving the first data comprises receiving the first data from a vendor of the at least one of the plurality of objects.
  • 41. The computer-readable medium of claim 39, wherein receiving the first data comprises receiving the first data in a first hierarchical data structure comprising a first data root element corresponding to a container associated with the at least one of the plurality of objects and a first data leaf element corresponding to the at least one of the plurality of objects.
  • 42. The computer-readable medium of claim 39, wherein receiving the first data comprises receiving the first data wherein the expected state comprises a condition in which a container associated with the at least one of the plurality of objects and the at least one of the plurality of objects are expected to be in at a future time.
  • 43. The computer-readable medium of claim 39, wherein receiving the first data comprises receiving the first data wherein the expected state comprises a condition in which a container associated with the at least one of the plurality of objects and the at least one of the plurality of objects are expected to be in at a future time, the future time comprising when the container is to be received by a buyer.
  • 44. The computer-readable medium of claim 39, wherein creating the second data comprises: receiving a container containing the at least one of the plurality of objects; reading an object indicia corresponding to the at least one of the plurality of objects; reading a container indicia corresponding to the container; and establishing the second data in a second hierarchical data structure comprising a second data root element corresponding to the read container indicia and a second data leaf element corresponding to the read object indicia.
  • 45. The computer-readable medium of claim 44, wherein receiving the container comprises receiving the container comprising at least one of a pallet, a forklift, a case, and a storage bin.
  • 46. The computer-readable medium of claim 44, wherein reading the object indicia comprises machine reading the object indicia.
  • 47. The computer-readable medium of claim 46, wherein machine reading the object indicia comprises at least one of receiving a signal associated with a radio frequency identification (RFID) tag and scanning a bar code.
  • 48. The computer-readable medium of claim 44, wherein reading the object indicia comprises reading an electronic product code.
  • 49. The computer-readable medium of claim 44, wherein reading the object indicia comprises receiving object attributes comprising at least one of an object type, a vendor identification number, a product identification number, a serial number, an expiration date, a batch number, a description, and a list of actions applied.
  • 50. The computer-readable medium of claim 44, wherein reading the container indicia comprises machine reading the container indicia.
  • 51. The computer-readable medium of claim 50, wherein machine reading the container indicia comprises at least one of receiving a signal associated with a radio frequency identification (RFID) tag and scanning a bar code.
  • 52. The computer-readable medium of claim 44, wherein reading the container indicia comprises reading an electronic product code.
  • 53. The computer-readable medium of claim 44, wherein reading the container indicia comprises receiving container attributes comprising at least one of a container type, a vendor identification number, a product identification number, a serial number, an expiration date, a batch number, a description, and a list of actions applied.
  • 54. The computer-readable medium of claim 39, wherein creating the second data comprises: receiving, at a first time, a first container containing the at least one of the plurality of objects; reading a first object indicia corresponding to the at least one of the plurality of objects; reading a first container indicia corresponding to the first container; receiving, at a second time, a second container containing an other of the plurality of objects, the second time being subsequent to the first time; reading a second object indicia corresponding to the other of the plurality of objects; reading a second container indicia corresponding to the second container, the second container indicia containing data linking the second container to the first container; establishing the second data in a second hierarchical data structure comprising a second data root element corresponding to the read first container indicia and a second data leaf element corresponding to the read first object indicia, the second data further comprising an other data leaf element corresponding to the read second object indicia if the difference between the first time and the second time is less than a time threshold value; and wherein receiving the first data corresponding to the expected state of the at least one of a plurality of objects further comprises receiving the first data corresponding to the expected state of the other of the plurality of objects.
  • 55. The computer-readable medium of claim 54, further comprising proving an update indicating a status of at least one of the first container, the second container, and the plurality of objects.
  • 56. The computer-readable medium of claim 39, wherein comparing the first data to the second data to determine if the actual state corresponds to the expected state comprises: determining if a first data root element included in the first data has a corresponding second data root element in the second data; and determining if all first data leaf elements included in the first data have corresponding second data leaf elements in the second data.
  • 57. The computer-readable medium of claim 39, further comprising transmitting a signal indicating a result of the comparison of the first data to the second data.