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 PDF

Info

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
Application number
CN201811056204.1A
Other languages
Chinese (zh)
Other versions
CN109271199B (en
Inventor
于强
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Aisino Corp
Original Assignee
Aisino Corp
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 Aisino Corp filed Critical Aisino Corp
Priority to CN201811056204.1A priority Critical patent/CN109271199B/en
Publication of CN109271199A publication Critical patent/CN109271199A/en
Application granted granted Critical
Publication of CN109271199B publication Critical patent/CN109271199B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/70Software maintenance or management
    • G06F8/71Version 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

A kind of method and system for database continuous integrating and script file management
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.
CN201811056204.1A 2018-09-11 2018-09-11 Method and system for database continuous integration and script file management Active CN109271199B (en)

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)

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

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

Patent Citations (10)

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

* Cited by examiner, † Cited by third party
Title
唐世渭 等: "DBIT---一个数据库集成工具", 《第九届全国数据库学术会议论文集(下)》 *

Cited By (3)

* Cited by examiner, † Cited by third party
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
CN112860540B (en) Software version upgrade test control system and method
CN116226092B (en) Database updating method and device
CN102750610A (en) Transaction control method in product lifecycle phase management-enterprise resource planning (PLM-ERP) integration process
US8521698B2 (en) Method for safeguarding the integrity of a relational database in case of structural transaction execution
US20100146498A1 (en) Method to make smp/e based products self describing
Alapati et al. Oracle Database 11g: New Features for DBAs and Developers
CN118733071A (en) Data version difference comparison system and method based on data management model
CN118779302A (en) Data migration method, device, equipment and medium of pension management system
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
Burns et al. Oracle Database Upgrade Guide, 10g Release 2 (10.2) B14238-02
Burns et al. Oracle Database Upgrade Guide, 10g Release 2 (10.2) B14238-01
Chan Oracle Database Performance Tuning Guide, 11g Release 1 (11.1) B28274-02
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