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 PDF

Info

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
Application number
CN201710826996.5A
Other languages
Chinese (zh)
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.)
China Standard Software Co Ltd
Original Assignee
China Standard 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 China Standard Software Co Ltd filed Critical China Standard Software Co Ltd
Priority to CN201710826996.5A priority Critical patent/CN107656867A/en
Publication of CN107656867A publication Critical patent/CN107656867A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/36Preventing errors by testing or debugging software
    • G06F11/3668Software testing
    • G06F11/3672Test management
    • 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/21Design, 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

A kind of method and apparatus of database and Compatibility of Operating System authentication test
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.
CN201710826996.5A 2017-09-14 2017-09-14 A kind of method and apparatus of database and Compatibility of Operating System authentication test Pending CN107656867A (en)

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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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

Patent Citations (5)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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