Database management system for merging data into a database

Inventors: Chun Wang (Austin, TX); Rick Thielke (Austin, TX); Mubbashir Nazir (Kolkata, IN); Sean Yang (Austin, TX); Wensu Wang (Austin, TX); Michael Smith-Palmer (Austin, TX)

Assignee: DatalnfoCom USA, Inc.

G06F16/258 G06F7/14 G06F16/245

View Patent ↗

Loading inventors, assignments & file history…

Monitor This Case

Get email alerts when status or documents change.

Order Certified Copies

Most orders are placed with the USPTO same day — all within 24 business hours.

Order via The Patent Place →

Pre-filled with this patent's details

Quick Facts

Patent No.: US 10,866,962
App. No.: 16/146,590
Granted: Dec 15, 2020
Kind: B2

External Links

USPTO Patent Center↗ Full Patent PDF↗

Abstract

A system for merging data into a database is disclosed. During operation, the system may fetch a set of data from a data source external to the database. The system may determine that the fetched set of data is unstructured data, and then transform the fetched set of data into structured data. The system may also determine one or more lowest denominators for the fetched set of data, determine that the fetched set of data does not meet the one or more lowest denominators, and transform the fetched set of data to meet the one or more lowest denominators. The system may further determine one or more joinable keys for the fetched set of data, and merge the fetched set of data into the database.

Claims (35)

1. A system, comprising:

a memory that stores instructions; and

a processor that executes the instructions to perform operations, the operations comprising:

fetching a set of data from a data source external to a database;

determining that the fetched set of data is unstructured data;

following the determination that the fetched set of data is unstructured data, transforming the fetched set of data into structured data;

determining one or more lowest denominators for the fetched set of data, the one or more lowest denominators comprising one or more of a spatial denominator and a temporal denominator;

determining that the fetched set of data does not meet the one or more lowest denominators;

following the determination that the fetched set of data does not meet the one or more lowest denominators, transforming the fetched set of data to meet the one or more lowest denominators;

determining one or more joinable keys for the fetched set of data, the one or more joinable keys providing a connection to a set of data stored in the database; and

merging the fetched set of data into the database with the set of data stored in the database.

2. The system of claim 1 , further comprising:

transmitting a query to the database for a portion of data stored in the database;

receiving the queried portion of data from the database;

transmitting the queried portion of data for use by a user.

3. The system of claim 2 , wherein transmitting the queried portion of data for use by a user comprises transmitting the queried portion of data for display to the user.

4. The system of claim 1 , further comprising filtering out a portion of the data included in the fetched set of data prior to merging the fetched set of data into the database.

5. A method, comprising:

fetching, by utilizing instructions from a memory that are executed by a processor, a set of data from a data source external to a database;