Unlock instant, AI-driven research and patent intelligence for your innovation.

Supports association query of mixed data types and query extension method of fuzzy grouping

A technology of mixed data and query expansion, which is applied in the direction of electronic digital data processing, digital data information retrieval, special data processing applications, etc., and can solve the problems of limited query functions and inability to support mixed types of data query operations, etc.

Active Publication Date: 2019-09-27
DONGHUA UNIV
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, due to the limited query function of the current SQL statement, it cannot support the most commonly used query operations such as connection and grouping of mixed types of data.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Supports association query of mixed data types and query extension method of fuzzy grouping

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0051] In order to make the present invention more comprehensible, preferred embodiments are described in detail as follows.

[0052] The invention provides a method for realizing fuzzy connection of mixed data types and fuzzy grouping of specified data types by extending SQL statements. Aiming at the problem that mixed data in a distributed database environment cannot be connected through certain rules and the functional limitations of specified types of data aggregation operations, the invention provides users with SQL extended syntax for aggregation and connection, enabling users to complete fuzzy grouping and fuzzy grouping through specified statements. The method of query expansion such as connection expands the functionality and adaptability of the distributed database. Taking MYSQL and MONGODB as the underlying node database as an example, the specific steps are as follows:

[0053] Step 1, architecture construction, using MYCAT as the database middleware, building a d...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a query expansion method supporting correlated query and fuzzy grouping of a mixed data type. The query expansion method comprises the following steps of: S1, architecture construction; S2, data storage; S3, query expansion; S4, query parsing; S5, mixed connection; S6, fuzzy grouping; S7, result packaging and returning. Aiming at the problems that in a distributed database environment, mixed types of data cannot be connected by a certain rules and designated types of data is limited to an aggregation operation function, the invention provides an aggregation and connection SQL (Structured Query Language) expansion syntax for a user, so that the user can complete the query expansion method comprising fuzzy grouping, fuzzy connection and the like by designated statements. Functionality and adaptability of a distributed database are expanded.

Description

technical field [0001] The invention relates to a mixed type data query method supporting fuzzy connection and fuzzy grouping. Background technique [0002] With the rapid development of computer and information technology and the increasing popularization of applications in various industries, data of hundreds of terabytes or even tens to hundreds of petabytes are generated and collected every day. Traditional database technologies, especially centralized databases, pose enormous challenges. In order to provide distributed support for the widely used open source centralized databases such as MYSQL and PostGreSQL, a series of database middleware emerged as the times require. These middleware provide users with transparent solutions for building database clusters, and can smoothly integrate existing Stand-alone centralized databases and applications are migrated to the "cloud", becoming an important distributed data management solution. At the same time, distributed databas...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/2453G06F16/242
Inventor 黄晓虎王杰薛皓王梅
Owner DONGHUA UNIV