Method and system for accessing distinct type data-base

A database and type of technology, applied in the database field, can solve problems such as inability to handle complex SQL statements, inability to integrate database systems, and difficulties

Active Publication Date: 2008-04-09
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF0 Cites 46 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] 1. Restrict the flexibility of using SQL: Object-oriented statements are fundamentally different from structured statements, and the current database systems are basically relational databases. This situation determines that object-oriented statements cannot be as flexible as structured statements. Integrates well with database systems
[0006] 2. It is difficult to describe complex SQL statements: developers submit object statements, but the generated SQL statements are structured statem

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 accessing distinct type data-base
  • Method and system for accessing distinct type data-base
  • Method and system for accessing distinct type data-base

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0057] In order to make the above objects, features and advantages of the present invention more comprehensible, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0058] Referring to Fig. 1, it shows a flow chart of a method for accessing different types of databases according to an embodiment of the present invention, including steps:

[0059] Step 101, receiving a general SQL statement irrelevant to the target database.

[0060] The present invention proposes a general SQL statement, that is, a KSQL statement, on the basis that different databases support different SQL grammars. The general SQL statement has its own syntax, which can conveniently describe various functions of the database, but it cannot be directly run on a specific target database. Therefore, the use of the general SQL statement can make the external application no longer care about the running database environment, whi...

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 accessing data bases of different types, which includes: receive a general SQL sentence independent of an objective data base; judge the type of the objective data base; according to the type of the objective data base, translate the general SQL sentence into the SQL sentence which is executed in the special objective data base; deliver the translated SQL sentence to the special objective data base. The method is able to screen the difference in the different data bases, and the application program does not need to care about the type of the running objective data base. The invention also provides a system for accessing the data bases of different types.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and system for accessing different types of databases. Background technique [0002] In addition to implementing standard SQL syntax, existing database products also support their own unique SQL syntax, which is not universal. For example: the following statement is supported in SQL SERVER: SELECT TOP 100*FROM t, but because the TOP keyword is not supported under DB2, this statement cannot be compiled and executed correctly and must be written as an equivalent statement: SELECT*FROM tFETCH FIRST 100 ROWS ONLY. It can be seen that the realization of the same function, that is, selecting the first 100 records from table t, can be realized in both SQL SERVER and DB2, but the way of realization, that is, the submitted query statement is not the same. Another example: DB2 supports the following statement: update t as t1... But this statement will report a syntax error when it is ex...

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 KINGDEE SOFTWARE(CHINA) CO LTD
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