US7272776B2 - Master data quality - Google Patents

Master data quality Download PDF

Info

Publication number
US7272776B2
US7272776B2 US10/747,663 US74766303A US7272776B2 US 7272776 B2 US7272776 B2 US 7272776B2 US 74766303 A US74766303 A US 74766303A US 7272776 B2 US7272776 B2 US 7272776B2
Authority
US
United States
Prior art keywords
data
rules
error corrector
computer program
program product
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active, expires
Application number
US10/747,663
Other versions
US20050144552A1 (en
Inventor
Wolfgang Kalthoff
Frank Rohloff
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
SAP SE
Original Assignee
SAP SE
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by SAP SE filed Critical SAP SE
Priority to US10/747,663 priority Critical patent/US7272776B2/en
Assigned to SAP AKTIENGESELLSCHAFT reassignment SAP AKTIENGESELLSCHAFT ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: KALTHOFF, WOLFGANG, ROHLOFF, FRANK
Priority to PCT/EP2004/014690 priority patent/WO2005064491A1/en
Publication of US20050144552A1 publication Critical patent/US20050144552A1/en
Application granted granted Critical
Publication of US7272776B2 publication Critical patent/US7272776B2/en
Assigned to SAP SE reassignment SAP SE CHANGE OF NAME (SEE DOCUMENT FOR DETAILS). Assignors: SAP AG
Active legal-status Critical Current
Adjusted expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/215Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors

Definitions

  • This invention relates to data management and more particularly to ensuring master data quality.
  • IT environments can consist of many different systems performing processes, such as business processes, on common data.
  • the different systems can be part of the same entity or can be part of different entities, such as vendors or contractors.
  • the data used for the processes can be stored in a number of different locations, systems, and/or formats.
  • Different plants and branch offices of a company can work largely independently from each other and can store data in different formats; adopted companies can introduce new software solutions to a group of affiliated companies that require that data be stored in different formats; and systems from different vendors can be linked, but each vendor may specify that data be stored in different formats.
  • Different data models can make it difficult to integrate business processes in these scenarios.
  • the format in which data are entered into an IT environment depends strongly on the underlying data model used for storing the data in a particular location. For example, measurement data may be stored in English units at one plant but in metric units in another plant, or sales data may be stored in terms of revenue per month for one regional sales department, but in terms of revenue per week in another regional sales department. Because the format in which data are entered depends on the underlying data storage model, the user must recognize the underlying data model of the particular data storage system and must conform the format in which data are entered to the underlying data model. Furthermore, the user must ensure when data are entered into the system the data meet certain consistency checks that are imposed by the underlying data model. The data are not accepted until the consistency checks are satisfied.
  • a method of enhancing the quality of data stored in a system includes receiving data from a first data enterer, accepting data received from the first data enterer into the system if the data are entered in a format compliant with a first set of rules, receiving first additional data from a second data enterer, the first additional data being related to the data received from the first data enterer, and accepting first additional data received from the second data enterer into the system if the data are entered in a format compliant with a second set of rules.
  • a computer program product tangibly stored on a machine readable medium, for enhancing the quality of data stored in a system, includes instructions for causing a processor to receive data from a first data enterer, accept data received from the first data enterer into the system if the data are entered in a format compliant with a first set of rules, receive first additional data from a second data enterer, the first additional data being related to the data received from the first data enterer, and accept first additional data received from the second data enterer into the system if the data are entered in a format compliant with a second set of rules.
  • the data must also comply with the first set of rules.
  • Data accepted into the system can be compared with a third set of rules, an inconsistency in data entered into the system with a rule from the third set of rules can be detected, a report of the inconsistency can be dispatched to an error corrector, and corrected data can be received from the error corrector.
  • the data may be required also to comply with the second set of rules. The data received from the first and second data enterers and entered into the system for use by a user of the system can be released before the corrected data are received from the error corrector.
  • the inconsistency be corrected by the error corrector within a particular timeframe, and the error corrector can be reminded to correct the data before the end of the timeframe.
  • a particular error can be dispatched to a particular error corrector for correction.
  • the load of errors assigned to an error corrector can be monitored, and an additional report of inconsistency can be dispatched to another error corrector when the load of errors assigned to the error corrector exceeds a threshold load.
  • FIG. 1 is a schematic diagram of a system for entering and storing data.
  • FIG. 2 is a flow chart of a process for entering and storing data.
  • FIG. 3 is a flow chart of a process for ensuring data quality.
  • FIG. 1 describes a communications system for implementing techniques for entering and storing data.
  • FIG. 1 describes a communications system for implementing techniques for entering and storing data.
  • FIG. 1 describes a communications system for implementing techniques for entering and storing data.
  • FIG. 1 describes a communications system for implementing techniques for entering and storing data.
  • FIG. 1 describes a communications system for implementing techniques for entering and storing data.
  • FIG. 1 describes a communications system for implementing techniques for entering and storing data.
  • FIG. 1 describes a communications system for implementing techniques for entering and storing data.
  • FIG. 1 describes a communications system for implementing techniques for entering and storing data.
  • FIG. 1 describes a communications system for implementing techniques for entering and storing data.
  • FIG. 1 describes a communications system for implementing techniques for entering and storing data.
  • FIG. 1 describes a communications system for implementing techniques for entering and storing data.
  • FIG. 1 describes a communications system for implementing techniques for entering and storing data.
  • a data entry and storage system 100 is capable of receiving data at a data entry system 105 and a storing data in the data entry system 105 or transferring the data through a communications link 115 to one or more data storage systems 110 , 170 for storage.
  • Data entry and storage system 100 may exist within an organization and may include components remotely located from each other and/or components that are used by different users within the organization.
  • the data entry system 105 typically includes one or more data entry devices 120 , which include a user interface 122 , and/or data entry controllers 125 , and/or data storage devices 127 .
  • the data entry system 105 may include one or more general-purpose computers (e.g., personal computers), one or more special-purpose computers (e.g., devices specifically programmed to communicate with each other and/or the data storage system 110 ), or a combination of one or more general-purpose computers and one or more special-purpose computers.
  • the data entry system 105 may be arranged to operate within or in concert with one or more other systems, such as for example, one or more LANs (“Local Area Networks”) and/or one or more WANs (“Wide Area Networks”).
  • LANs Local Area Networks
  • WANs Wide Area Networks
  • the data entry device 120 is generally capable of executing instructions under the command of a data entry controller 125 .
  • the data entry device 120 is connected to the data entry controller 125 by a wired or wireless data pathway 130 capable of transferring information.
  • the data entry device 120 , data entry controller 125 , and data storage device each typically includes one or more hardware components and/or software components.
  • An example of a data entry device 120 is a general-purpose computer (e.g., a personal computer), which may receive data through a user interface 122 and which is capable of responding to and executing instructions in a defined manner.
  • Other examples include special-purpose computer, a workstation, a server, a hand-held computer, a mobile telephone, a personal digital assistant (“PDA”), a device, a component, other equipment or some combination thereof capable of responding to and executing instructions.
  • An example of data entry controller 125 is a software application loaded on the data entry device 120 for commanding and directing the input of data enabled by the data entry device 120 .
  • the data entry controller 125 may be embodied permanently or temporarily in any type of machine, component, equipment, storage medium, or propagated signal capable of providing instructions to the data entry device 120 .
  • An example of data storage device 127 is a magnetic media disk for storing data and coupled to data entry device 120 by a communication link 129 .
  • Data entry device may run database software for managing and organizing the storage of data on data storage device 127 in a data model that is understandable to a user, and the database software may present the data stored on the data storage device 127 to the user within the context of the data model.
  • the communications link 115 typically includes a delivery network 160 making a direct or indirect communication between the data entry system 105 and the data storage system 110 , irrespective of physical separation.
  • a delivery network 160 include the Internet, the World Wide Web, WANs, LANs, analog or digital wired and wireless telephone networks (e.g., PSTN, ISDN, or xDSL), radio, television, cable, satellite, and/or any other delivery mechanism for carrying data.
  • the communications link 115 may include communication pathways 150 , 155 that enable communications through the one or more delivery networks 160 described above. Each of the communication pathways 150 , 155 may include, for example, a wired, wireless, cable, or satellite communication pathway.
  • the first data storage system 110 typically includes one or more data storage devices 135 capable of executing instructions under the command and direction of a data storage controller 140 .
  • the data storage device 135 is connected to the data storage controller 140 by a wired or wireless data pathway 145 capable of carrying and delivering data and/or data storage controllers 140 .
  • the first data storage system 110 may include one or more general-purpose computers (e.g., personal computers), one or more special-purpose computers (e.g., devices specifically programmed to communicate with each other and/or the data entry system 105 ), or a combination of one or more general-purpose computers and one or more special-purpose computers.
  • the data storage system 110 may be arranged to operate within or in concert with one or more other systems, such as, for example, one or more LANs (“Local Area Networks”) and/or one or more WANs (“Wide Area Networks”).
  • the data storage device 135 and data storage controller 140 each typically includes one or more hardware components and/or software components.
  • An example of a data storage device 135 is a general-purpose computer (e.g., a personal computer) coupled to a data storage medium 142 through a communications link 144 and capable of responding to and executing instructions in a defined manner.
  • Other examples include a special-purpose computer, a workstation, a server, a device, a component, other equipment or some combination thereof capable of responding to and executing instructions.
  • An example of data storage controller 140 is a software application (e.g., a database application) loaded on the data storage device 135 for commanding and directing the storage and presentation of data stored on the data storage device 135 in a data model that is understandable to a user.
  • the software application may present the data stored on the data storage device 135 to the user within the context of the data model.
  • Other examples include a program, a piece of code, an instruction, a device, a computer, a computer system, or a combination thereof, for independently or collectively instructing the data storage device 135 to interact and operate as described herein.
  • the data storage controller 140 may be embodied permanently or temporarily in any type of machine, component, equipment, storage medium, or propagated signal capable of providing instructions to the data storage device 135 .
  • the second data storage system 170 typically includes one or more data storage devices 175 capable of executing instructions under the command and direction of a data storage controller 180 .
  • the data storage device 175 is connected to the data storage controller 180 by a wired or wireless data pathway 185 capable of carrying and delivering data.
  • the second data storage system 170 may include one or more general-purpose computers (e.g., personal computers), one or more special-purpose computers (e.g., devices specifically programmed to communicate with each other and/or the data entry system 105 ), or a combination of one or more general-purpose computers and one or more special-purpose computers.
  • the second data storage system 170 may be arranged to operate within or in concert with one or more other systems, such as, for example, one or more LANs (“Local Area Networks”) and/or one or more WANs (“Wide Area Networks”).
  • the data storage device 175 and data storage controller 180 each typically includes one or more hardware components and/or software components.
  • An example of a data storage device 175 is a general-purpose computer (e.g., a personal computer) coupled to a data storage medium 182 through a communications link 184 and capable of responding to and executing instructions in a defined manner.
  • Other examples include a special-purpose computer, a workstation, a server, a device, a component, other equipment or some combination thereof capable of responding to and executing instructions.
  • An example of data storage controller 180 is a software application (e.g., a database application) loaded on the data storage device 175 for commanding and directing the storage and presentation of data stored on the data storage device 175 in a data model that is understandable to a user.
  • the software application may present the data stored on the data storage device 175 to the user within the context of the data model.
  • Other examples include a program, a piece of code, an instruction, a device, a computer, a computer system, or a combination thereof, for independently or collectively instructing the data storage device 175 to interact and operate as described herein.
  • the data storage controller 180 may be embodied permanently or temporarily in any type of machine, component, equipment, storage medium, or propagated signal capable of providing instructions to the data storage device 175 .
  • Data are stored in storage devices 127 , 142 , 182 using a data model for characterizing and organizing the stored data.
  • a data model of a customer sales database may include data records that include customer names, billing address, delivery address, telephone numbers, Dun & Bradstreet numbers, sales revenue generated on a monthly basis, and/or most frequently purchased items.
  • the data model is chosen to optimize the utility of the stored data for a program that accesses the stored data.
  • the shipping department of a company may require information about the customer's shipping address but may not need information about the customer's Dun & Bradstreet number or billing address.
  • the accounting department of the company may require the latter information but not the former.
  • the data may be stored in different formats depending on the data model in which the data are stored.
  • sales revenue data for an international organization may be stored in terms of local currency for purposes of regional salespersons but in terms of the currency used by the corporate headquarters for purposes of annual accounting
  • English or metric measurement units may be used for dimensional data of a product depending on whether the data are being used by an American branch or by an international branch of the organization.
  • the underlying data model can be flexible enough to accept data in a multitude of different formats that are compatible with different programs that can access the data.
  • a flexible data model can be overly complex and confusing to the person entering the data. It is less cumbersome and more efficient for the user entering the data to input the data using a single data model.
  • a process 200 can be run for converting data from a data entry data model that is generally user-friendly for the person entering the data to a data storage model that is generally process-friendly for a program accessing and using the stored data.
  • the process begins (step 202 ), and the data entry user logs into the data entry system 105 (step 204 ).
  • the login process can identify the user and/or the user's role or position with the organization. For example, the login process can identify the user as a native French speaking salesperson, who uses the metric system, and who enters his sales revenue information on a weekly basis.
  • the data entry system can present a user-dependent data entry context to the user (step 206 ).
  • the data can be displayed through a user interface to the data entry system.
  • the data entry context provides certain user-specific default information to the user entering data (step 208 ).
  • This user-specific information can be information pertaining to the user's organization and/or the user's function within the organization. For example, basis based on the identity of the user, the system can automatically present a user interface to the user in which instructions are presented in French, measurement data are entered in metric units, and sale revenue data are entered on a weekly.
  • the system can determine, based on the identity of the user (e.g., a product designer), that the user always enters data that will be used by a particular department within the organization (e.g., a plant that produces products with automatic, robotic processes), and therefore the system can present a user-specific context for the user to enter data in a format that is most useful to people who will use the entered data (e.g., the production team that will be programming the robots).
  • the product designer can be presented with a user interface that requests data about the product that can be used to program the robots to produce the product.
  • the product designer can override the defaults and enter data in a format that is most useful to people at the different plant who will produce the product.
  • a user-specific data context is defined for the user entering data into the data entry system 105 .
  • the data context is not binding on the user, and the user can change the data context before entering data into the data system 105 or before passing the data to a data storage device 127 , 135 , 170 .
  • the user-specific data context is used to enhance the efficiency of data entry by setting default values that are correct for the user most of the time, although they can be altered by the user when necessary.
  • the user After the user-specific data context is defined and the user interface is presented to the user, the user enters data into the data entry system 105 through the user interface 122 (step 210 ). The user enters the data in a data entry data model.
  • the data received by the data entry system 105 are converted from the data entry data model into a data storage data model (step 212 ).
  • the data model used for storing the data can require that the data be stored in English rather than French, that English rather than metric measurement units be used, and that sales revenue data be stored in terms of sales per month rather than sales per week.
  • the data entry system 105 or one of the data storage systems 135 , 170 performs this transformation on the data entered in the data entry data model before storing the data or before delivering the data to a user accessing the stored data.
  • Data can also be generated based on the data received in the data entry data model. For example, when information about a customer's name and address are entered in the data entry data model, a Dun & Bradstreet number for the customer can be derived and entered in the data storage data model of the data that will be used by the accounting department. Also for example, the plant in which a product is to be produced may be derivable from the data entered in the data entry data model, and the data can be converted from the data entry data model to a data storage model that is most useful for the production engineers at the plant where the product will be produced. Thus, the system may derive the plant in which the product will be produced, and the user need not enter this information.
  • the system may transform the inputted data from the data entry model into more than one data storage model when the data will be accessed in the form of more than one data storage model.
  • a company may have several production plants, each of which has its own data storage model.
  • the system may receive the inputted data and transform the data into more than one data storage model for use by users at the different plants.
  • the data are stored (step 214 ) in a data storage device 127 , 135 , 175 for later access, and the process ends (step 216 ).
  • the above-described process is related to a process 300 for ensuring the quality of data entered into the system.
  • the process begins (step 302 ) and a data request is submitted by a person requesting data, and the request is received by the system (step 304 ).
  • This request provides a seed of data into the system that can grow and become more formalized through additional data entry during later steps.
  • the data requestor may be a sales manager who specifies what data must be entered by sales representatives into the system. In general, this person has some information about the rules that will apply to the requested data, but the person does not necessarily know all the details of the applicable rules.
  • the system can require a certain level of data consistency from the data requester (e.g., the data requester cannot ask for a product's color to be entered when the product has only one color). Nevertheless, the data quality of the requested data entered by the data requester will generally be low, and the requester is not forced to abide by all rules that are applicable to the data when entering the data.
  • He might be required to abide by some rules when making a request for data e.g., when requesting sales revenue data, he may be required to also request the name of the customer who is responsible for the sales revenue), however, his non-adherence to other rules may be presented to him as warnings that he may correct at the moment or at a later time (e.g., if the data requester requests that a customer's telephone number be entered, he may be warned or prompted also to request the customer's address, but he is not required to request the address at this time).
  • a data entry specialist enhances the data based on the data request (step 306 ).
  • the data entry specialist takes over the data entry task from the data requestor and corrects the data requested to improve the quality of the data.
  • all basic rules are active, and he cannot release data until the data abide by all basic rules.
  • the data are released for use by other users (step 308 ).
  • a refinement of the data may be necessary because further criteria may often need to be met, and it may be necessary for the data to comply with advanced rules.
  • an advanced rules engine is triggered to evaluate compliance with the advanced rules and determine if any inconsistencies exist in the data (step 310 ).
  • the advanced rules may have a long run time and may not be executable in real time. If no errors are found, the process 300 ends (step 316 ). When errors are found, the errors are dispatched to a corresponding error corrector (step 312 ), who can review the afflicted data object and a description of the error.
  • the assignment of an error to an error corrector can be performed in a hierarchical manner. Initially, the correction of each different error can be assigned to a different error corrector. However, if the workload of responding to a particular error (e.g., type A errors) becomes too great, then all type A errors for a particular product type (e.g., product ⁇ ) may be sent to error corrector 1 for correction, while all type A errors for a different product type (e.g., product ⁇ ) can be sent to error corrector 2 for correction. In this way, a general assignment of rare errors is performed, while a detailed assignment of common errors is performed with a minimum of customization. By dividing the data entry process among the data requester, the data entry specialist, and the data corrector, data grow slowly and become more formalized during several steps.
  • the error corrector After an error has been assigned and dispatched to an error corrector, the error corrector is allowed a certain amount of time to correct the error. For each error a timeframe is defined in which the error must be resolved. For example, an error reporting that a customer's name is missing from a data entry might have to be resolved within a week, while an error reporting a missing Dun & Bradstreet number for the customer might be less important to the company compiling the data and two months may be allowed for this error to be resolved.
  • the corrected data After errors are corrected (step 314 ) the corrected data are released to other users (step 308 ) and compliance with advances rules is evaluated again.
  • the system monitors the correction of errors and sends reminders to the assigned error correctors that the errors must be corrected within their specified timeframes.
  • the system therefore ensures that errors are caught and resolved. Also, the system can determine automatically when an error corrector's workload becomes too high and begins shifting errors to other error correctors to be resolved. Thus, the resources of the error correctors can be used most efficiently.
  • the invention can be implemented in digital electronic circuitry, or in computer hardware, firmware, software, or in combinations of them.
  • the invention can be implemented as a computer program product, i.e., a computer program tangibly embodied in an information carrier, e.g., in a machine-readable storage device or in a propagated signal, for execution by, or to control the operation of, data processing apparatus, e.g., a programmable processor, a computer, or multiple computers.
  • a computer program can be written in any form of programming language, including compiled or interpreted languages, and it can be deployed in any form, including as a stand-alone program or as a module, component, subroutine, or other unit suitable for use in a computing environment.
  • a computer program can be deployed to be executed on one computer or on multiple computers at one site or distributed across multiple sites and interconnected by a communication network.
  • Method steps of the invention can be performed by one or more programmable processors executing a computer program to perform functions of the invention by operating on input data and generating output. Method steps can also be performed by, and apparatus of the invention can be implemented as, special purpose logic circuitry, e.g., an FPGA (field programmable gate array) or an ASIC (application-specific integrated circuit).
  • FPGA field programmable gate array
  • ASIC application-specific integrated circuit
  • processors suitable for the execution of a computer program include, by way of example, both general and special purpose microprocessors, and any one or more processors of any kind of digital computer.
  • a processor will receive instructions and data from a read-only memory or a random access memory or both.
  • the essential elements of a computer are a processor for executing instructions and one or more memory devices for storing instructions and data.
  • a computer will also include, or be operatively coupled to receive data from or transfer data to, or both, one or more mass storage devices for storing data, e.g., magnetic, magneto-optical disks, or optical disks.
  • Information carriers suitable for embodying computer program instructions and data include all forms of non-volatile memory, including by way of example semiconductor memory devices, e.g., EPROM, EEPROM, and flash memory devices; magnetic disks such as internal hard disks and removable disks; magneto-optical disks; and CD-ROM and DVD-ROM disks.
  • semiconductor memory devices e.g., EPROM, EEPROM, and flash memory devices
  • magnetic disks such as internal hard disks and removable disks
  • magneto-optical disks and CD-ROM and DVD-ROM disks.
  • the processor and the memory can be supplemented by, or incorporated in special purpose logic circuitry.
  • the invention can be implemented on a computer having a display device such as a CRT (cathode ray tube) or LCD (liquid crystal display) monitor for displaying information to the user and a keyboard and a pointing device such as a mouse or a trackball by which the user can provide input to the computer.
  • a display device such as a CRT (cathode ray tube) or LCD (liquid crystal display) monitor for displaying information to the user and a keyboard and a pointing device such as a mouse or a trackball by which the user can provide input to the computer.
  • Other kinds of devices can be used to provide for interaction with a user as well; for example, feedback provided to the user can be any form of sensory feedback, such as visual feedback, auditory feedback, or tactile feedback; and input from the user can be received in any form, including acoustic, speech, or tactile input.
  • the invention can be implemented in a computing system that includes a back-end component, e.g., as a data server, or that includes a middleware component, e.g., an application server, or that includes a front-end component, e.g., a client computer having a graphical user interface or an Web browser through which a user can interact with an implementation of the invention, or any combination of such back-end, middleware, or front-end components.
  • the components of the system can be interconnected by any form or medium of digital data communication, e.g., a communication network. Examples of communication networks include a local area network (“LAN”), a wide area network (“WAN”), and the Internet.
  • LAN local area network
  • WAN wide area network
  • the Internet the global information network
  • the computing system can include clients and servers.
  • a client and server are generally remote from each other and typically interact through a communication network.
  • the relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other.

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Quality & Reliability (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

A method of enhancing the quality of data stored in a system includes receiving data from a first data enterer, accepting data received from the first data enterer into the system if the data are entered in a format compliant with a first set of rules, receiving first additional data from a second data enterer, the first additional data being related to the data received from the first data enterer, and accepting first additional data received from the second data enterer into the system if the data are entered in a format compliant with a second set of rules.

Description

TECHNICAL FIELD
This invention relates to data management and more particularly to ensuring master data quality.
BACKGROUND
Information technology (“IT”) environments can consist of many different systems performing processes, such as business processes, on common data. The different systems can be part of the same entity or can be part of different entities, such as vendors or contractors. The data used for the processes can be stored in a number of different locations, systems, and/or formats. Different plants and branch offices of a company can work largely independently from each other and can store data in different formats; adopted companies can introduce new software solutions to a group of affiliated companies that require that data be stored in different formats; and systems from different vendors can be linked, but each vendor may specify that data be stored in different formats. Different data models can make it difficult to integrate business processes in these scenarios.
Thus, the format in which data are entered into an IT environment depends strongly on the underlying data model used for storing the data in a particular location. For example, measurement data may be stored in English units at one plant but in metric units in another plant, or sales data may be stored in terms of revenue per month for one regional sales department, but in terms of revenue per week in another regional sales department. Because the format in which data are entered depends on the underlying data storage model, the user must recognize the underlying data model of the particular data storage system and must conform the format in which data are entered to the underlying data model. Furthermore, the user must ensure when data are entered into the system the data meet certain consistency checks that are imposed by the underlying data model. The data are not accepted until the consistency checks are satisfied.
SUMMARY
In a first general aspect, a method of enhancing the quality of data stored in a system includes receiving data from a first data enterer, accepting data received from the first data enterer into the system if the data are entered in a format compliant with a first set of rules, receiving first additional data from a second data enterer, the first additional data being related to the data received from the first data enterer, and accepting first additional data received from the second data enterer into the system if the data are entered in a format compliant with a second set of rules.
In a second general aspect, a computer program product, tangibly stored on a machine readable medium, for enhancing the quality of data stored in a system, includes instructions for causing a processor to receive data from a first data enterer, accept data received from the first data enterer into the system if the data are entered in a format compliant with a first set of rules, receive first additional data from a second data enterer, the first additional data being related to the data received from the first data enterer, and accept first additional data received from the second data enterer into the system if the data are entered in a format compliant with a second set of rules.
One or more of the following features can be included. For example, to comply with the second set of rules, the data must also comply with the first set of rules. Data accepted into the system can be compared with a third set of rules, an inconsistency in data entered into the system with a rule from the third set of rules can be detected, a report of the inconsistency can be dispatched to an error corrector, and corrected data can be received from the error corrector. To comply with the third set of rules, the data may be required also to comply with the second set of rules. The data received from the first and second data enterers and entered into the system for use by a user of the system can be released before the corrected data are received from the error corrector. It can be required that the inconsistency be corrected by the error corrector within a particular timeframe, and the error corrector can be reminded to correct the data before the end of the timeframe. A particular error can be dispatched to a particular error corrector for correction. The load of errors assigned to an error corrector can be monitored, and an additional report of inconsistency can be dispatched to another error corrector when the load of errors assigned to the error corrector exceeds a threshold load.
The details of one or more implementations are set forth in the accompanying drawings and the description below. Other features will be apparent from the description and drawings, and from the claims.
DESCRIPTION OF DRAWINGS
FIG. 1 is a schematic diagram of a system for entering and storing data.
FIG. 2 is a flow chart of a process for entering and storing data.
FIG. 3 is a flow chart of a process for ensuring data quality.
Like reference symbols in the various drawings indicate like elements.
DETAILED DESCRIPTION
For illustrative purposes, FIG. 1 describes a communications system for implementing techniques for entering and storing data. For brevity, several elements in the figures described below are represented as monolithic entities. However, as would be understood by one skilled in the art, these elements each may include numerous interconnected computers and components designed to perform a set of specified operations and/or dedicated to a particular geographical region.
Referring to FIG. 1, a data entry and storage system 100 is capable of receiving data at a data entry system 105 and a storing data in the data entry system 105 or transferring the data through a communications link 115 to one or more data storage systems 110, 170 for storage. Data entry and storage system 100 may exist within an organization and may include components remotely located from each other and/or components that are used by different users within the organization. The data entry system 105 typically includes one or more data entry devices 120, which include a user interface 122, and/or data entry controllers 125, and/or data storage devices 127. For example, the data entry system 105 may include one or more general-purpose computers (e.g., personal computers), one or more special-purpose computers (e.g., devices specifically programmed to communicate with each other and/or the data storage system 110), or a combination of one or more general-purpose computers and one or more special-purpose computers. The data entry system 105 may be arranged to operate within or in concert with one or more other systems, such as for example, one or more LANs (“Local Area Networks”) and/or one or more WANs (“Wide Area Networks”).
The data entry device 120 is generally capable of executing instructions under the command of a data entry controller 125. The data entry device 120 is connected to the data entry controller 125 by a wired or wireless data pathway 130 capable of transferring information.
The data entry device 120, data entry controller 125, and data storage device each typically includes one or more hardware components and/or software components. An example of a data entry device 120 is a general-purpose computer (e.g., a personal computer), which may receive data through a user interface 122 and which is capable of responding to and executing instructions in a defined manner. Other examples include special-purpose computer, a workstation, a server, a hand-held computer, a mobile telephone, a personal digital assistant (“PDA”), a device, a component, other equipment or some combination thereof capable of responding to and executing instructions. An example of data entry controller 125 is a software application loaded on the data entry device 120 for commanding and directing the input of data enabled by the data entry device 120. Other examples include a program, a piece of code, an instruction, a device, a computer, a computer system, or a combination thereof, for independently or collectively instructing the data entry device 120 to interact and operate as described herein. The data entry controller 125 may be embodied permanently or temporarily in any type of machine, component, equipment, storage medium, or propagated signal capable of providing instructions to the data entry device 120. An example of data storage device 127 is a magnetic media disk for storing data and coupled to data entry device 120 by a communication link 129. Data entry device may run database software for managing and organizing the storage of data on data storage device 127 in a data model that is understandable to a user, and the database software may present the data stored on the data storage device 127 to the user within the context of the data model.
The communications link 115 typically includes a delivery network 160 making a direct or indirect communication between the data entry system 105 and the data storage system 110, irrespective of physical separation. Examples of a delivery network 160 include the Internet, the World Wide Web, WANs, LANs, analog or digital wired and wireless telephone networks (e.g., PSTN, ISDN, or xDSL), radio, television, cable, satellite, and/or any other delivery mechanism for carrying data. The communications link 115 may include communication pathways 150, 155 that enable communications through the one or more delivery networks 160 described above. Each of the communication pathways 150, 155 may include, for example, a wired, wireless, cable, or satellite communication pathway.
The first data storage system 110 typically includes one or more data storage devices 135 capable of executing instructions under the command and direction of a data storage controller 140. The data storage device 135 is connected to the data storage controller 140 by a wired or wireless data pathway 145 capable of carrying and delivering data and/or data storage controllers 140. For example, the first data storage system 110 may include one or more general-purpose computers (e.g., personal computers), one or more special-purpose computers (e.g., devices specifically programmed to communicate with each other and/or the data entry system 105), or a combination of one or more general-purpose computers and one or more special-purpose computers. The data storage system 110 may be arranged to operate within or in concert with one or more other systems, such as, for example, one or more LANs (“Local Area Networks”) and/or one or more WANs (“Wide Area Networks”).
The data storage device 135 and data storage controller 140 each typically includes one or more hardware components and/or software components. An example of a data storage device 135 is a general-purpose computer (e.g., a personal computer) coupled to a data storage medium 142 through a communications link 144 and capable of responding to and executing instructions in a defined manner. Other examples include a special-purpose computer, a workstation, a server, a device, a component, other equipment or some combination thereof capable of responding to and executing instructions. An example of data storage controller 140 is a software application (e.g., a database application) loaded on the data storage device 135 for commanding and directing the storage and presentation of data stored on the data storage device 135 in a data model that is understandable to a user. The software application may present the data stored on the data storage device 135 to the user within the context of the data model. Other examples include a program, a piece of code, an instruction, a device, a computer, a computer system, or a combination thereof, for independently or collectively instructing the data storage device 135 to interact and operate as described herein. The data storage controller 140 may be embodied permanently or temporarily in any type of machine, component, equipment, storage medium, or propagated signal capable of providing instructions to the data storage device 135.
The second data storage system 170 typically includes one or more data storage devices 175 capable of executing instructions under the command and direction of a data storage controller 180. The data storage device 175 is connected to the data storage controller 180 by a wired or wireless data pathway 185 capable of carrying and delivering data. For example, the second data storage system 170 may include one or more general-purpose computers (e.g., personal computers), one or more special-purpose computers (e.g., devices specifically programmed to communicate with each other and/or the data entry system 105), or a combination of one or more general-purpose computers and one or more special-purpose computers. The second data storage system 170 may be arranged to operate within or in concert with one or more other systems, such as, for example, one or more LANs (“Local Area Networks”) and/or one or more WANs (“Wide Area Networks”).
The data storage device 175 and data storage controller 180 each typically includes one or more hardware components and/or software components. An example of a data storage device 175 is a general-purpose computer (e.g., a personal computer) coupled to a data storage medium 182 through a communications link 184 and capable of responding to and executing instructions in a defined manner. Other examples include a special-purpose computer, a workstation, a server, a device, a component, other equipment or some combination thereof capable of responding to and executing instructions. An example of data storage controller 180 is a software application (e.g., a database application) loaded on the data storage device 175 for commanding and directing the storage and presentation of data stored on the data storage device 175 in a data model that is understandable to a user. The software application may present the data stored on the data storage device 175 to the user within the context of the data model. Other examples include a program, a piece of code, an instruction, a device, a computer, a computer system, or a combination thereof, for independently or collectively instructing the data storage device 175 to interact and operate as described herein. The data storage controller 180 may be embodied permanently or temporarily in any type of machine, component, equipment, storage medium, or propagated signal capable of providing instructions to the data storage device 175.
Data are stored in storage devices 127, 142, 182 using a data model for characterizing and organizing the stored data. For example, a data model of a customer sales database may include data records that include customer names, billing address, delivery address, telephone numbers, Dun & Bradstreet numbers, sales revenue generated on a monthly basis, and/or most frequently purchased items. Generally, the data model is chosen to optimize the utility of the stored data for a program that accesses the stored data. For example, the shipping department of a company may require information about the customer's shipping address but may not need information about the customer's Dun & Bradstreet number or billing address. However, the accounting department of the company may require the latter information but not the former. Additionally, the data may be stored in different formats depending on the data model in which the data are stored. For example, sales revenue data for an international organization may be stored in terms of local currency for purposes of regional salespersons but in terms of the currency used by the corporate headquarters for purposes of annual accounting, and English or metric measurement units may be used for dimensional data of a product depending on whether the data are being used by an American branch or by an international branch of the organization. However, it is cumbersome and inefficient for the person entering the data to conform to the underlying data model when entering data. The underlying data model can be flexible enough to accept data in a multitude of different formats that are compatible with different programs that can access the data. However, a flexible data model can be overly complex and confusing to the person entering the data. It is less cumbersome and more efficient for the user entering the data to input the data using a single data model.
Thus, as illustrated in FIG. 2, a process 200 can be run for converting data from a data entry data model that is generally user-friendly for the person entering the data to a data storage model that is generally process-friendly for a program accessing and using the stored data.
The process begins (step 202), and the data entry user logs into the data entry system 105 (step 204). The login process can identify the user and/or the user's role or position with the organization. For example, the login process can identify the user as a native French speaking salesperson, who uses the metric system, and who enters his sales revenue information on a weekly basis.
After the user logs in and is identified by the system (step 204), the data entry system can present a user-dependent data entry context to the user (step 206). The data can be displayed through a user interface to the data entry system. The data entry context provides certain user-specific default information to the user entering data (step 208). This user-specific information can be information pertaining to the user's organization and/or the user's function within the organization. For example, basis based on the identity of the user, the system can automatically present a user interface to the user in which instructions are presented in French, measurement data are entered in metric units, and sale revenue data are entered on a weekly. As another example, the system can determine, based on the identity of the user (e.g., a product designer), that the user always enters data that will be used by a particular department within the organization (e.g., a plant that produces products with automatic, robotic processes), and therefore the system can present a user-specific context for the user to enter data in a format that is most useful to people who will use the entered data (e.g., the production team that will be programming the robots). For example, the product designer can be presented with a user interface that requests data about the product that can be used to program the robots to produce the product. However, if the product designer knows that his product will be produced at a different plant that requires more manual labor and less robotic labor, the product designer can override the defaults and enter data in a format that is most useful to people at the different plant who will produce the product.
Thus, a user-specific data context is defined for the user entering data into the data entry system 105. The data context is not binding on the user, and the user can change the data context before entering data into the data system 105 or before passing the data to a data storage device 127, 135, 170. However, the user-specific data context is used to enhance the efficiency of data entry by setting default values that are correct for the user most of the time, although they can be altered by the user when necessary.
After the user-specific data context is defined and the user interface is presented to the user, the user enters data into the data entry system 105 through the user interface 122 (step 210). The user enters the data in a data entry data model.
When the data entered by the user are to be stored and/or later accessed in a format or data model that is different from the data entry data model, the data received by the data entry system 105 are converted from the data entry data model into a data storage data model (step 212). For example, the data model used for storing the data can require that the data be stored in English rather than French, that English rather than metric measurement units be used, and that sales revenue data be stored in terms of sales per month rather than sales per week. The data entry system 105 or one of the data storage systems 135, 170 performs this transformation on the data entered in the data entry data model before storing the data or before delivering the data to a user accessing the stored data.
Data can also be generated based on the data received in the data entry data model. For example, when information about a customer's name and address are entered in the data entry data model, a Dun & Bradstreet number for the customer can be derived and entered in the data storage data model of the data that will be used by the accounting department. Also for example, the plant in which a product is to be produced may be derivable from the data entered in the data entry data model, and the data can be converted from the data entry data model to a data storage model that is most useful for the production engineers at the plant where the product will be produced. Thus, the system may derive the plant in which the product will be produced, and the user need not enter this information.
The system may transform the inputted data from the data entry model into more than one data storage model when the data will be accessed in the form of more than one data storage model. For example, a company may have several production plants, each of which has its own data storage model. Thus, the system may receive the inputted data and transform the data into more than one data storage model for use by users at the different plants.
After the data are transformed into the appropriate data storage model, the data are stored (step 214) in a data storage device 127, 135, 175 for later access, and the process ends (step 216).
Referring to FIG. 3, the above-described process is related to a process 300 for ensuring the quality of data entered into the system. The process begins (step 302) and a data request is submitted by a person requesting data, and the request is received by the system (step 304). This request provides a seed of data into the system that can grow and become more formalized through additional data entry during later steps. For example, the data requestor may be a sales manager who specifies what data must be entered by sales representatives into the system. In general, this person has some information about the rules that will apply to the requested data, but the person does not necessarily know all the details of the applicable rules. The system can require a certain level of data consistency from the data requester (e.g., the data requester cannot ask for a product's color to be entered when the product has only one color). Nevertheless, the data quality of the requested data entered by the data requester will generally be low, and the requester is not forced to abide by all rules that are applicable to the data when entering the data. He might be required to abide by some rules when making a request for data (e.g., when requesting sales revenue data, he may be required to also request the name of the customer who is responsible for the sales revenue), however, his non-adherence to other rules may be presented to him as warnings that he may correct at the moment or at a later time (e.g., if the data requester requests that a customer's telephone number be entered, he may be warned or prompted also to request the customer's address, but he is not required to request the address at this time).
After a data request has been formulated based on input from the data requester, a data entry specialist enhances the data based on the data request (step 306). The data entry specialist takes over the data entry task from the data requestor and corrects the data requested to improve the quality of the data. For the data entry specialist, all basic rules are active, and he cannot release data until the data abide by all basic rules. However, he can save data that are inconsistent to give him time to collect information to abide by all rules. For example, he can save customer sales revenue data that do not contain a customer's address, but before releasing the data to other users he may be required to enter the customer's address. After data abide by all basic rules, the data are released for use by other users (step 308).
However, even after data are released and they can be used by other users, they are not necessarily of sufficient quality for all purposes. A refinement of the data may be necessary because further criteria may often need to be met, and it may be necessary for the data to comply with advanced rules. Whenever data are changed or entered in the system an advanced rules engine is triggered to evaluate compliance with the advanced rules and determine if any inconsistencies exist in the data (step 310). The advanced rules may have a long run time and may not be executable in real time. If no errors are found, the process 300 ends (step 316). When errors are found, the errors are dispatched to a corresponding error corrector (step 312), who can review the afflicted data object and a description of the error. The assignment of an error to an error corrector can be performed in a hierarchical manner. Initially, the correction of each different error can be assigned to a different error corrector. However, if the workload of responding to a particular error (e.g., type A errors) becomes too great, then all type A errors for a particular product type (e.g., product α) may be sent to error corrector 1 for correction, while all type A errors for a different product type (e.g., product β) can be sent to error corrector 2 for correction. In this way, a general assignment of rare errors is performed, while a detailed assignment of common errors is performed with a minimum of customization. By dividing the data entry process among the data requester, the data entry specialist, and the data corrector, data grow slowly and become more formalized during several steps.
After an error has been assigned and dispatched to an error corrector, the error corrector is allowed a certain amount of time to correct the error. For each error a timeframe is defined in which the error must be resolved. For example, an error reporting that a customer's name is missing from a data entry might have to be resolved within a week, while an error reporting a missing Dun & Bradstreet number for the customer might be less important to the company compiling the data and two months may be allowed for this error to be resolved. After errors are corrected (step 314) the corrected data are released to other users (step 308) and compliance with advances rules is evaluated again.
The system monitors the correction of errors and sends reminders to the assigned error correctors that the errors must be corrected within their specified timeframes. The system therefore ensures that errors are caught and resolved. Also, the system can determine automatically when an error corrector's workload becomes too high and begins shifting errors to other error correctors to be resolved. Thus, the resources of the error correctors can be used most efficiently.
The invention can be implemented in digital electronic circuitry, or in computer hardware, firmware, software, or in combinations of them. The invention can be implemented as a computer program product, i.e., a computer program tangibly embodied in an information carrier, e.g., in a machine-readable storage device or in a propagated signal, for execution by, or to control the operation of, data processing apparatus, e.g., a programmable processor, a computer, or multiple computers. A computer program can be written in any form of programming language, including compiled or interpreted languages, and it can be deployed in any form, including as a stand-alone program or as a module, component, subroutine, or other unit suitable for use in a computing environment. A computer program can be deployed to be executed on one computer or on multiple computers at one site or distributed across multiple sites and interconnected by a communication network.
Method steps of the invention can be performed by one or more programmable processors executing a computer program to perform functions of the invention by operating on input data and generating output. Method steps can also be performed by, and apparatus of the invention can be implemented as, special purpose logic circuitry, e.g., an FPGA (field programmable gate array) or an ASIC (application-specific integrated circuit).
Processors suitable for the execution of a computer program include, by way of example, both general and special purpose microprocessors, and any one or more processors of any kind of digital computer. Generally, a processor will receive instructions and data from a read-only memory or a random access memory or both. The essential elements of a computer are a processor for executing instructions and one or more memory devices for storing instructions and data. Generally, a computer will also include, or be operatively coupled to receive data from or transfer data to, or both, one or more mass storage devices for storing data, e.g., magnetic, magneto-optical disks, or optical disks. Information carriers suitable for embodying computer program instructions and data include all forms of non-volatile memory, including by way of example semiconductor memory devices, e.g., EPROM, EEPROM, and flash memory devices; magnetic disks such as internal hard disks and removable disks; magneto-optical disks; and CD-ROM and DVD-ROM disks. The processor and the memory can be supplemented by, or incorporated in special purpose logic circuitry.
To provide for interaction with a user, the invention can be implemented on a computer having a display device such as a CRT (cathode ray tube) or LCD (liquid crystal display) monitor for displaying information to the user and a keyboard and a pointing device such as a mouse or a trackball by which the user can provide input to the computer. Other kinds of devices can be used to provide for interaction with a user as well; for example, feedback provided to the user can be any form of sensory feedback, such as visual feedback, auditory feedback, or tactile feedback; and input from the user can be received in any form, including acoustic, speech, or tactile input.
The invention can be implemented in a computing system that includes a back-end component, e.g., as a data server, or that includes a middleware component, e.g., an application server, or that includes a front-end component, e.g., a client computer having a graphical user interface or an Web browser through which a user can interact with an implementation of the invention, or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication, e.g., a communication network. Examples of communication networks include a local area network (“LAN”), a wide area network (“WAN”), and the Internet.
The computing system can include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other.
A number of embodiments have been described. Nevertheless, it will be understood that various modifications may be made without departing from the spirit and scope of the invention. Accordingly, other embodiments are within the scope of the following claims.

Claims (18)

1. A method of enhancing quality of data stored in a system, the method comprising:
receiving data from a first data enterer;
accepting data received from the first data enterer into the system if the data are entered in a format compliant with a first set of rules;
receiving first additional data from a second data enterer, the first additional data being related to the data received from the first data enterer;
accepting first additional data received from the second data enterer into the system if the data is entered in a format compliant with a second set of rules;
comparing data accepted into the system with a third set of rules;
detecting an inconsistency in data accepted into the system with a rule from the third set of rules;
dispatching a report of the inconsistency to an error corrector; and
receiving corrected data from the error corrector.
2. The method of claim 1, wherein, to comply with the second set of rules, the data must also comply with the first set of rules.
3. The method of claim 1, wherein, to comply with the third set of rules, the data must also comply with the second set of rules.
4. The method of claim 1, further comprising releasing the data received from the first and second data enterers and entered into the system, the releasing being performed before the corrected data is received from the error corrector.
5. The method of claim 1, further comprising requiring that the inconsistency be corrected by the error corrector within a particular timeframe.
6. The method of claim 5, further comprising reminding the error corrector to correct the data before the end of the timeframe.
7. The method of claim 1, further comprising:
dispatching a particular error to a particular error corrector for correction.
8. The method of claim 7, further comprising:
monitoring a load of errors assigned to an error corrector; and
dispatching an additional report of inconsistency to another error corrector when the load of errors assigned to the error corrector exceeds a threshold load.
9. A computer program product, tangibly stored on a machine readable medium, for enhancing a quality of data stored in a system, the computer program product comprising instructions for causing a processor to:
receive data from a first data enterer;
accept data received from the first data enterer into the system if the data are entered in a format compliant with a first set of rules;
receive first additional data from a second data enterer, the first additional data being related to the data received from the first data enterer;
accept first additional data received from the second data enterer into the system if the data is entered in a format compliant with a second set of rules;
compare data accepted into the system with a third set of rules;
detect an inconsistency in data accepted into the system with a rule from the third set of rules;
dispatch a report of the inconsistency to an error corrector; and
receive corrected data from the error corrector.
10. The computer program product of claim 9, wherein, to comply with the second set of rules, the data must also comply with the first set of rules.
11. The computer program product of claim 9, wherein, to comply with the third set of rules, the data must also comply with the second set of rules.
12. The computer program product of claim 9, wherein the computer program product further comprises instructions for causing a processor to release the data received from the first and second data enterers and entered into the system, the releasing being performed before the corrected data is received from the error corrector.
13. The computer program product of claim 9, wherein the computer program product further comprises instructions for causing a processor to require that the inconsistency be corrected by the error corrector within a particular timeframe.
14. The computer program product of claim 13, wherein the computer program product further comprises instructions for causing a processor to remind the error corrector to correct the data before the end of the timeframe.
15. The computer program product of claim 9, wherein the computer program product further comprises instructions for causing a processor to dispatch a particular error to a particular error corrector for correction.
16. The computer program product of claim 15, wherein the computer program product further comprises instructions for causing a processor to:
monitor a load of errors assigned to an error corrector; and
dispatch an additional report of inconsistency to another error corrector when the load of errors assigned to the error corrector exceeds a threshold load.
17. A system for enhancing a quality of data stored in a system, the system comprising:
a data storage system;
a controller communicably coupled to the data storage system, the controller configured to:
receive data from first data entry device;
accept the data received from the first data entry device for storage in the data storage system if the data is entered in a format compliant with a first set of rules;
receive first additional data from a second data entry device, the first additional data being related to the data recieved from the first data enterer;
accept first additional data recieved from the second data entry device for storage in the data storage system if the data are entered in a format compliant with a second set of rules;
compare the accepted data with a third set of rules;
detect an inconsistency in data stored in the data storage system with a rule from the third set of rules;
dispatch a report of the inconsistency to an error corrector; and
receive corrected data from the error corrector.
18. The system of claim 17, further comprising one or more networks coupled to the data storage system and to the controller.
US10/747,663 2003-12-30 2003-12-30 Master data quality Active 2025-02-14 US7272776B2 (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
US10/747,663 US7272776B2 (en) 2003-12-30 2003-12-30 Master data quality
PCT/EP2004/014690 WO2005064491A1 (en) 2003-12-30 2004-12-23 Detection and correction of data quality problems

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
US10/747,663 US7272776B2 (en) 2003-12-30 2003-12-30 Master data quality

Publications (2)

Publication Number Publication Date
US20050144552A1 US20050144552A1 (en) 2005-06-30
US7272776B2 true US7272776B2 (en) 2007-09-18

Family

ID=34700784

Family Applications (1)

Application Number Title Priority Date Filing Date
US10/747,663 Active 2025-02-14 US7272776B2 (en) 2003-12-30 2003-12-30 Master data quality

Country Status (2)

Country Link
US (1) US7272776B2 (en)
WO (1) WO2005064491A1 (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120246110A1 (en) * 2011-03-22 2012-09-27 Sap Ag Master Data Management in a Data Warehouse/Data Mart
US10147040B2 (en) 2017-01-20 2018-12-04 Alchemy IoT Device data quality evaluator
US20230107253A1 (en) * 2018-08-24 2023-04-06 Acuitive Solutions, Inc. Graphical user interface and error detection system for analyzing big datasets

Families Citing this family (20)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8200622B2 (en) 2002-05-31 2012-06-12 Informatica Corporation System and method for integrating, managing and coordinating customer activities
US7426520B2 (en) 2003-09-10 2008-09-16 Exeros, Inc. Method and apparatus for semantic discovery and mapping between data sources
US7496588B2 (en) 2005-06-27 2009-02-24 Siperian, Inc. Method and apparatus for data integration and management
US7526677B2 (en) * 2005-10-31 2009-04-28 Microsoft Corporation Fragility handling
US8150803B2 (en) 2006-01-03 2012-04-03 Informatica Corporation Relationship data management
EP1974276A4 (en) * 2006-01-03 2009-11-25 Siperian Inc Relationship data management
US7523121B2 (en) 2006-01-03 2009-04-21 Siperian, Inc. Relationship data management
US7836004B2 (en) * 2006-12-11 2010-11-16 International Business Machines Corporation Using data mining algorithms including association rules and tree classifications to discover data rules
US8171001B2 (en) * 2007-06-27 2012-05-01 International Business Machines Corporation Using a data mining algorithm to generate rules used to validate a selected region of a predicted column
US8166000B2 (en) * 2007-06-27 2012-04-24 International Business Machines Corporation Using a data mining algorithm to generate format rules used to validate data sets
US8401987B2 (en) * 2007-07-17 2013-03-19 International Business Machines Corporation Managing validation models and rules to apply to data sets
US9225684B2 (en) * 2007-10-29 2015-12-29 Microsoft Technology Licensing, Llc Controlling network access
US8224873B1 (en) 2008-05-22 2012-07-17 Informatica Corporation System and method for flexible security access management in an enterprise
US8166071B1 (en) 2008-05-22 2012-04-24 Informatica Corporation System and method for efficiently securing enterprise data resources
US9720971B2 (en) * 2008-06-30 2017-08-01 International Business Machines Corporation Discovering transformations applied to a source table to generate a target table
US8458148B2 (en) * 2009-09-22 2013-06-04 Oracle International Corporation Data governance manager for master data management hubs
US8751436B2 (en) 2010-11-17 2014-06-10 Bank Of America Corporation Analyzing data quality
EP2691878A1 (en) * 2011-03-28 2014-02-05 Telefonaktiebolaget L M Ericsson (PUBL) Data management in a data virtualization environment
US8930303B2 (en) 2012-03-30 2015-01-06 International Business Machines Corporation Discovering pivot type relationships between database objects
WO2014173298A1 (en) * 2013-04-25 2014-10-30 飞天诚信科技股份有限公司 Method for managing application on card

Citations (53)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4459663A (en) 1981-07-02 1984-07-10 American Business Computer Data processing machine and method of allocating inventory stock for generating work orders for producing manufactured components
US5099431A (en) 1989-10-23 1992-03-24 International Business Machines Corporation Automated re-work shop order scheduling system
US5182705A (en) 1989-08-11 1993-01-26 Itt Corporation Computer system and method for work management
US5191534A (en) 1990-08-21 1993-03-02 International Business Machines Corporation Engineering and manufacturing change control mechanism
US5311424A (en) 1991-06-28 1994-05-10 International Business Machines Corporation Method and system for product configuration definition and tracking
US5442782A (en) 1993-08-13 1995-08-15 Peoplesoft, Inc. Providing information from a multilingual database of language-independent and language-dependent items
US5655085A (en) 1992-08-17 1997-08-05 The Ryan Evalulife Systems, Inc. Computer system for automated comparing of universal life insurance policies based on selectable criteria
US5694598A (en) 1994-10-12 1997-12-02 U S West Technologies, Inc. Method for mapping data between a relational format and an object-oriented format
US5703938A (en) 1995-08-28 1997-12-30 Mct Communications Corp. Method of optimizing access trunk configurations and system therefor
US5710884A (en) 1995-03-29 1998-01-20 Intel Corporation System for automatically updating personal profile server with updates to additional user information gathered from monitoring user's electronic consuming habits generated on computer during use
US5758031A (en) * 1992-11-10 1998-05-26 Omron Corporation Rule generating apparatus and method
US5859972A (en) 1996-05-10 1999-01-12 The Board Of Trustees Of The University Of Illinois Multiple server repository and multiple server remote application virtual client computer
US5911139A (en) 1996-03-29 1999-06-08 Virage, Inc. Visual image database search engine which allows for different schema
US6018742A (en) 1998-07-07 2000-01-25 Perigis Corporation Constructing a bifurcated database of context-dependent and context-independent data items
US6029195A (en) 1994-11-29 2000-02-22 Herz; Frederick S. M. System for customized electronic identification of desirable objects
US6032147A (en) 1996-04-24 2000-02-29 Linguateq, Inc. Method and apparatus for rationalizing different data formats in a data management system
US6067525A (en) 1995-10-30 2000-05-23 Clear With Computers Integrated computerized sales force automation system
US6226650B1 (en) 1998-09-17 2001-05-01 Synchrologic, Inc. Database synchronization and organization system and method
US6236997B1 (en) 1997-06-23 2001-05-22 Oracle Corporation Apparatus and method for accessing foreign databases in a heterogeneous database system
WO2001037097A1 (en) 1999-11-15 2001-05-25 Smithkline Beecham Corporation Method for identifying unique entities in disparate data files
CA2391829A1 (en) 1999-12-10 2001-06-14 A2I, Inc. Timeshared electronic catalog system and method
US6324647B1 (en) 1999-08-31 2001-11-27 Michel K. Bowman-Amuah System, method and article of manufacture for security management in a development architecture framework
WO2002025500A2 (en) 2000-09-20 2002-03-28 A2I, Inc. Method and apparatus for dynamically formatting and displaying tabular data in real time
DE10049940A1 (en) 2000-10-06 2002-04-18 Plecto Ag Transformation connector for converting data from a proprietary format to a commercial format before it is transmitted over a network, where typically the transfer format is an XML language, so data can easily be transmitted
US6405132B1 (en) 1997-10-22 2002-06-11 Intelligent Technologies International, Inc. Accident avoidance system
WO2002047463A2 (en) 2000-12-12 2002-06-20 A2I, Inc. A method and apparatus for transforming data
US20020161778A1 (en) 2001-02-24 2002-10-31 Core Integration Partners, Inc. Method and system of data warehousing and building business intelligence using a data storage model
US6480755B1 (en) 1999-02-04 2002-11-12 Mitsubishi Denki Kabushiki Kaisha Process control device and process control method permitting processing order and processing condition to be changed while manufacturing process continues
US6487594B1 (en) 1999-11-30 2002-11-26 Mediaone Group, Inc. Policy management method and system for internet service providers
US20020184308A1 (en) 1999-08-23 2002-12-05 Levy Martin J. Globalization and normalization features for processing business objects
US20020194196A1 (en) 2000-12-12 2002-12-19 Weinberg Paul N. Method and apparatus for transforming data
US6529948B1 (en) 1999-08-31 2003-03-04 Accenture Llp Multi-object fetch component
US6567818B1 (en) 1999-06-14 2003-05-20 International Business Machines Corporation Employing management policies to manage instances of objects
US20030191832A1 (en) 1999-06-01 2003-10-09 Ramakrishna Satyavolu Method and apparatus for controlled establishment of a turnkey system providing a centralized data aggregation and summary capability to third party entities
WO2003093998A2 (en) 2002-04-29 2003-11-13 Sap Aktiengesellschaft Collaborative data cleansing
US20030233347A1 (en) 2002-06-04 2003-12-18 Weinberg Paul N. Method and apparatus for generating and utilizing qualifiers and qualified taxonomy tables
US6668254B2 (en) 2000-12-21 2003-12-23 Fulltilt Solutions, Inc. Method and system for importing data
US20040015408A1 (en) 2002-07-18 2004-01-22 Rauen Philip Joseph Corporate content management and delivery system
US6711456B2 (en) 2001-06-07 2004-03-23 Matsushita Electric Industrial Co., Ltd NC data management apparatus and method
US6718361B1 (en) 2000-04-07 2004-04-06 Network Appliance Inc. Method and apparatus for reliable and scalable distribution of data files in distributed networks
US6738682B1 (en) 2001-09-13 2004-05-18 Advances Micro Devices, Inc. Method and apparatus for scheduling based on state estimation uncertainties
US6754666B1 (en) 1999-08-19 2004-06-22 A2I, Inc. Efficient storage and access in a database management system
US6757710B2 (en) 1996-02-29 2004-06-29 Onename Corporation Object-based on-line transaction infrastructure
US6768944B2 (en) 2002-04-09 2004-07-27 Intelligent Technologies International, Inc. Method and system for controlling a vehicle
US6842881B2 (en) * 2002-07-30 2005-01-11 Photronics, Inc. Rule based system and method for automatically generating photomask orders in a specified order format
US6857123B1 (en) 1998-12-18 2005-02-15 International Business Machines Corporation Method and apparatus for a Meta Data Service in a data processing system
US20050038551A1 (en) 2002-08-29 2005-02-17 Jyoti Mazumder Method of fabricating composite tooling using closed-loop direct-metal deposition
US6879976B1 (en) 1999-08-19 2005-04-12 Azi, Inc. Data indexing using bit vectors
US6883136B1 (en) 1999-08-19 2005-04-19 Azi, Inc. Simultaneous display and formatting of disparate values in a tabular form
US6895408B1 (en) 2002-03-19 2005-05-17 Oracle International Corporation Method and apparatus to facilitate interaction management between loosely coupled applications
US6915287B1 (en) 2001-12-13 2005-07-05 Novell, Inc. System, method and computer program product for migrating data from one database to another database
US7013289B2 (en) 2001-02-21 2006-03-14 Michel Horn Global electronic commerce system
US7174305B2 (en) 2001-01-23 2007-02-06 Opentv, Inc. Method and system for scheduling online targeted content delivery

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US161778A (en) * 1875-04-06 Improvement in compositions for filling the fibers of paper
EP0398645B1 (en) * 1989-05-15 1997-08-06 International Business Machines Corporation System for controlling access privileges
US5418945A (en) * 1992-05-18 1995-05-23 Motorola, Inc. File based and highly available hybrid database
US5966715A (en) * 1995-12-29 1999-10-12 Csg Systems, Inc. Application and database security and integrity system and method
ZA200002638B (en) * 2000-05-26 2001-01-31 Jan Christoffel De Waal The production of dicalcium phosphate or monocalcium phosphate.

Patent Citations (58)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4459663A (en) 1981-07-02 1984-07-10 American Business Computer Data processing machine and method of allocating inventory stock for generating work orders for producing manufactured components
US5182705A (en) 1989-08-11 1993-01-26 Itt Corporation Computer system and method for work management
US5099431A (en) 1989-10-23 1992-03-24 International Business Machines Corporation Automated re-work shop order scheduling system
US5191534A (en) 1990-08-21 1993-03-02 International Business Machines Corporation Engineering and manufacturing change control mechanism
US5311424A (en) 1991-06-28 1994-05-10 International Business Machines Corporation Method and system for product configuration definition and tracking
US5655085A (en) 1992-08-17 1997-08-05 The Ryan Evalulife Systems, Inc. Computer system for automated comparing of universal life insurance policies based on selectable criteria
US5758031A (en) * 1992-11-10 1998-05-26 Omron Corporation Rule generating apparatus and method
US5442782A (en) 1993-08-13 1995-08-15 Peoplesoft, Inc. Providing information from a multilingual database of language-independent and language-dependent items
US5694598A (en) 1994-10-12 1997-12-02 U S West Technologies, Inc. Method for mapping data between a relational format and an object-oriented format
US6029195A (en) 1994-11-29 2000-02-22 Herz; Frederick S. M. System for customized electronic identification of desirable objects
US5710884A (en) 1995-03-29 1998-01-20 Intel Corporation System for automatically updating personal profile server with updates to additional user information gathered from monitoring user's electronic consuming habits generated on computer during use
US5703938A (en) 1995-08-28 1997-12-30 Mct Communications Corp. Method of optimizing access trunk configurations and system therefor
US6067525A (en) 1995-10-30 2000-05-23 Clear With Computers Integrated computerized sales force automation system
US6757710B2 (en) 1996-02-29 2004-06-29 Onename Corporation Object-based on-line transaction infrastructure
US5911139A (en) 1996-03-29 1999-06-08 Virage, Inc. Visual image database search engine which allows for different schema
US6032147A (en) 1996-04-24 2000-02-29 Linguateq, Inc. Method and apparatus for rationalizing different data formats in a data management system
US5859972A (en) 1996-05-10 1999-01-12 The Board Of Trustees Of The University Of Illinois Multiple server repository and multiple server remote application virtual client computer
US6236997B1 (en) 1997-06-23 2001-05-22 Oracle Corporation Apparatus and method for accessing foreign databases in a heterogeneous database system
US6405132B1 (en) 1997-10-22 2002-06-11 Intelligent Technologies International, Inc. Accident avoidance system
US6018742A (en) 1998-07-07 2000-01-25 Perigis Corporation Constructing a bifurcated database of context-dependent and context-independent data items
US6226650B1 (en) 1998-09-17 2001-05-01 Synchrologic, Inc. Database synchronization and organization system and method
US6857123B1 (en) 1998-12-18 2005-02-15 International Business Machines Corporation Method and apparatus for a Meta Data Service in a data processing system
US6480755B1 (en) 1999-02-04 2002-11-12 Mitsubishi Denki Kabushiki Kaisha Process control device and process control method permitting processing order and processing condition to be changed while manufacturing process continues
US20030191832A1 (en) 1999-06-01 2003-10-09 Ramakrishna Satyavolu Method and apparatus for controlled establishment of a turnkey system providing a centralized data aggregation and summary capability to third party entities
US6567818B1 (en) 1999-06-14 2003-05-20 International Business Machines Corporation Employing management policies to manage instances of objects
US6883136B1 (en) 1999-08-19 2005-04-19 Azi, Inc. Simultaneous display and formatting of disparate values in a tabular form
US6879976B1 (en) 1999-08-19 2005-04-12 Azi, Inc. Data indexing using bit vectors
US6754666B1 (en) 1999-08-19 2004-06-22 A2I, Inc. Efficient storage and access in a database management system
US20020184308A1 (en) 1999-08-23 2002-12-05 Levy Martin J. Globalization and normalization features for processing business objects
US6324647B1 (en) 1999-08-31 2001-11-27 Michel K. Bowman-Amuah System, method and article of manufacture for security management in a development architecture framework
US6529948B1 (en) 1999-08-31 2003-03-04 Accenture Llp Multi-object fetch component
WO2001037097A1 (en) 1999-11-15 2001-05-25 Smithkline Beecham Corporation Method for identifying unique entities in disparate data files
US6487594B1 (en) 1999-11-30 2002-11-26 Mediaone Group, Inc. Policy management method and system for internet service providers
US7103605B1 (en) 1999-12-10 2006-09-05 A21, Inc. Timeshared electronic catalog system and method
CA2391829A1 (en) 1999-12-10 2001-06-14 A2I, Inc. Timeshared electronic catalog system and method
US6718361B1 (en) 2000-04-07 2004-04-06 Network Appliance Inc. Method and apparatus for reliable and scalable distribution of data files in distributed networks
WO2002025471A2 (en) 2000-09-20 2002-03-28 A2I, Inc. Method and apparatus for structuring, maintaining, and using families of data
WO2002025500A2 (en) 2000-09-20 2002-03-28 A2I, Inc. Method and apparatus for dynamically formatting and displaying tabular data in real time
US6910044B2 (en) 2000-09-20 2005-06-21 Sap Aktiengesellschaft Method and apparatus for structuring, maintaining, and using families of data
US20020116417A1 (en) 2000-09-20 2002-08-22 Weinberg Paul N. Method and apparatus for dynamically formatting and displaying tabular data in real time
DE10049940A1 (en) 2000-10-06 2002-04-18 Plecto Ag Transformation connector for converting data from a proprietary format to a commercial format before it is transmitted over a network, where typically the transfer format is an XML language, so data can easily be transmitted
US20020194196A1 (en) 2000-12-12 2002-12-19 Weinberg Paul N. Method and apparatus for transforming data
WO2002047463A2 (en) 2000-12-12 2002-06-20 A2I, Inc. A method and apparatus for transforming data
US6668254B2 (en) 2000-12-21 2003-12-23 Fulltilt Solutions, Inc. Method and system for importing data
US7174305B2 (en) 2001-01-23 2007-02-06 Opentv, Inc. Method and system for scheduling online targeted content delivery
US7013289B2 (en) 2001-02-21 2006-03-14 Michel Horn Global electronic commerce system
US20020161778A1 (en) 2001-02-24 2002-10-31 Core Integration Partners, Inc. Method and system of data warehousing and building business intelligence using a data storage model
US6711456B2 (en) 2001-06-07 2004-03-23 Matsushita Electric Industrial Co., Ltd NC data management apparatus and method
US6738682B1 (en) 2001-09-13 2004-05-18 Advances Micro Devices, Inc. Method and apparatus for scheduling based on state estimation uncertainties
US6915287B1 (en) 2001-12-13 2005-07-05 Novell, Inc. System, method and computer program product for migrating data from one database to another database
US6895408B1 (en) 2002-03-19 2005-05-17 Oracle International Corporation Method and apparatus to facilitate interaction management between loosely coupled applications
US6768944B2 (en) 2002-04-09 2004-07-27 Intelligent Technologies International, Inc. Method and system for controlling a vehicle
WO2003093998A2 (en) 2002-04-29 2003-11-13 Sap Aktiengesellschaft Collaborative data cleansing
US6938038B2 (en) 2002-06-04 2005-08-30 Sap Aktiengesellschaft Method and apparatus for generating and utilizing qualifiers and qualified taxonomy tables
US20030233347A1 (en) 2002-06-04 2003-12-18 Weinberg Paul N. Method and apparatus for generating and utilizing qualifiers and qualified taxonomy tables
US20040015408A1 (en) 2002-07-18 2004-01-22 Rauen Philip Joseph Corporate content management and delivery system
US6842881B2 (en) * 2002-07-30 2005-01-11 Photronics, Inc. Rule based system and method for automatically generating photomask orders in a specified order format
US20050038551A1 (en) 2002-08-29 2005-02-17 Jyoti Mazumder Method of fabricating composite tooling using closed-loop direct-metal deposition

Non-Patent Citations (23)

* Cited by examiner, † Cited by third party
Title
"SyncML Protocol, version 1.0," Internet Citation, Dec. 7, 2000, XP002217356, 60 pgs.
Anonymous. "Data Profiling the Foundation for Data Management," Dataflux Corp., Jul. 1, 2004, pp. 1-17, XP002313258.
Berndtsson et al., Task Sharing Among Agents Using Reactive Rules, Cooperative Operation Systems, 1997. COOPIS '97., Proceedings of the Second IFCIS International, Jun. 24-27, 1997, pp. 56-65.
Bertino, Elisa, et al., "Data Security," Proceedings of the Twenty-Second Annual International Computer Software and Applications Conference, Vienna, Austria, Aug. 19-21, 1998, Los Alamitos, CA, USA, Aug. 19, 1998, (CompSAC '98), XP010305455, pp. 228-237.
Bon, M., et al., "Sharing Product Data Among Heterogeneous Workflow Environments," CAD 2002: Corporate Engineering Research, Geman Informatics Society, Mar. 4-5, 2002, Dresden, Germany, XP002268575, pp. 1-10.
Chan and Suwanda, "Designing Multinational Online Stores: Challenges, Implementation Techniques and Experience", IBM Centre for Advanced Studies Conference: Proceedings of the 2000 conference of the Centre for Advanced Studies on Collaborative research, Mississauga, Ontario, Canada, 2000, pp. 1-14.
Chandramouli, Ramaswamy, "Application of XML Tools for Enterprise-Wide RBAC Implementation Tasks," Proceedings of the 5<SUP>th </SUP>ACM Workshop on Role-Based Access Control, Berlin, Germany, Jul. 26-27, 2000, XP000958089, pp. 11-18.
Chaudhuri, Surajit, et al., "An Overview of Data Warehousing and OLAP Technology," SIGMOD Record, New York, NY, USA, vol. 26, No. 1, Mar. 1997, pp. 65-74, XP002193792, ISSN: 0163-5808.
Choi, Jin Oh, et al., "Update Propagation of Replicated Data in Distributed Spatial Databases," Proceedings of Database and Expert Systems Applications: Tenth International Conference, Florence, Italy, Aug. 30, 1999-Sep. 2, 1999, DEXA '99 (Lecture Notes in Computer Science vol. 1677), Berlin, Germany, Springer-Verlag, Germany, XP009022583, pp. 952-963.
Chou, H-T. et al., "Versions and Change Notification in an Object-Oriented Database System", Proceedings of the Design Automation Conference, Anaheim, Jun. 12-15, 1988, Proceedings of the Design Automation Conference (DAC), New York, IEEE, US, vol. CONF. 25, Jun. 12, 1988, pp. 275-281, XP010013006, ISBN: 0-8186-0864-1.
Ferreira Rezende, Fernando de, et al., "A Lock Method for KBMSs Using Abstraction Relationships' Semantics," Proceedings of the International Conference on Information and Knowledge Management, CIKM, ACM, New York, NY, USA, 1994, XP002943684, pp. 112-121.
Garcia, M.S., et al. "Immunization Registries DeDupliation and Record Matching," White Paper, 1999, XP002259647, 11 pgs.
Georgakopoulos, D., et al. "An Overview of Workflow Management: From Process Modeling to Workflow Automation Infrastructure," Distributed and Parallel Databases, Kluwer, NL, vol. 3, No. 2, Apr. 1995, pp. 119-153, XP001055255.
Haerder T. et al., "Integritaetskontrolle," Datenbanken Konzepte und Techniken Der Implementierung, 1999, pp. 397-405, XP002294581 [translation provided].
Haerder T. et al., "Intergritaetskontrolle," Datenbanken Konzepte und Techniken Der Implementierung, 1999, pp. 397-405, XP002294581 [translation provided].
Haerder T. et al., "RX-Sperrverfahren," Datenbanken Konzepte und Techniken Der Implementierung, 1999, pp. 419-420, XP002294552 [translation provided].
Hill et al., "Data Transformation: Key to Information Sharing" Gartner Group Strategic Analysis Report, Sep. 29, 1998, pp. 1-60.
Hong, B. et al., "Modeling of Version Relationships for CAD Databases", Computers and Communications Technology Toward 2000, Seoul, Aug. 25-28, 1987, Proceedings of the Region 10 Conference, (TENCON), New York, IEEE, US, vol. 1, Conf. 3, Aug. 25, 1987, pp. 142-146, XP000011783.
Kamita, T. et al., "A Database Architecture and Version Control for Group Work", System Sciences, 1994, vol. III: Information Systems: Decision Support and Knowledge-Based Systems, Proceedings of the Twenty-Seventh Hawaii International Conference of Wailea, HI, US, Jan. 4-7, 1994, Los Alamitos, CA, US, IEEE Comput. Soc., Jan. 4, 1994, pp. 438-447, XP010097053, ISBN: 0-8186-5070-2.
Rahm, Erhard, et al., "Data Cleaning: Problems and Current Approaches," IEEE Bulletin of the Technical Committee on Data Engineering, vol. 23, No. 4, retrieved from the Internet Dec. 2000 at https://lips.informatik.uni-leipzig.de:80/pub/2000-45, XP002284896, 11 pgs.
Rana, S.P. et al., "Version Support for Manufacturing Database Systems", International Conference on Industrial & Engineering Applications of Artificial Intelligence & Expert Systems, Tullahoma, IN, US, New York, NY, US, vol. 2, Jun. 6, 1989, pp. 779-784, XP000605772.
Sheth and Larson, "Federated Database Systems for Managing Distributed, Heterogeneous, and Antonomous Databases", ACM Computing Surveys, 1990, 22(3): 184-236.
U.S. Appl. No. 09/577,268, filed May 2000, Hazi et al.

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120246110A1 (en) * 2011-03-22 2012-09-27 Sap Ag Master Data Management in a Data Warehouse/Data Mart
US8886590B2 (en) * 2011-03-22 2014-11-11 Sap Ag Master data management in a data warehouse/data mart
US10147040B2 (en) 2017-01-20 2018-12-04 Alchemy IoT Device data quality evaluator
US20230107253A1 (en) * 2018-08-24 2023-04-06 Acuitive Solutions, Inc. Graphical user interface and error detection system for analyzing big datasets

Also Published As

Publication number Publication date
WO2005064491A1 (en) 2005-07-14
US20050144552A1 (en) 2005-06-30

Similar Documents

Publication Publication Date Title
US7272776B2 (en) Master data quality
US7571191B2 (en) Defining a data analysis process
US10706059B2 (en) Background format optimization for enhanced SQL-like queries in Hadoop
US8311918B2 (en) Systems and methods for calculating specified matrices
US7966266B2 (en) Methods and systems for cost estimation based on templates
US8626702B2 (en) Method and system for validation of data extraction
US6993717B2 (en) Data transformation system
US20100211895A1 (en) Method for visualization and integration of business intelligence data
US7930230B2 (en) Methods and systems for risk evaluation
US20120254236A1 (en) Content transfer
US20090037236A1 (en) Analytical reporting and data mart architecture for public organizations
US20090164486A1 (en) Business intelligence data extraction on demand
CN110032594B (en) Customizable data extraction method and device for multi-source database and storage medium
CN117454278A (en) Method and system for realizing digital rule engine of standard enterprise
US20070011176A1 (en) Business reporting under system failures
US20230259994A1 (en) Reference-based software application blueprint creation
US9015115B2 (en) Project management system with asynchronous updating
US11810022B2 (en) Contact center call volume prediction
US7653661B2 (en) Monitoring connection between computer system layers
US20050149474A1 (en) Master data entry
US20230195792A1 (en) Database management methods and associated apparatus
US20090024507A1 (en) Unique versatile axpert executor engine which can interpret and execute transaction structures and information views to build information systems
BR102020016116A2 (en) open source tools integration platform
US9727830B2 (en) Multi-tier employment model for human capital management
CN113377604A (en) Data processing method, device, equipment and storage medium

Legal Events

Date Code Title Description
AS Assignment

Owner name: SAP AKTIENGESELLSCHAFT, GERMANY

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:KALTHOFF, WOLFGANG;ROHLOFF, FRANK;REEL/FRAME:014602/0941

Effective date: 20040330

STCF Information on status: patent grant

Free format text: PATENTED CASE

FEPP Fee payment procedure

Free format text: PAYOR NUMBER ASSIGNED (ORIGINAL EVENT CODE: ASPN); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY

CC Certificate of correction
FPAY Fee payment

Year of fee payment: 4

AS Assignment

Owner name: SAP SE, GERMANY

Free format text: CHANGE OF NAME;ASSIGNOR:SAP AG;REEL/FRAME:033625/0334

Effective date: 20140707

FPAY Fee payment

Year of fee payment: 8

MAFP Maintenance fee payment

Free format text: PAYMENT OF MAINTENANCE FEE, 12TH YEAR, LARGE ENTITY (ORIGINAL EVENT CODE: M1553); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY

Year of fee payment: 12