CN109271199A - A kind of method and system for database continuous integrating and script file management - Google Patents
A kind of method and system for database continuous integrating and script file management Download PDFInfo
- Publication number
- CN109271199A CN109271199A CN201811056204.1A CN201811056204A CN109271199A CN 109271199 A CN109271199 A CN 109271199A CN 201811056204 A CN201811056204 A CN 201811056204A CN 109271199 A CN109271199 A CN 109271199A
- Authority
- CN
- China
- Prior art keywords
- script file
- script
- library
- file
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/70—Software maintenance or management
- G06F8/71—Version control; Configuration management
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Security & Cryptography (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of methods for database continuous integrating and script file management, the described method includes: the script file for the current slot that script file is committed under script file administrative directory is summarized under catalogue, the script file is executed in geo-database integration environment；The script file is executed by script integration tool DBIT and manages the script file and is summarized under catalogue, comprising: the script file in each period, which summarizes, creates subdirectory under the path of catalogue；The perform script file in verification library judges whether the script file is abnormal, and the script file that the abnormal script file imports current slot is summarized the subdirectory under catalogue；The non-abnormal script file is executed in formal library, and the script file after running succeeded is appended to edition upgrading script file；The session control in the verification library is removed, rebuilds verification library using the formal library.
Description
Technical field
The present invention relates to geo-database integration technical fields, are used for database continuous integrating and foot more particularly, to one kind
The method and system of this document management.
Background technique
In software development process, with the completion to demand, reparation to system Bug and to the complete of system ease for use
Other than kind increase and modification in addition to code, the variation of database is also important a link.The variation of software function, program
Update will be premised on the variation of database.Exploitation of the upgrading of software i.e. from a version updating to another version
Cheng Zhong, the update of database are a lasting processes in software development process, the variation of regular database structure with
And the variation of preset data just needs a complete script management and integrated process.
In high concurrent, the transactional database of high data volume, oracle database is leading.It is integrated in oracle
In the process, a large amount of scripts are since it is desired that there is the requirement of grammaticality, the requirement of the various constraints of data, blob, clob field
Particularity, ddl sentence can not rollback feature, very big difficulty is brought to oracle continuous integrating.
Therefore, it is necessary to a kind of technologies, to realize database continuous integrating and script file management.
Summary of the invention
Technical solution of the present invention provides a kind of method and system for database continuous integrating and script file management,
To solve the problems, such as how to manage database continuous integrating and script file.
To solve the above-mentioned problems, the present invention provides a kind of sides for database continuous integrating and script file management
Method, which comprises
The script file for the current slot that script file is committed under script file administrative directory is summarized under catalogue,
The script file is executed in geo-database integration environment；
The script file is executed by script integration tool DBIT and manages the script file and is summarized under catalogue, is wrapped
It includes:
Script file in each period, which summarizes, creates subdirectory under the path of catalogue；
The perform script file in verification library judges whether the script file is abnormal, and by the abnormal script
The script file that file imports current slot summarizes the subdirectory under catalogue；
The non-abnormal script file is executed in formal library, and the script file after running succeeded is appended to version
This upgrade script file；
The session control in the verification library is removed, rebuilds verification library using the formal library.
Preferably, further includes: java standard library and verification library are created in database environment, the java standard library is after continuous integrating
For formal library.
Preferably, further includes:
Define the naming rule of the script file.
Preferably, the naming rule are as follows:
Date _ submitter's name _ module name _ illustrates .txt.
Preferably, the script integration tool DBIT is described by java language development, including pre-set timed task
Timed task is executed by task framework Quartz.
Preferably, the subdirectory further includes text file, and the text file is for recording the different of the script file
Normal reason.
Preferably, the geo-database integration environment is oracle database the integration environment.
Preferably, by the way of submitting script file, continuous integrating is carried out to the database.
Preferably, the script file include: not same date, different submitter and disparate modules script file.
Preferably, the script file that script file is committed to the current slot under script file administrative directory converges
Under catalogue, comprising:
The script file of the current slot, which summarizes catalogue, to be automatically generated by date by script integration tool DBIT,
Generating the time is after having executed proxima luce (prox. luc) script.
Based on another aspect of the present invention, a kind of system for database continuous integrating and script file management is provided,
The system comprises:
Submit unit, the script file of the current slot for being committed to script file under script file administrative directory
Summarize under catalogue, the script file is executed in geo-database integration environment；
Integrated unit converges for executing the script file by script integration tool DBIT and managing the script file
Under catalogue, comprising:
Script file in each period, which summarizes, creates subdirectory under the path of catalogue；
The perform script file in verification library judges whether the script file is abnormal, and by the abnormal script
The script file that file imports current slot summarizes the subdirectory under catalogue；
The non-abnormal script file is executed in formal library, and the script file after running succeeded is appended to version
This upgrade script file；
The session control in the verification library is removed, rebuilds verification library using the formal library.
It preferably, further include establishing unit, for creating java standard library and verification library, the java standard library in database environment
It is formal library after continuous integrating.
Preferably, further includes:
Define the naming rule of the script file.
Preferably, the naming rule are as follows:
Date _ submitter's name _ module name _ illustrates .txt.
Preferably, the script integration tool DBIT is described by java language development, including pre-set timed task
Timed task is executed by task framework Quartz.
Preferably, the subdirectory further includes text file, and the text file is for recording the different of the script file
Normal reason.
Preferably, the geo-database integration environment is oracle database the integration environment.
Preferably, by the way of submitting script file, continuous integrating is carried out to the database.
Preferably, the script file include: not same date, different submitter and disparate modules script file.
Preferably, the script file that script file is committed to the current slot under script file administrative directory converges
Under catalogue, comprising:
The script file of the current slot, which summarizes catalogue, to be automatically generated by date by script integration tool DBIT,
Generating the time is after having executed proxima luce (prox. luc) script.
Technical solution of the present invention provides a kind of method and system for database continuous integrating and script file management,
Middle method includes: that the script file for the current slot that script file is committed under script file administrative directory is summarized catalogue
Under, the perform script file in geo-database integration environment；Pass through script integration tool DBIT perform script file and Manage Scripts
File summarizes under catalogue, comprising: the script file in each period, which summarizes, creates subdirectory under the path of catalogue；In verification library
Middle perform script file judges whether script file is abnormal, and abnormal script file is imported to the script of current slot
File summarizes the subdirectory under catalogue；Non- abnormal script file is executed in formal library, and by the script after running succeeded
File appending is to edition upgrading script file；The session control in verification library is removed, rebuilds verification library using formal library.The present invention
Technical solution solve in software development process, the production of the continuous integrating of oralce database and upgrade script file, with
And provide the solution of a script file management.Since the prior art is to carry out complexity to script file according to grammer to test
Card, and verification result and bad, technical solution of the present invention executes script in verification library, solves cumbersome script grammer
Verifying work.What the present invention innovated is converted into: direct perform script, is then caught the exception by java program in implementation procedure
Mode carry out error correction.Technical solution of the present invention is switched to by judging in advance by conclusion reverse-direction derivation.Either path in the present invention
Creation, the verifying of script, the execution of script, Database Automatic Backup are executed automatically by script integration tool DBIT, nothing
Need manual intervention.Therefore in software development process, the continuous integrating of database can automate as far as possible, reduce to greatest extent
Workload increases the stability and correctness of database in integrated.
Detailed description of the invention
By reference to the following drawings, exemplary embodiments of the present invention can be more fully understood by:
Fig. 1 is a kind of side for database continuous integrating and script file management according to the preferred embodiment for the present invention
Method flow chart；
Fig. 2 is a kind of side for database continuous integrating and script file management according to the preferred embodiment for the present invention
Method flow chart；And
Fig. 3 is to be for database continuous integrating and script file management according to a kind of of the preferred embodiment for the present invention
System structure chart.
Specific embodiment
Exemplary embodiments of the present invention are introduced referring now to the drawings, however, the present invention can use many different shapes
Formula is implemented, and is not limited to the embodiment described herein, and to provide these embodiments be at large and fully disclose
The present invention, and the scope of the present invention is sufficiently conveyed to person of ordinary skill in the field.Show for what is be illustrated in the accompanying drawings
Term in example property embodiment is not limitation of the invention.In the accompanying drawings, identical cells/elements use identical attached
Icon note.
Unless otherwise indicated, term (including scientific and technical terminology) used herein has person of ordinary skill in the field
It is common to understand meaning.Further it will be understood that with the term that usually used dictionary limits, should be understood as and its
The context of related fields has consistent meaning, and is not construed as Utopian or too formal meaning.
Fig. 1 is a kind of side for database continuous integrating and script file management according to the preferred embodiment for the present invention
Method flow chart.When software development, need first to establish a database version.It is each in the cataloged procedure of actual software exploitation
Position designer, Developmental Engineer before the coding will design database table in advance structure, various constraints, index, view etc.
Database object and preset data.The team unity that complicated system requires several engineers is completed.And for consistency
Everybody often faces the same database, and every day, everyone may modify to this database.This mistake
Journey we with the mode of script file submit to database execute.So the management of script file, geo-database integration is one non-
Often important work.As shown in Figure 1, a kind of method for database continuous integrating and script file management, method include:
Preferably, in step 101: script file is committed to the script of the current slot under script file administrative directory
File summarizes under catalogue, the perform script file in geo-database integration environment.
Preferably, in step 102: summarizing mesh by script integration tool DBIT perform script file and Manage Scripts file
Under record, comprising: the script file in each period, which summarizes, creates subdirectory under the path of catalogue；The perform script in verification library
File judges whether script file is abnormal, and the script file that abnormal script file imports current slot is summarized mesh
Subdirectory under record；Non- abnormal script file is executed in formal library, and the script file after running succeeded is appended to
Edition upgrading script file.
The application handles script file in each cycle, and the DDL and DML order operated is extracted respectively, and exists first
Being driven in verification library by ojdbc calls database execution method to execute DDL operation, if dishing out any exception in implementation procedure
It will be captured by java try-catch, while this document should be removed to memory, then file itself is sheared to " execution failure foot
Originally it " is appended in " supporting paper .txt " under path and by error log.Here " supporting paper .txt " is also memory-resident,
So as to real-time update.Memory write-back hard disk simultaneously is refreshed in each more new capital.DML operation is continued to execute if success, if lost
It loses to duplication DDL and executes the operation of failure.Indicate that the script file submitted is correct if success, at this moment by language in script file
Sentence executes on formal library.Content for script is appended to edition upgrading script after running succeeded.Such step is literary by whole scripts
Part processing is completed.
Preferably, method further include: java standard library and verification library are created in database environment, java standard library is after continuous integrating
For formal library.
Preferably, method further include: define the naming rule of script file.Preferably, naming rule are as follows: date _ submission
People's name _ module name _ illustrates .txt.
The application creates subdirectory in the case where daily script summarizes path using Java I/O technology first, entitled " to execute failure
Script ", and create " supporting paper .txt " wherein.Then the script file submitted daily is loaded into memory, is stored in
In List<File>set, inspection name authority is circuited sequentially, does not meet the removal memory of name authority and by script file
It itself clips in " executing failure script " catalogue, while incongruent reason being written in " supporting paper .txt "
Preferably, script integration tool DBIT is by java language development, including pre-set timed task, timed task
It is executed by task framework Quartz.
Preferably, subdirectory further includes text file, and text file is used to record the abnormal cause of script file.
Preferably, geo-database integration environment is oracle database the integration environment.
Preferably, by the way of submitting script file, continuous integrating is carried out to database.
Preferably, script file include: not same date, different submitter and disparate modules script file.
Preferably, the script file for the current slot that script file is committed under script file administrative directory is summarized into mesh
Under record, comprising:
The script file of current slot, which summarizes catalogue, to be automatically generated by date by script integration tool DBIT, is generated
Time is after having executed proxima luce (prox. luc) script.
Preferably, the session control in verification library is removed, rebuilds verification library using formal library.In the application, automated back-up
Then formal library empties and kills all session in verification library, then delete verification library, and with formal library backup file
Rebuild verification library.This sequence of operations is called using java by the way of errorlevel.Batch processing executes oracle exp order,
Formal library is exported with dmp file format to backup path；Then alter system kill session order is executed to kill
Fall the session in all connectivity verification libraries, then execute drop user and delete verification library, finally executes create user order weight
It builds, and all correlation oracle permissions of grant and role.This guarantees that verification library is consistent with formal library always, so that exist next time
Pre-execution in verification library can be consistent in formal library implementation effect.It is miscellaneous numerous that embodiments of the present invention eliminate weight well
Trivial script verifying is achieved the same effect and more succinct by the way of pre-execution, also prevents script verifying band
The incomplete problem of verification come.
Fig. 2 is a kind of side for database continuous integrating and script file management according to the preferred embodiment for the present invention
Method flow chart.To the continuous integrating of oracle database, the mode for submitting script file is taken.Not same date, different submitters,
Disparate modules may all have script file, in order to manage well and location of mistake, it is desirable that the name of the script file of submission is advised
Then as follows: " date _ submitter's name _ module name _ illustrates .txt.The application is with oracle the integration environment specially come perform script.
The integration environment includes a database environment, script integration tool DBIT and script administrative directory.Each submitter can be by script
The same day script being committed under script administrative directory summarizes under catalogue, which is to lead into script integration tool DBIT by date certainly
Dynamic generation, generating the time is after having executed proxima luce (prox. luc) script.Database environment includes oracle java standard library and verification library.
This java standard library is exactly the formal library after continuous integrating, and verification library is the environment of script pre-execution.Execution and foot for script
This administrative directory is managed collectively automatically by script integration tool DBIT.Script integration tool DBIT is inside set by java language development
Timed task, such as 10 points of each night period startings.Here it is realized using java timed task frame Quartz.Such as Fig. 2
Shown, kind includes: for database continuous integrating and the method for script file management
1, subdirectory is created in the case where daily script summarizes path using Java I/O technology first, it is entitled " to execute failure foot
This ", and create " supporting paper .txt " wherein.Then the script file for holding friendship daily is loaded into memory, be stored in List <
In File > set, inspection name authority is circuited sequentially, file itself is simultaneously clipped to and " execute failure by incongruent removal memory
In script " catalogue, while incongruent reason being written in " supporting paper .txt ".
2, script file is handled in each cycle, and the DDL and DML order operated is extracted respectively, and is verifying first
Being driven on library by ojdbc calls database execution method to execute DDL operation, if any exception of dishing out in implementation procedure all can
Captured by java try-catch, at the same should file remove memory, then file itself is sheared to " execute failure script " road
It is appended in " supporting paper .txt " under diameter and by error log.Here " supporting paper .txt " is also memory-resident, so as to
Real-time update.Memory write-back hard disk simultaneously is refreshed in each more new capital.DML operation is continued to execute if success, if failure is extremely
Replicate the operation that DDL executes failure.It indicates that the script file submitted is correct if success, at this moment sentence in script file exists
It is executed on formal library.Script file content is appended to edition upgrading script file after running succeeded.Such step is by whole feet
This document processing is completed.
3, then the formal library of automated back-up empties and kills all session in verification library, then deletes verification library,
And with formal library backup file reconstruction verification library.This sequence of operations is called using java by the way of errorlevel.Batch processing
Oracle exp order is executed, formal library is exported with dmp file format to backup path；Then alter system is executed
Kill session order kills the session in all connectivity verification libraries, then executes drop user and deletes verification library, finally executes
Create user order is rebuild, and all correlation oracle permissions of grant and role.This guarantee verification library always with formal library
Unanimously, enable the pre-execution next time in verification library consistent in formal library implementation effect.Presently filed embodiment
The miscellaneous cumbersome script verifying of weight is eliminated well, is achieved the same effect by the way of pre-execution and more succinct,
It also prevents script verifying bring and verifies incomplete problem.
Because oracle includes blob, the field types such as clob, sql script is difficult to carry out.Integrated approach of the invention,
It supports to submit dmp file.Operation execution sequence 2 above finally completes.Because dmp file content is invisible, Ke Nengyou
More unrelated tables are exported in the maloperation of submitter, it at this moment can coverage criteria library.So script integration tool DBIT needs to read
Dmp File header information confirms that it only includes a table and includes blob, the field of clob type.
In order to guarantee the correctness of script file submission, specification sql redaction rule exports the preparation of dmp file.Daily need
Pay attention to submitting the correctness of script.The script edit rule of designer's to master oracle；And understand the Business Stream of system
Journey and development technique；The script quality that finally also periodically submit to personnel is examined, and allows pay attention to script all member's moment
Normalization and correctness.
About before submission script is to script integration tool DBIT, everyone should confirm the enforceability of script, this
An environment completely the same with java standard library is needed for test.Script file integration tool is feared standby to direction machine creation number
According to the function in library.As long as script file submitter sends one " library is built in request " order to integration tool, integration tool can be automatic
Nearest standard library backup file is exported into creation test library to target machine.Java design pattern thought, message are used herein
Request and response, database command, the mode that the technologies such as batch processing scheduling combine are realized.
In order to guarantee the correctness of script submission, specification sql redaction rule exports the preparation of dmp file.It is daily to exploitation
The training of personnel and standardized management are also critically important.For experienced person, timed reminding and supervision, makes the entirely group of exploitation
The conscious correctness for paying attention to submitting script of team.For newcomer, it giveed training, be instructed, it is made to grasp oracle
Script edit rule；And professional training is carried out to it, allow it to understand the operation flow and development technique of system；Finally also to determine
Phase examines the script quality that personnel submit, and allows pay attention to the normalization and correctness of script all member's moment.About
Before submission script is to script integration tool, everyone should confirm the enforceability of script, this needs one and java standard library
Completely the same environment is for test.Script integration tool is feared standby to the function of being directed toward machine creation database.As long as script mentions
People is handed over to send one " library is built in request " order to integration tool, integration tool can be automatically by nearest standard library backup file to mesh
Mark machine export creation test library.Java design pattern thought, message request and response, database command, at batch are used herein
The mode that the technologies such as reason scheduling combine is realized.
Fig. 3 is to be for database continuous integrating and script file management according to a kind of of the preferred embodiment for the present invention
System structure chart.As shown in figure 3, a kind of system for database continuous integrating and script file management, system include:
Submit unit 301, the script of the current slot for being committed to script file under script file administrative directory
File summarizes under catalogue, the perform script file in geo-database integration environment；
Integrated unit 302, for summarizing mesh by script integration tool DBIT perform script file and Manage Scripts file
Under record, comprising: the script file in each period, which summarizes, creates subdirectory under the path of catalogue；The perform script in verification library
File judges whether script file is abnormal, and the script file that abnormal script file imports current slot is summarized mesh
Subdirectory under record；Non- abnormal script file is executed in formal library, and the script file after running succeeded is appended to
Edition upgrading script file.
The application handles script file in each cycle, and the DDL and DML order operated is extracted respectively, and exists first
Being driven in verification library by ojdbc calls database execution method to execute DDL operation, if dishing out any exception in implementation procedure
It will be captured by java try-catch, while this document should be removed to memory, then file itself is sheared to " execution failure foot
Originally it " is appended in " supporting paper .txt " under path and by error log.Here " supporting paper .txt " is also memory-resident,
So as to real-time update.Memory write-back hard disk simultaneously is refreshed in each more new capital.DML operation is continued to execute if success, if lost
It loses to duplication DDL and executes the operation of failure.Indicate that the script file submitted is correct if success, at this moment by language in script file
Sentence executes on formal library.Content for script is appended to edition upgrading script after running succeeded.Such step is literary by whole scripts
Part processing is completed.
Preferably, system further include: define the naming rule of script file.Preferably, naming rule are as follows: date _ submission
People's name _ module name _ illustrates .txt.
Preferably, script integration tool DBIT is by java language development, including pre-set timed task, timed task
It is executed by task framework Quartz.
Preferably, subdirectory further includes text file, and text file is used to record the abnormal cause of script file.
Preferably, geo-database integration environment is oracle database the integration environment.
Preferably, by the way of submitting script file, continuous integrating is carried out to database.
Preferably, script file include: not same date, different submitter and disparate modules script file.
Preferably, the script file for the current slot that script file is committed under script file administrative directory is summarized into mesh
Under record, comprising:
The script file of current slot, which summarizes catalogue, to be automatically generated by date by script integration tool DBIT, is generated
Time is after having executed proxima luce (prox. luc) script.
Preferably, further include establishing unit, be used to create java standard library in database environment and verification library, java standard library are being held
The formal library sequel Cheng Houwei.
Preferably, the session control in verification library is removed, rebuilds verification library using formal library.In the application, automated back-up
Then formal library empties and kills all session in verification library, then delete verification library, and with formal library backup file
Rebuild verification library.This sequence of operations is called using java by the way of errorlevel.Batch processing executes oracle exp order,
Formal library is exported with dmp file format to backup path；Then alter system kill session order is executed to kill
Fall the session in all connectivity verification libraries, then execute drop user and delete verification library, finally executes create user order weight
It builds, and all correlation oracle permissions of grant and role.This guarantees that verification library is consistent with formal library always, so that exist next time
Pre-execution in verification library can be consistent in formal library implementation effect.It is miscellaneous numerous that embodiments of the present invention eliminate weight well
Trivial script verifying is achieved the same effect and more succinct by the way of pre-execution, also prevents script verifying band
The incomplete problem of verification come.
The present invention is described by reference to a small amount of embodiment.However, it is known in those skilled in the art, as
Defined by subsidiary Patent right requirement, in addition to the present invention other embodiments disclosed above equally fall in it is of the invention
In range.
Normally, all terms used in the claims are all solved according to them in the common meaning of technical field
It releases, unless in addition clearly being defined wherein.All references " one/described/be somebody's turn to do [device, component etc.] " are all opened ground
At least one example being construed in described device, component etc., unless otherwise expressly specified.Any method disclosed herein
Step need not all be run with disclosed accurate sequence, unless explicitly stated otherwise.
Claims (20)
1. a kind of method for database continuous integrating and script file management, which comprises
The script file for the current slot that script file is committed under script file administrative directory is summarized under catalogue, in data
The script file is executed in the integration environment of library；
The script file, which is executed, by script integration tool DBIT and manages the script file summarizes under catalogue, comprising:
Script file in each period, which summarizes, creates subdirectory under the path of catalogue；
The perform script file in verification library judges whether the script file is abnormal, and by the abnormal script file
The script file for importing current slot summarizes the subdirectory under catalogue；
The non-abnormal script file is executed in formal library, and the script file after running succeeded is appended to version liter
Grade script file；
The session control in the verification library is removed, rebuilds verification library using the formal library.
2. according to the method described in claim 1, further include: java standard library and verification library, the mark are created in database environment
Quasi- library is formal library after continuous integrating.
3. according to the method described in claim 1, further include:
Define the naming rule of the script file.
4. according to the method described in claim 3, the naming rule are as follows:
Date _ submitter's name _ module name _ illustrates .txt.
5. according to the method described in claim 1, the script integration tool DBIT is by java language development, including presetting
Timed task, the timed task executes by task framework Quartz.
6. the text file is for recording institute according to the method described in claim 1, the subdirectory further includes text file
State the abnormal cause of script file.
7. according to the method described in claim 1, the geo-database integration environment is oracle database the integration environment.
8. according to the method described in claim 1, carrying out continuing collection to the database by the way of submitting script file
At.
9. according to the method described in claim 1, the script file includes: not same date, different submitter and disparate modules
Script file.
10. according to the method described in claim 1, described when script file is committed to current under script file administrative directory
Between the script file of section summarize under catalogue, comprising:
The script file of the current slot, which summarizes catalogue, to be automatically generated by date by script integration tool DBIT, is generated
Time is after having executed proxima luce (prox. luc) script.
11. a kind of system for database continuous integrating and script file management, the system comprises:
Unit is submitted, the script file of the current slot for script file to be committed under script file administrative directory summarizes
Under catalogue, the script file is executed in geo-database integration environment；
Integrated unit summarizes mesh for executing the script file by script integration tool DBIT and managing the script file
Under record, comprising:
Script file in each period, which summarizes, creates subdirectory under the path of catalogue；
The perform script file in verification library judges whether the script file is abnormal, and by the abnormal script file
The script file for importing current slot summarizes the subdirectory under catalogue；
The non-abnormal script file is executed in formal library, and the script file after running succeeded is appended to version liter
Grade script file；
The session control in the verification library is removed, rebuilds verification library using the formal library.
12. system according to claim 11 further includes establishing unit, for created in database environment java standard library and
Verification library, the java standard library are formal library after continuous integrating.
13. system according to claim 11, further includes:
Define the naming rule of the script file.
14. system according to claim 13, the naming rule are as follows:
Date _ submitter's name _ module name _ illustrates .txt.
15. system according to claim 11, the script integration tool DBIT is set by java language development, including in advance
The timed task set, the timed task are executed by task framework Quartz.
16. system according to claim 11, the subdirectory further includes text file, and the text file is for recording
The abnormal cause of the script file.
17. system according to claim 11, the geo-database integration environment is oracle database the integration environment.
18. system according to claim 11 carries out the database to continue collection by the way of submitting script file
At.
19. system according to claim 11, the script file includes: not same date, different submitters and different moulds
The script file of block.
20. system according to claim 11, it is described script file is committed to it is current under script file administrative directory
The script file of period summarizes under catalogue, comprising:
The script file of the current slot, which summarizes catalogue, to be automatically generated by date by script integration tool DBIT, is generated
Time is after having executed proxima luce (prox. luc) script.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811056204.1A CN109271199B (en) | 2018-09-11 | 2018-09-11 | Method and system for database continuous integration and script file management |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811056204.1A CN109271199B (en) | 2018-09-11 | 2018-09-11 | Method and system for database continuous integration and script file management |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109271199A true CN109271199A (en) | 2019-01-25 |
| CN109271199B CN109271199B (en) | 2023-01-10 |
Family
ID=65188409
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811056204.1A Active CN109271199B (en) | 2018-09-11 | 2018-09-11 | Method and system for database continuous integration and script file management |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109271199B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111104155A (en) * | 2019-11-29 | 2020-05-05 | 北京浪潮数据技术有限公司 | Database script management platform and method, electronic equipment and storage medium |
| CN111209719A (en) * | 2019-12-31 | 2020-05-29 | 西安翔腾微电子科技有限公司 | Method, device, equipment and storage medium for automatically realizing IC design environment |
| CN112685077A (en) * | 2020-12-29 | 2021-04-20 | 平安普惠企业管理有限公司 | Data modification method, system, computer device and computer readable storage medium |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2003345594A (en) * | 2002-05-28 | 2003-12-05 | Japan Research Institute Ltd | Script file generating device and method for structuring data base |
| US6985901B1 (en) * | 1999-12-23 | 2006-01-10 | Accenture Llp | Controlling data collection, manipulation and storage on a network with service assurance capabilities |
| US20070136311A1 (en) * | 2005-11-29 | 2007-06-14 | Ebay Inc. | Method and system for reducing connections to a database |
| CN101694626A (en) * | 2009-09-30 | 2010-04-14 | 曙光信息产业(北京)有限公司 | Script execution system and method |
| CN101739340A (en) * | 2009-12-17 | 2010-06-16 | 金蝶软件（中国）有限公司 | Method and device for verifying script file |
| US20110055807A1 (en) * | 2009-08-31 | 2011-03-03 | Accenture Global Services Gmbh | Integration environment generator |
| CN103279419A (en) * | 2013-06-09 | 2013-09-04 | 浪潮电子信息产业股份有限公司 | Automation version verifying method and system based on B/S structural system |
| CN104239583A (en) * | 2014-10-14 | 2014-12-24 | 北京国双科技有限公司 | Method and device for processing issued result of database script |
| CN105094961A (en) * | 2015-08-11 | 2015-11-25 | 北京思特奇信息技术股份有限公司 | Task scheduling management system based on quartz frame and method thereof |
| CN107092557A (en) * | 2017-03-24 | 2017-08-25 | 广东网金控股股份有限公司 | A kind of database schema upgrade script verification method and device |
-
2018
- 2018-09-11 CN CN201811056204.1A patent/CN109271199B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6985901B1 (en) * | 1999-12-23 | 2006-01-10 | Accenture Llp | Controlling data collection, manipulation and storage on a network with service assurance capabilities |
| JP2003345594A (en) * | 2002-05-28 | 2003-12-05 | Japan Research Institute Ltd | Script file generating device and method for structuring data base |
| US20070136311A1 (en) * | 2005-11-29 | 2007-06-14 | Ebay Inc. | Method and system for reducing connections to a database |
| US20110055807A1 (en) * | 2009-08-31 | 2011-03-03 | Accenture Global Services Gmbh | Integration environment generator |
| CN101694626A (en) * | 2009-09-30 | 2010-04-14 | 曙光信息产业(北京)有限公司 | Script execution system and method |
| CN101739340A (en) * | 2009-12-17 | 2010-06-16 | 金蝶软件（中国）有限公司 | Method and device for verifying script file |
| CN103279419A (en) * | 2013-06-09 | 2013-09-04 | 浪潮电子信息产业股份有限公司 | Automation version verifying method and system based on B/S structural system |
| CN104239583A (en) * | 2014-10-14 | 2014-12-24 | 北京国双科技有限公司 | Method and device for processing issued result of database script |
| CN105094961A (en) * | 2015-08-11 | 2015-11-25 | 北京思特奇信息技术股份有限公司 | Task scheduling management system based on quartz frame and method thereof |
| CN107092557A (en) * | 2017-03-24 | 2017-08-25 | 广东网金控股股份有限公司 | A kind of database schema upgrade script verification method and device |
Non-Patent Citations (1)
| Title |
|---|
| 唐世渭 等: "DBIT---一个数据库集成工具", 《第九届全国数据库学术会议论文集（下）》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111104155A (en) * | 2019-11-29 | 2020-05-05 | 北京浪潮数据技术有限公司 | Database script management platform and method, electronic equipment and storage medium |
| CN111209719A (en) * | 2019-12-31 | 2020-05-29 | 西安翔腾微电子科技有限公司 | Method, device, equipment and storage medium for automatically realizing IC design environment |
| CN112685077A (en) * | 2020-12-29 | 2021-04-20 | 平安普惠企业管理有限公司 | Data modification method, system, computer device and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109271199B (en) | 2023-01-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10013248B2 (en) | Reducing downtime during upgrades of interrelated components in a database system | |
| US8671084B2 (en) | Updating a data warehouse schema based on changes in an observation model | |
| US8112742B2 (en) | Method and system for debugging data integration applications with reusable synthetic data values | |
| US6151608A (en) | Method and system for migrating data | |
| US6564215B1 (en) | Update support in database content management | |
| EP2610762A1 (en) | Database version management system | |
| CN109271199A (en) | A kind of method and system for database continuous integrating and script file management | |
| US20100088286A1 (en) | Deployment manager for master data management | |
| US20240143386A1 (en) | Using multiple blockchains for applying transactions to a set of persistent data objects in persistent storage systems | |
| CN102750610A (en) | Transaction control method in product lifecycle phase management-enterprise resource planning (PLM-ERP) integration process | |
| US20110153574A1 (en) | Method for safeguarding the integrity of a relational database in case of structural transaction execution | |
| US8584117B2 (en) | Method to make SMP/E based products self describing | |
| CN116226092B (en) | Database updating method and device | |
| Alapati et al. | Oracle Database 11g: New Features for DBAs and Developers | |
| Marks | A metadata driven approach to performing multi-vendor database schema upgrades | |
| CN117422285A (en) | Operation flow inheritance method | |
| Ravikumar et al. | Database Upgrade Methods | |
| Glag | Efficient Software Development with DB2 for OS/390: Organizational and Technical Measures for Performance Optimization | |
| Madrid | Oracle 10g/11g Data and Database Management Utilities | |
| Burns et al. | Oracle Database Upgrade Guide, 10g Release 2 (10.2) B14238-01 | |
| Burns et al. | Oracle Database Upgrade Guide, 10g Release 2 (10.2) B14238-02 | |
| Chan | Oracle Database Performance Tuning Guide, 11g Release 1 (11.1) B28274-02 | |
| Chan | Oracle Database Performance Tuning Guide, 10g Release 2 (10.2) B14211-03 | |
| Miquel | Oracle Fusion Middleware Developer's Guide for Oracle Data Integrator, 11g Release 1 (11.1. 1) E12643-03 | |
| Chan | Oracle Database Performance Tuning Guide, 10g Release 2 (10.2) B14211-01 |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |