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

Visiting method and device for relational database

A database and relational technology, applied in the database field, can solve problems such as high error rate, system performance loss, and high error correction cost, and achieve the effects of reducing error rate, fast and accurate access, and avoiding resource consumption

Active Publication Date: 2013-06-26
BEIJING FEINNO COMM TECH
View PDF2 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] The present invention provides a relational database access method and device to solve the problems of high error rate, high error correction cost and unnecessary loss of system performance in existing solutions for accessing relational databases

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
  • Visiting method and device for relational database
  • Visiting method and device for relational database
  • Visiting method and device for relational database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] In order to make the object, technical solution and advantages of the present invention clearer, the implementation manner of the present invention will be further described in detail below in conjunction with the accompanying drawings.

[0025] see figure 1 , is a relational database access method provided in Embodiment 1 of the present invention, the method comprising:

[0026] 11: Set service configuration information and data table configuration information, and establish a positioning array according to the selected access parameters, and the label of the array element in the positioning array indicates the position of the access parameter in the application business entity class.

[0027] In the embodiment of the present invention, the above access parameters are set according to the data columns in the data table, and the column names are set for the data columns in the data table, then the selected access parameters are the column names of the data columns. In ...

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 discloses a visiting method and a device for a relational database. The visiting method and the device for the relational database achieve a novel static mapping mechanism, are capable of quickly and accurately achieving the visit for a database, and reduce error rate in visit operation and cost consumptions in error correction. The visiting method for the relational database includes the following steps: setting service configuration information and data table configuration information, building a positioning array according to selected visiting parameters and the labels of array elements in the positioning array indicate the positions of the visiting parameters in an application service entity class, obtaining keyword information from the application service entity class, obtaining visiting expressions and the visiting parameters from the service configuration information according to the keyword information, obtaining the labels of the array elements from the data table configuration information according to the visiting parameters, finding numerical values of the visiting parameters from the entity class by using the labels, setting the numerical values of the visiting parameters into the visiting expressions, and executing the visiting expressions in the relational database.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a relational database access method and device. Background technique [0002] Relational databases are an integral part of most current information systems. Using a Java-based application system to access a relational database is a more common solution at present. This solution usually has the following two methods: [0003] The first way is to directly use Java Database Connectivity (JDBC) to access relational databases; the second way is to use open source projects (such as open source project iBatis, Hibernate, etc.) to access relational databases. [0004] There are at least the following defects in the above-mentioned existing solutions: [0005] In the first way, developers need to manually integrate the structured query language (Structured Query Language, SQL) statement to be executed into the program code, the error rate is high, and the cost of checking and elimina...

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): G06F17/30
Inventor 于剑池徐广鑫
Owner BEIJING FEINNO COMM TECH
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