Patent Application
20050283502
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.
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.
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:
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,
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:
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
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,
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
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.
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
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.
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
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
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
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
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
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
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.
