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

Information processing method and device

An information processing method and grammar technology, applied in the field of database, can solve the problems of increasing the cost of secondary development or upgrade of developers and taking a long time, and achieve the effect of improving development efficiency and saving analysis time.

Active Publication Date: 2014-12-10
SHENZHEN TENCENT COMP SYST CO LTD
View PDF4 Cites 37 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, in practical applications, existing systems always have implemented SQL codes (or called SQL texts), but not necessarily corresponding data flow diagrams. If the secondary development of the system is required through data flow diagrams Or upgrade, it is necessary to manually analyze the SQL code of the system to obtain the data flow diagram. For large and complex systems, obtaining the data flow diagram will take a long time, which increases the cost of secondary development or upgrade for developers

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
  • Information processing method and device
  • Information processing method and device
  • Information processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0081] The inventor found in the process of implementing the present invention that in practical applications, existing systems always have implemented SQL codes (or called SQL texts), but do not necessarily have corresponding data flow diagrams. Secondary development or upgrade of the system in the form of flow diagram requires manual analysis of SQL to obtain the data flow diagram. The cost of first development or upgrade; the inventor also found in the process of implementing the present invention that SQL codes can be divided into several basic elements (consisting of character strings) including: SQL instruction, SQL operator, column name (some in the data table The name of a column of data, such as area, person name, etc.), table name (namely the name of the data table), data (such as integer, floating point number, etc.); if the basic elements of the SQL code can be identified based on the strings in the SQL code, And further analyze the SQL grammatical relationship bet...

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 embodiment of the invention discloses an information processing method and device. The method comprises the steps that the basic elements of SQL codes are recognized based on a first strategy; the basic elements analyzed from the SQL codes are subjected to combination operation, SQL sentences are obtained, and a syntax tree is established; the SQL sentences in the syntax tree are subjected to traversal, based on the types of the basic elements in the SQL sentences obtained after traversal and the corresponding relationship of the types of the basic elements and nodes, nodes are correspondingly established for the basic elements in the SQL sentences obtained after traversal, and the intermediary language description of the syntax tree is obtained; and based on the intermediary language description of the syntax tree, a data flow diagram corresponding to the SQL codes is established. According to the technical scheme of the embodiment, the corresponding data flow diagram can be obtained quickly and accurately based on the SQL codes, developing personnel can carry out secondary development or upgrading on a system conveniently based on the data flow diagram, and implementation cost is lowered.

Description

technical field [0001] The invention relates to database technology, in particular to an information processing method and device. Background technique [0002] SQL is a standard computer language for accessing and processing databases. SQL supports accessing and processing data in database systems. Such databases include: Oracle, Sybase, SQL Server, DB2, and Access; in practical applications, development using SQL Design work often uses the tool of data flow diagram. Data flow diagram (DFD, Data Flow Diagram) is a graphical representation of data flow. Data flow is a workflow (also called pipeline) dedicated to data manipulation. Data flow Contains multiple nodes executed sequentially (each node is a conversion of data), the data flow usually starts with the source conversion and ends with the target conversion, with the help of the data flow graph, developers can conveniently and intuitively implement the SQL If the system is modified and upgraded, the difficulty of syste...

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
CPCG06F8/31G06F16/2433
Inventor 刘德志赵明明刘飚彭涯费强邓建威陈宁国陈静
Owner SHENZHEN TENCENT COMP SYST CO LTD
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