CN101882159A - Database detecting method of and device thereof - Google Patents
Database detecting method of and device thereof Download PDFInfo
- Publication number
- CN101882159A CN101882159A CN2010102112041A CN201010211204A CN101882159A CN 101882159 A CN101882159 A CN 101882159A CN 2010102112041 A CN2010102112041 A CN 2010102112041A CN 201010211204 A CN201010211204 A CN 201010211204A CN 101882159 A CN101882159 A CN 101882159A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- file
- specified format
- module
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a database detecting method of and a device thereof. The method comprises the following steps of: mining the data dictionary information of a standard database, and generating a document with an appointed format; copying the document with the appointed format a device of the database to be detected; differencing the embodiment of the database to be detected from the embodiment in the document with the appointed format, and displaying a difference result. The invention improves the reliability of the database, and increases the efficiency and the accuracy of the system.
Description
Technical field
The present invention relates to computer communication field, in particular to a kind of detection method and device of database.
Background technology
Along with the fast development of Web TV (Internet Protocol Television abbreviates IPTV as), the edition upgrading task of end application is increasing.At present, a database upgrade to the effect that of end application edition upgrading, and database and be to present unlike version program with the operating system file of physics one by one, so the database after the maintainer can't adopt traditional difference instrument or detection means to upgrading is checked.
The inventor finds in the above-mentioned correlation technique, each office point of existing network all is that the application program after adopting manual configuration to upgrading is generally checked, whether the test by main business workflow comes the upgrading in decision data storehouse successful then, and the maintenance cost of doing like this is than higher, and risk is bigger.
Summary of the invention
Fundamental purpose of the present invention is to provide a kind of detection scheme of database, to solve the decision data storehouse is come in each office point of above-mentioned existing network by the test of main business workflow the upgrading problem whether success causes the maintenance cost height, has a big risk at least.
To achieve these goals, according to an aspect of the present invention, provide a kind of detection method of database.
Detection method according to database of the present invention may further comprise the steps: excavate the data dictionary information of standard database, generate the file of specified format; With the document copying of specified format equipment to the data to be tested storehouse; And the example in the file of the example of database to be detected and specified format done difference, and show differentiated result.
One of below further, the example in the file of the example in data to be tested storehouse and specified format comprises at least: database table, view, synonym, index, storing process, function, sequence, trigger, subregion.
Further, example in the file of the example of database to be detected and specified format is done before the difference, also comprise: read the data object of data to be tested storehouse under designated mode, from the data dictionary information in data to be tested storehouse, search and example that derivation is corresponding with data object.
Further, the data dictionary information of excavation standard database comprises: read the data object of standard database under designated mode, search example corresponding with data object in the data dictionary information.
Further, the file of generation specified format comprises: the example corresponding with data object that will find according to specified format generates the file on a serializing plane.
Further, show that differentiated result comprises: the form with tree-like synoptic diagram or form shows differentiated result.
To achieve these goals, according to a further aspect in the invention, also provide a kind of pick-up unit of database.
Pick-up unit according to database of the present invention comprises: excavate module, be used to excavate the data dictionary information of standard database, and generate the file of specified format; The copy module is used for the document copying of the specified format equipment to the data to be tested storehouse; Difference block is used for the example of the file of the example of database to be detected and specified format is done difference; And display module, be used to show differentiated result.
Further, excavating module comprises: read module is used to read the data object of standard database under designated mode; And search module, be used for searching the data dictionary information example corresponding with data object.
Further, excavating module also is used for will searching the file that the example corresponding with data object that module searches arrives generates a serializing plane according to specified format.
Further, display module also is used for showing differentiated result with the form of tree-like synoptic diagram or form.
By the present invention, employing with the database of each office point of existing network (promptly, the data to be tested storehouse) mode that compares with standard database, solved the decision data storehouse is come in each office point of existing network by the test of main business workflow the upgrading problem whether success causes the maintenance cost height, has a big risk, increase the reliability of database, improved the efficient and the accuracy of system.
Description of drawings
Accompanying drawing described herein is used to provide further understanding of the present invention, constitutes the application's a part, and illustrative examples of the present invention and explanation thereof are used to explain the present invention, do not constitute improper qualification of the present invention.In the accompanying drawings:
Fig. 1 is the process flow diagram according to the detection method of the database of the embodiment of the invention;
Fig. 2 is the structured flowchart according to the pick-up unit of the database of the embodiment of the invention;
Fig. 3 is the structural representation of database difference instrument according to the preferred embodiment of the invention;
Fig. 4 is the screenshot capture of the differentiated tree-like demonstration difference of the database instance of the embodiment of the invention.
Embodiment
Hereinafter will describe the present invention with reference to the accompanying drawings and in conjunction with the embodiments in detail.Need to prove that under the situation of not conflicting, embodiment and the feature among the embodiment among the application can make up mutually.
Fig. 1 is the process flow diagram according to the detection method of the database of the embodiment of the invention, and as shown in Figure 1, this method may further comprise the steps:
Step S102, the data dictionary information of excavation standard database, the file of generation specified format;
Step S104 is with the document copying of the specified format equipment to the data to be tested storehouse; And
Step S106 does difference to the example in the file of the example of database to be detected and specified format, and shows differentiated result.
Pass through the embodiment of the invention, employing with the data to be tested storehouse (promptly, the database of each office point of existing network) with standard database (promptly, breadboard database) mode that compares, solved the decision data storehouse is come in each office point of existing network by the test of main business workflow the upgrading problem whether success causes the maintenance cost height, has a big risk, increase the reliability of database, improved the efficient and the accuracy of system.
One of below preferably, the example in the file of the example in data to be tested storehouse and specified format can comprise at least: database table, view, synonym, index, storing process, function, sequence, trigger, subregion.This method realizes simple, workable.
Preferably, in step S102, can read the data object of standard database under designated mode, search example corresponding in the data dictionary information with data object.This method can obtain the example of standard database, has improved the efficient of system.
Preferably, in step S102, the example corresponding with data object that can will find according to specified format generates the file on a serializing plane.This method can be with the example corresponding with data object that find according to specified format (promptly, predetermined format) exports in the obj ect file, so that the example of the database of existing network office point and the example of standard database are carried out difference, have improved the processing power of system.
Preferably, before step S106, can read the data object of data to be tested storehouse under designated mode, from the data dictionary information in data to be tested storehouse, search and example that derivation is corresponding with data object.
The example in data to be tested storehouse can be derived in this preferred enforcement, make the difference object unanimity of two databases, thereby the example in database to be detected and the standard database is carried out difference, relatively the database after the upgrading (promptly, the data to be tested storehouse) difference of example in example and the breadboard database, and then the success of whether upgrading of the database of definite existing network office point.
Preferably, in step S106, show differentiated result with the form of tree-like synoptic diagram or form.This method can make operating personnel observe the difference of example in testing data storehouse and the standard database intuitively, quickly, has improved user experience.
Fig. 2 is the structured flowchart according to the pick-up unit of the database of the embodiment of the invention, and as shown in Figure 2, this device comprises: excavate module 22, copy module 24, difference block 26 and display module 28, below this structure is elaborated.
Excavate module 22, be used to excavate the data dictionary information of standard database, and generate the file of specified format; Copy module 24 is coupled to and excavates module 22, is used for the document copying of the specified format equipment to the data to be tested storehouse; Difference block 26 is coupled to copy module 24, is used for the example of the file of the example of database to be detected and specified format is done difference; And display module 28, be coupled to difference block 26, be used to show differentiated result.
Preferably, excavating module 22 comprises: read module 222 is used to read the data object of standard database under designated mode; And search module 224, and be coupled to read module 222, be used for searching the data dictionary information example corresponding with data object.
Preferably, excavating module 22 also is used for will searching the file that module 224 examples corresponding with data object that find generate a serializing plane according to specified format.
Preferably, display module 28 also is used for showing differentiated result with the form of tree-like synoptic diagram or form.
Need to prove that in specific implementation process, the pick-up unit of database can be a kind of database difference instrument.
In the embodiment of the invention, data to be tested storehouse and standard database are compared, solved the decision data storehouse is come in each office point of existing network by the test of main business workflow the upgrading problem whether success causes the maintenance cost height, has a big risk, increase the reliability of database, improved the efficient and the accuracy of system.
Be described in detail below in conjunction with the implementation procedure of example the embodiment of the invention.
Example 1
Fig. 3 is the structural representation of database difference instrument according to the preferred embodiment of the invention, this database difference instrument comprises: data dictionary excavates module 32, flat file difference block 34 and database instance difference Reports module 36, below this structure is elaborated.
Data dictionary excavates module 32, is used for the data object under the reading database designated mode; Flat file difference block 34 is used to store each data object, and each data object is carried out difference; Database instance difference Reports module 36 is used for the difference between tree-like synoptic diagram or the report form displaying database instance.
In specific implementation process, can comprise the steps: when using database difference instrument to carry out the detection of database
Step S302, log-on data storehouse difference instrument.
Step S304 excavates breadboard data of database dictionary information, generates the normative document (can be the serializing flat file) of specified format.
Step S306 copies this normative document to existing network, connects to treat database of the existing network (that is, the database after the upgrading to be detected), reads the data dictionary of database of the existing network successively, and the structural information of each database object is come with the predetermined format derivation.
Step S308, with the structural information of the database of the existing network object of deriving successively with normative document in information compare, show difference with tree-like diagrammatic sketch or form.For example, Bi Jiao content can comprise: the structure of database objects such as database table, view, synonym, index, storing process, function, sequence, trigger, subregion, and the content of the table of some appointment of oracle database.Particularly, also can do online difference to two oracle database examples.
Need to prove, in specific implementation process, can include only and excavate and differential process, do not comprise the process of formation sequence flat file.
Example 2
To realize that the oracle database example (laboratory) and the difference of database of the existing network 1 example are example, the detection method of the database of the preferred embodiment of the present invention can may further comprise the steps:
Step 1 connects breadboard oracle database (that is standard database) example.
Step 3, from the related data dictionary table, retrieve the descriptor of this object one by one, and according to a serializing flat file of predetermined form generation (for example, preserving data can generate in proper order by forms such as database table, view, synonym, index, storing process, functions).
Step 4, the serializing flat file that the laboratory is generated reads in the internal memory.
Step 5 connects the oracle database example (for example, database of the existing network 1,2,3...) of examine successively.
Step 6 reads the data object under the oracle database designated mode of examine.
Step 7 is retrieved the descriptor of this object one by one from the data dictionary table of the oracle database of relevant examine, and the related content in the serializing flat file that generates with the laboratory compares according to predefined procedure.
Step 8, tree-like schematic diagram shows difference or generate corresponding form.
It is increasing and cause the problem of database maintenance cost height, the present situation that has a big risk and hidden danger that present embodiment can solve the database version upgrading task of existing network office point, simplified the scrutiny program after the database upgrade of existing network office point, improved user experience.
Example 3
Fig. 4 is the synoptic diagram of the differentiated tree-like demonstration difference of the database instance of the embodiment of the invention, as shown in Figure 4, the left and right sides is respectively the differential configuration synoptic diagram of laboratory and database of the existing network table, wherein, have two tables (promptly among SYS.TABLES (2) the expression SYS user, SYS.sysevent and SYS.login_user table), table name is that the child node of SYS.login_user has COLUMNS (3) in the laboratory data base of left side, represent that this table has 3 row, in like manner also can other child node of carry (for example, index, external key etc.), user_d is the row name of SYS.login_user table, and its child node has some property values such as TYPE:NUMBER and SIZE:50 (all loading according to real data).
In specific implementation process, can be marked etc. by the difference result of different colours to the left and right sides.For example, can represent that the both sides value is variant with blueness, represent that with redness there is this element in the left side, the right side does not have this element, to reach the purpose of showing difference.
In addition, the embodiment of the invention can also compare the data of some specified database table.
In sum, the embodiment of the invention can relate to the structure of oracle database object and serializing and the flat file of oracle database object and serializing is carried out technology such as difference, is intended to the inspection after the reduced data qurush level.And, the breadboard standard database of database and manufacturer of each office point of existing network can be compared, find the difference of database object structure, thereby increased the reliability of database, improved user experience.
Obviously, those skilled in the art should be understood that, above-mentioned each module of the present invention or each step can realize with the general calculation device, they can concentrate on the single calculation element, perhaps be distributed on the network that a plurality of calculation element forms, alternatively, they can be realized with the executable program code of calculation element, thereby, they can be stored in the memory storage and carry out by calculation element, and in some cases, can carry out step shown or that describe with the order that is different from herein, perhaps they are made into each integrated circuit modules respectively, perhaps a plurality of modules in them or step are made into the single integrated circuit module and realize.Like this, the present invention is not restricted to any specific hardware and software combination.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and for a person skilled in the art, the present invention can have various changes and variation.Within the spirit and principles in the present invention all, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. the detection method of a database is characterized in that, may further comprise the steps:
Excavate the data dictionary information of standard database, generate the file of specified format; With the document copying of described specified format equipment to the data to be tested storehouse; And
Example in the file of the example in described data to be tested storehouse and described specified format is done difference, and show differentiated result.
2. method according to claim 1, one of it is characterized in that, below the example in the example in described data to be tested storehouse and the file of described specified format comprises at least: database table, view, synonym, index, storing process, function, sequence, trigger, subregion.
3. method according to claim 1 is characterized in that, the example in the file of the example in described data to be tested storehouse and described specified format is done before the difference, also comprises:
Read the data object of described data to be tested storehouse under designated mode, from the data dictionary information in described data to be tested storehouse, search and example that derivation is corresponding with described data object.
4. method according to claim 1 is characterized in that, the data dictionary information of excavating described standard database comprises:
Read the data object of described standard database under designated mode, search example corresponding in the described data dictionary information with described data object.
5. method according to claim 4 is characterized in that, the file that generates described specified format comprises:
The example corresponding with described data object that will find according to described specified format generates the file on a serializing plane.
6. according to each described method in the claim 1 to 5, it is characterized in that, show that differentiated described result comprises:
Form with tree-like synoptic diagram or form shows differentiated described result.
7. the pick-up unit of a database is characterized in that, comprising:
Excavate module, be used to excavate the data dictionary information of standard database, and generate the file of specified format;
The copy module is used for the document copying of the described specified format equipment to the data to be tested storehouse;
Difference block is used for the example of the file of the example in described data to be tested storehouse and described specified format is done difference; And
Display module is used to show differentiated result.
8. device according to claim 7 is characterized in that, described excavation module comprises: read module is used to read the data object of described standard database under designated mode; And
Search module, be used for searching the described data dictionary information example corresponding with described data object.
9. device according to claim 8 is characterized in that, described excavation module also is used for searching the file that the example corresponding with described data object that module searches arrives generates a serializing plane according to described specified format with described.
10. according to each described device in the claim 7 to 9, it is characterized in that described display module also is used for showing differentiated described result with the form of tree-like synoptic diagram or form.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102112041A CN101882159A (en) | 2010-06-18 | 2010-06-18 | Database detecting method of and device thereof |
| PCT/CN2011/075685 WO2011157213A1 (en) | 2010-06-18 | 2011-06-13 | Method and device for detecting database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102112041A CN101882159A (en) | 2010-06-18 | 2010-06-18 | Database detecting method of and device thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101882159A true CN101882159A (en) | 2010-11-10 |
Family
ID=43054173
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010102112041A Pending CN101882159A (en) | 2010-06-18 | 2010-06-18 | Database detecting method of and device thereof |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN101882159A (en) |
| WO (1) | WO2011157213A1 (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2011157213A1 (en) * | 2010-06-18 | 2011-12-22 | 中兴通讯股份有限公司 | Method and device for detecting database |
| CN106339500A (en) * | 2016-09-09 | 2017-01-18 | 浪潮软件股份有限公司 | Remote database comparison tool and method |
| CN109947797A (en) * | 2017-07-31 | 2019-06-28 | 华为技术有限公司 | A kind of data detecting device and method |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1889076A (en) * | 2005-06-27 | 2007-01-03 | 国际商业机器公司 | Customized databank mode portability difference detecting method and system |
| CN101676908A (en) * | 2008-09-17 | 2010-03-24 | 中兴通讯股份有限公司 | Method and device for detecting integrity of database objects |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| GB0217201D0 (en) * | 2002-07-24 | 2002-09-04 | Beach Solutions Ltd | XML database differencing engine |
| CN101882159A (en) * | 2010-06-18 | 2010-11-10 | 中兴通讯股份有限公司 | Database detecting method of and device thereof |
-
2010
- 2010-06-18 CN CN2010102112041A patent/CN101882159A/en active Pending
-
2011
- 2011-06-13 WO PCT/CN2011/075685 patent/WO2011157213A1/en active Application Filing
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1889076A (en) * | 2005-06-27 | 2007-01-03 | 国际商业机器公司 | Customized databank mode portability difference detecting method and system |
| CN101676908A (en) * | 2008-09-17 | 2010-03-24 | 中兴通讯股份有限公司 | Method and device for detecting integrity of database objects |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2011157213A1 (en) * | 2010-06-18 | 2011-12-22 | 中兴通讯股份有限公司 | Method and device for detecting database |
| CN106339500A (en) * | 2016-09-09 | 2017-01-18 | 浪潮软件股份有限公司 | Remote database comparison tool and method |
| CN109947797A (en) * | 2017-07-31 | 2019-06-28 | 华为技术有限公司 | A kind of data detecting device and method |
| CN109947797B (en) * | 2017-07-31 | 2022-04-05 | 华为技术有限公司 | Data inspection device and method |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2011157213A1 (en) | 2011-12-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10237295B2 (en) | Automated event ID field analysis on heterogeneous logs | |
| CN105940410B (en) | For removing the cleaner of personal recognizable information | |
| CN107251024A (en) | Tracking and data generation are performed for diagnosing the data base querying of executive problem | |
| US10331441B2 (en) | Source code mapping through context specific key word indexes and fingerprinting | |
| US20110161874A1 (en) | Analyzing objects from a graphical interface for standards verification | |
| CN106528393A (en) | Method and device for Mock testing of WebService | |
| CN112214411B (en) | Disaster recovery system testing method, device, equipment and storage medium | |
| CN105868096A (en) | Methods and apparatuses used for displaying web page test result in browser and device | |
| CN104462985A (en) | Detecting method and device of bat loopholes | |
| KR101696694B1 (en) | Method And Apparatus For Analysing Source Code Vulnerability By Using TraceBack | |
| CN109492399A (en) | Risk file test method, device and computer equipment | |
| CN104462305A (en) | Data analyzing method and device | |
| CN111190880B (en) | Database detection method, device and computer readable storage medium | |
| CN101882159A (en) | Database detecting method of and device thereof | |
| CN101908174A (en) | Method, device and EAP (Enterprise Application Platform) system for processing part object information in drawing file | |
| KR101415528B1 (en) | Apparatus and Method for processing data error for distributed system | |
| CN106933743A (en) | A kind of method of testing and device | |
| CN111062039A (en) | Multi-standard security reference detection method and system, target host and server | |
| CN110659204A (en) | Code detection method, device and medium | |
| JP2013077124A (en) | Software test case generation device | |
| CN109582582A (en) | A kind of automated testing method and system of web interface | |
| CN114510409A (en) | Application program code detection method and computer readable storage medium | |
| KR101865103B1 (en) | System and method for verifying consistency of software | |
| CN105260425A (en) | Cloud disk based file display method and apparatus | |
| CN113111353B (en) | Container mirror library security evaluation system and method based on dependency relationship |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20101110 |