Database construction system, device and method

A technology for establishing methods and databases, applied in the field of databases, can solve the problems of inconvenient development and maintenance, high risk of errors, and reduced R&D efficiency.

Inactive Publication Date: 2014-07-09
FUJIAN STAR NET EVIDEO INFORMATION SYST CO LTD
View PDF3 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, engineers need to manually write multiple SQL statements according to different products when developing database systems, which will bring great inconvenience to development and maintenance, reduce research and development efficiency and increase the risk of errors

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
  • Database construction system, device and method
  • Database construction system, device and method
  • Database construction system, device and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] In order to describe the technical content, structural features, achieved goals and effects of the present invention in detail, the following will be described in detail in conjunction with the embodiments and accompanying drawings.

[0029] Structured Query Language (Structured Query Language) referred to as SQL, Structured Query Language is a database query and programming language for accessing data and querying, updating and managing relational database systems; it is also the extension of database script files.

[0030] In the prior art, common database types usually include Derby, Pgsql, Oracle and Sybase, each of which will be briefly introduced below.

[0031] Derby is a database written entirely in java, which is an Open source product and distributed based on Apache License 2.0. Derby is very small, and the core part of derby.jar is only 2M, so it can be used as a separate database server or embedded in an application program.

[0032] Pgsql, an object-relati...

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 database construction system which is run in a compiling system and used for executing compiling and access to a database. The database construction system comprises a receiving unit, a judging unit and a translating unit. The receiving unit is used for receiving a universal initialization SQL statement of a database. The judging unit is used for judging the type of a target database. The translating unit is used for compiling character strings in different languages according to key values of the initialization SQL statement of the database and generating SQL statements executed in the target database according to the initialization SQL statement of the database and the key value character strings. The invention further provides a database construction method and device. By means of the database construction system, device and method, the SQL statements adapting to various types of databases and languages can be generated according to the universal SQL statement for initialization of data of the database, so that the initialization SQL statement is easy to maintain, and the risk that errors are generated in the maintenance process is reduced.

Description

technical field [0001] The invention relates to the field of databases, in particular to a system, device and method for establishing a database. Background technique [0002] In addition to implementing standard SQL syntax, existing database products also support their own unique SQL syntax, which are not universal. For example, the following statement is supported in SQL Server: SELECT TOP100*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 t FETCH FIRST100ROWS ONLY. It can be seen that to achieve the same function, that is, select 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. Therefore, engineers need to manually write multiple SQL statements according to different products when developing database systems, which will bring ...

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
CPCG06F16/21
Inventor 黄建阳游磊青
Owner FUJIAN STAR NET EVIDEO INFORMATION SYST 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