# US 2018/0322166 A1 · System and method of extracting data from structured and unstructured sources of data using automated joins

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2018/0322166 A1
- Document ID: US20180322166A1
- Status: Published application
- Kind: A1
- Application number: 15/588,435
- Filed: 2017-05-05
- Published: 2018-11-08
- Earliest claimed: 2017-05-05
- Assignees: Atlantic Technical Organization
- Applicants: Atlantic Technical Organization
- Inventors: Arturo Geigel; Victor Rivera
- Web page: https://patentgrep.com/patent/US20180322166A1

## CPC

- G06F 16/2423: {Interactive query statement specification based on a database schema}
- G01C 21/3446: {Details of route searching algorithms, e.g. Dijkstra, A*, arc-flags or using precalculated routes}
- G06F 16/2428: {Query predicate definition using graphical user interfaces, including menus and forms (G06F16/2423 takes precedence)}
- G06F 16/24526: {Internal representations for queries}
- G06F 16/2456: {Join operations}
- G06F 16/322: {Trees}
- G06F 16/284: {Relational databases}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- G01C: MEASURING DISTANCES, LEVELS OR BEARINGS; SURVEYING; NAVIGATION; GYROSCOPIC INSTRUMENTS; PHOTOGRAMMETRY OR VIDEOGRAMMETRY (measuring liquid level G01F; radio navigation, determining distance or velocity by use of propagation effects, e.g. Doppler effects, propagation time, of radio waves, analogous arrangements using other waves G01S)

## Abstract

System and method for creating enabling the user to select fields from a database, semi structured or unstructured documents that produces an automated process of joining the database tables, semi structured or unstructured documents into a feature vector that can be further processed by machine learning algorithms or preprocessing routines and filters. The full join performed starts by producing a graph representation of the links between data tables/documents and then restructuring the information into the most efficient join tree. The join tree then extracts the data in the form of a feature vector.

## Claims

### Claim 1

A computer operable method to extract data from a database wherein said database includes a plurality of record sources and a plurality of relationships therebetween, said method comprising:
selecting at least a first record source from among said plurality record sources in said database, wherein said first record source comprises at least a first foreign key relationship,
selecting least a second record source from among said plurality record sources in said database, wherein said second record source comprises at least a second foreign key relationship;
determining at least a first path relationship between said first record source and said second record source among said plurality record sources, wherein said first path includes a plurality of nodes, wherein a weight is assigned to each node,
perform a full outer join operation on said first record source to connect said second record source;
generating a graph of said full outer join operation defined by said first record source, said second record source and said path relationship among said plurality of record sources;
and generating at least a first tree comprising a source node.

### Claim 2 (depends on 1)

The method according to claim 1 comprising the step of selecting at least a first field, wherein said first field is at least one field from among said plurality record sources.

### Claim 3 (depends on 1)

The method according to claim 1 wherein the step of selecting at least a first field comprises a graphical user display of database table fields for an user selection.

### Claim 4

A system, comprising:
circuitry configured for displaying real time images and associated data, wherein said circuitry configured for displaying real time images and associated data comprises an interface system;
circuitry configured for transferring an user request to a central processing system, wherein said central processing system is connected to a data base storage, wherein said data storage comprises a meta information;
circuitry configured for selecting at least a first record source from among said plurality record sources in said database, wherein said first record source comprises at least a first foreign key relationship,
circuitry configured for selecting least a second record source from among said plurality record sources in said database, wherein said second record source comprises at least a second foreign key relationship;
circuitry configured for determining at least a first path relationship between said first record source and said second record source among said plurality record sources, wherein said first path includes a plurality of nodes, wherein a weight is assigned to each node,
circuitry configured for performing a full outer join operation on said first record source to connect said second record source;
circuitry configured for generating a graph of said full outer join operation defined by said first record source, said second record source and said path relationship among said plurality of record sources;
and circuitry configured for generating at least a first tree comprising a source node.

### Claim 5 (depends on 17)

The system of claim 17, wherein said central processing system comprises a structured data source collection.

### Claim 6 (depends on 17)

The system of claim 17, wherein said central processing system comprises a unstructured data source collection.

### Claim 7 (depends on 17)

The system of claim 17, wherein said data storage comprises a database schema to store said meta information.