CN108399196A - The sql automatic execution methods and system of database sql sentence Auto-Generation Tools - Google Patents

The sql automatic execution methods and system of database sql sentence Auto-Generation Tools Download PDF

Info

Publication number
CN108399196A
CN108399196A CN201810087108.7A CN201810087108A CN108399196A CN 108399196 A CN108399196 A CN 108399196A CN 201810087108 A CN201810087108 A CN 201810087108A CN 108399196 A CN108399196 A CN 108399196A
Authority
CN
China
Prior art keywords
function
sql
database
auto
sql query
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.)
Granted
Application number
CN201810087108.7A
Other languages
Chinese (zh)
Other versions
CN108399196B (en
Inventor
吴游颖
林荫峰
蔡世平
方超
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Fujian Star Software Co Ltd
Original Assignee
Fujian Star Software Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Fujian Star Software Co Ltd filed Critical Fujian Star Software Co Ltd
Priority to CN201810087108.7A priority Critical patent/CN108399196B/en
Publication of CN108399196A publication Critical patent/CN108399196A/en
Application granted granted Critical
Publication of CN108399196B publication Critical patent/CN108399196B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages

Abstract

The present invention provides a kind of sql automatic execution methods of database sql sentence Auto-Generation Tools, by sql query statements Auto-Generation Tool and Database Connectivity;The table structural information of the table to be inquired and the function information of the built-in function of all supports are obtained from database;Sql query statement Auto-Generation Tools read in table structural information and function information, and generate sql query statements using random algorithm;Sql query statement Auto-Generation Tools call the interface function of connection database to execute sql query statements automatically, and the log generated in implementation procedure is output in real time in log files;After having executed sql query statements, programming count implementing result simultaneously exports.The present invention also provides the system corresponding to a kind of method, advantage of the present invention:So that the sql query statements that sql query statement Auto-Generation Tools are generated is run in the database automatically, linking link of the script between executing can be eliminated, save the testing time.

Description

The sql automatic execution methods and system of database sql sentence Auto-Generation Tools
Technical field
The present invention relates to database field, more particularly to a kind of sql of database sql sentence Auto-Generation Tools is held automatically Row method and system.
Background technology
Database (Database) be according to data structure come tissue, storage and manage data warehouse, it result from away from Before modern more than 60 years, after the development of information technology and market, especially nineteen nineties, data management is not It is only to store and manage data, and be transformed into the mode of the required various data managements of user again.
In recent years, with the development of big data, the type of database becomes more and more, sql grammers and application method Also different, the requirement to function and performance is also higher and higher.It is in test database work(that sql query statements, which automate Core Generator, A kind of tool often needed to use when energy and performance, still, existing database sql sentences Auto-Generation Tool is generating After sql script files, it is required for manually performing the sql script files of generation by tester, and can not also give birth in implementation procedure It at log and exports, therefore, not only testing efficiency is relatively low, but also inconvenient tester positions the position of bug.
Invention content
One of the technical problem to be solved in the present invention is to provide a kind of sql of database sql sentence Auto-Generation Tools Automatic execution method, the sql query statements for enabling sql query statement Auto-Generation Tools to be generated by this method exist automatically It is run in database, linking link of the script between executing can be eliminated, save the testing time.
The present invention is realized in one of technical problem:The sql of database sql sentence Auto-Generation Tools is executed automatically Method, described method includes following steps:
Step S1, by sql query statements Auto-Generation Tool and Database Connectivity;
Step S2, the letter of the table structural information of the table to be inquired and the built-in function of all supports is obtained from database Number information;
Step S3, sql query statements Auto-Generation Tool reads in table structural information and function information, and utilizes random algorithm Generate sql query statements;
Step S4, sql query statements Auto-Generation Tool calls the interface function of connection database to execute sql inquiries automatically Sentence, and the log generated in implementation procedure is output in real time in log files;
Step S5, after having executed sql query statements, programming count implementing result simultaneously exports.
Further, the step S1 is specially:By ODBC interconnection techniques by sql query statements Auto-Generation Tool with Database Connectivity.
Further, the step S2 is specially:
The type information of each row, obtains from database from the row name and table for obtaining the table to be inquired in database The number of parameters and parameters that function name, function return value type, the function of the built-in function of all supports include Type information;The built-in function of all supports includes operator, aggregate function, OLTP functions or OLAP function.
The second technical problem to be solved by the present invention is to provide a kind of sql of database sql sentence Auto-Generation Tools Automatic to execute system, the sql query statements for enabling sql query statement Auto-Generation Tools to be generated by the system exist automatically It is run in database, linking link of the script between executing can be eliminated, save the testing time.
The present invention is realized in the twos' of technical problem:The sql of database sql sentence Auto-Generation Tools is executed automatically System, the system comprises link block, data obtaining module, sentence generation module, automatic execution module and result statistics Module;
The link block is used for sql query statements Auto-Generation Tool and Database Connectivity;
Described information acquisition module, for obtaining the table structural information of the table to be inquired and all supports from database Built-in function function information;
The sentence generation module reads in table structural information and function information for sql query statement Auto-Generation Tools, And generate sql query statements using random algorithm;
The automatic execution module calls the interface function of connection database for sql query statement Auto-Generation Tools It is automatic to execute sql query statements, and the log generated in implementation procedure is output in real time in log files;
The result statistical module, after having executed sql query statements, programming count implementing result simultaneously exports.
Further, the link block is specially:By ODBC interconnection techniques by sql query statement Auto-Generation Tools With Database Connectivity.
Further, described information acquisition module is specially:
The type information of each row, obtains from database from the row name and table for obtaining the table to be inquired in database The number of parameters and parameters that function name, function return value type, the function of the built-in function of all supports include Type information;The built-in function of all supports includes operator, aggregate function, OLTP functions or OLAP function.
The invention has the advantages that:1, the side interacted with database by using sql query statements Auto-Generation Tool Formula makes the sql query statements that sql query statement Auto-Generation Tools are generated run in the database automatically, therefore, the present invention Linking link of the script between executing is eliminated, the testing time is saved;
2, log of the sql query statements for being generated Sql query statement Auto-Generation Tools in database implementation procedure Log files are output in real time, for the log information that operating personnel's real time inspection executes, and facilitate the position of positioning bug, simultaneously Can also real time inspection sql query statements implementation progress and executive condition;
3, after executing, programming count implementing result simultaneously exports, and the personnel that are convenient to operation have implementation effect more intuitive Understanding.
Description of the drawings
The present invention is further illustrated in conjunction with the embodiments with reference to the accompanying drawings.
Fig. 1 is the functional block diagram of the sql automatic execution methods of database sql sentence Auto-Generation Tools of the present invention.
Fig. 2 is to carry out matched functional block diagram to row and function in the present invention.
Specific implementation mode
Please emphasis refering to fig. 1 with shown in Fig. 2, the side of execution automatically the sql of database sql sentence Auto-Generation Tools of the present invention The preferred embodiment of method, described method includes following steps:
Step S1, by sql query statements Auto-Generation Tool and Database Connectivity;
The step S1 is specially:It is by ODBC interconnection techniques that sql query statements Auto-Generation Tool and database is mutual Even.
Step S2, the letter of the table structural information of the table to be inquired and the built-in function of all supports is obtained from database Number information;
The step S2 is specially:
The type information of each row, obtains from database from the row name and table for obtaining the table to be inquired in database The number of parameters and parameters that function name, function return value type, the function of the built-in function of all supports include Type information;The built-in function of all supports includes operator (such as plus sige, minus sign, equal sign, comma), aggregate function (such as MAX, MIN, SUM, AVG), OLTP functions or OLAP function.
In the specific implementation, it needs the table structural information that will be obtained to preserve into the first text file, the function of acquisition is believed Breath is preserved into the second text file;It is also desirable to the format of the first text file and the second text file be changed, so that first The format of text file and the second text file is consistent with the input format of sql query statement Auto-Generation Tools, that is, needs The first text file and the second text file are changed according to specified format, makes the defeated of sql query statement Auto-Generation Tools Enter and output obtains unification.
Step S3, sql query statements Auto-Generation Tool reads in table structural information and function information, and utilizes random algorithm Generate sql query statements;
In the specific implementation, sql query statements Auto-Generation Tool can first read the first text file and the second text text Part, and preserve the first text file and the second text file according to the format of regulation;Then, sql query statements automatically generate work Tool obtains the first text file and the second text file preserved, and by the type information of each row in the first text file and the The type information for the parameters that function return value type and built-in function in two text files are included is matched, and will The row and built-in function of type matching preserve, and the unmatched row of type and built-in function are then without preserving;It is calculated using random Method randomly selects the row of preservation and built-in function and automatically generates sql query statements;
Meanwhile sql query statements Auto-Generation Tool type information of each row and second in the first text file When the type information for the parameters that function return value type and built-in function in text file are included is matched, specifically Including:The type information of each row in first text file is compared with function return value type in the second text file Match, and if type matching, preserves row and function return value;If type mismatches, row and function return value are not preserved; By the class for the parameters that built-in function is included in the type information of each row in the first text file and the second text file Type information is compared matching, and if the parameters that the type information of each row is included with built-in function type information Equal Corresponding matching will then preserve in the corresponding parameter list of the type information of each row filling built-in function;It otherwise just will be each It is preserved in the corresponding parameter list of type information filling built-in function of row;
When specifically generating sql query statements, sql query statements Auto-Generation Tool randomly selects guarantor using random algorithm The row and built-in function deposited, and the row of type matching and function return value are generated into numeric ratio to (such as<,=,>Deng) first Sql inquiry clauses;The built-in function that row type information is filled in parameter list is generated into the 2nd sql inquiry clauses;Finally, sql is looked into It askes sentence Auto-Generation Tool the first sql inquiry clauses and the 2nd sql inquiry clauses are packaged together with other query statements, Automatically generate sql query statements.
Step S4, sql query statements Auto-Generation Tool calls the interface function of connection database to execute sql inquiries automatically Sentence, and the log generated in implementation procedure is output in real time in log files, in this way, operating personnel can real time inspection hold Capable log information, and facilitate the position of positioning bug, while can be with the implementation progress of real time inspection sql query statements and execution Situation.
Step S5, after having executed sql query statements, programming count implementing result simultaneously exports, including the number that runs succeeded, holds The various relevant informations such as the row frequency of failure, execution date, the rate that runs succeeded, the personnel that are convenient to operation have implementation effect more intuitive Understanding.
The sql of database sql sentence Auto-Generation Tools of the present invention executes the preferred embodiment of system, the system automatically Including link block, data obtaining module, sentence generation module, automatic execution module and result statistical module;
The link block is used for sql query statements Auto-Generation Tool and Database Connectivity;
The link block is specially:By ODBC interconnection techniques by sql query statements Auto-Generation Tool and database Interconnection.
Described information acquisition module, for obtaining the table structural information of the table to be inquired and all supports from database Built-in function function information;
Described information acquisition module is specially:
The type information of each row, obtains from database from the row name and table for obtaining the table to be inquired in database The number of parameters and parameters that function name, function return value type, the function of the built-in function of all supports include Type information;The built-in function of all supports includes operator (such as plus sige, minus sign, equal sign, comma), aggregate function (such as MAX, MIN, SUM, AVG), OLTP functions or OLAP function.
In the specific implementation, it needs the table structural information that will be obtained to preserve into the first text file, the function of acquisition is believed Breath is preserved into the second text file;It is also desirable to the format of the first text file and the second text file be changed, so that first The format of text file and the second text file is consistent with the input format of sql query statement Auto-Generation Tools, that is, needs The first text file and the second text file are changed according to specified format, makes the defeated of sql query statement Auto-Generation Tools Enter and output obtains unification.
The sentence generation module reads in table structural information and function information for sql query statement Auto-Generation Tools, And generate sql query statements using random algorithm;
In the specific implementation, sql query statements Auto-Generation Tool can first read the first text file and the second text text Part, and preserve the first text file and the second text file according to the format of regulation;Then, sql query statements automatically generate work Tool obtains the first text file and the second text file preserved, and by the type information of each row in the first text file and the The type information for the parameters that function return value type and built-in function in two text files are included is matched, and will The row and built-in function of type matching preserve, and the unmatched row of type and built-in function are then without preserving;It is calculated using random Method randomly selects the row of preservation and built-in function and automatically generates sql query statements;
Meanwhile sql query statements Auto-Generation Tool type information of each row and second in the first text file When the type information for the parameters that function return value type and built-in function in text file are included is matched, specifically Including:The type information of each row in first text file is compared with function return value type in the second text file Match, and if type matching, preserves row and function return value;If type mismatches, row and function return value are not preserved; By the class for the parameters that built-in function is included in the type information of each row in the first text file and the second text file Type information is compared matching, and if the parameters that the type information of each row is included with built-in function type information Equal Corresponding matching will then preserve in the corresponding parameter list of the type information of each row filling built-in function;It otherwise just will be each It is preserved in the corresponding parameter list of type information filling built-in function of row;
When specifically generating sql query statements, sql query statements Auto-Generation Tool randomly selects guarantor using random algorithm The row and built-in function deposited, and the row of type matching and function return value are generated into numeric ratio to (such as<,=,>Deng) first Sql inquiry clauses;The built-in function that row type information is filled in parameter list is generated into the 2nd sql inquiry clauses;Finally, sql is looked into It askes sentence Auto-Generation Tool the first sql inquiry clauses and the 2nd sql inquiry clauses are packaged together with other query statements, Automatically generate sql query statements.
The automatic execution module calls the interface function of connection database for sql query statement Auto-Generation Tools It is automatic to execute sql query statements, and the log generated in implementation procedure is output in real time in log files, in this way, operating personnel Can the log information that executes of real time inspection, and facilitate the position of positioning bug, while can be with real time inspection sql query statements Implementation progress and executive condition.
The result statistical module, after having executed sql query statements, programming count implementing result simultaneously exports, including Run succeeded the various relevant informations such as number, the execution frequency of failure, execution date, the rate that runs succeeded, and be convenient to operation personnel couple Implementation effect is understood more intuitively.
In conclusion the invention has the advantages that:1, by using sql query statements Auto-Generation Tool and database Interactive mode makes the sql query statements that sql query statement Auto-Generation Tools are generated run in the database automatically, because This, this invention removes linking link of the script between executing, and save the testing time;
2, log of the sql query statements for being generated Sql query statement Auto-Generation Tools in database implementation procedure Log files are output in real time, for the log information that operating personnel's real time inspection executes, and facilitate the position of positioning bug, simultaneously Can also real time inspection sql query statements implementation progress and executive condition;
3, after executing, programming count implementing result simultaneously exports, and the personnel that are convenient to operation have implementation effect more intuitive Understanding.
Although specific embodiments of the present invention have been described above, those familiar with the art should manage Solution, we are merely exemplary described specific embodiment, rather than for the restriction to the scope of the present invention, it is familiar with this The technical staff in field modification and variation equivalent made by the spirit according to the present invention, should all cover the present invention's In scope of the claimed protection.

Claims (6)

1. a kind of sql automatic execution methods of database sql sentence Auto-Generation Tools, it is characterised in that:The method includes Following steps:
Step S1, by sql query statements Auto-Generation Tool and Database Connectivity;
Step S2, the function letter of the table structural information of the table to be inquired and the built-in function of all supports is obtained from database Breath;
Step S3, sql query statements Auto-Generation Tool reads in table structural information and function information, and is generated using random algorithm Sql query statements;
Step S4, sql query statements Auto-Generation Tool calls the interface function of connection database to execute sql inquiry languages automatically Sentence, and the log generated in implementation procedure is output in real time in log files;
Step S5, after having executed sql query statements, programming count implementing result simultaneously exports.
2. the sql automatic execution methods of database sql sentence Auto-Generation Tools according to claim 1, feature exist In:The step S1 is specially:By ODBC interconnection techniques by sql query statements Auto-Generation Tool and Database Connectivity.
3. the sql automatic execution methods of database sql sentence Auto-Generation Tools according to claim 1, feature exist In:The step S2 is specially:
The type information of each row, obtains all from database from the row name and table for obtaining the table to be inquired in database The function name of the built-in function of support, the type of function return value type, the number of parameters that function includes and parameters Information;The built-in function of all supports includes operator, aggregate function, OLTP functions or OLAP function.
4. a kind of sql of database sql sentence Auto-Generation Tools executes system automatically, it is characterised in that:The system comprises Link block, data obtaining module, sentence generation module, automatic execution module and result statistical module;
The link block is used for sql query statements Auto-Generation Tool and Database Connectivity;
Described information acquisition module, for out of, table structural information and all supports that obtain the table to be inquired in database Set the function information of function;
The sentence generation module reads in table structural information and function information, and profit for sql query statement Auto-Generation Tools Sql query statements are generated with random algorithm;
The automatic execution module calls the interface function of connection database automatic for sql query statement Auto-Generation Tools Sql query statements are executed, and the log generated in implementation procedure is output in real time in log files;
The result statistical module, after having executed sql query statements, programming count implementing result simultaneously exports.
5. the sql of database sql sentence Auto-Generation Tools according to claim 4 executes system automatically, feature exists In:The link block is specially:By ODBC interconnection techniques by sql query statements Auto-Generation Tool and Database Connectivity.
6. the sql of database sql sentence Auto-Generation Tools according to claim 4 executes system automatically, feature exists In:Described information acquisition module is specially:
The type information of each row, obtains all from database from the row name and table for obtaining the table to be inquired in database The function name of the built-in function of support, the type of function return value type, the number of parameters that function includes and parameters Information;The built-in function of all supports includes operator, aggregate function, OLTP functions or OLAP function.
CN201810087108.7A 2018-01-30 2018-01-30 Automatic sql execution method and system of database sql statement automatic generation tool Active CN108399196B (en)

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 true CN108399196A (en) 2018-08-14
CN108399196B 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)

Cited By (2)

* Cited by examiner, † Cited by third party
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
CN116302211A (en) * 2023-05-22 2023-06-23 美云智数科技有限公司 Configuration method and device of policy executor, computer equipment and storage medium

Citations (7)

* Cited by examiner, † Cited by third party
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
US20070027904A1 (en) * 2005-06-24 2007-02-01 George Chow 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
EP1901180A1 (en) * 2006-09-07 2008-03-19 Research In Motion Limited System and method of generating databases
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

Patent Citations (7)

* Cited by examiner, † Cited by third party
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
US20070027904A1 (en) * 2005-06-24 2007-02-01 George Chow System and method for translating between relational database queries and multidimensional database queries
EP1901180A1 (en) * 2006-09-07 2008-03-19 Research In Motion Limited System and method of generating databases
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

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
丁祥武 等: "SQL测试用例集的自动生成", 《计算机应用与软件》 *

Cited By (3)

* Cited by examiner, † Cited by third party
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
CN116302211A (en) * 2023-05-22 2023-06-23 美云智数科技有限公司 Configuration method and device of policy executor, computer equipment and storage medium
CN116302211B (en) * 2023-05-22 2023-11-21 美云智数科技有限公司 Configuration method and device of policy executor, computer equipment and storage medium

Also Published As

Publication number Publication date
CN108399196B (en) 2022-07-29

Similar Documents

Publication Publication Date Title
CN108984712B (en) Service scene-based number making method and device and readable storage medium
US9009140B2 (en) Optimization of database query
US9037549B2 (en) System and method for testing data at a data warehouse
CN107402989A (en) The method and distributed NewSQL Database Systems that a kind of full-text search is established
CN102236672A (en) Method and device for importing data
CN101977121A (en) Configuration file processing method, device and system
CN110427188B (en) Configuration method, device, equipment and storage medium of single-test assertion program
US20140101097A1 (en) Template based database analyzer
CN111026670B (en) Test case generation method, test case generation device and storage medium
CN107943694A (en) A kind of test data generating method and device
CN109614315A (en) A kind of automatic generation method and system of data synchronism detection use-case
CN105760517A (en) Method and device for transferring data from Oracle database to DB2 database
CN108399196A (en) The sql automatic execution methods and system of database sql sentence Auto-Generation Tools
CN111291025B (en) Method for supporting multi-physical model conversion by logic model and storage device
CN115391142A (en) Database audit log generation method and system
CN111367893A (en) Method and device for database version iteration
CN111506594B (en) Big data query platform, management method thereof and data query method
CN116502273B (en) Dynamic data desensitization method, device and equipment based on data blood edges
CN112799966A (en) Method, system, equipment and medium for generating test data in batches by extensible plug-in
CN108388589A (en) A kind of device that database sql query statements automatically generate
CN108460092B (en) Automatic generation method and system for sql query statement containing database built-in function
CN112445867A (en) Intelligent analysis method and system for data relationship
CN115455091A (en) Data generation method and device, electronic equipment and storage medium
CN107273293B (en) Big data system performance test method and device and electronic equipment
CN114297961A (en) Chip test case processing method and related device

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
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.

GR01 Patent grant
GR01 Patent grant