Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Container framework for user-defined functions

A container and function technology, applied in the field of database systems, can solve the problems of consuming computing resources, destroying data, disabling databases, etc.

Pending Publication Date: 2021-02-26
GOPIVOTAL
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Although some databases can handle user-defined functions, doing so can be inefficient
That is, executing a user-defined function consumes a disproportionate amount of computing resources, such as memory or processing power, disrupting the normal operation of the database for other users, relative to executing a query written in the main query language
Also, user-defined functions may not have been thoroughly tested and may contain malicious code that disables the database or corrupts 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
  • Container framework for user-defined functions
  • Container framework for user-defined functions
  • Container framework for user-defined functions

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0066] Embodiment 1 is a method, comprising:

[0067] receiving a query written in a main query language by a distributed database system installed on a cloud computing platform, wherein the query invokes a user-defined function;

[0068] allocating one or more master segment hosts hosted on the cloud computing platform to process one or more portions of the query written in the master query language;

[0069] allocating one or more first containers to handle calls to user-defined functions in the query;

[0070] providing, by the one or more primary segment hosts, the user-defined function and one or more parameters in the call to the user-defined function to a process assigned to process the user-defined function said one or more first containers of said invocation;

[0071] executing, by said one or more first containers assigned to process said calls to said user-defined functions, said user-defined The function;

[0072] receiving, by the one or more primary segment h...

Embodiment 2

[0075] Embodiment 2 is the method of embodiment 1, wherein allocating the first container to handle the call to the user-defined function comprises:

[0076] The first container is selected from a pool of available containers.

Embodiment 3

[0077] Embodiment 3 is the method described in embodiment 2, further comprising:

[0078] After providing the primary segment host with an initial result of executing the call to the user-defined function, releasing the first container into the pool of available containers.

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

Methods, systems, and computer programs encoded on computer storage media, for processing user-defined functions in containers. One example system receives a query written in a primary query languagethat calls a user-defined function. The system assigns primary segment hosts to process portions of the query written in the primary query language and assigns first containers to process the call tothe user-defined function. The primary segment hosts provide to the first containers the user-defined function and one or more arguments in the call to the user-defined function. The first containersexecute the user-defined function. The primary segment hosts receive an initial result of the call to the user-defined function computed by the first containers. The primary segment hosts compute a final result of the query using the initial result. The primary segment hosts provide the final result of the query in response to receiving the query.

Description

Background technique [0001] This specification relates to database systems. [0002] A database organizes data into tables with columns and rows. A unique key identifies every row in every table. A particular row represents an instance of a particular entity, and the columns in that row store the values ​​attributed to that instance. A row in one table can be linked to a row in the other table by including a column in one of the two tables that links the rows with a unique key. [0003] A database can be divided into segments. Segments are queried by corresponding segment instances, which are computer programs executed by physical or virtual computing nodes called segment nodes. Each segment node has its own storage and processing capabilities. Under the direction of the host, each segment instance can handle a portion of queries from clients. The host can collect the results from each segment instance and return the final results to the client. [0004] Users can write...

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 Applications(China)
IPC IPC(8): G06F16/245
CPCG06F16/245G06F16/2471G06F16/27G06F16/2457G06F9/5077G06F9/5083G06F2209/5011G06F2209/503G06F16/2448
Inventor 王淏舟吴疆郭罡白少琦张桓
Owner GOPIVOTAL
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

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