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

Data interaction method and interaction device based on postgreSQL client PSQL

A data interaction and client-side technology, applied in the field of data interaction, can solve problems such as excessively increasing work input, achieve the effect of reducing learning costs and improving efficiency

Active Publication Date: 2021-06-15
HIGHGO SOFTWARE
View PDF4 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Because PSQL is not compatible with the PL / SQL syntax in Oracle, the migration of applications from Oracle to PostgreSQL becomes difficult, which increases the work input

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
  • Data interaction method and interaction device based on postgreSQL client PSQL
  • Data interaction method and interaction device based on postgreSQL client PSQL
  • Data interaction method and interaction device based on postgreSQL client PSQL

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0053] In order to further explain the technical means and functions adopted by the present invention to achieve the intended purpose, the present invention will be described in detail below in conjunction with the accompanying drawings and preferred embodiments.

[0054] Firstly, related concepts involved in the present invention are introduced.

[0055] SQL statements are divided into basic SQL and extended SQL (PL / SQL), which are introduced as follows:

[0056] SQL: SQL is a structured query language, which is closer to natural language. Using SQL, you only need to say what to do, not how to do it. It is composed of data definition language, data manipulation language, and data control language. It is not process-oriented, that is, the previous statement has nothing to do with the next statement. SQL is the standard language.

[0057]PL / SQL: PL / SQL (Procedural Language / SQL) is an extension of SQL, which absorbs many of the highest design features of programming languages ...

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 data interaction method and device based on a postgreSQL client PSQL. The method comprises the steps of: juding whether a data definition statement is a PL / SQL object data definition statement or not; when the data definition statement is not the PL / SQL object data definition statement, analyzing the data definition statement according to SQL grammar; when the data definition statement is a PL / SQL object data definition statement, judging whether the PL / SQL object data definition statement is a PostgreSQL grammar statement or an Oracle grammar statement; if the data definition statement is a PostgreSQL grammar statement, analyzing the data definition statement according to a preset grammar of the PostgreSQL; if the data definition statement is an Oracle grammar statement, analyzing the data definition statement according to a preset grammar of Oracle; and sending the analyzed data definition statement to a database. According to the data interaction method based on the POstgreSQL client PSQL, the grammar difference between the POstgreSQL and the Oracle can be correctly filtered, and smooth compatibility and automatic switching of the two grammar modes are achieved. And moreover, the learning cost of a PostgreSQL user can be reduced, and the application migration efficiency is improved.

Description

technical field [0001] The invention relates to the technical field of data interaction, in particular to a data interaction method and an interaction device based on a postgreSQL client PSQL. Background technique [0002] PSQL is a command-line interactive client tool in PostgreSQL, which allows interactive input of SQL commands and sends complete SQL commands to the PostgreSQL server. [0003] Existing PSQL has an inherent rule when users need to input functions or stored procedures in PL / SQL syntax in interactive mode, that is, dollar signs or single quotation marks must be used to wrap PL procedure blocks. Because PSQL is not compatible with the PL / SQL syntax in Oracle, the migration of applications from Oracle to PostgreSQL becomes difficult, which increases the workload. Contents of the invention [0004] The technical problem to be solved by the present invention is how to improve the compatibility of PSQL to different syntax data. The present invention proposes a ...

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): G06F16/242G06F40/253
CPCG06F16/2433G06F40/253
Inventor 兰柯苗健卢健
Owner HIGHGO SOFTWARE
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