WO2018194349A1

WO2018194349A1 - Method for visualizing chart through selection of partial area of data table

Info

Publication number: WO2018194349A1
Application number: PCT/KR2018/004451
Authority: WO
Inventors: 정병준; 임준원; 임지현
Original assignee: 주식회사 뉴스젤리
Priority date: 2017-04-17
Filing date: 2018-04-17
Publication date: 2018-10-25
Also published as: KR101798149B1

Abstract

One embodiment of the present invention provides a method for visualizing a chart through selection of a partial area of a data table, which is implemented in an Internet environment, the method comprising: a data table setup step for fetching a data table on a dashboard; an interaction reception step for receiving an interaction with a partial area of the data table; a chart generation step for generating a chart, using a database constructed from the partial area which is given the interaction; and a chart display step for configuring a graphical user interface (GUI) from the chart and displaying the GUI on an electronic device comprising a display.

Description

How to visualize a chart by selecting some areas of a data table

The present invention relates to a method for visualizing a chart by selecting a partial region of a data table. More particularly, the present invention relates to a chart for generating a chart using only a data region to which an interaction by a user is given as a database, and generating a chart using the graphical user interface (GUI). It is related to the method of constructing and displaying).

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.

In this regard, there is a need for a user to visualize a large amount of data or unrefined data by selecting only a partial area according to the user's purpose and application direction.

Therefore, in order to meet the needs of the user, a chart is generated using only the data area to which the user has been interacted with as a database, and a tool for constructing and displaying the graphic user interface (GUI) is provided. It is necessary.

The present invention is to solve the above-mentioned problems of the prior art, an object of the present invention is to generate a chart using only the data area to which the interaction is given by the user as a database and to a graphical user interface (GUI) It is to provide a way to configure and display.

In order to achieve the above object, an aspect of the present invention is a chart visualization method through the selection of some areas of the data table, which is implemented in the Internet environment, comprising: a data table setup step of loading a data table on a dashboard; An interaction receiving step of receiving an interaction with respect to a partial region of the data table; A chart generation step of generating a chart using the partial region to which the interaction is given as a database; And a chart display step of configuring a graphical user interface (GUI) with the chart and displaying the graphical user interface on an electronic device including a display.

In an exemplary embodiment, the interaction may include clicking, dragging, or inputting a position of the partial region, wherein the partial region is a single region. It may be a visualization method.

In an embodiment, the interaction may include clicking, dragging, or inputting a position of the partial region, wherein the partial region is a plurality of regions, and the plurality of regions. May be a chart visualization method, wherein the chart is located at a location spaced apart from each other in the data table.

In one embodiment, the chart generation step, in the database, recognizes the data stored in the first row as a column name, the data in each column to the variable type data according to the column name It may be a chart visualization method characterized in that the recognition.

In one embodiment, the chart generation step, in the database, recognizes the data stored in the first column as a row name, and the data in each row as variable type data according to the row name. It may be a chart visualization method characterized in that the recognition.

According to an embodiment, in the database, data stored in a specific region is recognized as a column name or a row name according to a user's selection, and data stored in the specific region is referred to as a column name. If it is recognized, the data in the column to which the region belongs is recognized as variable type data according to the column name. If the data stored in the specific region is recognized as the row name, the data in the row to which the region belongs is the variable according to the row name. It may be a chart visualization method characterized in that recognized as type data.

In one embodiment, the chart generation step is to generate two or more charts that can be generated from the database, wherein the chart display step is a graphical user interface that allows a user to select one or more of the two or more charts. It may be a chart visualization method characterized in that the configuration.

In addition, in order to achieve the above object, another aspect of the present invention is a computer-readable memory device that stores instructions for visualizing the chart through the selection of some areas of the data table, implemented in the Internet environment, a dash A data table setup step of loading a data table on the board; An interaction receiving step of receiving an interaction with respect to a partial region of the data table; A chart generation step of generating a chart using the partial region to which the interaction is given as a database; And a graphic user interface (GUI) using the chart to perform a chart display step of displaying the graphic user interface on an electronic device including a display.

According to an aspect of the present invention, a chart is generated using only a data area to which a user has been interacted with as a database, and is configured and displayed as a graphical user interface (GUI) to display a large amount of data or unrefined data. You can visualize only the area you want.

According to an aspect of the present invention, the data stored in the first row is recognized as a column name for a partial region to which an interaction by a user is given, and the data in each column is assigned to the column name. By recognizing the variable type data accordingly, errors in recognition of the data in the column can be greatly reduced.

According to another aspect of the present invention, by recognizing data stored in the first column as a row name in the database, and recognizing data in each row as variable type data according to the row name. As a result, errors in recognition of data in a row can be significantly reduced.

Furthermore, according to another aspect of the present invention, by configuring a graphical user interface that allows the user to select one or more of the two or more charts, it is possible to provide the user with various types of charts that can be generated based on the database. .

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 illustrating a method of visualizing a chart by selecting some regions of a data table according to an embodiment of the present invention.

2 is a schematic diagram showing an interaction according to an embodiment of the present invention.

3 is a schematic diagram showing an interaction according to another embodiment of the present invention.

4 is a schematic diagram illustrating a method of recognizing data in a chart generation step according to an embodiment of the present invention.

5 is a schematic diagram illustrating a method of recognizing data in a chart generation step 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.

Prior to the description, the meaning of terms used in the present specification will be briefly described. It is to be noted that the terminology is provided for the purpose of understanding the specification and is not used to limit the technical spirit of the present invention unless it is explicitly described as limiting the present invention.

- 셀 (Cell)Cell

It is a basic area where data is input in a spreadsheet program, etc., and is a rectangular area created by the intersection of rows and columns, which are horizontal and vertical grids, which form the basic form of a spreadsheet.

- 필드 (Field)Field

A range of fixed locations within a set of data, such as a computer command. For example, it may mean a designated area used for a specific kind of data in one record.

- 클라이언트 환경 (Client environment)Client environment

It is possible to run an engine that performs chart visualization described in the detailed description of the 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.

- 네트워크 (Network)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.

- 웹 브라우저 (Web browser)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.

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

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.

Referring to FIG. 1, the method for visualizing a chart according to an embodiment of the present invention includes a data table setup step (S100) of loading a data table on a dashboard, and an interaction reception step of receiving an interaction for a partial region of the data table ( S200); A chart generation step (S300) of generating a chart using a partial region to which an interaction is given as a database; And a chart display step (S400) of configuring a graphical user interface (GUI) with a chart and displaying the graphical user interface on an electronic device including a display.

Data table setup step (S100) is a step of loading a data table on the dashboard of 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.

The interaction receiving step S200 may receive an interaction applied to a partial region of the data table from the user.

In the interaction receiving step S200, the device in which the interaction is recognized may be hardware including a camera, a microphone, a touch driving screen, a keyboard, a mouse, and the like.

The device on which the interaction is recognized 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 in which the interaction is recognized is achieved in addition to the touch drive device through 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.

Interaction types that can be received in the interaction receiving step (S200) will be described later.

The chart generation step S300 is a step of generating a chart using a partial region to which an interaction is given as a database.

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.

The chart display step S400 may configure a graphical user interface (GUI) using the chart generated in the chart generation step S300 and display the graphic user interface 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 graphic user interface displayed through the chart display step S400.

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.

The chart visualization method according to an embodiment of the present invention may be implemented in an internet environment through a web browser.

In addition, the present invention may be implemented in the form of an application in various kinds of client environments, and data communication may be performed through a network.

Referring to FIG. 2, an interaction according to an embodiment of the present invention may include clicking, dragging, or positioning a portion of the region 110 on the data table 100. It may be input by the user, and this partial region 110 may be a single region.

Referring to FIG. 3, an interaction according to an embodiment of the present invention may include clicking, dragging, or partial region 110 on some

regions

121 and 122 on the data table 100. The location of the user may be input, and the

partial areas

121 and 122 may be a plurality of areas.

In addition, the

partial regions

121 and 122 as the plurality of regions may be at positions spaced apart from each other in the data table 100.

Accordingly, the data is visualized by simply clicking or dragging some desired

areas

110, 121, and 122 on the data table 100 without considering the arrangement or variable type of data on the data table 100 according to the type of chart. Charts can be generated.

Therefore, a chart that can be generated as an area desired by the user can be obtained easily and intuitively, so that user convenience can be greatly improved.

Referring to FIG. 4, the chart generation step S300 according to an embodiment of the present invention recognizes data stored in a first row as a column name in a database, and recognizes data in each column. It may be recognized as variable type data according to the column name.

That is, in the database, data stored in the first row may be recognized as a header. The header is a group of characters placed at the head of the data, and used to identify or control the content and character of the data following it.

As a result, an error in recognition of the data in the column can be greatly reduced.

Referring to FIG. 5, a chart generation step S300 according to an embodiment of the present invention recognizes data stored in a first column as a row name in the database, and recognizes data in each row. May be recognized as variable type data according to the row name.

That is, in the database, data stored in the first column can be recognized as a header.

As a result, an error in recognition of data in a row may be significantly reduced.

In addition, the chart generation step S300 according to an embodiment of the present invention recognizes data stored in a specific area as a column name or a row name according to a user's selection in the database. If the data stored in the area is recognized as a column name, the data in the column to which the area belongs is recognized as variable type data according to the column name.If the data stored in a specific area is recognized as the row name, the area is recognized. The data in the belonging row may be recognized as variable type data according to the row name.

That is, in the database, data stored in a specific area may be recognized as a column name or a row name by a user's click, drag, or position input.

When recognized as a column name, the data in a column to which a specific region belongs can be recognized as variable type data according to the column name by using the recognized column name as a kind of header for identifying or controlling the content and character of the data.

In addition, when recognized as a row name, the data in a row to which a specific region belongs may be recognized as variable type data according to the row name by using the recognized row name as a kind of header for identifying or controlling the content and character of the data.

Through this, data in a column or a row to which the specific region belongs can be effectively recognized without an error such as a misrecognition by using the specific region selected by the user as a header.

Furthermore, by selecting a specific region of the user, whether the region is a column name that is a variable type for data recognition of a column to which the region belongs, a row name that is a variable type for data recognition of a row to which the region belongs, or a corresponding It may be determined whether the variable type is used for data recognition of both the column and the row to which the region belongs.

According to another aspect of the invention, the chart generation step (S300) is to generate two or more charts that can be generated from the database, the chart display step (S400), the user can select one or more of the two or more charts. It may be to configure a graphical user interface.

Two or more charts may be formed depending on the structure of the database, the type of variables the data in the database has, and the independent-dependent relationship.

Therefore, the user can be provided with a plurality of charts that can be formed from the data area as a candidate group by simple interaction such as clicking or dragging a desired data area, and can select a specific chart from among them.

Therefore, meaningful data visualizations can be easily and intuitively obtained from large data or unpurified data to increase data utilization.

Referring to FIG. 6, in a basic configuration, computing device 200 includes at least one processing device 220 and system memory 210.

Computing device 200 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 210 may be volatile (eg, RAM), nonvolatile (eg, ROM, flash memory, etc.) or some combination of the two.

System memory 210 typically includes, but is not limited to, operating system 211 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 200, facilitates the use of the computing device 200, facilitates the execution of the program modules 212, and acts as an intermediary between the user and the hardware. If all are included in the operating system 211.

System memory 210 may also include one or more software, such as program module 212, chart visualization module 213.

The chart visualization module 213 may load a data table on the dashboard and receive interactions for some areas of the data table. In addition, the received interaction can be converted into an attribute given for each interaction.

The chart visualization module 213 may generate a chart using the partial region to which the interaction is applied as a database. The chart visualization module 213 may include a display by configuring a graphical user interface (GUI). The graphic user interface may be displayed on an electronic device.

Further, the chart visualization module 213 recognizes the data stored in the first row as the column name in the database which is the partial region to which the interaction is applied, and the data in each column according to the column name. Chart can be generated by recognizing variable type data.

In addition, the chart visualization module 213 recognizes data stored in the first column as a row name in the database, which is the partial region to which the interaction is applied, and recognizes data in each row according to the row name. You can also create a chart by recognizing it as variable type data.

In addition, the chart visualization module 213 generates two or more charts that can be generated from the database, which is the partial region to which the interactions are made, to construct a graphical user interface that allows the user to select one or more of the two or more charts. Can be.

Computing device 200 may have additional features or functionality. For example, computing device 200 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 250 and non-removable reservoir 260.

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 210, removable storage 250 and non-removable storage 260 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. Device, or any other medium that can be used to store desired information and can be accessed by computing device 200, but is not limited to such.

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

Output device (s) 240 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 200 also includes a communications connection 270 that enables the device to communicate with other computing devices 280, such as through wireless networks, satellite links, cellular links, and similar mechanisms in a distributed computing environment. do.

Other device 280 may include a computer device (s) running a communication application, a storage server, and a comparable device. The communication connection 270 is an example of a communication medium. 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]

S100: data table setup step

S200: Interaction reception step

S300: Chart Generation Step

S400: Chart Display Steps

100: data table

200: computing device

213: Chart Visualization Module

Claims

As a visualization method of chart by selecting a part of data table, which is implemented in internet environment,

A data table setup step of loading a data table on the dashboard;

An interaction receiving step of receiving an interaction with respect to a partial region of the data table;

A chart generation step of generating a chart using the partial region to which the interaction is given as a database; And

And a chart display step of configuring a graphical user interface (GUI) with the chart and displaying the graphical user interface on an electronic device including a display.
The method of claim 1,

The interaction is,

Clicking, dragging or entering the location of the partial region,

And the partial region is a single region.
The method of claim 1,

The interaction is,

Clicking, dragging or entering the location of the partial region,

Wherein the partial region is a plurality of regions, and the plurality of regions are at positions spaced apart from each other in the data table.
The method of claim 1,

The chart generation step,

And recognizing data stored in a first row as a column name in the database, and recognizing data in each column as variable type data according to the column name.
The method of claim 1,

The chart generation step,

And recognizing data stored in a first column as a row name in the database, and recognizing data in each row as variable type data according to the row name.
The method of claim 1,

The chart generation step,

In the database,

According to the user's selection, the data stored in the specific area is recognized as column name or row name.

When data stored in a specific area is recognized as a column name, data in the column to which the area belongs is recognized as variable type data according to the column name.

And recognizing data in a row to which a corresponding area belongs as variable type data according to the row name when data stored in a specific area is recognized as a row name.
The method of claim 1,

The chart generation step,

Generating two or more charts that can be generated from the database,

The chart display step,

And a graphical user interface for allowing a user to select one or more of the two or more charts.
A computer readable memory device having stored thereon instructions for visualizing a chart by selecting some areas of a data table, which is implemented in an internet environment.

A data table setup step of loading a data table on the dashboard;

An interaction receiving step of receiving an interaction with respect to a partial region of the data table;

A chart generation step of generating a chart using the partial region to which the interaction is given as a database; And

And configuring a graphical user interface (GUI) with the chart to display the graphical user interface on an electronic device including a display.