Method and system for inquiring database with user defined function

A user-defined, database technology, applied in the database field, can solve problems such as difficult performance guarantee, high development cost, and NoSQL system cannot effectively provide support, and achieve the effect of improving data interaction performance

Inactive Publication Date: 2013-09-11
IBM CORP
View PDF3 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, NoSQL systems cannot provide effective support for relational queries involving one or more large-scale data tables. Usually, applications need a large number of targe...

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 and system for inquiring database with user defined function
  • Method and system for inquiring database with user defined function
  • Method and system for inquiring database with user defined function

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] Preferred embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although preferred embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.

[0017] figure 1 A block diagram of an exemplary computing system 100 suitable for implementing embodiments of the invention is shown. Such as figure 1 As shown, the computer system 100 may include: CPU (Central Processing Unit) 101, RAM (Random Access Memory) 102, ROM (Read Only Memory) 103, system bus 104, hard disk controller 105, keyboard controller 106, serial interface controller 107 , parallel interface controller 108 , display cont...

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 relates to a database, and discloses a method and a system for inquiring a database with a user defined function (UDF). The method includes steps as follows: detecting whether an instruction for calling a UDF transmission parameter value is received; starting a first interface of the UDF if the instruction for calling the UDF transmission parameter value is received; receiving the parameter value through the first interface; transmitting the received parameter value to an external data source; and returning and detecting whether an instruction for calling the UDF to transmit the parameter value is received. With the adoption of the method, data interactivity between a RDBMS (relational database management system) and a NoSQL (not only SQL) data source can be effectively improved.

Description

technical field [0001] Embodiments of the present invention generally relate to databases, and more specifically, relate to a method and system for querying databases using user-defined functions (UDFs). Background technique [0002] With the increase of data volume and the continuous change of user requirements, various NoSQL systems different from the traditional relational database management system (RDBMS) are constantly emerging. Unlike traditional relational databases that provide SQL structured queries and ACID (atomicity, consistency, isolation, and durability) guarantees, NoSQL systems do not use SQL as a query language, and their common features are non-relational data storage and simple APIs. , eventual consistency guarantee, and good horizontal scalability, which make the NoSQL system an ideal platform for solving big data storage and big data query analysis in the cloud computing platform. [0003] Existing NoSQL systems can well support simple queries for larg...

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): G06F9/46G06F17/30
CPCG06F16/284G06F16/25
Inventor 金毅李磊马春娥马丽丽
Owner IBM CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap