CN107656867A - A kind of method and apparatus of database and Compatibility of Operating System authentication test - Google Patents
A kind of method and apparatus of database and Compatibility of Operating System authentication test Download PDFInfo
- Publication number
- CN107656867A CN107656867A CN201710826996.5A CN201710826996A CN107656867A CN 107656867 A CN107656867 A CN 107656867A CN 201710826996 A CN201710826996 A CN 201710826996A CN 107656867 A CN107656867 A CN 107656867A
- Authority
- CN
- China
- Prior art keywords
- test
- function
- database
- installation
- management
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
-
- 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/21—Design, administration or maintenance of databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides the method and apparatus of a kind of database and Compatibility of Operating System authentication test.This method includes:The installation scenario test of database is carried out, the installation scenario in the installation scenario test includes order line installation, graphical installation and silent installation;System information test is carried out, the system information test includes database Sanity testing and operating system statistical test;Function Test Automation is carried out, the Function Test Automation is that the function of database is tested by operation function automatic test script;And the test result according to installation scenario test, system information test and the Function Test Automation, determine whether database is compatible with operating system.The method of database provided by the invention and Compatibility of Operating System authentication test, suitable for all databases and the compatible authentication test of (SuSE) Linux OS, there is ease for use, portability.
Description
Technical field
The present invention relates to software testing technology field, particularly a kind of database and Compatibility of Operating System authentication test
Method and apparatus.
Background technology
With the continuous growth of data scale and business scale, database technology fast development is got up, high availability requirement
More and more higher.Core business system of the database as data center, function is stronger and stronger, performance requirement also more and more higher.
For operating system manufacturer, how effectively, specification, comprehensively verification operation system and the compatibility of database
It is more and more important.
The content of the invention
In view of the above problems, it is proposed that the present invention so as to provide one kind overcome above mentioned problem or at least in part solve on
State the database of problem and the method for Compatibility of Operating System authentication test and corresponding device.
According to an aspect of of the present present invention, there is provided a kind of method of database and Compatibility of Operating System authentication test, bag
Include:
Carry out the installation scenario test of database, the installation scenario in installation scenario test include order line installation,
Graphical installation and silent installation;
System information test is carried out, the system information test includes database Sanity testing and operating system statistics is surveyed
Examination;
Function Test Automation is carried out, the Function Test Automation is by operation function automatic test script logarithm
Tested according to the function in storehouse;And
According to the test knot of installation scenario test, system information test and the Function Test Automation
Fruit, determine whether database is compatible with operating system.
Alternatively, if database is data-base cluster, methods described also includes:
Pressure test is carried out, the pressure test is to perform test using pressure test instrument;
The test of reliable and High Availabitity is carried out, the test scene of the reliable and High Availabitity test includes the survey of clustered software
Examination, stability test, storage management software test, cluster file system test and the test stored;
It is described according to the installation scenario test, the system information test and the Function Test Automation test
As a result, determine that the database step whether compatible with operating system includes:
According to installation scenario test, system information test, the Function Test Automation, the pressure test
And the test result of the reliable and High Availabitity test, determine whether database is compatible with operating system.
Alternatively, the step of installation scenario for carrying out database is tested specifically includes:Checked before installation, installation data
Storehouse, checked after checking installation log, installation;
Checked before installation, specifically run the script for inspection before installing, check test node hostname, database
User and user's group, configuration file, network interface information, required lib bags, total internal memory and free memory, swap spaces, available disk sky
Between, system architecture, kernel version, kernel parameter, and record check export;Wherein, the script for being checked before installing is being run
Before, according to inspection database user and user's group, required lib bags in the requirement custom-written script of database;
The step of then proceeding by installation database after passing through is checked before installation, according to each database in installation process
Setup Type carries out splitting different installation scenarios, and records installation log corresponding to different installation scenarios;
Enter the step of checking installation log after installation, installation log corresponding to different installation scenarios is examined
Look into, and record check exports;
The step of installation log checks after then being installed without mistake, after installing DB, default service is to start,
After installation check be check database service whether normal operation, the script for being checked after installation is specifically run, according to number
Modified according to the service state viewing command in storehouse, and record check exports.
Alternatively, update is also included if database is single instance database, the step of installation scenario test;
The specific step of update is to install the database software of lowest version, from lowest version database upgrade to current version
Originally, check installation log, check database positioning.
Alternatively, the database Sanity testing creates database and logged in and manages particular by modification database parameter
Platform;The operating system statistical test checks operating system phase particular by sql sentences and system command is performed
Close information.
Alternatively, the Function Test Automation operation function automatic test script, is specifically transported using database sql
Row instrument runs sql orders;
The function of the database includes:The function of table management, the function of view management, the function of Constraints Management, storage
The function of process management, the function of trigger management, the function of user management, the function of partition table management, the work(of index management
One or more in energy, the function of tablespace management, the function of Role Management.
Alternatively, the function of the table management includes:Create table, modification table name, modification field name and type, addition
Field, the table structure defining operation for deleting field, the selection and modification of data type, check editor's data, supports conditions selection
Inquiry data are gone forward side by side edlin modification, Table Properties and dependence query;
The function of the view management includes:Create, delete view, check, change view definition, check viewdata,
Supports conditions are inquired about, view properties and its dependence query, establishment, modification, the deletion of Materialized View, the inquiry of Materialized View;
The function of the Constraints Management includes:Constraint definition and modification, constrain cascade function, constraint enables, disables control
System;
The function of the storing process management includes:Create, edit and storage process, delete storing process, compiling stored
Journey;
The function of the trigger management includes:Create, editor's trigger, delete trigger, compile trigger;
The function of the user management includes:User is created, role, permission grant to user delete user, and modification is used
Family configuration information;
The function of the partition table management includes:Create the division table, changes partition table, deletes subregion table function, if carry
For a variety of partition methods, the partition method includes range partition, hash subregion, list partition, compound subregion;
The function of the index management includes:Create, modification index information, index defines type selecting, there is provided effective
Index restructuring and deletion;
The function of the tablespace management includes:The definition of table space, table space modification, table space are deleted;
The function of the Role Management includes:Create role, to role add and delete authority, the distribution of role and return
Receive, role's enabling and disabling.
Alternatively, if database is data-base cluster, the function of the database also includes:The related function of cluster;
The related function of the cluster includes:The function of clustered node management, the function of cluster unified query, cluster are unified
The function of management.
Alternatively, the test of the clustered software includes:Private network failure, public network failure, node failure, high availability;It is private
The test of net failure is successively to pull out the main private network of host node and secondary private network, while pulls out the main private network of host node and secondary private network,
Pull out successively host node main private network and secondary private network until cluster only remain a node, private network interchanger power-off;Public network failure
Test is successively to pull out the public and private net of host node and secondary private network, while pulls out Your Majesty's net of host node and secondary private network;Node failure
Test be host node power-off, host node restarts;The test of high availability is to kill the process of cluster service, while stops two
Node, restart after node exits, stop cluster;
The stability test is to be specified first in duration, is run incessantly under high pressure, wherein, high pressure refers to
CPU usage is more than 90%, input/output port and the utilization rate of network is more than 70%;During operation when second specifies
Long record CPU, internal memory, the resource service condition of network and the running status of cluster;
The storage management software test includes:Kill the process of storage management software, storage disk failure and addition
Machine is restarted during disk;
The cluster file system test includes:The cluster process of at least two nodes is killed, disk interrupts, input and output
Port interrupts, extend file system space;
The test of the storage includes:Fiber failure, HBA card failures and input/output port interrupt;Fiber failure
Test is to pull out the main fiber line of host node, pulls out all optical fiber cables of host node, pull out successively host node main fiber line and
Secondary optical fiber cable only remains a node until cluster;The test of HBA card failures be disable host node bonded HBA cards in one,
Disable bonded HBA cards;The test that input/output port interrupts is to interrupt datafile files, interrupts disk access, is interrupted
redo。
Foundation another aspect of the present invention, additionally provide the dress of a kind of database and Compatibility of Operating System authentication test
Put, including:
Installation scenario test module, the installation scenario for carrying out database are tested, the peace in the installation scenario test
Filling scene includes order line installation, graphical installation and silent installation;
System information test module, for carrying out system information test, the system information test includes database and perfected
Test and operating system statistical test;
Function Test Automation module, for carrying out Function Test Automation, the Function Test Automation is to pass through fortune
Row Function Test Automation script is tested the function of database;And
Determining module, for being automated according to installation scenario test, system information test and the function
The test result of test, determine whether database is compatible with operating system.
Alternatively, described device also includes:
Pressure test module, for carrying out pressure test, the pressure test is to perform test using pressure test instrument;
Reliable and High Availabitity test module, for carrying out the test of reliable and High Availabitity, the reliable and High Availabitity test
Test of the test scene including clustered software, stability test, storage management software test, cluster file system are tested and deposited
The test of storage;
The determining module, it is additionally operable to automatic according to installation scenario test, system information test, the function
Change the test result of test, the pressure test and the reliable and High Availabitity test, determine that database is with operating system
No compatibility.
Alternatively, the installation scenario test module is additionally operable to inspection, installation database, inspection before the installation of progress database
Checked after looking into installation log, installation;
Checked before installation, specifically run the script for inspection before installing, check test node hostname, database
User and user's group, configuration file, network interface information, required lib bags, total internal memory and free memory, swap spaces, available disk sky
Between, system architecture, kernel version, kernel parameter, and record check export;Wherein, the script for being checked before installing is being run
Before, according to inspection database user and user's group, required lib bags in the requirement custom-written script of database;
The step of then proceeding by installation database after passing through is checked before installation, according to each database in installation process
Setup Type carries out splitting different installation scenarios, and records installation log corresponding to different installation scenarios;
Enter the step of checking installation log after installation, installation log corresponding to different installation scenarios is examined
Look into, and record check exports;
The step of installation log checks after then being installed without mistake, after installing DB, default service is to start,
After installation check be check database service whether normal operation, the script for being checked after installation is specifically run, according to number
Modified according to the service state viewing command in storehouse, and record check exports.
Alternatively, if database is single instance database, the installation scenario test module is additionally operable to carry out database
Update;
The specific step of update is to install the database software of lowest version, from lowest version database upgrade to current version
Originally, check installation log, check database positioning.
Alternatively, the database Sanity testing creates database and logged in and manages particular by modification database parameter
Platform;The operating system statistical test checks operating system phase particular by sql sentences and system command is performed
Close information.
Alternatively, the Function Test Automation module operation function automatic test script is specifically to use database
Sql running tools run sql orders;
The function of the database includes:The function of table management, the function of view management, the function of Constraints Management, storage
The function of process management, the function of trigger management, the function of user management, the function of partition table management, the work(of index management
One or more in energy, the function of tablespace management, the function of Role Management.
Alternatively, the function of the table management includes:Create table, modification table name, modification field name and type, addition
Field, the table structure defining operation for deleting field, the selection and modification of data type, check editor's data, supports conditions selection
Inquiry data are gone forward side by side edlin modification, Table Properties and dependence query;
The function of the view management includes:Create, delete view, check, change view definition, check viewdata,
Supports conditions are inquired about, view properties and its dependence query, establishment, modification, the deletion of Materialized View, the inquiry of Materialized View;
The function of the Constraints Management includes:Constraint definition and modification, constrain cascade function, constraint enables, disables control
System;
The function of the storing process management includes:Create, edit and storage process, delete storing process, compiling stored
Journey;
The function of the trigger management includes:Create, editor's trigger, delete trigger, compile trigger;
The function of the user management includes:User is created, role, permission grant to user delete user, and modification is used
Family configuration information;
The function of the partition table management includes:Create the division table, changes partition table, deletes subregion table function, if carry
For a variety of partition methods, the partition method includes range partition, hash subregion, list partition, compound subregion;
The function of the index management includes:Create, modification index information, index defines type selecting, there is provided effective
Index restructuring and deletion;
The function of the tablespace management includes:The definition of table space, table space modification, table space are deleted;
The function of the Role Management includes:Create role, to role add and delete authority, the distribution of role and return
Receive, role's enabling and disabling.
Alternatively, if database is data-base cluster, the function of the database also includes:The related function of cluster;
The related function of the cluster includes:The function of clustered node management, the function of cluster unified query, cluster are unified
The function of management.
Alternatively, the test of the clustered software includes:Private network failure, public network failure, node failure, high availability;It is private
The test of net failure is successively to pull out the main private network of host node and secondary private network, while pulls out the main private network of host node and secondary private network,
Pull out successively host node main private network and secondary private network until cluster only remain a node, private network interchanger power-off;Public network failure
Test is successively to pull out the public and private net of host node and secondary private network, while pulls out Your Majesty's net of host node and secondary private network;Node failure
Test be host node power-off, host node restarts;The test of high availability is to kill the process of cluster service, while stops two
Node, restart after node exits, stop cluster;
The stability test is to be specified first in duration, is run incessantly under high pressure, wherein, high pressure refers to
CPU usage is more than 90%, input/output port and the utilization rate of network is more than 70%;During operation when second specifies
Long record CPU, internal memory, the resource service condition of network and the running status of cluster;
The storage management software test includes:Kill the process of storage management software, storage disk failure and addition
Machine is restarted during disk;
The cluster file system test includes:The cluster process of at least two nodes is killed, disk interrupts, input and output
Port interrupts, extend file system space;
The test of the storage includes:Fiber failure, HBA card failures and input/output port interrupt;Fiber failure
Test is to pull out the main fiber line of host node, pulls out all optical fiber cables of host node, pull out successively host node main fiber line and
Secondary optical fiber cable only remains a node until cluster;The test of HBA card failures be disable host node bonded HBA cards in one,
Disable bonded HBA cards;The test that input/output port interrupts is to interrupt datafile files, interrupts disk access, is interrupted
redo。
The method and apparatus of database provided in an embodiment of the present invention and Compatibility of Operating System authentication test, suitable for institute
There is the compatible authentication test of database and (SuSE) Linux OS, there is ease for use, portability;Contain in installation scenario test
More comprehensive installation scenario has been covered, has ensured the normative, comprehensive of test;Function Test Automation part then contain compared with
For comprehensive function point, and realize that script automates, improve testing efficiency, ensured easy durability, expansibility and easy dimension
Shield property.
Also, reliable and high availability part of detecting carrys out the reliable and High Availabitity of validation database cluster from every aspect
Property, ensure the reliability and high availability of cluster.
Described above is only the general introduction of technical solution of the present invention, in order to better understand the technological means of the present invention,
And can be practiced according to the content of specification, and in order to allow above and other objects of the present invention, feature and advantage can
Become apparent, below especially exemplified by the embodiment of the present invention.
According to the accompanying drawings will be brighter to the detailed description of the specific embodiment of the invention, those skilled in the art
Above-mentioned and other purposes, the advantages and features of the present invention.
Brief description of the drawings
By reading the detailed description of hereafter preferred embodiment, it is various other the advantages of and benefit it is common for this area
Technical staff will be clear understanding.Accompanying drawing is only used for showing the purpose of preferred embodiment, and is not considered as to the present invention
Limitation.And in whole accompanying drawing, identical part is denoted by the same reference numerals.In the accompanying drawings:
Fig. 1 shows database according to an embodiment of the invention and the stream of the method for Compatibility of Operating System authentication test
Cheng Tu;
Fig. 2 shows database according to another embodiment of the present invention and the method for Compatibility of Operating System authentication test
Flow chart;
Fig. 3 shows the schematic diagram of the installation scenario test of progress database according to an embodiment of the invention;
Fig. 4 shows the schematic diagram of the function of database according to an embodiment of the invention;
Fig. 5 shows reliable and High Availabitity test block diagram according to an embodiment of the invention;
Fig. 6 shows the knot of database according to an embodiment of the invention and the device of Compatibility of Operating System authentication test
Structure schematic diagram;And
Fig. 7 shows database according to another embodiment of the present invention and the device of Compatibility of Operating System authentication test
Structural representation.
Embodiment
The exemplary embodiment of the disclosure is more fully described below with reference to accompanying drawings.Although the disclosure is shown in accompanying drawing
Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure without should be by embodiments set forth here
Limited.On the contrary, these embodiments are provided to facilitate a more thoroughly understanding of the present invention, and can be by the scope of the present disclosure
Completely it is communicated to those skilled in the art.
In order to solve the above-mentioned technical problem, the embodiments of the invention provide a kind of database and Compatibility of Operating System certification
The method of test, this method are applied to the compatible authentication test of all databases and (SuSE) Linux OS, have ease for use,
It is portable.As shown in figure 1, the method for database and Compatibility of Operating System authentication test comprises the following steps S102 extremely
S108。
Step S102, the installation scenario test of database is carried out, wherein, the installation scenario in installation scenario test includes life
The installation of order row, graphical installation and silent installation.
Step S104, system information test is carried out, wherein, system information test includes database Sanity testing and operation is
System statistical test.
In this step, database Sanity testing creates database and logged in and manages particular by modification database parameter
Platform;Operating system statistical test is particular by execution sql (structured querylanguage, structuralized query
Language) sentence and system command check operating system relevant information.
Step S106, Function Test Automation is carried out, wherein, Function Test Automation is to automate to survey by operation function
This function to database of training is tested.
Step S108, tested according to installation scenario, system information test and Function Test Automation test result, really
It is whether compatible with operating system to determine database.
In this step, if the test result of installation scenario test, system information test and Function Test Automation is equal
To pass through test, it is determined that database is compatible with operating system;If installation scenario test, system information test and function are automatic
Change any one in the test result of test not pass through test, it is determined that database is incompatible with operating system.
More comprehensive installation scenario is covered in the installation scenario test of above-described embodiment, has ensured the specification of test
It is property, comprehensive;Function Test Automation part then contains more comprehensive function point, and realizes that script automates, and improves
Testing efficiency, easy durability, expansibility and ease for maintenance are ensured.
The present embodiments relate to operating system in addition to it can be (SuSE) Linux OS, can also be other operations
System, such as Unix operating systems, the invention is not limited in this regard.
In the alternative embodiment of the present invention, if database is data-base cluster, as shown in Fig. 2 except above-mentioned steps
Beyond S102 to S106, the method for database provided in an embodiment of the present invention and Compatibility of Operating System authentication test can also wrap
Include step S202 to S206.
Step S202, pressure test is carried out, wherein, pressure test is to perform test using pressure test instrument.
In this step, Benchmark Factory for Database instruments can be used on pressure test.
Benchmark Factory are a kind of ripe, reliable, high scalability and wieldy testing tool.Support a variety of data
Storehouse type, for example, Oracle, SQL Server, DB2, Mysql, ODBC source database (such as Basesoft Information Tech. Co., Ltd. KingbaseDB, up to dream
Database D ameng, magic database Oscar) etc..This instrument also supports a variety of benchmark, such as TPC-C, TPC-H, TPC-B etc.,
In this authentication method, TPC-C benchmark can be used.
Step S204, the test of reliable and High Availabitity is carried out, wherein, the test scene of reliable and High Availabitity test includes cluster
Test, stability test, storage management software test, cluster file system test and the test stored of software.
Step S206, tested according to installation scenario, system information test, Function Test Automation, pressure test and can
Lean on and High Availabitity test test result, determine whether database compatible with operating system.
In this step, if installation scenario test, system information test, Function Test Automation, pressure test and can
Lean on and the test result of High Availabitity test is to pass through test, it is determined that database is compatible with operating system;If installation scenario is surveyed
It is any one in the test result that examination, system information test, Function Test Automation, pressure test and reliable and High Availabitity are tested
Individual is not pass through test, it is determined that database is incompatible with operating system.
The reliable and high availability part of detecting of above-described embodiment from every aspect come the reliable of validation database cluster and
High availability, ensure the reliability and high availability of cluster.
As shown in figure 3, the step of installation scenario test of database is carried out in above step S102 can specifically include:Peace
Checked before dress after inspection, installation database, inspection installation log, installation etc..That is, the order line installation in installation scenario (a), figure
Shapeization is installed and the execution step of silent installation, can will be situated between in detail below as shown in (b) installation scenario flow in Fig. 3
The content for each step that continues.
Checked before installation, specifically run the script for inspection before installing, check test node hostname, database
User and user's group, configuration file, network interface information, required lib bags, total internal memory and free memory, swap spaces, available disk sky
Between, system architecture, kernel version, kernel parameter, and record check export;Wherein, the script for being checked before installing is being run
Before, according to inspection database user and user's group, required lib bags in the requirement custom-written script of database;
The step of then proceeding by installation database after passing through is checked before installation, according to each database in installation process
Setup Type carries out splitting different installation scenarios, and records installation log corresponding to different installation scenarios;
Enter the step of checking installation log after installation, installation log corresponding to different installation scenarios is examined
Look into, and record check exports;
The step of installation log checks after then being installed without mistake, after installing DB, default service is to start,
After installation check be check database service whether normal operation, the script for being checked after installation is specifically run, according to number
Modified according to the service state viewing command in storehouse, and record check exports.
In the process of implementation, each installation scenario is required for the examination & verification of (SuSE) Linux OS tester, it is necessary to provides field
Scape exports and corresponding document.Documentation requirements is as follows:
1) journal file.Correct installation log file need to be preserved for evaluation.
2) precondition validation check exports.Required installation premise calls must all are fulfilled for, and are run into installation process
Prerequisite inspection cannot unsuccessfully receive, it is necessary to ensure that solve all prerequisites before the mounting.
3) output is checked after installing.All outputs checked after installation need to be provided.
It can be recorded for the inspection output that foregoing is directed to using script programs.
By taking graphical installation scenario as an example, script (script) program record is as follows:
$script/install/graphical_install_1.script
Script started,file is/install/graphical_install_1.script
$sh precheck.sh
$exit
Script done,file is/install/graphical_install_1.script
It is that installation is preceding first to check, runs the script precheck.sh for inspection before installing, mainly check test node
Hostname (hostname is the Hostname for showing or setting system), database user and user's group, configuration file,
Network interface information, required lib bags, total internal memory and free memory, swap spaces (i.e. swapace), free disk space, system tray
Structure, kernel version, kernel parameter, and record check output, etc..Before the operation of precheck.sh scripts, for being checked in script
Database user and user's group and required lib bags, should write according to the requirement of database to be customized.
Checked before installation and then proceed by installation database after passing through, then needed according to each database in installation process
Setup Type carries out splitting multiple installation scenarios, can equally be recorded for order line installation and silent installation using script
The whole process of installation is for examination & verification.
The step of checking installation log is put into after installation, it is necessary to ensure just to can guarantee that without mistake in installation log
The follow-up normal operation of software, installation log are then carried out in next step without mistake.
After installing DB, default service is to start.Checked after installation and mainly check whether database service is normal
Operation.Postcheck.sh needs to be modified according to the service state viewing command of database.When running postcheck.sh
Script is needed to use to be recorded.
Inspection after the installation namely postcheck.sh that has no problem is run successfully, and the result of return is success, then pacifies
Dress terminates.
In the alternative embodiment of the present invention, for single instance database, also need to upgrade in installation scenario test
Installation, mainly includes following four step for update:1) database software of lowest version is installed;2) from lowest version data
Storehouse is upgraded to current version;3) installation log is checked;4) database positioning is checked.
For in database and (SuSE) Linux OS compatibility authentication test, it is important that a part be function automation
Test.In the alternative embodiment of the present invention, Function Test Automation operation function automatic test pin in above-mentioned steps S106
This, specifically runs sql orders using database sql running tools.As shown in figure 4, the function of database here can be with
Including:The function of table management, the function of view management, the function of Constraints Management, the function of storing process management, trigger management
Function, the function of user management, the function of partition table management, the function of index management, the function of tablespace management, Jiao Seguan
One or more in the function of reason, the content of difference in functionality is described in detail below.
The function of table management includes:Create table, modification table name, modification field name and type, addition field, cancel (CANCL)
Editor's data are checked in the table structure defining operation of section, the selection and modification of data type, and supports conditions selection inquiry data are gone forward side by side
Edlin is changed, Table Properties and dependence query;
The function of view management includes:Create, delete view, check, change view definition, check viewdata, support
Condition query, view properties and its dependence query, establishment, modification, the deletion of Materialized View, the inquiry of Materialized View;
The function of Constraints Management includes:Constraint definition and modification, constrain cascade function, constraint enables, disables control;
The function of storing process management includes:Create, edit and storage process, delete storing process, compile storing process;
The function of trigger management includes:Create, editor's trigger, delete trigger, compile trigger;
The function of user management includes:User is created, role, permission grant to user delete user, and modification user matches somebody with somebody
Confidence ceases;
The function of partition table management includes:Create the division table, changes partition table, deletes subregion table function, if provides more
Kind partition method, partition method include range partition, hash subregion, list partition, compound subregion;
The function of index management includes:Create, modification index information, index defines type selecting, there is provided effective index
Restructuring and deletion;
The function of tablespace management includes:The definition of table space, table space modification, table space are deleted;
The function of Role Management includes:Role is created, authority, the distribution and recovery of role, angle are added and deleted to role
Color enabling and disabling.
In an alternate embodiment of the invention, if database is data-base cluster, the function of the database can also include:Cluster
Related function;The related function of the cluster can include:The function of clustered node management, the function of cluster unified query,
The function of cluster unified management.
Function Test Automation script can be functionAutoTest.sh scripts in above-described embodiment,
The basic operation (i.e. database and function) of database, operation are covered in functionAutoTest.sh scripts
FunctionAutoTest.sh scripts, mainly run sql orders using database sql running tools.
By taking tablespace management as an example, following sql orders can be run:
CREATE TABLESPACE TESTTABLESPACE01 DATAFILE'/opt/dbsoftware/data/
TESTTABLESPACE01.dbf'SIZE 128;Test table space defined function
ALTER TABLESPACE TESTTABLESPACE01 RENAME TO TESTTABLESPACE02;It is empty to test table
Between renaming function
ALTER TABLESPACE TESTTABLESPACE02 RESIZE DATAFILE'/opt/dbsoftware/
data/TESTTABLESPACE01.dbf.dbf'TO 256;The function of test modifications table space size
DROP TABLESPACE TESTTABLESPACE02;The function of table space is deleted in test
For data-base cluster, reliability and high availability are the critically important characteristics of cluster, therefore reliable and height can
It is necessary with property test.
It is required to collect test result and test log for each test case.Terminate since test to test,
The state and related command output result of cluster are collected every one minute can.
In the alternative embodiment of the present invention, reliable and High Availabitity test block diagram is as shown in Figure 5.In this authentication method,
Major design is tested on clustered software, stability test, storage management software, group document on reliable and high availability
System, the reliable and High Availabitity test scene for storing this five aspects, will describe in detail respectively below.
The test of clustered software can include:Private network failure, public network failure, node failure, high availability;Private network failure
Test is successively to pull out the main private network of host node and secondary private network, while pulls out the main private network of host node and secondary private network, is pulled out successively
The main private network and secondary private network of host node only remain a node, the power-off of private network interchanger until cluster;The test of public network failure is first
The public and private net of host node and secondary private network are pulled out afterwards, while pull out Your Majesty's net of host node and secondary private network;The test of node failure is
Host node is powered off, and host node is restarted;The test of high availability is to kill the process of cluster service, while stops two nodes, is treated
Node is restarted after exiting, and stops cluster;
Stability test is to be specified first in duration (such as 72 hours), is run incessantly under high pressure, wherein, it is high
Pressure refers to that CPU usage is more than 90%, input/output port (I/O) and the utilization rate of network is more than 70%;During operation
Every the operation shape that second specifies duration (such as 10 minutes) record CPU, internal memory, the resource service condition of network and cluster
State;
Storage management software test can include:Kill the process of storage management software, storage disk failure and addition
Machine is restarted during disk;
Cluster file system test can include:The cluster process of at least two nodes is killed, disk interrupts, input and output
Port interrupts, extend file system space;
The test of storage can include:Fiber failure, HBA card failures and input/output port (I/O) interrupt;Optical fiber event
The test of barrier is to pull out the main fiber line of host node, pulls out all optical fiber cables of host node, pulls out the main fiber of host node successively
Line and secondary optical fiber cable only remain a node until cluster;The test of HBA card failures is in the bonded HBA cards for disable host node
One, disable bonded HBA cards;The test that input/output port interrupts is to interrupt datafile files, interrupts disk access,
Interrupt redo.Here HBA cards can be optical fiber storage card, and datafile is the operation system for the data in data storage storehouse
File in system, redo are to redo log file.
The method of database provided in an embodiment of the present invention and Compatibility of Operating System authentication test, suitable for all data
Storehouse and the compatible authentication test of (SuSE) Linux OS, there is ease for use, portability.Covered in installation scenario test complete
The test scene in face, installing front and rear script inspection ensures the correctness of installation scenario.Function Test Automation part then includes
More comprehensive function point, and realize that script automates, improves testing efficiency, ensured easy durability, expansibility and
Ease for maintenance.Reliable and High Availabitity method of testing relate to the reliable and high availability test of cluster various aspects, and test point is wide
It is general comprehensive.In addition, test point all in authentication method, can reach the compliance of (SuSE) Linux OS, and expire simultaneously
The key application demand of sufficient user.
It should be noted that in practical application, above-mentioned all optional embodiments can be any group by the way of combining
Close, form the alternative embodiment of the present invention, this is no longer going to repeat them.
Based on the method for database and Compatibility of Operating System authentication test that each embodiment provides above, based on same
Inventive concept, the embodiment of the present invention additionally provide the device of a kind of database and Compatibility of Operating System authentication test.
Fig. 6 shows the knot of database according to an embodiment of the invention and the device of Compatibility of Operating System authentication test
Structure schematic diagram.As shown in fig. 6, the device can include installation scenario test module 610, system information test module 620, function
Automatic test module 630 and determining module 640.
Now introduce each composition or device of the database of the embodiment of the present invention and the device of Compatibility of Operating System authentication test
Annexation between the function and each several part of part:
Installation scenario test module 610, the installation scenario for carrying out database are tested, in the installation scenario test
Installation scenario includes order line installation, graphical installation and silent installation;
System information test module 620, for carrying out system information test, the system information test includes database and is good for
Full test and operating system statistical test;
Function Test Automation module 630, for carrying out Function Test Automation, the Function Test Automation is to pass through
Operation function automatic test script is tested the function of database;And
Determining module 640, with installation scenario test module 610, system information test module 620, Function Test Automation
Module 630 is coupled, for according to installation scenario test, system information test and the Function Test Automation
Test result, determine whether database compatible with operating system.
In the alternative embodiment of the present invention, as shown in fig. 7, the device of figure 6 above displaying can also include pressure test
Module 650 and reliable and High Availabitity test module 660.
Pressure test module 650, for carrying out pressure test, the pressure test is to perform survey using pressure test instrument
Examination;
Reliable and High Availabitity test module 660, for carrying out the test of reliable and High Availabitity, the reliable and High Availabitity test
The test of test scene including clustered software, stability test, storage management software test, cluster file system test and
The test of storage;
The determining module 640, it is coupled with pressure test module 650 and reliable and High Availabitity test module 660, also
For being tested according to the pressure test and the reliable and High Availabitity, determine whether database is compatible with operating system.
According to the combination of any one above-mentioned alternative embodiment or multiple alternative embodiments, the embodiment of the present invention can reach
Following beneficial effect:
The method and apparatus of database provided in an embodiment of the present invention and Compatibility of Operating System authentication test, suitable for institute
There is the compatible authentication test of database and (SuSE) Linux OS, there is ease for use, portability;Contain in installation scenario test
More comprehensive installation scenario has been covered, has ensured the normative, comprehensive of test;Function Test Automation part then contain compared with
For comprehensive function point, and realize that script automates, improve testing efficiency, ensured easy durability, expansibility and easy dimension
Shield property.Also, reliable and high availability part of detecting carrys out the reliable and high availability of validation database cluster from every aspect, protect
Hinder the reliability and high availability of cluster.
In the specification that this place provides, numerous specific details are set forth.It is to be appreciated, however, that the implementation of the present invention
Example can be put into practice in the case of these no details.In some instances, known method, structure is not been shown in detail
And technology, so as not to obscure the understanding of this description.
Similarly, it will be appreciated that in order to simplify the disclosure and help to understand one or more of each inventive aspect,
Above in the description to the exemplary embodiment of the present invention, each feature of the invention is grouped together into single implementation sometimes
In example, figure or descriptions thereof.However, the method for the disclosure should be construed to reflect following intention:I.e. required guarantor
The application claims of shield features more more than the feature being expressly recited in each claim.It is more precisely, such as following
Claims reflect as, inventive aspect is all features less than single embodiment disclosed above.Therefore,
Thus the claims for following embodiment are expressly incorporated in the embodiment, wherein each claim is in itself
Separate embodiments all as the present invention.
Those skilled in the art, which are appreciated that, to be carried out adaptively to the module in the equipment in embodiment
Change and they are arranged in one or more equipment different from the embodiment.Can be the module or list in embodiment
Member or component be combined into a module or unit or component, and can be divided into addition multiple submodule or subelement or
Sub-component.In addition at least some in such feature and/or process or unit exclude each other, it can use any
Combination is disclosed to all features disclosed in this specification (including adjoint claim, summary and accompanying drawing) and so to appoint
Where all processes or unit of method or equipment are combined.Unless expressly stated otherwise, this specification (including adjoint power
Profit requires, summary and accompanying drawing) disclosed in each feature can be by providing the alternative features of identical, equivalent or similar purpose come generation
Replace.
In addition, it will be appreciated by those of skill in the art that although some embodiments described herein include other embodiments
In included some features rather than further feature, but the combination of the feature of different embodiments means in of the invention
Within the scope of and form different embodiments.For example, in detail in the claims, embodiment claimed it is one of any
Mode it can use in any combination.
The all parts embodiment of the present invention can be realized with hardware, or to be run on one or more processor
Software module realize, or realized with combinations thereof.It will be understood by those of skill in the art that it can use in practice
Microprocessor or digital signal processor (DSP) realize database according to embodiments of the present invention and Compatibility of Operating System
The some or all functions of some or all parts in the device of authentication test.The present invention is also implemented as being used to hold
The some or all equipment or program of device of row method as described herein are (for example, computer program and computer
Program product).It is such realize the present invention program can store on a computer-readable medium, or can have one or
The form of the multiple signals of person.Such signal can be downloaded from internet website and obtained, or be provided on carrier signal, or
Person is provided in the form of any other.
It should be noted that the present invention will be described rather than limits the invention for above-described embodiment, and ability
Field technique personnel can design alternative embodiment without departing from the scope of the appended claims.In the claims,
Any reference symbol between bracket should not be configured to limitations on claims.Word "comprising" does not exclude the presence of not
Element or step listed in the claims.Word "a" or "an" before element does not exclude the presence of multiple such
Element.The present invention can be by means of including the hardware of some different elements and being come by means of properly programmed computer real
It is existing.In if the unit claim of equipment for drying is listed, several in these devices can be by same hardware branch
To embody.The use of word first, second, and third does not indicate that any order.These words can be explained and run after fame
Claim.
So far, although those skilled in the art will appreciate that detailed herein have shown and described multiple showing for the present invention
Example property embodiment, still, still can be direct according to present disclosure without departing from the spirit and scope of the present invention
It is determined that or derive many other variations or modifications for meeting the principle of the invention.Therefore, the scope of the present invention is understood that and recognized
It is set to and covers other all these variations or modifications.
Claims (10)
1. a kind of method of database and Compatibility of Operating System authentication test, it is characterised in that including:
The installation scenario test of database is carried out, the installation scenario in the installation scenario test includes order line installation, figure
Change installation and silent installation;
System information test is carried out, the system information test includes database Sanity testing and operating system statistical test;
Function Test Automation is carried out, the Function Test Automation is to database by operation function automatic test script
Function tested;And
According to the installation scenario test, the system information test and the Function Test Automation test result, really
It is whether compatible with operating system to determine database.
2. according to the method for claim 1, it is characterised in that if database is data-base cluster, methods described also includes:
Pressure test is carried out, the pressure test is to perform test using pressure test instrument;
The test of reliable and High Availabitity is carried out, the test scene of the reliable and High Availabitity test includes testing, surely for clustered software
Qualitative test, storage management software test, cluster file system test and the test of storage;
The test knot according to installation scenario test, system information test and the Function Test Automation
Fruit, determine that the database step whether compatible with operating system includes:
According to installation scenario test, system information test, the Function Test Automation, the pressure test and
The test result of the reliable and High Availabitity test, determines whether database is compatible with operating system.
3. method according to claim 1 or 2, it is characterised in that the step of the installation scenario test for carrying out database
Suddenly specifically include:Checked before installation after inspection, installation database, inspection installation log, installation;
Checked before installation, specifically run the script for inspection before installing, check test node hostname, database user
And user's group, configuration file, network interface information, required lib bags, total internal memory and free memory, swap spaces, free disk space,
System architecture, kernel version, kernel parameter, and record check exports;Wherein, run be used to install before the script that checks it
Before, according to inspection database user and user's group, required lib bags in the requirement custom-written script of database;
The step of then proceeding by installation database after passing through is checked before installation, according to the installation of each database in installation process
Type carries out splitting different installation scenarios, and records installation log corresponding to different installation scenarios;
Enter the step of checking installation log after installation, installation log corresponding to different installation scenarios checked,
And record check exports;
The step of installation log checks after then being installed without mistake, after installing DB, default service is to start, installation
Afterwards check be check database service whether normal operation, the script for being checked after installation is specifically run, according to database
Service state viewing command modify, and record check export.
4. according to the method for claim 3, it is characterised in that if database is single instance database, the installation scenario
The step of test, also includes update;
The specific step of update be install lowest version database software, from lowest version database upgrade to current version,
Check installation log, check database positioning.
5. method according to claim 1 or 2, it is characterised in that the database Sanity testing is particular by modification
Database parameter creates database and logs in management platform;The operating system statistical test is particular by execution sql languages
Sentence and system command check operating system relevant information.
6. method according to claim 1 or 2, it is characterised in that the Function Test Automation operation function automation
Test script, specifically run sql orders using database sql running tools;
The function of the database includes:The function of table management, the function of view management, the function of Constraints Management, storing process
The function of management, the function of trigger management, the function of user management, the function of partition table management, the function of index management, table
One or more in the function of space management, the function of Role Management.
7. according to the method for claim 6, it is characterised in that
The function of the table management includes:Create table, modification table name, modification field name and type, addition field, cancel (CANCL)
Editor's data are checked in the table structure defining operation of section, the selection and modification of data type, and supports conditions selection inquiry data are gone forward side by side
Edlin is changed, Table Properties and dependence query;
The function of the view management includes:Create, delete view, check, change view definition, check viewdata, support
Condition query, view properties and its dependence query, establishment, modification, the deletion of Materialized View, the inquiry of Materialized View;
The function of the Constraints Management includes:Constraint definition and modification, constrain cascade function, constraint enables, disables control;
The function of the storing process management includes:Create, edit and storage process, delete storing process, compile storing process;
The function of the trigger management includes:Create, editor's trigger, delete trigger, compile trigger;
The function of the user management includes:User is created, role, permission grant to user delete user, and modification user matches somebody with somebody
Confidence ceases;
The function of the partition table management includes:Create the division table, changes partition table, deletes subregion table function, if provides more
Kind partition method, the partition method include range partition, hash subregion, list partition, compound subregion;
The function of the index management includes:Create, modification index information, index defines type selecting, there is provided effective index
Restructuring and deletion;
The function of the tablespace management includes:The definition of table space, table space modification, table space are deleted;
The function of the Role Management includes:Role is created, authority, the distribution and recovery of role, angle are added and deleted to role
Color enabling and disabling.
8. according to the method for claim 6, it is characterised in that if database is data-base cluster, the work(of the database
Can also it include:The related function of cluster;
The related function of the cluster includes:The function of clustered node management, the function of cluster unified query, cluster unified management
Function.
9. according to the method for claim 2, it is characterised in that
The test of the clustered software includes:Private network failure, public network failure, node failure, high availability;The test of private network failure
It is successively to pull out the main private network of host node and secondary private network, while pulls out the main private network of host node and secondary private network, pulls out main section successively
The main private network and secondary private network of point only remain a node, the power-off of private network interchanger until cluster;The test of public network failure is successively to pull out
Fall the public and private net of host node and secondary private network, while pull out Your Majesty's net of host node and secondary private network;The test of node failure is main section
Point power-off, host node are restarted;The test of high availability is to kill the process of cluster service, while stops two nodes, treats node
Restart after exiting, stop cluster;
The stability test is to be specified first in duration, is run incessantly under high pressure, wherein, high pressure refers to CPU
Utilization rate is more than 90%, input/output port and the utilization rate of network is more than 70%;During operation duration is specified every second
Record CPU, internal memory, the resource service condition of network and the running status of cluster;
The storage management software test includes:Kill the process of storage management software, storage disk failure and addition disk
Shi Chongqi machines;
The cluster file system test includes:The cluster process of at least two nodes is killed, disk interrupts, input/output port
Interrupt, extend file system space;
The test of the storage includes:Fiber failure, HBA card failures and input/output port interrupt;The test of fiber failure
It is the main fiber line for pulling out host node, pulls out all optical fiber cables of host node, pulls out the main fiber line of host node and secondary light successively
Fine line only remains a node until cluster;The test of HBA card failures is disabling one in the bonded HBA cards for disable host node
Bonded HBA cards;The test that input/output port interrupts is to interrupt datafile files, interrupts disk access, interrupts redo.
A kind of 10. device of database and Compatibility of Operating System authentication test, it is characterised in that including:
Installation scenario test module, the installation scenario for carrying out database are tested, the erecting bed in the installation scenario test
Scape includes order line installation, graphical installation and silent installation;
System information test module, for carrying out system information test, the system information test includes database Sanity testing
With operating system statistical test;
Function Test Automation module, for carrying out Function Test Automation, the Function Test Automation is by running work(
Energy automatic test script is tested the function of database;And
Determining module, for according to installation scenario test, system information test and the Function Test Automation
Test result, determine whether database compatible with operating system.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710826996.5A CN107656867A (en) | 2017-09-14 | 2017-09-14 | A kind of method and apparatus of database and Compatibility of Operating System authentication test |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710826996.5A CN107656867A (en) | 2017-09-14 | 2017-09-14 | A kind of method and apparatus of database and Compatibility of Operating System authentication test |
Publications (1)
Publication Number | Publication Date |
---|---|
CN107656867A true CN107656867A (en) | 2018-02-02 |
Family
ID=61129993
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710826996.5A Pending CN107656867A (en) | 2017-09-14 | 2017-09-14 | A kind of method and apparatus of database and Compatibility of Operating System authentication test |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107656867A (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110990290A (en) * | 2019-12-13 | 2020-04-10 | 浪潮软件集团有限公司 | Universal big data platform stability test system and method |
CN111611159A (en) * | 2020-05-13 | 2020-09-01 | 麒麟软件有限公司 | Linux operating system test authentication flow management method |
CN111857752A (en) * | 2020-07-22 | 2020-10-30 | 浪潮商用机器有限公司 | PostgreSQL database installation method, device and equipment |
CN114584489A (en) * | 2022-03-08 | 2022-06-03 | 浪潮云信息技术股份公司 | Ssh channel-based remote environment information and configuration detection method and system |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102968374A (en) * | 2012-11-29 | 2013-03-13 | 中国移动(深圳)有限公司 | Data warehouse testing method |
CN103116544A (en) * | 2013-01-25 | 2013-05-22 | 浪潮电子信息产业股份有限公司 | Automated cross-platform multi-server multi-application test method |
CN104182340A (en) * | 2014-08-21 | 2014-12-03 | 浪潮(北京)电子信息产业有限公司 | Database compatibility test method and system |
US9111037B1 (en) * | 2013-08-21 | 2015-08-18 | Ca, Inc. | Method and apparatus to enable mainframe computer testing for software testing management platform |
CN106850342A (en) * | 2017-01-20 | 2017-06-13 | 郑州云海信息技术有限公司 | The method and device of test interchanger compatibility and stability |
-
2017
- 2017-09-14 CN CN201710826996.5A patent/CN107656867A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102968374A (en) * | 2012-11-29 | 2013-03-13 | 中国移动(深圳)有限公司 | Data warehouse testing method |
CN103116544A (en) * | 2013-01-25 | 2013-05-22 | 浪潮电子信息产业股份有限公司 | Automated cross-platform multi-server multi-application test method |
US9111037B1 (en) * | 2013-08-21 | 2015-08-18 | Ca, Inc. | Method and apparatus to enable mainframe computer testing for software testing management platform |
CN104182340A (en) * | 2014-08-21 | 2014-12-03 | 浪潮(北京)电子信息产业有限公司 | Database compatibility test method and system |
CN106850342A (en) * | 2017-01-20 | 2017-06-13 | 郑州云海信息技术有限公司 | The method and device of test interchanger compatibility and stability |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110990290A (en) * | 2019-12-13 | 2020-04-10 | 浪潮软件集团有限公司 | Universal big data platform stability test system and method |
CN110990290B (en) * | 2019-12-13 | 2023-06-06 | 浪潮软件集团有限公司 | System and method for testing stability of universal big data platform |
CN111611159A (en) * | 2020-05-13 | 2020-09-01 | 麒麟软件有限公司 | Linux operating system test authentication flow management method |
CN111857752A (en) * | 2020-07-22 | 2020-10-30 | 浪潮商用机器有限公司 | PostgreSQL database installation method, device and equipment |
CN111857752B (en) * | 2020-07-22 | 2023-08-08 | 浪潮商用机器有限公司 | PostgreSQL database installation method, device and equipment |
CN114584489A (en) * | 2022-03-08 | 2022-06-03 | 浪潮云信息技术股份公司 | Ssh channel-based remote environment information and configuration detection method and system |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10691654B2 (en) | Automated database migration architecture | |
US10353913B2 (en) | Automating extract, transform, and load job testing | |
US9792321B2 (en) | Online database migration | |
US11640352B2 (en) | Testing software and/or computing hardware design through test fragmentation into one or more discrete computing environments | |
US10083027B2 (en) | Systems and methods for managing software development environments | |
US8150674B2 (en) | Automated testing platform for event driven systems | |
US6182245B1 (en) | Software test case client/server system and method | |
US9098364B2 (en) | Migration services for systems | |
US8074204B2 (en) | Test automation for business applications | |
US20170053004A1 (en) | Etl tool interface for remote mainframes | |
CN107656867A (en) | A kind of method and apparatus of database and Compatibility of Operating System authentication test | |
US11669439B2 (en) | Computing hardware and software design testing auditability, including for critical control systems, functional safety, and autonomous vehicle component certification | |
US10909092B2 (en) | Automated database creation | |
CN111177239B (en) | Unified log processing method and system based on HDP big data cluster | |
EP3182278A1 (en) | System for automatic preparation of integrated development environments | |
US11100131B2 (en) | Simulation of a synchronization of records | |
Kumari | PCIe NVMe firmware and performance validation methodology | |
Ward et al. | Migrating to SQL Server on Linux | |
Alapati et al. | Oracle Database 11g: New Features for DBAs and Developers | |
CN114090419A (en) | Program testing method, system, device, electronic equipment and storage medium | |
CN113918182A (en) | Software deployment method, device, server and storage medium | |
CN113515288A (en) | Automatic deployment method and device based on release unit | |
Curtis | Pro Oracle GoldenGate for the DBA | |
Curtis | GoldenGate | |
Reid | Instant InnoDB |
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 | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180202 |
|
RJ01 | Rejection of invention patent application after publication |