SYSTEM FOR DATABASE DATA QUALITY PROCESSING

• US 20170103101A1
• Filed: 10/07/2016
• Published: 04/13/2017
• Est. Priority Date: 10/07/2015
• Status: Abandoned Application

• Current Assignee: Verizon Patent and Licensing Incorporated (Verizon Communications Inc.)
• Original Assignee: Telogis Incorporated (Verizon Communications Inc.)
• Inventors: Mason, Ralph James
• Application Number:
  US15/288,195
• Publication Number:
  US 20170103101A1
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/24578 using ranking
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G07C 5/008 communicating information to a remotely located station transmission systems for measured values G08C
• CPC Class Codes: G07C 5/0808 Diagnosing performance data testing of vehicles G01M17/00; testing of electrical installation on vehicles G01R31/005

Abstract

In an embodiment, a system can determine potential data quality issues in a database. The system applies quality assignment rules to a data set. The quality assignment rules access data from the data set or calculate one or more values from data entries of the data set. Data entries or determined values that satisfy the quality assignment rules receive one or more scores. The system then presents a subset of the data set based on the determined one or more scores. Accordingly, a user of the system can determine the source of the data quality issues such as a broken or miscalibrated data gathering device.

Claims

1. A system for determining data quality issues in a database, the system comprising:

a computer hardware processor in a physical computing device, the computer hardware processor being configured to;

receive a data set comprising first data and second data;

apply a first quality assignment rule to the first data to determine;

(i) that a first value corresponding to the first data exceeds a first threshold, and (ii) a first score for the first data;

apply the first quality assignment rule to the second data to determine;

(i) that a second value corresponding to the second data exceeds a second threshold, and (ii) a second score for the second data;

apply a second quality assignment rule to the first data to determine;

(i) that a third value corresponding to the first data exceeds a third threshold, and (ii) an updated first score, from the first score, for the first data;

apply the second quality assignment rule to the second data to determine that a fourth value corresponding to the second data does not exceed the third threshold;

determine a subset of the data set based at least on the updated first score and the second score, wherein the subset of the data set does not include the first data; and

cause presentation, in a user interface, of the subset of the data set.

2. The system of claim 1, wherein the data set comprises vehicle telematics data.

3. The system of claim 1, wherein the computer hardware processor is configured to determine the first value from a calculation of the first data according to the first quality assignment rule.

4. The system of claim 1, wherein the computer hardware processor is configured to apply the first quality assignment rule by determining, from the first data, of at least one of:

a speed, a time, a distance, a mass, a weight, an electric current, a temperature, or a luminous intensity.

5. The system of claim 1, wherein the computer hardware processor is configured determine the subset of the data set further by:

receiving a first data quality level;

determining that the updated first score does not correspond to the first data quality level;

determining that the second score corresponds to the first data quality level; and

generating the subset of the data set from the second data.

6. The system of claim 1, wherein the computer hardware processor is configured to:

apply the second quality assignment rule to the first data to determine a third score; and

determine the updated first score by adding the first score and the third score.

7. A method for determining data quality issues with fleet vehicle operation information, the method comprising:

receiving vehicle telematics data comprising first data and second data, the first data corresponding to a first vehicle and the second data corresponding to a second vehicle;

applying a first quality assignment rule to the first data to determine;

(i) that a first value corresponding to the first data exceeds a first threshold, and (ii) a first score for the first data;

applying the first quality assignment rule to the second data to determine;

(i) that a second value corresponding to the second data exceeds a second threshold, and (ii) a second score for the second data;

applying a second quality assignment rule to the first data to determine;

(i) that a third value corresponding to the first data exceeds a third threshold, and (ii) an updated first score, from the first score, for the first data;

applying the second quality assignment rule to the second data to determine that a fourth value corresponding to the second data does not exceed the third threshold;

determining a subset of the vehicle telematics data based at least on the updated first score and the second score, wherein the subset of the vehicle telematics data does not include the first data; and

causing presentation, in a user interface, of the subset of the vehicle telematics data.

8. The method of claim 7, wherein said applying the first quality assignment rule comprises determining, from the first data, of at least one of:

a driving speed, a driving time, an idle time, an amount of fuel, or a GPS coordinate.

9. The method of claim 7, wherein said applying the first quality assignment rule to the first data determines the first value, the first value corresponding to a driving distance divided by a driving time, the first threshold corresponding to a speed threshold.

10. The method of claim 7, wherein the first value corresponds to an idle time from the first data, and the first threshold corresponds to an idle time threshold.

11. The method of claim 7, wherein the first value corresponds to a fuel usage measurement from the first data, and the first threshold corresponds to a fuel usage threshold.

12. The method of claim 7, wherein said determining the subset of the vehicle telematics data comprises:

receiving a first data quality level;

determining that the updated first score does not correspond to the first data quality level;

determining that the second score corresponds to the first data quality level; and

generating the subset of the vehicle telematics data from the second data.

13. A system for determining data quality issues with fleet vehicle operation information, the system comprising:

a computer hardware processor in a physical computing device, the computer hardware processor being configured to;

receive vehicle telematics data, the vehicle telematics data comprising first data and second data;

apply a first quality assignment rule to the first data to determine;

(i) that a first value corresponding to the first data exceeds a first threshold, and (ii) a first score for the first data;

apply the first quality assignment rule to the second data to determine;

(i) that a second value corresponding to the second data exceeds a second threshold, and (ii) a second score for the second data;

apply a second quality assignment rule to the first data to determine;

(i) that a third value corresponding to the first data exceeds a third threshold, and (ii) an updated first score, from the first score, for the first data;

apply the second quality assignment rule to the second data to determine that a fourth value corresponding to the second data does not exceed the third threshold;

determine a subset of the vehicle telematics data based at least on the updated first score and the second score, wherein the subset of the vehicle telematics data does not include the first data; and

cause presentation, in a user interface, of the subset of the vehicle telematics data.

14. The system of claim 13, wherein the computer hardware processor is configured to apply the first quality assignment rule to determine, from the first data, of at least one of:

a driving speed, a driving time, an idle time, an amount of fuel, or a GPS coordinate.

15. The system of claim 13, wherein the computer hardware processor is configured to apply the first quality assignment rule to the first data to determine the first value, the first value corresponds to a driving distance divided by a driving time, and the first threshold corresponds to a speed threshold.

16. The system of claim 13, wherein the first value corresponds to an idle time from the first data, and the first threshold corresponds to an idle time threshold.

17. The system of claim 13, wherein the computer hardware processor is configured to apply the first quality assignment rule to the first data to determine the first value, the first value corresponding to a driving distance divided by a fuel usage measurement, the first threshold corresponding to a distance per fuel unit threshold.

18. The system of claim 13, wherein the computer hardware processor is configured to determine the subset of the vehicle telematics data further by:

receiving a first data quality level;

determining that the updated first score does not correspond to the first data quality level;

determining that the second score corresponds to the first data quality level; and

generating the subset of the vehicle telematics data from the second data.

19. The system of claim 13, wherein the computer hardware processor is configured to select, from a plurality of thresholds, the first threshold based at least on a vehicle type that corresponds to the first data.

20. The system of claim 13, wherein the first threshold and the second threshold are the same threshold value, and the first score and the second score are the same score value.