CN108399196B - Automatic sql execution method and system of database sql statement automatic generation tool - Google Patents
Automatic sql execution method and system of database sql statement automatic generation tool Download PDFInfo
- Publication number
- CN108399196B CN108399196B CN201810087108.7A CN201810087108A CN108399196B CN 108399196 B CN108399196 B CN 108399196B CN 201810087108 A CN201810087108 A CN 201810087108A CN 108399196 B CN108399196 B CN 108399196B
- Authority
- CN
- China
- Prior art keywords
- text file
- sql query
- function
- database
- execution
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Debugging And Monitoring (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Stored Programmes (AREA)
Abstract
The invention provides an sql automatic execution method of an sql statement automatic generation tool of a database, which interconnects the sql query statement automatic generation tool and the database; acquiring table structure information of a table to be inquired and function information of all supported built-in functions from a database; reading in table structure information and function information by an sql query statement automatic generation tool, and generating an sql query statement by using a random algorithm; the sql query statement automatic generation tool calls an interface function connected with the database to automatically execute the sql query statement, and outputs a log generated in the execution process to a log file in real time; and after the sql query statement is executed, automatically counting an execution result and outputting the result. The invention also provides a system corresponding to the method, and the method has the advantages that: the sql query statement generated by the automatic sql query statement generation tool can automatically run in the database, so that a link from a script to execution can be eliminated, and the test time is saved.
Description
Technical Field
The invention relates to the field of databases, in particular to an sql automatic execution method and system of an sql statement automatic generation tool of a database.
Background
Databases (databases) are warehouses that organize, store, and manage data according to data structures, which have evolved over sixty years ago, and with the development of information technology and markets, particularly after the nineties of the twentieth century, data management has no longer been the only way to store and manage data, and has transformed into the various ways of data management that users need.
In recent years, with the development of big data, the types of databases become more and more, the syntax and the usage method of sql are different, and the requirements on functions and performances are higher and higher. The sql query statement automatic generation tool is a tool which is often used when testing functions and performances of a database, but after an existing database sql statement automatic generation tool generates an sql script file, a tester needs to manually execute the generated sql script file, and a log cannot be generated and output in an execution process, so that not only is testing efficiency low, but also the tester is inconvenient to locate the position of a bug.
Disclosure of Invention
One of the technical problems to be solved by the present invention is to provide an sql automatic execution method for an sql statement automatic generation tool in a database, by which sql query statements generated by the sql query statement automatic generation tool can automatically run in the database, thereby eliminating a link from a script to execution and saving test time.
The invention realizes one of the technical problems as follows: an sql automatic execution method of an automatic database sql statement generation tool, the method comprising the steps of:
step S1, interconnecting the sql query statement automatic generation tool with a database;
step S2, obtaining the table structure information of the table to be inquired and the function information of all supported built-in functions from the database;
step S3, reading in table structure information and function information by an sql query statement automatic generation tool, and generating sql query statements by a random algorithm;
step S4, the sql query sentence automatic generation tool calls an interface function connected with the database to automatically execute sql query sentences, and the log generated in the execution process is output to the log file in real time;
and step S5, automatically counting the execution result and outputting the result after the sql query statement is executed.
Further, the step S1 is specifically: and interconnecting the sql query statement automatic generation tool with the database through an ODBC connection technology.
Further, the step S2 is specifically:
acquiring the column name of a table to be inquired and the type information of each column in the table from a database, and acquiring the function names, function return value types, the number of parameters contained in the functions and the type information of each parameter of all supported built-in functions from the database; the all supported built-in functions include operators, aggregation functions, OLTP functions, or OLAP functions.
The second technical problem to be solved by the present invention is to provide an sql automatic execution system of an sql sentence automatic generation tool for a database, which enables sql query sentences generated by the sql query sentence automatic generation tool to automatically run in the database, thereby eliminating a link from a script to execution and saving test time.
The invention realizes the second technical problem in the following way: the system comprises a connection module, an information acquisition module, a statement generation module, an automatic execution module and a result statistics module;
the connection module is used for interconnecting an sql query statement automatic generation tool with a database;
the information acquisition module is used for acquiring the table structure information of the table to be inquired and the function information of all supported built-in functions from the database;
the statement generation module is used for automatically generating an sql query statement tool to read in table structure information and function information and generating the sql query statement by using a random algorithm;
the automatic execution module is used for calling an interface function connected with a database by an sql query sentence automatic generation tool to automatically execute the sql query sentence and outputting a log generated in the execution process to a log file in real time;
And the result counting module is used for automatically counting and outputting the execution result after the sql query statement is executed.
Further, the connection module specifically includes: and interconnecting the sql query statement automatic generation tool with the database through an ODBC connection technology.
Further, the information acquisition module specifically includes:
acquiring the column name of a table to be inquired and the type information of each column in the table from a database, and acquiring the function names, function return value types, the number of parameters contained in the functions and the type information of each parameter of all supported built-in functions from the database; the all supported built-in functions include operators, aggregation functions, OLTP functions, or OLAP functions.
The invention has the following advantages: 1. by utilizing the interaction mode of the sql query statement automatic generation tool and the database, the sql query statement generated by the sql query statement automatic generation tool automatically runs in the database, so that the invention eliminates the link from the script to the execution and saves the test time;
2. log of the Sql query statement generated by the automatic Sql query statement generation tool in the database execution process is output to a log file in real time, so that an operator can check executed log information in real time, the position of a bug is convenient to locate, and the execution progress and the execution condition of the Sql query statement can be checked in real time;
3. After the execution is finished, the execution result is automatically counted and output, so that the operator can know the execution effect more visually.
Drawings
The invention will be further described with reference to the following examples with reference to the accompanying drawings.
FIG. 1 is a schematic block diagram of an sql automatic execution method of the database sql statement automatic generation tool of the present invention.
FIG. 2 is a schematic block diagram of matching columns to functions in the present invention.
Detailed Description
Referring to fig. 1 and fig. 2, the preferred embodiment of the sql automatic execution method of the database sql statement automatic generation tool of the present invention includes the following steps:
step S1, interconnecting the sql query statement automatic generation tool with a database;
the step S1 specifically includes: and interconnecting the sql query statement automatic generation tool with the database through an ODBC connection technology.
Step S2, obtaining the table structure information of the table to be inquired and the function information of all supported built-in functions from the database;
the step S2 specifically includes:
acquiring the column name of a table to be inquired and the type information of each column in the table from a database, and acquiring the function names, function return value types, the number of parameters contained in the functions and the type information of each parameter of all supported built-in functions from the database; the built-in functions supported include operators (e.g., plus, minus, equal, comma, etc.), aggregation functions (e.g., MAX, MIN, SUM, AVG, etc.), OLTP functions, or OLAP functions.
In specific implementation, the acquired table structure information needs to be saved into a first text file, and the acquired function information needs to be saved into a second text file; meanwhile, the formats of the first text file and the second text file are required to be modified so that the formats of the first text file and the second text file conform to the input format of the sql query sentence automatic generation tool, that is, the first text file and the second text file are required to be modified according to the specified format, so that the input and the output of the sql query sentence automatic generation tool are unified.
Step S3, reading in table structure information and function information by an sql query statement automatic generation tool, and generating sql query statements by a random algorithm;
in specific implementation, the automatic sql query sentence generation tool reads the first text file and the second text file first, and stores the first text file and the second text file according to a specified format; then, an sql query sentence automatic generation tool acquires a first text file and a second text file which are stored, matches the type information of each column in the first text file with the function return value type in the second text file and the type information of each parameter contained in a built-in function, stores the column with the matched type and the built-in function, and does not store the column with the unmatched type and the built-in function; randomly selecting the stored columns and built-in functions by using a random algorithm and automatically generating sql query sentences;
Meanwhile, when the automatic sql query statement generation tool matches the type information of each column in the first text file with the function return value type in the second text file and the type information of each parameter contained in the built-in function, the method specifically includes: comparing and matching the type information of each column in the first text file with the type of the function return value in the second text file, and if the types are matched, saving the column and the function return value; if the types do not match, the column and function return values are not saved; comparing and matching the type information of each column in the first text file with the type information of each parameter contained in a built-in function in the second text file, and filling the type information of each column into a parameter table corresponding to the built-in function for storage if the type information of each column is correspondingly matched with the type information of each parameter contained in the built-in function; otherwise, not filling the type information of each column into the parameter table corresponding to the built-in function for storage;
when an sql query statement is generated specifically, the automatic sql query statement generation tool selects the stored columns and built-in functions randomly by using a random algorithm, and generates a first sql query clause with a numerical value comparison (such as <, >, and the like) by returning the columns and the functions with matched types; generating a second sql query clause by using a built-in function filled with column type information in the parameter table; and finally, the sql query sentence automatic generation tool packages the first sql query clause and the second sql query clause with other query sentences to automatically generate the sql query sentence.
And S4, calling an interface function connected with the database by the automatic sql query sentence generation tool to automatically execute the sql query sentence, and outputting the log generated in the execution process to the log file in real time, so that an operator can check the executed log information in real time, conveniently locate the position of the bug, and check the execution progress and the execution condition of the sql query sentence in real time.
And step S5, after the sql query sentence is executed, automatically counting and outputting an execution result, wherein the execution result comprises various related information such as execution success times, execution failure times, execution date, execution success rate and the like, and operators can conveniently and visually know the execution effect.
The invention discloses a preferred embodiment of an sql automatic execution system of an sql statement automatic generation tool, which comprises a connection module, an information acquisition module, a statement generation module, an automatic execution module and a result statistics module;
the connection module is used for interconnecting an sql query statement automatic generation tool with a database;
the connecting module specifically comprises: and interconnecting the sql query statement automatic generation tool with the database through an ODBC connection technology.
The information acquisition module is used for acquiring the table structure information of the table to be inquired and the function information of all supported built-in functions from the database;
The information acquisition module specifically comprises:
acquiring the column name of a table to be inquired and the type information of each column in the table from a database, and acquiring the function names, function return value types, the number of parameters contained in the functions and the type information of each parameter of all supported built-in functions from the database; the built-in functions supported include operators (e.g., plus, minus, equal, comma, etc.), aggregation functions (e.g., MAX, MIN, SUM, AVG, etc.), OLTP functions, or OLAP functions.
In specific implementation, the acquired table structure information needs to be saved into a first text file, and the acquired function information needs to be saved into a second text file; meanwhile, the formats of the first text file and the second text file are required to be modified so that the formats of the first text file and the second text file conform to the input format of the sql query sentence automatic generation tool, that is, the first text file and the second text file are required to be modified according to the specified format, so that the input and the output of the sql query sentence automatic generation tool are unified.
The statement generation module is used for automatically generating an sql query statement tool to read in table structure information and function information and generating the sql query statement by using a random algorithm;
In specific implementation, the automatic sql query sentence generation tool reads the first text file and the second text file first, and stores the first text file and the second text file according to a specified format; then, an sql query sentence automatic generation tool acquires a first text file and a second text file which are stored, matches the type information of each column in the first text file with the function return value type in the second text file and the type information of each parameter contained in a built-in function, stores the column with the matched type and the built-in function, and does not store the column with the unmatched type and the built-in function; randomly selecting the stored columns and built-in functions by using a random algorithm and automatically generating sql query sentences;
meanwhile, when the automatic sql query statement generation tool matches the type information of each column in the first text file with the function return value type in the second text file and the type information of each parameter contained in the built-in function, the method specifically includes: comparing and matching the type information of each column in the first text file with the type of the function return value in the second text file, and if the types are matched, saving the column and the function return value; if the types do not match, the column and function return values are not saved; comparing and matching the type information of each column in the first text file with the type information of each parameter contained in a built-in function in the second text file, and filling the type information of each column into a parameter table corresponding to the built-in function for storage if the type information of each column is correspondingly matched with the type information of each parameter contained in the built-in function; otherwise, not filling the type information of each column into the parameter table corresponding to the built-in function for storage;
When an sql query statement is generated specifically, the automatic sql query statement generation tool selects the stored columns and built-in functions randomly by using a random algorithm, and generates a first sql query clause with a numerical value comparison (such as <, >, and the like) by returning the columns and the functions with matched types; generating a second sql query clause by using a built-in function filled with column type information in the parameter table; and finally, the sql query sentence automatic generation tool packages the first sql query clause and the second sql query clause with other query sentences to automatically generate the sql query sentence.
The automatic execution module is used for calling an interface function connected with a database by an sql query sentence automatic generation tool to automatically execute the sql query sentence and outputting a log generated in the execution process to a log file in real time, so that an operator can check the executed log information in real time, the position of a bug is convenient to locate, and the execution progress and the execution condition of the sql query sentence can be checked in real time.
The result counting module is used for automatically counting and outputting execution results after the sql query sentence is executed, wherein the execution results comprise various related information such as execution success times, execution failure times, execution dates and execution success rates, and operators can conveniently and visually know the execution effect.
In summary, the invention has the following advantages: 1. by utilizing the interaction mode of the sql query statement automatic generation tool and the database, the sql query statement generated by the sql query statement automatic generation tool automatically runs in the database, so that the invention eliminates the link from the script to the execution and saves the test time;
2. log of the Sql query statement generated by the automatic Sql query statement generation tool in the database execution process is output to a log file in real time, so that an operator can check executed log information in real time, the position of a bug is convenient to locate, and the execution progress and the execution condition of the Sql query statement can be checked in real time;
3. after the execution is finished, the execution result is automatically counted and output, so that the operator can know the execution effect more visually.
Although specific embodiments of the invention have been described above, it will be understood by those skilled in the art that the specific embodiments described are illustrative only and are not limiting upon the scope of the invention, and that equivalent modifications and variations can be made by those skilled in the art without departing from the spirit of the invention, which is to be limited only by the appended claims.
Claims (2)
1. An sql automatic execution method of an sql statement automatic generation tool of a database is characterized in that: the method comprises the following steps:
step S1, interconnecting the sql query statement automatic generation tool and the database through an ODBC connection technology;
step S2, obtaining the table structure information of the table to be inquired and the function information of all supported built-in functions from the database;
step S3, reading in table structure information and function information by an sql query statement automatic generation tool, and generating sql query statements by a random algorithm;
step S4, the sql query sentence automatic generation tool calls an interface function connected with the database to automatically execute sql query sentences, and the log generated in the execution process is output to the log file in real time;
step S5, automatically counting and outputting the execution result after the sql query statement is executed;
the step S2 specifically includes:
acquiring the column name of a table to be inquired and the type information of each column in the table from a database, and acquiring the function names, function return value types, the number of parameters contained in the functions and the type information of each parameter of all supported built-in functions from the database; all supported built-in functions comprise an operator, an aggregation function, an OLTP function or an OLAP function; storing the acquired table structure information into a first text file, and storing the acquired function information into a second text file; meanwhile, the formats of the first text file and the second text file are modified so that the formats of the first text file and the second text file accord with the input format of the sql query statement automatic generation tool;
The step S3 specifically includes:
the automatic sql query sentence generating tool reads the first text file and the second text file first and stores the first text file and the second text file according to a specified format; then, an sql query sentence automatic generation tool acquires a first text file and a second text file which are stored, matches the type information of each column in the first text file with the function return value type in the second text file and the type information of each parameter contained in a built-in function, stores the column with the matched type and the built-in function, and does not store the column with the unmatched type and the built-in function; randomly selecting the stored columns and built-in functions by using a random algorithm and automatically generating sql query sentences;
in step S5, the execution result includes the number of execution success times, the number of execution failure times, the execution date, and the execution success rate.
2. An sql automatic execution system of an sql statement automatic generation tool of a database, characterized in that: the system comprises a connection module, an information acquisition module, a statement generation module, an automatic execution module and a result statistics module;
the connecting module is used for interconnecting the sql query statement automatic generation tool with the database through an ODBC connecting technology;
The information acquisition module is used for acquiring the table structure information of the table to be inquired and the function information of all supported built-in functions from the database;
the statement generation module is used for automatically generating an sql query statement tool to read in table structure information and function information and generating the sql query statement by using a random algorithm;
the automatic execution module is used for calling an interface function connected with a database by an sql query sentence automatic generation tool to automatically execute the sql query sentence and outputting a log generated in the execution process to a log file in real time;
the result counting module is used for automatically counting and outputting the execution result after the sql query statement is executed;
the information acquisition module specifically comprises:
acquiring the column name of a table to be inquired and the type information of each column in the table from a database, and acquiring the function names, function return value types, the number of parameters contained in the functions and the type information of each parameter of all supported built-in functions from the database; all supported built-in functions comprise an operator, an aggregation function, an OLTP function or an OLAP function; storing the acquired table structure information into a first text file, and storing the acquired function information into a second text file; meanwhile, the formats of the first text file and the second text file are modified so that the formats of the first text file and the second text file accord with the input format of the sql query statement automatic generation tool;
The statement generation module is specifically as follows: the automatic sql query sentence generating tool reads the first text file and the second text file first and stores the first text file and the second text file according to a specified format; then, an sql query sentence automatic generation tool acquires a first text file and a second text file which are stored, matches the type information of each column in the first text file with the function return value type in the second text file and the type information of each parameter contained in a built-in function, stores the column and the built-in function of which the types are matched, and does not store the column and the built-in function of which the types are not matched; randomly selecting the stored columns and built-in functions by using a random algorithm and automatically generating sql query sentences;
in the result counting module, the execution result includes the execution success times, the execution failure times, the execution date and the execution success rate.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810087108.7A CN108399196B (en) | 2018-01-30 | 2018-01-30 | Automatic sql execution method and system of database sql statement automatic generation tool |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810087108.7A CN108399196B (en) | 2018-01-30 | 2018-01-30 | Automatic sql execution method and system of database sql statement automatic generation tool |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108399196A CN108399196A (en) | 2018-08-14 |
| CN108399196B true CN108399196B (en) | 2022-07-29 |
Family
ID=63095154
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810087108.7A Active CN108399196B (en) | 2018-01-30 | 2018-01-30 | Automatic sql execution method and system of database sql statement automatic generation tool |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108399196B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113961588A (en) * | 2021-10-27 | 2022-01-21 | 北京科杰科技有限公司 | Big data SQL program design method based on configurable parameters |
| CN116302211B (en) * | 2023-05-22 | 2023-11-21 | 美云智数科技有限公司 | Configuration method and device of policy executor, computer equipment and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6115704A (en) * | 1991-09-27 | 2000-09-05 | Bmc Software, Inc. | Extended SQL change definition language for a computer database system |
| EP1901180A1 (en) * | 2006-09-07 | 2008-03-19 | Research In Motion Limited | System and method of generating databases |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2006136025A1 (en) * | 2005-06-24 | 2006-12-28 | Orbital Technologies Inc. | System and method for translating between relational database queries and multidimensional database queries |
| CN101105814A (en) * | 2007-09-11 | 2008-01-16 | 金蝶软件（中国）有限公司 | Method and device for converting Script language to SQL language |
| CN101464862A (en) * | 2007-12-21 | 2009-06-24 | 英业达股份有限公司 | SQL generating system and method |
| CN106919678A (en) * | 2017-02-27 | 2017-07-04 | 武汉珞佳伟业科技有限公司 | A kind of database inquiry optimization system and method |
| CN107562955A (en) * | 2017-09-30 | 2018-01-09 | 北京酷我科技有限公司 | A kind of rapid generation of SQL statement |
-
2018
- 2018-01-30 CN CN201810087108.7A patent/CN108399196B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6115704A (en) * | 1991-09-27 | 2000-09-05 | Bmc Software, Inc. | Extended SQL change definition language for a computer database system |
| EP1901180A1 (en) * | 2006-09-07 | 2008-03-19 | Research In Motion Limited | System and method of generating databases |
Non-Patent Citations (1)
| Title |
|---|
| SQL测试用例集的自动生成;丁祥武 等;《计算机应用与软件》;20120815;第29卷(第08期);185-189+199 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108399196A (en) | 2018-08-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108519967B (en) | Chart visualization method and device, terminal and storage medium | |
| US9009140B2 (en) | Optimization of database query | |
| US8738607B2 (en) | Extracting portions of an abstract database for problem determination | |
| CN109254907B (en) | Java-based interface test report generation method and system | |
| CN109241384B (en) | Scientific research information visualization method and device | |
| CN108399196B (en) | Automatic sql execution method and system of database sql statement automatic generation tool | |
| US11934361B2 (en) | Automatic generation of a data model from a structured query language (SQL) statement | |
| CN112988782A (en) | Hive-supported interactive query method and device and storage medium | |
| CN112231407A (en) | DDL synchronization method, device, equipment and medium of PostgreSQL database | |
| CN108388589B (en) | Device for automatically generating sql query statement of database | |
| CN108460092B (en) | Automatic generation method and system for sql query statement containing database built-in function | |
| CN103064780A (en) | Software testing method and device thereof | |
| CN111506594B (en) | Big data query platform, management method thereof and data query method | |
| CN113703777A (en) | Code generation method and device based on database table, storage medium and equipment | |
| CN107273293B (en) | Big data system performance test method and device and electronic equipment | |
| CN112445867A (en) | Intelligent analysis method and system for data relationship | |
| US20190303467A1 (en) | Data aggregation data structure | |
| WO2023086322A1 (en) | Late materialization of queried data in database cache | |
| CN109977104B (en) | Data management method and device | |
| CN114328577A (en) | Data query method and device | |
| CN108153916B (en) | Method for realizing automatic generation tool of database sql query statement by using random algorithm | |
| CN112905558A (en) | Report system implementation method and system based on database configuration | |
| CN108388588B (en) | Database function offline reading method and system of sql statement automatic generation tool | |
| CN111723104A (en) | Method, device and system for syntax analysis in data processing system | |
| CN117648339B (en) | Data exploration method and device, server and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 350000 21 / F, building 5, f District, Fuzhou Software Park, 89 software Avenue, Gulou District, Fuzhou City, Fujian Province Applicant after: FUJIAN SINOREGAL SOFTWARE CO.,LTD. Address before: Floor 20-21, building 5, area F, Fuzhou Software Park, 89 software Avenue, Gulou District, Fuzhou City, Fujian Province 350000 Applicant before: FUJIAN SINOREGAL SOFTWARE CO.,LTD. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |