CN108228223A - Multi-type database based on domestic CPU environment unifies increment updating method - Google Patents
Multi-type database based on domestic CPU environment unifies increment updating method Download PDFInfo
- Publication number
- CN108228223A CN108228223A CN201711014189.XA CN201711014189A CN108228223A CN 108228223 A CN108228223 A CN 108228223A CN 201711014189 A CN201711014189 A CN 201711014189A CN 108228223 A CN108228223 A CN 108228223A
- Authority
- CN
- China
- Prior art keywords
- database
- xml
- file
- modification
- type
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2358—Change logging, detection, and notification
Abstract
The invention discloses the multi-type databases based on domestic CPU environment to unify increment updating method, the method library information according to the input data, including IP address, port numbers, Instance Name, user name, password, connect benchmark database, it exports general database XML and describes file, file is described as benchmark XML database, has recorded table, data, the view of database；It describes to modify on file in this benchmark XML database, the incremental update of database.The present invention simplifies developer's database maintenance and operates and promote the normalization of SQL：Developer need not pay close attention to specific database, it is only necessary to according to modification specification modification XML file, and submit control platform.When subsequent project needs to support a new Domestic Database, only it need to increase adaptation new database, developer need not pay close attention to new database SQL grammer.
Description
Technical field
The present invention relates to database technical fields, and in particular to a kind of multi-type database system based on domestic CPU environment
One increment updating method.
Background technology
In recent years, country vigorously supports the development of the full homemade software and hardware with independent intellectual property right, has emerged in large numbers with domestic
Operating system and numerous basic software and hardware products with independent intellectual property right that CPU is representative.Get the bid kylin system, depth behaviour
Make the domestic operating system ecological environment such as system to be gradually improved, Godson, soaring etc. has the high-end general core of independent intellectual property right
Piece flourishes, and technical merit reaches or the advanced international standard close to similar product.
With flourishing for domestic basic software and hardware, the popularization and use of domestic basis software and hardware bring unprecedented
Opportunity.Database is more based on having been emerged in the environment of domestic operating system and CPU as a ring important in ecological environment
Kind Domestic Database.
Currently based on being applied under the full domestic environment of domestic CPU and operating system, ecology is increasingly perfect, and database field is gushed
Multiple types of data library is showed, including magic database, golden storehouse database, up to dream database.WEB should under full domestic environment
Support remarkable ability is needed with system, up to a variety of Domestic Databases such as dream, Jin Cang, to meet the needs of different clients.Daily WEB application
During system iterative development, need frequently to change the database of system relationship.
Between disparate databases there are keyword disunity, support data type is also not quite identical, SQL statement grammer lattice
The problems such as inconsistent, the included function of formula differs.
General database development flow writes the SQL statement of various databases and connects database respectively for developer
Test, SQL tests are aggregated into SQL files by final finishing and submit the version control systems such as SVN, for being shared between developer
File and the convenient personnel that subsequently give out a contract for a project obtain upgrade file.
Developer needs to learn and grasp the SQL syntaxes of various Domestic Databases, for being write on disparate databases pair
The SQL statement answered simultaneously is tested, and submits the corresponding SQL files of various databases to version control system, for developer
Between shared file and the convenient personnel that subsequently give out a contract for a project obtain upgrade file.
In addition the flexibility of the coding style difference of project team's exploitation member and data base manipulation statement SQL, causes SQL to write
Method is different, SQL is normative poor, and subsequent development is safeguarded and positioning problems are difficult.
The personnel that give out a contract for a project need SQL files corresponding from version control system detection disparate databases, according to the need to be sent
Number is asked to arrange SQL files and be packaged and issues field upgrade personnel, needs the correctness of SQL execution sequences.Field upgrade personnel
It needs to back up each database to be upgraded in advance, according to type of database, selects the SQL to be performed and pay close attention to every SQL execution
As a result.
In addition developer also needs to correctness of concern SQL statement execution sequence etc..If by the SQL of upgrade database
It is aggregated into file, over time, the problem of file directory is complicated easily occurs, SQL files are inconvenient to browse and information
What the problem of searching, increasing the maintenance of developer, the packing for personnel's database update file of giving out a contract for a project and upgrading personnel positioned
It is difficult.
When project scene needs once to upgrade multiple demands or upgrade history demand, database file detection it is cumbersome,
Database file arranges error-prone.When subsequent project needs to support new database, for the integrality of assurance function, need out
Hair personnel learn and grasp new database syntax form etc., increase new SQL file directorys for new database, change history
SQL is adapted to new database, modified SQL files is put under newly-increased SQL file directorys.
In addition SQL is aggregated into catalogue complexity in file, SQL files are inconvenient to browse and information searching, increase follow-up
Maintenance and the difficulty of positioning problems.During disposable update wilderness demand, database change is larger, needs to safeguard a large amount of SQL texts
Part, since SQL quantity is more, SQL relevances are strong, SQL file consolidations are extremely complex.
When batch updating demand, the SQL files of demand number set associative are more, and database change is big, SQL rely on and
Relevance is strong, and SQL file consolidations are extremely complex, error-prone.When some historic demand there are BUG by REOPEN when or leak before
During more some module, need to send historic demand to project.Due to being difficult to the history by some database table of SQL Fileviews
Demand is changed, and when updating historic demand set, easily occurs leaking more or occurring the mistakes such as legacy data database table structure, old table data
Covering project scene table structure and data.
Invention content
The technical problem to be solved by the present invention is to：The present invention is in view of the above problems, provide a kind of based on domestic CPU environment
Multi-type database unifies increment updating method.
By application database increment updating method, developer only needs literary according to specification is submitted to change database XML
Part, it is no longer necessary to pay close attention to various database SQL grammers, safeguard complicated SQL catalogues.By using XML database file, increase
The readability of upgrade file, maintainability can easily check by database XML file the whole of some database element
Historical changing.Follow-up data library upgrade file is packaged, and method numbers set and detects automatically and handle database XML according to demand
File and automatic packaging, field upgrade personnel need to only obtain upgrade package, the management platform that application method provides, input database letter
It ceases and selects upgrading APMB package, method automatically backup data library, analyzes XML file and generation meets database syntax to be upgraded
SQL statement realizes database incremental update, simplifies escalation process, upgrading when something goes wrong can be automatically extensive according to backup file
It is multiple.
The technical solution adopted in the present invention is：
Multi-type database based on domestic CPU environment unifies increment updating method, and the method according to the input data believe by library
Breath including IP address, port numbers, Instance Name, user name, password, connects benchmark database, exports general database XML and retouch
File is stated, file is described as benchmark XML database, has recorded table, data, the view of database；
It describes to modify on file in this benchmark XML database, the incremental update of database.
The method content further includes：
Describe that file is completed to the deployment of other databases, the stage updates, number is gathered as desired based on benchmark XML database
Update.
The database XML describes file sectional lists by modular organisation database table structure, table data, view, including mesh
It records and puts type convert file, Implib, module file, view file, wherein：
Catalogue has stored defined in type convert file the transformational relation of Domestic Database data type and XML database type,
Shield the data type difference of disparate databases；
Implib defines the correspondence of the table of module and database, and method can be according to each mould of this file generated
Block catalogue stores table and data under each module respectively；
Module file includes the relevant table structure XML file of the module and table data XML file；
The relevant all table information of the module are included in table structure XML file under each module.
The table of the database is stored in the attribute of XML element as an XML element, wherein table name, table remark information
In value, the daughter element of literary name section, table index, table constraint as XML element has recorded table essential information, literary name segment information, table rope
Fuse breath, major key foreign-key table constraint information, wherein：
Literary name segment information have recorded the field name of table, field type, whether empty, default value, each information is as the field element
An attribute；
Table index information has recorded the index information on table, including index name, index field；
Major-key table constraint information has recorded major key information on table, title, the field of each major key；
Foreign-key table constraint information has recorded the title, field and associated table name, field name of each external key.
The method supported in XML element " modification type ", " demand number ", " historic demand ", " joint demand ",
" sequence number " property value, by literary name segment information, table index information, major key foreign-key table constraint information element under increase son member
Element, the modification of further record sheet structure；
Each daughter element corresponds to primary modification operation, for recording a database table structure change.
The table data XML file, has recorded the data manipulation in table, and table data modification is supported to be inserted into, be deleted, update behaviour
Make, wherein：
Each XML element has recorded a data update operation, and a data update operation can be directed to modification database one
Record or a plurality of record.
The method further includes：
XML file changes specification, and table data, table structure are changed according to the XML file modification specification of agreement.
The modification of the table data, table structure is by the module where confirming table to be modified or data, in the module mesh
The lower modification table structured file of record or table database file；For each modification, XML element needs to increase " modification type ", " demand
Number ", " joint demand number ", " version number ", wherein：
It changes type and supports add, alter, delete, describe the modification type to the XML element；
This changes corresponding demand number to demand number record, is numbered according to demand convenient for the later stage and obtains XML in XML file
The modification of element；
After developer changes, modified database XML file is submitted to version control system.
The method is tested by table data XML file grammaticality and XML element modification is normative surveys, and tests table number
According to the correctness of XML file.
The method further includes the upgrading of database, and content includes：
It is numbered and gathered according to the demand of input, analyze XML database file first, verify the correctness of XML file one by one, successively
The XML element in XML file is analyzed, whether verification meets XML modification specifications；
Each XML file is analyzed one by one, and number set search XML changes content according to demand, retains in the modification in XML file
Hold, delete the XML element do not changed；
XML is described into XML file and is packaged into database upgrade packet.
Beneficial effects of the present invention are：
The method of the present invention simplifies developer's database maintenance and operates and promote the normalization of SQL：Developer has without paying close attention to
The database of body, it is only necessary to according to modification specification modification XML file, and submit control platform.Subsequent project needs to support one
During new Domestic Database, only it need to increase adaptation new database, developer need not pay close attention to new database SQL grammer.Relatively
The SQL that developer submits, tool is according to the SQL more specifications of XML database file generated.
Simplify and be packaged flow of giving out a contract for a project：Personnel and upgrading personnel give out a contract for a project without paying close attention to complicated SQL catalogues, aggregates demand
Relevant SQL statement.It is numbered according to the demand to be detected, detects database XML file from version control systems such as SVN automatically,
XML file is analyzed one by one, obtains database update content, is packaged into database upgrade packet, is sent upgrade package and is given project implementation people
Member.
Simplify the flow for implementing upgrade database：Implementation personnel are in management platform input database information provided by the invention
And upgrade package is selected, automatic remote backup database according to the type of database to be upgraded, automatically generates and performs SQL successively
Sentence, and upgrading more detailed logging is recorded, facilitate positioning problems and to unsuccessfully repairing, avoid occurring in manual upgrade procedure
The problem of.
Description of the drawings
Fig. 1 is table structure xsd model structures；
Fig. 2 is literary name section xsd model structures；
Fig. 3 is table major key xsd model structures；
Fig. 4 is table index xsd model structures；
Fig. 5 is off-balancesheet key xsd model structures；
Fig. 6 is view xsd model structures；
Fig. 7 is table data xsd model structures；
Fig. 8 changes xsd model structures for table（For to PUB_OPERATION_TYPE table handlings）；
Wherein, xsd, XML Schema language describe the structure of XML document.
Specific embodiment
Below according to Figure of description, with reference to specific embodiment, the present invention is further described：
Multi-type database based on domestic CPU environment unifies increment updating method, and the method according to the input data believe by library
Breath including IP address, port numbers, Instance Name, user name, password, connects benchmark database, exports general database XML and retouch
File is stated, file is described as benchmark XML database, has recorded table, data, view of database etc..
Developer subsequently describes to modify on file in this benchmark XML database, and the increment of database is more
Newly.
The method content further includes：
Describe that file is completed to the deployment of other databases, the stage updates, number is gathered as desired based on benchmark XML database
Update etc..
As a shown in Figure 6, the database XML describe file sectional lists by modular organisation database table structure, table data,
View, including catalogue storage type convert file, Implib, module file, view file, wherein：
Catalogue has stored defined in type convert file the transformational relation of Domestic Database data type and XML database type,
Shield the data type difference of disparate databases；
Implib defines the correspondence of the table of module and database, and method can be according to each mould of this file generated
Block catalogue stores table and data under each module respectively；
Module file includes the relevant table structure XML file of the module and table data XML file；
The relevant all table information of the module are included in table structure XML file under each module.
The table of the database is stored in the category of XML element as an XML element, the wherein information such as table name, table remarks
In property value, the daughter element as XML element such as literary name section, table index, table constraint, have recorded table essential information, literary name segment information,
The table constraints information such as table index information, major key external key, wherein：
As shown in Fig. 2, literary name segment information have recorded the field name of table, field type, whether sky, default value etc., each information is made
An attribute for the field element；
As shown in figure 4, table index information has recorded the index information on table, including index name, index field etc.；
As shown in figure 3, major-key table constraint information has recorded major key information on table, title, the field of each major key；
As shown in figure 5, foreign-key table constraint information has recorded the title, field and associated table name, field name of each external key.
The method supported in XML element " modification type ", " demand number ", " historic demand ", " joint demand ",
Property values such as " sequence numbers ", by literary name segment information, table index information, major key foreign-key table constraint information element under increase son
Element, the modification of further record sheet structure；
Each daughter element corresponds to primary modification operation, for recording a database table structure change.
The table data XML file, has recorded the data manipulation in table, and table data modification supports insertion, deletion, update etc.
Operation, wherein：
Each XML element has recorded a data update operation, and a data update operation can be directed to modification database one
Record or a plurality of record.
Store field to be updated in XML element attribute, storage condition field in where daughter element attributes.Field is supported more
Kind literary style type, including most basic " field name "=" field value " type, while supports subquery type, SQL statement type
Deng the grammers such as support " between and ", " not null ", " in ".Sequence number is used to ensure that SQL's performs sequence.
As shown in figure 8, the method further includes：
XML file changes specification, and table data, table structure are changed according to the XML file modification specification of agreement.
The modification of the table data, table structure is by the module where confirming table to be modified or data, in the module mesh
The lower modification table structured file of record or table database file；For each modification, XML element needs to increase " modification type ", " demand
The attributes such as number ", " joint demand number ", " version number ", wherein：
It changes type and supports the keywords such as add, alter, delete, describe the modification type to the XML element；Each element
Support a variety of modification types, such as the establishment of database, the establishment of user, the newly-increased of table, renaming, deletion etc., literary name section it is new
Increasing, deletion, renaming, type modification, the newly-increased of view, are deleted at modification, and the newly-increased of index, is deleted at modification, constraint it is newly-increased,
Modification, deletion etc.；
This changes corresponding demand number to demand number record, is numbered according to demand convenient for the later stage and obtains XML in XML file
The modification of element；
After developer changes, modified database XML file is submitted to the version control systems such as SVN.
The method is tested by table data XML file grammaticality and XML element modification is normative surveys, and tests table number
According to the correctness of XML file.
Management platform is provided by using method, developer can test the correctness of XML file, preview is given birth to based on XML
Into SQL, connecting test library perform SQL verification.XML correctness test include table data XML file grammaticality test and
The normative test of XML element modification.According to type of database and demand number set, method can be according to database XML file
The SQL statement of generation, developer can be gathered with the SQL that method for previewing automatically generates.Method can connecting test library, perform every
SQL statement simultaneously returns to every SQL operation and has inerrancy successively.
The method further includes the upgrading of database, and content includes：
It is numbered and gathered according to the demand of input, analyze XML database file first, verify the correctness of XML file one by one, successively
The XML element in XML file is analyzed, whether verification meets XML modification specifications；
Each XML file is analyzed one by one, and number set search XML changes content according to demand, retains in the modification in XML file
Hold, delete the XML element do not changed；
XML is described into XML file and is packaged into database upgrade packet, database upgrade packet is sent to project scene.
In addition the personnel that give out a contract for a project can also carry out upgrade package test in management platform.The input test data in management platform
Library information, method connecting test library, automatically generates SQL, is tested in test environment.
Implementation personnel obtain database upgrade APMB package, obtain the database information and liter of project field upgrade personnel input
Grade APMB package path, remote machine and perform script file backup database first where connection database, analyzes XML successively
Database file, generation meet the SQL statement of correspondence database type, and SQL statement, implementing result, implementation procedure etc. is recorded in
In journal file, and database of record upgrading date, upgrade requirement number and database change information, convenient for positioning problems, keep away
The problems such as exempting to omit update；According to " sequence number " attribute in XML element and built-in algorithm, ensure the correct of SQL execution sequences
Property；During upgrading failure（Such as network connection failure）, support by backing up file, to unsuccessfully repairing.
Embodiment is merely to illustrate the present invention, and not limitation of the present invention, the ordinary skill in relation to technical field
Personnel without departing from the spirit and scope of the present invention, can also make a variety of changes and modification, therefore all equivalent
Technical solution also belong to scope of the invention, scope of patent protection of the invention should be defined by the claims.
Claims (10)
1. the multi-type database based on domestic CPU environment unifies increment updating method, which is characterized in that the method is according to defeated
The database information entered including IP address, port numbers, Instance Name, user name, password, connects benchmark database, exports general
Database XML describes file, and file is described as benchmark XML database, has recorded table, data, the view of database；
It describes to modify on file in this benchmark XML database, the incremental update of database.
2. the multi-type database according to claim 1 based on domestic CPU environment unifies increment updating method, feature
It is, the method content further includes：
Describe that file is completed to the deployment of other databases, the stage updates, number is gathered as desired based on benchmark XML database
Update.
3. the multi-type database according to claim 1 or 2 based on domestic CPU environment unifies increment updating method,
It is characterized in that, the database XML describes file sectional lists by modular organisation database table structure, table data, view, including mesh
It records and puts type convert file, Implib, module file, view file, wherein：
Catalogue has stored defined in type convert file the transformational relation of Domestic Database data type and XML database type,
Shield the data type difference of disparate databases；
Implib defines the correspondence of the table of module and database, and method can be according to each mould of this file generated
Block catalogue stores table and data under each module respectively；
Module file includes the relevant table structure XML file of the module and table data XML file；
The relevant all table information of the module are included in table structure XML file under each module.
4. the multi-type database according to claim 3 based on domestic CPU environment unifies increment updating method, feature
It is, for the table of the database as an XML element, wherein table name, table remark information is stored in the property value of XML element
In, the daughter element of literary name section, table index, table constraint as XML element has recorded table essential information, literary name segment information, table index
Information, major key foreign-key table constraint information, wherein：
Literary name segment information have recorded the field name of table, field type, whether empty, default value, each information is as the field element
An attribute；
Table index information has recorded the index information on table, including index name, index field；
Major-key table constraint information has recorded major key information on table, title, the field of each major key；
Foreign-key table constraint information has recorded the title, field and associated table name, field name of each external key.
5. the multi-type database according to claim 4 based on domestic CPU environment unifies increment updating method, feature
It is, the method supports " modification type ", " demand number ", " historic demand ", " joint demand ", " sequence in XML element
Number " property value, by literary name segment information, table index information, major key foreign-key table constraint information element under increase daughter element, into
The modification of one-step recording table structure；
Each daughter element corresponds to primary modification operation, for recording a database table structure change.
6. the multi-type database according to claim 5 based on domestic CPU environment unifies increment updating method, feature
It is, the table data XML file, have recorded the data manipulation in table, table data modification is supported to be inserted into, be deleted, update operation,
Wherein：
Each XML element has recorded a data update operation, and a data update operation can be directed to modification database one
Record or a plurality of record.
7. the multi-type database according to claim 6 based on domestic CPU environment unifies increment updating method, feature
It is, the method further includes：
XML file changes specification, and table data, table structure are changed according to the XML file modification specification of agreement.
8. the multi-type database according to claim 7 based on domestic CPU environment unifies increment updating method, feature
It is, the modification of the table data, table structure is by the module where confirming table to be modified or data, under the module directory
Change table structured file or table database file；For each modification, XML element needs to increase " modification type ", " demand volume
Number ", " joint demand number ", " version number ", wherein：
It changes type and supports add, alter, delete, describe the modification type to the XML element；
This changes corresponding demand number to demand number record, is numbered according to demand convenient for the later stage and obtains XML in XML file
The modification of element；
After developer changes, modified database XML file is submitted to version control system.
9. the multi-type database according to claim 8 based on domestic CPU environment unifies increment updating method, feature
It is, the method is tested by table data XML file grammaticality and XML element modification is normative surveys, and tests table data
The correctness of XML file.
10. the multi-type database according to claim 9 based on domestic CPU environment unifies increment updating method, special
Sign is that the method further includes the upgrading of database, and content includes：
It is numbered and gathered according to the demand of input, analyze XML database file first, verify the correctness of XML file one by one, successively
The XML element in XML file is analyzed, whether verification meets XML modification specifications；
Each XML file is analyzed one by one, and number set search XML changes content according to demand, retains in the modification in XML file
Hold, delete the XML element do not changed；
XML is described into XML file and is packaged into database upgrade packet.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711014189.XA CN108228223A (en) | 2017-10-26 | 2017-10-26 | Multi-type database based on domestic CPU environment unifies increment updating method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711014189.XA CN108228223A (en) | 2017-10-26 | 2017-10-26 | Multi-type database based on domestic CPU environment unifies increment updating method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108228223A true CN108228223A (en) | 2018-06-29 |
Family
ID=62655691
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711014189.XA Pending CN108228223A (en) | 2017-10-26 | 2017-10-26 | Multi-type database based on domestic CPU environment unifies increment updating method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108228223A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112162992A (en) * | 2020-10-12 | 2021-01-01 | 浪潮软件集团有限公司 | Efficient database updating system and method |
| CN112632185A (en) * | 2020-12-16 | 2021-04-09 | 浪潮云信息技术股份公司 | Multi-type database synchronization method, device and equipment based on CPU environment |
| CN113238782A (en) * | 2021-06-02 | 2021-08-10 | 西安热工研究院有限公司 | Method and system for upgrading domestic Ruitang real-time database file |
| CN113485994A (en) * | 2021-07-21 | 2021-10-08 | 中共四川省委组织部 | Domestic database-based double-track operation method |
| CN113535727A (en) * | 2021-07-19 | 2021-10-22 | 北京数码大方科技股份有限公司 | Data output method and data output device of information system and electronic equipment |
| CN113688147A (en) * | 2021-09-07 | 2021-11-23 | 中国银行股份有限公司 | Data processing method and system |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5848405A (en) * | 1997-04-21 | 1998-12-08 | Oracle Corporation | Method and apparatus for identifying new data by address ranges |
| CN102402559A (en) * | 2010-09-16 | 2012-04-04 | 中兴通讯股份有限公司 | Database upgrade script generating method and device |
| CN102968327A (en) * | 2012-12-14 | 2013-03-13 | 沈阳美行科技有限公司 | Embedded POI (Point of Interest) data increment updating method supporting increment updating |
| CN103150348A (en) * | 2013-02-07 | 2013-06-12 | 国家基础地理信息中心 | Incremental updating method and system for GIS database |
| CN103377210A (en) * | 2012-04-19 | 2013-10-30 | 北京四维图新科技股份有限公司 | Method for creating incremental navigation database and method for updating same |
| CN104850611A (en) * | 2015-05-12 | 2015-08-19 | 浪潮集团有限公司 | Method for timing incremental data updating from relational database to non-relational database by using kettle |
| CN106446151A (en) * | 2016-09-22 | 2017-02-22 | 山东浪潮云服务信息科技有限公司 | Data migration and incremental updating method based on domestic CPU and database |
-
2017
- 2017-10-26 CN CN201711014189.XA patent/CN108228223A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5848405A (en) * | 1997-04-21 | 1998-12-08 | Oracle Corporation | Method and apparatus for identifying new data by address ranges |
| CN102402559A (en) * | 2010-09-16 | 2012-04-04 | 中兴通讯股份有限公司 | Database upgrade script generating method and device |
| CN103377210A (en) * | 2012-04-19 | 2013-10-30 | 北京四维图新科技股份有限公司 | Method for creating incremental navigation database and method for updating same |
| CN102968327A (en) * | 2012-12-14 | 2013-03-13 | 沈阳美行科技有限公司 | Embedded POI (Point of Interest) data increment updating method supporting increment updating |
| CN103150348A (en) * | 2013-02-07 | 2013-06-12 | 国家基础地理信息中心 | Incremental updating method and system for GIS database |
| CN104850611A (en) * | 2015-05-12 | 2015-08-19 | 浪潮集团有限公司 | Method for timing incremental data updating from relational database to non-relational database by using kettle |
| CN106446151A (en) * | 2016-09-22 | 2017-02-22 | 山东浪潮云服务信息科技有限公司 | Data migration and incremental updating method based on domestic CPU and database |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112162992A (en) * | 2020-10-12 | 2021-01-01 | 浪潮软件集团有限公司 | Efficient database updating system and method |
| CN112632185A (en) * | 2020-12-16 | 2021-04-09 | 浪潮云信息技术股份公司 | Multi-type database synchronization method, device and equipment based on CPU environment |
| CN113238782A (en) * | 2021-06-02 | 2021-08-10 | 西安热工研究院有限公司 | Method and system for upgrading domestic Ruitang real-time database file |
| CN113535727A (en) * | 2021-07-19 | 2021-10-22 | 北京数码大方科技股份有限公司 | Data output method and data output device of information system and electronic equipment |
| CN113535727B (en) * | 2021-07-19 | 2024-04-09 | 北京数码大方科技股份有限公司 | Data output method and device of information system and electronic equipment |
| CN113485994A (en) * | 2021-07-21 | 2021-10-08 | 中共四川省委组织部 | Domestic database-based double-track operation method |
| CN113688147A (en) * | 2021-09-07 | 2021-11-23 | 中国银行股份有限公司 | Data processing method and system |
| CN113688147B (en) * | 2021-09-07 | 2024-02-09 | 中国银行股份有限公司 | Data processing method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108228223A (en) | Multi-type database based on domestic CPU environment unifies increment updating method | |
| US7562357B2 (en) | Relational database schema version management | |
| US9009195B2 (en) | Software framework that facilitates design and implementation of database applications | |
| US8099400B2 (en) | Intelligent storing and retrieving in an enterprise data system | |
| US8386464B2 (en) | Configuration of optimized custom properties in a data finder tool | |
| US8010905B2 (en) | Open model ingestion for master data management | |
| US9251296B2 (en) | Interactively setting a search value in a data finder tool | |
| US11341171B2 (en) | Method and apparatus for implementing a set of integrated data systems | |
| EP1585036A2 (en) | Management of parameterized database queries | |
| US20030154191A1 (en) | Logical data modeling and integrated application framework | |
| US20040181753A1 (en) | Generic software adapter | |
| US20110153562A1 (en) | Error prevention for data replication | |
| US20200012661A1 (en) | Synchronizing resource type and property structures | |
| US6915313B2 (en) | Deploying predefined data warehouse process models | |
| Math | Database Schema Integration Process–A Methodology and Aspects of Its Applying | |
| CN104573053B (en) | A kind of configuration item template dynamic customization method based on XML | |
| WO2005055561A2 (en) | System and method for managing oss component configuration | |
| CN105630783A (en) | Database data migration system | |
| WO2008014387A2 (en) | Custom database system and method of building and operating the same | |
| Johnson | Accessing Data with Microsoft®. Net Framework 4 | |
| WO2005089350A2 (en) | Custom database system and method of building the same | |
| US20100070954A1 (en) | Custom database system and method of building and operating the same | |
| Jennings | Microsoft Access 2010 in depth | |
| Tok et al. | Microsoft SQL Server 2012 Integration Services | |
| Schneller et al. | Mysql Admin Cookbook Lite: Replication and Indexing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180629 |