CN101661509A - Method for generating major key field of database table and device thereof - Google Patents
Method for generating major key field of database table and device thereof Download PDFInfo
- Publication number
- CN101661509A CN101661509A CN200910179909A CN200910179909A CN101661509A CN 101661509 A CN101661509 A CN 101661509A CN 200910179909 A CN200910179909 A CN 200910179909A CN 200910179909 A CN200910179909 A CN 200910179909A CN 101661509 A CN101661509 A CN 101661509A
- Authority
- CN
- China
- Prior art keywords
- value
- major key
- key field
- database table
- table major
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for generating a major key field of a database table and a device thereof. The method comprises the steps: obtaining the current maximum identifier ID value; increasing a preset value to the maximum ID value, and updating the current maximum ID value; respectively converting the ID value with the quantity of the preset value into preset scale to be memorized in anID pool to form the major key field of the database table available for use; and or memorizing the ID value with the quantity of the preset value into the ID pool to form the ID value available for generating the major key field of the database table, when the major key field of the database table is required to be generated, obtaining the ID value from the ID pool, and after converting the ID value into the preset scale, and forming the major key field of the database table available for use. The invention can keep the use convenience of GUID, greatly reduce the length of the major key, and effectively improve the querying performance and the index performance.
Description
Technical field
The present invention relates to the infosystem applied technical field, relate in particular to a kind of method and device that generates the database table major key field.
Background technology
At present, the main flow generation method of database table major key field comprises database sequence method and GUID (the unified identifier of the overall situation) method.Wherein, the database sequence method is meant by calling the ordinal function that database self provides, and returns an ever-increasing numerical value, can guarantee that this numerical value can not duplicate.The GUID method is meant the numerical value that generates on a machine, can guarantee that to all machines in the same space-time (whole world) all be unique.
Yet the method for the generation database table major key field of above-mentioned two kinds of main flows all has weak point, particularly, though database sequence method performance is higher, database volume takies minimum, must insert database earlier when using, could determine the ID value, this is very inconvenient for code compiling.And the GUID method is not because natural repeated, very easy to use, but the major key field length of its generation is longer, promptly 44.
Summary of the invention
The embodiment of the invention provides a kind of method and device that generates the database table major key field, and the convenience that can keep GUID to use can make major key length significantly reduce again, effectively improves inquiry and index performance.
The embodiment of the invention provides following technical scheme:
The embodiment of the invention provides a kind of method that generates the database table major key field, comprising:
Obtain current maximum identifier ID value;
Described maximum ID value is increased predetermined value, upgrade described current maximum ID value simultaneously;
Store in the ID pond after a described predetermined value ID value is converted to predetermined system respectively, form operational database table major key field; Perhaps a described predetermined value ID value is stored in the ID pond, formation can when needs generate the database table major key field, be obtained the ID value for the ID value that generates the database table major key field from described ID pond, and after this ID value is converted to predetermined system, form operational database table major key field.
Preferably, the described step of obtaining current maximum ID value also comprises before: judge whether the ID value in the ID pond uses up, if used up then continued subsequent step, can be if do not use up then directly from the ID pond, obtain operational database table major key field or from the ID pond, obtain for the ID value of the database table major key field that generates, and after this ID value is converted to predetermined system, form operational database table major key field.
Further, behind the operational database table major key field of described formation, also comprise:
Judge whether described database table major key field finally is saved in the database;
If be not saved in the database, then described database table major key field is recovered in the described ID pond, and the priority of the ID value of described recovery is higher than the ID value of non-recovery.
Preferably, described predetermined value is greater than 10, the natural number less than 10000.
Preferably, described predetermined system is the decimal system or two sexadecimals or three sexadecimals or six duodecimal number systems.
Accordingly, the embodiment of the invention is a kind of device that generates the database table major key field of the decorum also, comprising:
First acquiring unit is used to obtain current maximum identifier ID value;
First updating block is used for described maximum ID value is increased predetermined value, upgrades described current maximum ID value simultaneously;
First converting unit stores the ID pond into after being used for a described predetermined value ID value is converted to predetermined system respectively, forms operational database table major key field;
First processing unit is used for obtaining the database table major key field that needs generate from the operational database table major key field that store in described ID pond.
Preferably, described device also comprises: first judging unit is used for judging whether the ID value in ID pond uses up, if used up then trigger first acquiring unit and handle, if do not use up then trigger first processing unit processes.
Preferably, described device also comprises: first reclaims the unit, be used for when the database table major key field of described first processing unit acquisition is not saved in database, described database table major key field is recovered in the described ID pond, and the priority of the ID value of described recovery is arranged to be higher than the ID value of non-recovery.
In addition, the embodiment of the invention also provides a kind of device that generates the database table major key field, comprising:
Second acquisition unit is used to obtain current maximum identifier ID value;
Second updating block is used for described maximum ID value is increased predetermined value, upgrades described current maximum ID value simultaneously;
Second processing unit is used for storing a described predetermined value ID value into the ID pond, and formation can be for the ID value that generates the database table major key field;
Second converting unit is used for obtaining the ID value from described ID pond, and after this ID value is converted to predetermined system, forms the database table major key field of available use.
Preferably, described device also comprises: second judging unit is used for judging whether the ID value in ID pond uses up, if used up then trigger second acquisition unit and handle, if do not use up then trigger second converting unit and handle.
Preferably, described device also comprises: second reclaims the unit, be used for when the database table major key field of described second converting unit formation is not saved in database, described database table major key field is recovered in the described ID pond, and the priority of the ID value of described recovery is arranged to be higher than the ID value of non-recovery.
The method and the device of generation database table major key field provided by the invention, the convenience that can keep GUID to use can make major key length significantly reduce again, effectively improves inquiry and index performance.Particularly, the embodiment of the invention can obtain ID in advance, could determine ID and need not must to insert database in advance as using database sequence.Through test, compare with existing GUID method, the performance basically identical of average acquiring ID, but the length of ID can reduce to 7 even lower, database volume reduction about 30% from 44.
Description of drawings
In order to be illustrated more clearly in the embodiment of the invention or technical scheme of the prior art, to do to introduce simply to the accompanying drawing of required use in embodiment or the description of the Prior Art below, apparently, accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the method flow diagram that the embodiment of the invention one generates the database table major key field;
Fig. 2 is the method flow diagram that the embodiment of the invention two generates the database table major key field;
Fig. 3 is the apparatus structure synoptic diagram that the embodiment of the invention three generates the database table major key field;
Fig. 4 is the apparatus structure synoptic diagram that the embodiment of the invention four generates the database table major key field.
Embodiment
The embodiment of the invention provides a kind of method and device that generates the database table major key field, and the convenience that can keep GUID to use can make major key length significantly reduce again, effectively improves inquiry and index performance.For making purpose of the present invention, technical scheme and advantage clearer, the embodiment that develops simultaneously with reference to the accompanying drawings, the present invention is described in more detail.
As shown in Figure 1, be the method flow diagram of the embodiment of the invention one generation database table major key field, described method comprises:
Need to prove that described current maximum ID value can be stored in the UID table in the database in advance, also can be stored in other the file, as long as can get access to current maximum ID value when needs obtain.If, then when realizing, can be pre-created UID table (ID BigInt) by the storage of the table of the UID in the database, wherein, have only a line item forever in the described UID table, be used to store current maximum ID value.
Need to prove, the setting range of described predetermined value is very wide and very flexible, for example can be 10 or 1000 or 5000 or 10000 etc., how many concrete settings depends primarily on actual needs, for example, can be configured according to obtaining the ID frequency, when the newly-increased frequency of software systems fine, predetermined value can be provided with bigger to obtain more performance, if mainly be query manipulation, what can be provided with is smaller.After described maximum ID value is increased predetermined value, current maximum ID value need be upgraded synchronously, so that can get access to current maximum ID value when obtaining again next time.
Need to prove, the setting range of described predetermined system is also very extensive and very flexible, for example can be the decimal system, or two sexadecimal, or three sexadecimal, or six duodecimal number system or the like, how many concrete settings depends primarily on actual needs, for example, in order to adapt to the Database Systems of case-insensitives such as SQLServer, can adopt 36 systems to change, wherein, 36 systems are to use 0-9, and totally 36 characters of capitalization A-Z forms, and these 36 is unduplicated fully, and lowercase a-z and capitalization A-Z are considered to equally in the Database Systems of case-insensitive.If adopt 36 systems to change, the length that then stores the ID character string in the ID pond after the conversion into is 7.Because 36 7 powers are 78,300,000,000 ID, are enough to satisfy the demand of general application system, therefore, are comparative optimizations for common demand 36 systems.But, can suitably dwindle or increase the figure place of ID character string for specific demand.If the carrier-class system, data volume is huge, and 7 (36,^7=,783 hundred million) are just not much of that for possibility, can expand to 8 (3,6^8,=28,000 hundred million).For middle-size and small-size little software systems, 6 may be just enough.So can carry out accommodation in actual use.For higher system, both can dwindle ID length, also can reach higher ID capacity.Therefore, in order to reduce ID length, can be at Oracle, employing 62 systems in the databases such as DB2 (0-9, A-Z, a-z), or other more high-order system conversion methods.
In addition, need to prove also that described ID pond is the data structure of explanation storage ID just, can adopt multiple modes such as array, tabulation when specifically using, the present invention does not limit this.
In addition, the described step of obtaining current maximum ID value can also comprise before: judge whether the ID value in the ID pond uses up, if used up then continued subsequent step, if do not use up then directly from the ID pond, obtain operational database table major key field.
When stating method in realization, specifically can adopt getUID () method, its false code is expressed as follows:
If (the ID pond is empty or has used up)
Obtain the ID value in the UID table.
ID value in the UID table is added n (for example n=100,1000), upgrade back the UID table.
(0-9, A～Z) also is filled into the ID pond to transfer n ID numerical value to 36 systems.
Return first ID in the pond
} else{
Return next ID in the pond
}
Below above-mentioned false code is described as follows:
It is 100 that the ID tankage is set, when routine call getUID () method, when applying for an ID:
Judge that at first whether the ID pond is empty or has used up, if last ID value is then gone to get in the database for empty or used up in the ID pond, then with ID value+100 in the database, new database more.Then the ID pond is used database ID value+1, be filled into the ID pond after database ID value+2...... database ID value+100 are converted to 36 systems respectively, return data storehouse ID value+character string of 1 is the ID of application then.If the ID pond is not empty, return directly then that next ID gets final product in the ID pond.
For example: some over-network registrations system, preserve behind user's fill message, before user profile is saved in the subscriber's meter of database, need to give this record to distribute a major key (ID).At this moment the getUID () method of routine call UID class obtains an ID, then may be expressed as: 0000001.And if, then may be expressed as: A40B4B44-802A-41CD-97AB-B13047D6A984 with ID of existing GUID method acquisition.Obviously, of the present invention 7 than existing GUID method to fix 44 meetings many efficiently, also little many of storage space.
Obviously, the present invention can obtain 17 ID character string that never repeat by getUID () method.Need to prove that herein if adopt individual server in realization, then this method is by being arranged to thread to guarantee the uniqueness of ID character string.If adopt a plurality of servers, then by a plurality of servers are connected on the same database server, to reach the purpose of mutual exclusion.
In addition, can also do following improvement in the foregoing description one, promptly behind the operational database table major key field of described formation, also comprise:
Judge whether described database table major key field finally is saved in the database, if be not saved in the database, then described database table major key field is recovered in the described ID pond, and the priority of the ID value of described recovery is higher than the ID value of non-recovery.For example, when the program application ID, can pass through verification, find user's input error, finally the ID of application is not preserved into database, described ID also can also be returned so, use to other application user.When realizing, the ID that reclaims can be also placed in the ID pond and use for the subsequent application user; Also the ID that reclaims can be placed in the ID pond, but the priority of the ID value that reclaims be arranged to be higher than simultaneously the priority of the ID value of non-recovery; Certainly the ID that reclaims can also be placed in the special recovery ID pond, the priority in this recovery ID pond is higher than aforesaid ID pond, arrives first when obtaining and reclaims in the ID pond, if do not continue subsequent step again.In a word, the mode of realization has a lot, as long as the ID that reclaims can be utilized once more, the present invention does not limit concrete implementation.
As shown in Figure 2, be the method flow diagram of the embodiment of the invention two generation database table major key fields, described method comprises:
Need to prove that described current maximum ID value can be stored in the UID table in the database in advance, also can be stored in other the file, as long as can get access to current maximum ID value when needs obtain.If, then when realizing, can be pre-created UID table (ID BigInt) by the storage of the table of the UID in the database, wherein, have only a line item forever in the described UID table, be used to store current maximum ID value.
Need to prove, the setting range of described predetermined value is very wide and very flexible, for example can be 10 or 1000 or 5000 or 10000 etc., how many concrete settings depends primarily on actual needs, for example, can be configured according to obtaining the ID frequency, when the newly-increased frequency of software systems fine, predetermined value can be provided with bigger to obtain more performance, if mainly be query manipulation, what can be provided with is smaller.After described maximum ID value is increased predetermined value, current maximum ID value need be upgraded synchronously, so that can get access to current maximum ID value when obtaining again next time.
Need to prove that the setting range of described predetermined system is also very extensive and very flexible, for example can be the decimal system or two sexadecimals or three sexadecimals or six duodecimal number systems or the like, and how many concrete settings depends primarily on actual needs.
In addition, the described step of obtaining current maximum ID value can also comprise before: judge whether the ID value in the ID pond uses up, if used up then continued subsequent step, can be if do not use up then from the ID pond, obtain for the ID value of the database table major key field that generates, and after this ID value is converted to predetermined system, form operational database table major key field.
When stating method in realization, specifically can adopt getUID () method, its false code is expressed as follows:
If (the ID pond is empty or has used up)
Obtain the ID value in the UID table.
ID value in the UID table is added n (for example n=100,1000), upgrade back the UID table.
N ID numerical value is filled into the ID pond.
Return in the pond first ID and transfer it to 36 systems (0-9, A～Z)
} else{
Return in the pond next ID and transfer it to 36 systems (0-9, A～Z)
}
Below above-mentioned false code is described as follows:
It is 100 that the ID tankage is set, when routine call getUID () method, when applying for an ID:
Judge that at first whether the ID pond is empty or has used up, if last ID value is then gone to get in the database for empty or used up in the ID pond, then with ID value+100 in the database, new database more.Then with the ID pond with database ID value+1, database ID value+2...... database ID value+100 are filled into the ID pond, then the character string of return data storehouse ID value+1 and be converted into the ID that 36 systems are application.If the ID pond is not empty, then directly returns the character string of next ID in the ID pond and be converted into 36 systems and get final product.
Obviously, the present invention can obtain 17 ID character string that never repeat by getUID () method.In addition, can also do following improvement in the foregoing description one, promptly behind the operational database table major key field of described formation, also comprise:
Judge whether described database table major key field finally is saved in the database, if be not saved in the database, then described database table major key field is recovered in the described ID pond, and the priority of the ID value of described recovery is higher than the ID value of non-recovery.For example, when the program application ID, can pass through verification, find user's input error, finally the ID of application is not preserved into database, described ID also can also be returned so, use to other application user.When realizing, the ID that reclaims can be also placed in the ID pond and use for the subsequent application user; Also the ID that reclaims can be placed in the ID pond, but the priority of the ID value that reclaims be arranged to be higher than simultaneously the priority of the ID value of non-recovery; Certainly the ID that reclaims can also be placed in the special recovery ID pond, the priority in this recovery ID pond is higher than aforesaid ID pond, arrives first when obtaining and reclaims in the ID pond, if do not continue subsequent step again.In a word, the mode of realization has a lot, as long as the ID that reclaims can be utilized once more, the present invention does not limit concrete implementation.
As shown in Figure 3, be the apparatus structure synoptic diagram of the embodiment of the invention three generation database table major key fields, this device comprises: first acquiring unit 310, first updating block 320, first converting unit 330, first processing unit 340, wherein:
Described first acquiring unit 310 is used to obtain current maximum identifier ID value;
Described first updating block 320 is used for described maximum ID value is increased predetermined value, upgrades described current maximum ID value simultaneously;
Described first converting unit 330 stores the ID pond into after being used for a described predetermined value ID value is converted to predetermined system respectively, forms operational database table major key field;
Described first processing unit 340 is used for obtaining the database table major key field that needs generate from the operational database table major key field that store in described ID pond.
Wherein, described device can also comprise: first judging unit 350 is used for judging whether the ID value in ID pond uses up, if used up then trigger first acquiring unit 310 and handle, if do not use up then trigger first processing unit 340 and handle.
In addition, described device can further include: first reclaims unit 360, be used for when the database table major key field of described first processing unit 340 acquisitions is not saved in database, described database table major key field is recovered in the described ID pond, and the priority of the ID value of described recovery is arranged to be higher than the ID value of non-recovery.
As shown in Figure 4, generate the apparatus structure synoptic diagram of database table major key field for the embodiment of the invention four.This device comprises: second acquisition unit 410, second updating block 420, second processing unit 430, second converting unit 440; Wherein:
Described second acquisition unit 410 is used to obtain current maximum identifier ID value;
Described second updating block 420 is used for described maximum ID value is increased predetermined value, upgrades described current maximum ID value simultaneously;
Described second processing unit 430 is used for storing a described predetermined value ID value into the ID pond, and formation can be for the ID value that generates the database table major key field;
Described second converting unit 440 is used for obtaining the ID value from described ID pond, and after this ID value is converted to predetermined system, forms the database table major key field of available use.
Wherein, described device can also comprise: second judging unit 450 is used for judging whether the ID value in ID pond uses up, if used up then trigger second acquisition unit 410 and handle, if do not use up then trigger second converting unit 440 and handle.
In addition, described device can further include: second reclaims unit 460, be used for when the database table major key field of described second converting unit 440 formation is not saved in database, described database table major key field is recovered in the described ID pond, and the priority of the ID value of described recovery is arranged to be higher than the ID value of non-recovery.
Need to prove that the associated description of said method embodiment is equally applicable to device embodiment, repeats no more herein.
One of ordinary skill in the art will appreciate that and realize that all or part of step that the foregoing description method is carried is to instruct relevant hardware to finish by program, described program can be stored in a kind of computer-readable recording medium, this program comprises one of step or its combination of method embodiment when carrying out.
In addition, each functional unit in each embodiment of the present invention can be integrated in the processing module, also can be that the independent physics in each unit exists, and also can be integrated in the module two or more unit.Above-mentioned integrated module both can adopt the form of hardware to realize, also can adopt the form of software function module to realize.If described integrated module realizes with the form of software function module and during as independently production marketing or use, also can be stored in the computer read/write memory medium.
The above-mentioned storage medium of mentioning can be a ROM (read-only memory), disk or CD etc.
In sum, the method and the device of the generation database table major key field that the embodiment of the invention provides, the convenience that can keep GUID to use can make major key field length significantly reduce again, effectively improves inquiry and index performance.Particularly, the embodiment of the invention can obtain ID in advance, could determine ID and need not must to insert database in advance as using database sequence.Through test, compare with existing GUID method, the performance basically identical of average acquiring ID, but the length of ID can reduce to 7 even lower, database volume reduction about 30% from 44.
More than to the method and the device of generation database table major key field provided by the present invention, used specific case among the present invention principle of the present invention and embodiment set forth, the explanation of above embodiment just is used for helping to understand the solution of the present invention; Simultaneously, for one of ordinary skill in the art, according to thought of the present invention, the part that all can change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (11)
1, a kind of method that generates the database table major key field is characterized in that, comprising:
Obtain current maximum identifier ID value;
Described maximum ID value is increased predetermined value, upgrade described current maximum ID value simultaneously;
Store in the ID pond after a described predetermined value ID value is converted to predetermined system respectively, form operational database table major key field; Perhaps a described predetermined value ID value is stored in the ID pond, formation can when needs generate the database table major key field, be obtained the ID value for the ID value that generates the database table major key field from described ID pond, and after this ID value is converted to predetermined system, form operational database table major key field.
2, the method for generation database table major key field according to claim 1, it is characterized in that, the described step of obtaining current maximum ID value also comprises before: judge whether the ID value in the ID pond uses up, if used up then continued subsequent step, can be if do not use up then directly from the ID pond, obtain operational database table major key field or from the ID pond, obtain for the ID value of the database table major key field that generates, and after this ID value is converted to predetermined system, form operational database table major key field.
3, the method for generation database table major key field according to claim 2 is characterized in that, behind the operational database table major key field of described formation, also comprises:
Judge whether described database table major key field finally is saved in the database;
If be not saved in the database, then described database table major key field is recovered in the described ID pond, and the priority of the ID value of described recovery is higher than the ID value of non-recovery.
According to the method for any described generation database table major key field among the claim 1-3, it is characterized in that 4, described predetermined value is greater than 10, the natural number less than 10000.
According to the method for any described generation database table major key field among the claim 1-3, it is characterized in that 5, described predetermined system is the decimal system or two sexadecimals or three sexadecimals or six duodecimal number systems.
6, a kind of device that generates the database table major key field is characterized in that, comprising:
First acquiring unit is used to obtain current maximum identifier ID value;
First updating block is used for described maximum ID value is increased predetermined value, upgrades described current maximum ID value simultaneously;
First converting unit stores the ID pond into after being used for a described predetermined value ID value is converted to predetermined system respectively, forms operational database table major key field;
First processing unit is used for obtaining the database table major key field that needs generate from the operational database table major key field that store in described ID pond.
7, the device of generation database table major key field according to claim 6 is characterized in that, also comprises:
First judging unit is used for judging whether the ID value in ID pond uses up, if used up then trigger first acquiring unit and handle, if do not use up then trigger first processing unit processes.
8, the device of generation database table major key field according to claim 7 is characterized in that, also comprises:
First reclaims the unit, be used for when the database table major key field of described first processing unit acquisition is not saved in database, described database table major key field is recovered in the described ID pond, and the priority of the ID value of described recovery is arranged to be higher than the ID value of non-recovery.
9, a kind of device that generates the database table major key field is characterized in that, comprising:
Second acquisition unit is used to obtain current maximum identifier ID value;
Second updating block is used for described maximum ID value is increased predetermined value, upgrades described current maximum ID value simultaneously;
Second processing unit is used for storing a described predetermined value ID value into the ID pond, and formation can be for the ID value that generates the database table major key field;
Second converting unit is used for obtaining the ID value from described ID pond, and after this ID value is converted to predetermined system, forms the database table major key field of available use.
10, the device of generation database table major key field according to claim 9 is characterized in that, also comprises:
Second judging unit is used for judging whether the ID value in ID pond uses up, if used up then trigger second acquisition unit and handle, if do not use up then trigger second converting unit and handle.
11, the device of generation database table major key field according to claim 10 is characterized in that, also comprises:
Second reclaims the unit, be used for when the database table major key field of described second converting unit formation is not saved in database, described database table major key field is recovered in the described ID pond, and the priority of the ID value of described recovery is arranged to be higher than the ID value of non-recovery.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009101799097A CN101661509B (en) | 2009-09-29 | 2009-09-29 | Method for generating major key field of database table and device thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009101799097A CN101661509B (en) | 2009-09-29 | 2009-09-29 | Method for generating major key field of database table and device thereof |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101661509A true CN101661509A (en) | 2010-03-03 |
| CN101661509B CN101661509B (en) | 2012-07-18 |
Family
ID=41789529
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2009101799097A Active CN101661509B (en) | 2009-09-29 | 2009-09-29 | Method for generating major key field of database table and device thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101661509B (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102156717A (en) * | 2011-03-25 | 2011-08-17 | 中国有色矿业集团有限公司 | Method and device for mapping entity object into database |
| CN102880705A (en) * | 2012-09-28 | 2013-01-16 | 用友软件股份有限公司 | Database primary key generating device and database primary key generating method |
| CN102999525A (en) * | 2011-09-16 | 2013-03-27 | 深圳市金蝶中间件有限公司 | Data-table processing method and system |
| CN103020268A (en) * | 2012-12-26 | 2013-04-03 | 大唐软件技术股份有限公司 | Serial number applying method and system of relational database |
| CN103164418A (en) * | 2011-12-12 | 2013-06-19 | 阿里巴巴集团控股有限公司 | Method and device for processing serial numbers |
| CN103324733A (en) * | 2013-06-30 | 2013-09-25 | 四川效率源信息安全技术有限责任公司 | File reconstructable storage and management method based on database |
| CN104423901A (en) * | 2013-08-29 | 2015-03-18 | 北大方正集团有限公司 | Automatic generating method and system for variable sequential data |
| CN105630991A (en) * | 2015-12-25 | 2016-06-01 | 北京奇虎科技有限公司 | Method and device for automatically generating ID |
| CN108256019A (en) * | 2018-01-09 | 2018-07-06 | 顺丰科技有限公司 | Database key generation method, device, equipment and its storage medium |
| CN108959285A (en) * | 2017-05-18 | 2018-12-07 | 北京京东尚科信息技术有限公司 | Database key acquisition methods and device |
| CN110019275A (en) * | 2017-12-31 | 2019-07-16 | 中国移动通信集团安徽有限公司 | Major key generation method, device, equipment and medium |
| CN117827849A (en) * | 2024-03-04 | 2024-04-05 | 支付宝(杭州)信息技术有限公司 | Data dictionary maintenance method and device |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107133285B (en) * | 2017-04-18 | 2019-08-30 | 北京北信源软件股份有限公司 | A kind of distribution major key generation method and device |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2007094733A (en) * | 2005-09-28 | 2007-04-12 | Hitachi Ltd | Information processing apparatus, schema preparation method, and program |
| CN101216840A (en) * | 2008-01-21 | 2008-07-09 | 金蝶软件（中国）有限公司 | Data enquiry method and data enquiry system |
-
2009
- 2009-09-29 CN CN2009101799097A patent/CN101661509B/en active Active
Cited By (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102156717B (en) * | 2011-03-25 | 2013-07-03 | 中国有色矿业集团有限公司 | Method and device for mapping entity object into database |
| CN102156717A (en) * | 2011-03-25 | 2011-08-17 | 中国有色矿业集团有限公司 | Method and device for mapping entity object into database |
| CN102999525A (en) * | 2011-09-16 | 2013-03-27 | 深圳市金蝶中间件有限公司 | Data-table processing method and system |
| CN102999525B (en) * | 2011-09-16 | 2016-08-03 | 深圳市金蝶中间件有限公司 | Tables of data processing method and system |
| CN103164418A (en) * | 2011-12-12 | 2013-06-19 | 阿里巴巴集团控股有限公司 | Method and device for processing serial numbers |
| CN103164418B (en) * | 2011-12-12 | 2016-05-04 | 阿里巴巴集团控股有限公司 | A kind of processing method of sequence number and equipment |
| CN102880705B (en) * | 2012-09-28 | 2015-09-02 | 用友软件股份有限公司 | Database key generating apparatus and database key generation method |
| CN102880705A (en) * | 2012-09-28 | 2013-01-16 | 用友软件股份有限公司 | Database primary key generating device and database primary key generating method |
| CN103020268B (en) * | 2012-12-26 | 2016-05-04 | 大唐软件技术股份有限公司 | Relevant database sequence number application process and system |
| CN103020268A (en) * | 2012-12-26 | 2013-04-03 | 大唐软件技术股份有限公司 | Serial number applying method and system of relational database |
| CN103324733A (en) * | 2013-06-30 | 2013-09-25 | 四川效率源信息安全技术有限责任公司 | File reconstructable storage and management method based on database |
| CN104423901A (en) * | 2013-08-29 | 2015-03-18 | 北大方正集团有限公司 | Automatic generating method and system for variable sequential data |
| CN104423901B (en) * | 2013-08-29 | 2018-11-06 | 北大方正集团有限公司 | Variable sequence data auto-generation method and system |
| CN105630991A (en) * | 2015-12-25 | 2016-06-01 | 北京奇虎科技有限公司 | Method and device for automatically generating ID |
| CN105630991B (en) * | 2015-12-25 | 2019-11-01 | 北京奇虎科技有限公司 | ID automatic generation method and device |
| CN108959285A (en) * | 2017-05-18 | 2018-12-07 | 北京京东尚科信息技术有限公司 | Database key acquisition methods and device |
| CN108959285B (en) * | 2017-05-18 | 2020-12-22 | 北京京东尚科信息技术有限公司 | Database main key acquisition method and device, storage medium and electronic equipment |
| CN110019275A (en) * | 2017-12-31 | 2019-07-16 | 中国移动通信集团安徽有限公司 | Major key generation method, device, equipment and medium |
| CN108256019A (en) * | 2018-01-09 | 2018-07-06 | 顺丰科技有限公司 | Database key generation method, device, equipment and its storage medium |
| CN117827849A (en) * | 2024-03-04 | 2024-04-05 | 支付宝(杭州)信息技术有限公司 | Data dictionary maintenance method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101661509B (en) | 2012-07-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101661509B (en) | Method for generating major key field of database table and device thereof | |
| US10866954B2 (en) | Storing data in a data section and parity in a parity section of computing devices | |
| Floratou et al. | Column-oriented storage techniques for MapReduce | |
| Nayak et al. | Type of NOSQL databases and its comparison with relational databases | |
| US9805079B2 (en) | Executing constant time relational queries against structured and semi-structured data | |
| CN101876983B (en) | Method for partitioning database and system thereof | |
| CN103312791B (en) | Internet of Things isomeric data storage means and system | |
| JP6410825B2 (en) | Incremental and concatenated redistribution to extend online shared nothing database | |
| US20110040771A1 (en) | Distributed hardware-based data querying | |
| CN102638584B (en) | Data distributing and caching method and data distributing and caching system | |
| CN108205577B (en) | Array construction method, array query method, device and electronic equipment | |
| US20130191523A1 (en) | Real-time analytics for large data sets | |
| CN104067216A (en) | System and method for implementing a scalable data storage service | |
| US20110004638A1 (en) | Attributed key-value-store database system | |
| EP2780834A1 (en) | Data processing service | |
| CN103678494A (en) | Method and device for client side and server side data synchronization | |
| CN112269792A (en) | Data query method, device, equipment and computer readable storage medium | |
| CN101727502A (en) | Data query method, data query device and data query system | |
| Mohamed et al. | MRO-MPI: MapReduce overlapping using MPI and an optimized data exchange policy | |
| EP2556446A1 (en) | Columnar storage representations of records | |
| CN105138281B (en) | A kind of sharing method and device of physical disk | |
| CN104462185A (en) | Digital library cloud storage system based on mixed structure | |
| CN103617199A (en) | Data operating method and data operating system | |
| CN111061680A (en) | Data retrieval method and device | |
| CN113177090A (en) | Data processing 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 |