The present invention is directed to the field of data modeling, and more specifically to aspects of reusable data types that can be referenced by other data objects.
An enterprise may employ various systems to manage various aspects of human resources and enterprise resources. The various systems can include Human Resource Management (HRM) systems, Employee Relationship Management (ERM) systems, Enterprise Resources Planning (ERP) systems, supply chain management (SCM) and warehouse management (WMS), and custom applications for the purpose of sharing data. Such an enterprise system is herein referred to as a multi-application integration system (MAIS). The various systems in the MAIS need to communicate data to each other. However, the users of enterprise data in the back-office typically store data in forms usable by the back-office computerized system, which often differ significantly from the forms usable with front-office computerized systems.
Thus, when some or all aspects of enterprise data are managed by both back-office and front-office computerized systems, there is a need to synchronize the enterprise data in both computerized systems.
Thus, in order for front-office computerized systems to communicate with back-office computerized systems that are already being used, the user must manually regenerate data from the back-office computerized systems in forms usable by the front-office computerized systems. Such manual regeneration has several significant disadvantages, including: (1) it is often expensive; (2) it often requires a substantial amount of time to complete; (3) it must be repeated each time data changes in either the back-office system or the front-office system; and (4) it is prone to errors.
In view of the foregoing, an automated and efficient approach for transforming data used by a back-office computerized system for use by a front-office computerized system, or vice versa, is needed.
All changes in the enterprise information need to be captured and made accessible to all relevant computer applications that the enterprise uses to manage various aspects of enterprise resources. Thus, a common data storage model is needed for enabling users of the relevant computer applications to have the same view of the enterprise information across the various computer applications.
According to certain embodiments, the common data storage model utilizes common objects that provide defined data structures that can be used as conduits for passing enterprise information from one computerized system to another in the enterprise multi-application integration system (MAIS). Such a data structure is a common structure that can be mapped to multiple distinct enterprise systems purchased from different vendors. Such a common data storage model is herein referred to as a common object data model or an MAIS data model.
One aspect of the common object data model is the design and utilization of “Common” common objects. In other words, the “Common” common objects provide data types that can be shared by a multiplicity of common objects that are in the common object data model.
The data types associated with Common common objects are defined in a Common common object schema, herein referred to as “common.xsd”. All integration application processes in MAIS have the common.xsd available for use within such integration application processes.
The common.xsd provides reusable data types that can be referenced by any common object within the common object data model. Instead of defining redundant data types that are local to each common object, the common.xsd provides global data types that can be used by all common objects, thus reducing the complexity of the data model, and allowing for simpler changes of data types in the future (if needed). The alternative is to define all elements within each common object, but to do so would increase maintenance costs and decrease standardization.
The common.xsd is not meant to be the data transport schema by itself. It is a library (repository) of commonly used data types. The data types within common.xsd provide standard definitions of data elements that can be reused by other common objects.
Some of the data types defined in the common.xsd are:
For example, common objects in the common object data model that require address information simply refer to the address data type defined in common.xsd, rather than recreating an entire address format within each of the common objects that need address information. Thus, there may be many common objects referring to the same address data type defined in common.xsd. If it is later determined that the addition of more elements within the address data type would be beneficial, the data type would be modified in common.xsd, and all of the common objects that refer to the address data type will inherit the new definition of an address. On the other hand, if the address format were defined in every common object that needs address information, then any changes to the address format would require that all such common objects be updated manually. The common.xsd, as used within MAIS, significantly reduces maintenance efforts and increases standardization of the data model.
Thus, the design of the Common common object is suitably adapted to evolve for enhancing the utility of the common object data model. Each reusable data type has a clearly defined native data type (e.g. string, date, integer, float, double, etc.) that corresponds to XML standards.
When enterprise information is passed from the back-office enterprise system to the front-office enterprise system, then the back-office enterprise system is referred to as the source system and the front-office enterprise system is referred to as the target system. On the other hand, when enterprise information is passed from the front-office enterprise system to the back-office enterprise system, then the front-office enterprise system is referred to as the source system and the back-office enterprise system is referred to as the target system.
A software facility (hereafter “the facility”) for automatically converting enterprise information, is described. In some embodiments, the facility converts enterprise information from a form used by the source system to a form used by the target system.
In some embodiments, such as embodiments adapted for converting enterprise information in the first source format, the facility converts enterprise information by converting the enterprise information that is in the first source format into an intermediate format. The intermediate format includes a plurality of common data type elements that are adapted to be shared across a plurality of data objects in the intermediate format. The intermediate format is then used to convert the enterprise information into the target format.
By performing such conversions, embodiments of the facility enable a user of a first computerized system who has stored enterprise information in a first format for use by the first computerized system to readily make the stored enterprise information available for use in a second computerized system that utilizes a second format in a cost-efficient and time-efficient manner.
The facility (not shown) converts some or all the enterprise information that is in the source format into the target format by using an intermediate format of the enterprise information. In certain embodiments, such conversions are performed with the aid of one or more other computer systems, such as integration server system 120. Components of the facility may reside on and/or execute on any combination of these computer systems, and intermediate results from the conversion may similarly reside on any combination of these computer systems.
The computer systems shown in
It will be understood by those skilled in the art that the facility may transform enterprise information from a number of different source systems and from a number of different source software packages to a number of target systems and/or to a number of target software packages.
The intermediate data structures used by the facility include common common data structures. Common common data structures are reusable data types that can be referenced by other intermediate data structures. Common common data structures include one or more elements comprising: an application element, a fault handler input element, a fault handler output element, a fault transformer input element, a fault transformer output element, a list of application instance element, a list of application type element, a list of ID cross-reference element, a list of ID cross-reference data element, a list of message definition element, a list of message text element, a list of value cross-reference element, and a list of value cross-reference data element, a message element, a message set element, an activity type element, an address type element, an alternate ID type element, a communication data type element, a data cleansing data type element, and a payment card type element.
It will be appreciated by those skilled in the art that the above-described facility may be straightforwardly adapted or extended in various ways. For example, the facility may be used to transform various other kinds of enterprise information, and may be used to transform enterprise information between a variety of other formats.
In the foregoing specification, embodiments of the invention have been described with reference to numerous specific details that may vary from implementation to implementation. Thus, the sole and exclusive indicator of what the invention is and what is intended by the applicants to be the invention, is the set of claims that issue from this application, in the specific form in which such claims issue, including any subsequent correction. Any express definitions set forth herein for terms contained in such claims shall govern the meaning of such terms as used in the claims. Hence, no limitation, element, property, feature, advantage or attribute that is not expressly recited in a claim should limit the scope of such claim in any way. The specification and drawings are, accordingly, to be regarded in an illustrative rather than a restrictive sense.
This application claims the benefit of U.S. Provisional Patent Application No. 60/457,493 filed Mar. 24, 2003, entitled, “COMMON COMMON OBJECT,” by Barnes-Leon et al., and which is hereby incorporated by reference in its entirety.
Number | Name | Date | Kind |
---|---|---|---|
4714995 | Materna et al. | Dec 1987 | A |
5311438 | Sellers et al. | May 1994 | A |
5349643 | Cox et al. | Sep 1994 | A |
5416917 | Adair et al. | May 1995 | A |
5446880 | Balgeman et al. | Aug 1995 | A |
5566332 | Adair et al. | Oct 1996 | A |
5646862 | Jolliffe et al. | Jul 1997 | A |
5708828 | Coleman | Jan 1998 | A |
5727158 | Bouziane et al. | Mar 1998 | A |
5742588 | Thornberg et al. | Apr 1998 | A |
5758355 | Buchanan | May 1998 | A |
5970490 | Morgenstern | Oct 1999 | A |
6178418 | Singer | Jan 2001 | B1 |
6216130 | Hougaard et al. | Apr 2001 | B1 |
6226649 | Bodamer et al. | May 2001 | B1 |
6236997 | Bodamer et al. | May 2001 | B1 |
6275812 | Haq et al. | Aug 2001 | B1 |
6336124 | Alam et al. | Jan 2002 | B1 |
6343275 | Wong | Jan 2002 | B1 |
6377952 | Inohara et al. | Apr 2002 | B1 |
6385620 | Kurzius et al. | May 2002 | B1 |
6434567 | De La Huerga | Aug 2002 | B1 |
6463430 | Brady et al. | Oct 2002 | B1 |
6556950 | Schwenke et al. | Apr 2003 | B1 |
6591260 | Schwarzhoff et al. | Jul 2003 | B1 |
6631382 | Kouchi et al. | Oct 2003 | B1 |
6668253 | Thompson et al. | Dec 2003 | B1 |
6754679 | Oheda | Jun 2004 | B2 |
6778651 | Jost et al. | Aug 2004 | B1 |
6792431 | Tamboli et al. | Sep 2004 | B2 |
6826542 | Virgin et al. | Nov 2004 | B1 |
6828963 | Rappoport | Dec 2004 | B1 |
6883004 | Bahl et al. | Apr 2005 | B2 |
6889260 | Hughes | May 2005 | B1 |
6912719 | Elderon et al. | Jun 2005 | B2 |
6947947 | Block et al. | Sep 2005 | B2 |
7043687 | Knauss et al. | May 2006 | B2 |
7099350 | Peterson | Aug 2006 | B2 |
7111077 | Starkovich et al. | Sep 2006 | B1 |
7124112 | Guyan et al. | Oct 2006 | B1 |
7257594 | Tamboli et al. | Aug 2007 | B2 |
7287041 | Barnes-Leon et al. | Oct 2007 | B2 |
20020019765 | Mann et al. | Feb 2002 | A1 |
20020035431 | Ell | Mar 2002 | A1 |
20020040313 | Hunter et al. | Apr 2002 | A1 |
20020085020 | Carroll, Jr. | Jul 2002 | A1 |
20020116234 | Nagasawa | Aug 2002 | A1 |
20020123983 | Riley et al. | Sep 2002 | A1 |
20020138582 | Chandra et al. | Sep 2002 | A1 |
20020169867 | Mann et al. | Nov 2002 | A1 |
20020174417 | Sijacic et al. | Nov 2002 | A1 |
20020178077 | Katz et al. | Nov 2002 | A1 |
20020184085 | Lindia et al. | Dec 2002 | A1 |
20020184148 | Kahn et al. | Dec 2002 | A1 |
20020188513 | Gil et al. | Dec 2002 | A1 |
20020188538 | Robertson et al. | Dec 2002 | A1 |
20030023580 | Braud et al. | Jan 2003 | A1 |
20030071852 | Stimac | Apr 2003 | A1 |
20030097642 | Arai et al. | May 2003 | A1 |
20030131018 | Godoy et al. | Jul 2003 | A1 |
20030163597 | Hellman et al. | Aug 2003 | A1 |
20030229529 | Mui et al. | Dec 2003 | A1 |
20040015515 | Beisiegel et al. | Jan 2004 | A1 |
20040039576 | He et al. | Feb 2004 | A1 |
20040128188 | Leither et al. | Jul 2004 | A1 |
20040199536 | Barnes-Leon et al. | Oct 2004 | A1 |
20040215503 | Allpress et al. | Oct 2004 | A1 |
20040249854 | Barnes-Leon et al. | Dec 2004 | A1 |
20050021391 | Lu et al. | Jan 2005 | A1 |
20050091249 | Hanson et al. | Apr 2005 | A1 |
20050197880 | Walsh et al. | Sep 2005 | A1 |
20060271446 | Barnes-Leon et al. | Nov 2006 | A1 |
20070033531 | Marsh | Feb 2007 | A1 |
20070203710 | Habichler et al. | Aug 2007 | A1 |
20070208577 | Barnes-Leon et al. | Sep 2007 | A1 |
20070208878 | Barnes-Leon et al. | Sep 2007 | A1 |
20070214063 | Kahlon et al. | Sep 2007 | A1 |
20070214064 | Kahlon et al. | Sep 2007 | A1 |
20070214065 | Kahlon et al. | Sep 2007 | A1 |
20070226049 | Muralitharan et al. | Sep 2007 | A1 |
20070250419 | Kumar et al. | Oct 2007 | A1 |
20070265944 | Catahan, Jr. et al. | Nov 2007 | A1 |
Number | Date | Country |
---|---|---|
101 50 391 | May 2002 | DE |
2001 256308 | Sep 2001 | JP |
WO 0188759 | Nov 2001 | WO |
WO 03003641 | Jan 2003 | WO |
Number | Date | Country | |
---|---|---|---|
20040249854 A1 | Dec 2004 | US |
Number | Date | Country | |
---|---|---|---|
60457493 | Mar 2003 | US |