US 11,386,107 B1Granted

Variable data source dynamic and automatic ingestion and auditing platform apparatuses, methods and systems

AssigneeOmnicom Media Group Holdings Inc.

InventorsSarah Walker, Eric Whitney, Karl Huckel

Life of this patent

Estimating the term…

Loading patent…

Abstract

The Variable Data Source Dynamic and Automatic Ingestion and Auditing Platform Apparatuses, Methods and Systems (“DIAP”) transforms file upload request, external data request, and analytics request inputs via DIAP components into clean data, metadata data sets, visualization module output, and audit notification outputs. A data ingest request is obtained via a user interface. A data file to ingest is obtained and processed to generate a clean file. A database table with a unique name is created and data in the clean file loaded into the database table. A metadata data set identifier is generated. Table columns from the database table to include into the metadata data set are determined, and the metadata data set is generated. The metadata data set links columns from the database table to analytics engine UI elements, and columns are associated with audit trail data via the metadata data set identifier.

Claims8

Dependent claims

A variable data source ingest and audit apparatus, comprising:

a memory;
a component collection in the memory, including:
a data ingest user interface component,
an dynamic and variable ingest component,
an dynamic and variable ingest audit component;
a processor disposed in communication with the memory, and configured to issue a plurality of processing instructions from the component collection stored in the memory,
wherein the processor issues instructions from the data ingest user interface component, stored in the memory, to:
obtain a data source selection identifier via data ingest user interface component;
wherein the processor issues instructions from the dynamic and variable ingest component, stored in the memory, to:
obtain access to a data source via variable ingest component from a data source selection identifier;
detect the data source's data structural construct, wherein the data source's data structural construct includes any of:
column structure, clean values, and anomalous values;
clean the detected data source's data structural construct's data values;
create clean data bucket from the cleaned data source's data structural construct's data values;
generate an alternation tamper detecting data bucket table from the detected data source's data structural construct's data values;
execute data definition on the alteration tamper detecting data bucket table;
generate a visualization module and metadata data sets from the alteration tamper detecting data bucket table;
wherein the processor issues instructions from the dynamic and variable ingest audit component, stored in the memory, to:
detect data alteration tampering anomalies by examining the alteration tamper detecting data bucket table for anomalous values differing from clean data bucket;
generate a notification for detected data tampering anomalies.

17 more elements

Dependencies are inferred from the claim text.

Facts

Application: 15/042,857Filed 12 Feb 2016 · us provisional application
Priority: 13 Feb 2015
Granted: 12 Jul 2022
Term ends: Not estimatedThe source records don’t support an estimate.

Classification5 codes

G06F 16/254
Integrating or interfacing systems involving database management systems: extract, transform and load [ETL] procedures, e.g. ETL data flows in…
G06F 16/211
Design, administration or maintenance of databases: schema design and management
G06F 16/221
Indexing; Data structures therefor; Storage structures: column-oriented storage; Management thereof
G06F 16/252
Integrating or interfacing systems involving database management systems: between a Database Management System and a front-end application