Supercharge Your Innovation With Domain-Expert AI Agents!

Method for supporting function of calling specific functions of middleware database through simple SQL

A database and middleware technology, applied in the fields of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of inability to directly call the unique functions of different types of underlying nodes, high cost, and high user threshold

Active Publication Date: 2017-02-15
DONGHUA UNIV
View PDF3 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, currently in distributed database middleware, it is impossible to directly call the unique functions of different types of underlying nodes
If the user wants to call it, it needs to be implemented through programming, which is usually expensive and has a high threshold for the user

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
  • Method for supporting function of calling specific functions of middleware database through simple SQL

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

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

[0039] The present invention provides a method for supporting specific functions of middleware databases through simple SQL calls. The present invention aims at the distributed database environment where multiple heterogeneous databases coexist, and users cannot operate and specify the specific execution of NoSQL databases in a simple manner through a unified platform. The way is to provide users with simple SQL-like statements, so that they can directly call the MongDB node database to specify the MapReduce function through the intermediate platform MYCAT, which improves the flexibility of the distributed database and provides common users with the use of database-specific functions. Provides a convenient way. Taking the count operation of MapReduce under MongDB as an example, the specific operation steps are:

[0040] Step 1. Build the architecture,...

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 method for supporting a function of calling specific functions of a middleware database through a simple SQL. The method is characterized in that users have the highly customizable performance and the operation simplification on database functions. The method comprises the following steps of: (1), setting up an architecture; (2), creating an index file; (3), storing data in different databases; (4), querying and expanding; (5), querying and analyzing; (6), performing routing binding and distributing; (7), executing the method; and (8), packaging a result, and returning. By means of the method disclosed by the invention, in a distributed database environment, for specific functions of various node databases, users can realize unified calling through an intermediate management platform only by using simple SQL-like statements.

Description

technical field [0001] The invention relates to a method for invoking the special function of the underlying heterogeneous database in the distributed database middleware. Background technique [0002] With the rapid development of computer and information technology and the increasing popularization of applications in various industries, human beings have entered the era of big data. The "4V" characteristics of massive data and heterogeneity of big data have brought great challenges to traditional database technology. In order to make up for the shortcomings of relational databases in dealing with big data, various non-relational databases have emerged. Non-relational databases have their own unique advantages in one or more aspects on the premise of realizing basic functions. For example, MongDB supports file storage in terms of storage types, and natively supports operations such as MapReduce and Aggregation Pipeline in terms of functions. On the other hand, with the rap...

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
IPC IPC(8): G06F17/30
Inventor 王杰黄晓虎王梅
Owner DONGHUA UNIV
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com