CN109542898A - Date storage method, device, electronic equipment and the storage medium of data bank table - Google Patents
Date storage method, device, electronic equipment and the storage medium of data bank table Download PDFInfo
- Publication number
- CN109542898A CN109542898A CN201811274700.4A CN201811274700A CN109542898A CN 109542898 A CN109542898 A CN 109542898A CN 201811274700 A CN201811274700 A CN 201811274700A CN 109542898 A CN109542898 A CN 109542898A
- Authority
- CN
- China
- Prior art keywords
- data
- stored
- row
- column
- block data
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This disclosure relates to the date storage method of data bank table, device, electronic equipment and storage medium, comprising the following steps: receive data on file library form instruction;According to data on file library form instruction, table to be stored is determined;Using the column of table to be stored as standard, table to be stored is divided into multiple block datas;Specified each of table to be stored is classified as a block data;Store multiple block datas.Memory dosage can be reduced by implementing the disclosure, improve the efficiency of hypostazation storage;Many operations of all tables are only needed to orient and read the column needed, the row of needs;It is accessed using piecemeal, first screen millisecond can be achieved in asynchronous read, and the light piecemeal that can reach row, column is read, and substantially increases the efficiency to table operation.
Description
Technical field
This disclosure relates to table field of storage, more specifically to the date storage method of data bank table, device,
Electronic equipment and storage medium.
Background technique
Original sheet (table) is similar to traditional excel, google sheet etc., need to access one it is static
Table entity data, the storage mode of design are to store entire data with a two dimension hashmap (Hash figure), are then serialized
After field, it is stored in the blob field of mysql (relevant database).
However, this mode is needed when carrying out reading data using big memory, speed is slow, and memory consumption is big, storage effect
Rate is low, and client is low to the operating efficiency of table.
Summary of the invention
Disclosure technical problems to be solved are, in view of the above drawbacks of the prior art, provide the number of data bank table
According to storage method, device, electronic equipment and storage medium.
The disclosure solves technical solution used by its technical problem: providing a kind of data storage side of data bank table
Method, comprising the following steps:
Receive data on file library form instruction;
According to data on file library form instruction, table to be stored is determined;
Using the column of the table to be stored as standard, the table to be stored is divided into multiple block datas;It is specified described
The each of table to be stored is classified as a block data;
Store the multiple block data.
Preferably, the data type stored in each described block data is identical with data length.
Preferably, the multiple block data of storage includes:
Each described block data is lockked by atomicity mode;
The block data being lockable is stored in file server in the form of document.
Preferably, described be stored in the multiple block datas being lockable in file server before includes:
Whether the length for judging the block data is regular length;
If so, the block data being lockable is stored in file server in the form of document;
It is stored if it is not, being referred to the block data being lockable in external memory by pointer.
Preferably, the method also includes:
Obtain the row ID of the table to be stored;
According to the row ID, the position corresponding relationship intersection of row and column is generated, and by the position pair of row and column generated
It should be related to that intersection is stored in mapping storage device.
Preferably, the method also includes:
Memory module is deleted in creation in the mapping storage device;The deletion memory module is deleted for storing
Row.
Preferably, the step of the method also includes following new line increments:
New line increment instruction is received, determines the value of new line increment;
The first row is chosen from the deletion memory module, and the value of selected the first row is revised as the new line increment
Value, complete the operation of new line increment.
The disclosure also provides a kind of data storage device of data bank table, comprising:
Receiving unit, for receiving data on file library form instruction;
Determination unit, for determining table to be stored according to data on file library form instruction;
Division unit, for using the column of the table to be stored as standard, the table to be stored to be divided into multiple moneys
Expect block;Specified each of table to be stored is classified as a block data;
Storage unit, for storing the multiple block data.
The disclosure also provides a kind of electronic equipment, including processor, and the processor is used to executing to be stored in memory
The step of method as described above is realized when computer program.
The disclosure also provides a kind of readable storage medium storing program for executing, is stored thereon with computer program, and the computer program is located
The step of reason device realizes method as described above when executing.
Implement date storage method, device, electronic equipment and the storage medium of the data bank table of the disclosure, has following
The utility model has the advantages that the date storage method of this data bank table is the following steps are included: receive data on file library form instruction;According to
Data on file library form instruction determines table to be stored;Using the column of table to be stored as standard, will table be stored be divided into it is more
A block data, and specified each of table to be stored is classified as a block data;Store multiple block datas.Implementing the disclosure can drop
Low memory dosage improves the efficiency of hypostazation storage;For many operations of all tables only need to orient read need column,
The row needed;It is accessed using piecemeal, first screen millisecond can be achieved in asynchronous read, and the light piecemeal that can reach row, column reads, mentions significantly
The high efficiency to table operation.
Detailed description of the invention
The disclosure is described further below in conjunction with accompanying drawings and embodiments, in attached drawing:
Fig. 1 is a kind of flow diagram of the date storage method for data bank table that one embodiment of the disclosure provides;
Fig. 2 is a kind of flow diagram of the date storage method for data bank table that another embodiment of the disclosure provides;
Fig. 3 is the schematic diagram for the whole table inquiry that another embodiment of the disclosure provides;
Fig. 4 is the schematic diagram for the new line increment that another embodiment of the disclosure provides;
Fig. 5 is a kind of functional block diagram of the data storage device for data bank table that the embodiment of the present disclosure provides;
Fig. 6 is the structural schematic diagram for a kind of electronic equipment that the embodiment of the present disclosure provides.
Specific embodiment
In order to which the technical features, objects and effects to the disclosure are more clearly understood, now compare attached drawing and be described in detail
The specific embodiment of the disclosure.
In design, different fields or column can store the data of different shape to data bank table, for example, can be with
Store integer, floating number, character string, the categorical datas such as time, the data of these types be all there are the data of regular length, or
Person also can store the data of the types such as formula, reference, multiselect, and this kind of data do not have regular length, cannot be directly stored in
In data bank table, but data bank simply statistical query can be passed through.
The characteristics of based on different types of data, the disclosure improves the mode of data storage, i.e., based on depositing based on column
Storage mode stores the data of data bank table, and the position that every a line is corresponded to column is stored, thus realization pair
The data of data bank table store, to reach subsequent quick reading, update, increase, deletion, inquiry to data bank list data
Deng.
Specifically, Fig. 1 is that a kind of Stored Procedure of date storage method of data bank table of the disclosure is illustrated referring to Fig. 1
Figure.
As shown in Figure 1, a kind of date storage method of data bank table the following steps are included:
Step S1, data on file library form instruction is received.
Data on file library form instruction can be triggered by the relevant operation of the user of client.For example, can be by client
End subscriber stores the instruction of the data of specified data bank table by single left button mouse click or right button triggering;Or by double-clicking mouse
It marks left button or right button triggering stores the instruction for specifying the data of data bank table;Or specified data bank table is inputted by keyboard
Lattice, to trigger the instruction for the data for storing specified data bank table.
The trigger request that client is inputted according to user determines the data bank table for needing to store, and deposits to server transmission
Store up data bank form instruction.Server receives the data on file library form instruction that client is sent.
Step S2, according to data on file library form instruction, table to be stored is determined.
Specifically, after server receives the data on file library form instruction that client is sent, it can be by server
Corresponding module parses institute's received data on file library form instruction, and then determines table to be stored.
What needs to be explained here is that having there is client user to edit the related data completed in table wait store.This public affairs
It opened and treats the storage of storage table and can be achieved to treat the data stored in table and stored.
Step S3, using the column of table to be stored as standard, table to be stored is divided into multiple block datas.
It is to be appreciated that each data bank table includes multiple column, therefore, the embodiment of the present disclosure is to storage table
The standard that is classified as of lattice is divided, and then table to be stored can be divided into multiple block datas, storage in each block data
Have with former wait store the identical data of data in table in corresponding position.Optionally, can with the one of table to be stored column or
It is multiple to be divided into a block data, it is specific to need to be determined according to actual design Storage.
In the embodiments of the present disclosure, in order to reduce memory consumption, the concurrent capability of server process table is improved, is improved real
The efficiency of bodyization storage reduces the inappropriate use to data and improves to the inquiry of list data, classification, filtering, polymerization
Efficiency etc., the disclosure is preferably divided using a column as a block data, i.e., specified to storage table in inventive embodiments
The each of lattice is classified as a block data.
Further, the data type stored in each block data is identical with data length, and in each block data
The bias (offset) of corresponding every row is identical.Since a column of table to be stored are a block data, after division,
The data type that is stored in each column, data length are all the same.So in specifically storage operating process, each money
Material block can be indicated by a regular length multiplied by the formation of line number amount.
For example, if a certain arrange stored data type for integer type, at this point, the block data can indicate are as follows: int
The block data of the block data of (4byte) × row_count length, i.e. integer (4 bit) × row length.It is assumed that a certain column institute
The data type of storage is integer, and the row length of the column is 11 rows, then the block data can indicate are as follows: integer (4 bit) × 11
Block data.Alternatively, a certain arrange stored data type as character string type, then it can be expressed as the character of regular length
String, for example, single line text is 255 bytes, then when being stored, which can be indicated are as follows: [255] byte.
Step S4, multiple block datas are stored.
By after storing table to arrange and divided for benchmark, stored to resulting multiple block datas are divided,
In, the corresponding column of each block data.
Preferably, before carrying out column storage, each block data can be lockked by atomicity mode, then again will
The block data being lockable is in the form of document in storage file server.By the way that each block data is locked in a manner of atomicity
Firmly, it can avoid in the subsequent data progress relevant operation to the data bank table stored, as inquired, filtering, polymerization, classify,
When access, the same block data is performed simultaneously operation by different users.
Further, the date storage method of the data bank table of the disclosure is further comprising the steps of:
Step A, the row ID of table to be stored is obtained.
It is to be appreciated that each traveling line identifier of storage table can be first treated before treating storage table and being divided,
The mark is the row ID of every a line of table to be stored.Row ID is used for every a line of unique identification table to be stored.Pass through
The row ID an of unique identification is respectively provided with to every a line of table to be stored, it can be achieved that treating the unique of every a line of storage table
Mark, and when realizing the relevant operation subsequent to the data in table by row ID, the identification to every a line.
Step B, according to row ID, the position corresponding relationship intersection of row and column is generated, and by the position of row and column generated
Corresponding relationship intersection is stored in mapping storage device.
Due to the unique identification that row ID is every a line, so, the position corresponding relationship of row and column is established, it can be according to row ID
Uniquely and the specific location of row in each column is quickly determined, that is, determines specific location of the row in each block data.
In other words, by the position corresponding relationship intersection of the row and column in be stored in mapping storage device, when subsequent needs
When carrying out relevant operation to the list data stored, the row of row ID institute unique identification can be determined by row ID, and pass through
It is that row ID can also determine that row ID is corresponded in table representative for which row, meanwhile, by the row ID of which row multiplied by the row
The width of the column at place, available corresponding bias (offset), and then can quickly remove and work as corresponding to row ID
Move ahead, may be implemented quickly part readings, partial write, part update, part addition, without the data to entire table into
Row integrated operation substantially increases the efficiency of operating efficiency and hypostazation storage.
Further, the date storage method of the data bank table is further comprising the steps of:
Step C, in mapping storage device, memory module is deleted in creation;Memory module is deleted for storing deleted row.
By creating the deletion memory module for storing deleted row in mapping storage device, may be implemented to table
Recycling, while the dirty data excessively deleted can also be avoided to be stored in block data, and accelerate the efficiency of new line increment.
Further, the date storage method of the data bank table is further comprising the steps of:
Step D, new line increment instruction is received, determines the value of new line increment.
Step E, the first row is chosen from deletion memory module, and the value of selected the first row is revised as new line increment
Value completes new line increment operation.
Specifically, determining the value of new line increment when receiving the instruction of new line increment according to the new line increment instruction and obtaining this newly
The relevant information and data of line increment, then, from the row (i.e. the first row) for choosing foremost in memory module is deleted, directly by first
The data modification stored in row is the data of new line increment, and new line increment operation can be completed.This mode both can be to avoid too many
The dirty data of deletion persists in block data, and the fast operating of new line increment also may be implemented, improve efficiency.
It is to be appreciated that when carrying out deleting row operation for server, only the row deleted being stored in and is deleted
Except in memory module, the memory space of the row also retains in the server.Therefore, in order to guarantee that server can operate normally effect
Rate, the date storage method of the data bank table of the disclosure also sets up re-establishment mechanism can that is, in the period for reaching setting
Automatically it will be stored in the data dump deleted in memory module or acording to the requirement of user, to guarantee the sky of the storage in server
Between.
The disclosure ensure that capable integrality, and the biasing of the row ID respective column by accessed row by above-mentioned storage method
The position corresponding relationship of value and row and column, has achieved the effect that quick access and update, improve the inquiries of data, classification,
The efficiency such as filtering, addition.
In addition, the disclosure stores data bank table in a manner of arranging, memory dosage is reduced, for all
Table, many operations only need to orient the row for reading the column, needs that need, can be real by the way of piecemeal access, asynchronous reading
Existing first screen millisecond, the light piecemeal that can achieve row, column are read.When inserting line, quickly addition can be realized based on row ID
Operation;When insertion column, can directly add in a new block data to table can be completed slotting queuing operation, not need to scan
Whole table.When more newline, the content of intersection need to be only read from mapping storage device, to obtain the bias (offset) of the row, so
The content in the offset in corresponding column is updated afterwards.When updating column, it is only necessary to which the block data for reading in the column is updated
, and will not influence the state of other column.Per-column classification, filtering, polymerization etc. only need the block data of this column of ground to read in
It is operated, generates new offset, do not need to carry out whole table handling, and then reach the mesh that memory dosage is effectively reduced
, achieve the effect that be similar to external sort.
It referring to fig. 2, is a kind of flow diagram of another embodiment of date storage method of data bank table of the disclosure.
As shown in Fig. 2, further comprising the steps of on the basis of the embodiment previous embodiment:
Specifically, including: before the multiple block datas being lockable are stored in file server
Step S4-1, whether the length for judging block data is regular length.
Step S4-2, if so, the block data being lockable is stored in file server in the form of document.
Step S4-3, it is stored if it is not, being referred to the block data being lockable in external memory by pointer.
Here the length of block data refers to the data length stored in each block data, wherein integer, floating-point
The data length of the types such as number, character string, time is regular length, and is to be not fixed length if long text, picture, attachment etc.
Data, these data for being not fixed length can be referred in external memory by pointer to be stored, and the disclosure is then
The data that these can be not fixed with length are simply counted.
It is the schematic diagram of the whole table inquiry of the disclosure referring to Fig. 3.
As shown in figure 3, including the client of front end, the position of mapping storage device, row and column for being stored as in table
Corresponding relationship intersection, block data.Wherein, each block data is stored in file server in the form of document.
The detailed process of whole table inquiry are as follows:
After being stored by the above scheme of the disclosure to data bank table, when needs are to certain stored in the server
When one data bank table carries out the inquiry of whole table, the row ID of every a line is first obtained, further according to row ID obtained in mapping storage
It is searched in the position corresponding relationship intersection of row and column in device, finds out specific location of every a line in corresponding column,
Which column is every a line correspond to, value corresponding to row ID then, then by every a line multiplied by column corresponding to row ID width
Degree, determines the data that every a line is stored in respective column, identified data is finally back to front end, for the user of front end
It checks.
It referring to fig. 4, is the schematic diagram of the new line increment of the disclosure.
As shown in figure 4, first, left side figure is the client of front end, for sending new line increment instruction to server.Mapping
Memory, the position corresponding relationship intersection and block data of the row and column for being stored as in table.Wherein, each data
Block is stored in file server in the form of document.
After server receives the new line increment instruction of client transmission, the instruction of new line increment is solved by corresponding module
Analysis, obtains the row ID of the new line increment, which is added to the last line in each block data, then corresponding
Offset is sent in mapping storage device, row ID based on the new line increment, the offset being stored in block data establish the row with
The position corresponding relationship of column, and in the position corresponding relationship intersection for the row and column being stored in mapping storage device, complete new line increment
Operation.
With reference to Fig. 5, the embodiment of the present disclosure additionally provides a kind of functional block diagram of the data storage device of data bank table.
As shown in figure 5, the data storage device for the data bank table that the embodiment of the present disclosure provides includes:
Receiving unit 501, for receiving data on file library form instruction.
Determination unit 502, for determining table to be stored according to data on file library form instruction.
Division unit 503, for the table to be stored being divided into multiple using the column of the table to be stored as standard
Block data;Specified each of table to be stored is classified as a block data.
Storage unit 504, for storing the multiple block data.
Wherein, which includes: to lock module and memory module.Wherein, module is lockked for passing through atomicity
Mode locks each block data;Memory module is used to the block data being lockable being stored in file server in the form of document
In.
Further, the data storage device for the data bank table that the embodiment of the present disclosure provides further include: judgement processing is single
Member, the judgement processing unit are used for before the multiple block datas being lockable are stored in file server, judge block data
Whether length is regular length, if so, the block data being lockable is stored in file server in the form of document;If it is not, then leading to
It crosses pointer and refers to the block data being lockable in external memory and store.
In the embodiment of the present disclosure, the data storage device of the data bank table further include: acquiring unit and corresponding relationship close
Collect generation unit.Wherein acquiring unit is used to obtain the row ID of table to be stored;Corresponding relationship intersection generation unit is used for basis
The row ID of table to be stored generates the position corresponding relationship intersection of row and column, and the position of row and column generated is corresponded to and is closed
It is that intersection is stored in mapping storage device.
Further, the data storage device of the data bank table of the embodiment of the present disclosure further include: creating unit and newly-increased
Row unit.Wherein, creating unit is used for the creation in mapping storage device and deletes memory module, and the deletion memory module is for storing
Deleted row.New line increment unit instructs the value for determining new line increment according to received new line increment for receiving new line increment instruction;
The first row is chosen from deleting in memory module, and the value of selected the first row is revised as to the value of new line increment, completes new line increment
Operation.
The disclosure also provides a kind of electronic equipment, which includes processor, and processor is for executing in memory
The step of above method is realized when the computer program of storage.
Below with reference to Fig. 6, it illustrates the structural representations for the electronic equipment 600 for being suitable for being used to realize the embodiment of the present disclosure
Figure.Terminal device in the embodiment of the present disclosure can include but is not limited to such as mobile phone, laptop, digital broadcasting and connect
Receive device, PDA (personal digital assistant), PAD (tablet computer), PMP (portable media player), car-mounted terminal (such as vehicle
Carry navigation terminal) etc. mobile terminal and such as number TV, desktop computer etc. fixed terminal.Electricity shown in Fig. 6
Sub- equipment is only an example, should not function to the embodiment of the present disclosure and use scope bring any restrictions.
As shown in fig. 6, electronic equipment 600 may include processing unit (such as central processing unit, graphics processor etc.)
601, random access can be loaded into according to the program being stored in read-only memory (ROM) 602 or from storage device 606
Program in memory (RAM) 603 and execute various movements appropriate and processing.In RAM 603, it is also stored with electronic equipment
Various programs and data needed for 600 operations.Processing unit 601, ROM 602 and RAM 603 pass through the phase each other of bus 604
Even.Input/output (I/O) interface 605 is also connected to bus 604.
In general, following device can connect to I/O interface 605: including such as touch screen, touch tablet, keyboard, mouse, taking the photograph
As the input unit 606 of head, microphone, accelerometer, gyroscope etc.;Including such as liquid crystal display (LCD), loudspeaker, vibration
The output device 607 of dynamic device etc.;Storage device 606 including such as tape, hard disk etc.;And communication device 609.Communication device
609, which can permit electronic equipment 600, is wirelessly or non-wirelessly communicated with other equipment to exchange data.Although Fig. 6 shows tool
There is the electronic equipment 600 of various devices, it should be understood that being not required for implementing or having all devices shown.It can be with
Alternatively implement or have more or fewer devices.
Particularly, in accordance with an embodiment of the present disclosure, it may be implemented as computer above with reference to the process of flow chart description
Software program.For example, embodiment of the disclosure includes a kind of computer program product comprising be carried on computer-readable medium
On computer program, which includes the program code for method shown in execution flow chart.In such reality
It applies in example, which can be downloaded and installed from network by communication device 609, or from storage device 606
It is mounted, or is mounted from ROM602.When the computer program is executed by processing unit 601, the embodiment of the present disclosure is executed
Method in the above-mentioned function that limits.
It should be noted that the above-mentioned computer-readable medium of the disclosure can be computer-readable signal media or meter
Calculation machine readable storage medium storing program for executing either the two any combination.Computer readable storage medium for example can be --- but not
Be limited to --- electricity, magnetic, optical, electromagnetic, infrared ray or semiconductor system, device or device, or any above combination.Meter
The more specific example of calculation machine readable storage medium storing program for executing can include but is not limited to: have the electrical connection, just of one or more conducting wires
Taking formula computer disk, hard disk, random access storage device (RAM), read-only memory (ROM), erasable type may be programmed read-only storage
Device (EPROM or flash memory), optical fiber, portable compact disc read-only memory (CD-ROM), light storage device, magnetic memory device,
Or above-mentioned any appropriate combination.In the disclosure, computer readable storage medium can be it is any include or storage journey
The tangible medium of sequence, the program can be commanded execution system, device or device use or in connection.And at this
In open, computer-readable signal media may include in a base band or as the data-signal that carrier wave a part is propagated,
In carry computer-readable program code.The data-signal of this propagation can take various forms, including but not limited to
Electromagnetic signal, optical signal or above-mentioned any appropriate combination.Computer-readable signal media can also be computer-readable and deposit
Any computer-readable medium other than storage media, the computer-readable signal media can send, propagate or transmit and be used for
By the use of instruction execution system, device or device or program in connection.Include on computer-readable medium
Program code can transmit with any suitable medium, including but not limited to: electric wire, optical cable, RF (radio frequency) etc. are above-mentioned
Any appropriate combination.
Above-mentioned computer-readable medium can be included in above-mentioned electronic equipment;It is also possible to individualism, and not
It is fitted into the electronic equipment.
Above-mentioned computer-readable medium carries one or more program, when said one or multiple programs are by the electricity
When sub- equipment executes, so that the electronic equipment: obtaining at least two internet protocol addresses;Send to Node evaluation equipment includes institute
State the Node evaluation request of at least two internet protocol addresses, wherein the Node evaluation equipment is internet from described at least two
In protocol address, chooses internet protocol address and return;Receive the internet protocol address that the Node evaluation equipment returns;Its
In, the fringe node in acquired internet protocol address instruction content distributing network.
Alternatively, above-mentioned computer-readable medium carries one or more program, when said one or multiple programs
When being executed by the electronic equipment, so that the electronic equipment: receiving the Node evaluation including at least two internet protocol addresses and request;
From at least two internet protocol address, internet protocol address is chosen;Return to the internet protocol address selected;Wherein,
The fringe node in internet protocol address instruction content distributing network received.
The calculating of the operation for executing the disclosure can be write with one or more programming languages or combinations thereof
Machine program code, above procedure design language include object oriented program language-such as Java, Smalltalk, C++,
It further include conventional procedural programming language-such as " C " language or similar programming language.Program code can be complete
It executes, partly executed on the user computer on the user computer entirely, being executed as an independent software package, part
Part executes on the remote computer or executes on a remote computer or server completely on the user computer.It is relating to
And in the situation of remote computer, remote computer can pass through the network of any kind --- including local area network (LAN) or extensively
Domain net (WAN)-be connected to subscriber computer, or, it may be connected to outer computer (such as utilize ISP
To be connected by internet).
Flow chart and block diagram in attached drawing are illustrated according to the system of the various embodiments of the disclosure, method and computer journey
The architecture, function and operation in the cards of sequence product.In this regard, each box in flowchart or block diagram can generation
A part of one module, program segment or code of table, a part of the module, program segment or code include one or more use
The executable instruction of the logic function as defined in realizing.It should also be noted that in some implementations as replacements, being marked in box
The function of note can also occur in a different order than that indicated in the drawings.For example, two boxes succeedingly indicated are actually
It can be basically executed in parallel, they can also be executed in the opposite order sometimes, and this depends on the function involved.Also it to infuse
Meaning, the combination of each box in block diagram and or flow chart and the box in block diagram and or flow chart can be with holding
The dedicated hardware based system of functions or operations as defined in row is realized, or can use specialized hardware and computer instruction
Combination realize.
Being described in unit involved in the embodiment of the present disclosure can be realized by way of software, can also be by hard
The mode of part is realized.Wherein, the title of unit does not constitute the restriction to the unit itself under certain conditions, for example, the
One acquiring unit is also described as " obtaining the unit of at least two internet protocol addresses ".
The embodiment of the present disclosure also provides a kind of readable storage medium storing program for executing, is stored thereon with computer program, computer program quilt
Processor realizes the date storage method of above-mentioned data bank table when executing.
The readable storage medium storing program for executing that the embodiment of the present disclosure provides includes but is not limited to disk, hard disk, random access storage device
(RAM), read-only memory (ROM), Erasable Programmable Read Only Memory EPROM (EPROM or flash memory), optical fiber, portable compact disc
Read-only memory (CD-ROM), any combination of light storage device, magnetic memory device or above-mentioned device.
It is to be appreciated that the readable storage medium storing program for executing of the disclosure can be readable included in above-mentioned electronic equipment 600 deposit
Storage media is also possible to be individually present and be not installed at the readable storage medium storing program for executing in electronic equipment 600.
Further, the computer program that the readable storage medium storing program for executing of the disclosure is stored can be one or more journey
Sequence.
The apparatus embodiments described above are merely exemplary, wherein described, unit can as illustrated by the separation member
It is physically separated with being or may not be, component shown as a unit may or may not be physics list
Member, it can it is in one place, or may be distributed over multiple network units.It can be selected according to the actual needs
In some or all of the modules achieve the purpose of the solution of this embodiment.
Through the above description of the embodiments, those skilled in the art can be understood that each embodiment can
It realizes by means of software and necessary general hardware platform, naturally it is also possible to pass through hardware.Based on this understanding, on
Stating technical solution, substantially the part that contributes to existing technology can be embodied in the form of software products in other words, should
Computer software product may be stored in a computer readable storage medium, such as magnetic disk, CD, read-only memory (ROM)
Or random access memory (RAM) etc., including some instructions use is so that a computer equipment (can be individual calculus
Machine, server or network equipment etc.) execute method described in certain parts of each embodiment or embodiment.
Above embodiments are only to illustrate the technical concepts and features of the disclosure, and its object is to allow person skilled in the art
Scholar can understand content of this disclosure and implement accordingly, the protection scope not limited the disclosure.It is all to be wanted with disclosure right
The equivalent changes and modifications that range is done are sought, should belong to the covering scope of disclosure claim.
It should be understood that for those of ordinary skills, it can be modified or changed according to the above description,
And all these modifications and variations all should belong to the protection scope of disclosure appended claims.
Claims (10)
1. a kind of date storage method of data bank table, which comprises the following steps:
Receive data on file library form instruction;
According to data on file library form instruction, table to be stored is determined;
Using the column of the table to be stored as standard, the table to be stored is divided into multiple block datas;It is specified described wait deposit
Storage each of table is classified as a block data;
Store the multiple block data.
2. the date storage method of data bank table according to claim 1, which is characterized in that each described block data
Middle stored data type is identical with data length.
3. the date storage method of data bank table according to claim 1, which is characterized in that the storage is the multiple
Block data includes:
Each described block data is lockked by atomicity mode;
The block data being lockable is stored in file server in the form of document.
4. the date storage method of data bank table according to claim 3, which is characterized in that described more by what is be lockable
Include: before in a block data deposit file server
Whether the length for judging the block data is regular length;
If so, the block data being lockable is stored in file server in the form of document;
It is stored if it is not, being referred to the block data being lockable in external memory by pointer.
5. the date storage method of data bank table according to claim 3, which is characterized in that the method also includes:
Obtain the row ID of the table to be stored;
According to the row ID, the position corresponding relationship intersection of row and column is generated, and the position of row and column generated is corresponded to and is closed
It is that intersection is stored in mapping storage device.
6. the date storage method of data bank table according to claim 5, which is characterized in that the method also includes:
Memory module is deleted in creation in the mapping storage device;The deletion memory module is for storing deleted row.
7. the date storage method of data bank table according to claim 6, which is characterized in that the method also includes with
The step of new line increment down:
New line increment instruction is received, determines the value of new line increment;
The first row is chosen from the deletion memory module, and the value of selected the first row is revised as the new line increment
Value completes new line increment operation.
8. a kind of data storage device of data bank table characterized by comprising
Receiving unit, for receiving data on file library form instruction;
Determination unit, for determining table to be stored according to data on file library form instruction;
Division unit, for using the column of the table to be stored as standard, the table to be stored to be divided into multiple block datas;
Specified each of table to be stored is classified as a block data;
Storage unit, for storing the multiple block data.
9. a kind of electronic equipment, which is characterized in that including processor, the processor is for executing the calculating stored in memory
It is realized when machine program such as the step of any one of claim 1-7 the method.
10. a kind of readable storage medium storing program for executing, is stored thereon with computer program, which is characterized in that the computer program is processed
It is realized when device executes such as the step of any one of claim 1-7 the method.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811274700.4A CN109542898A (en) | 2018-10-30 | 2018-10-30 | Date storage method, device, electronic equipment and the storage medium of data bank table |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811274700.4A CN109542898A (en) | 2018-10-30 | 2018-10-30 | Date storage method, device, electronic equipment and the storage medium of data bank table |
Publications (1)
Publication Number | Publication Date |
---|---|
CN109542898A true CN109542898A (en) | 2019-03-29 |
Family
ID=65846051
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811274700.4A Pending CN109542898A (en) | 2018-10-30 | 2018-10-30 | Date storage method, device, electronic equipment and the storage medium of data bank table |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109542898A (en) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110020328A (en) * | 2019-04-16 | 2019-07-16 | 北京字节跳动网络技术有限公司 | Data processing method, device, electronic equipment and the storage medium of online table |
CN112329452A (en) * | 2019-08-05 | 2021-02-05 | 珠海金山办公软件有限公司 | Method and device for generating chart, computer storage medium and terminal |
CN112905587A (en) * | 2019-12-04 | 2021-06-04 | 北京金山云网络技术有限公司 | Database data management method and device and electronic equipment |
CN113204555A (en) * | 2021-05-21 | 2021-08-03 | 北京字跳网络技术有限公司 | Data table processing method and device, electronic equipment and storage medium |
CN114356226A (en) * | 2021-12-17 | 2022-04-15 | 广州文远知行科技有限公司 | Sensor data storage method, device, equipment and storage medium |
CN116069260A (en) * | 2023-02-23 | 2023-05-05 | 摩尔线程智能科技(北京)有限责任公司 | Data processing apparatus, data processing method, computer device, and storage medium |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101040283A (en) * | 2004-11-12 | 2007-09-19 | 诺基亚公司 | Form related data reduction |
CN102682108A (en) * | 2012-05-08 | 2012-09-19 | 同方光盘股份有限公司 | Row and line mixed database storage method |
CN104516912A (en) * | 2013-09-29 | 2015-04-15 | 中国移动通信集团黑龙江有限公司 | Dynamic data storage method and device |
US9020991B2 (en) * | 2012-08-10 | 2015-04-28 | Ca, Inc. | System and method for analyzing available space in data blocks |
CN107480205A (en) * | 2017-07-24 | 2017-12-15 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus for carrying out data partition |
CN107818075A (en) * | 2017-10-16 | 2018-03-20 | 平安科技(深圳)有限公司 | Form data structuring extracting method, electronic equipment and computer-readable recording medium |
-
2018
- 2018-10-30 CN CN201811274700.4A patent/CN109542898A/en active Pending
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101040283A (en) * | 2004-11-12 | 2007-09-19 | 诺基亚公司 | Form related data reduction |
CN102682108A (en) * | 2012-05-08 | 2012-09-19 | 同方光盘股份有限公司 | Row and line mixed database storage method |
US9020991B2 (en) * | 2012-08-10 | 2015-04-28 | Ca, Inc. | System and method for analyzing available space in data blocks |
CN104516912A (en) * | 2013-09-29 | 2015-04-15 | 中国移动通信集团黑龙江有限公司 | Dynamic data storage method and device |
CN107480205A (en) * | 2017-07-24 | 2017-12-15 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus for carrying out data partition |
CN107818075A (en) * | 2017-10-16 | 2018-03-20 | 平安科技(深圳)有限公司 | Form data structuring extracting method, electronic equipment and computer-readable recording medium |
Cited By (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110020328A (en) * | 2019-04-16 | 2019-07-16 | 北京字节跳动网络技术有限公司 | Data processing method, device, electronic equipment and the storage medium of online table |
CN112329452A (en) * | 2019-08-05 | 2021-02-05 | 珠海金山办公软件有限公司 | Method and device for generating chart, computer storage medium and terminal |
CN112905587A (en) * | 2019-12-04 | 2021-06-04 | 北京金山云网络技术有限公司 | Database data management method and device and electronic equipment |
CN112905587B (en) * | 2019-12-04 | 2024-05-14 | 北京金山云网络技术有限公司 | Database data management method and device and electronic equipment |
CN113204555A (en) * | 2021-05-21 | 2021-08-03 | 北京字跳网络技术有限公司 | Data table processing method and device, electronic equipment and storage medium |
CN113204555B (en) * | 2021-05-21 | 2023-10-31 | 北京字跳网络技术有限公司 | Data table processing method, device, electronic equipment and storage medium |
CN114356226A (en) * | 2021-12-17 | 2022-04-15 | 广州文远知行科技有限公司 | Sensor data storage method, device, equipment and storage medium |
CN116069260A (en) * | 2023-02-23 | 2023-05-05 | 摩尔线程智能科技(北京)有限责任公司 | Data processing apparatus, data processing method, computer device, and storage medium |
CN116069260B (en) * | 2023-02-23 | 2024-03-22 | 摩尔线程智能科技(北京)有限责任公司 | Data processing apparatus, data processing method, computer device, and storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109542898A (en) | Date storage method, device, electronic equipment and the storage medium of data bank table | |
JP6875557B2 (en) | Methods and devices for writing service data to the blockchain system | |
CN106021267B (en) | To the method and system for concurrently reading and being inserted into of data structure | |
US9575639B2 (en) | Compound controls | |
CN104881466B (en) | The processing of data fragmentation and the delet method of garbage files and device | |
CN104050223B (en) | Pivot face for text mining and search | |
US20170351726A1 (en) | Method and computing device for minimizing accesses to data storage in conjunction with maintaining a b-tree | |
CN106970936A (en) | Data processing method and device, data query method and device | |
CN107924371A (en) | Infinite memory constructional hardware implementation with router | |
CN110019080A (en) | Data access method and device | |
CN112930529B (en) | Generating software artifacts from conceptual data models | |
CN108431774A (en) | Infinite memory structure stream and API | |
CN105608162B (en) | Document handling method and device | |
CN106970958B (en) | A kind of inquiry of stream file and storage method and device | |
CN105956166A (en) | Database reading-writing method and database reading-writing apparatus | |
CN108228646A (en) | For accessing the method for data and electronic equipment | |
CN108256070A (en) | For generating the method and apparatus of information | |
WO2017058705A1 (en) | Partitioning of geographic data | |
CN109471838A (en) | The operating method of Catalog Documents, device, electronic equipment, readable storage medium storing program for executing | |
CN109344348A (en) | A kind of resource regeneration method and device | |
WO2021173490A1 (en) | Vectorized queues for shortest-path graph searches | |
US20200320216A1 (en) | Systems and methods for determining database permissions | |
CN107301179A (en) | The method and apparatus of data base read-write separation | |
CN102054217A (en) | Entity morphing in metamodel-based tools | |
CN107480205A (en) | A kind of method and apparatus for carrying out data partition |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination |