WO2020253584A1 - Chart processing method and data processing method, and apparatuses - Google Patents

Chart processing method and data processing method, and apparatuses Download PDF

Info

Publication number
WO2020253584A1
WO2020253584A1 PCT/CN2020/095288 CN2020095288W WO2020253584A1 WO 2020253584 A1 WO2020253584 A1 WO 2020253584A1 CN 2020095288 W CN2020095288 W CN 2020095288W WO 2020253584 A1 WO2020253584 A1 WO 2020253584A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
chart
attribute information
target
adjustment amount
Prior art date
Application number
PCT/CN2020/095288
Other languages
French (fr)
Chinese (zh)
Inventor
王琛
张文
沈蛟
Original Assignee
阿里巴巴集团控股有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 阿里巴巴集团控股有限公司 filed Critical 阿里巴巴集团控股有限公司
Publication of WO2020253584A1 publication Critical patent/WO2020253584A1/en

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/26Visual data mining; Browsing structured data
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/174Form filling; Merging

Definitions

  • the present invention relates to the field of data visualization, in particular to a chart processing, data processing method and device.
  • the main purpose of data visualization includes the use of graphical objects to express data, to intuitively and clearly express the characteristics of the data and the meaning of the data, making the data easier for users to understand.
  • various suitable graphical object shape elements can be used to present the characteristics or meaning of the data.
  • the generalized chart contains a variety of forms: pie charts, bar charts, line charts, distribution charts combined with coordinates or maps, etc. are all common forms.
  • These data presentation forms usually include at least two dimensions, including an element dimension, which includes and identifies different data elements, and an attribute dimension, which identifies different attributes of data elements.
  • the embodiments of the present invention provide chart processing, data processing methods and devices, which can enhance the function of the data chart and increase the interactivity and applicability of the data chart.
  • the present invention provides the following solutions:
  • a chart processing method including:
  • the target data is changed according to the first adjustment amount, and the target data change result is determined.
  • a data processing method including:
  • a chart processing method including:
  • the second source data is determined.
  • a chart processing device includes:
  • the chart generating unit is used to generate a data chart according to the source data and display the data chart;
  • the first operation option providing unit is used to determine the target data in the data chart and provide corresponding data operation options for the target data
  • An adjustment amount determining unit configured to determine a first adjustment amount for adjusting the target data according to the input information for operating the data operation option
  • the target data changing unit is configured to change the target data according to the first adjustment amount to determine the target data change result.
  • a data processing device includes:
  • the chart establishment unit is configured to generate a data visualization data chart according to the source data, display the data chart and load the correlation between independent variable data and dependent variable data; the data chart includes element information dimensions and attribute information dimensions;
  • the second operation option providing unit is used to determine the independent variable data in the data chart and provide corresponding data operation options for the independent variable data;
  • the independent variable data adjustment unit determines the adjustment amount for adjusting the independent variable data according to the input information for operating the data operation option, and changes the independent variable data according to the adjustment amount;
  • the dependent variable update unit is configured to determine the corresponding dependent variable data that changes with the change of the independent variable data based on the association relationship, and load the changed dependent variable data in the data chart.
  • a chart processing device including:
  • the chart processing unit is configured to generate a data chart according to the first source data and provide data operation options for the data chart; the operation options are used to adjust the target data in the data chart;
  • An adjustment amount processing unit configured to determine an adjustment amount for adjusting the target data according to the input information for operating the data operation option
  • the result processing unit is configured to determine the second source data according to the adjustment amount.
  • a computer system including:
  • One or more processors are One or more processors.
  • a memory associated with the one or more processors where the memory is used to store program instructions, and when the program instructions are read and executed by the one or more processors, perform the following operations:
  • the target data is changed according to the first adjustment amount, and the target data change result is determined.
  • a data chart can be created and displayed based on the source data, the data operation options provided for the target data in the data chart, and the first adjustment amount for adjusting the target data can be determined according to the input information for operating the data operation options; The target data is changed according to the first adjustment amount, and the target data change result is determined.
  • the data chart can not only reflect the characteristics of the source data, but also provide operation options with interactive functions. Users can operate the data objects in the data chart in a more intuitive way through the data operation options, such as graphical elements or values. Making changes can quickly and conveniently view the changed data characteristics in the data chart, enhance the function of the data chart, increase the interactivity and applicability of the data chart, and make the data chart can be used in a wider range of applications.
  • the result of the change to the target data can also be fed back to the source data.
  • the result of the change to the target data is fed back to the source data, which increases the flexibility of the interaction between the source data and the data chart, and provides a way to visualize the data through the chart.
  • the way of manipulating the source data increases the user's ability to manipulate the source data, so that the data chart can not only be used to display the characteristics of the source data, but also the data chart has the potential for wider application.
  • the method can also visualize the source data that has an association relationship between the data, and process the different types of association relationships in each dimension between the data in the established data chart, and the operated target data includes
  • the data has an association relationship with other data
  • it can realize the processing of the associated data while operating the target data, which greatly increases the flexibility and adaptability of data visualization application technology, and enables data visualization and data chart technology With stronger interaction capabilities, it also realizes the display and processing capabilities of relational data. Based on these capabilities, data charts can be applied to a wider range of fields.
  • FIG. 1 is a schematic diagram of an example of a data chart provided by an embodiment of the present application.
  • FIG. 2 is a flowchart of the first method provided by an embodiment of the present application.
  • Fig. 3 is a schematic diagram of a data chart structure provided by an embodiment of the present application.
  • FIG. 4 is a schematic diagram of data operation options provided by an embodiment of the present application.
  • FIG. 5 is a schematic diagram of operation prompt information provided by an embodiment of the present application.
  • FIG. 6 is a schematic diagram of the first association relationship in the data chart provided by the embodiment of the present application.
  • FIG. 7 is a schematic diagram of the first constraint relationship in the data chart provided by the embodiment of the present application.
  • FIG. 8 is a flowchart of a second method provided by an embodiment of the present application.
  • FIG. 9 is a flowchart of a third method provided by an embodiment of the present application.
  • FIG. 10 is a schematic diagram of a first device provided by an embodiment of the present application.
  • FIG. 11 is a schematic diagram of a second device provided by an embodiment of the present application.
  • Figure 12 is a schematic diagram of a third device provided by an embodiment of the present application.
  • Fig. 13 is a schematic diagram of a computer system provided by an embodiment of the present application.
  • the chart established based on the source data can objectively reflect the characteristics or meaning of the data in the source data. For example, a certain form of chart can intuitively show the proportion of each element type, or in another One form of chart can show the distribution of different types of elements in a geographic area, and so on. Among them, various forms of charts are generated according to the data source, and faithfully display the meaning or characteristics of the constituent elements in the data source.
  • the embodiment of the application provides a data chart processing method, which can be applied to the field of data visualization technology.
  • the technical problem to be solved by this method is not only to display the data source, but to realize the visual expression of complex relational data.
  • the interactivity between the chart content and the data source is further solve a number of technical problems on the basis of achieving better expression and interaction.
  • This method can help users express complex data relationship characteristics in a dynamic data design process, and realize interactive operations in visual data, and can vividly reflect the interactive operation process and the data change process.
  • This method can be applied to the technical realization of various project budget design, marketing planning, speech display, data deduction and analysis, etc., and has good application prospects.
  • Data charts In data visualization, data charts are used to intuitively display the characteristics or meaning of the data. In practical applications, data charts are not limited to a narrow two-dimensional table, but can include multiple types of charts, for example , Data charts that are frequently used include pie charts, bar charts, line charts, distribution coordinate charts, distribution charts combined with maps, and so on. As shown in Figure 1, it is a schematic diagram of different types of data charts. In Figure 1, (a) is a pie chart, (b) is a bar chart, and (c) is a line chart. These types of data charts are all Data charts that are often encountered in daily life.
  • the data chart includes n dimensions, including at least two dimensions, namely, the element information dimension and the attribute information dimension.
  • the element information included in the element information dimension can be individual objects, classified objects, etc., such as student A, consumables A, user type B, etc.
  • the attribute information dimension includes attribute information, which can be the physical of the element information object Attributes, statistical attributes, etc., such as height, consumable inventory, and the number of users who have participated in an event.
  • the specific data corresponds to two dimensions. For example, "170cm” corresponds to the element information and attribute information in the two dimensions of "Student A" and "Height". It is easy to understand that this data represents the height of Student A.
  • the data therein for example, for the data of network cable usage "32(m)", the corresponding element information is “network cable”, and the corresponding attribute information is "room A usage”.
  • the attribute information corresponding to the specific data in the data chart should not be limited to the physical attribute of an object, and it can include statistical attributes and is mostly statistical attributes in practical applications. In addition, only by combining all relevant dimensions of the data can we understand the complete meaning of the data.
  • FIG. 2 is a flowchart of a chart processing method provided in Embodiment 1 of this application. As shown in FIG. 2, the method may include the following steps:
  • the source data can be obtained. Based on the source data, a data chart for data visualization can be generated and the data chart can be displayed.
  • a data chart for data visualization can be generated and the data chart can be displayed.
  • This implementation can be used for visualization Data display application scenarios, such as speech display, event data planning and other applications.
  • the source data can be stored on the server, and the server generates a data visualization data chart based on the source data at the request of the client, and sends the data chart to the client.
  • the terminal displays the data chart and provides the corresponding operation interface. After receiving the operation through the operation interface, the adjustment result of the corresponding data is fed back to the server, and the server processes the feedback, such as discarding or saving the modification and upgrading the source data.
  • the data chart can also include a two-dimensional table, which includes element information dimensions and attribute information dimensions.
  • the element information dimensions and attribute information dimensions respectively correspond to the rows and columns (or: columns and rows) of the two-dimensional table, that is, the element information dimensions correspond to the two-dimensional The row/column of the table, and the attribute information dimension corresponds to the column/row of the two-dimensional table.
  • a composite chart can include multiple different types of sub-charts, each of which is independent of each other, but they are all used to represent the same data source, or it can be a combination of multiple different forms of data charts to visualize the data source.
  • Figure 3 which is an example of the data chart provided in Example 1 of this application.
  • This chart is a composite chart that incorporates data visualization forms such as histograms and two-dimensional tables. That is, the source data is presented in a two-dimensional table as a whole.
  • the specific numerical representation of the data also incorporates the representation method of the histogram, making the data visualization of the data more intuitive and easy to understand.
  • the data chart in Figure 3 is a data chart about the expected planning of activities. These include element information dimensions and attribute information dimensions.
  • the data chart exemplarily corresponds to element information dimensions in columns and attribute information dimensions in rows. In practical applications, this correspondence relationship can be interchanged.
  • the element information dimension includes user type information, as shown in the first column of the data chart, such as "interest class A" type users and "active C” type users.
  • the attribute information dimension includes the attribute information of "population target percentage" and "customer unit price” shown in the first row of the data chart.
  • S202 Determine target data in the data chart, and provide corresponding data operation options for the target data
  • the data chart processing method provided in the embodiment of this application can not only generate and display the data chart based on the source data, but also can enhance the data
  • the interactivity of the chart can provide the user with the ability to interact with the data chart while displaying the data chart of the source data. For example, it can be the ability to adjust and change the data items in the data chart, so that the data chart is The scope of application is greatly increased.
  • the target data in the data chart can be determined, and corresponding data operation options can be provided for the target data.
  • the target data may be data that needs to be adjusted during the interaction process.
  • the target data may correspond to a target element information and a target attribute information item.
  • the target data can be determined according to the user's operation. For example, the data to be operated or the data corresponding to the graphic element is determined as the target data in the displayed data chart.
  • the specific realization provides corresponding data operation options for the target data, which can be realized in different ways according to different practical applications and different data chart types.
  • the focus is on reflecting the proportion of different data.
  • the proportion of each data is reflected in a different sector area.
  • the target data also corresponds to a sector.
  • the data chart of the pie chart can be provided The operation option for the proportion of the target sector, through which the angle or area of the target data sector can be adjusted.
  • a histogram such as the histogram shown in (b) in Figure 1
  • the height of the column in the histogram has a corresponding proportional relationship with the value of the data, and operation options for adjusting the height of the corresponding column of the target data can be provided.
  • providing corresponding data operation options for the target data can include two types, one is drag type, such as draggable graphic elements, so as to be operated by devices such as a mouse, and the other can be
  • drag type such as draggable graphic elements
  • an input box can be provided to receive the value input by the user, so that the precise adjustment value can be input through the keyboard.
  • the operation option can be a drag handle component, which can be used to drag graphic elements, or an input box component, used to input precise values.
  • the drag-type data operation options and the input-type data operation options can be implemented.
  • FIG 4 Examples of the two options can be seen in Figure 4, where 4(a) in Figure 4 is for the adjustable
  • the data provides drag-type operation options, that is, the circular handle behind the column of the histogram. The circular handle can be dragged to the left or right to change the corresponding data and the bar graph elements.
  • an input-type data operation option can also be provided. The input-type data operation option can receive the amount of user input, and then the adjustment amount to the target data can be determined according to the amount. .
  • S203 Determine a first adjustment amount for adjusting the target data according to the input information for operating the data operation option
  • the first adjustment amount for adjusting the target data can be determined according to the input information generated by operating the data operation option, for example, according to The input information generated by the drag operation of the drag handle assembly determines the first adjustment amount for adjusting the target data; or the first adjustment amount for adjusting the target data may be determined according to the input information input in the input box assembly One adjustment amount.
  • the first adjustment amount may be an increment for adjusting the target data, or may be a final target amount for adjusting the target data.
  • the target data may be changed according to the first adjustment amount to determine the target data change result.
  • the change result of the target data can be displayed in the data chart in real time.
  • the change of the target data can be real-time.
  • the data chart can be refreshed to display the determined target data change result in the data chart.
  • Most of the data in the data chart corresponds to corresponding graphic elements. Obviously, the result of the change of the target data can also be reflected by the change of the graphic elements in the chart.
  • the result of the change of the target data is reflected in the data chart, and the result of the change of the target data can also be fed back to the source data. For example, after the user confirms to save the changes in the data chart, the changed data can be saved to the data source.
  • this method can feed back the result of the change to the target data to the source data, thereby realizing that by providing operation options in the data chart, the target in the chart can be changed through the operation options Data (in some cases, this process is more similar to the change of graphic elements for the user), and then the change of the target data is provided back to the source data in a way, thereby increasing the flexibility of the interaction between the source data and the data chart It also provides users with a path to intuitively manipulate source data through data charts, increasing the interaction of data chart applications.
  • the source data is usually stored in the form of a database, and the results of changes to the target data are fed back to the source data, which is equivalent to updating the database where the source data is located, and the database management system can proceed according to its own strategy. Update, for example, you can save the object data of the change operation, save the data table mirror and so on.
  • the method provided in the embodiment of the present application can also process the source data that has an association relationship between the data.
  • the association relationship of the data in the source data can be saved together with the source data.
  • the description information of the corresponding association relationship of the source data can be loaded.
  • different types of association relationships can be shown in different dimensions.
  • the first association relationship can be shown in the attribute information dimension.
  • the attribute information dimension can include at least two association attributes.
  • FIG. 6 is a schematic diagram of the first association relationship in the attribute information dimension in the data chart.
  • the data chart in Figure 6 includes several attribute information in the attribute information dimension, and there is a first association relationship between each attribute information, for example,
  • the population conversion rate is at the target amount, and there is a first correlation between the population conversion rate and the crowd water storage target, and the first correlation is actually a positive correlation. Describing this association relationship from the perspective of attribute information is actually a logical description.
  • the reflection on the data can be the association relationship between data 610, data 611, and data 612 in Figure 6, where when data 610 is downregulated At this time, the data 611 and the data 612 will be adjusted downward accordingly. Similarly, when the data 620 is adjusted upward, the data 621 and the data 622 will also be adjusted upward along with the data 620.
  • the first association relationship is a logical description for the attribute information, while for the data under the attribute information, it becomes a quantitative description, that is, a functional relationship.
  • data 610 is used as an independent variable
  • data 611 is used as a dependent variable.
  • the target data is data under associative attribute information
  • the target data it is also necessary to determine the adjustment result of the associated data, where the associated data refers to the first association with the target data
  • the relational data and the target data correspond to the same target element information.
  • the associated data may include peer data 611 or data 612.
  • each data represents the corresponding proportion of the population classification, and the data in this column Specifically, it is a percentage value, and the sum of the various values is required to be 100%.
  • This type of data corresponds to a kind of constraint attribute information in the attribute information dimension, that is, the attribute information dimension includes constraint attribute information, where some or all of the data under the same constraint attribute information satisfies the first constraint relationship, as shown in Figure 7
  • the "population target proportion" is a restricted attribute information, and the data under it must meet the constraint condition that the total sum is 100%.
  • an adjustment response data can be determined under the constraint attribute information, and the second adjustment amount of the adjustment response data can be determined based on the first constraint relationship, where The second adjustment amount is used to change the adjustment response data, so that after the target data and the adjustment response data are changed, the first constraint relationship between the related data under the constraint attribute information is still maintained.
  • the target data to be adjusted (reduced) is 710
  • the sum of the data in the column in which it is located still satisfies the constraint condition that the sum is 100% after the adjustment. It can be in this column, that is, in this column.
  • the adjustment response data 720 is changed according to the second adjustment amount, so that after the target data and the adjustment response data are changed, the data in the column still meets the constraint condition that the sum is 100% .
  • the data item 710 and the data item 711, and the data item 720 and the data item 721 are also affected by the first association relationship.
  • the data item 710 is reduced, the data item 711 is affected according to the first association relationship. It also decreases, and the data item 721 increases as the data item 720 increases.
  • the aforementioned association relationship is more similar to a functional relationship
  • the first constraint relationship is a restriction on the sum of a set of data, the ratio of data to data, and the maximum value of data.
  • the first association relationship and the first constraint relationship may be determined by the user, or may be calculated in the machine learning of the data.
  • the constraint relationship of each data under the constraint attribute information can be objectively formed. For example, when a group of people is classified, the total proportion of each category is naturally 100%, which is in line with objective logic and user cognition constraints. When machine learning is performed on the data to obtain source data, such as when generating attribute information of component proportions, the underlying data will naturally require a sum of 100%. When adjusting the classified proportion data in the corresponding data chart, corresponding constraints must be made so that the adjusted data still conforms to the objective logic and the data adjustment operation smoothly passes the verification of the application program. Of course, this constraint relationship can also be specified, for example, formulated by a data administrator. The first constraint condition can also be saved with the source data.
  • the description information of the first constraint condition corresponding to the source data can be loaded.
  • the first constraint relationship can include different types of constraint relationships, and the constraint relationship can also be used as a check condition for data changes in visualization applications.
  • the first constraint relationship can include one of the following constraint relationship examples:
  • the sum of the data items restricted by the first constraint relationship is a fixed value
  • the proportion of data items restricted by the first constraint relationship is a fixed value
  • the sum of the data items restricted by the first constraint relationship does not exceed the preset maximum allowable value.
  • the target data is data under constrained attribute information
  • there are multiple ways to determine adjustment response data under the constrained attribute information such as specifying data in a certain row/column as adjustment response data, or adding One row/column
  • the data of the constraint attribute information is determined as the adjustment response data. That is, when the target data is the data under the constraint attribute information, the adjustment response data can be determined according to the specified data item under the constraint attribute information; or, when the target data is the data under the constraint attribute information, A new data item is created under the constraint attribute information, and the newly created data item is determined as the adjustment response data.
  • the adjusted target data is displayed in the data chart according to the change result.
  • the display of the adjusted target data and the adjusted associated data can be synchronized and real-time.
  • the target data is adjusted by dragging the handle, the change of the target data and the associated data can be linear and real-time changes.
  • the attribute information dimension of a data chart may include two or more constrained attribute information, and part or all of the data under each constrained attribute information satisfies the corresponding constraint relationship of the constrained attribute information.
  • the corresponding adjustment response data can be adjusted according to the corresponding constraint relationship, so that the adjusted data under each constraint attribute information still meets the corresponding requirements. The constraint relationship.
  • the adjustment response data in some applications it can only be used as a buffer of the adjustment process, without paying attention to its changes and other data changes caused by the adjustment response data, but in some applications this is not the case.
  • the adjustment response data itself, or other data that changes due to changes in the adjustment response data may also have important influence or data that is actually concerned, so it can be highlighted in the data chart Adjust the degree of change of the response data, or finally offset the offset of the adjustment response data through further adjustments.
  • the initial value of the adjustment response data can be determined, and the initial value of the adjustment response data can be stored in the cache. After completing the adjustment of the target data once, determine the offset of the adjustment response data change.
  • One of the significances of determining the offset of the corresponding data change is that the offset can be reflected in the data chart, so that the user can understand the changes in the adjustment response data in real time during the process of adjusting the target data, especially when performing multiple changes in sequence. In the case of adjustment of target data, the changes in response data can be clearly adjusted.
  • a zero-return check is performed for applications that need to restore the adjustment response data after the adjustment is completed. If it is determined that a zero-return check is required, check whether the offset is zeroed after the adjustment of the current target data. Of course, in the case where the offset needs to be reset to zero but it is not actually reset, the data adjustment can be continued until the offset in response to the data change is reset to zero.
  • the method provided in the first embodiment of the present application can be applied to a variety of application scenarios, for example, it can be applied to various project budget design, marketing planning, speech display, data deduction and analysis, etc.
  • the information and data contained in the generated data chart may be different.
  • the element information in the element information dimension of the data chart may include crowd classification information.
  • a specific example can be the classification information of each crowd obtained by classifying the crowd types in the data chart in FIG. 3.
  • the source data of the data chart can also be different according to actual applications.
  • the source data can include activity plan data
  • the created data chart includes the activity plan chart.
  • the activity plan data can be used to target Plan the implementation of the activity, apply the processing method of this application to directly adjust the data of the activity plan chart, and obtain a clear and intuitive adjustment result, and finally achieve a satisfactory result of the activity data planning.
  • the data chart can be a composite data chart containing multiple sub-charts, where the sub-charts are related in element information dimensions and/or attribute information dimensions.
  • the attribute information in sub-chart A can be the attribute of sub-chart B A part of the information, or the element information in the chart A may be a further subdivision type of the element information of the subchart B, that is, the element information and/or attribute information included in the subchart is a subdivision of another subchart.
  • the above provides a detailed introduction to the chart processing method provided by the embodiment of the application.
  • the method can create and display a data chart based on the source data, provide data operation options for the target data in the data chart, and operate according to the data operation options.
  • the data chart can not only reflect the characteristics of the source data, but also provide operation options with interactive functions. Users can operate the data objects in the data chart in a more intuitive way through the data operation options, such as graphical elements or values. Making changes can quickly and conveniently view the changed data characteristics in the data chart, which enhances the function of the data chart and greatly increases the interactivity of the data chart.
  • the result of the change to the target data can also be fed back to the source data.
  • the result of the change to the target data is fed back to the source data, which increases the flexibility of the interaction between the source data and the data chart, and provides a way to visualize the data through the chart.
  • the way of manipulating the source data increases the user's ability to manipulate the source data, so that the data chart can not only be used to display the characteristics of the source data, but also the data chart has the potential for wider application.
  • the method can also visualize the source data that has an association relationship between the data, and process different types of association relationships in each dimension between the data in the established data chart.
  • the target data includes When the data has an association relationship with other data, it can realize the processing of the associated data while operating the target data, which greatly increases the flexibility and adaptability of data visualization application technology, and enables data visualization and data chart technology With stronger interaction capabilities, it also realizes the display and processing capabilities of relational data. Based on these capabilities, data charts can be applied to a wider range of fields.
  • the second embodiment of the application provides a data processing method. Please refer to FIG. 8, which is a flowchart of the data experiment method provided in the second embodiment of the application.
  • the method may include the following steps:
  • S801 Generate a data visualization data chart according to the source data, display the data chart and load the correlation relationship between independent variable data and dependent variable data; the data chart includes element information dimensions and attribute information dimensions;
  • Data experiments can be deduced based on the source data used in the experiment to observe the changes in the data of interest; it can also adjust different target data to make the data of interest reach the ideal value, so as to obtain the optimal solution data; or It is used to show the dynamic data change process and obtain a better presentation effect.
  • This solution is based on the chart processing method in Example 1, especially the method content of processing relational source data (that is, the data in the source data has a specific type of association relationship in a specific dimension), and applies the data chart processing method Method for data experiment.
  • the source data can be determined, and data charts for data visualization can be generated based on the source data, and the data charts can be displayed.
  • the source data contains data with an association relationship, such as data with a functional relationship, including independent variable data and dependent variable data.
  • the association relationship of the data can be saved with the source data and loaded when the data chart is created.
  • the created data chart can include element information dimensions and attribute information dimensions.
  • element information dimension and the attribute information dimension please refer to the description in the first embodiment, which will not be repeated here.
  • data relationships can include multiple types, and data relationships can be crossed.
  • the same independent variable data can be used as independent variable data of different functional relationships at the same time.
  • the independent variable data and the dependent variable data can correspond to different attribute information in the attribute information dimension.
  • the independent variable data can correspond to the attribute information of "population target proportion”
  • the dependent variable data can correspond to the attribute information of "total sales”.
  • the independent variable data in the data chart can be determined, and the corresponding data operation options can be provided for the independent variable data.
  • the operation options can be used to adjust the respective variable data to change the independent variable data based on the correlation between the independent variable data and the dependent variable data.
  • Dependent variable data, and dependent variable data is usually data that is of interest in data experiments, or data that is expected to achieve a certain goal.
  • S803 Determine an adjustment amount for adjusting the independent variable data according to the input information for operating the data operation option, and change the independent variable data according to the adjustment amount;
  • step S203 For the content of this step, please refer to step S203 in the first embodiment.
  • the first adjustment value for adjusting the target data is determined.
  • the similar specific implementation is similar and will not be repeated here.
  • the adjustment amount to adjust the independent variable data is determined, and after the independent variable data is changed according to the adjustment amount, the corresponding dependent variable data that changes with the independent variable data can be determined based on the association relationship, and Load the changed dependent variable data in the data chart to observe the change of the dependent variable, or determine the state of the independent variable data after the dependent variable data reaches the ideal value.
  • the attribute information dimension can include constraint attribute information, and some or all of the data under the same constraint attribute information meets the second constraint relationship; when the independent variable data is data under constraint attribute information, under the constraint attribute information Determine an adjustment response data; when changing the independent variable data, adjust the adjustment response data based on the second constraint relationship, so that after the independent variable data is changed, the relationship between the related data under the constraint attribute information is maintained
  • the second constraint relationship refer to the data processing method for the first constraint relationship in the first embodiment.
  • the data experiment method is based on the data chart in the first embodiment and the processing method of the data chart, and part or all of the features of the data processing method in the first embodiment can be applied approximately. Similarly, in this data experiment method, the data changes in the data chart can be fed back to the source data.
  • the emission of harmful gases cannot exceed a certain value.
  • the maximum allowable value of the emission can be locked to observe or determine the change of the gas emission within the maximum value during the adjustment of other items.
  • a lock operation option to lock dependent variable data can be provided.
  • the limit value of the dependent variable data is locked as the target value.
  • the target value can be the maximum allowable value or the minimum allowable value Wait.
  • the data processing method can be applied to the processing method of event planning data.
  • data visualization data charts can be generated according to the event source data, display the data charts and load the adjustment item data and planning target data. Association relationship, determine the target adjustment item data in the data chart, provide corresponding data operation options for the target adjustment item data; according to the input information for operating the data operation options, determine the adjustment amount to adjust the target adjustment item data, and according to The adjustment amount change target adjustment item data, based on the association relationship, determines the corresponding planning target data that changes with the adjustment item data change, and updates the planning target data in the data chart.
  • the interactive ability of the data chart can be used when planning data, and the processing capacity of the relational data added in the data chart can be used, which is intuitive and fast.
  • Tools for event planning data processing can intuitively and quickly obtain the processing results of data event planning, use data charts to realize deduction based on event source data, and observe the changes in planning target data; or through adjustment of different adjustment item data , To make the planning target data concerned reach the ideal value, so as to obtain the optimal activity planning data solution; or to show the dynamic activity planning data change process to obtain a better demonstration effect.
  • the activities can be various types of social activities, economic activities, etc., such as marketing activities, architectural planning activities and so on.
  • the second embodiment of the application provides a data processing method, which can generate and display data charts for data visualization based on source data, load the correlation between independent variable data and dependent variable data; determine the independent variable data in the data chart , Provide corresponding data operation options for the independent variable data; determine the adjustment amount for adjusting the independent variable data according to the input information for operating the data operation options, and change the independent variable data according to the adjustment amount; based on the association relationship , Determine the corresponding dependent variable data that changes as the independent variable data changes, and load the changed dependent variable data in the data chart.
  • the data experiment method uses the added interactive capabilities for data charts and the increased processing capabilities of relational data in the data charts, which can use the intuitive and fast tool of data charts
  • Carrying out data experiments can intuitively and quickly obtain the processing results of the data experiments, using data charts to realize deduction based on the source data, and observe the changes of the data concerned; or through the adjustment of different target data, the data of interest can be reached Ideal value, so as to obtain the optimal solution data; or used to show the dynamic data change process, obtain a better presentation effect, etc.
  • the third embodiment of the present application provides a chart processing method. Please refer to FIG. 9, which is a flowchart of the data processing method provided in the third embodiment of the present application.
  • the method may include the following steps:
  • S901 Generate a data chart according to the first source data, and provide data operation options for the data chart; the operation options are used to adjust target data in the data chart;
  • a data chart for data visualization can be generated based on the first source data, and data operation options can be provided for the data chart; the data operation options can be operation options in a program that displays the data chart, such as a sliding input operation handle, Or data input components, etc., operation options can be used to adjust the target data in the data chart.
  • the forms of data charts can be various, such as pie charts, line charts, histograms, coordinate distribution charts, etc., which can include element information dimensions and attribute information dimensions.
  • the data chart can also include a two-dimensional table, which includes element information dimensions and attribute information dimensions, which correspond to the rows and columns (or: columns and rows) of the two-dimensional table respectively, that is, the element information dimensions correspond to the rows/columns of the two-dimensional table, and The attribute information dimension corresponds to the column/row of the two-dimensional table.
  • element information dimensions and attribute information dimensions which correspond to the rows and columns (or: columns and rows) of the two-dimensional table respectively, that is, the element information dimensions correspond to the rows/columns of the two-dimensional table, and
  • the attribute information dimension corresponds to the column/row of the two-dimensional table.
  • S902 Determine an adjustment amount for adjusting the target data according to the input information for operating the data operation option
  • While displaying the data chart of the first source data it provides users with the ability to operate and interact with the data chart.
  • the target data is adjusted through the data operation options, which can be adjusted according to the data operation options
  • the input information generated by the operation determines the adjustment amount to adjust the target data.
  • the adjustment amount to adjust the target data can be determined according to the input information generated by the drag operation of the drag handle component; or it can be determined according to the input box component Enter the input information to determine the adjustment amount to adjust the target data.
  • the adjustment amount may be an increment for adjusting the target data, or may be the final target amount for adjusting the target data.
  • S903 Determine the second source data according to the adjustment amount.
  • the target data can be changed according to the adjustment amount.
  • the change result of the target data can be displayed in the data chart in real time.
  • the change of the target data can be real-time.
  • the data chart can be refreshed to display the determined target data change result in the data chart.
  • the changed target data can be determined according to the adjustment amount, as well as data having a specific relationship with the target data, for example, data having a first association relationship with the target data or a first constraint relationship, and can be automatically adjusted according to the specific relationship.
  • the second source data can be determined according to the adjustment amount.
  • the second source data is different from the first source data. For example, it may be obtained by adjusting the adjustment amount based on the first source data.
  • the chart processing method can generate a data chart according to the first source data, and provide data operation options for the data chart; the operation options can be used to perform operations on the target data in the data chart. Adjustment; Determine the adjustment amount for adjusting the target data according to the input information for operating the data operation option; determine the second source data according to the adjustment amount. Therefore, the data chart can not only reflect the characteristics of the source data, but also provide operation options with interactive functions. The user can operate the data objects in the data chart through the data operation options in a more intuitive way, such as graphical elements or The value is changed, and the changed data characteristics can be quickly and conveniently viewed in the data chart.
  • the first source data can be directly adjusted to obtain the second source data, which enhances the function of the data chart , Which greatly increases the interactivity of the data chart.
  • the data chart processing device may include:
  • the chart generating unit 1010 is configured to generate a data chart based on source data and display the data chart; the data chart may include element information dimensions and attribute information dimensions;
  • the first operation option providing unit 1020 is used to determine the target data in the data chart and provide corresponding data operation options for the target data; wherein the target data corresponds to a target element information and a target attribute information;
  • the adjustment amount determining unit 1030 is configured to determine the first adjustment amount for adjusting the target data according to the input information for operating the data operation option;
  • the target data changing unit 1040 is configured to change the target data according to the first adjustment amount, and determine a target data change result.
  • the data chart may include an element information dimension and an attribute information dimension;
  • the attribute information dimension includes at least two associative attribute information, and a group of the associative attribute information is related by a first association relationship;
  • the device further includes:
  • the first association relationship loading unit is configured to load the first association relationship.
  • the device further includes:
  • the associated data adjustment unit is configured to determine an adjustment result of the associated data if the target data is data under the associated attribute information; wherein the associated data is data that has a first association relationship with the target data, and It corresponds to the same target element information as the target data.
  • the device may also include:
  • the target data refresh unit is used to display the adjusted target data in the data chart according to the change result.
  • the data chart includes element information dimensions and attribute information dimensions; wherein the attribute information dimension includes constraint attribute information, and some or all of the data under the same constraint attribute information satisfies the first constraint relationship; the device may further include:
  • An adjustment response data determining unit configured to determine an adjustment response data under the restriction attribute information when the target data is the data under the restriction attribute information
  • the second adjustment amount determining unit is configured to determine the second adjustment amount of the adjustment response data based on the first constraint relationship; the second adjustment amount is used to change the adjustment response data to change the target data and the adjustment response data After that, the first constraint relationship between related data under the constraint attribute information is maintained.
  • the first constraint relationship may include:
  • the sum of the data items restricted by the first constraint relationship is a fixed value
  • the proportion of data items restricted by the first constraint relationship is a fixed value
  • an adjustment response data is determined under the restriction attribute information, and the adjustment response data can be determined according to a designated data item under the restriction attribute information.
  • a new data item can be created under the restriction attribute information, and the newly created data item can be determined as the adjustment response data.
  • the device may further include:
  • the initial value determining unit is used to determine the initial value of the adjustment response data
  • the offset determination unit is used to determine the offset of the adjustment response to the data change after completing the adjustment of the target data once.
  • the device may further include:
  • the zero return determination unit is used to determine whether to perform a zero return check on the offset of the adjustment response data change; and, the zero return check unit is used to check whether the offset is current if it is determined that a zero return check is required Return to zero after adjustment of the target data.
  • the attribute information dimension may include at least two constrained attribute information, and part or all of the data under each constrained attribute information satisfies the corresponding constraint relationship of the constrained attribute information.
  • the data chart may include a two-dimensional table; the element information dimension of the two-dimensional table corresponds to the row/column of the two-dimensional table; the attribute information dimension of the two-dimensional table corresponds to the column/row of the two-dimensional table.
  • the operation option may include a drag handle component, and the first adjustment amount for adjusting the target data is determined according to the input information for operating the data operation option, and may be based on the input information generated by the drag operation on the drag handle component, Determine the first adjustment amount for adjusting the target data.
  • the operation option may also be an input box component, and the first adjustment amount for adjusting the target data may be determined according to the input information entered in the input box component.
  • the data chart processing device may further include:
  • the change result feedback unit is configured to feed back the change result of the target data to the source data.
  • the data chart includes the element information dimension, and the element information in the element information dimension may include crowd classification information.
  • the source data may include activity plan data.
  • the data chart may include a composite data chart containing multiple sub-charts; wherein the sub-charts are related in the element information dimension and/or the attribute information dimension.
  • the sub-charts are related in the element information dimension and/or the attribute information dimension, and the element information and/or attribute information included in the sub-chart may be a subdivision of another sub-graph.
  • the data experiment device may include:
  • the chart establishing unit 1110 is configured to generate a data visualization data chart according to the source data, display the data chart and load the correlation between independent variable data and dependent variable data; the data chart includes element information dimensions and attribute information dimensions;
  • the second operation option providing unit 1120 is configured to determine the independent variable data in the data chart, and provide corresponding data operation options for the independent variable data;
  • the independent variable data adjustment unit 1130 determines the adjustment amount for adjusting the independent variable data according to the input information for operating the data operation option, and changes the independent variable data according to the adjustment amount;
  • the dependent variable data update unit 1140 is configured to determine corresponding dependent variable data that changes with the change of the independent variable data based on the association relationship, and load the changed dependent variable data in the data chart.
  • FIG. 12 it is a schematic diagram of the processing device for the event planning data.
  • the processing device for the event planning data may include:
  • the chart processing unit 1210 is configured to generate a data chart according to the first source data and provide data operation options for the data chart; the operation options are used to adjust the target data in the data chart;
  • the adjustment amount processing unit 1220 is configured to determine an adjustment amount for adjusting the target data according to the input information for operating the data operation option;
  • the result processing unit 1230 is configured to determine the second source data according to the adjustment amount.
  • the embodiment of the present application also provides a computer system, including:
  • One or more processors are One or more processors.
  • a memory associated with the one or more processors where the memory is used to store program instructions, and when the program instructions are read and executed by the one or more processors, perform the following operations:
  • the data chart includes element information dimensions and attribute information dimensions;
  • the target data corresponds to a target element information and a target attribute information
  • the target data is changed according to the first adjustment amount, and the target data change result is determined.
  • FIG. 13 exemplarily shows the architecture of the computer system, which may specifically include a processor 1310, a video display adapter 1311, a disk drive 1312, an input/output interface 1313, a network interface 1314, and a memory 1320.
  • the processor 1310, the video display adapter 1311, the disk drive 1312, the input/output interface 1313, the network interface 1314, and the memory 1320 may be communicatively connected through the communication bus 1330.
  • the processor 1310 may be implemented by a general CPU (Central Processing Unit, central processing unit), microprocessor, application specific integrated circuit (Application Specific Integrated Circuit, ASIC), or one or more integrated circuits. Perform relevant procedures to realize the technical solutions provided in this application.
  • CPU Central Processing Unit
  • microprocessor microprocessor
  • ASIC Application Specific Integrated Circuit
  • the memory 1320 can be implemented in the form of ROM (Read Only Memory), RAM (Random Access Memory, random access memory), static storage device, dynamic storage device, etc.
  • the memory 1320 may store an operating system 1321 for controlling the operation of the computer system 1300 and a basic input output system BIOS 1322 for controlling the low-level operation of the computer system 1300.
  • web browser 1323, data storage management system 1324, and icon font processing system 1325 can also be stored.
  • the aforementioned icon font processing system 1325 may be an application program that specifically implements the foregoing steps in the embodiment of the present application. In short, when the technical solution provided by the present application is implemented through software or firmware, the relevant program code is stored in the memory 1320 and is called and executed by the processor 1310.
  • the input/output interface 1313 is used to connect an input/output module to realize information input and output.
  • the input/output/module can be configured in the device as a component (not shown in the figure), or can be connected to the device to provide corresponding functions.
  • the input device may include a keyboard, a mouse, a touch screen, a microphone, various sensors, etc.
  • an output device may include a display, a speaker, a vibrator, an indicator light, and the like.
  • the network interface 1314 is used to connect a communication module (not shown in the figure) to realize the communication interaction between the device and other devices.
  • the communication module can realize communication through wired means (such as USB, network cable, etc.), or through wireless means (such as mobile network, WIFI, Bluetooth, etc.).
  • the bus 1330 includes a path for transmitting information between various components of the device (such as the processor 1310, the video display adapter 1311, the disk drive 1312, the input/output interface 1313, the network interface 1314, and the memory 1320).
  • various components of the device such as the processor 1310, the video display adapter 1311, the disk drive 1312, the input/output interface 1313, the network interface 1314, and the memory 1320.
  • the computer system 1300 can also obtain information about specific receiving conditions from the virtual resource object receiving condition information database 1341 for condition judgment, and so on.
  • the above device only shows the processor 1310, the video display adapter 1311, the disk drive 1312, the input/output interface 1313, the network interface 1314, the memory 1320, the bus 1330, etc., in the specific implementation process, the The device may also include other components necessary for normal operation.
  • the above-mentioned device may also include only the components necessary for implementing the solution of the present application, and not necessarily all the components shown in the figure.

Abstract

Disclosed are a chart processing method and a data processing method, and apparatuses. The chart processing method comprises: generating a data chart according to source data, and displaying the data chart; determining target data in the data chart, and providing corresponding data operation options for the target data; determining, according to input information for operating the data operation options, a first adjustment amount by which the target data is adjusted; and changing the target data according to the first adjustment amount, and determining a target data change result. By means of the method, the functioning of the data chart can be enhanced, and the interactivity and applicability of the data chart can be increased, such that the data chart can be applied in a wider range of applications.

Description

图表的处理、数据处理方法及装置Chart processing, data processing method and device
本申请要求2019年06月18日递交的申请号为201910528180.3、发明名称为“图表的处理、数据处理方法及装置”的中国专利申请的优先权,其全部内容通过引用结合在本申请中。This application claims the priority of the Chinese patent application filed on June 18, 2019, with the application number 201910528180.3 and the invention title "Chart processing, data processing method and device", the entire content of which is incorporated into this application by reference.
技术领域Technical field
本发明涉及数据可视化领域,特别涉及一种图表的处理、数据处理方法及装置。The present invention relates to the field of data visualization, in particular to a chart processing, data processing method and device.
背景技术Background technique
数据可视化的主要目的包括使用图形化的对象表达数据,以直观清晰的表现数据的特征和数据所承载意义,使得数据更加易于用户进行理解。在进行图形化的数据可视化时,可以使用各种适合的图形化对象的形状元素来呈现数据的特征或意义,例如当获取到实际的数据后,可以将数据的特征或意义以图表的形式呈现出来。广义的图表所包含的形式多种多样:饼状图,柱状图,折线图,结合坐标或地图的分布图等等都是很常见的形式。在这些数据呈现形式中,通常至少包括两个维度,其中通常包括一个元素维度,其包括和标识不同的数据元素;以及一个属性维度,以标识数据元素所具有的不同属性。尽管在一些表达方式中,维度的体现并不是那么明显,例如在饼状图这种形式中,人们在使用时通常更加关心各组成部分的占比,但实际上它依然包括了元素维度以及各元素组成的占比这一属性所确定的维度。图表中各维度中所包含的信息组成了一个信息集合。The main purpose of data visualization includes the use of graphical objects to express data, to intuitively and clearly express the characteristics of the data and the meaning of the data, making the data easier for users to understand. When performing graphical data visualization, various suitable graphical object shape elements can be used to present the characteristics or meaning of the data. For example, when the actual data is obtained, the characteristics or meaning of the data can be presented in the form of a chart come out. The generalized chart contains a variety of forms: pie charts, bar charts, line charts, distribution charts combined with coordinates or maps, etc. are all common forms. These data presentation forms usually include at least two dimensions, including an element dimension, which includes and identifies different data elements, and an attribute dimension, which identifies different attributes of data elements. Although in some expressions, the manifestation of dimensions is not so obvious. For example, in the form of pie chart, people usually pay more attention to the proportion of each component when using it, but in fact it still includes the element dimension and each The dimension determined by the attribute of element composition. The information contained in each dimension in the chart forms an information set.
在一些实际应用中,随着数据源的数据量以及数据的复杂度的增加,在以图表等方式实现数据可视化任务的要求也在不断提高,例如在图表中需要表示的数据元素的属性信息类型在不断增加,在进行数据可视化时就需要考虑对多种元素数据属性进行合理有效的表达;在不同的数据元素或者数据元素属性之间具有一定的关联关系时,在某些应用环境下还需要将元素或属性之间的这种关联关系表达出来,等等,数据可视化任务的一些变化趋势使数据可视化技术方法需要满足一些新的需求,对于数据可视化中数据特征的表达以及处理都提出了新的挑战,其中,提高数据可视化的交互性和灵活性,是需要本领域技术人员解决的问题。In some practical applications, as the amount of data in the data source and the complexity of the data increase, the requirements for data visualization tasks in the form of charts and other methods are also increasing, such as the attribute information type of the data element that needs to be represented in the chart Increasingly, it is necessary to consider the reasonable and effective expression of multiple element data attributes when performing data visualization; when there is a certain association relationship between different data elements or data element attributes, it is also necessary in some application environments To express this association relationship between elements or attributes, etc., some changing trends in data visualization tasks make data visualization techniques and methods need to meet some new requirements, and new expressions and processing of data characteristics in data visualization are proposed. Among them, improving the interactivity and flexibility of data visualization is a problem that needs to be solved by those skilled in the art.
发明内容Summary of the invention
本发明实施例提供了图表的处理、数据处理方法及装置,能够增强数据图表的功能 作用,增加数据图表的交互性和应用性。The embodiments of the present invention provide chart processing, data processing methods and devices, which can enhance the function of the data chart and increase the interactivity and applicability of the data chart.
本发明提供了如下方案:The present invention provides the following solutions:
一种图表的处理方法,包括:A chart processing method, including:
根据源数据生成数据图表,并展示所述数据图表;Generate a data chart according to the source data, and display the data chart;
确定所述数据图表中的目标数据,为所述目标数据提供相应的数据操作选项;Determine the target data in the data chart, and provide corresponding data operation options for the target data;
根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的第一调节量;Determine the first adjustment amount for adjusting the target data according to the input information for operating the data operation option;
根据所述第一调节量变更所述目标数据,确定目标数据变更结果。The target data is changed according to the first adjustment amount, and the target data change result is determined.
一种数据处理方法,包括:A data processing method, including:
根据源数据生成数据可视化的数据图表,展示所述数据图表并加载其中的自变量数据与因变量数据的关联关系;所述数据图表包括元素信息维度以及属性信息维度;Generate a data visualization data chart according to the source data, display the data chart and load the association relationship between independent variable data and dependent variable data; the data chart includes element information dimensions and attribute information dimensions;
确定所述数据图表中的自变量数据,为所述自变量数据提供相应的数据操作选项;Determine the independent variable data in the data chart, and provide corresponding data operation options for the independent variable data;
根据对所述数据操作选项进行操作的输入信息,确定对所述自变量数据进行调节的调节量,并根据所述调节量变更所述自变量数据;Determining an adjustment amount for adjusting the independent variable data according to the input information for operating the data operation option, and changing the independent variable data according to the adjustment amount;
基于所述关联关系,确定随着所述自变量数据变更而变化的相应的因变量数据,并在所述数据图表中加载变更后的因变量数据。Based on the association relationship, determine the corresponding dependent variable data that changes with the change of the independent variable data, and load the changed dependent variable data in the data chart.
一种图表处理方法,包括:A chart processing method, including:
根据第一源数据生成数据图表,并为所述数据图表提供数据操作选项;所述操作选项用于对所述数据图表中的目标数据进行调节;Generate a data chart according to the first source data, and provide data operation options for the data chart; the operation options are used to adjust the target data in the data chart;
根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的调节量;Determining an adjustment amount for adjusting the target data according to the input information for operating the data operation option;
根据所述调节量,确定第二源数据。According to the adjustment amount, the second source data is determined.
一种图表的处理装置,包括:A chart processing device includes:
图表生成单元,用于根据源数据生成数据图表,并展示所述数据图表;The chart generating unit is used to generate a data chart according to the source data and display the data chart;
第一操作选项提供单元,用于确定所述数据图表中的目标数据,为所述目标数据提供相应的数据操作选项;The first operation option providing unit is used to determine the target data in the data chart and provide corresponding data operation options for the target data;
调节量确定单元,用于根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的第一调节量;An adjustment amount determining unit, configured to determine a first adjustment amount for adjusting the target data according to the input information for operating the data operation option;
目标数据变更单元,用于根据所述第一调节量变更所述目标数据,确定目标数据变更结果。The target data changing unit is configured to change the target data according to the first adjustment amount to determine the target data change result.
一种数据处理装置,包括:A data processing device includes:
图表建立单元,用于根据源数据生成数据可视化的数据图表,展示所述数据图表并加载其中的自变量数据与因变量数据的关联关系;所述数据图表包括元素信息维度以及属性信息维度;The chart establishment unit is configured to generate a data visualization data chart according to the source data, display the data chart and load the correlation between independent variable data and dependent variable data; the data chart includes element information dimensions and attribute information dimensions;
第二操作选项提供单元,用于确定所述数据图表中的自变量数据,为所述自变量数据提供相应的数据操作选项;The second operation option providing unit is used to determine the independent variable data in the data chart and provide corresponding data operation options for the independent variable data;
自变数据调节单元,根据对所述数据操作选项进行操作的输入信息,确定对所述自变量数据进行调节的调节量,并根据所述调节量变更所述自变量数据;The independent variable data adjustment unit determines the adjustment amount for adjusting the independent variable data according to the input information for operating the data operation option, and changes the independent variable data according to the adjustment amount;
因变数据更新单元,用于基于所述关联关系,确定随着所述自变量数据变更而变化的相应的因变量数据,并在所述数据图表中加载变更后的因变量数据。The dependent variable update unit is configured to determine the corresponding dependent variable data that changes with the change of the independent variable data based on the association relationship, and load the changed dependent variable data in the data chart.
一种图表处理装置,包括:A chart processing device, including:
图表处理单元,用于根据第一源数据生成数据图表,并为所述数据图表提供数据操作选项;所述操作选项用于对所述数据图表中的目标数据进行调节;The chart processing unit is configured to generate a data chart according to the first source data and provide data operation options for the data chart; the operation options are used to adjust the target data in the data chart;
调节量处理单元,用于根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的调节量;An adjustment amount processing unit, configured to determine an adjustment amount for adjusting the target data according to the input information for operating the data operation option;
结果处理单元,用于根据所述调节量,确定第二源数据。The result processing unit is configured to determine the second source data according to the adjustment amount.
一种计算机系统,包括:A computer system including:
一个或多个处理器;以及One or more processors; and
与所述一个或多个处理器关联的存储器,所述存储器用于存储程序指令,所述程序指令在被所述一个或多个处理器读取执行时,执行如下操作:A memory associated with the one or more processors, where the memory is used to store program instructions, and when the program instructions are read and executed by the one or more processors, perform the following operations:
根据源数据生成数据图表,并展示所述数据图表;Generate a data chart according to the source data, and display the data chart;
确定所述数据图表中的目标数据,为所述目标数据提供相应的数据操作选项;Determine the target data in the data chart, and provide corresponding data operation options for the target data;
根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的第一调节量;Determine the first adjustment amount for adjusting the target data according to the input information for operating the data operation option;
根据所述第一调节量变更所述目标数据,确定目标数据变更结果。The target data is changed according to the first adjustment amount, and the target data change result is determined.
根据本申请提供的具体实施例,本申请公开了以下技术效果:According to the specific embodiments provided in this application, this application discloses the following technical effects:
通过本申请,可以根据源数据建立和展示数据图表,为数据图表中的目标数据提供的数据操作选项,根据对数据操作选项进行操作的输入信息,确定对目标数据进行调节的第一调节量;根据第一调节量变更所述目标数据,确定目标数据变更结果。从而可以通过数据图表不仅能够反映源数据的特征,又提供了具有交互功能的操作选项,用户可 以在更加直观的方式通过数据操作选项对数据图表中的数据对象进行操作,比如对图形元素或数值进行变更,能够在数据图表中迅速和方便的查看变化后的数据特征,增强了数据图表的功能作用,增加了数据图表的交互性和应用性,使数据图表可以应用于更加广泛的应用中。Through this application, a data chart can be created and displayed based on the source data, the data operation options provided for the target data in the data chart, and the first adjustment amount for adjusting the target data can be determined according to the input information for operating the data operation options; The target data is changed according to the first adjustment amount, and the target data change result is determined. Thus, the data chart can not only reflect the characteristics of the source data, but also provide operation options with interactive functions. Users can operate the data objects in the data chart in a more intuitive way through the data operation options, such as graphical elements or values. Making changes can quickly and conveniently view the changed data characteristics in the data chart, enhance the function of the data chart, increase the interactivity and applicability of the data chart, and make the data chart can be used in a wider range of applications.
进一步的,还可以将对目标数据的变更结果反馈到源数据中。与现有技术中数据图表仅仅忠实的体现数据不同,将对目标数据的变更结果反馈到源数据中,增加了源数据与数据图表之间作用的灵活性,提供了一种能够通过数据图表直观的操作源数据的方式,增加了用户对于源数据的操作能力,使得数据图表不仅可以用于展示源数据的特征,更使数据图表具备了更广泛应用的潜力。Further, the result of the change to the target data can also be fed back to the source data. Different from the data chart in the prior art that only faithfully reflects the data, the result of the change to the target data is fed back to the source data, which increases the flexibility of the interaction between the source data and the data chart, and provides a way to visualize the data through the chart. The way of manipulating the source data increases the user's ability to manipulate the source data, so that the data chart can not only be used to display the characteristics of the source data, but also the data chart has the potential for wider application.
进一步的,该方法还可以对数据间具有关联关系的源数据进行数据可视化,并在所建立的数据图表中对数据间各维度上的不同类型的关联关系进行处理,在所操作的目标数据包括与其它数据具有关联关系的数据时,能够在操作目标数据的同时,实现同步对具有关联关系的数据的处理,大大增加了数据可视化应用技术的灵活性和适应性,使数据可视化以及数据图表技术具备了更强的互动能力的同时,也实现了对关系型数据的展现和处理能力,基于这些能力可以将数据图表应用于更加广泛的领域。Further, the method can also visualize the source data that has an association relationship between the data, and process the different types of association relationships in each dimension between the data in the established data chart, and the operated target data includes When the data has an association relationship with other data, it can realize the processing of the associated data while operating the target data, which greatly increases the flexibility and adaptability of data visualization application technology, and enables data visualization and data chart technology With stronger interaction capabilities, it also realizes the display and processing capabilities of relational data. Based on these capabilities, data charts can be applied to a wider range of fields.
当然,实施本申请的任一产品并不一定需要同时达到以上所述的所有优点。Of course, implementing any product of this application does not necessarily need to achieve all the advantages described above at the same time.
附图说明Description of the drawings
为了更清楚地说明本发明实施例或现有技术中的技术方案,下面将对实施例中所需要使用的附图作简单地介绍,显而易见地,下面描述中的附图仅仅是本发明的一些实施例,对于本领域普通技术人员来讲,在不付出创造性劳动的前提下,还可以根据这些附图获得其他的附图。In order to explain the embodiments of the present invention or the technical solutions in the prior art more clearly, the following will briefly introduce the drawings needed in the embodiments. Obviously, the drawings in the following description are only some of the present invention. Embodiments, for those of ordinary skill in the art, without creative work, other drawings can be obtained from these drawings.
图1是本申请实施例提供的数据图表示例的示意图;FIG. 1 is a schematic diagram of an example of a data chart provided by an embodiment of the present application;
图2是本申请实施例提供的第一方法的流程图;Figure 2 is a flowchart of the first method provided by an embodiment of the present application;
图3是本申请实施例提供数据图表结构的示意图;Fig. 3 is a schematic diagram of a data chart structure provided by an embodiment of the present application;
图4是本申请实施例提供的数据操作选项的示意图;4 is a schematic diagram of data operation options provided by an embodiment of the present application;
图5是本申请实施例提供的操作提示信息的示意图;FIG. 5 is a schematic diagram of operation prompt information provided by an embodiment of the present application;
图6是本申请实施例提供的数据图表中第一关联关系的示意图;FIG. 6 is a schematic diagram of the first association relationship in the data chart provided by the embodiment of the present application;
图7是本申请实施例提供的数据图表中第一约束关系的示意图;FIG. 7 is a schematic diagram of the first constraint relationship in the data chart provided by the embodiment of the present application;
图8是本申请实施例提供的第二方法的流程图;FIG. 8 is a flowchart of a second method provided by an embodiment of the present application;
图9是本申请实施例提供的第三方法的流程图;FIG. 9 is a flowchart of a third method provided by an embodiment of the present application;
图10是本申请实施例提供的第一装置的示意图;FIG. 10 is a schematic diagram of a first device provided by an embodiment of the present application;
图11是本申请实施例提供的第二装置的示意图;FIG. 11 is a schematic diagram of a second device provided by an embodiment of the present application;
图12是本申请实施例提供的第三装置的示意图;Figure 12 is a schematic diagram of a third device provided by an embodiment of the present application;
图13是本申请实施例提供的计算机系统的示意图。Fig. 13 is a schematic diagram of a computer system provided by an embodiment of the present application.
具体实施方式Detailed ways
下面将结合本发明实施例中的附图,对本发明实施例中的技术方案进行清楚、完整地描述,显然,所描述的实施例仅仅是本发明一部分实施例,而不是全部的实施例。基于本发明中的实施例,本领域普通技术人员所获得的所有其他实施例,都属于本发明保护的范围。The technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art fall within the protection scope of the present invention.
使用数据可视化技术表达数据时,根据源数据建立的图表能够客观反映源数据中数据的特征或意义,例如,在某种形式的图表中能够直观的展现出各元素类型的占比,或者在另一种形式的图表中可以展示不同类型的元素在一个地理区域的分布情况等等。其中,各种形式的图表根据数据源生成,并忠实的展示出数据源中各组成元素意义或特征。然而,随着数据在各种业务中重要性的提升,以及可视化技术中要处理的数据量的和数据复杂度提高,传统的还原式的可视化技术已经难以满足应用需求,表达数据之间的相互关系,以及在可视化图表中提供更多的交互性,成为了数据可视化技术领域新的需求和发展方向。本申请实施例提供了数据图表的处理方法,可以应用于数据可视化技术领域,该方法的所要解决的技术问题并不满足于仅是对数据源的展示,而是以实现复杂关系数据的可视化表达,实现和提高可视化图表内容与用户的交互性,图表内容与数据源的交互性,在实现更好的表达和交互的基础上进一步解决了若干技术问题。该方法可以在一种动态的数据设计过程中帮助用户表达复杂数据关系特征,以及在可视化数据中实现交互操作,可以生动的体现交互操作过程以及数据的变化过程。该方法可以应用于各种项目预算设计,营销规划,演讲展示,数据推演分析等等应用的技术实现,具有很好的应用前景。When data visualization technology is used to express data, the chart established based on the source data can objectively reflect the characteristics or meaning of the data in the source data. For example, a certain form of chart can intuitively show the proportion of each element type, or in another One form of chart can show the distribution of different types of elements in a geographic area, and so on. Among them, various forms of charts are generated according to the data source, and faithfully display the meaning or characteristics of the constituent elements in the data source. However, with the increase in the importance of data in various businesses, and the increase in the amount of data to be processed and the complexity of the data in the visualization technology, the traditional reduction visualization technology has been difficult to meet application requirements and express the mutual relationship between data Relations and providing more interactivity in visualization charts have become a new demand and development direction in the field of data visualization technology. The embodiment of the application provides a data chart processing method, which can be applied to the field of data visualization technology. The technical problem to be solved by this method is not only to display the data source, but to realize the visual expression of complex relational data. , To achieve and improve the interactivity between the visual chart content and the user, the interactivity between the chart content and the data source, and further solve a number of technical problems on the basis of achieving better expression and interaction. This method can help users express complex data relationship characteristics in a dynamic data design process, and realize interactive operations in visual data, and can vividly reflect the interactive operation process and the data change process. This method can be applied to the technical realization of various project budget design, marketing planning, speech display, data deduction and analysis, etc., and has good application prospects.
为了便于理解,首先对本申请实施例提供的方法相关概念进行介绍。In order to facilitate understanding, first introduce the related concepts of the method provided in the embodiments of the present application.
数据图表:在数据可视化中,数据图表使用于直观的展现数据的特征或意义图形结构,在实际应用中,数据图表并不限于狭义的二维表格,而是可以包括多种类型的图表, 例如,经常使用的数据图表包括饼状图、柱状图、折线图、分布坐标图、结合地图的分布图等等。如图1所示,为不同类型的数据图表的示意图,图1中(a)图表为饼状图,(b)图表为柱状图,(c)图表为折线图,这几种数据图表都是日常经常会遇到的数据图表。Data charts: In data visualization, data charts are used to intuitively display the characteristics or meaning of the data. In practical applications, data charts are not limited to a narrow two-dimensional table, but can include multiple types of charts, for example , Data charts that are frequently used include pie charts, bar charts, line charts, distribution coordinate charts, distribution charts combined with maps, and so on. As shown in Figure 1, it is a schematic diagram of different types of data charts. In Figure 1, (a) is a pie chart, (b) is a bar chart, and (c) is a line chart. These types of data charts are all Data charts that are often encountered in daily life.
数据图表的维度:一般情况下,数据图表都包括n个维度,其中至少包括两个维度,即元素信息维度以及属性信息维度。其中元素信息维度中包括的元素信息,元素信息可以个体对象、分类对象等等,例如学生甲,耗材A,用户类型B等等;属性信息维度包括属性信息,属性信息可以是元素信息对象的物理属性、统计属性等等,例如身高,耗材库存量,参加过某活动用户数量。而具体的数据对应于两个维度,例如“170cm”对应“学生甲”以及“身高”两个维度中的元素信息以及属性信息,容易理解,这个数据表示学生甲的身高。再例如,在物料用度规划中,不同类型物料可以形成元素信息维度中的元素信息,例如“水泥”、“PVC管”、“网线”等等;某种物料的使用量,具体如房间A中物料使用量,可以看作属性信息维度的属性信息。模拟的图表结构和数据如表1所示:Dimensions of the data chart: Generally, the data chart includes n dimensions, including at least two dimensions, namely, the element information dimension and the attribute information dimension. Among them, the element information included in the element information dimension can be individual objects, classified objects, etc., such as student A, consumables A, user type B, etc.; the attribute information dimension includes attribute information, which can be the physical of the element information object Attributes, statistical attributes, etc., such as height, consumable inventory, and the number of users who have participated in an event. The specific data corresponds to two dimensions. For example, "170cm" corresponds to the element information and attribute information in the two dimensions of "Student A" and "Height". It is easy to understand that this data represents the height of Student A. For another example, in material cost planning, different types of materials can form element information in the element information dimension, such as "cement", "PVC pipe", "network cable", etc.; the usage of a certain material, such as room A The amount of material used in the medium can be regarded as the attribute information of the attribute information dimension. The simulated chart structure and data are shown in Table 1:
表1Table 1
Figure PCTCN2020095288-appb-000001
Figure PCTCN2020095288-appb-000001
其中的数据如对于网线使用量“32(m)”这一数据,其对应元素信息为“网线”,对应的属性信息为“房间A用量”。The data therein, for example, for the data of network cable usage "32(m)", the corresponding element information is "network cable", and the corresponding attribute information is "room A usage".
综上示例可见,在数据图表中具体数据对应的属性信息不应局限的理解为某对象的物理属性,可以包括统计属性且实际应用中多为统计属性。另外,只有结合数据的所有相关维度的信息才能了解数据的完整意义。In summary, it can be seen that the attribute information corresponding to the specific data in the data chart should not be limited to the physical attribute of an object, and it can include statistical attributes and is mostly statistical attributes in practical applications. In addition, only by combining all relevant dimensions of the data can we understand the complete meaning of the data.
以下结合具体实施例对本申请提供的方法进行详细的介绍。The method provided in this application will be described in detail below in conjunction with specific embodiments.
实施例一Example one
请参看图2,为本申请实施例一提供的图表的处理方法的流程图,如图2所示,该方法可以包括以下步骤:Please refer to FIG. 2, which is a flowchart of a chart processing method provided in Embodiment 1 of this application. As shown in FIG. 2, the method may include the following steps:
S201:根据源数据生成数据图表,并展示所述数据图表;S201: Generate a data chart according to the source data, and display the data chart;
首先,可以获得源源数据,根据源数据可以生成用于数据可视化的数据图表,并展 示数据图表。具体实现时可以有不同的实现方式。例如从系统架构角度,在通过独立设备实现时,可以在设备中存储源数据,在设备应用中实现源数据的可视化,即根据源数据生成数据可视化的数据图表,这种实现方式可以用于可视化数据展示的应用场景中,例如演讲展示,活动数据规划等应用中。当然,也可以在基于服务器/客户端的系统架构中实现,例如可以在服务器端存储源数据,在客户端的请求下服务器根据源数据生成数据可视化的数据图表,并将数据图表发送到客户端,客户端对数据图表进行展示,以及提供相应的操作接口,在通过操作接口接收到操作后,将对应数据的调整结果反馈到服务器,服务器对反馈进行处理,例如丢弃或保存修改并升级源数据等。First, the source data can be obtained. Based on the source data, a data chart for data visualization can be generated and the data chart can be displayed. There can be different implementation methods for specific implementation. For example, from the perspective of system architecture, when implemented by independent devices, source data can be stored in the device, and the source data can be visualized in device applications, that is, data visualization data charts are generated based on the source data. This implementation can be used for visualization Data display application scenarios, such as speech display, event data planning and other applications. Of course, it can also be implemented in a server/client-based system architecture. For example, the source data can be stored on the server, and the server generates a data visualization data chart based on the source data at the request of the client, and sends the data chart to the client. The terminal displays the data chart and provides the corresponding operation interface. After receiving the operation through the operation interface, the adjustment result of the corresponding data is fed back to the server, and the server processes the feedback, such as discarding or saving the modification and upgrading the source data.
数据图表的形式多种多样,其中可以包括元素信息维度以及属性信息维度。各种类型的数据体表可以偏重表达数据的某些特征,如饼状图侧重展现各数据项的占比,结合地图的分布图则侧重于展现对象的地理分布情况等等。数据图表还可以包括二维表格,其中包括元素信息维度以及属性信息维度,元素信息维度和属性信息维度分别对应二维表格的行和列(或:列和行),即元素信息维度对应二维表格的行/列,而属性信息维度则对应二维表格的列/行。另外,在实际应用中,还可以使用复合型图表,即同时使用不同类型的图表进行源数据的可视化处理。复合型图表可以包括多个不同类型的子图表,各子图表相互独立,但都用于表现同一数据源,也可以是将多种不同形式的数据图表融合在一起进行数据源的可视化。参看图3,为本申请实施例一提供的数据图表的示例,该图表为一种复合型图表,融合了柱状图以及二维表格等数据可视化形式,即整体以二维表格呈现源数据,在具体的数据数值表示上还融合了柱状图的表示方法,使数据可视化的数据图表更加直观易懂。后续部分内容将结合图3使出的该数据图表进行介绍,图3中的数据图表为一个关于活动预期规划的数据图表。其中包括元素信息维度以及属性信息维度,为了便于介绍,该数据图表中示例性的以列对应元素信息维度,以行对应属性信息维度,在实际应用中,这种对应关系可以互换。其中元素信息维度中包括用户的类型信息,在数据图表中第一列所示,例如“兴趣类A”类型的用户,“活跃C”类型的用户。属性信息维度中包括了在数据图表中第一行所示的“人群目标占比”、“客单价”属性信息。There are many forms of data charts, including element information dimensions and attribute information dimensions. Various types of data body tables can focus on expressing certain characteristics of the data, such as a pie chart that focuses on showing the proportion of each data item, and a distribution map combined with a map focuses on showing the geographical distribution of objects, and so on. The data chart can also include a two-dimensional table, which includes element information dimensions and attribute information dimensions. The element information dimensions and attribute information dimensions respectively correspond to the rows and columns (or: columns and rows) of the two-dimensional table, that is, the element information dimensions correspond to the two-dimensional The row/column of the table, and the attribute information dimension corresponds to the column/row of the two-dimensional table. In addition, in practical applications, you can also use composite charts, that is, use different types of charts to visualize the source data at the same time. A composite chart can include multiple different types of sub-charts, each of which is independent of each other, but they are all used to represent the same data source, or it can be a combination of multiple different forms of data charts to visualize the data source. Refer to Figure 3, which is an example of the data chart provided in Example 1 of this application. This chart is a composite chart that incorporates data visualization forms such as histograms and two-dimensional tables. That is, the source data is presented in a two-dimensional table as a whole. The specific numerical representation of the data also incorporates the representation method of the histogram, making the data visualization of the data more intuitive and easy to understand. The subsequent part of the content will be introduced in conjunction with the data chart used in Figure 3. The data chart in Figure 3 is a data chart about the expected planning of activities. These include element information dimensions and attribute information dimensions. For ease of introduction, the data chart exemplarily corresponds to element information dimensions in columns and attribute information dimensions in rows. In practical applications, this correspondence relationship can be interchanged. Among them, the element information dimension includes user type information, as shown in the first column of the data chart, such as "interest class A" type users and "active C" type users. The attribute information dimension includes the attribute information of "population target percentage" and "customer unit price" shown in the first row of the data chart.
S202:确定所述数据图表中的目标数据,为所述目标数据提供相应的数据操作选项;S202: Determine target data in the data chart, and provide corresponding data operation options for the target data;
与传统数据可视化侧重于在数据图表中还原源数据表达源数据的固有特征不同,本申请实施例提供的数据图表的处理方法中,除了能够根据源数据生成和展示数据图表, 还可以能够增强数据图表的交互性,可以在显示源数据的数据图表的同时,能够提供给用户对数据图表的操作交互的能力,具体例如可以是对数据图表内的数据项目进行调整变更的能力,使数据图表的应用范围大大增加。在生成和展示数据图表后,可以确定数据图表中的目标数据,为目标数据提供相应的数据操作选项。目标数据可以是在交互过程中需要进行调整的数据,如同数据图表中的其它数据与元素信息以及属性信息相对应一样,目标数据可以与一目标元素信息以及一目标属性信息项对应。目标数据的确定可以根据用户的操作进行,例如在展示的数据图表中将被操作的数据或图形元素对应的数据确定为目标数据。Unlike traditional data visualization that focuses on restoring the source data in the data chart to express the inherent characteristics of the source data, the data chart processing method provided in the embodiment of this application can not only generate and display the data chart based on the source data, but also can enhance the data The interactivity of the chart can provide the user with the ability to interact with the data chart while displaying the data chart of the source data. For example, it can be the ability to adjust and change the data items in the data chart, so that the data chart is The scope of application is greatly increased. After the data chart is generated and displayed, the target data in the data chart can be determined, and corresponding data operation options can be provided for the target data. The target data may be data that needs to be adjusted during the interaction process. Just as other data in the data chart corresponds to element information and attribute information, the target data may correspond to a target element information and a target attribute information item. The target data can be determined according to the user's operation. For example, the data to be operated or the data corresponding to the graphic element is determined as the target data in the displayed data chart.
具体实现为目标数据提供相应的数据操作选项,可以根据不同的实际应用,以及不同的数据图表类型中可以有不同的实现。例如在饼状图的数据图表中,侧重于体现不同数据的占比情况,各数据的占比一不同扇形面积体现,当然目标数据也于一个扇形相对应,对于饼状图的数据图表可以提供对目标扇形占比的操作选项,通过该操作选项可以调节目标数据扇形角度或面积的大小。类似的,对于柱状图,例如图1中的(b)所示的柱状图,柱状图中柱子的高度与数据的值具有相应的比例关系,可以提供调整目标数据相应柱子高度的操作选项。实际上,在提供为目标数据提供相应的数据操作选项,可以包括两种类型,一种是拖曳型的,如可以拖动的图形元素,以便于通过鼠标等设备进行操作,另外一种可以是输入型的,例如可以提供输入框以接收用户输入的值,以便于通过键盘输入精确的调整值。例如操作选项可以是拖曳手柄组件,拖曳手柄组件可以用于拖曳图形元素,或者输入框组件,用于输入精确的数值。例如对于图3的数据图表,可以实现上述的拖曳型的数据操作选项以及输入型的数据操作选项,两种选项的示例可以见图4,其中,图4中的4(a)为对于可调节的数据提供的拖曳型的操作选项,即其中的柱状图柱子后的圆环形手柄,圆环形手柄可以向左或向右拖曳从而改变相应的数据以及柱状图形元素。另外,也可以如图4中的4(b)所示提供型输入型的数据操作选项,通过该输入型的数据操作选项可以接收用户输入的数量,进而可以根据数量确定对目标数据的调节量。The specific realization provides corresponding data operation options for the target data, which can be realized in different ways according to different practical applications and different data chart types. For example, in the data chart of the pie chart, the focus is on reflecting the proportion of different data. The proportion of each data is reflected in a different sector area. Of course, the target data also corresponds to a sector. The data chart of the pie chart can be provided The operation option for the proportion of the target sector, through which the angle or area of the target data sector can be adjusted. Similarly, for a histogram, such as the histogram shown in (b) in Figure 1, the height of the column in the histogram has a corresponding proportional relationship with the value of the data, and operation options for adjusting the height of the corresponding column of the target data can be provided. In fact, providing corresponding data operation options for the target data can include two types, one is drag type, such as draggable graphic elements, so as to be operated by devices such as a mouse, and the other can be For the input type, for example, an input box can be provided to receive the value input by the user, so that the precise adjustment value can be input through the keyboard. For example, the operation option can be a drag handle component, which can be used to drag graphic elements, or an input box component, used to input precise values. For example, for the data chart in Figure 3, the drag-type data operation options and the input-type data operation options can be implemented. Examples of the two options can be seen in Figure 4, where 4(a) in Figure 4 is for the adjustable The data provides drag-type operation options, that is, the circular handle behind the column of the histogram. The circular handle can be dragged to the left or right to change the corresponding data and the bar graph elements. In addition, as shown in 4(b) in Figure 4, an input-type data operation option can also be provided. The input-type data operation option can receive the amount of user input, and then the adjustment amount to the target data can be determined according to the amount. .
在数据图表的显示界面,还可以给出数据操作选项的使用提示,参看图5,其示出了两种类型的数据操作选项的使用提示,使用提示的给出可以在鼠标悬停于数据图表的图形元素或数值上时给出。如图5所示,其中5(a)为拖曳型的操作选项的使用提示,5(b)为输入型的操作选项的使用提示。On the display interface of the data chart, you can also give hints for the use of data operation options. Refer to Figure 5, which shows the hints for the use of two types of data operation options. The use of hints can be given by hovering over the data chart. The graphical element or value is given. As shown in Figure 5, 5(a) is a prompt for the use of drag-type operation options, and 5(b) is a prompt for the use of input-type operation options.
S203:根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的第一调节量;S203: Determine a first adjustment amount for adjusting the target data according to the input information for operating the data operation option;
当为目标数据提供相应的数据操作选项被操作,目标数据通过数据操作选项被调整,可以根据对数据操作选项进行操作产生的输入信息,确定对目标数据进行调节的第一调节量,例如可以根据对拖曳手柄组件进行拖曳操作所产生的输入信息,确定对目标数据进行调节的第一调节量;或者可以根据在所述输入框组件进行输入的输入信息,确定对所述目标数据进行调节的第一调节量。第一调节量可以是对目标数据进行调整的增量,也可以是对目标数据进行调整的最终的目标数量。When the corresponding data operation option is provided for the target data and the target data is adjusted through the data operation option, the first adjustment amount for adjusting the target data can be determined according to the input information generated by operating the data operation option, for example, according to The input information generated by the drag operation of the drag handle assembly determines the first adjustment amount for adjusting the target data; or the first adjustment amount for adjusting the target data may be determined according to the input information input in the input box assembly One adjustment amount. The first adjustment amount may be an increment for adjusting the target data, or may be a final target amount for adjusting the target data.
S204:根据所述第一调节量变更所述目标数据,确定目标数据变更结果。S204: Change the target data according to the first adjustment amount, and determine a target data change result.
在确定了对目标数据进行调节的第一调节量后,可以根据第一调节量变更目标数据,确定目标数据变更结果。目标数据的变更结果可以实时的展示在数据图表中,这种目标数据的变更可以是实时的,可以通过对数据图表进行刷新,以将确定的目标数据的变更结果展示在数据图表中。在数据图表中的数据大多对应有相应图形元素,显然,目标数据的变更结果也可以通过图表中的图形元素的变化体现出来。After the first adjustment amount for adjusting the target data is determined, the target data may be changed according to the first adjustment amount to determine the target data change result. The change result of the target data can be displayed in the data chart in real time. The change of the target data can be real-time. The data chart can be refreshed to display the determined target data change result in the data chart. Most of the data in the data chart corresponds to corresponding graphic elements. Obviously, the result of the change of the target data can also be reflected by the change of the graphic elements in the chart.
在数据图表中反应目标数据的变更结果,还可以将对目标数据的变更结果反馈到源数据中。例如可以在用户在数据图表中确认保存变更后,将变更后的数据保存到数据源中。与现有技术中数据图表仅仅忠实的体现数据不同,本方法可以将对目标数据的变更结果反馈到源数据中,从而实现了通过在数据图表中提供操作选项,通过操作选项变更图表中的目标数据(在一些情况下对于用户来说这个过程更类似于对图形元素的变更),然后将目标数据的变更反向提供给源数据一种方式,从而增加源数据与数据图表之间互动的灵活性,也给用户提供了一条能够通过数据图表直观的操作源数据的路径,增加了数据图表应用的互动。在实际应用中,源数据通常是以数据库的形式保存,将对目标数据的变更结果反馈到源数据中,相当于对源数据所在的数据库进行了更新操作,数据库管理系统可以依据自身的策略进行更新,例如可以保存变更操作的对象数据,保存数据表镜像等等。The result of the change of the target data is reflected in the data chart, and the result of the change of the target data can also be fed back to the source data. For example, after the user confirms to save the changes in the data chart, the changed data can be saved to the data source. Unlike the data chart in the prior art that only faithfully reflects the data, this method can feed back the result of the change to the target data to the source data, thereby realizing that by providing operation options in the data chart, the target in the chart can be changed through the operation options Data (in some cases, this process is more similar to the change of graphic elements for the user), and then the change of the target data is provided back to the source data in a way, thereby increasing the flexibility of the interaction between the source data and the data chart It also provides users with a path to intuitively manipulate source data through data charts, increasing the interaction of data chart applications. In practical applications, the source data is usually stored in the form of a database, and the results of changes to the target data are fed back to the source data, which is equivalent to updating the database where the source data is located, and the database management system can proceed according to its own strategy. Update, for example, you can save the object data of the change operation, save the data table mirror and so on.
除了通过数据操作选项对数据图表中的数据/图形的操作增加数据图表的交互性,对于数据间具有关联关系的源数据,本申请实施例提供的方法还可以进行处理。源数据中数据的关联关系可以随源数据一起保存,在对源数据进行数据可视化任务时,可以加载源数据相应的关联关系的描述信息。在源数据生成的数据图表中,不同维度上可以表现 出不同类型的关联关系,例如在属性信息维度上可以表现为第一关联关系,具体的,属性信息维度上可以包括至少两个关联型属性信息,具有第一关联关系的关联型属性信息形成一组关联型属性信息,一组关联型属性信息之间以第一关联关系相关,可以在进行数据可视化任务时加载第一关联关系。如图6,为数据图表中属性信息维度上的第一关联关系的示意图,图6的数据图表中在属性信息维度上包括了若干属性信息,各属性信息之间存在第一关联关系,例如在人群转化率于目标额,人群转化率于人群蓄水目标存在第一关联关系,第一关联关系实际为一种正相关的关系。从属性信息的角度描述这种关联关系实际上是一种逻辑上的描述,反应在数据上就可以是图6中,数据610、数据611以及数据612之间的关联关系,其中当数据610下调时,数据611以及数据612也会随之下调。同理,当数据620上调时,数据621以及数据622也会随数据620上调。In addition to the operation of the data/graphics in the data chart through the data operation options to increase the interactivity of the data chart, the method provided in the embodiment of the present application can also process the source data that has an association relationship between the data. The association relationship of the data in the source data can be saved together with the source data. When performing data visualization tasks on the source data, the description information of the corresponding association relationship of the source data can be loaded. In the data chart generated by the source data, different types of association relationships can be shown in different dimensions. For example, the first association relationship can be shown in the attribute information dimension. Specifically, the attribute information dimension can include at least two association attributes. Information, associative attribute information with a first association relationship forms a group of associative attribute information, a group of associative attribute information is related by a first association relationship, and the first association relationship can be loaded when performing a data visualization task. Figure 6 is a schematic diagram of the first association relationship in the attribute information dimension in the data chart. The data chart in Figure 6 includes several attribute information in the attribute information dimension, and there is a first association relationship between each attribute information, for example, The population conversion rate is at the target amount, and there is a first correlation between the population conversion rate and the crowd water storage target, and the first correlation is actually a positive correlation. Describing this association relationship from the perspective of attribute information is actually a logical description. The reflection on the data can be the association relationship between data 610, data 611, and data 612 in Figure 6, where when data 610 is downregulated At this time, the data 611 and the data 612 will be adjusted downward accordingly. Similarly, when the data 620 is adjusted upward, the data 621 and the data 622 will also be adjusted upward along with the data 620.
第一关联关系对于属性信息来说是一种逻辑上的描述,而对于属性信息下的数据,则成为一种数量的描述,即函数关系。例如当以数据610为自变量时,数据611则作用作为因变量。在通过数据操作选项调整目标数据时,如果目标数据是关联型属性信息下的数据,在调整目标数据时,还需要确定关联数据的调整结果,其中,关联数据是指与目标数据具有第一关联关系的数据,且与目标数据对应于同一目标元素信息,例如在图6的数据图表中,目标数据为数据610时,关联数据可以包括同行的数据611或数据612。The first association relationship is a logical description for the attribute information, while for the data under the attribute information, it becomes a quantitative description, that is, a functional relationship. For example, when data 610 is used as an independent variable, data 611 is used as a dependent variable. When adjusting the target data through the data operation options, if the target data is data under associative attribute information, when adjusting the target data, it is also necessary to determine the adjustment result of the associated data, where the associated data refers to the first association with the target data The relational data and the target data correspond to the same target element information. For example, in the data chart of FIG. 6, when the target data is data 610, the associated data may include peer data 611 or data 612.
源数据之间的关联的另一种体现是一种约束型的关系,例如图7中,数据项目710以及数据项目720所在的列中,各数据表示人群分类相应的占比,该列的数据具体为一个百分比数值,且各项数值相加要求为100%,这各约束条件与客观事实逻辑相符合,同时也复合用户的理解习惯。在进行应用设计时,常常也要求对这样的数据行/列的约束条件进行实时检验,以免出现不符合逻辑的数据或情形出现。这类数据在属性信息维度上对应了一种约束型属性信息,即属性信息维度上包括约束型属性信息,其中,同一约束型属性信息下的部分或全部数据满足第一约束关系,例如图7所示的数据图表中,“人群目标占比”即为一个约束型的属性信息,在其下的数据要满足总和为100%这一约束条件,当要调整的目标数据是约束型属性信息下的数据时,要使调整后的各受约束数据仍满足第一约束关系,可以在该约束型属性信息下确定一个调节响应数据,基于第一约束关系确定调节响应数据的第二调节量,其中,第二调节量用于变更调节响应数据,以在目标数据以及调节响应数据变更后,仍然保持约束型属性信息下各相关数据之间的第一约束关系。如图7中要调整(降低)的目标数据为710时,要使其所在的列的各数据之和在调整后仍然满足和为100%这一约束条件,可以在该列,也即在该约束性属性信息下确定 一个调节响应数据720,调节响应数据720根据第二调节量进行变更,使目标数据以及调节响应数据变更后,仍然保持该列各项数据满足和为100%这一约束条件。同时,如图中所示,数据项710与数据项711,以及数据项720与数据项721之间还受到第一关联关系的影响,在数据项710降低时,数据项711根据第一关联关系也随之降低,数据项721则随着数据项720的增加而增加。Another embodiment of the association between source data is a constrained relationship. For example, in Figure 7, in the column where the data item 710 and the data item 720 are located, each data represents the corresponding proportion of the population classification, and the data in this column Specifically, it is a percentage value, and the sum of the various values is required to be 100%. These constraints are consistent with the objective facts and logic, and at the same time, they also compound the user's understanding habits. When designing an application, it is often required to conduct real-time inspections of such data row/column constraint conditions, so as to avoid illogical data or situations. This type of data corresponds to a kind of constraint attribute information in the attribute information dimension, that is, the attribute information dimension includes constraint attribute information, where some or all of the data under the same constraint attribute information satisfies the first constraint relationship, as shown in Figure 7 In the data chart shown, the "population target proportion" is a restricted attribute information, and the data under it must meet the constraint condition that the total sum is 100%. When the target data to be adjusted is restricted attribute information In order to ensure that each constrained data after adjustment still satisfies the first constraint relationship, an adjustment response data can be determined under the constraint attribute information, and the second adjustment amount of the adjustment response data can be determined based on the first constraint relationship, where The second adjustment amount is used to change the adjustment response data, so that after the target data and the adjustment response data are changed, the first constraint relationship between the related data under the constraint attribute information is still maintained. As shown in Figure 7, when the target data to be adjusted (reduced) is 710, the sum of the data in the column in which it is located still satisfies the constraint condition that the sum is 100% after the adjustment. It can be in this column, that is, in this column. Determine an adjustment response data 720 under the constraint attribute information. The adjustment response data 720 is changed according to the second adjustment amount, so that after the target data and the adjustment response data are changed, the data in the column still meets the constraint condition that the sum is 100% . At the same time, as shown in the figure, the data item 710 and the data item 711, and the data item 720 and the data item 721 are also affected by the first association relationship. When the data item 710 is reduced, the data item 711 is affected according to the first association relationship. It also decreases, and the data item 721 increases as the data item 720 increases.
前述的关联关系更类似于一种函数关系,而第一约束关系是对一组数据的和,数据与数据的比例,数据的最大值的限制。第一关联关系以及第一约束关系可以是由用户确定,也可以在对数据的机器学习中计算产生。The aforementioned association relationship is more similar to a functional relationship, and the first constraint relationship is a restriction on the sum of a set of data, the ratio of data to data, and the maximum value of data. The first association relationship and the first constraint relationship may be determined by the user, or may be calculated in the machine learning of the data.
约束型属性信息下的各数据的约束关系,可以是客观形成,例如当对一个人群进行分类,各分类的占比之和自然为100%,这是符合客观逻辑和用户认知的约束条件。在对数据进行机器学习获得源数据时,如生成成分占比类的属性信息时,其下的数据也会自然要求和为100%。在对相应的数据图表中的分类占比数据进行调整时,要进行相应的约束,以使调整后的数据依然符合客观逻辑,以及使数据调整操作顺利通过应用程序的校验。当然,这种约束关系也可以是指定的,例如由数据管理员制定。第一约束条件也可以随源数据一起保存,在对源数据进行数据可视化任务时,可以加载源数据相应的第一约束条件的描述信息。在实际应用中,第一约束关系可以包括不同类型的约束关系,约束关系也可以作为可视化应用中对数据变更的一种校验条件,第一约束关系可以包括以下约束关系示例中的一种:The constraint relationship of each data under the constraint attribute information can be objectively formed. For example, when a group of people is classified, the total proportion of each category is naturally 100%, which is in line with objective logic and user cognition constraints. When machine learning is performed on the data to obtain source data, such as when generating attribute information of component proportions, the underlying data will naturally require a sum of 100%. When adjusting the classified proportion data in the corresponding data chart, corresponding constraints must be made so that the adjusted data still conforms to the objective logic and the data adjustment operation smoothly passes the verification of the application program. Of course, this constraint relationship can also be specified, for example, formulated by a data administrator. The first constraint condition can also be saved with the source data. When performing a data visualization task on the source data, the description information of the first constraint condition corresponding to the source data can be loaded. In practical applications, the first constraint relationship can include different types of constraint relationships, and the constraint relationship can also be used as a check condition for data changes in visualization applications. The first constraint relationship can include one of the following constraint relationship examples:
受所述第一约束关系约束的各数据项的和为固定值;The sum of the data items restricted by the first constraint relationship is a fixed value;
受所述第一约束关系约束的数据项的比例为固定值;或者,The proportion of data items restricted by the first constraint relationship is a fixed value; or,
受所述第一约束关系约束的各数据项的和不超过预设的最大允许值。The sum of the data items restricted by the first constraint relationship does not exceed the preset maximum allowable value.
当目标数据为约束型属性信息下的数据时,在该约束型属性信息下确定一调节响应数据的方式可以包括多种,如可以在指定某一行/列中的数据作为调节响应数据,或者增加一行/列,将其中的约束型属性信息的数据确定为调节响应数据。即当目标数据为所述约束型属性信息下的数据时,可以在该约束型属性信息下根据指定的数据项确定调节响应数据;或者,当目标数据为约束型属性信息下的数据时,在该约束型属性信息下新建数据项,并将新建的数据项确定为调节响应数据。When the target data is data under constrained attribute information, there are multiple ways to determine adjustment response data under the constrained attribute information, such as specifying data in a certain row/column as adjustment response data, or adding One row/column, the data of the constraint attribute information is determined as the adjustment response data. That is, when the target data is the data under the constraint attribute information, the adjustment response data can be determined according to the specified data item under the constraint attribute information; or, when the target data is the data under the constraint attribute information, A new data item is created under the constraint attribute information, and the newly created data item is determined as the adjustment response data.
在数据图表中根据变更结果展示展示调节后的目标数据。当数据图表中存在于目标数据具有关联关系的关联数据时,还可以在数据图表中更新关联数据,即展示调节后的 关联数据。调整后的目标数据以及调整后的关联数据的展示可以是同步的,实时的。在一些操作形式下,例如通过拖曳手柄操作调整目标数据的方式下,目标数据和关联数据的变化可以是线性的实时变化。The adjusted target data is displayed in the data chart according to the change result. When there is associated data in the data chart that has an association relationship with the target data, you can also update the associated data in the data chart, that is, display the adjusted associated data. The display of the adjusted target data and the adjusted associated data can be synchronized and real-time. In some operation modes, for example, the target data is adjusted by dragging the handle, the change of the target data and the associated data can be linear and real-time changes.
在一个数据图表的属性信息维度上,可以包括两个或两个以上约束型属性信息,每个约束型属性信息下的部分或全部数据满足该约束型属性信息相应的约束关系。在涉及到多个约束型属性信息下的多个目标数据的调整时,可以根据相应的约束关系对相应的调节响应数据进行调整,以使调整后的各约束型属性信息下的数据依然满足相应的约束关系。In the attribute information dimension of a data chart, it may include two or more constrained attribute information, and part or all of the data under each constrained attribute information satisfies the corresponding constraint relationship of the constrained attribute information. When the adjustment of multiple target data under multiple constraint attribute information is involved, the corresponding adjustment response data can be adjusted according to the corresponding constraint relationship, so that the adjusted data under each constraint attribute information still meets the corresponding requirements. The constraint relationship.
对于调节响应数据,在一些应用中可以仅仅作为调整过程的一个缓冲数据,而不关注其变化以及调节响应数据的引起的其它数据的变化,但有的应用中则并非如此。有时在进行目标数据的调整时,调节响应数据自身,或者因调节响应数据变化的而随之变化的其它数据,也可能是有着重要影响,或者被实际关注的数据,因此可以在数据图表中突出调节响应数据的变化程度,或者通过进一步的调整最终抵消掉调节响应数据的偏移。Regarding the adjustment response data, in some applications it can only be used as a buffer of the adjustment process, without paying attention to its changes and other data changes caused by the adjustment response data, but in some applications this is not the case. Sometimes when adjusting the target data, the adjustment response data itself, or other data that changes due to changes in the adjustment response data, may also have important influence or data that is actually concerned, so it can be highlighted in the data chart Adjust the degree of change of the response data, or finally offset the offset of the adjustment response data through further adjustments.
一种实现方式下,可以确定调节响应数据的初始值,调节响应数据的初始值可以保存在缓存中。在完成一次目标数据的调节后,确定调节响应数据变更的偏移量。确定相应数据变更的偏移量的意义之一在于可以在数据图表中体现该偏移量,以使用户在调整目标数据的过程中实时了解调节响应数据的变化情况,尤其是在依次进行多个目标数据的调整情况下,可以明确调节响应数据的变化情况。在另一种实施方式下,对于需要在调节完成后将调节响应数据复原的应用中,可以确定是否对调节响应数据变更的偏移量进行归零检查,如读取用户配置进行确定,或在某些操作动作(如保存数据更改)发生时进行归零检查。若确定需要进行归零检查,则检查偏移量是否在当前目标数据的调节后归零。当然,在需要偏移量归零而实际未归零的情况下,可以继续进行数据的调整直至响应数据变更的偏移量归零。In one implementation, the initial value of the adjustment response data can be determined, and the initial value of the adjustment response data can be stored in the cache. After completing the adjustment of the target data once, determine the offset of the adjustment response data change. One of the significances of determining the offset of the corresponding data change is that the offset can be reflected in the data chart, so that the user can understand the changes in the adjustment response data in real time during the process of adjusting the target data, especially when performing multiple changes in sequence. In the case of adjustment of target data, the changes in response data can be clearly adjusted. In another embodiment, for applications that need to restore the adjustment response data after the adjustment is completed, it can be determined whether to reset the offset of the adjustment response data change, such as reading the user configuration to determine, or When certain operation actions (such as saving data changes) occur, a zero-return check is performed. If it is determined that a zero-return check is required, check whether the offset is zeroed after the adjustment of the current target data. Of course, in the case where the offset needs to be reset to zero but it is not actually reset, the data adjustment can be continued until the offset in response to the data change is reset to zero.
如前所述,本申请实施例一提供的方法可以应用于多种应用场景,例如可以应用于各种项目预算设计,营销规划,演讲展示,数据推演分析等等,在不同的应用场景中,所生成的数据图表中包含的信息和数据可以不同,例如当涉及到人群相关数据的可视化应用时,数据图表的元素信息维度中的元素信息可以包括人群分类信息。具体的示例可以如图3中的数据图表中对人群类型进行分类得到的各人群分类信息。关于数据图表的源数据也可以根据实际应用的不同而不同,例如,源数据可以包括活动计划类数据,所 建立的数据图表相应的就包括了活动计划图表,活动计划类数据可以用于对目标活动的实施进行规划,应用本申请的处理方法对活动计划图表的数据进行直接的调整,可以获得清晰直观的调整结果,最终达到满意的活动数据规划结果。As mentioned above, the method provided in the first embodiment of the present application can be applied to a variety of application scenarios, for example, it can be applied to various project budget design, marketing planning, speech display, data deduction and analysis, etc. In different application scenarios, The information and data contained in the generated data chart may be different. For example, when a visualization application of crowd-related data is involved, the element information in the element information dimension of the data chart may include crowd classification information. A specific example can be the classification information of each crowd obtained by classifying the crowd types in the data chart in FIG. 3. The source data of the data chart can also be different according to actual applications. For example, the source data can include activity plan data, and the created data chart includes the activity plan chart. The activity plan data can be used to target Plan the implementation of the activity, apply the processing method of this application to directly adjust the data of the activity plan chart, and obtain a clear and intuitive adjustment result, and finally achieve a satisfactory result of the activity data planning.
数据图表可以是含有多个子图表的复合型数据图表,其中,子图表之间在元素信息维度和/或属性信息维度上具有相关性,例如子图表A中的属性信息可以是子图表B的属性信息的一部分,或者图表A中的元素信息可以是子图表B的元素信息的进一步的细分类型,即其中子图表所包括的元素信息和/或属性信息为另一子图表的细分。The data chart can be a composite data chart containing multiple sub-charts, where the sub-charts are related in element information dimensions and/or attribute information dimensions. For example, the attribute information in sub-chart A can be the attribute of sub-chart B A part of the information, or the element information in the chart A may be a further subdivision type of the element information of the subchart B, that is, the element information and/or attribute information included in the subchart is a subdivision of another subchart.
以上对本申请实施例提供的图表的处理方法进行了详细的介绍,该方法可以根据源数据建立和展示数据图表,为数据图表中的目标数据提供的数据操作选项,根据对数据操作选项进行操作的输入信息,确定对目标数据进行调节的第一调节量;根据第一调节量变更所述目标数据,确定目标数据变更结果。从而可以通过数据图表不仅能够反映源数据的特征,又提供了具有交互功能的操作选项,用户可以在更加直观的方式通过数据操作选项对数据图表中的数据对象进行操作,比如对图形元素或数值进行变更,能够在数据图表中迅速和方便的查看变化后的数据特征,增强了数据图表的功能作用,极大的增加了数据图表的交互性。进一步的,还可以将对目标数据的变更结果反馈到源数据中。与现有技术中数据图表仅仅忠实的体现数据不同,将对目标数据的变更结果反馈到源数据中,增加了源数据与数据图表之间作用的灵活性,提供了一种能够通过数据图表直观的操作源数据的方式,增加了用户对于源数据的操作能力,使得数据图表不仅可以用于展示源数据的特征,更使数据图表具备了更广泛应用的潜力。进一步的,该方法还可以对数据间具有关联关系的源数据进行数据可视化,并在所建立的数据图表种对数据间各维度上的不同类型的关联关系进行处理,在所操作的目标数据包括与其它数据具有关联关系的数据时,能够在操作目标数据的同时,实现同步对具有关联关系的数据的处理,大大增加了数据可视化应用技术的灵活性和适应性,使数据可视化以及数据图表技术具备了更强的互动能力的同时,也实现了对关系型数据的展现处理能力,基于这些能力可以将数据图表应用于更加广泛的领域。The above provides a detailed introduction to the chart processing method provided by the embodiment of the application. The method can create and display a data chart based on the source data, provide data operation options for the target data in the data chart, and operate according to the data operation options. Input information to determine the first adjustment amount for adjusting the target data; change the target data according to the first adjustment amount to determine the target data change result. Thus, the data chart can not only reflect the characteristics of the source data, but also provide operation options with interactive functions. Users can operate the data objects in the data chart in a more intuitive way through the data operation options, such as graphical elements or values. Making changes can quickly and conveniently view the changed data characteristics in the data chart, which enhances the function of the data chart and greatly increases the interactivity of the data chart. Further, the result of the change to the target data can also be fed back to the source data. Different from the data chart in the prior art that only faithfully reflects the data, the result of the change to the target data is fed back to the source data, which increases the flexibility of the interaction between the source data and the data chart, and provides a way to visualize the data through the chart. The way of manipulating the source data increases the user's ability to manipulate the source data, so that the data chart can not only be used to display the characteristics of the source data, but also the data chart has the potential for wider application. Further, the method can also visualize the source data that has an association relationship between the data, and process different types of association relationships in each dimension between the data in the established data chart. The target data includes When the data has an association relationship with other data, it can realize the processing of the associated data while operating the target data, which greatly increases the flexibility and adaptability of data visualization application technology, and enables data visualization and data chart technology With stronger interaction capabilities, it also realizes the display and processing capabilities of relational data. Based on these capabilities, data charts can be applied to a wider range of fields.
实施例二Example two
本申请实施例二提供了一种数据处理方法,请参看图8,其为本申请实施例二提供的数据实验方法的流程图,该方法可以包括以下步骤:The second embodiment of the application provides a data processing method. Please refer to FIG. 8, which is a flowchart of the data experiment method provided in the second embodiment of the application. The method may include the following steps:
S801:根据源数据生成数据可视化的数据图表,展示所述数据图表并加载其中的自变量数据与因变量数据的关联关系;所述数据图表包括元素信息维度以及属性信息维度;S801: Generate a data visualization data chart according to the source data, display the data chart and load the correlation relationship between independent variable data and dependent variable data; the data chart includes element information dimensions and attribute information dimensions;
数据实验可以根据实验用的源数据进行推演,观察受关注的数据的变化情况;也可以通过对不同的目标数据的调节,使关注的数据达到理想值,从而得到优选的解决方案数据;也可以用于展现动态的数据变化过程,获得更好的演示效果。本方案基于实施例一中的图表的处理方法,特别是处理关系型源数据(即源数据中的数据在特定维度上具有特定类型的关联关系)的方法内容,并将数据图表的处理方法应用于数据实验的方法。首先,可以确定源数据,根据源数据可以生成用于数据可视化的数据图表,并展示数据图表。源数据中包含具有关联关系的数据,例如具有函数关系的数据,其中包括自变量数据以及因变量数据,数据的关联关系可以随源数据一同保存,并在建立数据图表时进行加载。建立的数据图表中可以包括元素信息维度以及属性信息维度。元素信息维度以及属性信息维度的内容请参照实施例一中的描述,在此就不再赘述了。在本方法种,数据的关系可以包括多种,数据的关系可以交叉,如同一自变量数据可以同时作为不同函数关系的自变量数据。自变量数据与因变量数据可以对应属性信息维度上的不同属性信息。例如在某种应用场景下,自变量数据可以对应“人群目标占比”这一属性信息,而因变量数据可以对应“总销售额”这一属性信息。在此应用中,可以通过对不同人群目标占比这一自变量的调节,观察总销售额的因变量数据的变化情况。Data experiments can be deduced based on the source data used in the experiment to observe the changes in the data of interest; it can also adjust different target data to make the data of interest reach the ideal value, so as to obtain the optimal solution data; or It is used to show the dynamic data change process and obtain a better presentation effect. This solution is based on the chart processing method in Example 1, especially the method content of processing relational source data (that is, the data in the source data has a specific type of association relationship in a specific dimension), and applies the data chart processing method Method for data experiment. First, the source data can be determined, and data charts for data visualization can be generated based on the source data, and the data charts can be displayed. The source data contains data with an association relationship, such as data with a functional relationship, including independent variable data and dependent variable data. The association relationship of the data can be saved with the source data and loaded when the data chart is created. The created data chart can include element information dimensions and attribute information dimensions. For the content of the element information dimension and the attribute information dimension, please refer to the description in the first embodiment, which will not be repeated here. In this method, data relationships can include multiple types, and data relationships can be crossed. For example, the same independent variable data can be used as independent variable data of different functional relationships at the same time. The independent variable data and the dependent variable data can correspond to different attribute information in the attribute information dimension. For example, in a certain application scenario, the independent variable data can correspond to the attribute information of "population target proportion", and the dependent variable data can correspond to the attribute information of "total sales". In this application, you can observe the changes in the dependent variable data of total sales by adjusting the independent variable of the target proportion of different populations.
S802:确定所述数据图表中的自变量数据,为所述自变量数据提供相应的数据操作选项;S802: Determine the independent variable data in the data chart, and provide corresponding data operation options for the independent variable data;
可以确定数据图表中的自变量数据,为自变量数据提供相应的数据操作选项,操作选项可以用于调节各自变量数据,以通过调节自变量数据,基于自变量数据与因变量数据的关联关系改变因变量数据,而因变量数据通常为数据实验中受关注的数据,或者被期望达到某种目标的数据。The independent variable data in the data chart can be determined, and the corresponding data operation options can be provided for the independent variable data. The operation options can be used to adjust the respective variable data to change the independent variable data based on the correlation between the independent variable data and the dependent variable data. Dependent variable data, and dependent variable data is usually data that is of interest in data experiments, or data that is expected to achieve a certain goal.
S803:根据对所述数据操作选项进行操作的输入信息,确定对所述自变量数据进行调节的调节量,并根据所述调节量变更所述自变量数据;S803: Determine an adjustment amount for adjusting the independent variable data according to the input information for operating the data operation option, and change the independent variable data according to the adjustment amount;
该步骤内容可以参考实施例一中步骤S203,根据对数据操作选项进行操作的输入信息,确定对目标数据进行调节的第一调节量,的类似具体实现,在此就不再赘述了。For the content of this step, please refer to step S203 in the first embodiment. According to the input information for operating the data operation option, the first adjustment value for adjusting the target data is determined. The similar specific implementation is similar and will not be repeated here.
S804:基于所述关联关系,确定随着所述自变量数据变更而变化的相应的因变量数据,并在所述数据图表中加载变更后的因变量数据。S804: Based on the association relationship, determine corresponding dependent variable data that changes with the change of the independent variable data, and load the changed dependent variable data in the data chart.
在数据图表中,确定了对自变量数据进行调节的调节量,并根据调节量变更了自变量数据后,可以基于关联关系,确定随着自变量数据变更而变化的相应的因变量数据,并在数据图表中加载变更后的因变量数据,以观察因变量的变化,或者使因变量数据到达理想的数值后,确定自变量数据的状态。In the data chart, the adjustment amount to adjust the independent variable data is determined, and after the independent variable data is changed according to the adjustment amount, the corresponding dependent variable data that changes with the independent variable data can be determined based on the association relationship, and Load the changed dependent variable data in the data chart to observe the change of the dependent variable, or determine the state of the independent variable data after the dependent variable data reaches the ideal value.
其中属性信息维度上可以包括约束型属性信息,同一约束型属性信息下的部分或全部数据满足第二约束关系;当自变量数据为约束型属性信息下的数据时,在该约束型属性信息下确定一调节响应数据;在变更所述自变量数据时,基于所述第二约束关系调整所述调节响应数据,以在自变量数据变更后,保持所述约束型属性信息下相关数据之间的第二约束关系。该部分的具体实现可以参考实施例一中对第一约束关系的数据处理方法。该数据实验方法基于实施例一中的数据图表以及数据图表的处理方法,可以近似的应用实施例一中数据处理方法的部分或全部特征。类似的,在该数据实验方法中,可以将数据图表中的数据变化反馈到源数据中。Among them, the attribute information dimension can include constraint attribute information, and some or all of the data under the same constraint attribute information meets the second constraint relationship; when the independent variable data is data under constraint attribute information, under the constraint attribute information Determine an adjustment response data; when changing the independent variable data, adjust the adjustment response data based on the second constraint relationship, so that after the independent variable data is changed, the relationship between the related data under the constraint attribute information is maintained The second constraint relationship. For the specific implementation of this part, refer to the data processing method for the first constraint relationship in the first embodiment. The data experiment method is based on the data chart in the first embodiment and the processing method of the data chart, and part or all of the features of the data processing method in the first embodiment can be applied approximately. Similarly, in this data experiment method, the data changes in the data chart can be fed back to the source data.
在一些应用中,可能会希望一些数据只在一定范围内发生变化,例如希望某些数据不超过/不低于某值;例如,当用数据图表表示建筑活动数据时,希望在进行其它项目的调节时,有害气体的排放量不能超过一定值,此时,可以将排放量的最大允许值锁定,以观察或确定在其它项目调节时气体排放量在最大值内的变化情况。具体实现时,可以提供锁定因变量数据的锁定操作选项,当通过锁定操作选项接收到一目标值时,将因变量数据的极限值锁定为目标值,目标值可以是最大允许值或最小允许值等。当随着自变量数据变更而变化的相应因变量数据达到极限值时,停止变更自变量数据以及相应因变量数据。In some applications, you may want some data to change only within a certain range. For example, you want some data to not exceed/not fall below a certain value; for example, when you use a data chart to represent construction activity data, you want to perform other projects. When adjusting, the emission of harmful gases cannot exceed a certain value. At this time, the maximum allowable value of the emission can be locked to observe or determine the change of the gas emission within the maximum value during the adjustment of other items. In specific implementation, a lock operation option to lock dependent variable data can be provided. When a target value is received through the lock operation option, the limit value of the dependent variable data is locked as the target value. The target value can be the maximum allowable value or the minimum allowable value Wait. When the corresponding dependent variable data that changes with the change of the independent variable data reaches the limit value, stop changing the independent variable data and the corresponding dependent variable data.
在具体应用中,该数据处理方法可以应用于活动策划数据的处理方法,具体实现时,可以根据活动源数据生成数据可视化的数据图表,展示数据图表并加载其中的调节项数据与规划目标数据的关联关系,确定数据图表中的目标调节项数据,为目标调节项数据提供相应的数据操作选项;根据对数据操作选项进行操作的输入信息,确定对目标调节项数据进行调节的调节量,并根据调节量变更目标调节项数据,基于关联关系,确定随着调节项数据变更而变化的相应的规划目标数据,并在数据图表中更新所述规划目标数据。基于实施例一中的数据图表处理方法类似的机制,活动策划数据时可以利用数据图表增加的交互能力,以及在数据图表种增加的关系型数据的处理能力,可以利用数据图表这一直观快捷的工具进行活动策划数据的处理,能够直观快速的得到数据活动策划的 处理结果,利用数据图表实现了根据活动源数据进行推演,观察规划目标数据的变化情况;或者通过对不同的调节项数据的调节,使关注的规划目标数据达到理想值,从而得到优选的活动规划数据解决方案;或者用于展现动态的活动规划数据变化过程,获得更好的演示效果。其中,活动可以是各种类型的社会活动经济活动等,例如营销活动,建筑规划活动等等。In specific applications, the data processing method can be applied to the processing method of event planning data. In the specific implementation, data visualization data charts can be generated according to the event source data, display the data charts and load the adjustment item data and planning target data. Association relationship, determine the target adjustment item data in the data chart, provide corresponding data operation options for the target adjustment item data; according to the input information for operating the data operation options, determine the adjustment amount to adjust the target adjustment item data, and according to The adjustment amount change target adjustment item data, based on the association relationship, determines the corresponding planning target data that changes with the adjustment item data change, and updates the planning target data in the data chart. Based on a mechanism similar to the data chart processing method in the first embodiment, the interactive ability of the data chart can be used when planning data, and the processing capacity of the relational data added in the data chart can be used, which is intuitive and fast. Tools for event planning data processing, can intuitively and quickly obtain the processing results of data event planning, use data charts to realize deduction based on event source data, and observe the changes in planning target data; or through adjustment of different adjustment item data , To make the planning target data concerned reach the ideal value, so as to obtain the optimal activity planning data solution; or to show the dynamic activity planning data change process to obtain a better demonstration effect. Among them, the activities can be various types of social activities, economic activities, etc., such as marketing activities, architectural planning activities and so on.
本申请实施例二提供了一种数据处理方法,可以根据源数据生成和展示用于数据可视化的数据图表,加载其中的自变量数据与因变量数据的关联关系;确定数据图表中的自变量数据,为自变量数据提供相应的数据操作选项;根据对数据操作选项进行操作的输入信息,确定对自变量数据进行调节的调节量,并根据调节量变更所述自变量数据;基于所述关联关系,确定随着自变量数据变更而变化的相应的因变量数据,并在数据图表中加载变更后的因变量数据。基于实施例一中的数据图表处理方法类似的机制,数据实验方法利用为数据图表增加的交互能力,以及在数据图表种增加的关系型数据的处理能力,可以利用数据图表这一直观快捷的工具进行数据实验,能够直观快速的得到数据实验的处理结果,利用数据图表实现了根据源数据进行推演,观察受关注的数据的变化情况;或者通过对不同的目标数据的调节,使关注的数据达到理想值,从而得到优选的解决方案数据;或者用于展现动态的数据变化过程,获得更好的演示效果等等。The second embodiment of the application provides a data processing method, which can generate and display data charts for data visualization based on source data, load the correlation between independent variable data and dependent variable data; determine the independent variable data in the data chart , Provide corresponding data operation options for the independent variable data; determine the adjustment amount for adjusting the independent variable data according to the input information for operating the data operation options, and change the independent variable data according to the adjustment amount; based on the association relationship , Determine the corresponding dependent variable data that changes as the independent variable data changes, and load the changed dependent variable data in the data chart. Based on a mechanism similar to the data chart processing method in the first embodiment, the data experiment method uses the added interactive capabilities for data charts and the increased processing capabilities of relational data in the data charts, which can use the intuitive and fast tool of data charts Carrying out data experiments can intuitively and quickly obtain the processing results of the data experiments, using data charts to realize deduction based on the source data, and observe the changes of the data concerned; or through the adjustment of different target data, the data of interest can be reached Ideal value, so as to obtain the optimal solution data; or used to show the dynamic data change process, obtain a better presentation effect, etc.
实施例三Example three
本申请实施例三提供了一种图表处理方法,请参看图9,其为本申请实施例三提供的数据处理方法的流程图,该方法可以包括以下步骤:The third embodiment of the present application provides a chart processing method. Please refer to FIG. 9, which is a flowchart of the data processing method provided in the third embodiment of the present application. The method may include the following steps:
S901:根据第一源数据生成数据图表,并为所述数据图表提供数据操作选项;所述操作选项用于对所述数据图表中的目标数据进行调节;S901: Generate a data chart according to the first source data, and provide data operation options for the data chart; the operation options are used to adjust target data in the data chart;
首先,可以根据第一源数据生成用于数据可视化的数据图表,并为所述数据图表提供数据操作选项;数据操作选项可以是展示数据图表的节目中的操作选项,例如滑动输入的操作手柄,或数据输入组件等等,操作选项可以用于对数据图表中的目标数据进行调节。数据图表的形式可以多种多样,如饼状图,折线图,柱状图,坐标分布图等等,其中可以包括元素信息维度以及属性信息维度。数据图表还可以包括二维表格,其中包括元素信息维度以及属性信息维度,分别对应二维表格的行和列(或:列和行),即元素信息维度对应二维表格的行/列,而属性信息维度则对应二维表格的列/行。另外,在实 际应用中,还可以使用复合型图表,即同时使用不同类型的图表进行源数据的可视化处理。First, a data chart for data visualization can be generated based on the first source data, and data operation options can be provided for the data chart; the data operation options can be operation options in a program that displays the data chart, such as a sliding input operation handle, Or data input components, etc., operation options can be used to adjust the target data in the data chart. The forms of data charts can be various, such as pie charts, line charts, histograms, coordinate distribution charts, etc., which can include element information dimensions and attribute information dimensions. The data chart can also include a two-dimensional table, which includes element information dimensions and attribute information dimensions, which correspond to the rows and columns (or: columns and rows) of the two-dimensional table respectively, that is, the element information dimensions correspond to the rows/columns of the two-dimensional table, and The attribute information dimension corresponds to the column/row of the two-dimensional table. In addition, in practical applications, you can also use composite charts, that is, use different types of charts at the same time to visualize the source data.
S902:根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的调节量;S902: Determine an adjustment amount for adjusting the target data according to the input information for operating the data operation option;
可以在显示第一源数据的数据图表的同时,为用户提供对数据图表的操作交互的能力。确定所述数据图表中的目标数据,为所述目标数据提供相应的数据操作选项,当为目标数据提供相应的数据操作选项被操作,目标数据通过数据操作选项被调整,可以根据对数据操作选项进行操作产生的输入信息,确定对目标数据进行调节的调节量,例如可以根据对拖曳手柄组件进行拖曳操作所产生的输入信息,确定对目标数据进行调节的调节量;或者可以根据在输入框组件进行输入的输入信息,确定对目标数据进行调节的调节量。调节量可以是对目标数据进行调整的增量,也可以是对目标数据进行调整的最终的目标数量。While displaying the data chart of the first source data, it provides users with the ability to operate and interact with the data chart. Determine the target data in the data chart and provide corresponding data operation options for the target data. When the target data is provided with the corresponding data operation options to be operated, the target data is adjusted through the data operation options, which can be adjusted according to the data operation options The input information generated by the operation determines the adjustment amount to adjust the target data. For example, the adjustment amount to adjust the target data can be determined according to the input information generated by the drag operation of the drag handle component; or it can be determined according to the input box component Enter the input information to determine the adjustment amount to adjust the target data. The adjustment amount may be an increment for adjusting the target data, or may be the final target amount for adjusting the target data.
S903:根据所述调节量,确定第二源数据。S903: Determine the second source data according to the adjustment amount.
在确定了对目标数据进行调节的调节量后,可以根据调节量变更目标数据。目标数据的变更结果可以实时的展示在数据图表中,这种目标数据的变更可以是实时的,可以通过对数据图表进行刷新,以将确定的目标数据的变更结果展示在数据图表中。可以根据调节量确定变更后的目标数据,以及与目标数据具有特定关系的数据,例如与目标数据具有第一关联关系,或第一约束关系的数据,都可以根据具体的关系自动的调整。可以根据调节量,确定第二源数据。第二源数据不同于第一源数据,例如可以是在第一源数据的基础上根据调节量调节获得。After the adjustment amount for adjusting the target data is determined, the target data can be changed according to the adjustment amount. The change result of the target data can be displayed in the data chart in real time. The change of the target data can be real-time. The data chart can be refreshed to display the determined target data change result in the data chart. The changed target data can be determined according to the adjustment amount, as well as data having a specific relationship with the target data, for example, data having a first association relationship with the target data or a first constraint relationship, and can be automatically adjusted according to the specific relationship. The second source data can be determined according to the adjustment amount. The second source data is different from the first source data. For example, it may be obtained by adjusting the adjustment amount based on the first source data.
以上对本申请实施例提供的图表处理方法进行了详细的介绍,该方法可以根据第一源数据生成数据图表,并为数据图表提供数据操作选项;操作选项可以用于对数据图表中的目标数据进行调节;根据对数据操作选项进行操作的输入信息,确定对目标数据进行调节的调节量;根据调节量,确定第二源数据。从而可以通过数据图表不仅能够反映源数据的特征,又提供了具有交互功能的操作选项,用户可以在更加直观的方式,通过数据操作选项对数据图表中的数据对象进行操作,比如对图形元素或数值进行变更,能够在数据图表中迅速和方便的查看变化后的数据特征,通过数据图表中提供的操作选项,可以直接调整第一源数据,得到第二源数据,增强了数据图表的功能作用,极大的增加了数据图表的交互性。The chart processing method provided by the embodiment of the application is described in detail above. The method can generate a data chart according to the first source data, and provide data operation options for the data chart; the operation options can be used to perform operations on the target data in the data chart. Adjustment; Determine the adjustment amount for adjusting the target data according to the input information for operating the data operation option; determine the second source data according to the adjustment amount. Therefore, the data chart can not only reflect the characteristics of the source data, but also provide operation options with interactive functions. The user can operate the data objects in the data chart through the data operation options in a more intuitive way, such as graphical elements or The value is changed, and the changed data characteristics can be quickly and conveniently viewed in the data chart. Through the operation options provided in the data chart, the first source data can be directly adjusted to obtain the second source data, which enhances the function of the data chart , Which greatly increases the interactivity of the data chart.
与本申请实施例一相对应,还提供了一种数据图表的处理装置,参看图10,为该数据图表的处理装置的示意图,该数据图表的处理装置可以包括:Corresponding to the first embodiment of the present application, a data chart processing device is also provided. Refer to FIG. 10, which is a schematic diagram of the data chart processing device. The data chart processing device may include:
图表生成单元1010,用于根据源数据生成数据图表,并展示所述数据图表;所述数据图表可以包括元素信息维度以及属性信息维度;The chart generating unit 1010 is configured to generate a data chart based on source data and display the data chart; the data chart may include element information dimensions and attribute information dimensions;
第一操作选项提供单元1020,用于确定所述数据图表中的目标数据,为所述目标数据提供相应的数据操作选项;其中,目标数据对应一目标元素信息以及一目标属性信息;The first operation option providing unit 1020 is used to determine the target data in the data chart and provide corresponding data operation options for the target data; wherein the target data corresponds to a target element information and a target attribute information;
调节量确定单元1030,用于根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的第一调节量;The adjustment amount determining unit 1030 is configured to determine the first adjustment amount for adjusting the target data according to the input information for operating the data operation option;
目标数据变更单元1040,用于根据所述第一调节量变更所述目标数据,确定目标数据变更结果。The target data changing unit 1040 is configured to change the target data according to the first adjustment amount, and determine a target data change result.
其中,数据图表可以包括元素信息维度以及属性信息维度;属性信息维度上包括至少两个关联型属性信息,一组所述关联型属性信息之间以第一关联关系相关;所述装置还包括:Wherein, the data chart may include an element information dimension and an attribute information dimension; the attribute information dimension includes at least two associative attribute information, and a group of the associative attribute information is related by a first association relationship; the device further includes:
第一关联关系加载单元,用于加载所述第一关联关系。The first association relationship loading unit is configured to load the first association relationship.
其中,各关联型属性信息相应的数据也以所述第一关联关系相关;所述装置还包括:Wherein, the data corresponding to each association type attribute information is also related by the first association relationship; the device further includes:
关联数据调整单元,用于若所述目标数据为所述关联型属性信息下的数据,则确定关联数据的调整结果;其中,所述关联数据为与目标数据具有第一关联关系的数据,且与所述目标数据对应于同一目标元素信息。The associated data adjustment unit is configured to determine an adjustment result of the associated data if the target data is data under the associated attribute information; wherein the associated data is data that has a first association relationship with the target data, and It corresponds to the same target element information as the target data.
该装置还可以包括:The device may also include:
目标数据刷新单元,用于根据所述变更结果在数据图表中展示调节后的目标数据。The target data refresh unit is used to display the adjusted target data in the data chart according to the change result.
数据图表包括元素信息维度以及属性信息维度;其中,属性信息维度上包括约束型属性信息,同一所述约束型属性信息下的部分或全部数据满足第一约束关系;该装置还可以包括:The data chart includes element information dimensions and attribute information dimensions; wherein the attribute information dimension includes constraint attribute information, and some or all of the data under the same constraint attribute information satisfies the first constraint relationship; the device may further include:
调节响应数据确定单元,用于当所述目标数据为所述约束型属性信息下的数据时,在该约束型属性信息下确定一调节响应数据;An adjustment response data determining unit, configured to determine an adjustment response data under the restriction attribute information when the target data is the data under the restriction attribute information;
第二调节量确定单元,用于基于所述第一约束关系确定所述调节响应数据的第二调节量;第二调节量用于变更所述调节响应数据,以在目标数据以及调节响应数据变更后, 保持约束型属性信息下相关数据之间的第一约束关系。The second adjustment amount determining unit is configured to determine the second adjustment amount of the adjustment response data based on the first constraint relationship; the second adjustment amount is used to change the adjustment response data to change the target data and the adjustment response data After that, the first constraint relationship between related data under the constraint attribute information is maintained.
第一约束关系可以包括:The first constraint relationship may include:
受所述第一约束关系约束的各数据项的和为固定值;The sum of the data items restricted by the first constraint relationship is a fixed value;
受所述第一约束关系约束的数据项的比例为固定值;或者,The proportion of data items restricted by the first constraint relationship is a fixed value; or,
受所述第一约束关系约束的各数据项的和不超过预设的最大允许值;The sum of the data items restricted by the first constraint relationship does not exceed the preset maximum allowable value;
当所述目标数据为所述约束型属性信息下的数据时,在该约束型属性信息下确定一调节响应数据,可以在该约束型属性信息下根据指定的数据项确定所述调节响应数据。或者也可以在目标数据为所述约束型属性信息下的数据时,在该约束型属性信息下新建数据项,并将新建的数据项确定为所述调节响应数据。When the target data is data under the restriction attribute information, an adjustment response data is determined under the restriction attribute information, and the adjustment response data can be determined according to a designated data item under the restriction attribute information. Or, when the target data is the data under the restriction attribute information, a new data item can be created under the restriction attribute information, and the newly created data item can be determined as the adjustment response data.
在另一种实现方式下,该装置还可以包括:In another implementation manner, the device may further include:
初始值确定单元,用于确定调节响应数据的初始值;The initial value determining unit is used to determine the initial value of the adjustment response data;
偏移量确定单元,用于在完成一次目标数据的调节后,确定调节响应数据变更的偏移量。The offset determination unit is used to determine the offset of the adjustment response to the data change after completing the adjustment of the target data once.
在这种实现方式下,该装置还可以包括:In this implementation manner, the device may further include:
归零确定单元,用于确定是否对调节响应数据变更的偏移量进行归零检查;以及,归零检查单元,用于若确定需要进行归零检查,则检查所述偏移量是否在当前目标数据的调节后归零。The zero return determination unit is used to determine whether to perform a zero return check on the offset of the adjustment response data change; and, the zero return check unit is used to check whether the offset is current if it is determined that a zero return check is required Return to zero after adjustment of the target data.
属性信息维度上包括可以至少两个约束型属性信息,每个所述约束型属性信息下的部分或全部数据满足该约束型属性信息相应的约束关系。数据图表可以包括二维表格;二维表格的元素信息维度对应二维表格的行/列;二维表格的属性信息维度对应二维表格的列/行。操作选项可以包括拖曳手柄组件,根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的第一调节量,可以根据对拖曳手柄组件进行拖曳操作所产生的输入信息,确定对目标数据进行调节的第一调节量。操作选项还可以是输入框组件,可以根据在所述输入框组件进行输入的输入信息,确定对所述目标数据进行调节的第一调节量。The attribute information dimension may include at least two constrained attribute information, and part or all of the data under each constrained attribute information satisfies the corresponding constraint relationship of the constrained attribute information. The data chart may include a two-dimensional table; the element information dimension of the two-dimensional table corresponds to the row/column of the two-dimensional table; the attribute information dimension of the two-dimensional table corresponds to the column/row of the two-dimensional table. The operation option may include a drag handle component, and the first adjustment amount for adjusting the target data is determined according to the input information for operating the data operation option, and may be based on the input information generated by the drag operation on the drag handle component, Determine the first adjustment amount for adjusting the target data. The operation option may also be an input box component, and the first adjustment amount for adjusting the target data may be determined according to the input information entered in the input box component.
该数据图表的处理装置还可以包括:The data chart processing device may further include:
变更结果反馈单元,用于将对目标数据的所述变更结果反馈到所述源数据中。The change result feedback unit is configured to feed back the change result of the target data to the source data.
数据图表包括元素信息维度,元素信息维度中的元素信息可以包括人群分类信息。 在另一种实现方式下,源数据可以包括活动计划类数据。数据图表可以包括含有多个子图表的复合型数据图表;其中,子图表之间在元素信息维度和/或属性信息维度上具有相关性。子图表之间在元素信息维度和/或属性信息维度上具有相关性,可以是其中子图表所包括的元素信息和/或属性信息为另一子图表的细分。The data chart includes the element information dimension, and the element information in the element information dimension may include crowd classification information. In another implementation manner, the source data may include activity plan data. The data chart may include a composite data chart containing multiple sub-charts; wherein the sub-charts are related in the element information dimension and/or the attribute information dimension. The sub-charts are related in the element information dimension and/or the attribute information dimension, and the element information and/or attribute information included in the sub-chart may be a subdivision of another sub-graph.
与本申请实施例二相对应,还提供了一种数据处理装置,参看图11,为该数据实验装置的示意图,该数据实验装置可以包括:Corresponding to the second embodiment of the present application, a data processing device is also provided. Refer to FIG. 11, which is a schematic diagram of the data experiment device. The data experiment device may include:
图表建立单元1110,用于根据源数据生成数据可视化的数据图表,展示所述数据图表并加载其中的自变量数据与因变量数据的关联关系;所述数据图表包括元素信息维度以及属性信息维度;The chart establishing unit 1110 is configured to generate a data visualization data chart according to the source data, display the data chart and load the correlation between independent variable data and dependent variable data; the data chart includes element information dimensions and attribute information dimensions;
第二操作选项提供单元1120,用于确定所述数据图表中的自变量数据,为所述自变量数据提供相应的数据操作选项;The second operation option providing unit 1120 is configured to determine the independent variable data in the data chart, and provide corresponding data operation options for the independent variable data;
自变数据调节单元1130,根据对所述数据操作选项进行操作的输入信息,确定对所述自变量数据进行调节的调节量,并根据所述调节量变更所述自变量数据;The independent variable data adjustment unit 1130 determines the adjustment amount for adjusting the independent variable data according to the input information for operating the data operation option, and changes the independent variable data according to the adjustment amount;
因变数据更新单元1140,用于基于所述关联关系,确定随着所述自变量数据变更而变化的相应的因变量数据,并在所述数据图表中加载变更后的因变量数据。The dependent variable data update unit 1140 is configured to determine corresponding dependent variable data that changes with the change of the independent variable data based on the association relationship, and load the changed dependent variable data in the data chart.
与本申请实施例三相对应,还提供了一种图表处理装置,参看图12,为该活动策划数据的处理装置的示意图,该活动策划数据的处理装置可以包括:Corresponding to the third embodiment of the present application, a chart processing device is also provided. Referring to FIG. 12, it is a schematic diagram of the processing device for the event planning data. The processing device for the event planning data may include:
图表处理单元1210,用于根据第一源数据生成数据图表,并为所述数据图表提供数据操作选项;所述操作选项用于对所述数据图表中的目标数据进行调节;The chart processing unit 1210 is configured to generate a data chart according to the first source data and provide data operation options for the data chart; the operation options are used to adjust the target data in the data chart;
调节量处理单元1220,用于根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的调节量;The adjustment amount processing unit 1220 is configured to determine an adjustment amount for adjusting the target data according to the input information for operating the data operation option;
结果处理单元1230,用于根据所述调节量,确定第二源数据。The result processing unit 1230 is configured to determine the second source data according to the adjustment amount.
本申请实施例还提供了一种计算机系统,包括:The embodiment of the present application also provides a computer system, including:
一个或多个处理器;以及One or more processors; and
与所述一个或多个处理器关联的存储器,所述存储器用于存储程序指令,所述程序指令在被所述一个或多个处理器读取执行时,执行如下操作:A memory associated with the one or more processors, where the memory is used to store program instructions, and when the program instructions are read and executed by the one or more processors, perform the following operations:
根据源数据生成数据图表,并展示所述数据图表;数据图表包括元素信息维度以及 属性信息维度;Generate a data chart according to the source data and display the data chart; the data chart includes element information dimensions and attribute information dimensions;
确定所述数据图表中的目标数据,为所述目标数据提供相应的数据操作选项;所述目标数据对应一目标元素信息以及一目标属性信息;Determine the target data in the data chart, and provide corresponding data operation options for the target data; the target data corresponds to a target element information and a target attribute information;
根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的第一调节量;Determine the first adjustment amount for adjusting the target data according to the input information for operating the data operation option;
根据所述第一调节量变更所述目标数据,确定目标数据变更结果。The target data is changed according to the first adjustment amount, and the target data change result is determined.
其中,图13示例性的展示出了计算机系统的架构,具体可以包括处理器1310,视频显示适配器1311,磁盘驱动器1312,输入/输出接口1313,网络接口1314,以及存储器1320。上述处理器1310、视频显示适配器1311、磁盘驱动器1312、输入/输出接口1313、网络接口1314,与存储器1320之间可以通过通信总线1330进行通信连接。Among them, FIG. 13 exemplarily shows the architecture of the computer system, which may specifically include a processor 1310, a video display adapter 1311, a disk drive 1312, an input/output interface 1313, a network interface 1314, and a memory 1320. The processor 1310, the video display adapter 1311, the disk drive 1312, the input/output interface 1313, the network interface 1314, and the memory 1320 may be communicatively connected through the communication bus 1330.
其中,处理器1310可以采用通用的CPU(Central Processing Unit,中央处理器)、微处理器、应用专用集成电路(Application Specific Integrated Circuit,ASIC)、或者一个或多个集成电路等方式实现,用于执行相关程序,以实现本申请所提供的技术方案。Among them, the processor 1310 may be implemented by a general CPU (Central Processing Unit, central processing unit), microprocessor, application specific integrated circuit (Application Specific Integrated Circuit, ASIC), or one or more integrated circuits. Perform relevant procedures to realize the technical solutions provided in this application.
存储器1320可以采用ROM(Read Only Memory,只读存储器)、RAM(Random Access Memory,随机存取存储器)、静态存储设备,动态存储设备等形式实现。存储器1320可以存储用于控制计算机系统1300运行的操作系统1321,用于控制计算机系统1300的低级别操作的基本输入输出系统BIOS1322。另外,还可以存储网页浏览器1323,数据存储管理系统1324,以及图标字体处理系统1325等等。上述图标字体处理系统1325就可以是本申请实施例中具体实现前述各步骤操作的应用程序。总之,在通过软件或者固件来实现本申请所提供的技术方案时,相关的程序代码保存在存储器1320中,并由处理器1310来调用执行。The memory 1320 can be implemented in the form of ROM (Read Only Memory), RAM (Random Access Memory, random access memory), static storage device, dynamic storage device, etc. The memory 1320 may store an operating system 1321 for controlling the operation of the computer system 1300 and a basic input output system BIOS 1322 for controlling the low-level operation of the computer system 1300. In addition, web browser 1323, data storage management system 1324, and icon font processing system 1325 can also be stored. The aforementioned icon font processing system 1325 may be an application program that specifically implements the foregoing steps in the embodiment of the present application. In short, when the technical solution provided by the present application is implemented through software or firmware, the relevant program code is stored in the memory 1320 and is called and executed by the processor 1310.
输入/输出接口1313用于连接输入/输出模块,以实现信息输入及输出。输入输出/模块可以作为组件配置在设备中(图中未示出),也可以外接于设备以提供相应功能。其中输入设备可以包括键盘、鼠标、触摸屏、麦克风、各类传感器等,输出设备可以包括显示器、扬声器、振动器、指示灯等。The input/output interface 1313 is used to connect an input/output module to realize information input and output. The input/output/module can be configured in the device as a component (not shown in the figure), or can be connected to the device to provide corresponding functions. The input device may include a keyboard, a mouse, a touch screen, a microphone, various sensors, etc., and an output device may include a display, a speaker, a vibrator, an indicator light, and the like.
网络接口1314用于连接通信模块(图中未示出),以实现本设备与其他设备的通信交互。其中通信模块可以通过有线方式(例如USB、网线等)实现通信,也可以通过无线方式(例如移动网络、WIFI、蓝牙等)实现通信。The network interface 1314 is used to connect a communication module (not shown in the figure) to realize the communication interaction between the device and other devices. The communication module can realize communication through wired means (such as USB, network cable, etc.), or through wireless means (such as mobile network, WIFI, Bluetooth, etc.).
总线1330包括一通路,在设备的各个组件(例如处理器1310、视频显示适配器1311、磁盘驱动器1312、输入/输出接口1313、网络接口1314,与存储器1320)之间传输信息。The bus 1330 includes a path for transmitting information between various components of the device (such as the processor 1310, the video display adapter 1311, the disk drive 1312, the input/output interface 1313, the network interface 1314, and the memory 1320).
另外,该计算机系统1300还可以从虚拟资源对象领取条件信息数据库1341中获得具体领取条件的信息,以用于进行条件判断,等等。In addition, the computer system 1300 can also obtain information about specific receiving conditions from the virtual resource object receiving condition information database 1341 for condition judgment, and so on.
需要说明的是,尽管上述设备仅示出了处理器1310、视频显示适配器1311、磁盘驱动器1312、输入/输出接口1313、网络接口1314,存储器1320,总线1330等,但是在具体实施过程中,该设备还可以包括实现正常运行所必需的其他组件。此外,本领域的技术人员可以理解的是,上述设备中也可以仅包含实现本申请方案所必需的组件,而不必包含图中所示的全部组件。It should be noted that although the above device only shows the processor 1310, the video display adapter 1311, the disk drive 1312, the input/output interface 1313, the network interface 1314, the memory 1320, the bus 1330, etc., in the specific implementation process, the The device may also include other components necessary for normal operation. In addition, those skilled in the art can understand that the above-mentioned device may also include only the components necessary for implementing the solution of the present application, and not necessarily all the components shown in the figure.
通过以上的实施方式的描述可知,本领域的技术人员可以清楚地了解到本申请可借助软件加必需的通用硬件平台的方式来实现。基于这样的理解,本申请的技术方案本质上或者说对现有技术做出贡献的部分可以以软件产品的形式体现出来,该计算机软件产品可以存储在存储介质中,如ROM/RAM、磁碟、光盘等,包括若干指令用以使得一台计算机设备(可以是个人计算机,服务器,或者网络设备等)执行本申请各个实施例或者实施例的某些部分所述的方法。From the description of the foregoing implementation manners, it can be understood that those skilled in the art can clearly understand that this application can be implemented by means of software plus a necessary general hardware platform. Based on this understanding, the technical solution of this application essentially or the part that contributes to the existing technology can be embodied in the form of a software product, and the computer software product can be stored in a storage medium, such as ROM/RAM, magnetic disk , CD-ROM, etc., including several instructions to enable a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method described in each embodiment or some parts of the embodiment of this application.
本说明书中的各个实施例均采用递进的方式描述,各个实施例之间相同相似的部分互相参见即可,每个实施例重点说明的都是与其他实施例的不同之处。尤其,对于系统或系统实施例而言,由于其基本相似于方法实施例,所以描述得比较简单,相关之处参见方法实施例的部分说明即可。以上所描述的系统及系统实施例仅仅是示意性的,其中所述作为分离部件说明的单元可以是或者也可以不是物理上分开的,作为单元显示的部件可以是或者也可以不是物理单元,即可以位于一个地方,或者也可以分布到多个网络单元上。可以根据实际的需要选择其中的部分或者全部模块来实现本实施例方案的目的。本领域普通技术人员在不付出创造性劳动的情况下,即可以理解并实施。The various embodiments in this specification are described in a progressive manner, and the same or similar parts between the various embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the system or the system embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and for related parts, please refer to the part of the description of the method embodiment. The system and system embodiments described above are merely illustrative, where the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, namely It can be located in one place, or it can be distributed to multiple network units. Some or all of the modules may be selected according to actual needs to achieve the objectives of the solutions of the embodiments. Those of ordinary skill in the art can understand and implement it without creative work.
以上对本申请所提供的图表的处理、数据处理方法及装置,进行了详细介绍,本文中应用了具体个例对本申请的原理及实施方式进行了阐述,以上实施例的说明只是用于帮助理解本申请的方法及其核心思想;同时,对于本领域的一般技术人员,依据本申请的思想,在具体实施方式及应用范围上均会有改变之处。综上所述,本说明书内容不应理解为对本申请的限制。The chart processing, data processing methods and devices provided in this application are described in detail above. Specific examples are used in this article to explain the principles and implementations of this application. The description of the above examples is only used to help understand this application. The application method and its core idea; meanwhile, for the ordinary skilled in the art, according to the idea of this application, there will be changes in the specific implementation and the scope of application. In summary, the content of this specification should not be construed as a limitation on this application.

Claims (31)

  1. 一种图表的处理方法,其特征在于,包括:A chart processing method, characterized in that it comprises:
    根据源数据生成数据图表,并展示所述数据图表;Generate a data chart according to the source data, and display the data chart;
    确定所述数据图表中的目标数据,为所述目标数据提供相应的数据操作选项;Determine the target data in the data chart, and provide corresponding data operation options for the target data;
    根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的第一调节量;Determine the first adjustment amount for adjusting the target data according to the input information for operating the data operation option;
    根据所述第一调节量变更所述目标数据,确定目标数据变更结果。The target data is changed according to the first adjustment amount, and the target data change result is determined.
  2. 根据权利要求1所述的方法,其特征在于,所述数据图表包括元素信息维度以及属性信息维度;所述属性信息维度上包括至少两个关联型属性信息,一组所述关联型属性信息之间以第一关联关系相关;所述方法还包括:The method according to claim 1, wherein the data chart includes an element information dimension and an attribute information dimension; the attribute information dimension includes at least two associative attribute information, a group of the associative attribute information Are related by a first association relationship; the method further includes:
    加载所述第一关联关系。Load the first association relationship.
  3. 根据权利要求2所述的方法,其特征在于,各所述关联型属性信息相应的数据也以所述第一关联关系相关;所述方法还包括:The method according to claim 2, wherein the data corresponding to each of the associated attribute information is also related by the first association relationship; the method further comprises:
    若所述目标数据为所述关联型属性信息下的数据,则确定关联数据的调整结果;其中,所述关联数据为与目标数据具有第一关联关系的数据,且与所述目标数据对应于同一目标元素信息。If the target data is the data under the associative attribute information, the adjustment result of the associated data is determined; wherein the associated data is data that has a first association relationship with the target data, and corresponds to the target data The same target element information.
  4. 根据权利要求1所述的方法,其特征在于,还包括:The method according to claim 1, further comprising:
    根据所述变更结果在数据图表中展示调节后的目标数据。According to the change result, the adjusted target data is displayed in the data chart.
  5. 根据权利要求1所述的方法,其特征在于,所述数据图表包括元素信息维度以及属性信息维度;所述属性信息维度上包括约束型属性信息,同一所述约束型属性信息下的部分或全部数据满足第一约束关系;所述方法还包括:The method according to claim 1, wherein the data chart includes an element information dimension and an attribute information dimension; the attribute information dimension includes constraint attribute information, and part or all of the same constraint attribute information The data satisfies the first constraint relationship; the method further includes:
    当所述目标数据为所述约束型属性信息下的数据时,在该约束型属性信息下确定一调节响应数据;When the target data is the data under the restriction attribute information, determine an adjustment response data under the restriction attribute information;
    基于所述第一约束关系确定所述调节响应数据的第二调节量;所述第二调节量用于变更所述调节响应数据,以在所述目标数据以及调节响应数据变更后,保持所述约束型属性信息下相关数据之间的所述第一约束关系。The second adjustment amount of the adjustment response data is determined based on the first constraint relationship; the second adjustment amount is used to change the adjustment response data so as to maintain the adjustment response data after the target data and adjustment response data are changed. The first constraint relationship between related data under constraint attribute information.
  6. 根据权利要求5所述的方法,其特征在于,所述第一约束关系包括:The method according to claim 5, wherein the first constraint relationship comprises:
    受所述第一约束关系约束的各数据项的和为固定值。The sum of the data items constrained by the first constraint relationship is a fixed value.
  7. 根据权利要求5所述的方法,其特征在于,所述第一约束关系包括:The method according to claim 5, wherein the first constraint relationship comprises:
    受所述第一约束关系约束的数据项的比例为固定值。The proportion of data items restricted by the first constraint relationship is a fixed value.
  8. 根据权利要求5所述的方法,其特征在于,所述第一约束关系包括:The method according to claim 5, wherein the first constraint relationship comprises:
    受所述第一约束关系约束的各数据项的和不超过预设的最大允许值。The sum of the data items restricted by the first constraint relationship does not exceed the preset maximum allowable value.
  9. 根据权利要求5所述的方法,其特征在于,所述当所述目标数据为所述约束型属性信息下的数据时,在该约束型属性信息下确定一调节响应数据,包括:The method according to claim 5, wherein when the target data is data under the restriction attribute information, determining an adjustment response data under the restriction attribute information comprises:
    当所述目标数据为所述约束型属性信息下的数据时,在该约束型属性信息下根据指定的数据项确定所述调节响应数据。When the target data is data under the restriction attribute information, the adjustment response data is determined according to a designated data item under the restriction attribute information.
  10. 根据权利要求5所述的方法,其特征在于,所述当所述目标数据为所述约束型属性信息下的数据时,在该约束型属性信息下确定一调节响应数据,包括:The method according to claim 5, wherein when the target data is data under the restriction attribute information, determining an adjustment response data under the restriction attribute information comprises:
    当所述目标数据为所述约束型属性信息下的数据时,在该约束型属性信息下新建数据项,并将新建的数据项确定为所述调节响应数据。When the target data is data under the restriction attribute information, a new data item is created under the restriction attribute information, and the newly created data item is determined as the adjustment response data.
  11. 根据权利要求9或10所述的方法,其特征在于,还包括:The method according to claim 9 or 10, further comprising:
    确定所述调节响应数据的初始值;Determining the initial value of the adjustment response data;
    在完成一次目标数据的调节后,确定调节响应数据变更的偏移量。After completing the adjustment of the target data once, determine the offset of the adjustment response data change.
  12. 根据权利要求11所述的方法,其特征在于,还包括:The method according to claim 11, further comprising:
    确定是否对调节响应数据变更的所述偏移量进行归零检查;Determining whether to perform a zero return check on the offset of the adjustment response data change;
    若确定需要进行所述归零检查,则检查所述偏移量是否在当前目标数据的调节后归零。If it is determined that the zero-return check is required, it is checked whether the offset is reset to zero after the current target data is adjusted.
  13. 根据权利要求5所述的方法,其特征在于,所述属性信息维度上包括至少两个约束型属性信息,每个所述约束型属性信息下的部分或全部数据满足该约束型属性信息相应的约束关系。The method according to claim 5, wherein the attribute information dimension includes at least two constrained attribute information, and part or all of the data under each constrained attribute information satisfies the corresponding constraint attribute information. Constraint relationship.
  14. 根据权利要求1所述的方法,所述数据图表包括二维表格;所述二维表格的元素信息维度对应二维表格的行/列;所述二维表格的属性信息维度对应二维表格的列/行。The method according to claim 1, wherein the data chart comprises a two-dimensional table; the element information dimension of the two-dimensional table corresponds to the row/column of the two-dimensional table; the attribute information dimension of the two-dimensional table corresponds to the two-dimensional table Column/row.
  15. 根据权利要求1所述的方法,其特征在于,所述操作选项包括拖曳手柄组件,所述根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的第一调节量,包括:The method according to claim 1, wherein the operation option includes dragging a handle assembly, and the first adjustment amount for adjusting the target data is determined according to the input information for operating the data operation option ,include:
    根据对所述拖曳手柄组件进行拖曳操作所产生的输入信息,确定对所述目标数据进行调节的第一调节量。The first adjustment amount for adjusting the target data is determined according to the input information generated by the drag operation of the drag handle assembly.
  16. 根据权利要求1所述的方法,其特征在于,所述操作选项包括输入框组件,所述根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的第一调节量,包括:The method according to claim 1, wherein the operation option includes an input box component, and the first adjustment amount for adjusting the target data is determined according to the input information for operating the data operation option ,include:
    根据在所述输入框组件进行输入的输入信息,确定对所述目标数据进行调节的第一调节量。According to the input information input in the input box component, the first adjustment amount for adjusting the target data is determined.
  17. 根据权利要求1-16任一项所述的方法,其特征在于,还包括:The method according to any one of claims 1-16, further comprising:
    将对目标数据的所述变更结果反馈到所述源数据中。The result of the change to the target data is fed back to the source data.
  18. 根据权利要求1-16任一项所述的方法,其特征在于,所述数据图表包括元素信息维度,所述元素信息维度中的元素信息包括人群分类信息。The method according to any one of claims 1-16, wherein the data chart includes an element information dimension, and the element information in the element information dimension includes crowd classification information.
  19. 根据权利要求1-16任一项所述的方法,其特征在于,所述源数据包括活动计划类数据。The method according to any one of claims 1-16, wherein the source data includes activity plan data.
  20. 根据权利要求1-16任一项所述的方法,其特征在于,所述数据图表包括含有多个子图表的复合型数据图表;其中,所述子图表之间在元素信息维度和/或属性信息维度上具有相关性。The method according to any one of claims 1-16, wherein the data chart comprises a composite data chart containing a plurality of sub-charts; wherein the element information dimension and/or attribute information is between the sub-charts. Dimensionally relevant.
  21. 根据权利要求20所述的方法,其特征在于,所述子图表之间在元素信息维度和/或属性信息维度上具有相关性,包括:The method according to claim 20, wherein the element information dimension and/or attribute information dimension between the sub-graphs have correlation, comprising:
    其中子图表所包括的元素信息和/或属性信息为另一子图表的细分。The element information and/or attribute information included in the sub-chart is a subdivision of another sub-chart.
  22. 一种数据处理方法,其特征在于,包括:A data processing method, characterized by comprising:
    根据源数据生成数据可视化的数据图表,展示所述数据图表并加载其中的自变量数据与因变量数据的关联关系;所述数据图表包括元素信息维度以及属性信息维度;Generate a data visualization data chart according to the source data, display the data chart and load the association relationship between independent variable data and dependent variable data; the data chart includes element information dimensions and attribute information dimensions;
    确定所述数据图表中的自变量数据,为所述自变量数据提供相应的数据操作选项;Determine the independent variable data in the data chart, and provide corresponding data operation options for the independent variable data;
    根据对所述数据操作选项进行操作的输入信息,确定对所述自变量数据进行调节的调节量,并根据所述调节量变更所述自变量数据;Determining an adjustment amount for adjusting the independent variable data according to the input information for operating the data operation option, and changing the independent variable data according to the adjustment amount;
    基于所述关联关系,确定随着所述自变量数据变更而变化的相应的因变量数据,并在所述数据图表中加载变更后的因变量数据。Based on the association relationship, determine the corresponding dependent variable data that changes with the change of the independent variable data, and load the changed dependent variable data in the data chart.
  23. 根据权利要求22所述的方法,其特征在于,所述自变量数据与因变量数据对应所述属性信息维度上的不同属性信息。The method according to claim 22, wherein the independent variable data and the dependent variable data correspond to different attribute information in the attribute information dimension.
  24. 根据权利要求22或23所述的方法,其特征在于,所述属性信息维度上包括约束型属性信息,同一所述约束型属性信息下的部分或全部数据满足第二约束关系;所述方法还包括:The method according to claim 22 or 23, wherein the attribute information dimension includes constrained attribute information, and some or all of the data under the same constrained attribute information satisfies the second constraint relationship; the method further include:
    当所述自变量数据为所述约束型属性信息下的数据时,在该约束型属性信息下确定一调节响应数据;When the independent variable data is data under the constraint attribute information, determine an adjustment response data under the constraint attribute information;
    在变更所述自变量数据时,基于所述第二约束关系调整所述调节响应数据,以在所 述自变量数据变更后,保持所述约束型属性信息下相关数据之间的第二约束关系。When the independent variable data is changed, the adjustment response data is adjusted based on the second constraint relationship, so that after the independent variable data is changed, the second constraint relationship between related data under the constraint attribute information is maintained .
  25. 根据权利要求22或23所述的方法,其特征在于,还包括:The method according to claim 22 or 23, further comprising:
    将所述数据图表中的数据变化反馈到所述源数据中。Feed back the data changes in the data chart to the source data.
  26. 根据权利要求22或23所述的方法,其特征在于,还包括:The method according to claim 22 or 23, further comprising:
    提供锁定所述因变量数据的锁定操作选项;Provide lock operation options for locking the dependent variable data;
    当通过所述锁定操作选项接收到一目标值时,将所述因变量数据的极限值锁定为所述目标值;When a target value is received through the lock operation option, lock the limit value of the dependent variable data as the target value;
    当随着自变量数据变更而变化的相应因变量数据达到所述极限值时,停止变更所述自变量数据以及相应因变量数据。When the corresponding dependent variable data that changes with the change of the independent variable data reaches the limit value, stop changing the independent variable data and the corresponding dependent variable data.
  27. 一种图表处理方法,其特征在于,包括:A chart processing method, characterized by comprising:
    根据第一源数据生成数据图表,并为所述数据图表提供数据操作选项;所述操作选项用于对所述数据图表中的目标数据进行调节;Generate a data chart according to the first source data, and provide data operation options for the data chart; the operation options are used to adjust the target data in the data chart;
    根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的调节量;Determining an adjustment amount for adjusting the target data according to the input information for operating the data operation option;
    根据所述调节量,确定第二源数据。According to the adjustment amount, the second source data is determined.
  28. 一种图表的处理装置,其特征在于,包括:A chart processing device, characterized in that it comprises:
    图表生成单元,用于根据源数据生成数据图表,并展示所述数据图表;The chart generating unit is used to generate a data chart according to the source data and display the data chart;
    第一操作选项提供单元,用于确定所述数据图表中的目标数据,为所述目标数据提供相应的数据操作选项;The first operation option providing unit is used to determine the target data in the data chart and provide corresponding data operation options for the target data;
    调节量确定单元,用于根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的第一调节量;An adjustment amount determining unit, configured to determine a first adjustment amount for adjusting the target data according to the input information for operating the data operation option;
    目标数据变更单元,用于根据所述第一调节量变更所述目标数据,确定目标数据变更结果。The target data changing unit is configured to change the target data according to the first adjustment amount to determine the target data change result.
  29. 一种数据处理装置,其特征在于,包括:A data processing device, characterized by comprising:
    图表建立单元,用于根据源数据生成数据可视化的数据图表,展示所述数据图表并加载其中的自变量数据与因变量数据的关联关系;所述数据图表包括元素信息维度以及属性信息维度;The chart establishment unit is configured to generate a data visualization data chart according to the source data, display the data chart and load the correlation between independent variable data and dependent variable data; the data chart includes element information dimensions and attribute information dimensions;
    第二操作选项提供单元,用于确定所述数据图表中的自变量数据,为所述自变量数据提供相应的数据操作选项;The second operation option providing unit is used to determine the independent variable data in the data chart and provide corresponding data operation options for the independent variable data;
    自变数据调节单元,根据对所述数据操作选项进行操作的输入信息,确定对所述自 变量数据进行调节的调节量,并根据所述调节量变更所述自变量数据;The independent variable data adjustment unit determines the adjustment amount for adjusting the independent variable data according to the input information for operating the data operation option, and changes the independent variable data according to the adjustment amount;
    因变数据更新单元,用于基于所述关联关系,确定随着所述自变量数据变更而变化的相应的因变量数据,并在所述数据图表中加载变更后的因变量数据。The dependent variable update unit is configured to determine the corresponding dependent variable data that changes with the change of the independent variable data based on the association relationship, and load the changed dependent variable data in the data chart.
  30. 一种图表处理装置,其特征在于,包括:A chart processing device, characterized by comprising:
    图表处理单元,用于根据第一源数据生成数据图表,并为所述数据图表提供数据操作选项;所述操作选项用于对所述数据图表中的目标数据进行调节;The chart processing unit is configured to generate a data chart according to the first source data and provide data operation options for the data chart; the operation options are used to adjust the target data in the data chart;
    调节量处理单元,用于根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的调节量;An adjustment amount processing unit, configured to determine an adjustment amount for adjusting the target data according to the input information for operating the data operation option;
    结果处理单元,用于根据所述调节量,确定第二源数据。The result processing unit is configured to determine the second source data according to the adjustment amount.
  31. 一种计算机系统,其特征在于,包括:A computer system, characterized in that it comprises:
    一个或多个处理器;以及One or more processors; and
    与所述一个或多个处理器关联的存储器,所述存储器用于存储程序指令,所述程序指令在被所述一个或多个处理器读取执行时,执行如下操作:A memory associated with the one or more processors, where the memory is used to store program instructions, and when the program instructions are read and executed by the one or more processors, perform the following operations:
    根据源数据生成数据图表,并展示所述数据图表;Generate a data chart according to the source data, and display the data chart;
    确定所述数据图表中的目标数据,为所述目标数据提供相应的数据操作选项;Determine the target data in the data chart, and provide corresponding data operation options for the target data;
    根据对所述数据操作选项进行操作的输入信息,确定对所述目标数据进行调节的第一调节量;Determine the first adjustment amount for adjusting the target data according to the input information for operating the data operation option;
    根据所述第一调节量变更所述目标数据,确定目标数据变更结果。The target data is changed according to the first adjustment amount, and the target data change result is determined.
PCT/CN2020/095288 2019-06-18 2020-06-10 Chart processing method and data processing method, and apparatuses WO2020253584A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201910528180.3 2019-06-18
CN201910528180.3A CN112100990A (en) 2019-06-18 2019-06-18 Chart processing method and device, and data processing method and device

Publications (1)

Publication Number Publication Date
WO2020253584A1 true WO2020253584A1 (en) 2020-12-24

Family

ID=73748367

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2020/095288 WO2020253584A1 (en) 2019-06-18 2020-06-10 Chart processing method and data processing method, and apparatuses

Country Status (2)

Country Link
CN (1) CN112100990A (en)
WO (1) WO2020253584A1 (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112860961A (en) * 2021-01-29 2021-05-28 支付宝(杭州)信息技术有限公司 Visual data processing method and device and electronic equipment
CN115705097A (en) * 2021-07-20 2023-02-17 京东方科技集团股份有限公司 Electronic whiteboard and chart display method thereof

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1858742A (en) * 2006-03-17 2006-11-08 华为技术有限公司 Method and system for realizing update data in real time data bank
CN104102407A (en) * 2013-04-08 2014-10-15 上海联影医疗科技有限公司 Parameter input method and system
CN104615669A (en) * 2015-01-15 2015-05-13 浙江绮耘软件有限公司 Data correction method, device and system
CN105005433A (en) * 2014-04-24 2015-10-28 卡西欧计算机株式会社 Graph display control apparatus and graph display control method
CN106575360A (en) * 2014-08-21 2017-04-19 微软技术许可有限责任公司 Enhanced recognition of charted data
CN107861673A (en) * 2017-06-27 2018-03-30 陆金所(上海)科技服务有限公司 Pull pattern input method, device and computer-readable recording medium
US20190130615A1 (en) * 2017-10-30 2019-05-02 Microsoft Technology Licensing, Llc Priority based automatic placement of labels on charts

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1858742A (en) * 2006-03-17 2006-11-08 华为技术有限公司 Method and system for realizing update data in real time data bank
CN104102407A (en) * 2013-04-08 2014-10-15 上海联影医疗科技有限公司 Parameter input method and system
CN105005433A (en) * 2014-04-24 2015-10-28 卡西欧计算机株式会社 Graph display control apparatus and graph display control method
CN106575360A (en) * 2014-08-21 2017-04-19 微软技术许可有限责任公司 Enhanced recognition of charted data
CN104615669A (en) * 2015-01-15 2015-05-13 浙江绮耘软件有限公司 Data correction method, device and system
CN107861673A (en) * 2017-06-27 2018-03-30 陆金所(上海)科技服务有限公司 Pull pattern input method, device and computer-readable recording medium
US20190130615A1 (en) * 2017-10-30 2019-05-02 Microsoft Technology Licensing, Llc Priority based automatic placement of labels on charts

Also Published As

Publication number Publication date
CN112100990A (en) 2020-12-18

Similar Documents

Publication Publication Date Title
US10691284B2 (en) Canvas layout algorithm
CN106575308B (en) Semantic distance-based assignment of data elements to visualization edges
US11126318B2 (en) Filtering popup secondary data visualizations according to selected data from primary data visualizations
CN105247548B (en) User in collaboration workspace system based on application defines workflow
US9330080B2 (en) Methods and systems to facilitate providing spreadsheet and database data to users via a social network
US20080184140A1 (en) Analytics planning in a visual programming environment
US10460485B2 (en) Multi-dimensional data visualization
US20130275904A1 (en) Interactive data visualization and manipulation
US9910574B2 (en) Method and system for visualizing and manipulating graphic charts
US20080168376A1 (en) Visual designer for non-linear domain logic
US20140331179A1 (en) Automated Presentation of Visualized Data
US10282905B2 (en) Assistive overlay for report generation
CN113011400A (en) Automatic identification and insight of data
WO2020253584A1 (en) Chart processing method and data processing method, and apparatuses
KR101798149B1 (en) Chart visualization method by selecting some areas of the data table
US20160300251A1 (en) System and method for mapping and comparing choroplethic housing statistics
US20180253201A1 (en) Systems and methods for a multi-display collaboration environment
US10504065B2 (en) Modeling utilizing staging entity joined with compensation formula table
US20140157099A1 (en) Efficient space allocation for business objects
US20200012409A1 (en) Cognitive composition of multi-dimensional icons
US9483086B2 (en) Business object detail display
US20150082137A1 (en) Creating measures from formula on other measures
US10198836B2 (en) Trellis chart scaling
US11222039B2 (en) Methods and systems for visual data manipulation
US20160180272A1 (en) Collision calendar tool

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 20825413

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 20825413

Country of ref document: EP

Kind code of ref document: A1