GB2517582A - Data quality monitors - Google Patents
Data quality monitors Download PDFInfo
- Publication number
- GB2517582A GB2517582A GB1411984.6A GB201411984A GB2517582A GB 2517582 A GB2517582 A GB 2517582A GB 201411984 A GB201411984 A GB 201411984A GB 2517582 A GB2517582 A GB 2517582A
- Authority
- GB
- United Kingdom
- Prior art keywords
- objects
- data quality
- properties
- data
- potential data
- 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.)
- Withdrawn
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/904—Browsing; Visualisation therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Quality & Reliability (AREA)
Abstract
A computer system for monitoring data objects in a database for poor quality data is configured to; receive a selection of one or more data quality criterion and an indication of which and how many need to be satisfied by data to indicate a potential problem; determine potential data quality problems by scanning data of data objects and identifying if there is a match with the selected data quality criteria; present any potential data quality problems to the user, including the properties and property values which match the data quality criteria; receive from a user a possible resolution or correction for the data quality problem, implementing that resolution. The potential data quality problems might be incorrect, invalid or inconsistent data such as possible duplicate objects; missing, multi-valued or unparsed properties; disallowed enumerations; and numeric or date-range violations. The data quality criteria required for a match might be programmed using Boolean operators.
Description
DATA QUALITY MONITORS
TECHNICAL FIELD
The present disclosure relates to systems and techniques for data quality monitoring.
More specifically, identifying and resolving data quality issues and presenting data with potential quafity issues for user confirmation and resolution.
BACKGROUND
Traditional automated data integration may result in various data quality issues.
Automatic scripts to search for and resolve such data quality issues often create further data quality problems.
S UM1VIARY There is a need to identify and monitor data quality problems automatically and i intelligently. In accordance with one aspect, a computer system is configured to include one or more computer processors and a tangible storage device storing one or more module configured for execution by the one or more computer processors in order to: receive, by the computer system, selection of an object type to monitor for possible data quality prohiems; receive, by the computer system, selection of one or more data quality criterion; determine potential data quality problems by scanning data associated with a plurality of objects of the selected object type in order to determine if the selected one or more data quality criterion are matched by respective objects; generate a user interface indicating the potential data quality problems of respective objects match the selected one or more data quaBty criterion, and induding one or more properties of the matching objects; receive from a user of the computing environment an indication of how to resolve the potential data quality prolMems; and implement the indicated res&ution.
In some embodiments, the data quality monitor type is one of: possible duplicate objects, missing properties, multi-valued properties, unparsed properties, disallowed enumerations, numeric range violations, and date range violations. In some embodiments, the data quality monitor type is possible duplicate objects, and said determining objects having potential data quality problems further comprises identifying respective objects each having common property va'ues for a predetermined 3 quality of the selected one or more properties. In some embodiments, the indication of how to resolve the potential data quafity problem comprises an indication of two or more objects having potential data quality problems that are duplicates; and said implementing the indicated resolution comprises combining the two or more indicated objects into a single object. In some embodiments, the one or more properties of the objects having potential data quality problems indicates a quantity of the identified respective objects sharing the selected one or more properties. In some embodiments, the data quality monitor type is missing properties; and said determining objects having potential data quality problems further comprises identifying respective objects that are missing a predetermined of the selected one or more properties.
jo Tn some embodiments, the data quafity monitor type is multi-valued properties; and said determining objects having potential data quality prob'ems further comprises identifying respective objects that have multiple values for ones of the selected one or more properties. In some embodiments, the indication of how to resolve the potential data quality problem comprises an indication of one of the multiple values that is correct; and said implementing the indicated resolution further comprises removing all of the multiple values except for the indicated one or multiple values that is correct. In some embodiments, the data quality monitor type is unparsed properties; and said determining objects having potential data quality problems further comprises identifying respective objects that have property values for one or more of the selected one or more properties including unparsed data.
In some embodiments, the data quality monitor type is disallowed enumerations; and said determining objects having potential data quality problems further comprises identifying respective objects that have property values for one or more of the selected one or more properties including disallowed enumerations. In some embodiments, the data quality monitor type is numeric range violation; and said determining objects having potential data quality problems further comprises identifying respective objects that have property values that violate an allowed numeric range for the respective sclcctcd propcrty. In somc cmbodimcnts, tim data quality monitor typc is datc rangc 3° violation; and said determining objects having potential data quality problems further comprises identifying respective objects that have property values that violate an allowed date range for the respective selected property. In some embodiments, the computer system further comprises receiving selection of one or more object types that the selected object type is required to be associated with in order to be included in the scanned plurality of objects. tn some embodiments, the computer system further comprises receiving one or more Boolean operators for the selected one or more properties and/or an indication of how many of the selected one or more properties are reqnired in order to identify the respective objects as objects having potential data quality problems.
In accordance with another aspect, a compnter implemented method comprises under control of a computing system having one or more physical processors and configured to process large amounts of data, receiving, by the computing system, selection of an object type to monitor for possible data quality problems; receiving, by the computing system, se'ection of a data quality monitor type; receiving, by the computing system, jo selection of one or more properties of objects of the selected object type; determining objects having potential data quality problems by scanning data associated with a plurality of objects of the selected object type in order to locate respective objects matching the selected one or more properties; generating a user interface indicating the objects having potential data quality problems, and including one or more properties of the objects having potential data quality problems; receiving, by the computing system, an indication of how to resolve the potential data quality problems; and implementing the indicated resolution. Tn some embodiment, the data quality monitor type is one of: possible duplicate objects, missing properties, multi-valued properties, unparsed properties, disallowed enumerations, and numeric range violation, and date range violation. In some embodiment, the computer implemented method further comprises receiving one or more Boolean operators for the selected one or more properties and/or an indication of how many of the selected one or more properties are required in order to identify the respective objects as objects having potential data quality problems.
In accordance with another aspect, a non-transitory computer-readable storage medium storing computer-executable instructions configured to direct a computing system to: receive selection of an object type to monitor for possible data quality proNems; receive selection of one or more data quality criterion; determine potentia' data quality problcms by scanning data associatcd with a plurality of objccts of thc selected object type in order to determine if the selected one or more data quality criterion are matched by respective objects; generate a user interface indicating the potential data quality problems of respective objects; match the selected one or more data quality criterion, and including one or more properties of the matching objects; receive from a user of the computing environment an indication of how to resolve the potential data quality problems; and implement the indicated resolution. In some embodiments, the data quality monitor type is one of: possible duplicate objects, missing properties, multi-valued properties, unparsed properties, disallowed enumerations, and numeric range violation, and date range violation. In some embodiments, the non-transitory computer-readable storage medium further comprises receiving selection of one or more object types that the selected object type is required to be associated with in order to be included in the scanned plurality of objects.
BRIEF DESCRIVHON OF THE DRAWTNGS
Figure 1 illustrates one embodiment of a database system using an ontology.
o Figure 2 illustrates one embodiment of a process of generating person objects with properties from multiple data sources.
Figure 3 illustrates one embodiment of a system for creating data in a data store using a dynamic ontology.
Figure 4A illustrates a sample user interface using relationships described in a data store using a dynamic ontology.
Figure 4B illustrates a user interface that is configured to receive user-selected criteria for a data quality monitor, according to one embodiment.
Figures 5A illustrates an example interface that is configured to enable users to establish criteria for a duplicate objects data quality monitor.
Figure 5B illustrates potentially duplicate objects identified by a data quality monitor system.
Figure 5C illustrates an example interface that is configured to enable users to review additional data related to identified potentially duplicate objects and determine whether the objects are duplicate and should be resolved.
Figure 5D illustrates an example user interface wherein potentially duplicate objects are resolved and results of the resolution are displayed.
Figure 6 is a flowchart depicting an illustrative operation of identifying, confirming, and removing or resolving duplicate objects.
Figurc 7 is a flowchart depicting an illustrative proccss of creating and running data quality monitors based on received data quality criteria.
Figure 8A illustrates an example user interface that allows a user to select criteria for a data quality monitor.
Figure 8B illustrates another example user interface wherein a user has configured a potentially duplicate person monitor to search on both person objects and case objects.
Figure 8C illustrates an example user interface wherein a group of possibly duplicate person objects are displayed and properties of these person objects are shown.
Figure 9 illustrates an example nser interface wherein a user has selected a missing properties monitor and is provided with examp'e object properties to select for monitoring.
Figure 10 illustrates an examp'e user interface that displays multiple case objects that were identified in an executed missing properties monitor.
Figure 11 illustrates a computer system with which certain methods and modules discussed herein maybe implemented.
DETAILED DESCRIPTION OF CERTAIN EMBODIMENTS IC)
DEFINITIONS
In order to facilitate an understanding of the systems and methods discussed herein, a number of terms are defined below. The terms defined below, as well as other terms used herein, should be construed to include the provided definitions, the ordinary and customary meaning of the terms, and/or any other implied meaning for the respective terms. Thus, the definitions below do not limit the meaning of these terms, but only provide exemplary definitions.
Ontology: Stored information that provides a data model for storage of data in one or more databases. For example, the stored data may comprise definitions for object types and property types for data in a database, and how objects and properties maybe related.
Database: A broad term for any data structure for storing and/or organizing data, including, but not limited to, relational databases (Oracle database, mySQL database, etc.), spreadsheets, XML files, and text file, among others.
Data Object or Object: A data container for information representing specific things in ti-rn world that havc a numbcr of dcfinablc propcrtics. For cxamplc, a data objcct can represent an entity such as a person, a place, an organization, a market instrument, or other noun. A data object can represent an event that happens at a point in time or for a duration. A data object can represent a document or other unstructured data source such as an e-mail message, a news report, or a written paper or artide. Each data object may be associated with a unique identifier that uniquely identifies the data object. The object's attributes (e.g. metadata about the object) maybe represented in one or more properties.
Object Type: Type of a data object (e.g., person, event, or document). Object types may be defined by an ontology and may be modified or updated to include additional object types. An object definition (e.g., in an ontology) may include how the object is related to other objects, such as being a sub-object type of another object type (e.g. an agent may be a sub-object type of a person object type), and the properties the object type may have.
Properties: Attributes of a data object that represent individual data items. At a o ml nimum, each property of a data object has a property type and a value or values.
Property Type: The type of data a property is, such as a string, an integer, or a double. Property types may include complex property types, such as a series data values associated with timed ticks (e.g. a time series), etc. Property Value: The va'ue associated with a property, which is of the type indicated in the property type associated with the property. A property may have multiple values.
Link: A connection between two data objects, based on, for example, a relationship, an event, and/or matching properties. Links may be directional, such as one representing a payment from person A to B, or bidirectional.
Link Set: Set of multiple links that are shared between two or more data objects.
Data Quality Monitors: rules including one or more criterion configured to identify potential data quality problems in data objects or between multiple data objects.
Actions to confirm possibly data quality problems and/or correct such data quality problems may be taken by a user or by automatic processes.
OBJECT CENTRIC DATA MODEL
To provide a framework for the foflowing discussion of specific systems and methods described herein, an example database system 210 using an ontothgy 205 will now be described. This description is provided for the purpose of providing an example and is not intended to limit the techniques to the example data model, the example database system, or the example database system's use of an ontology to represent information.
In one embodiment, a body of data is conceptually structured according to an object-centric data model represented by ontology 205. The conceptua' data model is independent of any particular database used for durably storing one or more database(s) 209 based on the ontology 205. For example, each object of the conceptual data model may correspond to one or more rows in a relational database or an entry in Lightweight Directory Access Protocol (LDAP) database, or any combination of one or more databases.
jo FTG. 1 iflustrates an object-centric conceptual data model according to an embodiment.
An ontology 205, as noted above, may include stored information providing a data model for storage of data in the database 209. The ontology 205 may be defined by one or more object types, which may each be associated with one or more property types. At the highest level of abstraction, data object 201 is a container for information representing things in the world. For example, data object 201 can represent an entity such as a person, a place, an organization, a market instrument, or other noun. Data object 201 can represent an event that happens at a point in time or for a duration. Data object 201 can represent a document or other unstructured data source such as an e-mail message, a news report, or a written paper or article. Each data object 201 is associated with a unique identifier that uniquely identifies the data object within the database system.
Different types of data objects may have different property types. For example, a "person" data object might have an "Eye Color" property type and an "Event" data object might have a "Date" property type. Each property 203 as represented by data in the database system 210 may have a property type defined by the ontology 205 used by the database 209.
Objccts may bc instantiatcd in thc databasc 209 in accordancc with thc corrcsponding 3° object definition for the particular object in the ontology 205. For example, a specific monetarypayment (e.g., an object of type "event") of US$30.00 (e.g., a propertyof type "currency") taking p'ace on 3/27/2009 (e.g., a property of type "date") may be stored in the database 209 as an event object with associated currency and date properties as defined within the ontology 205.
The data objects defined in the ontology 205 may support property multiplicity. In particular, a data object 201 maybe allowed to have more than one property 203 of the same property type. For example, a "person" data object might have multiple "Address" properties or multiple "Name" properties.
Each link 202 represents a connection between two data objects 201. In one embodiment, the connection is either through a relationship, an event, or through matching properties. A relationship connection may be asymmetrical or symmetrical.
For example, "person" data object A may be connected to "person" data object B by a jo "Child Of' relationship (where "person" data object B has an asymmetric "Parent Of' rdationship to "person" data object A), a "Kin Of' symmetric relationship to "person" data object C, and an asymmetric "Member Of' relationship to "Organization" data object X. The type of relationship between two data objects may vary depending on the types of the data objects. For example, "person" data object A may have an "Appears In" rdationship with "Document" data object Y or have a "Participate In" relationship with "Event" data object E. As an example of an event connection, two "person" data objects may be connected by an "Airline Flight" data object representing a particular airline flight if they traveled together on that flight, or by a "Meeting" data object representing a particular meeting if they both attended that meeting. In one embodiment, when two data objects are connected by an event, they are also connected by relationships, in which each data object has a specific relationship to the event, such as, for example, an "Appears In" relationship.
As an example of a matching properties connection, two "person" data objects representing a brother and a sister, may both have an "Address" property that indicates where they live. If the brother and the sister live in the same home, then their "Address" properties likely contain similar, if not identical property values. In one embodiment, a link between two data objects may be established based on similar or matching propcrtics (c.g., propcrtytypcs and/or propcrtyvalucs) of thc data objccts. Thcsc arc just some examp'es of the types of connections that may be represented by a link and other types of connections may be represented; embodiments are not limited to any particular types of connections between data objects. For example, a document might contain references to two different objects. For example, a document may contain a reference to a payment (one object), and a person (a second object). A link between these two objects may represent a connection between these two entities through their co-occurrence within the same document.
Each data object 201 can have mukipk links with another data object 201 to form a link set 204. For example, two "person" data objects representing a husband and a wife.
could be finked through a "Spouse Of' relationship, a matching "Address" property, and one or more matching "Event" properties (e.g., a wedding). Each link 202 as represented by data in a database may have a link type defined by the database onto'ogy used by the database.
Figure 2 illustrates one embodiment of a process of generating person objects with o properties from multiple data sources. Problems related to data quality may arise in certain of the person data objects as a result of the automatic integration of data from multiple sources. Additionally, errors may be introduced by data entry mistakes, such as typographical errors, and/or in other manners. In the example of Figure 2, multiple data sources provide data to the data federation system 225 including utility bills 215, phone records 217, tickets 217, driver's registration 221, and other personal data 223, etc. Depending on the embodiment, the data sources that provide these various types of data may be different entities or a single entity.
Each data record (e.g., data provided about a person from one of the data sources) may include information about one or more persons, and properties of person objects from the various data sources may vary For example, the utility bifis data 215 may include properties such as name, address, account number, amount due, past utility usage information, past payment history, and/or minimum amount due, while the phone records data 217 may include information such as name, address, phone number(s) and/or account number(s) (which may or may not be the same as phone number), amount due, usage information, past payment history, minimum amount due, phone calls placed, message sent, recipient's information (phone number), information about each phone call placed and/or each message sent, for example. The tickets data 219 may includc information such as namc of a drivcr, address, phone number, driver license number, vehicle registration number, event involved, ticket type, and/or date of the ticket. The driver's registration data 221 may include information such as name, date of birth, height, weight, eye color, hair color, date Ucense issued, and/or expiration date.
In some embodiments, through data federation system 225, data from various sources may be automatically federated to create multiple person objects 227. For example, the -10-utility bills data 215 of a person may show that the person lives at 123 Oak Street, and his phone number is 123-456-7890. The same person's phone records data 217 may show that he lives at 789 Willow Road and his phone number is 098-765-4321. The person's tickets data 219 may show that this person lives at 123 Oak Street, his gender is "female," he was born on 01/13, and his phone number is 098-765-4321. Finally, the person's driver's registration 221 may show that he lives at 789 Willow Road, he was born on 01/13/1967, his gender is "male," and his phone number is 123-456-7890.
In this example, the data federation system 225 may update the corresponding person o object (or create the person object if one doesn't already exist) using some automated data federation ru'es and processes. In some embodiments, the end result of the data federation process may be something that simply takes all the source information and compiles it together in the person object. For example, if the data federation process integrates the data from various sources direct'y without any changes, the person may be indicated as having two genders: male and female. The person may also be shown as having two birth dates: "01/13" and "01/13/1967." Furthermore, the first birth date of "01/13" may be interpreted as January 2013 instead of January 13th of a year.
Accordingly, due to data quality issues, the federated data through the data federation system 225 may involve all kinds of discrepancies, missing values, and other types of potential problems. These problems may sometimes be difficult to recognize such that the problems may be corrected.
Figure 3 is a block diagram illustrating exemplary components and data that may be used in identi'ing and storing data according to an ontology. In this example, the onto'ogy may be configured, and data in the data model populated, by a system of parsers and ontology configuration tools. In the embodiment of FIG. 3, input data 300 is provided to parser 302. The input data may comprise data from one or more sources, such as data sources that providc thc various data items discusscd with reference to Figure 2. For examp'e, an institution may have one or more databases with information on credit card transactions, rental cars, and people. The databases may contain a variety of related information and attributes about each type of data, such as a "date" for a credit card transaction, an address for a person, and a date for when a rental car is rented. The parser 302 is able to read a variety of source input data types and determine which type of data it is reading.
-11 -In accordance with the discussion above, the example ontology 205 compnses stored information providing the data model of data stored in database 209, and the ontology is defined by one or more object types 310, one or more property types 316, and one or more link types 330. Based on information determined by the parser 302 or other mapping of source input information to object type, one or more data objects 201 may be instantiated in the database 209 based on respective determined object types 310, and each of the objects 201 has one or more properties 203 that are instantiated based on property types 316. Two data objects 201 may be connected by one or more links 202 that may be instantiated based on link types 330. The property types 316 each may jo comprise one or more base types 320, such as a string, number, etc. Tn some embodiments, property types include only a base type of string, number, date, enumeration, or composite. Depending on the embodiment, property types may or may not have a hierarchical structure like objects do. For instance, a missing child object type can be a sub-type of the person object type, but a home property type cannot be a sub-type of a location property type.
Tn some embodiments, composite property types contain multiple components, but may still be considered a sing'e property. For instance, an Address property may be a composite property, formed from multiple components, such as Address 1 (string), Address 2 (string), City (string), State (string), and ZIP (could be number or a string).
In some embodiments, the ontology rules may also restrict which properties are allowed on which objects, as well as what link relationships are allowed between objects.
In an embodiment, a user of the system uses an object type editor 324 to create and/or modify the object types 310 and define attributes of the object types. In an embodiment, a user of the system uses a property type editor 326 to create and/or modi'thc propcrtytypcs 316 and dcflnc attributcs of tim propcrtytypcs. In an embodiment, a user of the system uses fink type editor 328 to create the link types 330.
Alternatively, other programs, processes, or programmatic contro's maybe used to create link types and property types and define attributes, and using editors is not required.
In an embodiment, creating a property type 316 nsing the property type editor 326 involves defining at least one parser definition using a parser editor 322. In some -12 -embodiments, a parser definition comprises metadata that informs parser 302 how to parse input data 300 to normalize the value assigned to the property type 316 that is associated with the parser definition. For example, the ontology parser may determine how to convert both inputs "1/1/02" and "Jan 1 2002" into a normalized value "2002- 01-01 00:00." Depending on the embodiment, a composite property parser may identify individual components. For example, a composite parser for may turn an address "in Main St., New City, ST, 12345" into normalized values such as: Address 1: iii Main St; City: New 0 City; State: ST; Zip: 12345. Tn some embodiments, if parsing rules fail, the original va'ue maybe kept in an unparsed format. This maybe later identified as a potential data quality issue by a data quality monitor. In some embodiments, code parsers may choose which property type to use. In some embodiments, the code may map a data column from the input to a property type in the ontology and then parse the input.
Tn an embodiment, each parser definition may comprise a regular expression parser 3o4A or a code module parser 3o4B. In other embodiments, other kinds of parser definitions may be provided using scripts or other programmatic elements. Once defined, both a regular expression parser 304A and a code module parser 304B can provide input to parser 302 to control parsing of input data 300.
Using the data types defined in the ontology, input data 300 may be parsed by the parser 302 determine which object type 310 should receive data from a record created from the input data, and which property types 316 should be assigned to data from individual field values in the input data. Based on the object-property mapping 301, the parser 302 selects one of the parser definitions that is associated with a property type in the input data. The parser parses an input data field using the selected parser definition, resulting in creating new or modified data 303. The new or modified data 303 is addcd to thc databasc 209 according to ontology 205 by storing valucs of tim new or modified data in a property of the specified property type. As a result, input data 300 having varying format or syntax can be created in database 209. The ontology 205 maybe modified at anytime using object type editor 324, property type editor 326, and link type editor 328, or under program control without human use of an editor. Parser editor 322 enables creating multiple parser definitions that can successfully parse input data 300 having varying format or syntax and determine which property types should be used to transform input data 300 into new or modified input data 303.
-13 -The properties, objects, and the links (e.g. relationships) between the objects can be visualized using a graphical user interface (GUT). For example, FIG. 4A displays a user interface showing a graph representation 403 of relationships (including relationships or links 404, 405, 406, 407, 408) between the data objects (including data objects 421, 422, 423, 424, 425, 426) that are represented as nodes in the example of Figure 4. In this embodiment, data objects 421-426 are person objects, such as the person objects 227 discussed with reference to Figure 2. In this example, the person nodes (associated with person data objects) may have relationships to other person nodes, for example, o through payment objects. For example, relationship 404 is based on a payment associated with the individuals indicated in person data objects 421 and 423. The link 404 represents these shared payments (for example, the individual associated with data object 411 may have paid the individual associated with data object 413 on three occasions). These relationships may be stored as links, or in some embodiments, as properties, where a relationship may be detected between the properties, or as event objects. Tn some cases, as stated above, the links may be directional. For example, a payment link may have a direction associated with the payment, where one person object is a receiver of a payment, and another person object is the payer of payment.
Tn addition to visually showing relationships between the data objects, the user interface may allow various other manipulations. For example, the objects within database 209 maybe searched using a search interface 450 (e.g., text string matching of object properties), inspected (e.g., properties and associated data viewed), filtered (e.g., narrowing the universe of objects into sets and subsets by properties or relationships), and statistically aggregated (e.g., numerically summarized based on summarization criteria), among other operations and visualizations.
Figure 4B illustrates an object filler user interface 460 that is configured to receive uscr-sclcctcd critcria for a data quality monitor and display rcsults given the critcria, according to an embodiment of the present disclosure.
Tn the embodiment of Figure 4B, the object filter initially receives from the user a selection of one or more types of objects to be monitored. In this example, the selected object type is "Case," and therefore case objects satisfying the specified criteria are displayed. In general, a case is an object type that refers to multiple other objects of possibly multiple object types. A case object may refer to various types of information, such as a case related to a criminal investigation, a case of West Nile virus infection, a case involving litigants, or a case related to economic analysis. Depending on specific user requirements, a case object may include various properties such as names of people involved, dates of events, address, phone number, outcome, etc., and a case object may be associated with multiple other object types, such as one or more person objects, event objects, etc. in some other embodiments, other object types maybe selected, such as person, event, vehicle, etc. In this example, criterion (e.g., required object types or values of properties) to be Jo included in the data quality monitor can be added by clicking the add criterion button 461. For example, the monitor may initiafly include no criterion (or possibly defaull criterion in one embodiment), and the user adds a first criterion 469 by clicking on the add criterion button 461, and subsequently adds the criterion 471 and 473 by clicking on the add criterion button 461 additional times.
The user interface of Figure 4B allows the user to select Boolean operators to further define requirements of the monitor. For example, the user has indicated in interface 463 that the object type is required to be a "case" and has indicated in interface 465 that any one of the listed cnterion 469, 471, 473 is sufficient for a match. In one embodiment, these interfaces 463, 467 also allow the user to indicate a minimum number of the criterion that must be met, rather than the indicated "any" (in interface 467) or "all" (in interface 463). In other embodiments, relationships between the criteria may be provided in other manners.
As shown in Figure 4B, criterion may reference any available properties of the selected object type. For example, the criteria of "category = SD" is selected in criterion 469 and "category = SF" is selected in criterion 471, while criterion 473 refers to a particular date. A user may define any additional or different criterion based on any other propcrtics of thc objcctsto bc monitorcd, such as location = Boston, MA, airlinc = Southwest, date range = 02/14/2009 to 03/09/2011, etc. In some embodiments, a data quality monitor may be configured to restrict selected objects to objects connected to one or more specific object or objects connected to one or more type of objects. For example, if person" is an object type that is already selected, a user may add an icon representing an object type (such as "case" 475) next to the "person" object type 479, and add a link between the two object types. With the -15 -added link between the case object 475 and the person object 479, the monitor is configured to se'ect on'y case objects that are also connected to a person object. This feature may be useful to further Umit the scope of searched objects. For example, if a user is only interested in case objects connected to a known criminal A, in addition to satisfying the criteria on the right side of the panel, the selected case objects are a'so related to the criminal A. DATA QUALiTY MONITORS o Figures 5A illustrates an example user interface 510 that is configured to enable users to establish criteria for a data quality monitor. Initially, the user may select an existing monitor (such as a monitor that was previously generated by the user and/or another user) using the drop-down menu 512. Alternatively, the user can create a new monitor by s&ecting create new monitor button 514. If the user creates a new monitor, the examp'e user interface 510 aflows the user to provide a custom name, such as "Duplicate persons" by inputting the name in a text box. In addition, in some embodiments, the user interface in may aflow the user to publish a custom monitor by clicking the publish monitor button 520, which makes the monitor available to other users (e.g., via the select monitor drop-down menu 512) such as to perform the same data quality monitoring on other datasets.
in the embodiment of Figure 5A, the user can select one or more particubr object types to monitor. in this example, person objects 522 relating to case objects 524 are configured to be monitored by this data quality monitor. A user may further edit the objects to monitor by clicking the "edit" button 521, which opens a user interface such as the interface shown in Fig. 4B. In some embodiments, this may mean that person objects being monitored should be related to one or more case object, and person objects not related to any case objects should not be monitored. In some embodiments, only person objccts 522 may bc configured to bc monitorcd without the additional requirement that the person objects 522 should be related to one or more case objects 524.
In this example, the user has selected a dupflcate objects data quality monitor using the monitor type drop-down menu 526. Data quality monitor types may be directed to other data quality issues, such as such as missing values, unparsed properties, numeric range vi&ations, properties with values that do not match aliowed enumerations, and other types of potential data quality issues, which may also be available in the menu 526. The user interface 510 further provides a list of available property types associated with the chosen object type (in this example, person object type) for which the monitor will search.
Furthermore, the data quality monitor may also be configured to allow a user to input a number of minimum matches among the provided property criteria that result in a matching person object (or other object type in other implementations). For example, if a user has specified 4 properties and a minimum match of 2 (as shown in the example o of Figure 5A), matching at east two of the specified properties between two person objects would be deemed sufficient for identifying those two objects as potentially duplicate objects. In the example of Figure A, the following properties are selected to be matched on: name, date of birth, Social Security Number, and license number.
Tn some embodiments, the properties to match on in order to determine whether objects are duplicate maybe added or deleted. A user may dick "Add property" button 538 to add additional properties. A user may a'so click on the remove property icon 540 next to a property to remove that property. Property settings may also be saved with the monitor.
In the embodiment of Figure A, results of the data quality monitor 510 may be obtained by clicking on the "Run Monitor Now" button 530. Depending on the embodiment and the specific dataset used, duplicate objects may or may not be found according to the established data quality monitor criteria. In this example, 3 groups of person objects are found to be possible duplicates according to the specified criteria.
Depending on the embodiment, results of the data quality monitor may be viewed in a graph setting by selecting or in a browser setting by selecting 536.
Figure 5B illustratcs potentially duplicate objects identified by the data quality monitor defined in user interface 510 of Figure A. In this example, two person objects, Bad Person 1540 and Bad Person 2542 are identified by the "Duplicate persons" data quality monitor as possibly the same as each other. Tn some embodiments where there are many objects identified, the objects may be displayed in a graph view or in a browser view with fewer objects shown at first. A user will be given the choice to drill-down, drill-up, and/or otherwise explore the identified objects. -17-
Figure C illustrates an example interface 544 that is configured to enable users indicate whether the objects are duplicate and should be resolved, possibly after reviewing additional data related to identified potentially dupUcate objects (see Figure 8C, for example). In some embodiments, a different interface maybe presented for resolving groups of potentially duplicate objects. tn the example interface 544, a user may be presented with a question such as "Are you sure you want to resolve these 2 objects?" In some other embodiments, a similar or different question may be asked to communicate to the user that a choice may be made to resolve the potential data quality issue. In this example, a user may choose the default title "Bad Person 2." If this choice jo is made, the title of the new merged objects is Bad Person 2. Tn this embodiment, the data on both Bad Person iand Bad Person 2 are merged to form the new merged object tilled Bad Person 2.
In some embodiments, when a potential data quality issue is resolved, the merged object is maintained in the data store and the individual objects used to create it no longer show up separately in searches. Tn some embodiments, the user that initiates object resolution may also indicate that the resolution should be effective only in data accessed by the particular user and/or a particular group of user. Thus, the resolution (and/or other changes to data objects) may be selectively pushed out to other users.
Figure 5D illustrates an example user interface 546 wherein potentially duplicate objects are resolved and results of the resolution are displayed. In this example, Bad Person 2 is found to be a potentially duplicate of some other objects. Tnformation regarding properties of Bad Person 2, which now include properties of Bad Person 1 that was resolved into Bad Person 2, may be displayed. In some embodiments, only information that is actually used to match duplicate objects or identify other potentially data quality issues is displayed. In some other embodiments, all or relevant properties of a selected object may be displayed to a user. In this example, Bad Person 2 is show to havc thc namc of "Bad Pcrson 1" and a Social Sccurity Numbcr of 123-45-6789.
Figure 6 is a flowchart depicting an illustrative operation of identifying, confirming, and removing or resolving duplicate objects according to one embodiment. The method of Figure 6 may be performed by a computing system used by an analyst (or other user), one or more server systems that store the object ontology (e.g., database system 210 of Figure i), and/or any other suitable computing system.
-18 -The method 600 begins at block 605, where a data quality monitor automatically determines possible duplicate objects based on a set of criteria (e.g., those set in user interface io of Figure GA). In some embodiments, the set of criteria may be created by a user. In some other embodiments, the set of criteria may have been already created before (e.g., by the same user, another user, or as a system default) and stored in the data quality monitor. The set of criteria may include property criteria, such as the properties to match and the minimum number of properties that needs to be matched.
While a possible duplicates data quality monitor is discussed with reference to Figure 6, other types of monitors may be executed in a similar manner. As discussed above, the jo other types of data quality monitors may include missing values, unparsed properties, numeric range violations, properties with values that do not match aflowed enumerations, and other types of potential data quality issues.
The method ôoo proceeds to block 6io, where the data quality monitor creates associations between possible duplicate objects. For example, if two person objects are deemed to be possible duplicates of each other based on identical Social Security Number (55N) and identical date of birth (DOB) (where SSN and DOB are selected properties to be matched on and the monitor requires 2 or less matching properties), a "possible duplicate objects" association/link between these two person objects may be created. In some situations, the two person objects may have some other properties that are not identical, such as different eye colors.
In another example, if four Ticket objects have the same date of issuance, name, incident type, driver's license number, and vehicle license numbers, the data quality monitor may deem them to be potentially duplicates (based on the established monitor criteria) and create associations/links between the four Ticket objects, identifying them as potential duplicates.
At block 615, tI-ic data quality monitor providcs an indication of possiblc duplicatc objects to a user. In some embodiments, the indication that some objects may potentiafly be duplicates of each other may be presented in a graph view, wherein the one or more identified objects are displayed and connections between or among the identified objects indicate their associations. A user may use the information provided in such a graph view and/or one or more related histogram views (see, e.g., Figure 8C), for example, to determine whether the objects are duplicates or not. In some other embodiments, the connections between or among the identified objects may be shown in an exp'orer view, wherein a user may click on an icon that represents an object to find out more details abont why certain objects are connected to each other and what makes the objects possible duplicates of one another. The created association may indicate the identical matched properties, or possiNy only the properties that are deemed crucial.
At decision block 720, the data quality monitor receives input from the user indicating whether or not a set of potential duplicates really are duplicates. For example, the user may review additional properties of identified possiNe duplicate objects in order to jo make the determination. The user may provide the input in various manners, such as the user dragging and dropping duplicate objects onto one another, responding to a query from the system requesting confirmation of duplication in illustrated objects, and/or by any other manner. In some embodiments, the data quality monitor may be configured to automatically make a choice by default in case a user is not available or decides not to perform the confirmation step. Tn such instances, the data quality monitor may automaticafly make a determination and resolve and/or remove any duplication.
If the user finds that the identified objects are duplicates, the process 600 proceeds to block 625, where the duplication issue is resolved. As discussed above, in one embodiment duplicate objects maybe resolved by combining the objects into a single object, having properties from each of the two or more determined duplicate objects. In other embodiments, the duplicate objects may remain separate objects, but associations between or among the identified objects may be updated to indicate the user's confirmation of the duplication. For example, the association among the identified objects may be updated to "confirmed duplicates" from "potential duplicates." Tf, howcvcr, thc uscr dccidcs that thc idcntificd objccts may not bc duplicatcs at decision block 620, the process 600 proceeds to block 630, where the indication of possible duplication may be removed by the system. Tn some embodiments, association between or among the identified objects may also be removed or updated to indicate the use's confirmation of no duplication. For example, the association among the identified objects maybe updated to "no duplication-confirmed" from "potential duplicates." Figure 7 is a flowchart depicting an illustrative process of creating and running data quality monitors based on received data quality criteria, according to one embodiment.
The method of Figure 7 may be performed by a computing system used by an analyst (or other user), one or more server systems that store the object ontology (e.g., database system 210 of Figure i), and/or any other suitable computing system.
The process 700 begins at block 705, where the data quality monitor receives selection of object types. In some embodiments, available object types may be presented directly to a user, such as in a drop-down menu. In some other embodiments, the user can jo choose more than one available object types.For example, as previously discussed, a person object type may be selected.
The process 700 proceeds to block 710, where the data quality monitor receives a selection of required properties of objects to be included in an analysis set. For examp'e, if the selected object type in block 705 is a person object, the selection of required properties for the person objects to be included in the analysis set may include any property of person objects, such as the following, without limitation: name, address, phone number, date of birth, Social Security Number, driver's license, countiy of citizenship, immigration status, occupation, etc. In some cases, the selection of required properties of objects may include a smaller number of properties that are the most crucial to a user. For example, if a user wants to run a data quality monitor on case objects related to stolen vehicles, the properties associated with the case objects may include Vehicle Identification Number (V1N), date on which the vehicle was stolen, location where the vehicle was last seen, vehicle model, vehicle make, and vehicle color, etc. In some other cases, the selection of required properties may include a large number of properties, depending on the user's requirement. In addition, the object type selected for monitoring may be required to be associated with one or more other object types, such as the required link between person object types and case object typcs in the cxamplc of Figure 5A.
At block 715, the data quality monitor may receive a selection of data quality criteria to apply to objects in the analysis set. Depending on the embodiment, available data quality criteria may first be determined based on a selected data quafity monitor type, such as (i) duplicate objects; (2) multi-valued properties; () missing properties; () unparsed properties; () properties with values that do not match allowed enumerations; (6) numeric range violation, etc. Each data quality monitor type may include certain criteria for identifying objects with potential data quality problems.
Additionafly, the user can customize the data quality criteria that are included in the monitor. Discussed below are examples of certain data quality monitors that maybe selected by a user.
A duplicate objects monitor may identify potentiafly duplicate objects that have one or more identical (or substantially similar) property values such that they may be considered duplicates. However, objects may not always be considered potentially duplicate just because they share some of the same property values. For example, jo several person objects may share the same mailing address, phone number, and vehicle information. In some situations, having such identical property values does not make the person objects identical because these people may live in the same household. In some other cases, sharing important property values may result in the system finding that some objects are potentially duplicates. For example, if several person objects share the same Social Security Number, phone number, date of birth, then they might be considered duplicates. Tn some embodiments, these person objects may stifi be considered not potentially duplicates due to other property values that are available or fraud concerns. Thus, depending on the particular data objects and corresponding properties that are being monitored, the user may have different criteria for a duplicate objects monitor.
A multi-valued properties monitor may identify objects with properties with more than one value. For example, the President of a foreign countiy should be only one person.
If the value of the President property of that country object has more than one person, this could indicate a potential data quality problem. In another example, a person object has two Social Security Numbers. Normally, a person should only be associated with only one Social Security Number. However, there could be a fraud investigation, and this particular person object has been associated with several Social Security Numbcrs that hc has fraudulently uscd. Thus, thc pcrson objcct may be flagged as a potential data quality problem in a multi-vahied properties monitor.
A missing properties monitor may identify objects with property values missing and/or missing property types. For example, in some embodiments, a blood donor database may include many person objects, each having a property called "blood type." Because it maybe important to determine the blood donors' blood types, a person object having -22-no blood type property value or a person object having no Nood type property at all may potentially be proNematic.
An unparsed properties monitor may identify objects associated with unprocessed and/or incomplete information in an origin database. For example, a field agent in a law enforcement agency may have input the following information regarding a suspect (e.g., a person data object): "bc: CA." Afterwards, if no more information is provided by the field agent, it may not be very clear whether this information means "location = California," "ocation = Canada" or something else. In another example, a suspect may jo have provided a date of birth. However, the suspect's date of birth may use a different ca'endar year system, such as the lunar-year calendar system or the Tibetan calendar system. Therefore, if the suspect's lunar birth date is January 2o', 1986, the suspect's real birth date may be a different date. Property values as such may also result in data quality issues.
Tn another example, a date may be provided in a format such as Day/Month/Year (e.g., 13/7/92). A system that mistook the "Day" for "Month" may fail to parse the date of 13/7/92 because there is no month 13. The unparsed properties monitor may catch dates that fail to parse under the Month/Day/Year convention and alert a user to correct the date parsing nile so that a date provided under the Day/Month/Year format will be parsed corredily.
Depending on the embodiment, an enumerated property may be a property with a restricted or limited set of allowed values. Properties with values that do not match allowed enumerations may result from wrong values that do not correspond to the property types. For example, a person object may have an "age" property with a value of "female" and a "gender" property with a value of "as years old." In another example, "fmale" may be provided instead of "fema'e" for gender, which may result in data parsing failures. In somc situations, a uscr may mistakenly understand the acceptable vahies of a property. For example, a user may believe that the location property may have two values such as "CONUS" (meaning Continental U.S.) and "OCONUS (outside Continental U.S.) when in fact the ocation property has values such as bar," "park," or "home." The data quality monitor may detect such discrepancies and alert a use to correct the problems accordingly. Tn some other situations, the problem could be less obvious. For example, a case object may have a "st&en vehide" property with a value of "Escape at Lincoln St." The fiáld agent who originally entered the information may -23 -have meant that the vehicle was stolen while it was on Lincoln St., and the st&en vehicle is a Ford Escape. However, since the information has not been parsed properly, it may present an unparsed properties issue. Depending on embodiments and user requirements, such discrepancies in property values maybe detected by a data quality monitor nsing parameters specified by the user and/or parameters set up by the system.
A numeric range violation monitor may identify objects with property values outside of an expected range for the particular property. For examp'e, a person object may have jo an "age" property with a value of "-10" or "450." Both are clearly wrong. More subtle mistakes can a'so be detected. For example, if the system has knowledge that a certain street's street numbers are o to 100, then the system may be able to find an erroneous street address value with a street number of 150. In some other embodiments, a data range violittion monitor may also be provided. For example, if a provided date is invalid or is out of context (e.g., a credit card transaction date in the 14th Century), the data quality monitor may catch such problems and alert the user.
Once a data quality monitor type is selected and criteria of the monitor are established, the process 700 proceeds to block 720, where the data quality monitor is executed. For example, the data quality monitor may scan the analysis set for objects matching the specified data quality criteria and/or a set of system default criteria.
At block 725, results of the execution of data quality monitor are provided, in some embodiments, such results are provided in a graphical user interface, listing all the objects and/or their specific values that may have violated the defined data quality criteria, in some other embodiments, such results may be provided in a graphical user interface that connects the objects in order to allow the users to see how such objects are connected. For example, as previous'y discussed, two potentially duplicate objects may bc conncctcd by an association namcd "possibly samc as," showing that thc two objects are deemed to be possible duplicates. Depending on the embodiment, the graphica' user interface may a'so include property values showing why the identified objects are included. Tn some other embodiments, the results may also be stored in a file such as a comma-delimited file, an Excel® file, an XML file, an HTML the, etc., with information such as name of the objects and/or property values, in some embodiments, the results may be available for users to down'oad.
At block 730, a user may be given the choice of saving the data quality monitor for later use. If the user chooses to do so, in some embodiments, the results of several rounds of data quality monitoring may also be compared to see whether the same data quaBty issues tend to persist, and whether some data quality problems have already been resolved. In some other embodiments, a user may not on'y save data quality monitors, but also publish them so that other users of the system may also run similar or the same searches to detect data quality issues. Depending on the embodiment, other users may use a published data quality monitor and customize the monitor for their own specific requirements.
Figure 8A illustrates an example user interface 840 that aflows a user to create, load, and/or update criteria for a data quality monitor according to one embodiment. The example user interface 840 includes choices of creating a new monitor 853 or selecting an existing data quality monitor 850. In some embodiments, if a user chooses to create a new data quality monitor 853, the user interface 840 may present choices/questions to the user so that the user may speciT criteria to be included in the new data quality monitor. If a user chooses to select an existing data quality monitor 850, criteria of the selected data quality monitor are loaded into the system for execution. The example user interface 840 allows the user to further customize an existing data quality monitor and save the customized data quality monitor as a new monitor. In some other embodiments, a data quality monitor may be configured such that it can only be customized or edited by certain users.
The user interface 840 includes options that allow a user to configure the objects to monitor 855. In this examp'e, the objects selected to be monitored are case objects.
Other types of objects can also be monitored. Moreover, in some embodiments, a user may edit objects so that more than one type of objects may be monitored. In some embodiments, even if monitoring is only performed on one type of object, data quality monitoring critcria may rcquirc thc monitorcd objcct to bc associatcd with onc or morc other types of objects. For example, a case object maybe required to be associated with at one or more event objects and/or person objects that are of interest to a user.
The examp'e user interface 840 further includes a monitor type selection control 860 that allows selection of a data quality monitor type. As previously discussed, available data quality monitor types may indude: (i) potentially duplicate objects; (2) multi-valued properties; (3) missing properties; (4) unparsed properties; (j) properties with -25 -values that do not match allowed enumerations; (6) numeric range violation, and/or any other monitor. In the example of Figure 8A, potentially duplicate objects 860 is selected. Once a data quality monitor type is selected, specific properties of the selected objects to be monitored may be provided bythe user. Customization of properties is discussed further with reference to the example of Figure 8B.
In some embodiments, data quality monitor settings may also be configured to discover orphaned objects, such as objects with no links. Data quality monitor settings may also be limited to run the search criteria specified, e.g., in 855, exclusively without checking jo for anything else.
Figure SB illustrates another example user interface 1100 wherein a user has configured a potentially duplicate person monitor to identify person objects (linked to case objects) that are potentially duplicates. Thus, as displayed in the area 1125, person objects Unked to case objects are configured to be monitored. The requl red association of person objects to case objects may be a user's desire to monitor only person objects that have some connection to a criminal investigation (e.g., "case").
In the drop-down menu 1130 in this example, the selected data quality criterion is potentially duplicate objects (potentially duplicate person) and the minimum number of properties satisfying the property requirements is selected as two at box 1135.
In this example, the user has selected properties to match on as: name 1140, date of birth 1145, Social Security Number 1150, and license number ii,5. Therefore, according to the settings in user interface 1100, the objects found to be potentially duplicates should have at least two identical property values, which can be any two properties from the four selected properties. Thus, for this particular monitor, two objects sharing the same name and Social Security Number would be considered possiblc duplicatcs and may bc prcscntcd to thc uscr for furthcr confirmation and/or resolution.
As discussed previously, objects matching the criteria specified in a data quality monitor maybe displayed in the user interface 1100. In this example, a total of three groups of objects are found, as indicated in n6o. The eleven identified person objects are all related to a case object(s) per the link requirement indicated in area 1125. tn this -26 -example, the eleven located person objects are displayed in interface 1165, along with connections between the identified person objects.
Figure 8Cillustrates an example user interface 870 wherein a group of possibly duplicate person objects are displayed and properties of these person objects are shown to indicate properties of the objects, which maybe useful to the user in determining whether the objects really are duplicates. In this example, a group of five person objects (e.g., of the three groups of objects located in the example of Figure 8B) are displayed and an entity properties histogram 871 is illustrated to show various Jo properties of the identified objects. As shown at 874, the five person objects have the name "James Bond" or names very similar to "James Bond," such as "James B." Furthermore, some of the identified person objects share other properties. In this example, all five person objects have the same social security number, as shown in 878.
Four of the five objects have the same date of birth (at 872) and three of the person objects share the same last name "Bond" (at 876). Finally, all five identified person objects in this example have at east three properties (as required by a user by specifying minimum matches = 3) that match another person object. Given the information provided about the identified properties, the user may be able to confirm whether any or all of the identified objects should be considered duplicates or not. If a user confirms that some of the identified objects are in fact duplicates, he or she may take further actions such as resolving the duplication and/or updating the associations among person objects.
Figure 9 illustrates an example user interface 900 wherein a user has selected a missing properties monitor and is provided with object properties to select for monitoring. In this example, the objects being monitored are case objects. As previously discussed, missing properties may include data quality issues resulting from absent property values associated with one or more properties and/or missing property types altogcthcr. Tn this example, the uscr intcrfacc 900 includcs a list of propcrties associated with the case object so that a user may choose which properties and/or property values to monitor.
In this example, the list of properties for user selection in the drop-down menu 910 includes: (i) location name; (2) location type; () address; () address city; () address state; (6) crime category. In this example, the user has chosen to monitor "location name" in order to identify case objects missing either the property "location name" or -27-objects with no value associated with the "location name" property. The user interface 900 also allows the user to choose to monitor more case properties for missing properties, such as by selecting the add criterion button 845. In some embodiments, other properties associated with a case object maybe presented for user selection. Tn some other embodiments, instead of presenting the properties that a user may choose to monitor in a drop-down menu, other types of user interface elements may be used.
Figure 10 illustrates an example user interface 1000 that displays multiple case objects that were identified in an executed missing properties monitor. In this example, o multiple properties associated with an object have been selected for inclusion in the missing properties monitor. Tn particular, in addition to a "location name" property in 910, "subject victim status" is selected in 1005 and Agent Name is selected in 1007.
Depending on the embodiment, the user interface 1000 may also include one or more Boolean thgic operator between or among the properties selected by a user. For examp'e, a user maybe able to specif)r that she wants to monitor case objects missing both the "location name" property (or property value) and the "subject victim status" property (or property value). In another example, a user may specify that she only wants to monitor case objects missing either the "location name" property (or property value) or the "subject victim status" property (or property value). The user interface 1000 allows the users to specify a minimum number of matches in box 1135 or some other user interface elements. In this example, a minimum of two matches is required and, thus, objects located by this monitor match at least two of the three specified properties.
In a similar manner as discussed above with reference to Figures 8-9, for example, data quality monitors of other types, such as unparsed properties, may present a list of available properties for users to choose from in customizing the monitors. In an unparscd propcrtics cxamplc, onc or morc Boolcan logic opcrators may bc providcd to specify whether afl the properties selected by the user are required to have unparsed properties or only one or a subset of the properties are required to have unparsed properties.
The user interface 1000 may also include options for users to run monitor now 1010 or create nightly monitor 1015. If a user chooses to create nightly monitors, the user interface 1000 may in some embodiments ask further questions such as the specific -28 -time that the configured data quality monitor should be executed and how the user wish to review the data quality monitor results. if a nser chooses to mn the configured data quality monitor now, the user interface 1000 may send commands to execute the data quality monitor. After execution, the user interface 1000 may display a quantity of objects matching the data quality monitor and/or display the matched objects.
In the example of Figure 10, 1257 case objects were found as shown at 1020. The user interface may present a choice to analyze the matched objects using an Object Explorer by choosing 1025. In some embodiments, the user interface 1000 may also include jo choices for users to view the matched objects in a graph by choosing 1030 or in a browser by choosing 1035.
Depending on the embodiment, the user interface 1000 may also display the objects matching the configured data quality settings in the executed data quality monitor. In this example, the user interface includes an area 865 displaying case objects matching the data quality settings. The first six case objects 1040 are displayed as case 1 through 6. A different default number of objects may be disp'ayed by the user interface 1000 as needed or according to a different user setting.
IMPLEMENTATION MECHANISMS
According to one embodiment, the techniques described herein are implemented by one or more special-purpose computing devices. The special-purpose computing devices may be hard-wired to perform the techniques, or may include digital electronic devices such as one or more application-specific integrated circuits (ASICs) or field programmable gate arrays (FPGAs) that are persistently programmed to perform the techniques, or may include one or more general purpose hardware processors programmed to perform the techniques pursuant to program instructions in firmware, mcmory, othcr storagc, or a combination. Such spccial-purposc computing dcviccs may also combine custom hard-wired logic, ASTCs, orFPGAs with custom programming to accompUsh the techniques. The special-purpose computing devices maybe desktop computer systems, server computer systems, portable computer systems, handheld devices, networking devices or any other device or combination of devices that incorporate hard-wired and/or program logic to implement the techniques.
-29 -Computing device(s) are generally controlled and coordinated by operating system software, such as iOS, Android, Chrome OS, Windows XP, Windows Vista, Windows 7, Windows 8, Windows Server, Windows CE, Unix, Linux, SunOS, Solaris, iOS, Blackberry OS, VxWorks, or other compatible operating systems. In other embodiments, the computing device may be controlled by a proprietary operating system. Conventiona' operating systems control and schedule computer processes for execution, perform memory management, provide file system, networking, I/O services, and provide a user interface functionality, such as a graphical user interface ("GUI"), among other things.
For example, Figure 11 is a block diagram that illustrates a computer system 800 upon which an embodiment may be implemented. Computer system Soo includes a bus 802 or other communication mechanism for communicating information, and a hardware processor, or multiple processors, 804 coup'ed with bus 802 for processing information. Hardware processor(s) 804 maybe, for example, one or more general purpose microprocessors.
Computer system 800 also inc'udes a main memory 806, such as a random access memory (RAM), cache and/or other dynamic storage devices, coupled to bus 802 for storing information and instructions to be executed by processor 804. Main memory 806 also may be used for storing temporary variaNes or other intermediate information during execution of instructions to be executed by processor 804. Such instructions, when stored in storage media accessible to processor 804, render computer system 800 into a special-purpose machine that is customized to perform the operations specified in the instructions.
Computer system 8oo further inchides a read only memory (ROM) 8o8 or other static storage device coupled to bus 802 for storing static information and instructions for proccssor 804. A storagc dcvicc 810, such as a magnctic disk, optical disk, or USB thumb drive (flash drive), etc., is provided and coupNd to bus 802 for storing information and instructions.
Computer system 800 maybe coupled via bus 802 to a display 812, such as a cathode ray tube (CRT) or LCD disphy (or touch screen), for displaying information to a computer user. An input device 814, induding alphanumeric and other keys, is coup'ed to bus 802 for communicating information and command se'ections to processor 804.
Another type of user input device is cursor contro' 816, such as a mouse, a trackbafl, or cursor direction keys for communicating direction information and command selections to processor 804 and for controlling cursor movement on display 812. This input device typicafly has two degrees of freedom in two axes, a first axis (e.g., x) and a second axis (e.g., y), that allows the device to specify positions in a plane. in some embodiments, the same direction information and command selections as cursor control may be implemented via receiving touches on a touch screen without a cursor.
Computing system 800 may include a user interface module to imp'ement a GUI that jo may be stored in a mass storage device as executable software codes that are executed by the computing device(s). This and other modules may include, by way of example, components, such as software components, object-oriented software components, class components and task components, processes, functions, attributes, procedures, subroutines, segments of program code, drivers, firmware, microcode, circuitry, data, databases, data structures, tables, arrays, and variab'es.
Tn general, the word "module," as used herein, refers to logic embodied in hardware or firmware, or to a collection of software instructions, possiNy having entry and exit points, written in a programming language, such as, for examp'e, Java, Lua, C or C++.
A software module may be compiled and linked into an executable program, installed in a dynamic link library, or may be written in an interpreted programming language such as, for example, BAStC, Perl, or Python. It will be appreciated that sothvare modules may be callable from other modules or from themselves, and/or maybe invoked in response to detected events or interrupts. Software modules configured for execution on computing devices may be provided on a computer readable medium, such as a compact disc, digital video disc, flash drive, magnetic disc, or any other tangible medium, or as a digital dowthoad (and may be originally stored in a compressed or installable format that requires installation, decompression or decryption prior to cxccution). Such softwarc codc may bc storcd, partially or fully, on a mcmory dcvicc of the executing computing device, for execution by the computing device. Software instructions may be embedded in firmware, such as an EPROM. Tt will be further appreciated that hardware modules may be comprised of connected logic units, such as gates and flip-flops, and/or may be comprised of programmable units, such as programmable gate arrays or processors. The modules or computing device functionality described herein are preferably implemented as software modules, but may be represented in hardware or firmware. Generally, the modules described herein refer to logical modules that may be combined with other modules or divided into sub-modules despite their physical organization or storage Computer system 800 may implement the techniques described herein using customized hard-wired logic, one or more AS1Cs or FPGAs, firmware and/or program logic which in combination with the computer system causes or programs computer system Soo to be a special-purpose machine. According to one embodiment, the techniques herein are performed by computer system Soo in response to processor(s) 804 executing one or more sequences of one or more instructions contained in main o memory 806. Such instructions maybe read into main memory 8o6 from another storage medium, such as storage device 810. Execution of the sequences of instnictions contained in main memory 8o6 causes processor(s) 804 to perform the process steps described herein. In alternative embodiments, hard-wired circuitry may be used in place of or in combination with software instructions.
The term "non-transitory media," and similar terms, as used herein refers to any media that store data and/or instructions that cause a machine to operate in a specific fashion.
Such non-transitory media may comprise non-volatile media and/or volatile media.
Non-volatile media includes, for example, optical or magnetic disks, such as storage device 8io. Volatile media includes dynamic memory, such as main memory 8o6.
Common forms of non-transitory media include, for example, a floppy disk, a flexible disk, hard disk, solid state drive, magnetic tape, or any other magnetic data storage medium, a CD-ROM, any other optical data storage medium, any physical medium with patterns of holes, a RAM, a PROM, and EPROM, a FLASH-EPROM, NYRAM, any other memory chip or cartridge, and networked versions of the same.
Non-transitory media is distinct from but may be used in conjunction with transmission media. Transmission media participates in transferring information bctwccn nontransitory media. For cxamplc, transmission mcdia includcs coaxial cables, copper wire and fiber optics, including the wires that comprise bus 802.
Transmission media can also take the form of acoustic or light waves, such as those generated during radio-wave and infra-red data communications.
Various forms of media may be involved in carrying one or more sequences of one or more instructions to processor 804 for execution. For example, the instructions may initially be carried on a magnetic disk or solid state drive of a remote computer. The remote computer can load the instructions into its dynamic memory and send the instructions over a telephone line using a modem. A modem ocal to computer system 800 can receive the data on the telephone line and use an infra-red transmitter to convert the data to an infra-red signal. An infra-red detector can receive the data carried in the infra-red signal and appropriate circuitry can place the data on bus 802.
Bus 802 carries the data to main memory 806, from which processor 804 retrieves and executes the instructions. The instructions received by main memory 8o6 may retrieves and executes the instructions. The instructions received by main memory 8o6 may optionally be stored on storage device 810 either before or after execution by processor 804.
Computer system 8oo also includes a communication interface 8i8 coupled to bus 802.
Communication interface 8i8 provides a two-way data communication coupling to a network link 820 that is connected to a ocal network 822. For examp'e, communication interface 818 maybe an integrated services digita' network (TSDN) card, cable modem, sateflite modem, or a modem to provide a data communication connection to a corresponding type of telephone line. As another example, communication interface 818 may be a oca1 area network (LAN) card to provide a data communication connection to a compatible LAN (or WAN component to communicated with a WAN). Wireless links may also be implemented. In any such implementation, communication interface 818 sends and receives electrical, electromagnetic or optical signals that carry digital data streams representing various types of information.
Network link 820 typically provides data communication through one or more networks to other data devices. For example, network link 820 may provide a connection through local network 822 to a host computer 824 or to data equipment operated by an Internet Service Provider (ISP) 826. ISP 826 in turn provides data communication scrviccs through the world widc packet data communication nctwork now commonly referred to as the "Internet" 828. Local network 822 and Internet 828 both use electrical, electromagnetic or optical signa's that carry digita' data streams.
The signals through the various networks and the signals on network fink 820 and through communication interface 818, which carry the digital data to and from computer system 800, are example forms of transmission media.
Computer system 800 can send messages and receive data, including program code, through the network(s), network link 820 and communication interface 818. In the Tnternet example, a server 830 might transmit a requested code for an application program through Tnternet 828, ISP 826, local network 822 and communication interface 818.
The received code may be executed by processor 804 as it is received, and/or stored in storage device 8io, or other non-volatile storage for later execution.
jo Each of the processes, methods, and algorithms described in the preceding sections may be embodied in, and fully or partially automated by, code mod&es executed by one or more computer systems or computer processors comprising computer hardware.
The processes and algorithms may be implemented partially or wholly in application-specific circuitry.
The various features and processes described above may be used independently of one another, or maybe combined in various ways. All possible combinations and subcombinations are intended to fall within the scope of this disclosure. In addition, certain method or process blocks may be omitted in some implementations. The methods and processes described herein are also not limited to any particular sequence, and the blocks or states relating thereto can be performed in other sequences that are appropriate. For example, described blocks or states may be performed in an order other than that specifically disclosed, or multiple blocks or states may be combined in a single block or state. The example blocks or states may be performed in serial, in parallel, or in some other manner. Blocks or states may be added to or removed from the disclosed example embodiments. The example systems and components described herein may be configured differently than described. For example, elements may be added to, removed from, or rearranged compared to the discloscd cxamplc cmbodimcnts.
Conditional language, such as, among others, "can," "could," "might," or "may," un'ess specifically stated otherwise, or otherwise understood within the context as used, is generally intended to convey that certain embodiments include, while other embodiments do not include, certain features, elements and/or steps. Thus, such conditional language is not generally intended to imply that features, elements and/or steps are in anyway required for one or more embodiments or that one or more embodiments necessarily include logic for deciding, with or without user input or prompting, whether these features, elements and/or steps are included or are to be performed in any particular embodiment.
Any process descriptions, elements, or blocks in the flow diagrams described herein and/or depicted in the attached figures should be understood as potentially representing mod tiles, segments, or portions of code which include one or more executable instructions for implementing specific logical functions or steps in the process. Alternate implementations are included within the scope of the embodiments jo described herein in which elements or functions may be deleted, executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those skilled in the art.
Tt should be emphasized that many variations and modifications may be made to the above-described embodiments, the elements of which are to be understood as being among other acceptab'e examples. All such modifications and variations are intended to be included herein within the scope of this disclosure. The foregoing description details certain embodiments of the invention. It will be appreciated, however, that no matter how detailed the foregoing appears in text, the invention can be practiced in many ways. As is also stated above, it should be noted that the use of particular terminology when describing certain features or aspects of the invention should not be taken to imply that the terminology is being re-defined herein to be restricted to including any specific characteristics of the features or aspects of the invention with which that terminology is associated. The scope of the invention should therefore be construed in accordance with the appended claims and any equivalents thereof.
Claims (18)
- Claims 1. A computer system configured to: receive selection of one or more data quality criterion; receive one or more Boolean operators associated with the one or more data quality criterion and/or an indication of how many of the one or more data quality criterion are required in order to identify respective database objects as having potential data quality problems; determine potential data quality problems by scanning data associated with a Jo plurality of database objects of the selected object type, each of the objects having one or more properties and corresponding property values, in order to determine if the selected one or more data quality criterion are matched by properties and/or properties values of respective objects; generate a user interface indicating the potential data quality problems of respective objects having property values matching the selected one or more data quality criterion, and inchiding one or more properties and/or property values of the respective objects; receive from a user of the computer system a resolution of the potential data quality problems; and implement the resolution.
- 2. The computer system of claim 1, wherein the potential data quality problems include at least one of: possible duplicate objects, missing properties, multi-valued properties, unparsed properties, disallowed enumerations, numeric range violations, and date range violations.
- 3. The computer system of claim 1, wherein the potential data quality problem is possible duplicate objects, and said determining potential data quality problems further compriscs idcntifying rcspcctivc objects cach having common propcrty values for a predetermined quantity of properties.
- 4. The computer system of claim 3, wherein the resolution comprises an indication of two or more objects having potential data quafity problems that are duplicates; and said implementing the resolution comprises combining the two or more indicated objects into a single object.
- 5. The computer system of daim 3 or claim 4, wherein the user interface further indicates quantities of the identified respective objects sharing respective common prop erty values.
- 6. The computer system of daim 1, wherein the potential data quality problem is missing properties; and said determining potential data quality problems further comprises identifying respective objects that are missing at least a predetermined quantity of property values.
- 7. The computer system of claim 1, wherein the potential data quality problem is multi-valued properties; and said determining potential data quality problems further comprises identifying respective objects that have multiple property values for individual properties.
- 8. The computer system of claim 7, wherein the resohition comprises an indication of one of the multiple property values that is correct for ones of the properties; and said implementing the resolution further comprises removing all of the multiple property values except for the one of the multiple property values that is correct for respective properties.
- 9. The computer system of daim 1, wherein the potential data quality problem is unparsed properties; and said determining potential data quality problems further comprises identifying respective objects that have one or more property values including unparsed data.
- 10. The computer system of claim 1, wherein the potential data quality problem is disallowed enumerations; and said dctcrmining potential data quality problcms further compriscs identifying respective objects that have one or more property vahies including disallowed enumerations.
- ii. The computer system of claim 1, wherein the potential data quality problem is numeric range violation; and said determining potential data quality problems further comprises identifying respective objects that have one or more property valnes that violate an aflowed numeric range for the respective property.
- 12. The computer system of claim 1, wherein the potential data quality problem is date range violation; and said determining potential data quality problems further comprises identifying respective objects that have one or more property values that violate an allowed date range for respective properties.
- 13. The computer system of claim 1, further comprising receiving selection of one or more object types that the selected object type is required to be associated with in order to be included in the scanned plurality of objects.
- 14. The computer system of claim 1, wherein the object type comprises one of a person, a place, an organization, or a market instrument and the database objects are each associated with specific things of the corresponding object type.
- 15. A computer implemented method comprising: receiving, by a computing system having one or more physical processors and configured to process large amounts of data, selection of an object type to monitor for potential data quality problems; receiving, by the computing system, selection of a data quality monitor type; receiving, by the computing system, selection of one or more data quality criterion of objects of the selected object type; receiving, by the computer system, one or more Boolean operators associated with the one or more data quality criterion and/or an indication of how many of the one or more data quality criterion are required in order to identify respective database objccts as objccts having potential data quality problcms; determining, by the computing system, objects having potential data quality problems by scanning data associated with a pluraBty of objects of the selected object type in order to locate respective objects matching the selected data quality criterion; generating, by the computing system, a user interface indicating the objects having potential data quality problems, and including one or more properties and/or property values of the objects having potential data quality problems; -38 -receiving, by the computing system, a resolution of the potentia' data quality proNems; and implementing, by the computing system, the resohition.
- 16. The computer implemented method of cilaim 15, wherein the data quality monitor type is one of: possible duplicate objects, missing properties, multi-valued properties, unparsed properties, disallowed enumerations, numeric range violation, and date range violation.o
- 17. The computer implemented method of claim 15, wherein the database objects each represent one of a person, place, organization, or market instrument, and includes one or more properties and corresponding property values associated with the respective person, place, organization, or market instrument:
- 18. A computer program comprising computer-executable instructions configured to direct a computing system to perform a method as claimed in any of claims i to 17.
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US13/935,861 US8601326B1 (en) | 2013-07-05 | 2013-07-05 | Data quality monitors |
US14/094,418 US9348851B2 (en) | 2013-07-05 | 2013-12-02 | Data quality monitors |
Publications (2)
Publication Number | Publication Date |
---|---|
GB201411984D0 GB201411984D0 (en) | 2014-08-20 |
GB2517582A true GB2517582A (en) | 2015-02-25 |
Family
ID=51410673
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
GB1411984.6A Withdrawn GB2517582A (en) | 2013-07-05 | 2014-07-04 | Data quality monitors |
Country Status (2)
Country | Link |
---|---|
DE (1) | DE102014213036A1 (en) |
GB (1) | GB2517582A (en) |
Cited By (50)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9286373B2 (en) | 2013-03-15 | 2016-03-15 | Palantir Technologies Inc. | Computer-implemented systems and methods for comparing and associating objects |
US9338013B2 (en) | 2013-12-30 | 2016-05-10 | Palantir Technologies Inc. | Verifiable redactable audit log |
US9348499B2 (en) | 2008-09-15 | 2016-05-24 | Palantir Technologies, Inc. | Sharing objects that rely on local resources with outside servers |
US9392008B1 (en) | 2015-07-23 | 2016-07-12 | Palantir Technologies Inc. | Systems and methods for identifying information related to payment card breaches |
US9483546B2 (en) | 2014-12-15 | 2016-11-01 | Palantir Technologies Inc. | System and method for associating related records to common entities across multiple lists |
US9495353B2 (en) | 2013-03-15 | 2016-11-15 | Palantir Technologies Inc. | Method and system for generating a parser and parsing complex data |
US9501552B2 (en) | 2007-10-18 | 2016-11-22 | Palantir Technologies, Inc. | Resolving database entity information |
US9514414B1 (en) | 2015-12-11 | 2016-12-06 | Palantir Technologies Inc. | Systems and methods for identifying and categorizing electronic documents through machine learning |
US9678850B1 (en) | 2016-06-10 | 2017-06-13 | Palantir Technologies Inc. | Data pipeline monitoring |
US9715518B2 (en) | 2012-01-23 | 2017-07-25 | Palantir Technologies, Inc. | Cross-ACL multi-master replication |
US9760556B1 (en) | 2015-12-11 | 2017-09-12 | Palantir Technologies Inc. | Systems and methods for annotating and linking electronic documents |
US9772934B2 (en) | 2015-09-14 | 2017-09-26 | Palantir Technologies Inc. | Pluggable fault detection tests for data pipelines |
US9852205B2 (en) | 2013-03-15 | 2017-12-26 | Palantir Technologies Inc. | Time-sensitive cube |
US9880987B2 (en) | 2011-08-25 | 2018-01-30 | Palantir Technologies, Inc. | System and method for parameterizing documents for automatic workflow generation |
US9898335B1 (en) | 2012-10-22 | 2018-02-20 | Palantir Technologies Inc. | System and method for batch evaluation programs |
US9946738B2 (en) | 2014-11-05 | 2018-04-17 | Palantir Technologies, Inc. | Universal data pipeline |
US9965534B2 (en) | 2015-09-09 | 2018-05-08 | Palantir Technologies, Inc. | Domain-specific language for dataset transformations |
US9984428B2 (en) | 2015-09-04 | 2018-05-29 | Palantir Technologies Inc. | Systems and methods for structuring data from unstructured electronic data files |
US9996595B2 (en) | 2015-08-03 | 2018-06-12 | Palantir Technologies, Inc. | Providing full data provenance visualization for versioned datasets |
US9996229B2 (en) | 2013-10-03 | 2018-06-12 | Palantir Technologies Inc. | Systems and methods for analyzing performance of an entity |
US10007674B2 (en) | 2016-06-13 | 2018-06-26 | Palantir Technologies Inc. | Data revision control in large-scale data analytic systems |
US10061828B2 (en) | 2006-11-20 | 2018-08-28 | Palantir Technologies, Inc. | Cross-ontology multi-master replication |
US10103953B1 (en) | 2015-05-12 | 2018-10-16 | Palantir Technologies Inc. | Methods and systems for analyzing entity performance |
US10127289B2 (en) | 2015-08-19 | 2018-11-13 | Palantir Technologies Inc. | Systems and methods for automatic clustering and canonical designation of related data in various data structures |
US10133588B1 (en) | 2016-10-20 | 2018-11-20 | Palantir Technologies Inc. | Transforming instructions for collaborative updates |
US10133782B2 (en) | 2016-08-01 | 2018-11-20 | Palantir Technologies Inc. | Techniques for data extraction |
US10140664B2 (en) | 2013-03-14 | 2018-11-27 | Palantir Technologies Inc. | Resolving similar entities from a transaction database |
US10180977B2 (en) | 2014-03-18 | 2019-01-15 | Palantir Technologies Inc. | Determining and extracting changed data from a data source |
US10198515B1 (en) | 2013-12-10 | 2019-02-05 | Palantir Technologies Inc. | System and method for aggregating data from a plurality of data sources |
US10235533B1 (en) | 2017-12-01 | 2019-03-19 | Palantir Technologies Inc. | Multi-user access controls in electronic simultaneously editable document editor |
US10452678B2 (en) | 2013-03-15 | 2019-10-22 | Palantir Technologies Inc. | Filter chains for exploring large data sets |
US10496529B1 (en) | 2018-04-18 | 2019-12-03 | Palantir Technologies Inc. | Data unit test-based data management system |
US10503574B1 (en) | 2017-04-10 | 2019-12-10 | Palantir Technologies Inc. | Systems and methods for validating data |
US10579647B1 (en) | 2013-12-16 | 2020-03-03 | Palantir Technologies Inc. | Methods and systems for analyzing entity performance |
US10621314B2 (en) | 2016-08-01 | 2020-04-14 | Palantir Technologies Inc. | Secure deployment of a software package |
US10628834B1 (en) | 2015-06-16 | 2020-04-21 | Palantir Technologies Inc. | Fraud lead detection system for efficiently processing database-stored data and automatically generating natural language explanatory information of system results for display in interactive user interfaces |
US10636097B2 (en) | 2015-07-21 | 2020-04-28 | Palantir Technologies Inc. | Systems and models for data analytics |
US10754822B1 (en) | 2018-04-18 | 2020-08-25 | Palantir Technologies Inc. | Systems and methods for ontology migration |
US10762102B2 (en) | 2013-06-20 | 2020-09-01 | Palantir Technologies Inc. | System and method for incremental replication |
US10795909B1 (en) | 2018-06-14 | 2020-10-06 | Palantir Technologies Inc. | Minimized and collapsed resource dependency path |
US10838987B1 (en) | 2017-12-20 | 2020-11-17 | Palantir Technologies Inc. | Adaptive and transparent entity screening |
US10853454B2 (en) | 2014-03-21 | 2020-12-01 | Palantir Technologies Inc. | Provider portal |
US10866792B1 (en) | 2018-04-17 | 2020-12-15 | Palantir Technologies Inc. | System and methods for rules-based cleaning of deployment pipelines |
US10956406B2 (en) | 2017-06-12 | 2021-03-23 | Palantir Technologies Inc. | Propagated deletion of database records and derived data |
US10970261B2 (en) | 2013-07-05 | 2021-04-06 | Palantir Technologies Inc. | System and method for data quality monitors |
US11061874B1 (en) | 2017-12-14 | 2021-07-13 | Palantir Technologies Inc. | Systems and methods for resolving entity data across various data structures |
US11061542B1 (en) | 2018-06-01 | 2021-07-13 | Palantir Technologies Inc. | Systems and methods for determining and displaying optimal associations of data items |
US11074277B1 (en) | 2017-05-01 | 2021-07-27 | Palantir Technologies Inc. | Secure resolution of canonical entities |
US11106692B1 (en) | 2016-08-04 | 2021-08-31 | Palantir Technologies Inc. | Data record resolution and correlation system |
US11302426B1 (en) | 2015-01-02 | 2022-04-12 | Palantir Technologies Inc. | Unified data interface and system |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8601326B1 (en) | 2013-07-05 | 2013-12-03 | Palantir Technologies, Inc. | Data quality monitors |
-
2014
- 2014-07-04 DE DE102014213036.0A patent/DE102014213036A1/en not_active Withdrawn
- 2014-07-04 GB GB1411984.6A patent/GB2517582A/en not_active Withdrawn
Non-Patent Citations (1)
Title |
---|
None * |
Cited By (77)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US10061828B2 (en) | 2006-11-20 | 2018-08-28 | Palantir Technologies, Inc. | Cross-ontology multi-master replication |
US10733200B2 (en) | 2007-10-18 | 2020-08-04 | Palantir Technologies Inc. | Resolving database entity information |
US9501552B2 (en) | 2007-10-18 | 2016-11-22 | Palantir Technologies, Inc. | Resolving database entity information |
US9846731B2 (en) | 2007-10-18 | 2017-12-19 | Palantir Technologies, Inc. | Resolving database entity information |
US9348499B2 (en) | 2008-09-15 | 2016-05-24 | Palantir Technologies, Inc. | Sharing objects that rely on local resources with outside servers |
US10747952B2 (en) | 2008-09-15 | 2020-08-18 | Palantir Technologies, Inc. | Automatic creation and server push of multiple distinct drafts |
US11693877B2 (en) | 2011-03-31 | 2023-07-04 | Palantir Technologies Inc. | Cross-ontology multi-master replication |
US9880987B2 (en) | 2011-08-25 | 2018-01-30 | Palantir Technologies, Inc. | System and method for parameterizing documents for automatic workflow generation |
US10706220B2 (en) | 2011-08-25 | 2020-07-07 | Palantir Technologies, Inc. | System and method for parameterizing documents for automatic workflow generation |
US9715518B2 (en) | 2012-01-23 | 2017-07-25 | Palantir Technologies, Inc. | Cross-ACL multi-master replication |
US9898335B1 (en) | 2012-10-22 | 2018-02-20 | Palantir Technologies Inc. | System and method for batch evaluation programs |
US11182204B2 (en) | 2012-10-22 | 2021-11-23 | Palantir Technologies Inc. | System and method for batch evaluation programs |
US10140664B2 (en) | 2013-03-14 | 2018-11-27 | Palantir Technologies Inc. | Resolving similar entities from a transaction database |
US10152531B2 (en) | 2013-03-15 | 2018-12-11 | Palantir Technologies Inc. | Computer-implemented systems and methods for comparing and associating objects |
US9852205B2 (en) | 2013-03-15 | 2017-12-26 | Palantir Technologies Inc. | Time-sensitive cube |
US9495353B2 (en) | 2013-03-15 | 2016-11-15 | Palantir Technologies Inc. | Method and system for generating a parser and parsing complex data |
US10120857B2 (en) | 2013-03-15 | 2018-11-06 | Palantir Technologies Inc. | Method and system for generating a parser and parsing complex data |
US10452678B2 (en) | 2013-03-15 | 2019-10-22 | Palantir Technologies Inc. | Filter chains for exploring large data sets |
US9286373B2 (en) | 2013-03-15 | 2016-03-15 | Palantir Technologies Inc. | Computer-implemented systems and methods for comparing and associating objects |
US10977279B2 (en) | 2013-03-15 | 2021-04-13 | Palantir Technologies Inc. | Time-sensitive cube |
US10762102B2 (en) | 2013-06-20 | 2020-09-01 | Palantir Technologies Inc. | System and method for incremental replication |
US10970261B2 (en) | 2013-07-05 | 2021-04-06 | Palantir Technologies Inc. | System and method for data quality monitors |
US9996229B2 (en) | 2013-10-03 | 2018-06-12 | Palantir Technologies Inc. | Systems and methods for analyzing performance of an entity |
US10198515B1 (en) | 2013-12-10 | 2019-02-05 | Palantir Technologies Inc. | System and method for aggregating data from a plurality of data sources |
US11138279B1 (en) | 2013-12-10 | 2021-10-05 | Palantir Technologies Inc. | System and method for aggregating data from a plurality of data sources |
US10579647B1 (en) | 2013-12-16 | 2020-03-03 | Palantir Technologies Inc. | Methods and systems for analyzing entity performance |
US10027473B2 (en) | 2013-12-30 | 2018-07-17 | Palantir Technologies Inc. | Verifiable redactable audit log |
US9338013B2 (en) | 2013-12-30 | 2016-05-10 | Palantir Technologies Inc. | Verifiable redactable audit log |
US11032065B2 (en) | 2013-12-30 | 2021-06-08 | Palantir Technologies Inc. | Verifiable redactable audit log |
US10180977B2 (en) | 2014-03-18 | 2019-01-15 | Palantir Technologies Inc. | Determining and extracting changed data from a data source |
US10853454B2 (en) | 2014-03-21 | 2020-12-01 | Palantir Technologies Inc. | Provider portal |
US9946738B2 (en) | 2014-11-05 | 2018-04-17 | Palantir Technologies, Inc. | Universal data pipeline |
US10853338B2 (en) | 2014-11-05 | 2020-12-01 | Palantir Technologies Inc. | Universal data pipeline |
US10191926B2 (en) | 2014-11-05 | 2019-01-29 | Palantir Technologies, Inc. | Universal data pipeline |
US10242072B2 (en) | 2014-12-15 | 2019-03-26 | Palantir Technologies Inc. | System and method for associating related records to common entities across multiple lists |
US9483546B2 (en) | 2014-12-15 | 2016-11-01 | Palantir Technologies Inc. | System and method for associating related records to common entities across multiple lists |
US11302426B1 (en) | 2015-01-02 | 2022-04-12 | Palantir Technologies Inc. | Unified data interface and system |
US10103953B1 (en) | 2015-05-12 | 2018-10-16 | Palantir Technologies Inc. | Methods and systems for analyzing entity performance |
US10628834B1 (en) | 2015-06-16 | 2020-04-21 | Palantir Technologies Inc. | Fraud lead detection system for efficiently processing database-stored data and automatically generating natural language explanatory information of system results for display in interactive user interfaces |
US10636097B2 (en) | 2015-07-21 | 2020-04-28 | Palantir Technologies Inc. | Systems and models for data analytics |
US9661012B2 (en) | 2015-07-23 | 2017-05-23 | Palantir Technologies Inc. | Systems and methods for identifying information related to payment card breaches |
US9392008B1 (en) | 2015-07-23 | 2016-07-12 | Palantir Technologies Inc. | Systems and methods for identifying information related to payment card breaches |
US9996595B2 (en) | 2015-08-03 | 2018-06-12 | Palantir Technologies, Inc. | Providing full data provenance visualization for versioned datasets |
US11392591B2 (en) | 2015-08-19 | 2022-07-19 | Palantir Technologies Inc. | Systems and methods for automatic clustering and canonical designation of related data in various data structures |
US12038933B2 (en) | 2015-08-19 | 2024-07-16 | Palantir Technologies Inc. | Systems and methods for automatic clustering and canonical designation of related data in various data structures |
US10127289B2 (en) | 2015-08-19 | 2018-11-13 | Palantir Technologies Inc. | Systems and methods for automatic clustering and canonical designation of related data in various data structures |
US9984428B2 (en) | 2015-09-04 | 2018-05-29 | Palantir Technologies Inc. | Systems and methods for structuring data from unstructured electronic data files |
US9965534B2 (en) | 2015-09-09 | 2018-05-08 | Palantir Technologies, Inc. | Domain-specific language for dataset transformations |
US11080296B2 (en) | 2015-09-09 | 2021-08-03 | Palantir Technologies Inc. | Domain-specific language for dataset transformations |
US10417120B2 (en) | 2015-09-14 | 2019-09-17 | Palantir Technologies Inc. | Pluggable fault detection tests for data pipelines |
US10936479B2 (en) | 2015-09-14 | 2021-03-02 | Palantir Technologies Inc. | Pluggable fault detection tests for data pipelines |
US9772934B2 (en) | 2015-09-14 | 2017-09-26 | Palantir Technologies Inc. | Pluggable fault detection tests for data pipelines |
US9760556B1 (en) | 2015-12-11 | 2017-09-12 | Palantir Technologies Inc. | Systems and methods for annotating and linking electronic documents |
US10817655B2 (en) | 2015-12-11 | 2020-10-27 | Palantir Technologies Inc. | Systems and methods for annotating and linking electronic documents |
US9514414B1 (en) | 2015-12-11 | 2016-12-06 | Palantir Technologies Inc. | Systems and methods for identifying and categorizing electronic documents through machine learning |
US9678850B1 (en) | 2016-06-10 | 2017-06-13 | Palantir Technologies Inc. | Data pipeline monitoring |
US10318398B2 (en) | 2016-06-10 | 2019-06-11 | Palantir Technologies Inc. | Data pipeline monitoring |
US11106638B2 (en) | 2016-06-13 | 2021-08-31 | Palantir Technologies Inc. | Data revision control in large-scale data analytic systems |
US10007674B2 (en) | 2016-06-13 | 2018-06-26 | Palantir Technologies Inc. | Data revision control in large-scale data analytic systems |
US10621314B2 (en) | 2016-08-01 | 2020-04-14 | Palantir Technologies Inc. | Secure deployment of a software package |
US10133782B2 (en) | 2016-08-01 | 2018-11-20 | Palantir Technologies Inc. | Techniques for data extraction |
US11106692B1 (en) | 2016-08-04 | 2021-08-31 | Palantir Technologies Inc. | Data record resolution and correlation system |
US10133588B1 (en) | 2016-10-20 | 2018-11-20 | Palantir Technologies Inc. | Transforming instructions for collaborative updates |
US11221898B2 (en) | 2017-04-10 | 2022-01-11 | Palantir Technologies Inc. | Systems and methods for validating data |
US10503574B1 (en) | 2017-04-10 | 2019-12-10 | Palantir Technologies Inc. | Systems and methods for validating data |
US11074277B1 (en) | 2017-05-01 | 2021-07-27 | Palantir Technologies Inc. | Secure resolution of canonical entities |
US10956406B2 (en) | 2017-06-12 | 2021-03-23 | Palantir Technologies Inc. | Propagated deletion of database records and derived data |
US10235533B1 (en) | 2017-12-01 | 2019-03-19 | Palantir Technologies Inc. | Multi-user access controls in electronic simultaneously editable document editor |
US11061874B1 (en) | 2017-12-14 | 2021-07-13 | Palantir Technologies Inc. | Systems and methods for resolving entity data across various data structures |
US10838987B1 (en) | 2017-12-20 | 2020-11-17 | Palantir Technologies Inc. | Adaptive and transparent entity screening |
US10866792B1 (en) | 2018-04-17 | 2020-12-15 | Palantir Technologies Inc. | System and methods for rules-based cleaning of deployment pipelines |
US10754822B1 (en) | 2018-04-18 | 2020-08-25 | Palantir Technologies Inc. | Systems and methods for ontology migration |
US11294801B2 (en) | 2018-04-18 | 2022-04-05 | Palantir Technologies Inc. | Data unit test-based data management system |
US10496529B1 (en) | 2018-04-18 | 2019-12-03 | Palantir Technologies Inc. | Data unit test-based data management system |
US12032476B2 (en) | 2018-04-18 | 2024-07-09 | Palantir Technologies Inc. | Data unit test-based data management system |
US11061542B1 (en) | 2018-06-01 | 2021-07-13 | Palantir Technologies Inc. | Systems and methods for determining and displaying optimal associations of data items |
US10795909B1 (en) | 2018-06-14 | 2020-10-06 | Palantir Technologies Inc. | Minimized and collapsed resource dependency path |
Also Published As
Publication number | Publication date |
---|---|
GB201411984D0 (en) | 2014-08-20 |
DE102014213036A1 (en) | 2015-01-22 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US11599513B2 (en) | System and method for data quality monitors | |
GB2517582A (en) | Data quality monitors | |
US20210004368A1 (en) | System and user interfaces for searching resources and related documents using data structures | |
US11580680B2 (en) | Systems and interactive user interfaces for dynamic retrieval, analysis, and triage of data items | |
JP7490729B2 (en) | Development of spreadsheet-based software applications | |
JP5306360B2 (en) | Method and system for analysis of systems for matching data records | |
US9626088B2 (en) | System and method for generating event visualizations | |
US20110107203A1 (en) | System and method for providing judicial orders | |
US20050209903A1 (en) | System for assisting user with task involving form, and related apparatuses, methods, and computer-readable media | |
US20070050701A1 (en) | Method, system and computer program product for medical form creation | |
WO2003088032A1 (en) | Data exchange method and system | |
US20230090961A1 (en) | Audit logging database system and user interface | |
US20130232106A1 (en) | System and Method For Applying An Update To A Database | |
US20080109439A1 (en) | Apparatus and method for a collaborative semantic domain and data set based on combining data | |
US20190087484A1 (en) | Capturing context using network visualization | |
RU2728809C1 (en) | Method and system for validating complex data structures in a complex micro-service architecture with visual display of results | |
US20230141519A1 (en) | System, Method, and Computer Program Product for Automatically Preparing Documents for a Multi-National Organization | |
AU2014200156A1 (en) | Investigation management method and system | |
JP2005522789A (en) | Systems and user interfaces that support the use of rules to process health care and other billing data. | |
Gonçalves | Software for Clinical Data Interaction | |
AU2005201489A1 (en) | Method and means for analysis of incident data |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
WAP | Application withdrawn, taken to be withdrawn or refused ** after publication under section 16(1) |