CN106168949A - The method and device that data base splits - Google Patents

The method and device that data base splits Download PDF

Info

Publication number
CN106168949A
CN106168949A CN201610286177.1A CN201610286177A CN106168949A CN 106168949 A CN106168949 A CN 106168949A CN 201610286177 A CN201610286177 A CN 201610286177A CN 106168949 A CN106168949 A CN 106168949A
Authority
CN
China
Prior art keywords
data
tables
indications
allocated
subdata base
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201610286177.1A
Other languages
Chinese (zh)
Other versions
CN106168949B (en
Inventor
潘高峰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Taikang Insurance Group Co Ltd
Taikang Online Property Insurance Co Ltd
Original Assignee
Taikang Insurance Group Co Ltd
Taikang Online Property Insurance Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Taikang Insurance Group Co Ltd, Taikang Online Property Insurance Co Ltd filed Critical Taikang Insurance Group Co Ltd
Priority to CN201610286177.1A priority Critical patent/CN106168949B/en
Publication of CN106168949A publication Critical patent/CN106168949A/en
Application granted granted Critical
Publication of CN106168949B publication Critical patent/CN106168949B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The disclosure is directed to the method and device that a kind of data base splits, the method includes: the predeterminated position in tables of data title to be allocated in data base uses the indications of ordering relation indicate;Described tables of data to be allocated is assigned at least two subdata base, wherein determines the subdata base at the tables of data place after distribution with the indications according to the described ordering relation in tables of data title.The technical scheme of the disclosure can prejudge the accurate location after data split, it is possible to increase the search efficiency after data base's fractionation.

Description

The method and device that data base splits
Technical field
It relates to database field, particularly relate to the method and device that a kind of data base splits.
Background technology
Along with the popularization of distributed arrangement Yu management mode, the fractionation of data base and integration are more and more universal, The basic thought that data base splits is that a data base is split as multiple data division, each data division It is respectively stored on different data bases, thus alleviates the performance issue of centralized database.
For the enterprise-level database that data volume is huge, split requirement the highest, should ensure to split Science, it is to avoid repeat or loss of data, ensure that follow-up inquiry is convenient and swift again.
The method that correlation technique provides is that the mode utilizing cryptographic Hash delivery is to carry out data base's fractionation.But this Class method typically requires and utilizes cryptographic Hash model to calculate every time, the most time-consuming and occupying system resources, And data distribution is directly perceived after calculating, it is accurate that user cannot be prejudged out after data are redistributed Position, it is necessary to just learnt by system display after a whole set of disassembler completes.
Based on the foregoing, it is desirable to provide the method and device that a kind of new data split.
It is only used for strengthening the reason of background of this disclosure in information above-mentioned disclosed in described background section Solving, therefore it can include not constituting the information to prior art known to persons of ordinary skill in the art.
Summary of the invention
For overcoming problem present in correlation technique, the disclosure provides a kind of point method and dress that data base tears open Put.
First aspect according to disclosure embodiment, it is provided that a kind of method that data base splits, including:
Predeterminated position in tables of data title to be allocated in data base is used the indications mark of ordering relation Show;
Described tables of data to be allocated is assigned at least two subdata base, wherein with according to tables of data The indications of the described ordering relation in title determines the subdata base at the tables of data place after distribution.
In an embodiment, described tables of data to be allocated is assigned to the behaviour at least two subdata base Work includes:
By the indications of the described ordering relation in described tables of data title to be allocated and described subdata base Set up corresponding relation;
According to described corresponding relation, described tables of data to be allocated is assigned in corresponding subdata base.
In an embodiment, by the indications of the described ordering relation in described tables of data title to be allocated The operation setting up corresponding relation with described subdata base includes:
Obtain the number of described at least two subdata base, and obtain described tables of data title to be allocated In the number of indications of described ordering relation, by the number of described indications and described subdata base Number modulus obtains the tables of data number that each subdata base is to be accommodated, according to described data table name to be allocated Described indications in title and described tables of data number, sequentially by the indications of described tables of data to be allocated Corresponding relation is set up with described subdata base.
In an embodiment, the indications of described ordering relation includes numeral sequentially or capitalization sequentially In letter or lower case sequentially or numeral, capitalization and lower case sequentially at least two The combination of person.
In an embodiment, described method also includes, according to the subdata of the tables of data after distribution with place Corresponding relation between storehouse, generates the dispensing position splitting distribution information for inquiring about tables of data.
Second aspect according to disclosure embodiment, it is provided that the device that a kind of data base splits, including:
Name identification unit, for using the predeterminated position in tables of data title to be allocated in data base The indications of ordering relation indicates;
Tables of data allocation unit, for being assigned at least two subdata base by described tables of data to be allocated In, wherein determine the tables of data after distribution with the indications according to the described ordering relation in tables of data title The subdata base at place.
In an embodiment, described tables of data allocation unit includes that title correspondence subelement and distribution are single Unit;
Described title correspondence subelement, for closing the described sequence in described tables of data title to be allocated The indications of system and described subdata base set up corresponding relation;
Described distribution subelement, for being assigned to described tables of data to be allocated according to described corresponding relation In corresponding subdata base.
In an embodiment, described title correspondence subelement is used for, and obtains described at least two subdata base Number, and obtain the number of the indications of described ordering relation in described tables of data title to be allocated Mesh, obtains each subdata base by the number of described indications and the number modulus of described subdata base to be accommodated Tables of data number, according to the described indications in described tables of data title to be allocated and described tables of data Number, sequentially sets up corresponding relation by the indications of described tables of data to be allocated and described subdata base.
In an embodiment, the indications of described ordering relation includes numeral sequentially or capitalization sequentially In letter or lower case sequentially or numeral, capitalization and lower case sequentially at least two The combination of person.
In an embodiment, described device also includes distributing information generating unit, after according to distribution Corresponding relation between tables of data and the subdata base at place, generates fractionation distribution information and is used for inquiring about data The dispensing position of table.
Embodiment of the disclosure that the technical scheme of offer can include following beneficial effect:
The technical scheme of the disclosure can prejudge the accurate location after data split, it is possible to increase data Search efficiency after the fractionation of storehouse.
It should be appreciated that it is only exemplary and explanatory that above general description and details hereinafter describe , the disclosure can not be limited.
Accompanying drawing explanation
Accompanying drawing herein is merged in description and constitutes the part of this specification, it is shown that meet this Bright embodiment, and for explaining the principle of the present invention together with description.
Fig. 1 is the flow chart of the method split according to a kind of data base shown in an exemplary embodiment;
Fig. 2 is the flow chart of the method split according to a kind of data base shown in an exemplary embodiment;
Fig. 3 is according to the flow chart of step S220 in the method shown in an exemplary embodiment;
Fig. 4 is the schematic diagram of the device split according to a kind of data base shown in an exemplary embodiment;
Fig. 5 is the schematic diagram of the device split according to a kind of data base shown in an exemplary embodiment.
Detailed description of the invention
Here will illustrate exemplary embodiment in detail, its example represents in the accompanying drawings.Following When description relates to accompanying drawing, unless otherwise indicated, the same numbers in different accompanying drawings represents same or analogous Key element.Embodiment described in following exemplary embodiment does not represent the institute consistent with the present invention There is embodiment.On the contrary, they only with as appended claims describes in detail, the one of the present invention The example of the apparatus and method that a little aspects are consistent.
Embodiment one
Fig. 1 is the flow chart of the method split according to a kind of data base shown in an exemplary embodiment, this Embodiment is applicable to be split to the tables of data in data base the situation of at least two data base, such as Fig. 1 Shown in, the method that the data base described in the present embodiment splits includes:
In step s 110, the predeterminated position in tables of data title to be allocated in data base is used row The indications of order relation indicates.
In the step s 120, tables of data to be allocated is assigned at least two subdata base, wherein The subdata at the tables of data place after distribution is determined with the indications according to the ordering relation in tables of data title Storehouse.
Based on above-mentioned, the technical scheme of the disclosure can prejudge the accurate location after data split, and carries Search efficiency after high data base fractionation.
Embodiment two
Fig. 2 is the flow chart of the method split according to a kind of data base shown in an exemplary embodiment, as Shown in Fig. 2, the method that the data base described in the present embodiment splits includes:
In step S210, the predeterminated position in tables of data title to be allocated in data base is used row The indications of order relation indicates.Wherein " predeterminated position " can be set as required, such as Tables of data title " ABC** ", it is possible to " * * " is set as the predeterminated position of indications, such as " ABC45 ", " ABC64 " etc. are tables of data title.Predeterminated position in the present embodiment is not only Simply mean to position last and the Arabic numerals of penultimate of tables of data title, if tables of data Quantity is bigger, it is also possible to represent by the sequence numeral of three even more multidigits, and the numeral that sorts can also In other positions of tables of data title, the most former position of such as front two or front three.
Wherein the indications of ordering relation can be numeral sequentially, capitalization sequentially or sequentially little Write mother, it is also possible to at least a combination of both in numeral sequentially, capitalization and lower case. Such as, indications can be 1,2,3 ..., it is also possible to for A, B, C ..., it is also possible to for A, b, c ..., it is also possible to for A1, A2, A3 ..., it is also possible to for aB1, aB2, aB3 ... etc. Deng, will not enumerate herein.It addition, the numeral in the present embodiment is possible not only to be Arabic numerals, Can also is that Roman number, no matter numeral is with alphabetical, as long as have default sequence or artificial the most about definite sequence Indications be used equally to data base split foundation, be not especially limited in this present embodiment.
In step S220, by indications and the subnumber of the ordering relation in tables of data title to be allocated Corresponding relation is set up according to storehouse.Such as, in the present embodiment can be according to the number of at least two subdata base Set up the corresponding relation between indications and the subdata base in tables of data title to be allocated, below to step Rapid S220 illustrates.
Fig. 3 is according to the flow chart of step S220 in the method shown in an exemplary embodiment, such as Fig. 3 Shown in, the indications of the ordering relation in tables of data title to be allocated is built by the present embodiment with subdata base The step of vertical corresponding relation includes:
As it is shown on figure 3, in step S221, obtain the number of at least two subdata base.
In step S222, obtain the number of the indications of ordering relation in tables of data title to be allocated Mesh.
In step S223, the number modulus of the number of indications with subdata base is obtained each subdata The tables of data number that storehouse is to be accommodated.
In step S224, according to the sign in the tables of data title to be allocated obtained in step S222 Symbol and step S223 obtain tables of data number, sequentially by indications and the subnumber of tables of data to be allocated Corresponding relation is set up according to storehouse.
According to above-mentioned steps by tables of data to be allocated according to the indications of the predeterminated position in tables of data title It is assigned in the subdata base corresponding to indications.
As in figure 2 it is shown, in step S230, according to the subdata base of the tables of data after distribution with place Between corresponding relation, generate and split distribution information for inquiring about the dispensing position of tables of data.
In tables of data title, the numeral of position last and penultimate is as a example by indications, carries out Data split method flow approximately as:
1) by tables of data title to be allocated in data base with position last and the number of penultimate Word is defined as the indications with ordering relation, the entitled ABC45 of two tables of data the most therein And ABC64.
2) when data base once splits, such as, data base's entirety is divided into 2 subdata bases, then Tables of data ABC00-ABC50 is distributed to the first subdata base by definable, and by tables of data ABC51-ABC99 distributes to the second subdata base.
3) according to the ordering relation made an appointment, user can directly judge that tables of data ABC45 is stored in In first subdata base, ABC64 is stored in the second subdata base, and foundation is suitable according to array Sequence, numeral 45 is between 00-50, during therefore tables of data ABC45 is positioned at the first subdata base, and Numeral 64 is between 51-99, during therefore tables of data ABC64 is positioned at the second subdata base.
4) when data base carries out secondary fractionation, such as, whole data base is divided into 10 subdata bases, Then tables of data ABC00-10 is distributed to the first subdata base by definable, tables of data ABC11-20 is divided Being assigned in the second subdata base, next coming in order are analogized.
5) after above-mentioned steps, the ordering relation that user can directly make an appointment, it is judged that tables of data ABC45 is stored in the 5th subdata base, and tables of data ABC64 is stored in the 7th subdata base.
Also, it should be noted wherein the method for splitting of the data base that the disclosure is provided is not as office Limit, tables of data title can use numeral, upper and lower case letter etc. to have the indications of Rankine-Hugoniot relations.It addition, Data base splits definition and tables of data distribution can be passed through database command (such as sql script) and come real Existing.
Based on above-mentioned, the fractionation of data base, this method can be completed according to the method that the present embodiment provides Simple, it is to avoid tediously long logical operations, user also can be made to understand in advance after data split simultaneously Distribution deployment scenarios, and can be realized by database script order.
Embodiment three
Fig. 4 is the schematic diagram of the device split according to a kind of data base shown in an exemplary embodiment, as Shown in Fig. 4, this device 1000 includes name identification unit 310 and tables of data allocation unit 320.
Wherein name identification unit 310 is for by the default position in tables of data title to be allocated in data base Put and use the indications of ordering relation to indicate.Wherein in the present embodiment, the indications of ordering relation includes sequentially Numeral or capitalization sequentially or lower case sequentially or numeral sequentially, capitalization And at least a combination of both in lower case.This tables of data allocation unit 320 is for by number to be allocated It is assigned at least two subdata base according to table, wherein with the mark according to the ordering relation in tables of data title Show the subdata base according with the tables of data place after determining distribution.
Wherein tables of data to be allocated is pressed by tables of data allocation unit 320 according to the step shown in above-mentioned Fig. 3 Indications according to the predeterminated position in tables of data title is assigned in the subdata base corresponding to indications, this Embodiment repeats no more.
As a example by still using the numeral of position last in tables of data title and penultimate as indications, enter Row data split method flow approximately as:
Name identification unit 310 by tables of data title to be allocated in data base with position last and fall The deputy definition of number is the indications with ordering relation, the name of two tables of data the most therein It is referred to as ABC45 and ABC64.When data base once splits, tables of data allocation unit 320 will Data base's entirety is divided into 2 subdata bases, then definable is by tables of data ABC00-ABC50 distribution to the One subdata base, and tables of data ABC51-ABC99 is distributed to the second subdata base.User can basis The ordering relation made an appointment, directly judges that tables of data ABC45 is stored in the first subdata base, ABC64 is stored in the second subdata base, and according to being according to array order, numeral 45 is positioned at Between 00-50, during therefore tables of data ABC45 is positioned at the first subdata base, and numeral 64 is positioned at 51-99 Between, during therefore tables of data ABC64 is positioned at the second subdata base.When data base carries out secondary fractionation Time, whole data base is divided into 10 subdata bases by tables of data allocation unit 320, then definable is by data Tables of data ABC11-20, to the first subdata base, is distributed to the second subdata by Table A BC00-10 distribution In storehouse, next coming in order are analogized.Finally, the sequence that tables of data allocation unit 320 can directly be made an appointment is closed System, it is judged that tables of data ABC45 is stored in the 5th subdata base, and tables of data ABC64 is stored in In 7th subdata base.
As shown in Figure 4, this device 1000 also includes distribute information generating unit 330, for according to dividing The corresponding relation between tables of data and the subdata base at place after joining, generates fractionation distribution information and is used for looking into Ask the dispensing position of tables of data.
About the device in above-described embodiment, the concrete mode that wherein unit performs to operate is having Close in the embodiment of the method and be described in detail, explanation will be not set forth in detail herein.
Data base's detachment device that the present embodiment provides can perform the embodiment of the present invention one and embodiment two is carried The method that the data base of confession splits, possesses the corresponding functional module of execution method and beneficial effect.
Embodiment four
Fig. 5 is the schematic diagram according to a kind of data base's detachment device shown in an exemplary embodiment, such as figure Shown in 5, this device 2000 includes: name identification unit 410, tables of data allocation unit 420 and point Join information generating unit 430.
Name identification unit 410 is for adopting the predeterminated position in tables of data title to be allocated in data base Indicate by the indications of ordering relation.Tables of data allocation unit 420 is for by tables of data distribution to be allocated In at least two subdata base, wherein determine with the indications according to the ordering relation in tables of data title The subdata base at the tables of data place after distribution.
Further, as it is shown in figure 5, the tables of data allocation unit 420 in the present embodiment includes: title Corresponding subelement 421 and distribution subelement 422, wherein title correspondence subelement 421 will be for treating point The indications of the ordering relation in the tables of data title joined and subdata base set up corresponding relation.Distribution is single Unit 422 is for being assigned to corresponding subdata base according to above-mentioned corresponding relation by tables of data to be allocated In.
Wherein title correspondence subelement 421 is for obtaining the number of at least two subdata base, and obtains The number of the indications of the ordering relation in tables of data title to be allocated, by number and the subnumber of indications The tables of data number that each subdata base is to be accommodated is obtained, according to tables of data to be allocated according to the number modulus in storehouse Indications in title and tables of data number, sequentially by indications and the subdata base of tables of data to be allocated Set up corresponding relation.
As it is shown in figure 5, this device 2000 also includes distributing information generating unit 430, for according to distribution After tables of data and the subdata base at place between corresponding relation, generate split distribution information be used for inquiring about The dispensing position of tables of data.
About the device in above-described embodiment, the concrete mode that wherein unit performs to operate is having Close in the embodiment of the method and be described in detail, explanation will be not set forth in detail herein.
Data base's detachment device that the present embodiment provides can perform the embodiment of the present invention one and embodiment two is carried The method that the data base of confession splits, possesses the corresponding functional module of execution method and beneficial effect.
Those skilled in the art, after considering description and putting into practice invention disclosed herein, will readily occur to this Other embodiment of invention.The application is intended to any modification, purposes or the adaptability of the present invention Change, these modification, purposes or adaptations are followed the general principle of the present invention and include these public affairs Open undocumented common knowledge in the art or conventional techniques means.Description and embodiments only by Being considered as exemplary, true scope and spirit of the invention are pointed out by claim below.
It should be appreciated that the invention is not limited in described above and illustrated in the accompanying drawings accurately Structure, and various modifications and changes can carried out without departing from the scope.The scope of the present invention is only by institute Attached claim limits.

Claims (10)

1. the method that a data base splits, it is characterised in that including:
Predeterminated position in tables of data title to be allocated in data base is used the indications mark of ordering relation Show;
Described tables of data to be allocated is assigned at least two subdata base, wherein with according to tables of data The indications of the described ordering relation in title determines the subdata base at the tables of data place after distribution.
Method the most according to claim 1, it is characterised in that by described tables of data to be allocated The operation being assigned at least two subdata base includes:
By the indications of the described ordering relation in described tables of data title to be allocated and described subdata base Set up corresponding relation;
According to described corresponding relation, described tables of data to be allocated is assigned in corresponding subdata base.
Method the most according to claim 2, it is characterised in that by described tables of data to be allocated The operation that the indications of the described ordering relation in title and described subdata base set up corresponding relation includes:
Obtain the number of described at least two subdata base, and obtain described tables of data title to be allocated In the number of indications of described ordering relation, by the number of described indications and described subdata base Number modulus obtains the tables of data number that each subdata base is to be accommodated, according to described data table name to be allocated Described indications in title and described tables of data number, sequentially by the indications of described tables of data to be allocated Corresponding relation is set up with described subdata base.
Method the most according to claim 1, it is characterised in that the indications of described ordering relation Including numeral sequentially or capitalization sequentially or lower case sequentially or numeral sequentially, At least a combination of both in capitalization and lower case.
Method the most according to claim 1, it is characterised in that described method also includes:
According to the corresponding relation between tables of data and the subdata base at place after distribution, generate and split distribution Information is for inquiring about the dispensing position of tables of data.
6. the device that a data base splits, it is characterised in that including:
Name identification unit, for using the predeterminated position in tables of data title to be allocated in data base The indications of ordering relation indicates;
Tables of data allocation unit, for being assigned at least two subdata base by described tables of data to be allocated In, wherein determine the tables of data after distribution with the indications according to the described ordering relation in tables of data title The subdata base at place.
Device the most according to claim 6, it is characterised in that described tables of data allocation unit bag Include title correspondence subelement and distribution subelement;
Described title correspondence subelement, for closing the described sequence in described tables of data title to be allocated The indications of system and described subdata base set up corresponding relation;
Described distribution subelement, for being assigned to described tables of data to be allocated according to described corresponding relation In corresponding subdata base.
Device the most according to claim 7, it is characterised in that described title correspondence subelement is used In, obtain the number of described at least two subdata base, and obtain described tables of data title to be allocated In the number of indications of described ordering relation, by the number of described indications and described subdata base Number modulus obtains the tables of data number that each subdata base is to be accommodated, according to described data table name to be allocated Described indications in title and described tables of data number, sequentially by the indications of described tables of data to be allocated Corresponding relation is set up with described subdata base.
Device the most according to claim 6, it is characterised in that the indications of described ordering relation Including numeral sequentially or capitalization sequentially or lower case sequentially or numeral sequentially, At least a combination of both in capitalization and lower case.
Device the most according to claim 6, it is characterised in that described device also includes distribution letter Breath signal generating unit, the corresponding relation between tables of data and the subdata base at place after being used for according to distribution, Generate the dispensing position splitting distribution information for inquiring about tables of data.
CN201610286177.1A 2016-05-03 2016-05-03 The method and device that database is split Active CN106168949B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610286177.1A CN106168949B (en) 2016-05-03 2016-05-03 The method and device that database is split

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610286177.1A CN106168949B (en) 2016-05-03 2016-05-03 The method and device that database is split

Publications (2)

Publication Number Publication Date
CN106168949A true CN106168949A (en) 2016-11-30
CN106168949B CN106168949B (en) 2018-11-16

Family

ID=57358926

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610286177.1A Active CN106168949B (en) 2016-05-03 2016-05-03 The method and device that database is split

Country Status (1)

Country Link
CN (1) CN106168949B (en)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107798030A (en) * 2017-02-17 2018-03-13 平安科技(深圳)有限公司 The method for splitting and device of tables of data
CN108256091A (en) * 2018-01-25 2018-07-06 郑州云海信息技术有限公司 A kind of vertical method for splitting based on SQLite databases
CN108399175A (en) * 2017-02-07 2018-08-14 阿里巴巴集团控股有限公司 A kind of storage of data, querying method and its device
CN117633059A (en) * 2024-01-25 2024-03-01 广东广宇科技发展有限公司 Data query method based on distributed database

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101562664A (en) * 2009-05-20 2009-10-21 中兴通讯股份有限公司 Ticket processing method and system
CN102053982A (en) * 2009-11-02 2011-05-11 阿里巴巴集团控股有限公司 Method and equipment for managing database information
CN102541997A (en) * 2011-11-23 2012-07-04 苏州阔地网络科技有限公司 Database execution method and system for automatic database partitioning
CN103136315A (en) * 2011-11-22 2013-06-05 中兴通讯股份有限公司 Storage processing method and storage processing device for call detail record (CDR) data

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101562664A (en) * 2009-05-20 2009-10-21 中兴通讯股份有限公司 Ticket processing method and system
CN102053982A (en) * 2009-11-02 2011-05-11 阿里巴巴集团控股有限公司 Method and equipment for managing database information
CN103136315A (en) * 2011-11-22 2013-06-05 中兴通讯股份有限公司 Storage processing method and storage processing device for call detail record (CDR) data
CN102541997A (en) * 2011-11-23 2012-07-04 苏州阔地网络科技有限公司 Database execution method and system for automatic database partitioning

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108399175A (en) * 2017-02-07 2018-08-14 阿里巴巴集团控股有限公司 A kind of storage of data, querying method and its device
CN108399175B (en) * 2017-02-07 2022-04-12 阿里巴巴集团控股有限公司 Data storage and query method and device
CN107798030A (en) * 2017-02-17 2018-03-13 平安科技(深圳)有限公司 The method for splitting and device of tables of data
CN108256091A (en) * 2018-01-25 2018-07-06 郑州云海信息技术有限公司 A kind of vertical method for splitting based on SQLite databases
CN117633059A (en) * 2024-01-25 2024-03-01 广东广宇科技发展有限公司 Data query method based on distributed database
CN117633059B (en) * 2024-01-25 2024-04-09 广东广宇科技发展有限公司 Data query method based on distributed database

Also Published As

Publication number Publication date
CN106168949B (en) 2018-11-16

Similar Documents

Publication Publication Date Title
CN106168949A (en) The method and device that data base splits
US8630577B2 (en) Item banking system for standards-based assessment
Christopher Governance paradigms of public universities: An international comparative study
Kardes Reaching middle class consumers in emerging markets: Unlocking market potential through urban-based analysis
Dyck et al. Identifying common characteristics in fundamental, integrated, and agile software development methodologies
CN103902717A (en) System and method for personalizing internal portals of enterprises
Jones Indonesian cultural policy in the reform era
CN103744676A (en) Method for displaying relevance of multi-level information
Gustafsson et al. The role of VDC professionals in the construction industry
CN106169111A (en) A kind of configurable business process analysis method based on the constraint of data stream
Nguyen et al. A comparative study of electronic performance support systems
CN107766033A (en) A kind of quick demand method for splitting based on problem framework
CN103210436A (en) Real-time learning system
Cuhls et al. Roadmapping: comparing cases in China and Germany
Yurchyshena et al. Using R Programming Language to Cluster of Universities Based on Sustainability Potential Indicators
Leite et al. Integrating an architectural engineering undergraduate program with building information modeling
Lauesen et al. Virtual windows: Linking user tasks, data models, and interface design
Gilroy et al. The evaluation of course quality through a service template
CN103500314A (en) Authorization control system construction method and device
Turkin et al. The approach to drawing up a list of professional competences in the field of software engineering for harmonization of educational standards
CN104637011A (en) On-line teaching tutorship system and method
CN109063031A (en) Data mining method, apparatus and server
CN105678661A (en) Education admission information automated management system
Kroma et al. A Taxonomy for Guiding XR Prototyping Decisions by the Non-Tech-Savvy
Ivongbe et al. E-MARKETING MATRIX FRAMEWORK: THE TWO-FACTOR PARADIGM SHIFT

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant