CN103020285B - Integration across database supports automatic coding and the system of multi-field combination - Google Patents
Integration across database supports automatic coding and the system of multi-field combination Download PDFInfo
- Publication number
- CN103020285B CN103020285B CN201210580904.7A CN201210580904A CN103020285B CN 103020285 B CN103020285 B CN 103020285B CN 201210580904 A CN201210580904 A CN 201210580904A CN 103020285 B CN103020285 B CN 103020285B
- Authority
- CN
- China
- Prior art keywords
- coding
- module
- automatic
- database
- maximal value
- 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.)
- Active
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses automatic coding and system that a kind of integration across database supports multi-field combination, method comprise parameter configuration step, service setting up procedure and coding obtaining step, coding obtaining step comprise judge sub-step, export sub-step and coding register sub-step.Correspondingly, system comprise parameter configuration module, service start module and coding acquisition module, coding acquisition module comprise judge submodule, output sub-module and coding register submodule.The present invention can improve the concurrency of automatic coding effectively, and the portability of software development architecture is significantly improved, and when many places use automatic coding, adopts the present invention effectively can reduce size of code, improve tempo of development and coding quality.
Description
Technical field
The present invention relates to a kind of database automatic coding, particularly a kind of integration across database supports the automatic coding of multi-field combination.
Background technology
Database common at present has Oracle, MicrosoftSQLServer, MySql, DB2, Sybase and MicrosoftAccess, and their respective automatic numbering implementations are different.Except the coding method that these databases carry, in order to meet some special code requirement, people is also had to be realized by trigger, storing process or program code.
1, relevant prior art
a)Oracle
Oracle does not have defined good automatic numbering row, needs manual creation.Here is the conventional method creating Oracle automatic numbering row:
1). for the table that will add Oracle automatic numbering row creates index, the automatic numbering row that indexed row will realize after being exactly, such row are called the row of " ID " often.For the table HARD in scheme LY, arranging the SQL statement creating index to its hard_id is:
1.CREATEUNIQUEINDEXLY.HARDONLY.HARD(hard_id);
2). creating a minimum value is 1, and maximal value is not limit, and increment value is the sequence of 1.The establishment of sequence by OEM or can directly input SQL statement establishment equally.The SQL statement creating sequence is:
3). finally for table LY.HARD creates trigger, to realize when each inserting line, hard_id row increase progressively numbering automatically.Below for creating the SQL statement of trigger:
b)SQLServer
SQLServer adopts the mode of mark increment to realize automatic coding: first row are defined as integer int, then find " mark " " Column Properties " of this attribute field is inner, whether selection mark is wherein set to "Yes", and finally defining increment seed is again 1.
Also can adopt and use grammer to create automatic coding row, grammer is as follows:
1.CREATETABLE [table name word] (
2. [int] IDENTITY (1, the 1) NOTNULL that [certainly adds name],
3.。。。Other row
4.)
c)MySql
MySql adopts AUTO_INCREMENT attribute to be classified as automatic numbering to specify certain when building table, as:
1.CREATETABLE`mydatabase`.`mytable`(
2.`ID`INTEGERUNSIGNEDNOTNULLAUTO_INCREMENT,
3....
4....
5.PRIMARYKEY(`id`)
6.)
d)DB2
Mark is classified as DB2 provides a kind of method, can automatically for the every a line being added into table generates unique numeric.To new table definition identity column, ASIDENTITY clause to be used in CREATETABLE statement.When establishment one is shown, if need every a line unique identification being added into this table, so an identity column can be added to this table.Ensureing that the every a line for being added into table provides unique digital value, unique index should be defined at identity column, or being claimed as major key.
The value of identity column can " all the time " or " in default situations " be generated by DB2 database manager.By the value giving to be generated by DB2 database manager all the time to the identity column being defined as GENERATEDALWAYS (all the time), do not allow the value that application program provides explicit.The identity column being defined as GENERATEDBYDEFAULT (in default situations) enables application program explicitly provide value for identity column, if application program does not provide value, so DB2 is by generation one value; Because of by this value of application program controlling, so DB2 can not ensure the uniqueness of this value.Here is the example of a GENERATEDBYDEFAULT:
1.createtablemydatabase.mytable(
2.IDintgeneratedbydefaultasidentity,
3....
4....
5.)
e)Sybase
In Sybase, the method for fulfillment database automatic coding adopts Identity attribute to carry out identity column, the function class that identity follows the sequence object in Oracle to complete seemingly, but there is certain constraint, each table can only have the row of an identity, the type of row must be numberic (n, 0).Concrete establishment grammer is as follows:
1.createtabletable_name
2.(column_namenumeric(precision,0)identity)
f)MicrosoftAccess
In table during define field, the type being kept at data in literary name section can be specified by usage data attribute.An optional type is wherein had to be " automatic numbering ".After application the type, whenever add a new record in table, one that is specified by MicrosoftAccess unique serial number (at every turn increasing progressively 1) or random number.Automatic numbering field, accounts for 4 bytes (if FieldSize attribute is set to ReplicationID, being 16 bytes), and can not upgrade.
Can use NewValues attribute to specify in when being added in table by record, the incremental manner of " automatic numbering " field: increase progressively---(default value) be a newly-increased record often, and " automatic numbering " field value increases by 1; At random---an often newly-increased record, the value of " automatic numbering " field is designated as a random LongInteger value (when synchronous coping database, " automatic numbering " field arranges and will be set to " at random ", to guarantee that the new record be input in different copy has unique value).Concrete method of operating is in table " design " view, clicks the General tab in " field attribute " pane, in the attribute list of table, arranges this attribute.
G) trigger
Example is below application triggers in SQLServer database, realizes carrying out automatic coding to the character data in a table: Article 1 data encoding is ' FM00000 ', and Article 2 is ' FM00001 ', and Article 3 is " FM00002 ', the rest may be inferred.
1.CREATEtriggertest_triggerontest_table
2.forinsert
3.as
4.declarenext_seqint
5.selectnext_seq=(selectcast((selectsubstring(max(name),3,5)fromtest_table)asint)+1)
6.updatetest_table
7.setname=′FM′+right(′00000′+cast(next_seqasvarchar),5)
8.frominsertediwherei.id=test_table.id
9.GO
H) storing process
Example is below application memory process in SQLServer database, realizes carrying out automatic coding to carrying out bullets per year:
I) program code
Example below automatically produces class numbering with year for distinguishing for realizing in JAVA:
2, prior art defect
As can be seen from example representative above, the grammer not only creating automatic coding between various database is different, and is also not quite similar to the requirement of automatic coding row separately.This traditional database automatic coding mode, depends on concrete database, and automatic coding can not integration across database platform, causes system transplantation poor.
In addition, this automatic coding depending on concrete database only supports the sequential encoding to field itself, if this coding depends on other field (such as: the serial number of bank every day depends on the date, the class number of student depends on concrete class), the automatic coding that then can not directly be carried by database is realized, and must be realized by other modes such as trigger, storing process or program codes.And in traditional way, each acquisition automatic coding must search the maximal value in current database, namely call MAX function, the execution time of this function is long, if adopt the method when large concurrent data processing, easily cause bottleneck, reduce the whole efficiency of system.
Summary of the invention
The automatic coding that the object of the invention is to provide a kind of integration across database to support multi-field combination and system, solving automatic coding can not integration across database platform, the problem of not supporting multi-field to combine.
Technical scheme of the present invention is as follows:
Integration across database supports an automatic coding for multi-field combination, comprises the following steps:
Parameter configuration step, the parameter configuration item of input automatic coding, described parameter configuration item comprises type of database;
Service setting up procedure, loads described parameter configuration item, according to described type of database instantiation data bank interface, creates initial memory; Described storage space comprises storage organization and data content, described storage organization comprises table name, automatic coding field name, associate field name, automatic coding field current maximum and associate field and update time, described data content comprises the data item that zero to many meet this storage organization, and described initial memory comprises described storage organization and zero data item;
Coding obtaining step, provides the maximum coding of required coding to user, comprise and judge sub-step, output sub-step and coding registration sub-step;
Described judgement sub-step, obtains maximal value according to search criterion in described storage space, if obtain successfully, enters output sub-step, if obtain unsuccessfully, enters coding registration sub-step;
Described output sub-step, exports rule according to coding and exports next coding, and described update time is updated to current time;
Described coding registration sub-step, comprises and searches described maximal value; New data item is registered to described storage space; Return described maximal value; Enter output sub-step.
Method of the present invention repeatedly can use, improves internal memory operation speed by primary retrieval.
Further, described database interface comprises maximal value and searches interface function.
Described coding registration sub-step comprises further: search interface function by described maximal value and search described maximal value, if do not found, then using default value as described maximal value.
Further, described storage organization comprises described coding gain and coded format further;
The method is further comprising the steps:
Customization coding exports rule step, described coding output rule comprises coding and increases progressively rule and coding output format, described coding increases progressively rule for regulation coding gain, described coding gain is defaulted as 1, described coding output format is for specifying described coded format, and described coded format is defaulted as integer.
Further, described coding registration sub-step comprises lock step and unlocked step further;
Lock step, described search described maximal value before lock registration and search code block;
Unlocked step, after registering new data item to described storage space, described return described maximal value before unlock this registration and search code block.
The present invention prevents reading and writing data conflict by minimum locking.
Further, described parameter configuration item also comprises Automatic clearance cycle and data timeout time;
The method is further comprising the steps:
The data entries of described data timeout time is removed more than in the described Automatic clearance cycle.
The data entries that the present invention is of little use by Automatic clearance, prevents long-play from causing internal memory to overflow, and improves search efficiency.
Correspondingly, the present invention also provides a kind of integration across database to support the automatic coding system (ACOM) of multi-field combination, comprising:
Parameter configuration module, for inputting the parameter configuration item of automatic coding, described parameter configuration item comprises type of database;
Service starts module, for starting described parameter configuration module, loads described parameter configuration item; And, for according to described type of database instantiation data bank interface; And, start memory management module, create initial memory;
Memory management module, for managed storage space, described storage space comprises storage organization and data content, described storage organization comprises table name, automatic coding field name, associate field name, automatic coding field current maximum and associate field and update time, described data content comprises the data item that zero to many meet this storage organization, and described initial memory comprises described storage organization and zero data item;
Coding acquisition module, for providing the maximum coding of required coding to user, comprises judgement submodule, output sub-module and coding registration submodule;
Judging submodule, for obtaining maximal value according to search criterion in described storage space, if obtain successfully, calling output sub-module, if obtain unsuccessfully, call coding registration submodule;
Output sub-module, exports next coding for exporting rule according to coding, and described update time is updated to current time;
Coding registration submodule, the maximal value for calling described database interface module is searched interface function and is searched maximal value and for registering new data item to the storage space of described memory management module; And for returning described maximal value; And for calling output sub-module;
Further, this system also comprises:
Database interface module, for defining the database interface of various database types, described database interface comprises maximal value and searches interface function;
Described coding registration submodule is further used for calling described database interface module, searches described maximal value, if do not found, then using default value as described maximal value.
Further, the described storage organization of described memory management module comprises described coding gain and coded format further;
This system comprises further:
Coding exports rule module, rule is exported for customizing coding, described coding output rule comprises coding and increases progressively rule and coding output format, described coding increases progressively rule for regulation coding gain, described coding gain is defaulted as 1, described coding output format is for specifying described coded format, and described coded format is defaulted as integer.
Further, described coding registration submodule be further used for described search described maximal value before locking registration search code block and after registering new data item to described storage space, before returning described maximal value, unlock registration search code block.
Further, the described parameter configuration item of described parameter configuration module also comprises Automatic clearance cycle and data timeout time;
This system comprises further:
Automatic clearance module, for removing more than the data entries of described data timeout time in the Automatic clearance cycle.
The present invention can improve the concurrency of automatic coding effectively, and the portability of software development architecture is significantly improved.When particularly needing many places use automatic coding in a project, adopt the method effectively can reduce size of code, improve tempo of development and coding quality.
Accompanying drawing explanation
Below with reference to accompanying drawings and the present invention is specifically described in conjunction with the embodiments.
Fig. 1 is the process flow diagram of the inventive method.
Embodiment
With reference to the accompanying drawings and by embodiments of the invention, technical scheme of the present invention is described in detail.
A kind of integration across database of the present invention supports that the automatic coding system (ACOM) of multi-field combination comprises parameter configuration module, service startup module, database interface module, memory management module, coding rule module, coding acquisition module, Automatic clearance module.Wherein, service start module directly and parameter configuration module, database interface module and memory management module carry out communication; Coding acquisition module comprise coding registration submodule, and have ready conditions calling coding registration submodule; Memory management module, coding Registering modules, coding acquisition module, Automatic clearance module carry out communication by sharing data area.Coding acquisition module have ready conditions calling coding registration submodule refer in system use procedure of the present invention, user only calls coding acquisition module, coding registration submodule is called by acquisition module of encoding, and the rule called often runs into the just registration one of a unregistered coding.Specifically see below six, the description of coding acquisition module and seven, coding registration submodule.
Respectively modules and step performed are separately described below:
One, parameter configuration module
Parameter configuration module is for inputting the parameter configuration item of automatic coding, realize the configuration of user to various controllable parameter, parameter configuration item comprises type of database, Automatic clearance cycle, data timeout time, and parameter configuration module can realize the control of user to automatic coding.
The specific implementation of parameter configuration module can by text, XML file or other can preserve parameter by persistence file.
Parameter configuration module can provide parameter management interface.
If provide parameter management interface, parameter after completing parameter configuration, can be made directly to come into force, also can by restarting service to come into force.
It is an a kind of implementation citing based on JAVA below [example]
1, parameter configuration files is config.xml file
Note: the unit of Automatic clearance cycle and data timeout time is sky.
2, the JAVA code of parameter configuration files config.xml file is read and write
Two, service starts module
Service starts module for realizing the startup of automatic coding service, comprises for loading parameters configuration item, instantiation data bank interface module, calls memory management module and creates initial memory, realize the necessary condition providing automatic coding to serve.
Service starts instantiation data bank interface module in module and can exchange with the step calling memory management module establishment initial memory.
It is an a kind of implementation citing based on JAVA below [example]
// instantiation data bank interface
// in SSH framework, the DAO of a structure fulfillment database interface realizes class, realized by being automatically injected of spring
Repository(″dataBaseDao″)
publicclassDataBaseDaoHibernateextendsGenericDaoHibernate<DM,String>implementsIDataBase{
... (detailed content is shown in " a kind of database interface based on Oracle realizes " in following " database interface module ")
}
// create initial memory
HashMap<String, TableSid>SidMap=newHashMap<St ring, TableSid> (); The example in following " memory management module " is shown in the definition of //TableSid
Three, database interface module
Database interface module is for defining the database interface of various database types, and described database interface comprises maximal value and searches interface function.This module realizes polytype database lookup maximal value interface, provides service by after described database interface instantiation for reality uses.
In an automatic coding service, allow to realize the interface that arrives multitype database, but must ensure that all type of database occurred in parameter configuration are implemented.
It is an a kind of implementation citing based on JAVA below [example]
Four, memory management module
Memory management module is used for managed storage space, and memory management module, when service starts module startup, creates storage space in internal memory.Described storage space comprises storage organization and data content, and storage organization, for storing the information of random length entry, can support fast finding.
Storage organization at least comprises: the current maximum of table name, automatic coding field name, automatic coding field, associate field name, associated field value, update time.Wherein, associate field name and associated field value can have multiple, but should keep one-to-one relationship.Described data content comprises the data item that zero to many meet this storage organization, and each described data item forms a data entries.When establishment initial memory, only have storage organization, there is no data content.Namely, described initial memory comprises described storage organization and zero data item.
Storage organization can adopt the mode such as Hash table, chained list, queue, array, vector, heap to realize, preferred Hash table.
The content of storage organization also comprises: coding gain and coded format.
Associate field name can have zero to multiple.Table name, associate field name and automatic coding field name can store respectively, and also can be stored in a variable, such as string variable, centre separator, the special symbol can not used in table name and field name as comma, branch, space etc. separates.# separator is used in the present embodiment.
It is an a kind of implementation citing based on JAVA below [example].
In this example, table name, associate field name and automatic coding field name leave in tableColumn character string in order, using # as separator.Further, concrete value left in secondary sublist, comprise current maximum and the associated field value of automatic coding field, secondary sublist ConcurrentHashMap realizes.
Five, coding rule module
Coding rule module exports rule described coding output rule for customizing coding.Described coding exports the regular coding that comprises and increases progressively the rule of rule and the form of coding output.Described coding increases progressively rule for regulation coding gain, and described coding gain is defaulted as 1, and described coding output format is for specifying described coded format, and described coded format is defaulted as integer.
The customized content of coding rule can also comprise default value, and this default value is used to specify the rreturn value do not found in current maximum situation.
Coding rule block module can realize interface separately, also may be incorporated in the interface of coding acquisition module, and the interface being incorporated in coding acquisition module more can simplify use.
It is an a kind of implementation citing based on JAVA below [example]
Six, coding acquisition module
Coding acquisition module, for providing the maximum coding of required coding to user.Coding acquisition module comprises judgement submodule, output sub-module and coding registration submodule.
Particularly, judging submodule, for obtaining maximal value M according to search criterion in described memory module, if obtain successfully, calling output sub-module, if obtain unsuccessfully, call coding registration submodule.
Output sub-module, exports next coding N for exporting rule according to coding, and " update time " of the data item in memory module is updated to current time.
Wherein, the coding gain that coding exports in rule represents with x, and x is defaulted as 1, then N=M+x.Described search criterion generally comprises concrete table name, automatic coding field name, associate field name, the associated field value with data item needed for user.
Seven, coding registration submodule, maximal value for calling described database interface module searches interface function, searches maximal value, and registers new data item to the storage space of described memory management module, return described maximal value to described memory management module, and enter output sub-module.
Further, coding registration submodule be further used for described search described maximal value before locking registration search code block and after registering new data item to the described storage space of described memory management module, described return described maximal value before unlock registration and search code block.
Namely, coding registration submodule specifically performs following steps:
1, lock registration and search code block;
2, the database lookup maximal value interface function of calling data bank interface module, obtain maximal value M, if do not found, then putting maximal value M is default value, and this default value is generally 0.Default value also can in addition in write parameters configuration module;
3, new data item is write to memory management module;
4, unlock registration and search code block.
5, maximal value M is returned;
Described registration is searched code block and is referred to code for performing the 2 to the 3 step, under object lesson is shown in.
It is an a kind of implementation citing based on JAVA below [example]
The step that code block is searched in the locking registration that have invoked wherein is comprised when more than calling the function in the example of memory management module.
Such as, realize to all nodes in chapters and sections directory tree structure all in each project each book stable, sort continuously.That is, when opening any one chapters and sections in book as user, the order of the content item seen is identical at every turn, and the numbering of content item all certainly increases from 1.Wherein, PMStructure is table name, projectId(item id), the ID of pmid(book) and the ID of parentId(superior node) be associate field, subOrder is automatic coding field name.
PMStructure is for storing the tree construction of chapters and sections catalogue, and current node id (key word) and father node parentId forms tree construction.Specific code is as follows:
StringtableColumn=″PMStructure#projectId#pmid#parentId#subOrder″;
String[]columnValues={projectinfo.getProjectId().toString(),pmid,parentId};
SidServicesidService=(SidService)getBean(″sidService″);
IntegerSubOrder=sidService.GetIntSid(tableColumn,columnValues);
Eight, Automatic clearance module
Automatic clearance module, the Automatic clearance cycle according to presetting in parameter configuration module triggers Automatic clearance module automatically, according to data timeout time, remove the data entries of time-out update time in memory module, thus realize the data entries that is of little use in Automatic clearance memory module, can prevent from causing internal memory to overflow during long-play, improve the efficiency of searching maximal value simultaneously.
It is an a kind of implementation citing based on JAVA below [example]
Should be appreciated that above is illustrative and not restrictive by preferred embodiment to the detailed description that technical scheme of the present invention is carried out.Those of ordinary skill in the art can modify to the technical scheme described in each embodiment on the basis of reading instructions of the present invention, or carries out equivalent replacement to wherein portion of techniques feature; And these amendments or replacement, do not make the essence of appropriate technical solution depart from the spirit and scope of various embodiments of the present invention technical scheme.Protection scope of the present invention is only limited by following claims.
Claims (10)
1. integration across database supports an automatic coding for multi-field combination, it is characterized in that, comprises the following steps:
Parameter configuration step, the parameter configuration item of input automatic coding, described parameter configuration item comprises type of database;
Service setting up procedure, loads described parameter configuration item, according to described type of database instantiation data bank interface, creates initial memory; Described initial memory comprises storage organization and data content, described storage organization comprises table name, automatic coding field name, the current maximum of automatic coding field, associate field name, associated field value, update time, described data content comprises the data item that zero to many meet this storage organization, and described initial memory comprises described storage organization and zero data item;
Coding obtaining step, provides the maximum coding of required coding to user, comprise and judge sub-step, output sub-step and coding registration sub-step;
Described judgement sub-step, obtains maximal value according to search criterion in described storage space, if obtain successfully, enters output sub-step, if obtain unsuccessfully, enters coding registration sub-step;
Described output sub-step, exports rule according to coding and exports next coding, and described update time is updated to current time;
Described coding registration sub-step, comprises and searches described maximal value; New data item is registered to described storage space; Return described maximal value; Enter output sub-step.
2. integration across database according to claim 1 supports the automatic coding of multi-field combination, it is characterized in that,
Described database interface comprises maximal value and searches interface function;
Described coding registration sub-step comprises further: search interface function by described maximal value and search described maximal value, if do not found, then using default value as described maximal value.
3. integration across database according to claim 1 supports the automatic coding of multi-field combination, it is characterized in that,
Described storage organization comprises coding gain and coded format further;
The method is further comprising the steps:
Customization coding exports rule step, described coding output rule comprises coding and increases progressively rule and coding output format, described coding increases progressively rule for regulation coding gain, described coding gain is defaulted as 1, described coding output format is for specifying described coded format, and described coded format is defaulted as integer.
4. integration across database according to claim 1 supports the automatic coding of multi-field combination, it is characterized in that,
Described coding registration sub-step comprises lock step and unlocked step further;
Lock step, described search described maximal value before lock registration and search code block;
Unlocked step, after registering new data item to described storage space, described return described maximal value before unlock this registration and search code block.
5. integration across database according to claim 1 supports the automatic coding of multi-field combination, it is characterized in that,
Described parameter configuration item also comprises Automatic clearance cycle and data timeout time;
The method is further comprising the steps:
The data entries of described data timeout time is removed more than in the described Automatic clearance cycle.
6. integration across database supports an automatic coding system (ACOM) for multi-field combination, it is characterized in that, comprising:
Parameter configuration module, for inputting the parameter configuration item of automatic coding, described parameter configuration item comprises type of database;
Service starts module, for starting described parameter configuration module, loads described parameter configuration item; And, for according to described type of database instantiation data bank interface; And, start memory management module, create initial memory;
Memory management module, for managed storage space, described storage space comprises storage organization and data content, described storage organization comprises table name, automatic coding field name, the current maximum of automatic coding field, associate field name, associated field value, update time, described data content comprises the data item that zero to many meet this storage organization, and described initial memory comprises described storage organization and zero data item;
Coding acquisition module, for providing the maximum coding of required coding to user, comprises judgement submodule, output sub-module and coding registration submodule;
Judging submodule, for obtaining maximal value according to search criterion in described storage space, if obtain successfully, calling output sub-module, if obtain unsuccessfully, call coding registration submodule;
Output sub-module, exports next coding for exporting rule according to coding, and described update time is updated to current time;
Coding registration submodule, the maximal value for calling described database interface module is searched interface function and is searched maximal value and for registering new data item to the storage space of described memory management module; And for returning described maximal value; And for calling output sub-module.
7. integration across database according to claim 6 supports the automatic coding system (ACOM) of multi-field combination, and it is characterized in that, this system also comprises:
Database interface module, for defining the database interface of various database types, described database interface comprises maximal value and searches interface function;
Described coding registration submodule is further used for calling described database interface module, searches described maximal value, if do not found, then using default value as described maximal value.
8. integration across database according to claim 6 supports the automatic coding system (ACOM) of multi-field combination, it is characterized in that,
The described storage organization of described memory management module comprises coding gain and coded format further;
This system comprises further:
Coding exports rule module, rule is exported for customizing coding, described coding output rule comprises coding and increases progressively rule and coding output format, described coding increases progressively rule for regulation coding gain, described coding gain is defaulted as 1, described coding output format is for specifying described coded format, and described coded format is defaulted as integer.
9. integration across database according to claim 6 supports the automatic coding system (ACOM) of multi-field combination, it is characterized in that,
Described coding registration submodule be further used for described search described maximal value before locking registration search code block and after registering new data item to described storage space, before returning described maximal value, unlock registration search code block.
10. integration across database according to claim 6 supports the automatic coding system (ACOM) of multi-field combination, it is characterized in that,
The described parameter configuration item of described parameter configuration module also comprises Automatic clearance cycle and data timeout time;
This system comprises further:
Automatic clearance module, for removing more than the data entries of described data timeout time in the Automatic clearance cycle.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210580904.7A CN103020285B (en) | 2012-12-27 | 2012-12-27 | Integration across database supports automatic coding and the system of multi-field combination |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210580904.7A CN103020285B (en) | 2012-12-27 | 2012-12-27 | Integration across database supports automatic coding and the system of multi-field combination |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103020285A CN103020285A (en) | 2013-04-03 |
| CN103020285B true CN103020285B (en) | 2016-01-13 |
Family
ID=47968888
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210580904.7A Active CN103020285B (en) | 2012-12-27 | 2012-12-27 | Integration across database supports automatic coding and the system of multi-field combination |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103020285B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104731863B (en) * | 2015-02-13 | 2017-10-13 | 杭州米加科技有限公司 | Simplify the method for PostgreSQL division codes |
| CN107220332A (en) * | 2017-05-24 | 2017-09-29 | 深圳怡化电脑股份有限公司 | A kind of method and device of data management |
| CN110825751B (en) * | 2019-11-13 | 2023-10-03 | 上海图莱智能科技有限公司 | Method for customizing data format and data conversion system |
| CN112417660B (en) * | 2020-11-12 | 2024-04-12 | 中国核电工程有限公司 | Automatic coding method and system for pipeline support and hanger |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101645074A (en) * | 2009-09-07 | 2010-02-10 | 浪潮集团山东通用软件有限公司 | Method for accessing relational databases of different types |
| CN101789021A (en) * | 2010-02-24 | 2010-07-28 | 浪潮通信信息系统有限公司 | Universal configurable database data migration method |
| CN102663103A (en) * | 2012-04-13 | 2012-09-12 | 北京工业大学 | Configurable method for automatically generating database and accessing data |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030217044A1 (en) * | 2002-05-15 | 2003-11-20 | International Business Machines Corporation | Method and apparatus of automatic method signature adaptation for dynamic web service invocation |
| US7475090B2 (en) * | 2006-11-15 | 2009-01-06 | International Business Machines Corporation | Method and apparatus for moving data from an extensible markup language format to normalized format |
-
2012
- 2012-12-27 CN CN201210580904.7A patent/CN103020285B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101645074A (en) * | 2009-09-07 | 2010-02-10 | 浪潮集团山东通用软件有限公司 | Method for accessing relational databases of different types |
| CN101789021A (en) * | 2010-02-24 | 2010-07-28 | 浪潮通信信息系统有限公司 | Universal configurable database data migration method |
| CN102663103A (en) * | 2012-04-13 | 2012-09-12 | 北京工业大学 | Configurable method for automatically generating database and accessing data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103020285A (en) | 2013-04-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7562087B2 (en) | Method and system for processing directory operations | |
| JP2718881B2 (en) | Token identification system | |
| US9230083B2 (en) | Securing application information in system-wide search engines | |
| US10437804B1 (en) | Storing graph data representing workflow management | |
| KR20060045622A (en) | Extraction, transformation and loading designer module of a computerized financial system | |
| CN103020285B (en) | Integration across database supports automatic coding and the system of multi-field combination | |
| CN105956123A (en) | Local updating software-based data processing method and apparatus | |
| CN102708203A (en) | Database dynamic management method based on XML metadata | |
| CN102054034A (en) | Implementation method for business basic data persistence of enterprise information system | |
| US8892566B2 (en) | Creating indexes for databases | |
| US9773028B2 (en) | Manipulating non-schema attributes for objects in a schema based directory | |
| CN113326264A (en) | Data processing method, server and storage medium | |
| CN105447166A (en) | Keyword based information search method and system | |
| CN100397397C (en) | XML data storage and access method based on relational database | |
| CN110263104A (en) | JSON character string processing method and device | |
| CN105677805A (en) | Data storing and reading method and device using protobuf | |
| CN114860727A (en) | Zipper watch updating method and device | |
| US20080133587A1 (en) | Extending Existing Data within a Directory Service | |
| CN105589915A (en) | Database acceleration method through operation index value and hybrid layer cache | |
| CN110019306A (en) | A kind of SQL statement lookup method and system based on XML format file | |
| CN110232063B (en) | Hierarchical data query method, hierarchical data query device, computer equipment and storage medium | |
| US8244778B1 (en) | Customization of types using default aspects | |
| CN110888863A (en) | State field optimization method and device, electronic equipment and storage medium | |
| CN114138815A (en) | Multi-database compatibility implementation method, device and medium for application program | |
| CN111259003B (en) | Database establishment method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |