Supercharge Your Innovation With Domain-Expert AI Agents!

Method and device for converting Script language to SQL language

A technology of conversion and language conversion, applied in the field of programming language conversion processing, can solve the problems of not supporting batch processing, inefficient computing, and not supporting complex business logic processing, etc., to achieve the effect of strong business processing capabilities

Inactive Publication Date: 2008-01-16
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF0 Cites 39 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this method can only perform inefficient calculations on the client side, and only obtains the value of one cell at a time, and cannot support batch processing; moreover, due to the limitations of the Script language, this method can only handle simple business logic , does not support the processing of complex business logic

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 device for converting Script language to SQL language
  • Method and device for converting Script language to SQL language
  • Method and device for converting Script language to SQL language

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0049] 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.

[0050] One of the core ideas of the embodiments of the present invention is to analyze the business rules defined in the Script language that need to be reflected in the database, parse out the grammatical elements and data processing logic, and complete the conversion from the Script language to the SQL statement by processing the conditional relationship , so that the system can execute SQL statements in specific databases to realize complex business logic processing and batch processing functions to obtain strong business processing capabilities.

[0051] With reference to Fig. 1, show a kind of flow chart of the method embodiment 1 that Script language is converted into SQL language of the present invention, specifically compri...

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 method for converting Script language into SQL language, including: obtaining business rules defined by Script language, the business rules are the data handling logic constituted by grammar factors; generating the configuration table of the grammar factors, which includes the grammar factors and corresponding configuration relationship; analyzing the business rules to procure the grammar factors and corresponding data handling logic; mobilizing the corresponding configuration relationship in the configuration table according to the grammar factor and data handling logic, and changing the business rules into SQL languages. The invention can implement SQL languages in concrete databases to realize logic treatment of complicated businesses and batch processing functions, so as to obtain rather powerful business handling capability.

Description

technical field [0001] The invention relates to the field of program language conversion processing, in particular to a method and a device for converting Script language reflected in a database into SQL language. Background technique [0002] Script language is a general term for a scripting programming language, including JavaScript, VBScript, Applet Script, Script, etc. It is mainly used to describe business rules and define the relationship between elements. SQL (Structured Query Language, Structured Query Language) is a database query and programming language for accessing data and querying, updating and managing relational database systems. SQL is an advanced non-procedural programming language that allows users to Work on high-level data structures. It is not necessary for the user to specify the storage method of the data, nor does the user need to know the specific data storage method, so different database systems with completely different underlying structures ca...

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
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com