CN101661509B - 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
- CN101661509B CN101661509B CN2009101799097A CN200910179909A CN101661509B CN 101661509 B CN101661509 B CN 101661509B CN 2009101799097 A CN2009101799097 A CN 2009101799097A CN 200910179909 A CN200910179909 A CN 200910179909A CN 101661509 B CN101661509 B CN 101661509B
- 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.)
- Active
Links
Images
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 an ID 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 through 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 on a machine, generates, and 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 confirm 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;
Said current maximum identifier ID value is added one add predetermined value, upgrade said current maximum ID value simultaneously to said current maximum identifier ID value;
Store in the ID pond after converting a said predetermined value ID value into predetermined system respectively, form operational database table major key field; Perhaps a said predetermined value ID value is stored in the ID pond; Formation can supply to generate the ID value of database table major key field, when needs generate the database table major key field, from said ID pond, obtains the ID value; And after converting this ID value into predetermined system, form operational database table major key field.
Preferably; The said step of obtaining current maximum ID value also comprises before: judge whether database table major key field or ID value in the ID pond use up; If used up then continued the above-mentioned step of obtaining current maximum identifier ID value; If do not use up then the direct ID value that from the ID pond, obtains operational database table major key field or the database table major key field that acquisition can supply generate from the ID pond; And after converting this ID value into predetermined system, form operational database table major key field.
Further, behind the operational database table major key field of said formation, also comprise:
Judge whether said database table major key field finally is saved in the database;
If be not saved in the database, then said database table major key field is recovered in the said ID pond, and the priority of the database table major key field of said recovery is higher than the database table major key field of non-recovery.
Preferably, said predetermined value is greater than 10, the natural number less than 10000.
Preferably, said 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 that said current maximum identifier ID value is added one and adds predetermined value to said current maximum identifier ID value, upgrades said current maximum ID value simultaneously;
First converting unit stores the ID pond into after being used for converting a said predetermined value ID value into predetermined system respectively, forms operational database table major key field;
First processing unit is used for from the operational database table major key field that store in said ID pond, obtaining the database table major key field that needs generate.
Preferably; Said device also comprises: first judging unit; Be used for judging whether the database table major key field in ID pond uses up; If used up then triggered first acquiring unit, first updating block and first converting unit is handled, if do not use up then trigger first processing unit processes.
Preferably; Said device also comprises: the first recovery unit; Be used for when the database table major key field of said first processing unit acquisition is not saved in database; Said database table major key field is recovered in the said ID pond, and the priority of the ID value of said 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 that said current maximum identifier ID value is added one and adds predetermined value to said current maximum identifier ID value, upgrades said current maximum ID value simultaneously;
Second processing unit is used for storing a said predetermined value ID value into the ID pond, and formation can supply to generate the ID value of database table major key field;
Second converting unit is used for obtaining the ID value from said ID pond, and after converting this ID value into predetermined system, forms the database table major key field of available use.
Preferably; Said device also comprises: second judging unit; Be used for judging whether the ID value in ID pond uses up, if used up then trigger second acquisition unit, second updating block and second processing unit processes, if do not use up then trigger second converting unit and handle.
Preferably; Said device also comprises: the second recovery unit; Be used for when the database table major key field of said second converting unit formation is not saved in database; Said database table major key field is recovered in the said ID pond, and the priority of the ID value of said 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 as using database sequence, must to insert database in advance.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; Obviously, the 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 property, 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 the object of the invention, technical scheme and advantage clearer, the embodiment that develops simultaneously with reference to the accompanying drawings is to further explain of the present invention.
As shown in Figure 1, be the method flow diagram of the embodiment of the invention one generation database table major key field, said method comprises:
Need to prove that said 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 when needs obtain, can get access to current maximum ID value.If, then when realizing, can create UID table (ID BigInt) in advance through the storage of the table of the UID in the database, wherein, have only a line item forever in the said UID table, be used to store current maximum ID value.
Need to prove that the setting range of said predetermined value very extensively 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 said maximum ID value is increased predetermined value, need current maximum ID value 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 said predetermined system for example can be the decimal system or two sexadecimals or three sexadecimals or six duodecimal number systems or the like also very extensively and very flexible; How many concrete settings depends primarily on actual needs, for example, and 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; Totally 36 characters of capitalization A-Z forms; 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 from 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 maybe 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 said 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 represented as follows:
Explain as follows in the face of above-mentioned false code down:
It is 100 that the ID tankage is set, when routine call getUID () method, when applying for an ID:
Judge at first whether the ID pond is empty or has used up, if the ID pond is empty or has used up that then go to get in the database last ID value, then with ID value+100 in the database, the storehouse Updates Information.Then with the ID pond with database ID value+1, be filled into the ID pond after database ID value+2...... database ID value+100 convert 36 systems respectively into, 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 a major key of this record distribution (ID).At this moment the getUID () method of routine call UID class obtains an ID, then possibly be expressed as: 0000001.And if, then possibly be expressed as: A40B4B44-802A-41CD-97AB-B13047D6A984 with ID of existing GUID method acquisition.Obviously, 7 fixing 44 meetings than existing GUID method of the present invention are many efficiently, also little many of storage space.
Obviously, the present invention can obtain 17 ID character string that never repeat through getUID () method.Need to prove that here if in realization, adopt individual server, then this method is through being arranged to thread to guarantee the uniqueness of ID character string.If adopt a plurality of servers, then through 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 said formation, also comprise:
Judge whether said database table major key field finally is saved in the database, if be not saved in the database, then said database table major key field is recovered in the said ID pond, and the priority of the ID value of said 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, can also said ID also be returned so, use to other application user.When realizing, can the ID that reclaim be also placed in and supply subsequent application user use in the ID pond; Also can the ID that reclaim be placed in the ID pond, but the priority of the ID value that reclaims be arranged to be higher than the priority of the ID value of non-recovery simultaneously; Certainly can also the ID that reclaim be placed in the special recovery ID pond, the priority in this recovery ID pond is higher than aforesaid ID pond, when obtaining, arrives first 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 can the ID that reclaim 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, said method comprises:
Need to prove that said 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 when needs obtain, can get access to current maximum ID value.If, then when realizing, can create UID table (ID BigInt) in advance through the storage of the table of the UID in the database, wherein, have only a line item forever in the said UID table, be used to store current maximum ID value.
Need to prove that the setting range of said predetermined value very extensively 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 said maximum ID value is increased predetermined value, need current maximum ID value 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 said predetermined system for example can be the decimal system or two sexadecimals or three sexadecimals or six duodecimal number systems or the like also very extensively and very flexible, how many concrete settings depends primarily on actual needs.
In addition; The said 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 the ID value of the database table major key field that does not use up then from the ID pond, obtain supply to generate, and with this ID value convert into be scheduled to system after, form operational database table major key field.
When stating method in realization, specifically can adopt getUID () method, its false code is represented as follows:
Explain as follows in the face of above-mentioned false code down:
It is 100 that the ID tankage is set, when routine call getUID () method, when applying for an ID:
Judge at first whether the ID pond is empty or has used up, if the ID pond is empty or has used up that then go to get in the database last ID value, then with ID value+100 in the database, the storehouse Updates Information.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 through getUID () method.In addition, can also do following improvement in the foregoing description one, promptly behind the operational database table major key field of said formation, also comprise:
Judge whether said database table major key field finally is saved in the database, if be not saved in the database, then said database table major key field is recovered in the said ID pond, and the priority of the ID value of said 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, can also said ID also be returned so, use to other application user.When realizing, can the ID that reclaim be also placed in and supply subsequent application user use in the ID pond; Also can the ID that reclaim be placed in the ID pond, but the priority of the ID value that reclaims be arranged to be higher than the priority of the ID value of non-recovery simultaneously; Certainly can also the ID that reclaim be placed in the special recovery ID pond, the priority in this recovery ID pond is higher than aforesaid ID pond, when obtaining, arrives first 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 can the ID that reclaim be utilized once more, the present invention does not limit concrete implementation.
As shown in Figure 3, be that the embodiment of the invention three generates the apparatus structure synoptic diagram of 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:
Said first acquiring unit 310 is used to obtain current maximum identifier ID value;
Said first updating block 320 is used for said maximum ID value is increased predetermined value, upgrades said current maximum ID value simultaneously;
Said first converting unit 330 stores the ID pond into after being used for converting a said predetermined value ID value into predetermined system respectively, forms operational database table major key field;
Said first processing unit 340 is used for from the operational database table major key field that store in said ID pond, obtaining the database table major key field that needs generate.
Wherein, said 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; Said device can further include: the first recovery unit 360; Be used for when the database table major key field of said first processing unit 340 acquisitions is not saved in database; Said database table major key field is recovered in the said ID pond, and the priority of the ID value of said recovery is arranged to be higher than the ID value of non-recovery.
As shown in Figure 4, be the apparatus structure synoptic diagram of the embodiment of the invention four generation database table major key fields.This device comprises: second acquisition unit 410, second updating block 420, second processing unit 430, second converting unit 440; Wherein:
Said second acquisition unit 410 is used to obtain current maximum identifier ID value;
Said second updating block 420 is used for said maximum ID value is increased predetermined value, upgrades said current maximum ID value simultaneously;
Said second processing unit 430 is used for storing a said predetermined value ID value into the ID pond, and formation can supply to generate the ID value of database table major key field;
Said second converting unit 440 is used for obtaining the ID value from said ID pond, and after converting this ID value into predetermined system, forms the database table major key field of available use.
Wherein, said 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; Said device can further include: the second recovery unit 460; Be used for when the database table major key field of said second converting unit 440 formation is not saved in database; Said database table major key field is recovered in the said ID pond, and the priority of the ID value of said 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 here.
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 accomplish through 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 said 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 as using database sequence, must to insert database in advance.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 concrete example 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 scheme of the present invention; Simultaneously, for one of ordinary skill in the art, according to thought of the present invention, the part that on embodiment and range of application, all can change, in sum, this description should not be construed as limitation of the present invention.
Claims (10)
1. a method that generates the database table major key field is characterized in that, comprising:
Obtain current maximum identifier ID value;
Said current maximum identifier ID value is added one add predetermined value, upgrade said current maximum ID value simultaneously to said current maximum identifier ID value;
Store in the ID pond after converting a said predetermined value ID value into predetermined system respectively, form operational database table major key field; Perhaps a said predetermined value ID value is stored in the ID pond; Formation can supply to generate the ID value of database table major key field, when needs generate the database table major key field, from said ID pond, obtains the ID value; And after converting this ID value into 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 said step of obtaining current maximum ID value also comprises before: judge whether database table major key field or ID value in the ID pond use up; If used up then continued the step in the claim 1; If do not use up then directly from the ID pond, obtain operational database table major key field or the ID value of the database table major key field that from the ID pond, obtains supply to generate, and with this ID value convert into be scheduled to system after, 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 said formation, also comprises:
Judge whether said database table major key field finally is saved in the database;
If be not saved in the database, then said database table major key field is recovered in the said ID pond, and the priority of the database table major key field of said recovery is higher than the database table major key field of non-recovery.
4. according to the method for any described generation database table major key field among the claim 1-3, it is characterized in that said predetermined value is greater than 10, the natural number less than 10000.
5. according to the method for any described generation database table major key field among the claim 1-3, it is characterized in that said predetermined system is the decimal system or two sexadecimals or three sexadecimals or six duodecimal number systems.
6. a 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 that said current maximum identifier ID value is added one and adds predetermined value to said current maximum identifier ID value, upgrades said current maximum ID value simultaneously;
First converting unit stores the ID pond into after being used for converting a said predetermined value ID value into predetermined system respectively, forms operational database table major key field;
First processing unit is used for from the operational database table major key field that store in said ID pond, obtaining the database table major key field that needs generate.
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 database table major key field in ID pond uses up, if used up then trigger first acquiring unit, first updating block and first converting unit is handled, 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:
The first recovery unit; Be used for when the database table major key field of said first processing unit acquisition is not saved in database; Said database table major key field is recovered in the said ID pond, and the priority of the ID value of said recovery is arranged to be higher than the ID value of non-recovery.
9. a 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 that said current maximum identifier ID value is added one and adds predetermined value to said current maximum identifier ID value, upgrades said current maximum ID value simultaneously;
Second processing unit is used for storing a said predetermined value ID value into the ID pond, and formation can supply to generate the ID value of database table major key field;
Second converting unit is used for obtaining the ID value from said ID pond, and after converting this ID value into 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, second updating block and second processing unit processes, if do not use up then trigger second converting unit and handle.
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 CN101661509A (en) | 2010-03-03 |
| CN101661509B true 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 (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107133285A (en) * | 2017-04-18 | 2017-09-05 | 北京北信源软件股份有限公司 | A kind of distributed major key generation method and device |
Families Citing this family (11)
| 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 |
| CN102999525B (en) * | 2011-09-16 | 2016-08-03 | 深圳市金蝶中间件有限公司 | Tables of data processing method and system |
| 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 |
| CN103020268B (en) * | 2012-12-26 | 2016-05-04 | 大唐软件技术股份有限公司 | Relevant database sequence number application process and system |
| CN103324733A (en) * | 2013-06-30 | 2013-09-25 | 四川效率源信息安全技术有限责任公司 | File reconstructable storage and management method based on database |
| CN104423901B (en) * | 2013-08-29 | 2018-11-06 | 北大方正集团有限公司 | Variable sequence data auto-generation method and system |
| CN105630991B (en) * | 2015-12-25 | 2019-11-01 | 北京奇虎科技有限公司 | ID automatic generation method 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 |
Citations (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
Patent Citations (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 |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107133285A (en) * | 2017-04-18 | 2017-09-05 | 北京北信源软件股份有限公司 | A kind of distributed major key generation method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101661509A (en) | 2010-03-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101661509B (en) | Method for generating major key field of database table and device thereof | |
| Floratou et al. | Column-oriented storage techniques for MapReduce | |
| CN101876983B (en) | Method for partitioning database and system thereof | |
| JP6410825B2 (en) | Incremental and concatenated redistribution to extend online shared nothing database | |
| CN101661391B (en) | Object serializing method, object deserializing method, device and system | |
| CN104252536B (en) | A kind of internet log data query method and device based on hbase | |
| US8392473B2 (en) | Fast hierarchical enrichment | |
| CN106326361B (en) | Data query method and device based on HBase database | |
| WO2016183539A1 (en) | Data partitioning and ordering | |
| CN104102710A (en) | Massive data query method | |
| CN104067216A (en) | System and method for implementing a scalable data storage service | |
| Barmpis et al. | Comparative analysis of data persistence technologies for large-scale models | |
| US20110004638A1 (en) | Attributed key-value-store database system | |
| CN103312791A (en) | Internet of things heterogeneous data storage method and system | |
| EP2780834A1 (en) | Data processing service | |
| CN101727502A (en) | Data query method, data query device and data query system | |
| CN106570113B (en) | Mass vector slice data cloud storage method and system | |
| CN104090901A (en) | Method, device and server for processing data | |
| EP2556446A1 (en) | Columnar storage representations of records | |
| CN107247734A (en) | A kind of distributed data base major key generation method and system | |
| CN100517229C (en) | Data version upgrading method | |
| CN104657387A (en) | Data query method and device | |
| CN105447166A (en) | Keyword based information search method and system | |
| CN113177090A (en) | Data processing method and device | |
| CN102567419B (en) | Mass data storage device and method based on tree structure |
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 |