WO2018174365A1 - Method for visualizing chart of data table - Google Patents

Abstract

One embodiment of the present invention provides a method for visualizing a chart of a data table, which is implemented in an internet environment, the method comprising the steps of: reading data from a data table; extracting variable types of the data; providing the variable types in the form of graphical input options to a client environment interface; reading a chart generation variable type selected by a user from among the variable types; determining a chart which can be generated, on the basis of the chart generation variable type, and generating the chart using the data; and providing the chart to the client environment interface.

Description

How to visualize charts in data tables

The present invention relates to a method for visualizing a chart of a data table, and more particularly, extracts a variable type from data of an area selected by a user, and determines a chart that can be generated based on a chart generation variable type selected by a user from the extracted variable types. And a chart for generating a chart using the data and providing the chart to a client environment interface.

As the Internet is becoming more common in countries around the world, and the importance of data delivered through them is increasing, various technologies are being developed rapidly to make data utilization more effective.

In particular, recently, a data visualization technology that processes a tabular data such as a spreadsheet into a chart form so that a user can check at a glance has been in the spotlight.

This data visualization technique is largely composed of a technique for acquiring data to be visualized and a technique for visualizing the acquired data on a client environment.

However, conventionally, in order to visualize a large amount of data, the user had to directly select a chart suitable for the data to be visualized, and perform tasks such as setting an axis for drawing a chart.

For this reason, the results of the data visualization are highly dependent on the chart comprehension of the user, and the effort and time required for the data visualization have also been greatly demanded.

Therefore, in order to overcome the limitations of this data visualization, the user simply clicks or drags the data area, extracts the variable type from the selected data, and automatically generates a suitable chart to visualize the data table easily. It is necessary to provide a tool to do this.

The present invention is to solve the above-mentioned problems of the prior art, an object of the present invention is to extract the variable type from the data of the area selected by the user, and can be generated based on the chart generation variable type selected by the user from the extracted variable type It is to provide a chart visualization method of a data table for determining a chart, generating the chart using the data, and providing the chart to a client environment interface.

In order to achieve the above object, an aspect of the present invention is a chart visualization method of a data table, which is implemented in an Internet environment, comprising: reading data from a data table; Extracting a variable type of the data; Providing the variable type in the form of a graphical input option to a client environment interface; Among the variable types, reading a chart generation variable type selected by a user; Determining a chart that can be generated based on the chart generation variable type, and generating the chart using the data; And providing the chart to a client environment interface.

In one embodiment, a method of visualizing a chart of a data table, implemented in an internet environment, comprising: displaying the data table in a client environment; Reading data of an area selected by a user from the data table; Extracting a variable type of the data; Providing the variable type in the form of a graphical input option to a client environment interface; Among the variable types, reading a chart generation variable type selected by a user; Determining a chart that can be generated based on the chart generation variable type, and generating the chart using the data; And providing the chart to a client environment interface.

In one embodiment, the step of extracting the variable type of the data may be a chart visualization method of the data table, characterized in that the parsing of the data.

In an embodiment, the step of extracting the variable type of the data may be performed by reading a variable type of each cell unit from a spreadsheet format data and extracting the most frequent variable type in row and column units from the data. The method may be a chart visualization method of a data table.

In an embodiment, the step of providing the variable type in the form of a graphical input option to a client environment interface may include classifying the variable type into a categorical variable type representing a specific type and a numeric variable type representing a numeric value. In addition, the categorical variable type and the numerical variable type may be chart visualization methods of a data table, wherein the tabs are configured as separate tabs.

In one embodiment, the chart includes a bar chart, a line chart, a scatter chart, a tree map chart, a pie chart, parallel coordinates ( It may be a chart visualization method of a data table, characterized in that at least one of Cartesian Coordinates and Coordinates Map.

In addition, in order to achieve the above object, another aspect of the present invention is a chart visualization method of a data table, which is implemented in an Internet environment, comprising: reading data from a data table; The data is in spreadsheet format, and the variable type of data stored in the first cell of each row in the data is extracted as the header of the row, and the variable type of data stored in the first cell of each column in the data is the header of the column. Extracting with; Providing the header in the form of a graphical input option to a client environment interface; Among the headers, reading a chart generation header selected by a user; Determining a chart that can be generated based on the chart generation header, and generating the chart using the data; And providing the chart to a client environment interface.

In one embodiment, a method of visualizing a chart of a data table, implemented in an internet environment, comprising: displaying the data table in a client environment; Reading data of an area selected by a user from the data table; The area is in a spreadsheet format, and the variable type of data stored in the first cell of each row in the area is extracted as the header of the row, and the variable type of data stored in the first cell of each column in the area is the header of the column. Extracting with; Providing the header in the form of a graphical input option to a client environment interface; Among the headers, reading a chart generation header selected by a user; Determining a chart that can be generated based on the chart generation header, and generating the chart using the data; And providing the chart to a client environment interface.

According to an embodiment, the variable type of data stored in the first cell of each row in the region is extracted as the header of the row, and the variable type of data stored in the first cell of each column in the region is extracted as the header of the column. The step of performing may be a chart visualization method of the data table, characterized in that made through the parsing of the data.

In one embodiment, providing the header in the form of a graphical input option to a client environment interface comprises: dividing the header into a categorical header representing a particular type and a numeric header representing a numeric value, wherein the categorical includes: It may be a chart visualization method of a data table, wherein the header and the numeric header are configured as separate tabs.

In one embodiment, the chart includes a bar chart, a line chart, a scatter chart, a tree map chart, a pie chart, parallel coordinates ( It may be a chart visualization method of a data table, characterized in that at least one of Cartesian Coordinates and Coordinates Map.

In order to achieve the above object, another aspect of the present invention is a computer readable memory device that stores instructions for chart visualization of a data table, implemented in an Internet environment, the step of reading data from the data table ; Extracting a variable type of the data; Providing the variable type in the form of a graphical input option to a client environment interface; Among the variable types, reading a chart generation variable type selected by a user; Determining a chart that can be generated based on the chart generation variable type, and generating the chart using the data; And providing the chart to a client environment interface.

A computer readable memory device having instructions stored for chart visualization of a data table, implemented in an internet environment, comprising: displaying a data table in a client environment; Reading data of an area selected by a user from the data table; Extracting a variable type of the data; Providing the variable type in the form of a graphical input option to a client environment interface; Among the variable types, reading a chart generation variable type selected by a user; Determining a chart that can be generated based on the chart generation variable type, and generating the chart using the data; And a computer readable memory device performing the step of providing the chart to a client environment interface.

According to an aspect of the present invention, by receiving the user's selection of the entire data table or the data table to extract the variable type of the selected data, thereby generating a chart and providing it to the user, without having to understand the chart type in detail With a simple selection operation, you can provide a chart that fits the nature of your data.

Further, by simultaneously providing a plurality of charts suitable for the selected data, it is possible to improve the utilization of the data visualization data.

In addition, since the data variable type of the selected area is recognized without the user directly recognizing the variable type of the data, a chart suitable for this may be automatically generated.

The effects of the present invention are not limited to the above-described effects, but should be understood to include all the effects deduced from the configuration of the invention described in the detailed description or claims of the present invention.

1 is a flowchart of a chart visualization method of a data table according to an embodiment of the present invention.

2 is a flowchart of a chart visualization method of a data table according to another embodiment of the present invention.

3 is a schematic diagram illustrating a chart visualization method of a data table according to an embodiment of the present invention.

4 is a flowchart of a chart visualization method of a data table according to another embodiment of the present invention.

5 is a flowchart of a chart visualization method of a data table according to another embodiment of the present invention.

6 is a block diagram of an exemplary computing operating environment in which embodiments of the present invention may be implemented.

Hereinafter, with reference to the accompanying drawings will be described the present invention. As those skilled in the art would realize, the described embodiments may be modified in various different ways, all without departing from the spirit or scope of the present invention. In the drawings, parts irrelevant to the description are omitted in order to clearly describe the present invention, and like reference numerals designate like parts throughout the specification.

Throughout the specification, when a part is "connected" to another part, it includes not only "directly connected" but also "indirectly connected" with another member in between. . In addition, when a part is said to "include" a certain component, this means that it may further include other components, without excluding the other components unless otherwise stated.

While embodiments will be described in terms of program modules in general contexts executed in conjunction with application programs running on the operating system of the computing device, those skilled in the art will appreciate that aspects may also be implemented in conjunction with other program modules.

Generally, program modules include routines, programs, components, data structures, and other types of structures that perform particular tasks or implement particular abstract data types. In addition, those skilled in the art can be practiced with other computer system configurations including handheld devices, multiprocessor systems, microprocessor-based or programmable consumer electronics, minicomputers, mainframe computers, and comparable computing devices. You will know. Embodiments may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote memory storage devices.

Embodiments may be implemented in a computer implemented process (method), computing system, or article of manufacture, such as a computer program product or computer readable medium. The computer program product may be a computer storage medium that is readable by a computer system and encodes a computer program that includes instructions that cause a computer or computing system to perform the example process (s). The computer readable storage medium is a computer readable memory device.

The computer readable storage medium may be implemented, for example, via one or more of volatile computer memory, nonvolatile memory, hard drive, flash drive, floppy disk or compact disk, and comparable hardware media.

Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings.

1 and 2 are flowcharts of a chart visualization method of a data table according to an embodiment of the present invention, Figure 3 is a schematic diagram showing a chart visualization method of a data table according to an embodiment of the present invention.

1 to 3, a method for visualizing a chart of a data table according to an embodiment of the present invention is implemented in an internet environment. The method for visualizing a chart of a data table includes: reading data from a data table (S110); Extracting a variable type of the data (S120); Providing the variable type in the form of a graphical input option to a client environment interface (S130); Reading the chart generation variable type selected by the user among the variable types (S140); Determining a chart that can be generated based on the chart generation variable type, and generating the chart using the data (S150); And providing the chart to a client environment interface (S160).

In addition, the chart visualization method of the data table according to another embodiment of the present invention is implemented in an internet environment, the method of chart visualization of the data table, the step of displaying the data table in the client environment (S210); Reading data of an area selected by a user from the data table (S220); Extracting a variable type of the data (S230); Providing the variable type in the form of a graphical input option to a client environment interface (S240); Reading the chart generation variable type selected by the user among the variable types (S250); Determining a chart that can be generated based on the chart generation variable type, and generating the chart using the data (S260); And providing the chart to a client environment interface (S270).

When the method for visualizing a chart of a data table according to an embodiment of the present invention is implemented in an internet environment, it may mean that the method is implemented in an internet environment based on a network.

The network may be configured without regard to its networking aspects such as wired and wireless. For example, a local area network (LAN), a metropolitan area network (MAN), a wide area network (WAN), etc. can be composed of a variety of communication networks, preferably in the present invention It can consist of internets connected between countries around the world.

The network may include any topology of servers, clients, Internet service providers, and communication media. The system according to the embodiments described in the present invention may have a static or dynamic topology. The network may include a secure network such as an enterprise network, an unsecure network such as a wireless open network, or the Internet. The network may also coordinate communications over other networks, such as a public switched telephone network (PSTN) or a cellular network. In addition, the network may include a short range wireless network such as Bluetooth. The network provides communication between the nodes described herein. For example, the network may include wireless media such as acoustic, RF, infrared and other wireless media.

In addition, in order to execute the method for visualizing the chart of the data table according to an embodiment of the present invention, accessing the Internet environment may be performed through a web browser.

A web browser is a program that displays various information provided on the Internet through a web page. For example, when the operating system is installed, such as 'Internet Explorer', the web browser may be installed together in the memory of each client environment. It may be installed in the memory of the client environment according to the customer request.

Referring to FIG. 1, in step S110 of reading data from a data table, the data table may be a data table searched on a database established on the Internet.

The database constructed on the Internet may be a public database provided by a public institution such as a city unit, a city unit, or the like.

The data table may be a data table uploaded from a database stored in a computing device.

That is, it may be a data file uploaded by a simple selection operation of the user.

In the step S210 of displaying the data table in the client environment, the client environment may include an engine that performs chart visualization of the data table described in the detailed description of the present invention. In one embodiment, the client environment obtains data from local or remote storage, such as memory or a server, the Internet, or the like. In another embodiment, data is generated in the client environment using an application program running in the client environment.

The client environment can be configured to obtain input or feedback from the user or other entity and apply it. Feedback can be interpreted in the client environment to understand the user's or other entity's preferences for output. Input or feedback may be obtained directly from the user or other entity and / or in response to one or more prompts that may be generated by the client environment. Based on this input or feedback, the client environment can generate work order information.

While the subject matter described in the present invention is presented in the general scope of program modules executed in conjunction with the execution of operating systems and applications on client environments, those skilled in the art will recognize that other implementations in combination with other types of program modules may implement different implementations. It will be appreciated that examples may be performed. Generally, program modules include routines, programs, components, data structures, and other types of structures that perform particular tasks or implement particular abstract data types. Furthermore, those skilled in the art will appreciate that the subject matter described herein is a communication device and a mobile phone, smart that can be connected to an external server through a network, such as an IPTV including a desktop PC, tablet PC, laptop PC, set-top box. All types of handheld based wireless communication devices, multiprocessor systems, microprocessors that can be connected to external servers via a network such as phones, personal digital assistants (PDAs), portable multimedia players (PMPs), tablet PCs, etc. It will be appreciated that the implementation may be in a client environment configuration, including base or programmable consumer electronics, minicomputers, mainframe computers, and the like.

Displaying the data table in the client environment (S210) is a step of loading the data table on the dashboard of the client environment, based on the Internet environment. The data table may be a spreadsheet method in which data is stored in units of cells.

Variable types can be assigned to data stored in each cell. Variable types can represent attributes of the data, for example categorical variable types, ages, and heights, which are classified into certain predetermined types, such as gender (male and female), and class (bottle, sick, sick, sick). , Weight, etc. can be classified into numeric variable types.

In operation S220 of reading data of an area selected by the user from the data table, the device receiving the user's selection may be hardware including a camera, a microphone, a touch driving screen, a keyboard, a mouse, and the like.

The device receiving the user's selection may communicate with an external resource such as a cloud-hosted platform to retrieve data in the data table. The cloud host platform may include remote resources including data storage and content servers.

In addition, the device receiving input of the user may, in addition to the touch drive device, incorporate other input mechanisms such as optical gesture capture, gyroscope input device, mouse, keyboard, eye tracking input, and comparable software and / or hardware based technologies. Can be achieved.

The selection operation of the user may be to click or drag a partial area 200 on the data table 100, and the partial area 200 may be a single area or an area including a plurality of data cells. Can be.

The following steps may be performed on the selected data through the step S220 of reading data of the area selected by the user from the data table.

In this way, efficient chart visualization can be performed only for the area selected by the user, regardless of the data capacity or the purification state.

Extracting the variable type of the data (S120, S230) may be performed through parsing the data.

Parsing data refers to a parsing process in which a computer acting as a parser classifies a string of sentence units into a token that is considered meaningful and reconstructs it into a parse tree. In the parsing process, a series of strings, which are only signs, are translated into machine language and become meaningful units of meaning.

On the other hand, parsing is a task of detaching a semantic unit in a sentence arranged as a series of characters, and may include an act of determining and classifying a hierarchy such as whether the semantic unit is a central element or an interlaced element.

In this way, charts suitable for the variable type can be automatically generated without the user directly understanding the variable type of the data.

Therefore, a chart suitable for the nature of the data can be generated regardless of the user's understanding of the data or the understanding of the chart.

According to one embodiment, the step of extracting the variable type of the data (S120, S230), reading the variable type of each cell unit from the spreadsheet format data, the least variable type in the row unit and column unit in the data By extracting

That is, referring to FIG. 3, for the partial region 200 selected by the user from the data table 100, all variable types of each cell unit included in the partial region 200 are read, and then, the row unit and the column. You can select the variable type that appears the most as a unit and extract it as the representative variable type for that row or column.

As a result, the user's intuitive understanding and selection of the partial region 200 may be reflected in the chart visualization, and a chart may be automatically generated according to the user's preferences or utilization.

In the step (S130, S240) of providing the variable type in the form of graphical input options to the client environment interface, the client environment interface is a computer, in particular, an interface for interaction and information exchange between a computer and a user (human). Also called human-computer interaction (HCI) or man-machine interface (MMI), these client environment interfaces can provide two ways of input and output.

The input defines how the user manipulates the system, and the output can be a means for presenting the results generated by the system according to the user's operation. The client environment interface according to an embodiment of the present invention may be designed so that the user can easily find and use the necessary elements and easily obtain accurate results based on psychology and physiology.

The client environment interface according to an embodiment of the present invention includes both a graphic, text, and voice information displayed by a program to a user and an interaction method for a user control sequence in which the user controls the program.

The client environment interfaces include graphical user interface (GUI), web user interface (WUI), command-line interface (CLI), batch interface, and touch interface ( touch interface), voice user interface, and the like.

Providing the variable type in the form of graphical input options to the client environment interface (S130, S240), divides the variable type into a categorical variable type representing a specific type and a numeric variable type representing a numerical value, The categorical variable type and the numeric variable type may be configured as separate tabs.

This can improve the user's understanding of the chart visualization process of the data table.

Among the variable types, the steps S140 and S250 of reading the chart generation variable type selected by the user may be given a separate label to the chart generation variable type selected by the user, and a separate label may be given in a subsequent step. The chart may be determined based on the chart generation variable type.

Determining a chart that can be generated based on the chart generation variable type, and generating the chart using the data (S150, S260), determines all charts that can be generated based on the chart generation variable type, the user Generating the charts using the data of the selected area.

Charts are visualizations based on databases, for example, bar charts, line charts, scatter charts, tree map charts, pie charts ( Pie chart, parallel coordinates (Cartesian Coordinates), coordinates (Coordinates Map) and graph of the function according to the regression analysis, etc., but is not limited thereto.

According to an embodiment, the minimum condition for generating the bar chart is that the chart generation variable type is one categorical variable type. In this case, a histogram-type chart using the data frequency may be generated.

On the other hand, the optimal condition for generating a bar chart is that the chart generation variable type is one categorical variable type and one numeric variable type. In this case, the categorical variable type may form one axis, and the numeric variable type may form the chart height according to the aggregated data.

According to an embodiment, the minimum condition for generating the line chart is that the chart generation variable type is one categorical variable type. In this case, a histogram-type chart using the data frequency may be generated.

On the other hand, the optimal condition for generating a line chart is that the chart generation variable type is one categorical variable type and one numeric variable type. In this case, the categorical variable type may form one axis, and the numeric variable type may form the chart height according to the aggregated data.

Also, a line may be added whenever one categorical variable type and N numeric variable types are added.

According to an embodiment, the minimum and optimal conditions for generating the scatter chart are two types of chart generation variable types. In this case, the aggregation function for counting the number of data should be disabled.

In addition, whenever one numeric variable type is added, the size of the basic figure constituting the scatter chart shape may be added by one unit, and color may be formed for each basic figure whenever the categorical variable type is added.

According to an embodiment, the minimum condition for generating the treemap chart is that the chart generation variable type is one categorical variable type. In this case, a tree map chart using data frequencies may be generated.

On the other hand, the optimal condition for generating a treemap chart is that the chart generation variable type is one categorical variable type and one numeric variable type. In this case, the categorical variable type may form the basic figure of the treemap chart, and the numeric variable type may form the size of the basic figure according to the aggregated data.

In addition, whenever N categorical variable types are added, a basic figure representing a subordinate concept may be added.

According to an embodiment, the minimum condition for generating the pie chart is that the chart generation variable type is one categorical variable type. In this case, a pie chart may be generated using the data frequency.

On the other hand, the optimal condition for generating a bar chart is that the chart generation variable type is one categorical variable type and one numeric variable type. In this case, the categorical variable type may form a pie, and the numeric variable type may form an angle for dividing the inside of the pie chart according to the aggregated data.

According to an embodiment, the minimum condition for generating the parallel coordinate chart is that the chart generation variable type is two numeric variable types. In this case, each of the numerical variable types forms an axis, and individual values may indicate positions of data values in the form of lines.

In addition, by adding one categorical variable type, individual lines can be aggregated and displayed by category.

Furthermore, when adding N categorical variable types, a separate axis may be additionally formed.

According to an embodiment, the minimum condition for generating the coordinate map chart is that the chart generation variable type is one categorical variable type. In this case, when the data indicates a specific position, a basic figure such as a bubble may be formed in the position of the specific position coordinate value.

Meanwhile, the optimal condition for generating a bar chart is that the chart generation variable type has two categorical variable types. In this case, each of the categorical variable types may represent a position along each axis of the coordinate map.

In addition, when one numeric variable type is added, not only the data position value but also the data amount can be expressed.

In the providing of the chart to the client environment interface (S160 and S270), a graphic user interface (GUI) may be configured with the generated chart, and the graphic user interface may be displayed on an electronic device including a display.

Visualized charts may include three-dimensional (3D) representations, graphics, images, video, and the like, and may be representations of a database, but are not limited in form.

The user may acquire the visualized data of only the desired area among the large amount of data or the unrefined data through the graphical user interface displayed through providing the chart to the client environment interface (S160 and S270).

In addition, since a chart is generated using only a partial area as a database from a large amount of data or unrefined data, computation time is greatly reduced, and data visualization data can be generated quickly.

In addition, it may be to configure a graphical user interface that allows the user to select one or more of the two or more charts.

As a result, the user may be configured to compare the plurality of charts, and then select an optimal chart suitable for data utilization.

4 and 5 are flowcharts of a chart visualization method of a data table according to another embodiment of the present invention.

3 to 5, a chart visualization method of a data table according to another embodiment of the present invention is a chart visualization method of a data table, which is implemented in an internet environment, in which step of reading data from a data table (S310). ; The data is in spreadsheet format, and the variable type of data stored in the first cell of each row in the data is extracted as the header of the row, and the variable type of data stored in the first cell of each column in the data is the header of the column. Extracting to step (S320); Providing the header in the form of a graphical input option to a client environment interface (S330); (S340) reading the chart generation header selected by the user among the headers; Determining a chart that can be generated based on the chart generation header, and generating the chart using the data (S350); And providing the chart to a client environment interface (S360).

In addition, the method for visualizing a chart of a data table according to another embodiment of the present invention may be implemented in an internet environment. The method for visualizing a chart of a data table may include: displaying a data table in a client environment (S410); Reading data of an area selected by a user from the data table (S420); The area is in a spreadsheet format, and the variable type of data stored in the first cell of each row in the area is extracted as the header of the row, and the variable type of data stored in the first cell of each column in the area is the header of the column. Extracting to step (S430); Providing the header in the form of a graphical input option to a client environment interface (S440); Among the headers, reading a chart generation header selected by the user (S450); Determining a chart that can be generated based on the chart generation header, and generating the chart using the data (S460); And providing the chart to a client environment interface (S470).

Duplicate descriptions will be omitted below.

The data or region is in spreadsheet format, and extracts the variable type of data stored in the first cell of each row in the data or region as the header of the row, and the variable type of data stored in the first cell of each column in the region. In the step (S320, S430) of extracting the header of the column, the cell is a basic area into which data is input in a spreadsheet program or the like, by the intersection of rows and columns having a horizontal and vertical grid shape constituting the basic form of the spreadsheet. It can mean a rectangular area to be created.

Referring to FIG. 3, the header of the first row is data 2 310, the header of the second row is data 7 340, the header of the third row is data 12 350, and the header of the fourth row. The header is data 17 (360).

The header of the first column is data 2 310, the header of the second column is data 3 320, and the header of the third column is data 4 330.

Through this step, the user's area selection can be intuitively reflected in the chart visualization.

According to an embodiment, the variable type of data stored in the first cell of each row in the region is extracted as the header of the row, and the variable type of data stored in the first cell of each column in the region is extracted as the header of the column. The step may be performed through parsing the data.

According to an embodiment, the providing of the header in the form of a graphical input option to the client environment interface may include classifying the header into a categorical header representing a specific type and a numeric header representing a numerical value. The categorical header and the numeric header may be configured as separate tabs.

In addition, according to an embodiment, the chart includes a bar chart, a line chart, a scatter chart, a tree map chart, a pie chart, and a parallel chart. The coordinates may be one or more of Cartesian Coordinates and Coordinates Map.

6 is a block diagram of an exemplary computing operating environment in which embodiments of the present invention may be implemented.

Referring to FIG. 6, another embodiment of the present invention provides a computer readable memory device having instructions stored for chart visualization of a data table, which is implemented in an internet environment, the method comprising: displaying a data table in a client environment; Reading data of an area selected by a user from the data table; Extracting a variable type of the data; Providing the variable type in the form of a graphical input option to a client environment interface; Among the variable types, reading a chart generation variable type selected by a user; Determining a chart that can be generated based on the chart generation variable type, and generating the chart using the data; And a computer readable memory device performing the step of providing the chart to a client environment interface.

In addition, the computing device 900 may include at least one processing device 920 and a system memory 910.

Computing device 900 may also include a plurality of processing devices that cooperate in executing a program. Depending on the exact configuration and type of computing device, system memory 910 may be volatile (eg, RAM), nonvolatile (eg, ROM, flash memory, etc.) or some combination of the two.

System memory 910 typically includes, but is not limited to, operating system 911 suitable for controlling the operation of platforms such as Microsoft's WINDOWS®, or WINDOWS PHONE® operating system, including, but not limited to, Apple's Mac OX, It can be UNIX, Linux, IRIX, AIX, or HP-UX.

That is, software that controls the hardware, manages the environment of the computing device 900, facilitates the use of the computing device 900, facilitates the execution of the program modules 912, and acts as an intermediary between the user and the hardware. And all are included in operating system 911.

System memory 910 may also include one or more software, such as program module 912, chart visualization module 913.

Chart visualization module 913 may detect an interaction that interacts with the displayed chart. In addition, the interaction may be classified into any one of an input operation, an update operation, a removal operation, a turning operation, and a click operation, and may be converted into attributes assigned to each operation.

In addition, the chart visualization module 913 may be configured such that, for the chart elements forming the independent chart and the dependent chart, values are input on the chart elements, the chart elements are updated to match the parameter dataset, and the chart elements are It can be said that the expression of the chart element changes as it is deleted, the chart element is rotated, and the chart element is clicked.

Further, the chart visualization module 913 may express the interaction as one of the chart elements that make up the independent chart and the dependent chart. The chart elements may be enlarged, reduced, merged, split, zoomed in, zoomed out, or style changed. have.

In addition, the chart visualization module 913 can execute the interactions that have been made to the chart and update the chart to display associated changes.

Computing device 900 may have additional features or functionality. For example, computing device 900 may also include additional data storage devices (removable and / or non-removable) such as, for example, magnetic disks, optical disks, or tapes. Such additional reservoirs are shown in FIG. 6 as removable reservoir 950 and non-removable reservoir 960.

Computer-readable storage media may include volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules, or other data. .

The computer readable storage medium is a computer readable memory device. System memory 910, removable storage 950 and non-removable storage 960 are all examples of computer readable storage media. Computer-readable storage media may include RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage. The device may include, but is not limited to, any other medium that may be used to store desired information and that may be accessed by the computing device 900.

Any such computer readable storage media can be part of computing device 900. Computing device 900 may also have input device (s) 930 such as a keyboard, mouse, pen, voice input device, touch input device, and comparable input device.

Output device (s) 940 may be included, such as displays, speakers, printers, and other types of output devices. These devices are all well known in the art and need not be discussed at length here.

Computing device 900 also includes a communication connection 970 that enables the device to communicate with other computing devices 980, such as through a wireless network, satellite link, cellular link, and similar mechanisms in a distributed computing environment. do.

Other device 980 can include a computer device (s) running a communications application, a storage server, and a comparable device. Communication connection 970 is an example of communication media. Communication media may include computer readable instructions, data structures, program modules, or other data in a modulated data signal, such as a carrier wave or other transport mechanism, and may include any information delivery media. The term "modulated data signal" means a signal that has one or more of its characteristics set or changed in such a manner as to encode information in the signal. By way of example, and not limitation, communication media includes wired media such as a wired network or direct wired connection, and wireless media such as acoustic, RF, infrared, and other wireless media.

Example embodiments also include a method. These methods can be implemented in any number of ways, including the structures described herein. One such method is by machine operation of an apparatus of the type described herein.

Another optional method is that one or more of the individual operations of the method are performed and one or more human operators perform some. These human operators don't have to be in the same location, they just need to be with machines that each run a part of the program.

The foregoing description of the present invention is intended for illustration, and it will be understood by those skilled in the art that the present invention may be easily modified in other specific forms without changing the technical spirit or essential features of the present invention. will be. Therefore, it should be understood that the embodiments described above are exemplary in all respects and not restrictive. For example, each component described as a single type may be implemented in a distributed manner, and similarly, components described as distributed may be implemented in a combined form.

The scope of the present invention is represented by the following claims, and it should be construed that all changes or modifications derived from the meaning and scope of the claims and their equivalents are included in the scope of the present invention.

[Description of the code]

S110: reading data from the data table

S120: extracting the variable type of the data

S130: providing the variable type in the form of a graphical input option to a client environment interface

S140: reading the chart generation variable type selected by the user from among the variable types

S150: determining a chart that can be generated based on the chart generation variable type, and generating the chart using the data

S160: providing the chart to a client environment interface

Claims (13)

As a method of visualizing charts of data tables, implemented in an internet environment, Reading data from a data table; Extracting a variable type of the data; Providing the variable type in the form of a graphical input option to a client environment interface; Among the variable types, reading a chart generation variable type selected by a user; Determining a chart that can be generated based on the chart generation variable type, and generating the chart using the data; And Providing the chart to a client environment interface. As a method of visualizing charts of data tables, implemented in an internet environment, Displaying a data table in a client environment; Reading data of an area selected by a user from the data table; Extracting a variable type of the data; Providing the variable type in the form of a graphical input option to a client environment interface; Among the variable types, reading a chart generation variable type selected by a user; Determining a chart that can be generated based on the chart generation variable type, and generating the chart using the data; And Providing the chart to a client environment interface. The method according to claim 1 or 2, Extracting the variable type of the data is through the parsing of the data chart visualization method of the data table. The method according to claim 1 or 2, Extracting the variable type of the data, Read variable type of each cell from spreadsheet data, And extracting the most frequent variable type in the row unit and the column unit from the data. The method according to claim 1 or 2, Providing the variable type in the form of graphical input options to the client environment interface, The table is divided into categorical variable types representing a specific type and a numeric variable type representing a numerical value, and the categorical variable type and the numerical variable type are configured in separate tabs, respectively. Chart visualization method. The method according to claim 1 or 2, The charts include bar charts, line charts, scatter charts, tree map charts, pie charts, parallel charts and cartesian coordinates. Chart visualization method of a data table, characterized in that at least one of (Coordinates Map). As a method of visualizing charts of data tables, implemented in an internet environment, Reading data from a data table; The data is in spreadsheet format, and the variable type of data stored in the first cell of each row in the data is extracted as the header of the row, and the variable type of data stored in the first cell of each column in the data is the header of the column. Extracting with; Providing the header in the form of a graphical input option to a client environment interface; Among the headers, reading a chart generation header selected by a user; Determining a chart that can be generated based on the chart generation header, and generating the chart using the data; And Providing the chart to a client environment interface. As a method of visualizing charts of data tables, implemented in an internet environment, Displaying a data table in a client environment; Reading data of an area selected by a user from the data table; The area is in a spreadsheet format, and the variable type of data stored in the first cell of each row in the area is extracted as the header of the row, and the variable type of data stored in the first cell of each column in the area is the header of the column. Extracting with; Providing the header in the form of a graphical input option to a client environment interface; Among the headers, reading a chart generation header selected by a user; Determining a chart that can be generated based on the chart generation header, and generating the chart using the data; And Providing the chart to a client environment interface. The method according to claim 7 or 8, Extracting the variable type of data stored in the first cell of each row in the region as the header of the row, and extracting the variable type of data stored in the first cell of each column in the region as the header of the column Chart visualization method of a data table, characterized in that through the parsing. The method according to claim 7 or 8, Providing the header in the form of graphical input options to the client environment interface, And dividing the header into a categorical header representing a specific type and a numeric header representing a numerical value, wherein the categorical header and the numeric header are configured as separate tabs. The method according to claim 7 or 8, The charts include bar charts, line charts, scatter charts, tree map charts, pie charts, parallel charts and cartesian coordinates. Chart visualization method of a data table, characterized in that at least one of (Coordinates Map). A computer readable memory device having stored thereon instructions for chart visualization of data tables, implemented in an internet environment, comprising: Reading data from a data table; Extracting a variable type of the data; Providing the variable type in the form of a graphical input option to a client environment interface; Among the variable types, reading a chart generation variable type selected by a user; Determining a chart that can be generated based on the chart generation variable type, and generating the chart using the data; And And presenting the chart to a client environment interface. A computer readable memory device having stored thereon instructions for chart visualization of data tables, implemented in an internet environment, comprising: Displaying a data table in a client environment; Reading data of an area selected by a user from the data table; Extracting a variable type of the data; Providing the variable type in the form of a graphical input option to a client environment interface; Among the variable types, reading a chart generation variable type selected by a user; Determining a chart that can be generated based on the chart generation variable type, and generating the chart using the data; And And presenting the chart to a client environment interface.

Images