CN110069488A - A kind of date storage method, method for reading data and its device - Google Patents
A kind of date storage method, method for reading data and its device Download PDFInfo
- Publication number
- CN110069488A CN110069488A CN201710919122.4A CN201710919122A CN110069488A CN 110069488 A CN110069488 A CN 110069488A CN 201710919122 A CN201710919122 A CN 201710919122A CN 110069488 A CN110069488 A CN 110069488A
- Authority
- CN
- China
- Prior art keywords
- data
- identification
- subregion
- stored
- partition
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
Abstract
A kind of date storage method, method for reading data and its device provided by the invention, applied in the first equipment, it include the data subregion that at least one database table and each database table include preset number in first equipment, each data subregion all has partition identification, this method comprises: obtaining the Data Identification of data to be stored；The partition identification of the corresponding data subregion of data to be stored is determined according to Data Identification；Data to be stored is stored to the determining corresponding data subregion of partition identification.The present invention database table is arranged the data subregion of fixed preset number, and Labelling Regions are carried out for each data subregion, when carrying out the storage of data to be stored, obtain the Data Identification of data to be stored, then partition identification is determined according to Data Identification, finally stored data to be stored to the determining corresponding data subregion of partition identification, the present invention is by being fixed subregion to database table, the growth of effective control partition quantity, while also improving and looking into new capability.
Description
Technical field
The present invention relates to technical field of data processing, more particularly to a kind of date storage method, method for reading data
And its device.
Background technique
SEM (Search Engine Marketing, search engine marketing) operation system uses Greenplum number at present
According to library as data warehouse, storage and the query analysis of data are supported.Due to facing the storage and inquiry of mass data, to meet
The performance of inquiry will reasonably design database, and table subregion is a kind of most common design scheme, to database table
Carry out subregion after, stored in every piece of subregion data volume will the data volume of subregion be small relatively, inquiry when application partition cut out
The data volume that can reduce inquiry is cut, to improve the performance of inquiry.
Existing scheme is as follows to the table partitioning strategies of SEM operation system: use secondary partition, first by " project label " into
Row level-one subregion, then secondary partition is carried out by " day ", all items of all advertisers are stored in SEM system
In Greenplum data warehouse.Assuming that there is 5 advertisers, each advertiser has 10 projects, then database table daily will
There are 50 partition tables, and actual services have more advertisers and project, therefore the partition table in database table can be with industry
The expansion of business is more and more.Get off being increasing with partition table for a long time, will make in database can storage data quantity it is more next
It is fewer, while being increasing with partition table, cause query performance poor, or even cause system unavailable.
Summary of the invention
In view of the above problems, it proposes on the present invention overcomes the above problem or at least be partially solved in order to provide one kind
State the date storage method, method for reading data and its device of problem.
Specific technical solution is as follows:
A kind of date storage method is applied in the first equipment, includes at least one database table in first equipment
And each described database table includes the data subregion of preset number, each data subregion all has partition identification, the method
Include:
Obtain the Data Identification of data to be stored；
The partition identification of the corresponding data subregion of the data to be stored is determined according to the Data Identification；
The data to be stored is stored to the determining corresponding data subregion of the partition identification.
Preferably, the Data Identification is the project label of the data to be stored.
Preferably, the subregion mark that the corresponding data subregion of the data to be stored is determined according to the Data Identification
Know, comprising:
The project label of the data to be stored is subjected to modular arithmetic to the preset number, is taken the remainder；
The remainder is determined to the partition identification of the corresponding data subregion of the data to be stored.
Preferably, the Data Identification is the project name of the data to be stored.
Preferably, the subregion mark that the corresponding data subregion of the data to be stored is determined according to the Data Identification
Know, comprising:
Extract the initial of the project name of the data to be stored；
The initial of the project name is determined as to the partition identification of the corresponding data subregion of the data to be stored.
A kind of method for reading data is applied in the first equipment, includes at least one database table in first equipment,
And each described database table includes the data subregion of preset data, all has partition identification, which comprises
Obtain the Data Identification of data to be read；
The partition identification of the corresponding data subregion of the data to be read is determined according to the Data Identification；
The data to be read are searched in the corresponding data subregion according to the partition identification, and will be described to be read
Data are read.
A kind of data storage device is applied in the first equipment, includes at least one database table in first equipment
And each described database table includes the data subregion of preset number, each data subregion all has partition identification, described device
Include:
First acquisition unit, for obtaining the Data Identification of data to be stored；
First determination unit, for determining point of the corresponding data subregion of the data to be stored according to the Data Identification
Area's mark；
Storage unit, for storing the data to be stored to the determining corresponding data subregion of the partition identification.
A kind of reading data device is applied in the first equipment, includes at least one database table in first equipment,
And each described database table includes the data subregion of preset data, all has partition identification, described device includes:
Second acquisition unit, for obtaining the Data Identification of data to be read；
Second determination unit, for determining point of the corresponding data subregion of the data to be read according to the Data Identification
Area's mark；
Reading unit, for searching the data to be read in the corresponding data subregion according to the partition identification,
And the data to be read are read.
A kind of storage medium, the storage medium include the program of storage,
Wherein, the equipment where controlling the storage medium when described program is run executes data as described above and deposits
Method for storing and/or method for reading data as described above.
A kind of processor, the processor are used to run program,
Wherein, date storage method as described above and/or data as described above are executed when described program is run
Read method.
By above-mentioned technical proposal, a kind of date storage method, method for reading data and its device provided by the invention are answered
It include at least one database table in the first equipment and each database table includes the number of preset number in the first equipment
According to subregion, each data subregion all has partition identification, this method comprises: obtaining the Data Identification of data to be stored；According to data
Identify the partition identification for determining the corresponding data subregion of data to be stored；Data to be stored is stored to determining partition identification pair
The data subregion answered.The present invention database table is arranged the data subregion of fixed preset number, and is divided for each data subregion
Area's label obtains the Data Identification of data to be stored when carrying out the storage of data to be stored, is then determined according to Data Identification
The partition identification of the data subregion of data to be stored finally stores data to be stored to the determining corresponding data of partition identification
Subregion, the present invention are looked into newly by the way that subregion, the growth of effective control partition quantity is fixed to database table, while also improving
Performance.
The above description is only an overview of the technical scheme of the present invention, in order to better understand the technical means of the present invention,
And it can be implemented in accordance with the contents of the specification, and in order to allow above and other objects of the present invention, feature and advantage can
It is clearer and more comprehensible, the followings are specific embodiments of the present invention.
Detailed description of the invention
By reading the following detailed description of the preferred embodiment, various other advantages and benefits are common for this field
Technical staff will become clear.The drawings are only for the purpose of illustrating a preferred embodiment, and is not considered as to the present invention
Limitation.And throughout the drawings, the same reference numbers will be used to refer to the same parts.In the accompanying drawings:
Fig. 1 shows a kind of date storage method flow chart provided in an embodiment of the present invention；
Fig. 2 shows another date storage method flow charts provided in an embodiment of the present invention；
Fig. 3 shows another date storage method flow chart provided in an embodiment of the present invention；
Fig. 4 shows a kind of method for reading data flow chart provided in an embodiment of the present invention；
Fig. 5 shows a kind of data storage device structural schematic diagram provided in an embodiment of the present invention；
Fig. 6 shows a kind of reading data apparatus structure schematic diagram provided in an embodiment of the present invention.
Specific embodiment
Exemplary embodiments of the present disclosure are described in more detail below with reference to accompanying drawings.Although showing the disclosure in attached drawing
Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure without should be by embodiments set forth here
It is limited.On the contrary, these embodiments are provided to facilitate a more thoroughly understanding of the present invention, and can be by the scope of the present disclosure
It is fully disclosed to those skilled in the art.
Referring to Fig. 1, being applied in the first equipment, described first sets present embodiment discloses a kind of date storage method
It include at least one database table in standby and each described database table includes the data subregion of preset number, each data subregion
Partition identification is all had, specifically includes the following steps:
S101, the Data Identification for obtaining data to be stored.
It should be noted that above-mentioned the first equipment referred to carries out data management, each database using data warehouse technology
Data partition data in table can be identical or can also be different, such as: it, can be by the there are two database table in data warehouse
When one database table carries out subregion, it is arranged to 5 subregion numbers；When second database carries out subregion, it can be provided 5 subregions
The subregion number of number or other quantity.But the partition identification of the data subregion in same database table is different, every number
Partition identification according to subregion is unique.
Preferably, Data Identification is specifically as follows the project label of data to be stored or the project name of data to be stored.
Certainly, the Data Identification of data to be stored can be set with detailed programs, but for data subregion
Partition identification will with the Data Identification of data to be stored carry out same rule setting.
For example, when the Data Identification of data to be stored is project label (CampaignKey), and project label is number
Word, the corresponding partition identification for data subregion are also corresponding for number；When the Data Identification of data to be stored is project name
When, it is corresponding that label can be carried out for preset rule for the partition identification of data subregion, such as: it can be project name
Initial or other.
S102, the partition identification that the corresponding data subregion of data to be stored is determined according to Data Identification.
Preferably, it please refers to shown in Fig. 2, when Data Identification is the project label of data to be stored, S102's is specifically held
Row process is as follows:
S201, the project label of data to be stored is subjected to modular arithmetic to preset number, taken the remainder.
S202, the partition identification that remainder is determined to the corresponding data subregion of data to be stored.
It should be noted that for example: having carried out 5 subregions for first database table, it may be assumed that first database table includes 5
A data subregion is arranged partition identifications to this 5 data subregions respectively, can be set to 0,1,2,3,4, for get to
The project label of storing data is 7024, then to 7024%5, remainder obtains 4, it is determined that the corresponding data subregion of data to be stored
Partition identification be 4.
Preferably, it please refers to shown in Fig. 3, when Data Identification is the project name of data to be stored, S102's is specifically held
Row process is as follows:
S301, extract data to be stored project name initial；
S302, the partition identification that the initial of project name is determined as to the corresponding data subregion of data to be stored.
It should be noted that for example: having carried out 26 subregions for first database table, it may be assumed that first database table includes
26 data subregions are arranged partition identification to this 26 data subregions respectively, can be set to A, B, C, D ... ..., X, Y, Z are right
It is Chef Kang in the project name of the data to be stored got, then corresponding to its phonetic is " KANGSHIFU ", its initial K is taken,
The partition identification for then determining the corresponding data subregion of data to be stored is K.
S103, data to be stored is stored to the determining corresponding data subregion of partition identification.
A kind of date storage method provided in this embodiment is applied in the first equipment, includes at least one in the first equipment
A database table and each database table include the data subregion of preset number, and each data subregion all has partition identification, should
Method includes: the Data Identification for obtaining data to be stored；The corresponding data subregion of data to be stored is determined according to Data Identification
Partition identification；Data to be stored is stored to the determining corresponding data subregion of partition identification.The present embodiment sets database table
The data subregion of fixed preset number is set, and carries out Labelling Regions for each data subregion, when carrying out the storage of data to be stored,
The Data Identification for obtaining data to be stored, then determines the partition identification of the data subregion of data to be stored according to Data Identification,
Finally data to be stored is stored to the determining corresponding data subregion of partition identification, the present embodiment is by carrying out database table
Fixed partition, the growth of effective control partition quantity, while also improving and looking into new capability.
Referring to Fig. 4, being applied in the first equipment, in the first equipment present embodiment discloses a kind of method for reading data
Including at least one database table, and each database table includes the data subregion of preset data, all has partition identification, should
Method includes:
S401, the Data Identification for obtaining data to be read.
It should be noted that above-mentioned the first equipment referred to carries out data management, each database using data warehouse technology
Data partition data in table can be identical or can also be different, such as: it, can be by the there are two database table in data warehouse
When one database table carries out subregion, it is arranged to 5 subregion numbers；When second database carries out subregion, it can be provided 5 subregions
The subregion number of number or other quantity.But the partition identification of the data subregion in same database table is different, every number
Partition identification according to subregion is unique.
Preferably, Data Identification is specifically as follows the project label of data to be stored or the project name of data to be stored.
Certainly, the Data Identification of data to be stored can be set with detailed programs, but for data subregion
Partition identification will with the Data Identification of data to be stored carry out same rule setting.
For example, when the Data Identification of data to be stored is project label (CampaignKey), and project label is number
Word, the corresponding partition identification for data subregion are also corresponding for number；When the Data Identification of data to be stored is project name
When, it is corresponding that label can be carried out for preset rule for the partition identification of data subregion, such as: it can be project name
Initial or other.
S402, the partition identification that the corresponding data subregion of data to be read is determined according to Data Identification.
Preferably, when Data Identification is the project label of data to be stored, the specific implementation procedure of partition identification is determined
It is as follows:
The project label of data to be stored is subjected to modular arithmetic to preset number, is taken the remainder.
Remainder is determined to the partition identification of the corresponding data subregion of data to be stored.
It should be noted that for example: having carried out 5 subregions for first database table, it may be assumed that first database table includes 5
A data subregion is arranged partition identifications to this 5 data subregions respectively, can be set to 0,1,2,3,4, for get to
The project label of storing data is 7024, then to 7024%5, remainder obtains 4, it is determined that the corresponding data subregion of data to be stored
Partition identification be 4.
Preferably, when Data Identification is the project name of data to be stored, the specific implementation procedure of partition identification is determined
It is as follows:
Extract the initial of the project name of data to be stored；
The initial of project name is determined as to the partition identification of the corresponding data subregion of data to be stored.
It should be noted that for example: having carried out 26 subregions for first database table, it may be assumed that first database table includes
26 data subregions are arranged partition identification to this 26 data subregions respectively, can be set to A, B, C, D ... ..., X, Y, Z are right
It is Chef Kang in the project name of the data to be stored got, then corresponding to its phonetic is " KANGSHIFU ", its initial K is taken,
The partition identification for then determining the corresponding data subregion of data to be stored is K.
S403, data to be read are searched in corresponding data subregion according to partition identification, and data to be read is read.
A kind of method for reading data provided in this embodiment is applied in the first equipment, includes at least one in the first equipment
A database table and each database table include the data subregion of preset number, and each data subregion all has partition identification, should
Method includes: the Data Identification for obtaining data to be read；The corresponding data subregion of data to be read is determined according to Data Identification
Partition identification；Data to be read are searched in corresponding data subregion according to partition identification, and data to be read are read.This implementation
Example obtains the Data Identification of data to be read, and the subregion mark of the corresponding data subregion of data to be read is determined according to Data Identification
Know, data to be read is searched in corresponding data subregion according to partition identification, and data to be read are read, the present embodiment passes through
The growth of effective control partition quantity, improves and looks into new capability.
Referring to Fig. 5, a kind of disclosed date storage method, the present embodiment correspondence disclose one kind based on the above embodiment
Data storage device is applied in the first equipment, including described at least one database table and each in first equipment
Database table includes the data subregion of preset number, and each data subregion all has partition identification, and the specific device includes: first to obtain
Take unit 501, the first determination unit 502, storage unit 503, in which:
First acquisition unit 501, for obtaining the Data Identification of data to be stored；
First determination unit 502, for determining the subregion mark of the corresponding data subregion of data to be stored according to Data Identification
Know；
Storage unit 503, for storing data to be stored to the determining corresponding data subregion of partition identification.
The data storage device includes processor and memory, above-mentioned first acquisition unit, the first determination unit, storage
Unit etc. as program unit storage in memory, by processor execute above procedure unit stored in memory Lai
Realize corresponding function.
Include kernel in processor, is gone in memory to transfer corresponding program unit by kernel.Kernel can be set one
Or more, the growth of control partition quantity is carried out by adjusting kernel parameter, new capability is looked into raising.
Referring to Fig. 6, a kind of disclosed method for reading data, the present embodiment correspondence disclose one kind based on the above embodiment
Reading data device is applied in the first equipment, including described at least one database table and each in first equipment
Database table includes the data subregion of preset number, and each data subregion all has partition identification, and the specific device includes: second to obtain
Take unit 601, the second determination unit 602, reading unit 603, in which:
Second acquisition unit 601, for obtaining the Data Identification of data to be read；
Second determination unit 602, for determining the subregion mark of the corresponding data subregion of data to be read according to Data Identification
Know；
Reading unit 603, for searching data to be read in corresponding data subregion according to partition identification, and will be to be read
Data are read.
The reading data device includes processor and memory, and above-mentioned second acquisition unit, is read the second determination unit
Unit etc. as program unit storage in memory, by processor execute above procedure unit stored in memory Lai
Realize corresponding function.
Include kernel in processor, is gone in memory to transfer corresponding program unit by kernel.Kernel can be set one
Or more, the growth of control partition quantity is carried out by adjusting kernel parameter, new capability is looked into raising.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/
Or the forms such as Nonvolatile memory, if read-only memory (ROM) or flash memory (flash RAM), memory include that at least one is deposited
Store up chip.
The embodiment of the invention provides a kind of storage mediums, are stored thereon with program, real when which is executed by processor
The existing date storage method and/or method for reading data.
The embodiment of the invention provides a kind of processor, the processor is for running program, wherein described program operation
Date storage method and/or method for reading data described in Shi Zhihang.
The embodiment of the invention provides a kind of equipment, equipment include processor, memory and storage on a memory and can
The program run on a processor, processor perform the steps of when executing program
The Data Identification of data to be stored is obtained, specifically, Data Identification is for the project label of data to be stored or wait deposit
Store up the project name of data；
The partition identification that the corresponding data subregion of data to be stored is determined according to Data Identification, can specifically include: will be to
The project label of storing data carries out modular arithmetic to preset number, takes the remainder；Remainder is determined into the corresponding data of data to be stored
The partition identification of subregion, or, extracting the initial of the project name of data to be stored；By the initial of project name be determined as to
The partition identification of the corresponding data subregion of storing data；
The data to be stored is stored to the determining corresponding data subregion of the partition identification.
And/or
Obtain the Data Identification of data to be read；
The partition identification of the corresponding data subregion of data to be read is determined according to Data Identification；
Data to be read are searched in corresponding data subregion according to partition identification, and data to be read are read.
Equipment herein can be server, PC, PAD, mobile phone etc..
Present invention also provides a kind of computer program products, when executing on data processing equipment, are adapted for carrying out just
The program of beginningization there are as below methods step:
The Data Identification of data to be stored is obtained, specifically, Data Identification is for the project label of data to be stored or wait deposit
Store up the project name of data；
The partition identification that the corresponding data subregion of data to be stored is determined according to Data Identification, can specifically include: will be to
The project label of storing data carries out modular arithmetic to preset number, takes the remainder；Remainder is determined into the corresponding data of data to be stored
The partition identification of subregion, or, extracting the initial of the project name of data to be stored；By the initial of project name be determined as to
The partition identification of the corresponding data subregion of storing data；
The data to be stored is stored to the determining corresponding data subregion of the partition identification.
And/or
Obtain the Data Identification of data to be read；
The partition identification of the corresponding data subregion of data to be read is determined according to Data Identification；
Data to be read are searched in corresponding data subregion according to partition identification, and data to be read are read.
It should be understood by those skilled in the art that, embodiments herein can provide as method, system or computer program
Product.Therefore, complete hardware embodiment, complete software embodiment or reality combining software and hardware aspects can be used in the application
Apply the form of example.Moreover, it wherein includes the computer of computer usable program code that the application, which can be used in one or more,
The computer program implemented in usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) produces
The form of product.
The application is referring to method, the process of equipment (system) and computer program product according to the embodiment of the present application
Figure and/or block diagram describe.It should be understood that every one stream in flowchart and/or the block diagram can be realized by computer program instructions
The combination of process and/or box in journey and/or box and flowchart and/or the block diagram.It can provide these computer programs
Instruct the processor of general purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices to produce
A raw machine, so that being generated by the instruction that computer or the processor of other programmable data processing devices execute for real
The device for the function of being specified in present one or more flows of the flowchart and/or one or more blocks of the block diagram.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works, so that it includes referring to that instruction stored in the computer readable memory, which generates,
Enable the manufacture of device, the command device realize in one box of one or more flows of the flowchart and/or block diagram or
The function of being specified in multiple boxes.
These computer program instructions also can be loaded onto a computer or other programmable data processing device, so that counting
Series of operation steps are executed on calculation machine or other programmable devices to generate computer implemented processing, thus in computer or
The instruction executed on other programmable devices is provided for realizing in one or more flows of the flowchart and/or block diagram one
The step of function of being specified in a box or multiple boxes.
In a typical configuration, calculating equipment includes one or more processors (CPU), input/output interface, net
Network interface and memory.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/
Or the forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flash RAM).Memory is computer-readable Jie
The example of matter.
Computer-readable medium includes permanent and non-permanent, removable and non-removable media can be by any method
Or technology come realize information store.Information can be computer readable instructions, data structure, the module of program or other data.
The example of the storage medium of computer includes, but are not limited to phase change memory (PRAM), static random access memory (SRAM), moves
State random access memory (DRAM), other kinds of random access memory (RAM), read-only memory (ROM), electric erasable
Programmable read only memory (EEPROM), flash memory or other memory techniques, read-only disc read only memory (CD-ROM) (CD-ROM),
Digital versatile disc (DVD) or other optical storage, magnetic cassettes, tape magnetic disk storage or other magnetic storage devices
Or any other non-transmission medium, can be used for storage can be accessed by a computing device information.As defined in this article, it calculates
Machine readable medium does not include temporary computer readable media (transitory media), such as the data-signal and carrier wave of modulation.
It should also be noted that, the terms "include", "comprise" or its any other variant are intended to nonexcludability
It include so that the process, method, commodity or the equipment that include a series of elements not only include those elements, but also to wrap
Include other elements that are not explicitly listed, or further include for this process, method, commodity or equipment intrinsic want
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including element
There is also other identical elements in process, method, commodity or equipment.
It will be understood by those skilled in the art that embodiments herein can provide as method, system or computer program product.
Therefore, complete hardware embodiment, complete software embodiment or embodiment combining software and hardware aspects can be used in the application
Form.It is deposited moreover, the application can be used to can be used in the computer that one or more wherein includes computer usable program code
The shape for the computer program product implemented on storage media (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.)
Formula.
The above is only embodiments herein, are not intended to limit this application.To those skilled in the art,
Various changes and changes are possible in this application.It is all within the spirit and principles of the present application made by any modification, equivalent replacement,
Improve etc., it should be included within the scope of the claims of this application.
Claims (10)
1. a kind of date storage method, which is characterized in that be applied in the first equipment, include at least one in first equipment
Database table and each described database table include the data subregion of preset number, and each data subregion all has partition identification,
The described method includes:
Obtain the Data Identification of data to be stored；
The partition identification of the corresponding data subregion of the data to be stored is determined according to the Data Identification；
The data to be stored is stored to the determining corresponding data subregion of the partition identification.
2. date storage method according to claim 1, which is characterized in that the Data Identification is the data to be stored
Project label.
3. date storage method according to claim 2, which is characterized in that described according to Data Identification determination
The partition identification of the corresponding data subregion of data to be stored, comprising:
The project label of the data to be stored is subjected to modular arithmetic to the preset number, is taken the remainder；
The remainder is determined to the partition identification of the corresponding data subregion of the data to be stored.
4. date storage method according to claim 1, which is characterized in that the Data Identification is the data to be stored
Project name.
5. date storage method according to claim 4, which is characterized in that described according to Data Identification determination
The partition identification of the corresponding data subregion of data to be stored, comprising:
Extract the initial of the project name of the data to be stored；
The initial of the project name is determined as to the partition identification of the corresponding data subregion of the data to be stored.
6. a kind of method for reading data, which is characterized in that be applied in the first equipment, include at least one in first equipment
Database table, and each described database table includes the data subregion of preset data, all has partition identification, the method packet
It includes:
Obtain the Data Identification of data to be read；
The partition identification of the corresponding data subregion of the data to be read is determined according to the Data Identification；
The data to be read are searched in the corresponding data subregion according to the partition identification, and by the data to be read
It reads.
7. a kind of data storage device, which is characterized in that be applied in the first equipment, include at least one in first equipment
Database table and each described database table include the data subregion of preset number, and each data subregion all has partition identification,
Described device includes:
First acquisition unit, for obtaining the Data Identification of data to be stored；
First determination unit, for determining the subregion mark of the corresponding data subregion of the data to be stored according to the Data Identification
Know；
Storage unit, for storing the data to be stored to the determining corresponding data subregion of the partition identification.
8. a kind of reading data device, which is characterized in that be applied in the first equipment, include at least one in first equipment
Database table, and each described database table includes the data subregion of preset data, all has partition identification, described device packet
It includes:
Second acquisition unit, for obtaining the Data Identification of data to be read；
Second determination unit, for determining the subregion mark of the corresponding data subregion of the data to be read according to the Data Identification
Know；
Reading unit, for searching the data to be read in the corresponding data subregion according to the partition identification, and will
The data to be read are read.
9. a kind of storage medium, which is characterized in that the storage medium includes the program of storage,
Wherein, the equipment where the storage medium is controlled when described program is run is executed such as any one of claim 1-5
The date storage method and/or method for reading data as claimed in claim 6.
10. a kind of processor, which is characterized in that the processor is used to run program,
Wherein, date storage method according to any one of claims 1 to 5 is executed when described program is run and/or such as right
It is required that method for reading data described in 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710919122.4A CN110069488A (en) | 2017-09-30 | 2017-09-30 | A kind of date storage method, method for reading data and its device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710919122.4A CN110069488A (en) | 2017-09-30 | 2017-09-30 | A kind of date storage method, method for reading data and its device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110069488A true CN110069488A (en) | 2019-07-30 |
Family
ID=67364372
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710919122.4A Pending CN110069488A (en) | 2017-09-30 | 2017-09-30 | A kind of date storage method, method for reading data and its device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110069488A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111506573A (en) * | 2020-03-16 | 2020-08-07 | 中国平安人寿保险股份有限公司 | Database table partitioning method and device, computer equipment and storage medium |
| CN112579623A (en) * | 2019-09-29 | 2021-03-30 | 北京国双科技有限公司 | Method, device, storage medium and equipment for storing data |
| CN113312414A (en) * | 2020-07-30 | 2021-08-27 | 阿里巴巴集团控股有限公司 | Data processing method, device, equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102799628A (en) * | 2012-06-21 | 2012-11-28 | 新浪网技术(中国)有限公司 | Method and device for data partitioning in key-value database |
| CN102968498A (en) * | 2012-12-05 | 2013-03-13 | 华为技术有限公司 | Method and device for processing data |
| WO2016111714A1 (en) * | 2015-01-07 | 2016-07-14 | Weingarden Neal | Consumer rewards for posting tagged messages containing geographic information |
-
2017
- 2017-09-30 CN CN201710919122.4A patent/CN110069488A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102799628A (en) * | 2012-06-21 | 2012-11-28 | 新浪网技术(中国)有限公司 | Method and device for data partitioning in key-value database |
| CN102968498A (en) * | 2012-12-05 | 2013-03-13 | 华为技术有限公司 | Method and device for processing data |
| WO2016111714A1 (en) * | 2015-01-07 | 2016-07-14 | Weingarden Neal | Consumer rewards for posting tagged messages containing geographic information |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112579623A (en) * | 2019-09-29 | 2021-03-30 | 北京国双科技有限公司 | Method, device, storage medium and equipment for storing data |
| CN111506573A (en) * | 2020-03-16 | 2020-08-07 | 中国平安人寿保险股份有限公司 | Database table partitioning method and device, computer equipment and storage medium |
| CN111506573B (en) * | 2020-03-16 | 2024-03-12 | 中国平安人寿保险股份有限公司 | Database table partitioning method, device, computer equipment and storage medium |
| CN113312414A (en) * | 2020-07-30 | 2021-08-27 | 阿里巴巴集团控股有限公司 | Data processing method, device, equipment and storage medium |
| CN113312414B (en) * | 2020-07-30 | 2023-12-26 | 阿里巴巴集团控股有限公司 | Data processing method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106557486A (en) | A kind of storage method and device of data | |
| CN109582403A (en) | Interlocked display method and device between chart inner assembly | |
| CN110188100A (en) | Data processing method, device and computer storage medium | |
| CN105868421A (en) | Data management method and data management device | |
| CN106897342B (en) | Data verification method and equipment | |
| CN105608087B (en) | resource scheduling method and device | |
| US11327990B2 (en) | Method and device for processing user portrait and server | |
| CN110069488A (en) | A kind of date storage method, method for reading data and its device | |
| CN103631937A (en) | Method, device and system for establishing column storage indexes | |
| CN109583921A (en) | Advertising budget acquisition methods, device, storage medium and processor | |
| CN109977135A (en) | A kind of data query method, apparatus and server | |
| CN110427364A (en) | A kind of data processing method, device, electronic equipment and storage medium | |
| CN109582543A (en) | Data retrogressive method and device | |
| CN106648839B (en) | Data processing method and device | |
| CN109033365A (en) | A kind of data processing method and relevant device | |
| CN110457182A (en) | A kind of load balancing cluster example operating index monitoring system | |
| CN110069453A (en) | Operation/maintenance data treating method and apparatus | |
| CN106649374B (en) | Navigation tag sequencing method and device | |
| CN109471901A (en) | A kind of method of data synchronization and device | |
| CN109977317A (en) | Data query method and device | |
| CN106294700A (en) | The storage of a kind of daily record and read method and device | |
| CN109101514A (en) | Data lead-in method and device | |
| CN110019508A (en) | A kind of method of data synchronization, apparatus and system | |
| CN109582476A (en) | Data processing method, apparatus and system | |
| CN109561126A (en) | A kind of method of data synchronization and device, storage medium, processor |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 100080 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Applicant after: Beijing Guoshuang Technology Co.,Ltd. Address before: 100086 Beijing city Haidian District Shuangyushu Area No. 76 Zhichun Road cuigongfandian 8 layer A Applicant before: Beijing Guoshuang Technology Co.,Ltd. |
|
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190730 |