KR102691452B1 - Method for searching data via graphic user interface - Google Patents

Abstract

The present invention relates to a data inquiry method through a GUI, comprising the steps of approving server access from a user terminal; Receiving data table selection information on a database stored in the server; Receiving search condition information for each column created based on the table selection information; Receiving sorting conditions for the search condition information for each column; and generating a query statement for the database according to the data table, search conditions for each column, and sorting conditions; Includes.

Description

How to search data through GUI {METHOD FOR SEARCHING DATA VIA GRAPHIC USER INTERFACE}

The present invention relates to a method of searching data through a GUI, and more specifically, to a method of searching data by creating a query by selecting a menu on a screen displayed on a user terminal for various databases.

Recently, as the environment has become one where a large amount of data can be collected, various databases (DBs) have been established.

For example, in addition to existing financial data, there is a lot of data collected from various sensors, and with the transition to a smart factory, information from various devices and equipment is being built into a database.

Conventionally, in order to input, modify, or delete data recorded in a specific table of a database, it was often updated through web programs such as JSP (Java Server Pages), ASP (Active Server pages), and PHP (Hypertext Preprocessor).

However, in the case of the existing method, if the smart factory manager's ability to use the software was not as professional as the developer's, there was a problem of utility in that it could not be used even after construction.

Accordingly, an environment is being developed where factory managers who want to collect and manage manufacturing data by building or constructing a smart factory can directly query and manage the data, and DB queries can now be used in a GUI (Graphic User Interface) environment.

In the present invention, we will disclose a method for easily creating and executing DB queries in a GUI environment.

The present invention is intended to solve the problems of the prior art described above, and allows users to write query statements through a GUI environment even when they do not know DB queries.

Additionally, the values derived from the query statement can be checked in table form in the program and output in various forms.

In addition, written query statements can be shared through the community, allowing users to acquire their own skills using good example statements.

One embodiment of the present invention relates to a data inquiry method through a GUI, comprising the steps of approving server access from a user terminal; Receiving data table selection information on a database stored in the server; Receiving search condition information for each column created based on the table selection information; Receiving sorting conditions for the search condition information for each column; and generating a query statement for the database according to the data table, search conditions for each column, and sorting conditions; Includes.

In addition, the method of searching data through the GUI may further include outputting data searched according to the generated query statement.

In addition, the step of approving the server connection is characterized by determining whether to approve the server connection based on the database type information, user identification information, and connection IP address of the server to be connected.

In addition, the step of receiving search condition information for each column is generated based on data transmitted from the server to the user terminal, and selects the search condition displayed on the GUI displayed on the user terminal to search for each column from the server. Characterized by receiving search condition information.

In addition, the step of outputting the data searched according to the generated query statement may output the generated query statement and the searched data, and provide an area in which modifications to the generated query statement can be performed. there is.

Another embodiment of the present invention relates to a data inquiry server through a GUI, comprising: a connection management unit that approves a connection from a user terminal; a data management unit that receives data table selection information on a database stored in a server; a search condition management unit that receives search condition information for each column created based on the table selection information and sorting conditions for the search condition information for each column; a query generator that generates a query statement for the database according to the data table, search conditions for each column, and sort conditions; Includes.

In addition, it may further include a query execution unit that outputs data searched according to the generated query statement.

Additionally, the connection management unit determines whether to grant approval based on the database type information, user identification information, and connection IP address of the server to be connected.

Additionally, the search condition management unit is characterized in that it receives search condition information for each column by selecting a search condition displayed on a GUI displayed on the user terminal.

Additionally, the query execution unit may output the generated query statement and searched data, and provide an area where modifications to the generated query statement can be performed.

The present invention is intended to solve the problems of the prior art described above, and allows users to write query statements through a GUI environment even when they do not know DB queries.

According to the present invention, it can be easily utilized by manufacturing companies that have introduced or are planning to introduce smart factories, and by medium-sized/small businesses that do not have their own computer development capabilities.

In addition, it can be easily utilized by manufacturing companies that have already secured a lot of data but are not utilizing it properly, or are aware of the importance of data but have difficulty establishing it.

Additionally, the values derived from the query statement can be checked in table form in the program and output in various forms.

In addition, written query statements can be shared through the community, enabling users to acquire their own skills using good example statements.

1 is a diagram illustrating a database query system through a GUI according to an example of the present invention.
Figure 2 is a diagram showing a database search process through a GUI according to an example of the present invention.
Figure 3 is a block diagram conceptually showing the structure of a server according to an example of the present invention.
Figure 4 is a diagram showing the configuration of a database inquiry screen through a GUI according to an example of the present invention.
Figure 5 is a diagram showing a screen for setting up a connection to a database from a user terminal according to an example of the present invention.
Figure 6 is a diagram showing the configuration of a DB table and column selection screen according to an example of the present invention.
Figure 7 is a diagram showing the configuration of a DB search condition selection screen according to an example of the present invention.
Figure 8 is a diagram showing the configuration of the DB sorting condition screen according to an example of the present invention.
Figure 9 is a diagram showing a DB query output screen according to an example of the present invention.

Below, with reference to the attached drawings, embodiments of the present invention will be described in detail so that those skilled in the art can easily implement the present invention. However, the present invention may be implemented in many different forms and is not limited to the embodiments described herein. In order to clearly explain the present invention in the drawings, parts unrelated to the description are omitted, and similar parts are given similar reference numerals throughout the specification.

Throughout the specification, when a part is said to be “connected” to another part, this includes not only cases where it is “directly connected,” but also cases where it is “electrically connected” with another element in between. . Additionally, when a part is said to “include” a certain component, this means that it may further include other components, rather than excluding other components, unless specifically stated to the contrary.

In this specification, 'part' includes a unit realized by hardware, a unit realized by software, and a unit realized using both. Additionally, one unit may be realized using two or more pieces of hardware, and two or more units may be realized using one piece of hardware. Meanwhile, '~ part' is not limited to software or hardware, and '~ part' may be configured to reside in an addressable storage medium or may be configured to reproduce one or more processors. Therefore, as an example, '~ part' refers to components such as software components, object-oriented software components, class components, and task components, processes, functions, properties, and procedures. , subroutines, segments of program code, drivers, firmware, microcode, circuits, data, databases, data structures, tables, arrays, and variables. The functions provided within the components and 'parts' may be combined into a smaller number of components and 'parts' or may be further separated into additional components and 'parts'. In addition, the components and 'parts' may be implemented to regenerate one or more CPUs within the device or secure multimedia card.

The “user terminal” mentioned below may be implemented as a computer or portable terminal that can connect to a server or other terminal through a network. Here, the computer includes, for example, a laptop, desktop, laptop, etc. equipped with a web browser, and the portable terminal is, for example, a wireless communication device that guarantees portability and mobility. , IMT (International Mobile Telecommunication)-2000, CDMA (Code Division Multiple Access)-2000, W-CDMA (W-Code Division Multiple Access), Wibro (Wireless Broadband Internet), LTE (Long Term Evolution) communication-based terminal, smart It may include all types of handheld-based wireless communication devices such as phones, tablet PCs, etc. Additionally, “network” refers to a wired network, mobile radio communication network, or satellite, such as a Local Area Network (LAN), Wide Area Network (WAN), or Value Added Network (VAN). It can be implemented with any type of wireless network, such as a communication network.

1 is a diagram showing a database query system through a GUI according to an example of the present invention.

Referring to FIG. 1, a database query system through a GUI according to an embodiment of the present invention may include a server 100 and a user terminal 200.

The server 100 according to the present invention is a device that processes a database and is capable of inputting, editing, receiving, and transmitting a database. The server 100 determines whether or not to approve database input, editing, reception, and transmission commands of the user terminal 200, and performs the determined task.

The user terminal 200 according to the present invention includes a desktop 210, a laptop 220, a smartphone 230, a tablet, a personal digital assistant (PDA), and all types of handheld-based wireless communication devices. can do. The user can transmit the image to the server 100 through the user terminal 200.

A network is any wired network, such as a Local Area Network (LAN), Wide Area Network (WAN), or Value Added Network (VAN), or any network, such as a mobile radio communication network or satellite communication network. It can be implemented as any type of wireless network.

Figure 2 is a diagram showing a database search process through a GUI according to an example of the present invention.

As shown in FIG. 2, the server may approve server access from the user terminal (S210). The user can access the server through the user terminal, and the server can decide to approve the connection based on the input user information.

The user can select a data table in the GUI environment displayed on the user terminal, and the server can receive data table selection information on the stored DB (S220). In other words, users can easily process the desired data table by selecting data in the GUI environment provided by the server.

The server receives search condition information for each column created based on the user's table selection information (S230). Users can set the data column they need, and the server can receive search conditions for the selected column.

The server receives sorting conditions for search condition information for each column (S240). By selecting sorting conditions for various data retrieved from the server, the server can sort information that is meaningful to the user.

The server creates a query statement for the DB according to the data table, search conditions for each column, and sorting conditions (S250). The server can output searched data according to the generated query statement.

Figure 3 is a block diagram conceptually showing the structure of a server according to an example of the present invention.

As shown in FIG. 3, the server 100 includes a connection management unit 110, a data management unit 120, a search condition management unit 130, and a query creation unit 140. Although not shown in FIG. 3, a communication unit, a storage unit, a power unit, and an input/output unit may be further included to ensure smooth operation of the server 100.

The connection management unit 110 according to an example of the present invention approves the connection from the user terminal. The connection management unit 110 may determine whether to approve the connection based on the database type information, user identification information, and connection IP address of the server to be connected.

The data management unit 120 according to an example of the present invention receives data table selection information on a database stored in a server. The data management unit 120 may receive search condition information for each column by selecting the search condition displayed on the GUI displayed on the user terminal.

The search condition management unit 130 according to an example of the present invention receives search condition information for each column created based on table selection information and sorting conditions for the search condition information for each column.

The query generator 140 according to an example of the present invention generates a query statement for the database according to the data table, search conditions for each column, and sort conditions.

The server 100 may further include a query execution unit (not shown) that outputs searched data according to the generated query statement. The generated query statement and searched data can be output, and an area where modifications to the generated query statement can be performed can be provided.

Figure 4 is a diagram showing the configuration of a database inquiry screen through a GUI according to an example of the present invention.

Figure 4 is an example of a screen displayed on a user terminal, and is a GUI (Graphic User Interface) for searching a database.

The DB query program running on the user terminal includes program menu (210), company logo (220), database table information (230), program settings window (240), query creation window (250), and query result window (260). It can be configured as a layout.

The program menu (210) may display the working name of the program that the user is working on, and the company logo (220) may display information about the company that owns the database. In addition, the database table information (230) may display the table information of the selected DB in a hierarchical structure, and the program setting window (240) may be a screen area that receives conditions from the user. The query generation window (250) is a window that displays a query statement generated according to conditions, and the query result window (260) is a window that displays an output value when the query statement is executed.

The data inquiry process through the GUI can largely be comprised of connection (Step 1), table selection (Step 2), search conditions (Step 3), sorting method (Step 4), and query output (Step 5). Hereinafter, the GUI The configuration of each screen will be described in detail according to the database search process through .

Figure 5 is a diagram showing a screen for setting up a connection to a database from a user terminal according to an example of the present invention.

During the access approval process, the user can select the type of DB they wish to access. For example, you can select the type of DB such as MS SQL, MySQL, or Maria DB.

During the access approval process, user information such as the IP address of the user terminal, user information, password, and access port can be received, and it is possible to determine whether or not to approve the access by comparing this user information with information previously stored on the server.

Figure 6 is a diagram showing the configuration of a DB table and column selection screen according to an example of the present invention.

As shown in FIG. 6, the database table information on the left side of the screen of the user terminal has a hierarchical structure, including upper level information (e.g., testdb) and lower level information (e.g., tb_mach, ChangeProtocol, ErrorProtocol, MenuPermissions, MenuStripPermissions, PermissionGroups, TableSettings, Users , Table1) can be displayed.

The program settings window can display table information (e.g. ChangeProtocol) and table column information, and the user can select the column they want to search by checking a checkbox in the column displayed in the program settings window. The server can display each column and its type together.

Figure 7 is a diagram showing the configuration of a DB search condition selection screen according to an example of the present invention.

As shown in Figure 7, the selection tasks in the previous processes (Step 1, Step 2) can be accumulated and displayed in the program settings window, and in the DB search condition selection process (Step 3), the conditions for each column are set. You can set, add, and edit.

As shown in Figure 7, a condition of greater than or equal to 0 can be set for the ID column, and a condition for outputting the latest value can be set for the Value column.

Figure 8 is a diagram showing the configuration of the DB sorting condition screen according to an example of the present invention.

Each column can be output for a condition, but in order to provide meaningful information to the user, it needs to be aligned according to the user's intent. Therefore, in the sorting process (Step 4), you can set a sorting method (e.g., ascending order) for the data of the output column, and the server can receive user input in various sorting methods such as ascending order, descending order, latest order, and largest value order. there is. In some cases, it is possible to receive input in a user-defined sorting order other than the sorting method provided by the server.

Figure 9 is a diagram showing a DB query output screen according to an example of the present invention.

As shown in FIG. 9, search conditions from Step 1 to Step 4 can be simply displayed prior to the program settings window. In addition, in the query creation window, a query statement to be executed according to the above search conditions may be generated and displayed. In the past, it was difficult for the general public to access the DB because the query statement had to be entered directly by a developer-level administrator. However, according to the present invention, it is possible to create a query statement by simply selecting it in the GUI environment, so the general public can access the DB. There is a beneficial effect of increased accessibility.

The query results window displays the generated query statement results and can be output according to the set sort order. Additionally, the server can provide an environment in which output data can be received and stored as well as searched by the user terminal.

A query statement can be a statement created from main statements such as select, where, and from, and can additionally perform functions by expanding to statements such as insert, update, and join. The generated query statement can also be output in a data format such as a table or chart.

According to the present invention, users can create customized query statements and share the query statements with other users. For example, if there are multiple managers on the same smart factory system, it may be advantageous for work consistency to execute query statements at the same level rather than creating and executing different query statements for each manager.

Additionally, when searching not only the same database but also similar databases, the server can provide a simpler and more accurate search environment by referring to previously searched query statements.

Accordingly, the server can provide a community space for storing query statements that each user wants to share, and can allow query statements to be shared on the community space. At this time, the shared query files, etc. can be shared in various file formats (e.g. CSV, TXT, Excel, Json, etc.).

The server can check whether each sharer has sharing permissions and can perform an authorization process to enable sharing between users who have sharing permissions.

Additionally, if the server determines that a query statement for a database similar to the data the user wants to query has been shared, it may provide the user with query statement information for a shareable database.

Users can personalize and modify query statements shared by the server by referring to them, and can also share the modified query statements. As this shared environment continues, database searches can be performed using excellent query statements, and even users without developer-level SW skills can easily build and manage a smart factory.

One embodiment of the present invention may also be implemented in the form of a recording medium containing instructions executable by a computer, such as program modules executed by a computer. Computer-readable media can be any available media that can be accessed by a computer and includes both volatile and non-volatile media, removable and non-removable media. Additionally, computer-readable media may include both computer storage media and communication media. Computer storage media includes both volatile and non-volatile, 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. Communication media typically includes computer readable instructions, data structures, program modules, or other data in a modulated data signal such as a carrier wave, or other transmission mechanism, and includes any information delivery medium.

Although the methods and systems of the present invention have been described with respect to specific embodiments, some or all of their components or operations may be implemented using a computer system having a general-purpose hardware architecture.

The description of the present invention described above is for illustrative purposes, and those skilled in the art will understand that the present invention can be easily modified into other specific forms without changing the technical idea or essential features of the present invention. will be. Therefore, the embodiments described above should be understood in all respects as illustrative and not restrictive. For example, each component described as single may be implemented in a distributed manner, and similarly, components described as distributed may also be implemented in a combined form.

The scope of the present invention is indicated by the claims described below rather than the detailed description above, and all changes or modified forms derived from the meaning and scope of the claims and their equivalent concepts should be construed as being included in the scope of the present invention. do.

100: Server
200: user terminal

Claims (10)

In the data inquiry method through GUI,
Approving server access from the user terminal;
Receiving data table selection information on a database stored in the server;
Receiving search condition information for each column created based on the table selection information;
Receiving sorting conditions for the search condition information for each column; and
Generating a query statement for the database according to a data table displayed in a hierarchical structure, search conditions for each column, and sorting conditions;
Including,
The step of receiving search condition information for each column is:
Characterized in receiving search condition information for each column from the server by selecting search conditions generated based on data transmitted from the server to the user terminal and displayed on a GUI displayed on the user terminal,
A data inquiry method through a GUI, characterized in that the generated query statement can be transmitted to other user terminals through a community network, and the generated query statement is shared between users who have sharing permissions. According to paragraph 1,
outputting data searched according to the generated query statement;
A method of querying data through a GUI, further comprising: According to paragraph 1,
The step of approving the server connection is,
A data inquiry method through a GUI, characterized in that approval is determined based on the database type information, user identification information, and access IP address of the server to be accessed. delete According to paragraph 2,
The step of outputting data searched according to the generated query statement is,
Output the generated query statement and searched data,
A data inquiry method through a GUI, characterized in that it provides an area where modifications to the generated query statement can be performed. In the data inquiry server through GUI,
a connection management unit that approves a connection from a user terminal;
a data management unit that receives data table selection information on a database stored in a server;
a search condition management unit that receives search condition information for each column created based on the table selection information and sorting conditions for the search condition information for each column; and
a query generator that generates a query statement for the database according to data tables displayed in a hierarchical structure, search conditions for each column, and sorting conditions;
Including,
The search condition management unit is characterized in that it receives search condition information for each column by selecting a search condition displayed on a GUI displayed on the user terminal,
The generated query statement can be transmitted to other user terminals through a community network, and the generated query statement is shared between users with sharing permissions. A data inquiry server through a GUI. According to clause 6,
A data inquiry server through a GUI, further comprising a query execution unit that outputs the searched data according to the generated query statement. According to clause 6,
The connection management department,
A data inquiry server through a GUI, characterized in that approval is determined based on the database type information, user identification information, and access IP address of the server to be accessed. delete In clause 7,
The query execution unit,
Output the generated query statement and searched data,
A data inquiry server through a GUI, characterized in that it provides an area where modifications to the generated query statement can be performed.