# US 2014/0201192 A1 · Automatic data index establishment method

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

- Number: US 2014/0201192 A1
- Document ID: US20140201192A1
- Status: Published application
- Kind: A1
- Application number: 13/741,400
- Filed: 2013-01-15
- Published: 2014-07-17
- Earliest claimed: 2013-01-15
- Assignees: Syscom Computer Engineering Co.
- Applicants: Syscom Computer Engineering Co.
- Inventors: PEI-FEN HU; CHEN-YU YEN; SHU-YUAN HU; KUN-TING CHIU
- Web page: https://patentgrep.com/patent/US20140201192A1

## CPC

- G06F 16/2272: {Management thereof}
- G06F 16/2455: Query execution
- G06F 16/24553: {of query operations}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

An automatic data index establishment method includes the steps of comparing a data index existed in at least one table when a database inquires at least one query to obtain the data index correspondingly and directly uses the data index to search related data. If the query has no corresponding data index, a Where Condition field, a Sorting field and a Group By field of the query are recorded and integrated to automatically generate the newly established data index and fill the data index into the table correspondingly. Therefore, the database has intelligent functions with automatic analysis to automatically generate, update, and delete the data index, so as to achieve the effects of enhancing the accuracy and execution efficiency of the data management and reducing the manpower of data managers effectively.

## Claims

### Claim 1

An automatic data index establishment method, being a method for automatically generating at least one data index when a database executes related data of at least one query to expedite an inquiry of the related data and improve the execution performance, comprising the steps of:
receiving the query;
comparing the data index existed in at least one table;
using the data index existed in the table to search related data corresponding to the query directly, when the query correspondingly obtains the data index;
recording a Where Condition field, a Sorting field and a Group By field of the query, when the query has no corresponding data index; and
integrating the Where Condition field, the Sorting field and the Group By field to automatically generate a newly established data index, and filling the newly established data index into the table correspondingly.

### Claim 2 (depends on 1)

The automatic data index establishment method of claim 1, integrating the Where Condition field, the Sorting field and the Group By field is based comparing the data index with the Where Condition field, the Sorting field and the Group By field to generate the newly established data index.

### Claim 3 (depends on 2)

The automatic data index establishment method of claim 2, further comprising the steps of: recording an inquiry time of the query; and recording the table and an identification code of the data index, in the step of using the data index to search the query.

### Claim 4 (depends on 3)

The automatic data index establishment method of claim 3, further comprising the steps of: computing the inquiry time and the identification code to obtain an idle time of the data index; and comparing the idle time with a parameter value, and deleting the data index correspondingly if the idle time is greater than the parameter value, after the newly established data index is generated.

### Claim 5 (depends on 4)

The automatic data index establishment method of claim 4, wherein the database periodically analyzes the table to delete the data index.

### Claim 6 (depends on 5)

The automatic data index establishment method of claim 5, wherein the database is a cloud database.

### Claim 7 (depends on 6)

The automatic data index establishment method of claim 6, wherein the database supports a Structured Query Language (SQL).