CN111666277B - Data chart, data source file updating method, device, system and storage medium - Google Patents
Data chart, data source file updating method, device, system and storage medium Download PDFInfo
- Publication number
- CN111666277B CN111666277B CN201910130252.9A CN201910130252A CN111666277B CN 111666277 B CN111666277 B CN 111666277B CN 201910130252 A CN201910130252 A CN 201910130252A CN 111666277 B CN111666277 B CN 111666277B
- Authority
- CN
- China
- Prior art keywords
- data
- chart
- updated
- description information
- source file
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the application provides a data chart, a data source file updating method, equipment, a system and a storage medium. In the data chart updating method, an updating operation for a data chart is converted into an updating operation for chart description information corresponding to the data chart, and then the data chart is reversely updated according to the updating operation for the chart description information. Because the chart description information has higher readability, the data corresponding to the data to be updated in the data chart can be quickly found from the chart description information to be modified, and the updating efficiency of the data chart can be effectively improved.
Description
Technical Field
The present disclosure relates to the field of data processing technologies, and in particular, to a method, an apparatus, a system, and a storage medium for updating a data chart and a data source file.
Background
Currently, to facilitate data analysis by users, a cross-table may be employed to expose data in a data source. The cross-table is used as a chart type to intuitively show the interrelationship and interaction between different data in the data source.
In general, the operation of updating the data presented by the cross-table depends on the operation of updating the data in the data source. However, the prior art has the following problems: data corresponding to the data to be updated in the cross table is not easy to find from the data source, and therefore the efficiency of updating the data presented by the cross table is low. In view of this, a new solution is needed.
Disclosure of Invention
Aspects of the present application provide a data chart, a data source file updating method, a device, a system and a storage medium, which are used for improving the updating efficiency of the data chart and the data source file.
The embodiment of the application provides a data chart updating method, which comprises the following steps: displaying diagram description information corresponding to the data diagram; the chart description information is generated according to the data chart; and detecting the updating of the chart description information, and updating the data chart according to the updated chart description information.
The embodiment of the application also provides a data source file updating method, which comprises the following steps: receiving a data chart generated by a data source file and sent by a server; the data displayed by the data chart carries an identification mark inherited from the data source file; correspondingly recording each chart unit in the data chart and the data carrying the identification mark displayed by each chart unit so as to generate chart description information; determining an identification mark of the target data in response to the updating operation of the target data in the chart description information; and sending the identification mark and the updated target data to the server so that the server updates the data matched with the identification mark in the data source file according to the updated target data.
The embodiment of the application also provides a data source file updating method, which comprises the following steps: generating a data chart according to a data source file, and sending the data chart to a client; the data displayed by the data chart carries an identification mark inherited from the data source file; receiving identification of target data and updated target data in chart description information sent by the client; determining data matched with the identification mark from the data source file as data to be updated; and updating the data to be updated according to the updated target data so as to update the data source file.
The embodiment of the application also provides a data chart updating device, which comprises: a memory and a processor; the memory is used for storing one or more computer instructions; the processor is configured to execute the one or more computer instructions to: responding to an update request for a data chart, and displaying chart description information corresponding to the data chart; the chart description information is generated according to the data chart; and detecting the updating of the chart description information, and updating the data chart according to the updated chart description information.
The embodiment of the application also provides a computer readable storage medium storing a computer program, and the computer program can realize the data chart updating method provided by the embodiment of the application when being executed.
The embodiment of the application also provides a client, which comprises: a memory, a processor, and a communication component; the memory is used for storing one or more computer instructions; the processor is configured to execute the one or more computer instructions to: receiving, by the communication component, a data chart generated from a data source file sent by a server; the data displayed by the data chart carries an identification mark inherited from the data source file; correspondingly recording each chart unit in the data chart and the data carrying the identification mark displayed by each chart unit so as to generate chart description information; determining an identification mark of the target data in response to the updating operation of the target data in the chart description information; and sending the identification mark and the updated target data to the server through the communication component, so that the server updates the data matched with the identification mark in the data source file according to the updated target data.
The embodiment of the application also provides a computer readable storage medium storing a computer program, and the computer program can realize a data source file updating method executed by a client when being executed.
The embodiment of the application also provides a server, which comprises: a memory, a processor, and a communication component; the memory is used for storing one or more computer instructions; the processor is configured to execute the one or more computer instructions to: generating a data chart according to a data source file, and sending the data chart to a client through the communication component; the data displayed by the data chart carries an identification mark inherited from the data source file; receiving identification of target data and updated target data in chart description information sent by the client through the communication component; determining data matched with the identification mark from the data source file as data to be updated; and updating the data to be updated according to the updated target data so as to update the data source file.
The embodiment of the application also provides a computer readable storage medium storing a computer program, and the computer program can realize a data source file updating method executed by a server when being executed.
The embodiment of the application also provides a data source file updating system, which comprises the following steps: a client and a server; wherein, the client is used for: receiving a data chart sent by the server; correspondingly recording each chart unit in the data chart and the data carrying the identification mark displayed by each chart unit so as to generate chart description information; responding to the updating operation of the target data in the chart description information, determining the identification mark of the target data, and sending the target data updated by the identification mark to the server; the server is used for: generating the data chart according to a data source file, and sending the data chart to the client; the data displayed by the data chart carries an identification mark inherited from the data source file; receiving the identification mark and the updated target data sent by the client; and determining the data matched with the identification mark from the data source file as data to be updated, and updating the data to be updated according to the updated target data so as to update the data source file.
In the data chart updating method provided by the embodiment of the application, the updating operation of the data chart is converted into the updating operation of the chart description information corresponding to the data chart, and then the data chart is reversely updated according to the updating operation of the chart description information. Because the chart description information has higher readability, the data corresponding to the data to be updated in the data chart can be quickly found from the chart description information to be modified, and the updating efficiency of the data chart can be effectively improved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this application, illustrate embodiments of the application and together with the description serve to explain the application and do not constitute an undue limitation to the application. In the drawings:
FIG. 1 is a flow chart of a method for updating a data chart according to an exemplary embodiment of the present application;
FIG. 2a is a schematic diagram of a cross table and corresponding JSON description information according to an exemplary embodiment of the present application;
FIG. 2b is a flow chart of a method for updating a data chart according to another exemplary embodiment of the present application;
FIG. 3a is a flow chart of a method for updating a data chart according to yet another exemplary embodiment of the present invention;
FIG. 3b is a flow chart of a method for updating a data chart according to yet another exemplary embodiment of the present invention;
FIG. 4 is a flowchart illustrating a method for updating a data source file according to an exemplary embodiment of the present invention;
FIG. 5 is a flowchart of a method for updating a data source file according to another exemplary embodiment of the present invention;
FIG. 6 is a schematic diagram of a data chart update apparatus according to an exemplary embodiment of the present application;
fig. 7 is a schematic structural diagram of a client according to an exemplary embodiment of the present application;
Fig. 8 is a schematic structural diagram of a server according to an exemplary embodiment of the present application;
fig. 9 is a schematic structural diagram of a data source file update system according to an exemplary embodiment of the present application.
Detailed Description
For the purposes, technical solutions and advantages of the present application, the technical solutions of the present application will be clearly and completely described below with reference to specific embodiments of the present application and corresponding drawings. It will be apparent that the described embodiments are only some, but not all, of the embodiments of the present application. All other embodiments, which can be made by one of ordinary skill in the art without undue burden from the present disclosure, are within the scope of the present disclosure.
In general, when generating a cross table, data in a data source file often needs to undergo data processing operations such as calculation, sorting or filtering, so that a correspondence between the data in the data source file and the data in the cross table is not intuitive. When the data presented by the cross table is updated (e.g. modified and deleted), the data corresponding to the data to be updated in the cross table is not easy to find from the data source file, and therefore, the updating efficiency is lower when the data presented by the cross table is updated.
In view of this drawback, in some embodiments of the present application, a solution is provided, and in the following, the technical solutions provided by the embodiments of the present application will be described in detail with reference to the accompanying drawings.
Fig. 1 is a flow chart illustrating a method for updating a data chart according to an exemplary embodiment of the present application, as shown in fig. 1, the method includes:
And 102, when the updating operation of the chart description information is detected, updating the data chart according to the updated chart description information.
The data chart is a technical term commonly used in the field, and may include, for example, a graphic structure displayed in a screen, wherein the graphic structure can intuitively display statistical information attributes (such as time attributes, quantity attributes and the like) and plays a key role in knowledge mining and information visual and vivid feeling. The data chart is generated according to the data source file, and the data in the data source file can be intuitively and vividly displayed. In this embodiment, the data diagram includes, but is not limited to: bar graphs, line graphs, sector graphs, radar graphs, word cloud graphs, funnel graphs, data maps, waterfall graphs, intersection tables, and the like.
And describing and generating the data chart by adopting a direct description mode according to chart description information corresponding to the data chart. Unlike the data source file, the chart description information is generated according to the data chart and has an intuitive correspondence with the data in the data chart.
Based on the visual corresponding relation, when an update request for the data chart exists, description information corresponding to data to be updated in the data chart can be quickly found in chart description information; and then, updating the description information to obtain updated chart description information, and reversely updating the data chart according to the updated chart description information.
In this embodiment, the updating operation for the data chart is converted into the updating operation for the chart description information corresponding to the data chart, and then the data chart is reversely updated according to the updating operation for the chart description information. Because the chart description information has higher readability, the data corresponding to the data to be updated in the data chart can be quickly found from the chart description information to be modified, and the updating efficiency of the data chart can be effectively improved.
In the above or below embodiments of the present application, the chart description information corresponding to the data chart may be shown when an update request for the data chart is detected. The update request for the data chart can be initiated by a user, or can be triggered by a timing event or other upper-level events. For example, in some scenarios, a modification button may be presented while a data chart is presented; when a trigger operation of the user for the modification button is detected, it can be considered that an update request for the data chart initiated by the user is detected. In other scenarios, upon detecting a user's click or swipe operation of a designated area on a data diagram, it may be considered that a user-initiated update request for the data diagram was detected.
In the above or below embodiments of the present application, the chart description information may be generated in a language that is easy to generate and has high readability. For example, the chart description information may be generated in JSON (JavaScript Object Notation, JS object numbered musical notation) language, or in XML (Extensible Markup Language ). Of course, in other embodiments, other languages than JSON and XML may be used to generate the chart description information, which is not limited in this embodiment.
For example, when the data graph is a cross table, the graph description information may be cross table description information in JSON format, or cross table description information in XML format, which is included but not limited thereto.
In the above or below embodiments of the present application, when generating the chart description information according to the data chart, each chart unit in the data chart may be taken as a description object, and the data displayed by each chart unit may be taken as a description value of the description object, so as to generate the chart description information. Wherein, the chart unit refers to a unit area of data displayed on the chart. For example, for a cross-table, its chart cells may be cell areas on the cross-table; for another example, for a sector, the chart unit may be a sector area corresponding to a central angle of 1 °.
Based on the above, a chart unit in the data chart and the data displayed by the chart unit can be recorded as a group of description objects and corresponding description values in the chart description information. For example, the chart description information is generated by JSON language, and the chart units can be used as keys in a key=value (key value pair) form, and the data displayed by the chart units are used as the values corresponding to the keys so as to record each chart unit in the data chart and the data displayed by each chart unit.
Next, with reference to fig. 2a, schematic description of the graph description information will be given by taking the cross table as an example. In fig. 2a, the graph description information is implemented as JSON description information of a cross table. In the JSON description information, the type (type) of the cell is key, the data displayed by the cell is value, and the first row of cells in the cross table and the data displayed by the cells are described in a key=value description mode. For example, the type of the first cell in the first row in the cross-over table is: standard dimension, which shows the data: orderID, the first cell is used as a description object, and the data displayed by the first cell is used as a description value, so that the following description information can be generated:
{“type”:“StandardDimension”，“v”:“Order ID”}
similarly, description information corresponding to the second cell of the first row can be generated:
{“type”:“StandardDimension”，“v”:“Order Level”}
The description information of other cells in the cross table may be generated according to the above method, which is not described herein.
In some alternative embodiments, when the data chart is updated according to the updated chart description information, a new data chart can be generated by adopting all data in the updated chart description information to replace the existing data chart, so that the existing data chart is updated in a mode that the new data chart covers the existing data chart.
In other alternative embodiments, when the data chart is updated according to the updated chart description information, only part of the data in the updated chart description information can be used for updating part of the data displayed by the data chart, so as to reduce the data processing resources occupied by updating the data chart. As will be described below in connection with fig. 2 b.
Fig. 2b is a flow chart illustrating a method for updating a data chart according to another exemplary embodiment of the present application, as shown in fig. 2b, the method includes:
and step 201, generating chart description information according to the data chart, and establishing a corresponding relation between a description object in the chart description information and a chart unit in the data chart.
And 204, determining a chart unit corresponding to the target description object in the data chart as a chart unit to be updated according to the description object in the chart description information and the corresponding relation of the chart unit in the data chart.
And 205, updating the data displayed by the chart unit to be updated according to the updated description value.
In step 201, optionally, when generating the chart description information, the name of the chart unit may be used as the name of the description object, so as to establish the correspondence between the description object and the chart unit by the name.
Alternatively, when generating the chart description information, the chart unit and the description object may be encoded, and the chart unit and the description object having the correspondence relationship may be encoded as the same identification code, so that the correspondence relationship between the description object and the chart unit is established through the identification code.
Alternatively, when generating the chart description information, the recording order of the description objects in the chart description information may be determined according to the arrangement order of the chart units in the data chart, so as to establish the correspondence between the description objects and the chart units in sequence. An exemplary embodiment may be shown in fig. 2a, in the cross table and JSON description information of the cross table illustrated in fig. 2a, the description objects in the JSON description information and the corresponding description values thereof have a corresponding relationship with the cells in the cross table and the displayed data in sequence, and based on the corresponding relationship in sequence, the corresponding relationship between the cells in the cross table and the description objects in the JSON description information may be established.
Of course, in other embodiments, the correspondence between the description object and the chart unit may be established in other alternative manners, and this embodiment includes, but is not limited to, the above-listed embodiments.
In step 202, optionally, when the user has an update request for any chart element on the data chart, the chart element may be selected. Optionally, the selecting operation may be implemented through a clicking operation or a touch operation, which is specific to the display mode of the data chart, and the embodiment is not limited.
In response to a selection operation for the chart unit, a description object corresponding to the selected chart unit can be determined according to the corresponding relation between the description object and the chart unit, chart description information is displayed, and the description object corresponding to the chart unit is positioned in the chart description information. In this embodiment, after the user selects the chart unit to be modified, the description object corresponding to the chart unit can be automatically located for the user to perform the update operation, so that the time cost required by the user to determine the description object can be further reduced, and the modification efficiency of the data chart is improved.
Then, the user can update the description object corresponding to the chart unit according to the requirement. Wherein the updating mode can include one or more of modification, deletion, addition and replacement
In step 203, detecting an update operation of the chart description information may include: in the detected diagram description information, the description value of one or more description objects is updated. At this time, the updated target description object and the corresponding updated description value thereof may be determined from the updated chart description information.
In step 204, after determining the target description object, a chart unit corresponding to the target description object in the data chart may be determined as a chart unit to be updated based on the correspondence between the description object and the chart unit established in step 201.
Next, in step 205, the data displayed by the chart unit to be updated may be updated according to the updated description value. Alternatively, the updated description value may be used to replace the data presented by the chart unit to be updated.
An exemplary embodiment of the steps 203 to 205 may be: a snoop event is added for the chart description information to snoop whether an update of the chart description information occurs. When the chart description information is monitored to be updated, the updated target description object and the corresponding updated description value thereof are obtained, and the modification action for the data chart is triggered, which is not repeated.
In this embodiment, the updating operation for the data chart is converted into the updating operation for the chart description information corresponding to the data chart. After the updated chart description information is obtained, according to the corresponding relation between the description object in the chart description information and the chart unit in the data chart, the updating content of the chart description information can be synchronized to the data chart so as to update the data chart. In the embodiment, based on the high readability of the chart description information, the data chart updating operation can be rapidly realized, and the updating efficiency is improved.
In the embodiment corresponding to fig. 2b, the association between the data chart and the chart description information may be implemented based on the correspondence between the description object in the chart description information and the chart unit in the data chart. In other embodiments, the association of the data graph and graph description information may be implemented based on the identification carried by the data.
In such an embodiment, before the data chart is generated, identification (ID) may be added to the data stored in each cell in the data source file, and the identification of the data stored in different cells may be different. For example, when the data source file is an Excel file, a unique ID may be added to the data deposited in each cell in the Excel file.
Next, a data chart is generated from the data source file to which the identification tag is added. The data displayed by each chart unit in the data chart also carries the respective identification mark, namely, the data displayed by the data chart inherits the identification mark in the data source file.
Based on this, when generating the chart description information from the data chart, the identification mark can be transferred to the chart description information. Further, the data chart and chart description information may be associated by the identification. As will be described in detail below.
Fig. 3a is a schematic flow chart of a data chart updating method according to another exemplary embodiment of the present invention, as shown in fig. 3a, the method includes:
And 304, determining to obtain updated description values from the updated chart description information when the updating operation of the chart description information is detected.
In this embodiment, the data displayed by each chart unit in the data chart carries an identification mark, and when generating chart description information according to the data chart, the identification mark is transferred to the chart description information. Based on the above, in the generated chart description information, the description value of each description object also carries an identification mark, and further, the data chart and the chart description information can be associated through the identification mark.
Unlike the embodiment corresponding to fig. 2b, this embodiment is no longer dependent on the correspondence of the description object and the chart unit. After the updated chart description information is obtained, according to the identification mark of the obtained updated description value, the updating content of the chart description information can be synchronized to the data chart so as to realize the updating of the data table.
As shown in fig. 3b, the data processing method provided in this embodiment further includes:
step 306: and determining data matched with the identification carried by the updated description value from the data source file as second data to be updated.
In this embodiment, after the chart description information is updated, the updating may be further synchronized to the data source file, so as to keep the consistency between the data in the data source file and the data in the data chart, and facilitate other services to use the data source file. In the data source file, the identification mark is added to the data stored in each cell, so that the data matched with the identification mark carried by the updated description value can be determined from the data source file and used as the second data to be updated, and the second data to be updated is updated according to the updated description value to update the data source file.
In this embodiment, data carrying identification marks, for example: the data displayed by the data chart, the description value in the chart description file and the data in the data source file keep unchanged the carried identification mark when being updated, and if the data has new and old replacement operations, the identification mark of the old data can be inherited by the new data.
Fig. 4 is a flowchart of a method for updating a data source file according to an exemplary embodiment of the present invention, as shown in fig. 4, where the method includes:
And step 404, transmitting the identification mark and the updated target data to a server so that the server updates the data matched with the identification mark in the data source file according to the updated target data.
Alternatively, in the present embodiment, a listening event may be added to the chart description information to listen to the update operation of the chart description information. When the updating operation of the target data in the chart description information is monitored, the identification mark of the target data is determined, and the operation of sending the identification mark and the updated target data to the server is triggered, which is not repeated.
In this embodiment, the client may generate the chart description information according to the data chart sent by the server, and the chart description information may provide the user with a convenient channel for modifying the data source file for generating the data chart. When a user needs to update the data displayed by the data chart, in order to keep consistency of the data displayed by the data chart and the data in the data source file, chart description information can be used as a bridge, identification carried by the data is used as a tie, and synchronous updating operation between the data chart and the data source file is converted into synchronous updating operation between the chart description information and the data source file. Furthermore, the operation of updating the data source file by the user through the client becomes more convenient and efficient.
Fig. 5 is a flowchart of a method for updating a data source file according to another exemplary embodiment of the present invention, as shown in fig. 5, where the method includes:
In this embodiment, the server may add an identification to the data held in the data source file, which identification may be transferred to the data schema. The identification may then be passed to the chart description information as the client generates the chart description information from the data chart. Based on the method, when a user initiates an updating operation of target data in the chart description information through the client, the server can modify corresponding data in the data source file according to the identification of the target data and the updated target data, so that the user can quickly modify the data source file through the client.
It should be noted that, the execution subjects of each step of the method provided in the above embodiment may be the same device, or the method may also be executed by different devices. For example, the execution subject of steps 201 to 204 may be device a; for another example, the execution subject of steps 201 and 202 may be device a, and the execution subject of step 203 may be device B; etc.
In addition, in some of the flows described in the above embodiments and the drawings, a plurality of operations appearing in a specific order are included, but it should be clearly understood that the operations may be performed out of the order in which they appear herein or performed in parallel, the sequence numbers of the operations such as 201, 202, etc. are merely used to distinguish between the various operations, and the sequence numbers themselves do not represent any order of execution. In addition, the flows may include more or fewer operations, and the operations may be performed sequentially or in parallel. It should be noted that, the descriptions of "first" and "second" herein are used to distinguish different messages, devices, modules, etc., and do not represent a sequence, and are not limited to the "first" and the "second" being different types.
Fig. 6 is a schematic structural diagram of a data chart updating apparatus according to an exemplary embodiment of the present application, and as shown in fig. 6, the data chart updating apparatus includes: a memory 601 and a processor 602.
The memory 601 is used for storing computer programs and may be configured to store various other data to support operations on the data diagram update apparatus. Examples of such data include instructions for any application or method operating on the data diagram update device, contact data, phonebook data, messages, pictures, video, and the like.
A processor 602 coupled to the memory 601 for executing the computer programs in the memory 601 for: displaying diagram description information corresponding to the data diagram; the chart description information is generated according to the data chart; and detecting the updating of the chart description information, and updating the data chart according to the updated chart description information.
Further optionally, the processor 602 is further configured to: and generating the chart description information by taking each chart unit in the data chart as a description object and taking the data displayed by each chart unit as a description value of the description object.
Further optionally, the processor 602 is specifically configured to, when updating the data chart according to the updated chart description information: and generating a new data chart for replacing the data chart according to the updated chart description information.
Further optionally, the processor 602, when generating the chart description information, is further configured to: establishing a corresponding relation between a description object in the chart description information and a chart unit in the data chart; the processor 602 is specifically configured to, when displaying the chart description information corresponding to the data chart: and responding to the selected operation of any chart unit on the data chart, displaying the chart description information, and positioning a description object corresponding to the chart unit in the chart description information.
Further optionally, the processor 602 is specifically configured to, when updating the data chart according to the updated chart description information: determining an updated target description object and a corresponding updated description value thereof from the updated chart description information; determining a chart unit corresponding to the target description object in the data chart as a chart unit to be updated according to the corresponding relation between the description object in the chart description information and the chart unit in the data chart; and updating the data displayed by the chart unit to be updated according to the updated description value.
Further optionally, the processor 602 is further configured to: adding identification marks for data stored in each cell in a data source file, wherein the identification marks of the data stored in different cells are different; generating the data chart according to the data source file added with the identification mark; the data displayed by each chart unit in the data chart carries respective identification marks; the processor 602 is specifically configured to, when taking each chart unit in the data chart as a description object and taking data shown in each chart unit as a description value of the description object, generate the chart description information: and correspondingly recording the chart units and the displayed data carrying the identification marks to obtain the description objects and the corresponding description values carrying the identification marks so as to transmit the identification marks in the data chart to the chart description information.
Further optionally, the processor 602 is specifically configured to, when presenting the chart description information corresponding to the data chart: responding to the selected operation of any chart unit on the data chart, and determining the identification of the data displayed by the chart unit; and displaying the chart description information, and positioning a description value corresponding to the identification in the chart description information.
Further optionally, the processor 602 is specifically configured to, when updating the data chart according to the updated chart description information: determining to obtain updated description values from the updated chart description information; determining data matched with the identification carried by the updated description value from the data displayed by the data chart as first data to be updated; and updating the first data to be updated according to the updated description value.
Further optionally, the processor 602 is further configured to, when detecting an update of the chart description information: determining to obtain updated description values from the updated chart description information; determining data matched with the identification carried by the updated description value from the data source file as second data to be updated; and updating the second data to be updated according to the updated description value so as to update the data source file.
Further optionally, the data graph is a cross table; the diagram description information is cross table description information in JSON format or XML format.
Further, as shown in fig. 6, the data chart updating apparatus further includes: communication component 603, display 604, power component 605, audio component 606, and other components. Only a part of the components are schematically shown in fig. 6, which does not mean that the data chart updating device only comprises the components shown in fig. 6.
In this embodiment, the data chart updating apparatus converts an updating operation for the data chart into an updating operation for the chart description information corresponding to the data chart, and then reversely updates the data chart according to the updating operation for the chart description information. Because the chart description information has higher readability, the data corresponding to the data to be updated in the data chart can be quickly found from the chart description information to be modified, and the updating efficiency of the data chart can be effectively improved.
Accordingly, the embodiments of the present application also provide a computer readable storage medium storing a computer program, where the computer program when executed can implement each step in the data chart updating method that can be executed by the data chart updating apparatus in the above method embodiment.
Fig. 7 is a schematic structural diagram of a client according to an exemplary embodiment of the present application. As shown in fig. 7, the client includes: memory 701, processor 702, and communication component 703.
A processor 702 coupled with the memory 701 for executing the computer program in the memory 701 for: receiving, by the communication component 703, a data diagram generated by a data source file sent by a server; the data displayed by the data chart carries an identification mark inherited from the data source file; correspondingly recording each chart unit in the data chart and the data carrying the identification mark displayed by the chart unit so as to generate chart description information; responding to the updating operation of the target data in the chart description information, and determining the identification of the target data; the identification and the updated target data are sent to the server through the communication component 703, so that the server updates the data matching the identification in the data source file according to the updated target data.
Further, as shown in fig. 7, the client further includes: a display 704, a power supply component 705, an audio component 706, and other components. Only some of the components are schematically shown in fig. 7, which does not mean that the client only comprises the components shown in fig. 7.
In this embodiment, the client may generate the chart description information according to the data chart sent by the server, and the chart description information may provide the user with a convenient channel for modifying the data source file for generating the data chart. When a user needs to update the data displayed by the data chart, in order to keep consistency of the data displayed by the data chart and the data in the data source file, chart description information can be used as a bridge, identification carried by the data is used as a tie, and synchronous updating operation between the data chart and the data source file is converted into synchronous updating operation between the chart description information and the data source file. Furthermore, the operation of updating the data source file by the user through the client becomes more convenient and efficient.
Accordingly, the present application further provides a computer readable storage medium storing a computer program, where the computer program when executed is capable of implementing each step in the data source file updating method that can be executed by the client in the above method embodiment.
Fig. 8 is a schematic structural diagram of a server according to an exemplary embodiment of the present application. As shown in fig. 8, the server includes: memory 801, processor 802, and communication component 803.
A processor 802 coupled to the memory 801 for executing computer programs in the memory 801 for: generating a data chart from the data source file and sending the data chart to the client through the communication component 803; the data displayed by the data chart carries an identification mark inherited from the data source file; receiving, by the communication component 803, an identification of target data in the chart description information sent by the client and the updated target data; determining data matched with the identification mark from the data source file as data to be updated; and updating the data to be updated according to the updated target data so as to update the data source file.
Further, as shown in fig. 8, the server further includes: power supply assembly 804, and the like. Only some of the components are schematically shown in fig. 8, which does not mean that the server only comprises the components shown in fig. 8.
In this embodiment, the server may add an identification to the data stored in the data source file, which identification may be transferred to the data schema. The identification may then be passed to the chart description information as the client generates the chart description information from the data chart. Based on the method, when a user initiates an updating operation of target data in the chart description information through the client, the server can modify corresponding data in the data source file according to the identification of the target data and the updated target data, so that the user can quickly modify the data source file through the client.
Accordingly, the present application further provides a computer readable storage medium storing a computer program, where the computer program when executed is capable of implementing each step in the data source file updating method that can be executed by the server in the above method embodiment.
The memory of fig. 6, 7, 8 described above may be implemented by any type or combination of volatile or non-volatile memory devices, such as Static Random Access Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic disk, or optical disk.
The communication assembly of fig. 7 and 8 is configured to facilitate wired or wireless communication between the device in which the communication assembly is located and other devices. The device in which the communication component is located may access a wireless network based on a communication standard, such as WiFi,2G or 3G, or a combination thereof. In one exemplary embodiment, the communication component receives a broadcast signal or broadcast-related information from an external broadcast management system via a broadcast channel. In one exemplary embodiment, the communication component may be implemented based on Near Field Communication (NFC) technology, radio Frequency Identification (RFID) technology, infrared data association (IrDA) technology, ultra Wideband (UWB) technology, bluetooth (BT) technology, and other technologies.
The displays in fig. 6 and 7 described above include screens, which may include a Liquid Crystal Display (LCD) and a Touch Panel (TP). If the screen includes a touch panel, the screen may be implemented as a touch screen to receive input signals from a user. The touch panel includes one or more touch sensors to sense touches, swipes, and gestures on the touch panel. The touch sensor may sense not only the boundary of a touch or sliding action, but also the duration and pressure associated with the touch or sliding operation.
The power supply assembly shown in fig. 6, 7 and 8 provides power for various components of the device where the power supply assembly is located. The power components may include a power management system, one or more power sources, and other components associated with generating, managing, and distributing power for the devices in which the power components are located.
FIG. 9 is a schematic structural diagram of a data source file update system according to an exemplary embodiment of the present application, as shown in FIG. 9, the data source file update system 900 includes: a client 901 and a server 902.
In the data source file updating system 900, a client 901 and a server 902 can establish a communication connection to implement data exchange, and a specific communication connection manner depends on an actual application scenario.
In some exemplary embodiments, the client 901 and the server 902 may communicate using a wired communication method and a wireless communication method.
The WIreless communication modes include short-distance communication modes such as bluetooth, zigBee, infrared, wiFi (WIreless Fidelity), etc., long-distance WIreless communication modes such as LORA, etc., and WIreless communication modes based on a mobile network. When the mobile network is in communication connection, the network system of the mobile network can be any one of 2G (GSM), 2.5G (GPRS), 3G (WCDMA, TD-SCDMA, CDMA2000, UTMS), 4G (LTE), 4g+ (lte+), 5G, wiMax, and the like.
The structure of the client 901 may be as shown in fig. 7. In some embodiments, the client 901 may be implemented as a mobile phone, a tablet computer, a multimedia display terminal, a computer, or the like on the user side.
The structure of the server 902 may be as shown in fig. 8. In some embodiments, the server 902 may be implemented as a conventional server, a cloud host, a virtual center, or other devices, which is not limited in this embodiment.
In the data source file update system 900, a server 902 is mainly used for: a data chart is generated from the data source file and sent to the client 901. The data diagram shows data carrying identification inherited from the data source file.
In the data source file update system 900, it is mainly used to: receiving the data chart sent by the server 902; correspondingly recording each chart unit in the data chart and the data carrying the identification mark displayed by the chart unit so as to generate chart description information; in response to the update operation of the target data in the chart description information, an identification of the target data is determined, and the target data after the identification is updated is sent to the server 902.
Then, the server 902 may receive the identification sent by the client 901 and the updated target data; and determining the data matched with the identification mark from the data source file as data to be updated, and updating the data to be updated according to the updated target data so as to update the data source file.
In the data source file updating system 900, based on the interaction process between the client 901 and the server 902 described in the above embodiments, a user can conveniently and efficiently implement the updating operation of the data source file through the chart description information provided by the client, which is beneficial to improving the efficiency of data processing.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In one typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of computer-readable media.
Computer readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. Computer-readable media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article or apparatus that comprises the element.
The foregoing is merely exemplary of the present application and is not intended to limit the present application. Various modifications and changes may be made to the present application by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc. which are within the spirit and principles of the present application are intended to be included within the scope of the claims of the present application.
Claims (16)
1. A method of updating a data chart, comprising:
displaying diagram description information corresponding to the data diagram; the chart description information is generated according to the data chart;
detecting the updating of the chart description information, and updating the data chart according to the updated chart description information;
The method further comprises the steps of: and taking each chart unit in the data chart as a description object, taking the data displayed by each chart unit as a description value of the description object, and generating the chart description information by adopting the following steps: adding identification marks for data stored in each cell in a data source file, wherein the identification marks of the data stored in different cells are different; generating the data chart according to the data source file added with the identification mark, wherein the data displayed by each chart unit in the data chart carries the identification mark; correspondingly recording the chart units and the displayed data carrying identification marks to obtain the description objects and the corresponding description values carrying the identification marks so as to transmit the identification marks in the data chart to the chart description information;
wherein updating the data chart according to the updated chart description information comprises: determining to obtain updated description values from the updated chart description information; determining data matched with the identification carried by the updated description value from the data displayed by the data chart as first data to be updated; and updating the first data to be updated according to the updated description value.
2. The method of claim 1, wherein updating the data graph based on the updated graph description information comprises:
and generating a new data chart for replacing the data chart according to the updated chart description information.
3. The method of claim 1, wherein generating the chart description information further comprises:
establishing a corresponding relation between a description object in the chart description information and a chart unit in the data chart;
and displaying the diagram description information corresponding to the data diagram, wherein the diagram description information comprises the following steps:
and responding to the selected operation of any chart unit on the data chart, displaying the chart description information, and positioning a description object corresponding to the chart unit in the chart description information.
4. The method of claim 3, wherein updating the data graph based on the updated graph description information comprises:
determining an updated target description object and a corresponding updated description value thereof from the updated chart description information;
determining a chart unit corresponding to the target description object in the data chart as a chart unit to be updated according to the corresponding relation between the description object in the chart description information and the chart unit in the data chart;
And updating the data displayed by the chart unit to be updated according to the updated description value.
5. The method of claim 1, wherein presenting the chart description information corresponding to the data chart comprises:
responding to the selected operation of any chart unit on the data chart, and determining the identification of the data displayed by the chart unit;
and displaying the chart description information, and positioning a description value corresponding to the identification mark in the chart description information.
6. The method of any of claims 1-5, wherein detecting an update of the chart description information further comprises:
determining to obtain updated description values from the updated chart description information;
determining data matched with the identification carried by the updated description value from the data source file as second data to be updated;
and updating the second data to be updated according to the updated description value so as to update the data source file.
7. The method of any one of claims 1-5, wherein the data graph is a cross-table; the chart description information is cross table description information in JSON format or XML format.
8. A method for updating a data source file, comprising:
receiving a data chart generated by a data source file and sent by a server; the data displayed by the data chart carries an identification mark inherited from the data source file;
correspondingly recording each chart unit in the data chart and the data carrying the identification mark displayed by each chart unit so as to generate chart description information;
determining an identification mark of the target data in response to the updating operation of the target data in the chart description information;
and sending the identification mark and the updated target data to the server so that the server updates the data matched with the identification mark in the data source file according to the updated target data.
9. A method for updating a data source file, comprising:
generating a data chart according to a data source file, and sending the data chart to a client; the data displayed by the data chart carries an identification mark inherited from the data source file;
receiving identification of target data and updated target data in chart description information sent by the client; the chart description information is generated by correspondingly recording each chart unit in the data chart and the displayed data carrying the identification mark;
Determining data matched with the identification mark from the data source file as data to be updated;
and updating the data to be updated according to the updated target data so as to update the data source file.
10. A data chart updating apparatus, characterized by comprising: a memory and a processor;
the memory is used for storing one or more computer instructions;
the processor is configured to execute the one or more computer instructions to: displaying diagram description information corresponding to the data diagram; the chart description information is generated according to the data chart; detecting the updating of the chart description information, and updating the data chart according to the updated chart description information;
the processor is further configured to: taking each chart unit in the data chart as a description object, taking the data displayed by each chart unit as a description value of the description object, and executing the following steps to generate the chart description information: adding identification marks for data stored in each cell in a data source file, wherein the identification marks of the data stored in different cells are different; generating the data chart according to the data source file added with the identification mark; the data displayed by each chart unit in the data chart carries respective identification marks; correspondingly recording the chart units and the displayed data carrying identification marks to obtain the description objects and the corresponding description values carrying the identification marks so as to transmit the identification marks in the data chart to the chart description information;
Wherein, the processor is specifically configured to: determining to obtain updated description values from the updated chart description information; determining data matched with the identification carried by the updated description value from the data displayed by the data chart as first data to be updated; and updating the first data to be updated according to the updated description value.
11. A computer readable storage medium storing a computer program, characterized in that the computer program is capable of implementing the data chart updating method of any one of claims 1-7 when executed.
12. A client, comprising: a memory, a processor, and a communication component;
the memory is used for storing one or more computer instructions;
the processor is configured to execute the one or more computer instructions to: receiving, by the communication component, a data chart generated from a data source file sent by a server; the data displayed by the data chart carries an identification mark inherited from the data source file; correspondingly recording each chart unit in the data chart and the data carrying the identification mark displayed by each chart unit so as to generate chart description information; determining an identification mark of the target data in response to the updating operation of the target data in the chart description information; and sending the identification mark and the updated target data to the server through the communication component, so that the server updates the data matched with the identification mark in the data source file according to the updated target data.
13. A computer readable storage medium storing a computer program, wherein the computer program is capable of implementing the data source file updating method of claim 8 when executed.
14. A server, comprising: a memory, a processor, and a communication component;
the memory is used for storing one or more computer instructions;
the processor is configured to execute the one or more computer instructions to: generating a data chart according to a data source file, and sending the data chart to a client through the communication component; the data displayed by the data chart carries an identification mark inherited from the data source file; receiving identification of target data and updated target data in chart description information sent by the client through the communication component; the chart description information is generated by correspondingly recording each chart unit in the data chart and the displayed data carrying the identification mark; determining data matched with the identification mark from the data source file as data to be updated; and updating the data to be updated according to the updated target data so as to update the data source file.
15. A computer readable storage medium storing a computer program, wherein the computer program is capable of implementing the data source file updating method of claim 9 when executed.
16. A data source file update system, comprising: a client and a server;
wherein, the client is used for: receiving a data chart sent by the server; correspondingly recording each chart unit in the data chart and the data carrying the identification mark displayed by each chart unit so as to generate chart description information; responding to the updating operation of the target data in the chart description information, determining the identification mark of the target data, and sending the target data updated by the identification mark to the server;
the server is used for: generating the data chart according to a data source file, and sending the data chart to the client; the data displayed by the data chart carries an identification mark inherited from the data source file; receiving the identification mark and the updated target data sent by the client; and determining the data matched with the identification mark from the data source file as data to be updated, and updating the data to be updated according to the updated target data so as to update the data source file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910130252.9A CN111666277B (en) | 2019-02-21 | 2019-02-21 | Data chart, data source file updating method, device, system and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910130252.9A CN111666277B (en) | 2019-02-21 | 2019-02-21 | Data chart, data source file updating method, device, system and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111666277A CN111666277A (en) | 2020-09-15 |
| CN111666277B true CN111666277B (en) | 2023-05-26 |
Family
ID=72381261
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910130252.9A Active CN111666277B (en) | 2019-02-21 | 2019-02-21 | Data chart, data source file updating method, device, system and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111666277B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH02297133A (en) * | 1989-03-02 | 1990-12-07 | Nec Corp | Diagram managing system |
| EP1619600A2 (en) * | 2004-07-19 | 2006-01-25 | Microsoft Corporation | Remote file updates through remote protocol |
| CN101067849A (en) * | 2006-12-20 | 2007-11-07 | 腾讯科技（深圳）有限公司 | Data diagram generating method and generating system |
| CN104572098A (en) * | 2014-12-30 | 2015-04-29 | 北京奇虎科技有限公司 | Updating method and device of mobile terminal page diagram |
| CN105528218A (en) * | 2015-12-30 | 2016-04-27 | 城云科技（杭州）有限公司 | Data diagram cascaded method and data diagram cascaded system |
| CN108492028A (en) * | 2018-03-21 | 2018-09-04 | 徐欣 | Demand data standardized method and standardized system |
| CN108804403A (en) * | 2017-04-28 | 2018-11-13 | 阿里巴巴集团控股有限公司 | The implementation method and device of business graphics |
-
2019
- 2019-02-21 CN CN201910130252.9A patent/CN111666277B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH02297133A (en) * | 1989-03-02 | 1990-12-07 | Nec Corp | Diagram managing system |
| EP1619600A2 (en) * | 2004-07-19 | 2006-01-25 | Microsoft Corporation | Remote file updates through remote protocol |
| CN101067849A (en) * | 2006-12-20 | 2007-11-07 | 腾讯科技（深圳）有限公司 | Data diagram generating method and generating system |
| CN104572098A (en) * | 2014-12-30 | 2015-04-29 | 北京奇虎科技有限公司 | Updating method and device of mobile terminal page diagram |
| CN105528218A (en) * | 2015-12-30 | 2016-04-27 | 城云科技（杭州）有限公司 | Data diagram cascaded method and data diagram cascaded system |
| CN108804403A (en) * | 2017-04-28 | 2018-11-13 | 阿里巴巴集团控股有限公司 | The implementation method and device of business graphics |
| CN108492028A (en) * | 2018-03-21 | 2018-09-04 | 徐欣 | Demand data standardized method and standardized system |
Non-Patent Citations (1)
| Title |
|---|
| 路丽华 ; 李敬年 ; .地形图数据库中的数据字典与元数据.测绘通报.2013,(06),全文. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111666277A (en) | 2020-09-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110110174B (en) | Data visualization page generation, monitoring and display method, browser and server | |
| US11106420B2 (en) | Method, device, system and storage medium for information transmission and data processing | |
| CN105335132B (en) | Method, device and system for customizing application program function | |
| US9639516B2 (en) | System and method for express spreadsheet visualization for building information modeling | |
| CN106844019A (en) | Application control method, application program redirect associated configuration method and device | |
| CN111897740B (en) | User interface testing method and device, electronic equipment and computer readable medium | |
| CN111628897B (en) | Intelligent equipment initialization method, device and system | |
| CN111259275B (en) | Data tracking method, device and storage medium | |
| CA2983098A1 (en) | Techniques to manage bookmarks for media files | |
| CN112346761B (en) | Front-end resource online method, device, system and storage medium | |
| CN112819574A (en) | Method, device and storage medium for generating household order | |
| US20230401377A1 (en) | Document creation method and apparatus, and device and storage medium | |
| CN114866805A (en) | Video processing method, device and storage medium | |
| CN104216977A (en) | Time series data search method and device | |
| AU2019232905A1 (en) | Offline briefcase synchronization | |
| CN112114804B (en) | Application program generation method, device and system | |
| CN111736825B (en) | Information display method, device, equipment and storage medium | |
| CN111666277B (en) | Data chart, data source file updating method, device, system and storage medium | |
| US20170131857A1 (en) | Wallpaper processing method and electronic device | |
| CN115718749A (en) | Information processing method, apparatus, device, storage medium, and program product | |
| CN115311051A (en) | Page display method, equipment and storage medium for house with view | |
| CN114189457A (en) | Cloud resource display and processing method, equipment and storage medium | |
| CN114546359A (en) | DSL description file generation method, device, equipment and storage medium | |
| CN110007814B (en) | Session marking method and device | |
| CN114997124A (en) | Table content processing method, device, equipment and storage 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 |