CN109933380B - Online table block loading method and device - Google Patents
Online table block loading method and device Download PDFInfo
- Publication number
- CN109933380B CN109933380B CN201910164945.XA CN201910164945A CN109933380B CN 109933380 B CN109933380 B CN 109933380B CN 201910164945 A CN201910164945 A CN 201910164945A CN 109933380 B CN109933380 B CN 109933380B
- Authority
- CN
- China
- Prior art keywords
- version
- preset
- loading
- snapshot
- incremental 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.)
- Active
Links
Images
Abstract
The disclosure provides an online table block loading method and device, wherein the method comprises the following steps: acquiring a document data loading request of a preset version; judging whether a version snapshot corresponding to a preset version exists or not; and if the version snapshots corresponding to the preset versions exist, loading and displaying the version snapshots according to the preset block number. Therefore, the table data is loaded in a blocking mode, online table loading efficiency is improved, and user experience is improved.
Description
Technical Field
The present disclosure relates to the field of data processing technologies, and in particular, to an online table block loading method and apparatus.
Background
At present, the online spreadsheet can browse and edit forms directly on a webpage without downloading applications, and the real-time loading capability of the webpage brings convenience and simultaneously brings a problem of file loading speed. Therefore, under the condition of heavy use, the table content is continuously increased, and the number of large table rows can even reach as many as tens of thousands of rows, thereby bringing great challenges to the page opening speed.
Disclosure of Invention
The present disclosure is directed to solving, at least in part, one of the technical problems in the related art.
Therefore, a first object of the present disclosure is to provide an online form blocking loading method, which is used to solve the technical problems in the prior art that when online electronic form content is loaded, the loading speed is slow, so that the use is inconvenient, and the like.
A second objective of the present disclosure is to provide an online table block loading apparatus.
A third object of the present disclosure is to provide an electronic device.
A fourth object of the present disclosure is to provide a computer-readable storage medium.
To achieve the above object, an embodiment of a first aspect of the present disclosure provides an online table block loading method, including:
acquiring a document data loading request of a preset version;
judging whether a version snapshot corresponding to the preset version exists or not;
and if the version snapshots corresponding to the preset versions exist, loading and displaying the version snapshots according to the preset block number.
Further, after the determining whether the version snapshot corresponding to the preset version exists, the method further includes:
if the version snapshot corresponding to the preset version does not exist, acquiring a target version snapshot corresponding to a target version adjacent to the preset version, and acquiring a plurality of incremental data;
and loading and displaying the preset block number of the target version snapshot, and loading and displaying the plurality of incremental data.
Further, before the loading and displaying the version snapshot according to the preset number of blocks, the method further includes:
and acquiring the version snapshots corresponding to the preset versions stored in blocks from a database, and caching the version snapshots corresponding to the preset versions for preset time.
Further, before the obtaining of the preset version of the document data loading request, the method further includes:
acquiring N incremental data;
selecting M incremental data from the N incremental data to generate an Mth version snapshot;
the M version snapshot is stored in a database in a blocking mode according to a preset size; wherein N and M are positive integers, and N is greater than or equal to M.
Further, after the loading and displaying the version snapshot according to the preset number of blocks, the method further includes:
monitoring whether new incremental data are generated or not through a preset monitoring long chain;
and if new incremental data are generated, opening the edition after the new incremental data are loaded.
Further, the loading and displaying the version snapshot according to a preset number of blocks includes:
acquiring a visible area and a target block version snapshot of current equipment;
and after the target block version snapshot is loaded and displayed in the visible area, continuously loading the residual block version snapshots.
The online form block loading method of the embodiment of the disclosure obtains a document data loading request of a preset version; judging whether a version snapshot corresponding to a preset version exists or not; and if the version snapshots corresponding to the preset versions exist, loading and displaying the version snapshots according to the preset block number. Therefore, by loading the table data in blocks, the online table loading efficiency is improved, and the user experience is improved.
To achieve the above object, an embodiment of a second aspect of the present disclosure provides an online table block loading apparatus, including:
the first acquisition module is used for acquiring a document data loading request of a preset version;
the judging module is used for judging whether a version snapshot corresponding to the preset version exists or not;
and the display module is used for loading and displaying the version snapshots according to the preset block number if the version snapshots corresponding to the preset versions exist.
Further, the apparatus further comprises:
the second obtaining module is used for obtaining a target version snapshot corresponding to a target version adjacent to the preset version and obtaining a plurality of incremental data if the version snapshot corresponding to the preset version does not exist;
the display module is further configured to load and display the preset number of blocks of the target version snapshot, and load and display the plurality of incremental data.
Further, the apparatus further comprises:
and the caching module is used for acquiring the version snapshots corresponding to the preset versions stored in blocks from a database and caching the version snapshots corresponding to the preset versions for preset time.
Further, the device further comprises:
a third obtaining module, configured to obtain N incremental data;
the selecting module is used for selecting M incremental data from the N incremental data to generate an Mth version snapshot;
the storage module is used for storing the Mth version snapshot in a database in a blocking mode according to a preset size; wherein N and M are positive integers, and N is greater than or equal to M.
Further, the device further comprises:
the monitoring module is used for monitoring whether new incremental data is generated or not through a preset monitoring long chain;
and the display module is also used for opening and editing after loading of new incremental data is finished if the new incremental data is generated.
Further, the display module is specifically configured to: acquiring a visible area and a target block version snapshot of current equipment; and after the target block version snapshot is loaded and displayed in the visible area, continuously loading the residual block version snapshots.
The online form block loading device of the embodiment of the disclosure loads a request by acquiring document data of a preset version; judging whether a version snapshot corresponding to a preset version exists or not; and if the version snapshot corresponding to the preset version exists, loading and displaying the version snapshot according to the preset block number. Therefore, by loading the table data in blocks, the online table loading efficiency is improved, and the user experience is improved.
To achieve the above object, an embodiment of a third aspect of the present disclosure provides an electronic device, including: memory, processor and computer program stored on the memory and executable on the processor, characterized in that the processor implements the online table blocking loading method as described above when executing the program.
In order to achieve the above object, a fourth aspect of the present disclosure provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the online table blocking loading method as described above.
Additional aspects and advantages of the disclosure will be set forth in part in the description which follows and, in part, will be obvious from the description, or may be learned by practice of the disclosure.
Drawings
The foregoing and/or additional aspects and advantages of the present disclosure will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings of which:
fig. 1 is a schematic flow chart of an online table block loading method according to an embodiment of the present disclosure;
fig. 2 is a schematic flowchart of an online table block loading method according to an embodiment of the present disclosure;
fig. 3 is a schematic flowchart of an online table block loading method according to an embodiment of the present disclosure;
fig. 4 is a schematic structural diagram of an online table block loading device according to an embodiment of the present disclosure;
fig. 5 is a schematic structural diagram of an online table block loading device according to an embodiment of the present disclosure;
fig. 6 is a schematic structural diagram of an online table block loading device according to an embodiment of the present disclosure;
fig. 7 is a schematic structural diagram of an online table block loading apparatus according to an embodiment of the present disclosure;
fig. 8 is a schematic structural diagram of an online table block loading apparatus according to an embodiment of the present disclosure; and
fig. 9 is a schematic structural diagram of an electronic device according to an embodiment of the present disclosure.
Detailed Description
Reference will now be made in detail to the embodiments of the present disclosure, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar functions throughout. The embodiments described below with reference to the drawings are exemplary and intended to be illustrative of the present disclosure, and should not be construed as limiting the present disclosure.
The online table block loading method and apparatus according to the embodiments of the present disclosure are described below with reference to the drawings.
Fig. 1 is a schematic flow chart of an online table block loading method according to an embodiment of the present disclosure. As shown in fig. 1, the online table block loading method includes the following steps:
s101, acquiring a preset version of document data loading request.
In practical application, in order to facilitate user use and data sharing, browsing and editing of the table on the webpage can be selected directly, however, as the table content increases, a large amount of data needs to be loaded when editing needs to be performed again, so that the loading speed is slow, and user use is affected.
In order to solve the problems, the application provides online table block loading, which is characterized in that a version snapshot is generated by incremental data generated by a plurality of users within a short period of document editing, the version snapshot is stored in a database in a block mode, and the loading display is directly carried out according to the preset block quantity when the loading is needed.
Therefore, it can be understood that, before a document data loading request of a preset version is obtained, a plurality of incremental data need to be obtained, corresponding version snapshots are generated, and block storage is performed according to a preset size, as a possible implementation manner, N incremental data are obtained, M incremental data are selected from the N incremental data to generate an mth version snapshot, the mth version snapshot is block-stored in a database according to the preset size, where N and M are positive integers, and N is greater than or equal to M.
The incremental data are generated in a short period of time when a user edits the document each time, are stored on the server and can be sent to the client of another collaborator; when each document is created, the version is 0, and each time the server receives incremental data generated by one client, the version is added with 1; the version snapshot corresponds to all data of the document at a specific time, a complete online table can be displayed by using the version snapshot, and an n-version snapshot can be generated by applying 0 to n versions of incremental data to the document. However, to save storage space, not every incremental data will generate a snapshot immediately.
For example, there are 105 versions of incremental data, and 100 versions of incremental data are selected from the 105 versions of incremental data to generate a 100 version corresponding version snapshot, the size of the version snapshot is 12mb, and the version snapshot can be divided into 4mb data, which are divided into one block, and the block is uniformly stored in the database. It should be noted that the version snapshots can be stored in blocks according to actual application needs.
Therefore, a user can send a document data loading request of a preset version at a corresponding client according to actual application needs, wherein the preset version can be input according to needs, such as a current latest version or a previous history version, and is selected according to actual editing needs.
And S102, judging whether a version snapshot corresponding to the preset version exists or not.
S103, if the version snapshot corresponding to the preset version exists, loading and displaying the version snapshot according to the preset block number.
Therefore, when a document data loading request of a preset version is acquired, it is necessary to determine whether a version snapshot corresponding to the preset version exists, for example, the preset version is 100, determine whether a version snapshot corresponding to the 100 version exists, for example, the preset version is 105, and determine whether a version snapshot corresponding to the 105 version exists.
Specifically, if the version snapshot corresponding to the preset version exists, the version snapshot is loaded and displayed according to the preset block number. The method includes the steps of obtaining a visible area of current equipment and a target block version snapshot, and continuously loading remaining block version snapshots after the target block version snapshot is loaded and displayed in the visible area, namely, displaying data which needs to be displayed preferentially by a user currently in the visible area of the current equipment, so that the user can conveniently and directly obtain the most conceivable data currently.
It should be noted that the first screen document can be displayed in advance through block loading, and the remaining data can be loaded and applied in a correct timing sequence, for example, a preset version corresponds to a version snapshot stored in three blocks, the second block data is displayed on the current first screen, the second block data can be preferentially loaded and displayed, and then the remaining cooling data is loaded to meet the user use requirement, so that the form can display the required data to the user in advance before the form is completely loaded, and the user experience is improved. And the ability of preferentially loading data in a user visible area (which refers to a display area of equipment currently used by a user, namely the size of an interface which can be browsed by the user currently) improves the document opening speed of the user and ensures the correct loading of complete document data.
It is further understood that, in the case that there is no version snapshot corresponding to the preset version, as specifically shown in fig. 2, after step 102, the method further includes:
s201, if the version snapshot corresponding to the preset version does not exist, acquiring a target version snapshot corresponding to a target version adjacent to the preset version, and acquiring a plurality of incremental data.
S202, loading and displaying the preset block number of the target version snapshot, and loading and displaying a plurality of incremental data.
Specifically, a corresponding snapshot is not required to be generated every time incremental data is generated, in order to save storage space, a plurality of increments in a period of time are generated into version snapshots, that is, preset versions are different, and corresponding version snapshots may exist or may not exist, and in the absence of the version snapshots, a target version snapshot corresponding to an adjacent target version closest to the preset versions may be obtained, for example, the preset version is 105, a version snapshot of a 100 th version having the corresponding version snapshot is obtained, incremental data of the versions 101 to 105 are obtained, a preset block number of the target version snapshot is loaded and displayed, and a plurality of incremental data are loaded and displayed.
The manner of loading and displaying the preset number of blocks of the target version snapshot may refer to the description given above as an example.
It should be noted that, in order to further improve the loading efficiency, before the version snapshots are loaded and displayed according to the number of preset blocks, the version snapshots corresponding to the preset versions stored in the blocks may be obtained from the database, and the version snapshots corresponding to the preset versions are cached for the preset time.
That is to say, when the version snapshot corresponding to the preset version exists, the version snapshot cache corresponding to the preset version is obtained from the data for a preset time, for example, 5 minutes, and then the target block data is directly selected from the cache for loading, so that the loading efficiency is further improved, and the user experience is improved. When the version snapshot corresponding to the preset version does not exist, the target version snapshot caching preset time corresponding to the target version adjacent to the preset version can be obtained from the database.
The online form block loading method of the embodiment of the disclosure obtains a document data loading request of a preset version; judging whether a version snapshot corresponding to a preset version exists or not; and if the version snapshots corresponding to the preset versions exist, loading and displaying the version snapshots according to the preset block number. Therefore, the table data is loaded in a blocking mode, online table loading efficiency is improved, and user experience is improved.
Based on the above embodiments, fig. 3 is a schematic flow chart of an online table block loading method according to an embodiment of the present disclosure. As shown in fig. 3, after step S103, the method further includes:
s301, monitoring whether new incremental data are generated or not through a preset monitoring long chain.
And S302, if new incremental data are generated, opening the edition after the new incremental data are loaded.
Specifically, when the preset version is the current latest version, in the process of loading the table data, a data increment newly generated by a coordinator may be received, and therefore, whether new increment data is generated or not needs to be monitored by the preset monitoring long chain, therefore, after a first piece of first screen data is applied and the remaining block data of the first table is continuously requested, and after one table is loaded, the next table is continuously loaded, after all tables are loaded, the application of the complete version snapshot is completed, and then, after all the increment data are loaded, the increment data collected by the monitoring long chain monitoring are loaded and then are open-edited. Therefore, the integrity of the editing data is guaranteed, and the use experience of a user is improved.
Fig. 4 is a schematic structural diagram of an online table block loading device according to an embodiment of the present disclosure. As shown in fig. 4, includes: a first obtaining module 41, a judging module 42 and a displaying module 43.
The first obtaining module 41 is configured to obtain a document data loading request of a preset version.
The determining module 42 is configured to determine whether a version snapshot corresponding to the preset version exists.
And a display module 43, configured to load and display the version snapshots according to the preset number of blocks if the version snapshots corresponding to the preset version exist.
Further, on the basis of the above embodiment, as shown in fig. 5, the apparatus further includes: a second acquisition module 44.
The second obtaining module 44 is configured to, if there is no version snapshot corresponding to the preset version, obtain a target version snapshot corresponding to a target version adjacent to the preset version, and obtain a plurality of incremental data.
The display module 43 is further configured to load and display the preset number of blocks of the target version snapshot, and load and display a plurality of incremental data.
Further, on the basis of the above embodiment, as shown in fig. 6, the apparatus further includes: and a cache module 45.
The caching module 45 is configured to obtain the version snapshots corresponding to the preset versions stored in blocks from the database, and cache the version snapshots corresponding to the preset versions for a preset time.
Further, on the basis of the above embodiment, as shown in fig. 7, the apparatus further includes: a third obtaining module 46, a selecting module 47 and a storing module 48.
The third obtaining module 46 is configured to obtain N incremental data.
And the selecting module 47 is configured to select M incremental data from the N incremental data to generate an mth version snapshot.
The storage module 48 is configured to store the mth version snapshot in a database in blocks according to a preset size; wherein N and M are positive integers, and N is greater than or equal to M.
Further, on the basis of the above embodiment, as shown in fig. 8, the apparatus further includes: and a listening module 49.
The monitoring module 49 is configured to monitor whether new incremental data is generated through a preset monitoring long chain.
And the display module is also used for opening and editing after loading of new incremental data is finished if the new incremental data is generated.
Further, on the basis of the foregoing embodiment, the display module 43 is specifically configured to obtain a visible area and a target block version snapshot of the current device; and after the target block version snapshot is loaded and displayed in the visible area, continuously loading the residual block version snapshot.
The online form block loading device of the embodiment of the disclosure loads a request by acquiring document data of a preset version; judging whether a version snapshot corresponding to a preset version exists or not; and if the version snapshot corresponding to the preset version exists, loading and displaying the version snapshot according to the preset block number. Therefore, by loading the table data in blocks, the online table loading efficiency is improved, and the user experience is improved.
Referring now to FIG. 9, shown is a schematic diagram of an electronic device 900 suitable for use in implementing embodiments of the present disclosure. The terminal device in the embodiments of the present disclosure may include, but is not limited to, a mobile terminal such as a mobile phone, a notebook computer, a digital broadcast receiver, a PDA (personal digital assistant), a PAD (tablet computer), a PMP (portable multimedia player), a vehicle terminal (e.g., a car navigation terminal), and the like, and a stationary terminal such as a digital TV, a desktop computer, and the like. The electronic device shown in fig. 9 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present disclosure.
As shown in fig. 9, the electronic device 900 may include a processing means (e.g., a central processing unit, a graphics processor, etc.) 901 that may perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM) 902 or a program loaded from a storage means 908 into a Random Access Memory (RAM) 903. In the RAM 903, various programs and data necessary for the operation of the electronic apparatus 900 are also stored. The processing apparatus 901, the ROM 902, and the RAM 903 are connected to each other through a bus 904. An input/output (I/O) interface 905 is also connected to bus 904.
Generally, the following devices may be connected to the I/O interface 905: input devices 906 including, for example, a touch screen, touch pad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; an output device 907 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; storage 908 including, for example, magnetic tape, hard disk, etc.; and a communication device 909. The communication means 909 may allow the electronic apparatus 900 to communicate with other apparatuses wirelessly or by wire to exchange data. While fig. 9 illustrates an electronic device 900 having various means, it is to be understood that not all illustrated means are required to be implemented or provided. More or fewer devices may alternatively be implemented or provided.
In particular, the processes described above with reference to the flow diagrams may be implemented as computer software programs, according to embodiments of the present disclosure. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network through the communication device 909, or installed from the storage device 908, or installed from the ROM 902. The computer program, when executed by the processing device 901, performs the above-described functions defined in the methods of the embodiments of the present disclosure.
It should be noted that the computer readable medium of the present disclosure may be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In contrast, in the present disclosure, a computer readable signal medium may comprise a propagated data signal with computer readable program code embodied therein, either in baseband or as part of a carrier wave. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, optical cables, RF (radio frequency), etc., or any suitable combination of the foregoing.
The computer readable medium may be embodied in the electronic device; or may exist separately without being assembled into the electronic device.
The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: acquiring a page rendering request, wherein the page rendering request comprises: a selected region in the page, and a rendering type; the area includes: at least one cell, and/or text data; if the area comprises at least one cell, acquiring an identifier of the at least one cell, wherein the identifier of the cell comprises: a row identifier and a column identifier; and according to the rendering type, rendering the cell corresponding to the identifier of at least one cell.
Computer program code for carrying out operations for aspects of the present disclosure may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, smalltalk, C + +, and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in the embodiments of the present disclosure may be implemented by software or hardware. Where the name of an element does not in some cases constitute a limitation on the element itself.
The present disclosure also provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the online table blocking loading method as described above.
The present disclosure also provides a computer program product, which when executed by an instruction processor in the computer program product, implements the online table blocking loading method as described above.
In the description herein, references to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present disclosure. In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.
Furthermore, the terms "first", "second" and "first" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In the description of the present disclosure, "plurality" means at least two, e.g., two, three, etc., unless explicitly defined otherwise.
Claims (10)
1. An online table block loading method is characterized by comprising the following steps:
storing a version snapshot of a document in a database in blocks, wherein the version snapshot is generated based on incremental data generated after a user edits the document;
acquiring a document data loading request of a preset version;
judging whether a version snapshot corresponding to the preset version exists or not;
and if the version snapshots corresponding to the preset versions exist, loading and displaying the version snapshots according to the preset block number.
2. The method of claim 1, wherein after the determining whether the version snapshot corresponding to the preset version exists, further comprising:
if the version snapshot corresponding to the preset version does not exist, acquiring a target version snapshot corresponding to a target version adjacent to the preset version, and acquiring a plurality of incremental data;
and loading and displaying the preset block number of the target version snapshot, and loading and displaying the plurality of incremental data.
3. The method of claim 1, prior to said loading said version snapshot by a preset number of partitions for display, further comprising:
and acquiring the version snapshots corresponding to the preset versions stored in blocks from a database, and caching the version snapshots corresponding to the preset versions for preset time.
4. The method according to claim 1, further comprising, before the acquiring a preset version of the document data load request:
acquiring N incremental data;
selecting M incremental data from the N incremental data to generate an Mth version snapshot;
the M version snapshot is stored in a database in a blocking mode according to a preset size; wherein N and M are positive integers, and N is greater than or equal to M.
5. The method of claim 1, wherein after the loading and displaying the version snapshot by a preset number of partitions, further comprising:
monitoring whether new incremental data are generated or not through a preset monitoring long chain;
and if new incremental data are generated, opening the edition after the new incremental data are loaded.
6. The method of claim 1, wherein the loading the version snapshot for display according to a preset number of partitions comprises:
acquiring a visible area and a target block version snapshot of current equipment;
and after the target block version snapshot is loaded and displayed in the visible area, continuously loading the residual block version snapshot.
7. An online form chunking loading apparatus, comprising:
the system comprises a first acquisition module, a second acquisition module and a third acquisition module, wherein the first acquisition module is used for acquiring a document data loading request of a preset version, and before the document data loading request of the preset version is acquired, version snapshots of a document are stored in a database in a blocking mode, and the version snapshots are generated based on incremental data generated after a user edits the document;
the judging module is used for judging whether a version snapshot corresponding to the preset version exists or not;
and the display module is used for loading and displaying the version snapshots according to the preset block number if the version snapshots corresponding to the preset versions exist.
8. The apparatus of claim 7, further comprising:
the second obtaining module is used for obtaining a target version snapshot corresponding to a target version adjacent to the preset version and obtaining a plurality of incremental data if the version snapshot corresponding to the preset version does not exist;
the display module is further configured to load and display the preset number of blocks of the target version snapshot, and load and display the plurality of incremental data.
9. An electronic device, comprising:
memory, processor and computer program stored on the memory and executable on the processor, characterized in that the processor when executing the program implements the online table blocking loading method according to any of claims 1 to 6.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the online table blocking loading method according to any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910164945.XA CN109933380B (en) | 2019-03-05 | 2019-03-05 | Online table block loading method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910164945.XA CN109933380B (en) | 2019-03-05 | 2019-03-05 | Online table block loading method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109933380A CN109933380A (en) | 2019-06-25 |
| CN109933380B true CN109933380B (en) | 2023-02-28 |
Family
ID=66986496
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910164945.XA Active CN109933380B (en) | 2019-03-05 | 2019-03-05 | Online table block loading method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109933380B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111581930A (en) * | 2020-05-09 | 2020-08-25 | 北京字节跳动网络技术有限公司 | Online form data processing method and device, electronic equipment and readable medium |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2006291453A (en) * | 2005-04-05 | 2006-10-26 | Public Works Research Institute | Embankment management support system for civil engineering works |
| CN1904879A (en) * | 2005-07-27 | 2007-01-31 | 国际商业机器公司 | Change-oriented electronic list application |
| CN101127034A (en) * | 2006-08-18 | 2008-02-20 | 国际商业机器公司 | Change oriented electronic table application |
| CN102460379A (en) * | 2009-06-02 | 2012-05-16 | 微软公司 | Timeline experience for restore user interface |
| TW201535134A (en) * | 2014-03-03 | 2015-09-16 | Nat Univ Tsing Hua | System and method for recovering system state consistency to any point-in-time in distributed database |
| CN105512227A (en) * | 2015-11-30 | 2016-04-20 | 用友优普信息技术有限公司 | Webpage data loading method and system |
| CN105549936A (en) * | 2015-12-21 | 2016-05-04 | 腾讯科技（深圳）有限公司 | Data table display method and apparatus |
| CN106133766A (en) * | 2014-03-18 | 2016-11-16 | 谷歌公司 | For calculating, apply and show the system and method for document increment |
| CN106445732A (en) * | 2016-08-30 | 2017-02-22 | 华中科技大学附属中学 | Version control-based online snapshot management method and system |
| CN106528125A (en) * | 2016-10-26 | 2017-03-22 | 腾讯科技（深圳）有限公司 | Data file incremental updating method, server, client and system |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP5949219B2 (en) * | 2012-06-29 | 2016-07-06 | ブラザー工業株式会社 | Image processing system, image processing apparatus, image processing method, and image processing program |
| US20140232733A1 (en) * | 2013-02-19 | 2014-08-21 | Jason Caulkins | Graphics Processing Unit Pre-Caching |
-
2019
- 2019-03-05 CN CN201910164945.XA patent/CN109933380B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2006291453A (en) * | 2005-04-05 | 2006-10-26 | Public Works Research Institute | Embankment management support system for civil engineering works |
| CN1904879A (en) * | 2005-07-27 | 2007-01-31 | 国际商业机器公司 | Change-oriented electronic list application |
| CN101127034A (en) * | 2006-08-18 | 2008-02-20 | 国际商业机器公司 | Change oriented electronic table application |
| CN102460379A (en) * | 2009-06-02 | 2012-05-16 | 微软公司 | Timeline experience for restore user interface |
| TW201535134A (en) * | 2014-03-03 | 2015-09-16 | Nat Univ Tsing Hua | System and method for recovering system state consistency to any point-in-time in distributed database |
| CN106133766A (en) * | 2014-03-18 | 2016-11-16 | 谷歌公司 | For calculating, apply and show the system and method for document increment |
| CN105512227A (en) * | 2015-11-30 | 2016-04-20 | 用友优普信息技术有限公司 | Webpage data loading method and system |
| CN105549936A (en) * | 2015-12-21 | 2016-05-04 | 腾讯科技（深圳）有限公司 | Data table display method and apparatus |
| CN106445732A (en) * | 2016-08-30 | 2017-02-22 | 华中科技大学附属中学 | Version control-based online snapshot management method and system |
| CN106528125A (en) * | 2016-10-26 | 2017-03-22 | 腾讯科技（深圳）有限公司 | Data file incremental updating method, server, client and system |
Non-Patent Citations (2)
| Title |
|---|
| DIV+CSS网页布局"教与学"方式探究;王仲满;《 课程教育研究》;20180518;全文 * |
| Region division and improving performance of dynamic code assignment scheme;Davinder S. Saini ET AL;《 TENCON 2008 - 2008 IEEE Region 10 Conference》;20090127;全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109933380A (en) | 2019-06-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111475298B (en) | Task processing method, device, equipment and storage medium | |
| CN109582310B (en) | Data processing method and device, electronic equipment and computer readable storage medium | |
| CN111198859B (en) | Data processing method, device, electronic equipment and computer readable storage medium | |
| CN109491742B (en) | Page table rendering method and device | |
| CN111400625B (en) | Page processing method and device, electronic equipment and computer readable storage medium | |
| CN113038234B (en) | Video processing method and device, electronic equipment and storage medium | |
| CN111857720B (en) | User interface state information generation method and device, electronic equipment and medium | |
| CN110619100A (en) | Method and apparatus for acquiring data | |
| CN113505302A (en) | Method, device and system for supporting dynamic acquisition of buried point data and electronic equipment | |
| CN109933380B (en) | Online table block loading method and device | |
| US10936339B2 (en) | Data sharing method and apparatus, electronic device and computer-readable storage medium | |
| CN109408387B (en) | Page testing method and device | |
| CN111596992A (en) | Navigation bar display method and device and electronic equipment | |
| CN111273967A (en) | Remote hook setting method and device suitable for Android system and electronic equipment | |
| CN111767062A (en) | Application configuration data updating method, device, equipment and storage medium | |
| CN112100211B (en) | Data storage method, apparatus, electronic device, and computer readable medium | |
| CN111625326B (en) | Task pipeline execution method and device and electronic equipment | |
| CN111459893B (en) | File processing method and device and electronic equipment | |
| CN113779461A (en) | Data loading method and device and electronic equipment | |
| CN110113416B (en) | Method and device for displaying information | |
| CN109284350B (en) | Method and device for updating search content, storage medium and electronic equipment | |
| CN111274104B (en) | Data processing method, device, electronic equipment and computer readable storage medium | |
| CN112835671A (en) | Application page scene switching method, device and equipment | |
| CN112100159A (en) | Data processing method and device, electronic equipment and computer readable medium | |
| CN116360710B (en) | Data storage method applied to server cluster, electronic device and readable medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |