JP2023028580A - data processing system - Google Patents

Abstract

To improve usability of data processing.SOLUTION: A processing system for performing data processing is provided, the system comprising an instruction reception unit configured to receive a data processing request for acknowledging selection of data to be processed and processing the data, a data processing unit configured to perform the data processing and store the data and content of the data processing, and an image generation unit configured to display the stored content of the data processing together with information on the data.SELECTED DRAWING: Figure 8

Description

The present invention relates to a data processing system that visually displays data processing time when a user performs predetermined data processing.

Conventionally, multiple data that are distributed and managed on a daily basis (for example, master data such as store and product data and individual data such as sales data by store) are integrated for a predetermined purpose such as sales analysis. At that time, data correction (for example, cleansing processing) such as elimination of duplication between data and name identification is performed in advance.

Cleansing processing is often performed periodically by batch processing, but a technique for performing cleansing processing in real time and executing data integration in response to user requests has been disclosed (Patent Document 1).

JP 2017-068475 A

However, Patent Literature 1 discloses a technique in which a user selects a table to be processed through a user interface, executes a predetermined cleansing process, and displays a preview of the execution result. measures to encourage the use of data are not disclosed.

Accordingly, it is an object of the present invention to provide a technique for improving usability in data processing.

According to one aspect of the present invention, there is provided a processing system that executes data processing, comprising: an instruction receiving unit that receives a selection of data to be processed, processes the data, and receives a request for data processing; a data processing unit that executes and stores the data and the content of the data processing; and an image generation unit that displays the stored content of the data processing together with the information of the data.

According to the present invention, usability can be further improved in data processing.

1 is a block configuration diagram showing a data processing system according to a first embodiment of the present invention; FIG. 2 is a functional block configuration diagram showing the server device 100 of FIG. 1; FIG. 2 is a functional block configuration diagram showing the terminal device 200 of FIG. 1; FIG. 4 is a diagram for explaining the contents of processing target data stored in the server 100; FIG. 4 is a diagram for explaining the contents of a processing flow stored in the server 100; FIG. It is an example of a user interface displayed on the terminal device 200 according to the first embodiment of the present invention. It is another example of a user interface displayed on the terminal device 200 according to the first embodiment of the present invention. It is an example of a flowchart of data processing according to the first embodiment of the present invention.

BEST MODE FOR CARRYING OUT THE INVENTION Hereinafter, embodiments of the present invention will be described with reference to the drawings. It should be noted that the embodiments described below do not unduly limit the scope of the invention described in the claims. Moreover, not all the constituent elements shown in the embodiments are essential constituent elements of the present invention.

(Embodiment 1)
<Configuration>
FIG. 1 is a block configuration diagram showing a data processing system 1 according to Embodiment 1 of the present invention. This data processing system 1, for example, performs data processing/correction (for example, cleansing processing) on distributedly managed data for a predetermined purpose (for example, marketing analysis), performs data combination, and performs data As a utilization, it is a system for outputting as a marketing report. It should be noted that marketing analysis as the purpose and marketing report as the output are examples, and the report is not limited to this, and may be a report for other purposes. Moreover, as long as at least two data are separately managed, the number of data to be distributed and managed is not limited regardless of whether it is a small number or a large number.

The data processing system 1 has a server device (data processing device) 100, a terminal device 200, and a network NW. The server device 100 and the terminal device 200 are connected via a network NW. The network NW includes the Internet, an intranet, a wireless LAN (Local Area Network), a WAN (Wide Area Network), and the like.

The server device 100 is a device that processes data, and may be, for example, a general-purpose computer such as a workstation or personal computer, or may be logically implemented by cloud computing.

The terminal device 200 is, for example, an information processing device such as a personal computer or a tablet terminal possessed by a user who uses the data processing system 1, but may be configured by a smart phone, a mobile phone, a PDA, or the like.

In this embodiment, the data processing system 1 includes a server device 100 and a terminal device 200, and the terminal device 200 is used to operate the server device 100. However, the server device 100 is configured as a stand-alone device. Alternatively, the server device 100 itself may be provided with a function to be operated by the user.

FIG. 2 is a functional block configuration diagram showing the server device 100 of FIG. The server device 100 includes a communication section 110 , a storage section 120 and a control section 130 .

The communication unit 110 is a communication interface for communicating with the terminal device 200 and the web server 300 via the network NW, and communication is performed according to a communication protocol such as TCP/IP (Transmission Control Protocol/Internet Protocol).

The storage unit 120 stores programs, input data, and the like for executing various control processes and functions in the control unit 130, and is composed of RAM (Random Access Memory), ROM (Read Only Memory), and the like. be. The storage unit 120 also includes a processing target data storage unit 121 that stores data to be processed, an icon data storage unit 122 that stores icon data to be displayed on the user interface, and individual data processing. are associated with each other and managed in an ordered manner. Furthermore, the storage unit 120 temporarily stores data that has been communicated with the terminal device 200 and the web server 300 . Note that a database (not shown) storing data used for each process may be constructed outside the storage unit 120 .

The control unit 130 controls the overall operation of the server device 100 by executing a program stored in the storage unit 120, and is composed of a CPU (Central Processing Unit), a GPU (Graphics Processing Unit), and the like. be done. The functions of the control unit 130 include an instruction reception unit 131 from the user's terminal device 120 , a data processing unit 132 , and an image generation unit 133 . The instruction receiving unit 131, the data processing unit 132, and the image generating unit 133 are activated by a program stored in the storage unit 120 and executed by the server device 100, which is a computer (electronic calculator).

When the user makes a predetermined request (by pressing a specific icon, etc.) via a user interface such as a web screen provided by the server 100 and displayed on the terminal device 200, the instruction receiving unit 131 An instruction is received from the terminal device 200 via the communication unit 110 .

The data processing unit 132 executes the corresponding data processing when the user's request is related to data processing (for example, data acquisition, processing/combination, extraction, utilization, etc.).

The image generator 133 generates image information for configuring a user interface displayed on the terminal device 200 . In particular, based on the icon data stored in the storage unit 120, various icons are arranged in a predetermined area on the user interface, and an image is generated for displaying these icons in association with each other as necessary. Processing related to the image generator 133 can also be executed by a GPU (Graphics Processing Unit).

FIG. 3 is a functional block configuration diagram showing the terminal device 200 of FIG. The terminal device 200 includes a communication section 210 , a display operation section 220 , a storage section 230 and a control section 240 .

The communication unit 210 is a communication interface for communicating with the server device 100 via the network NW, and communication is performed according to a communication protocol such as TCP/IP.

The display operation unit 220 is a user interface used by the user to input instructions and display text, images, etc. according to input data from the control unit 240, and the terminal device 200 is configured by a personal computer. When the terminal device 200 is a tablet terminal, it is composed of a touch panel and the like. The display operation unit 220 is activated by a control program stored in the storage unit 230 and executed by the terminal device 200, which is a computer (electronic calculator).

The storage unit 230 stores programs, input data, and the like for executing various control processes and functions in the control unit 240, and is composed of RAM, ROM, and the like. The storage unit 230 also temporarily stores the content of communication with the server device 100 .

The control unit 240 controls the overall operation of the terminal device 200 by executing the programs stored in the storage unit 230, and is composed of a CPU, a GPU, and the like.

Note that the server device 100 may be configured to have the function of the display operation unit, and in this case, the configuration may be configured without the terminal device 200 .

FIG. 4 is a diagram for explaining the contents of processing target data stored in the storage unit 120 of the server 100. As shown in FIG.

The data to be processed is stored as, for example, a csv file, and as shown in FIG. 4, for example, customer data is managed item by item. Items related to the customer include ID, first and last name, gender, date of birth, last purchase date and time, UNIX time, total purchase amount, total number of purchases, annual average number of purchases, and the like. As data to be processed, the processed data storage unit 121 can store a plurality of csv files for each customer.

FIG. 5 is a diagram for explaining the contents of the processing flow stored in the storage unit 120 of the server 100. As shown in FIG.

As a processing flow, for example, data is imported, the extracted data is processed and corrected (for example, cleansing), data is combined, the processed data is extracted, and the data is analyzed and utilized ( For example, a flow consisting of a plurality of data processing such as a page flow, etc., can be mentioned. Data generated in individual data processing can also be stored in a csv file format or the like.

FIG. 6 is an example of a user interface displayed on the terminal device 200 according to the first embodiment of the present invention.

As shown in FIG. 6(a), the user interface 600 has an area 601 showing a processing flow consisting of a plurality of data processes in chronological order from the left to the right of the drawing, and an area 601 for allowing the user to perform predetermined data processing. and an area 602 for arranging one or more instruction icons for instructing the device 100 .

In the area 601, for example, as shown in FIG. 6A, data processing includes data "capture", data "processing/combination", data "extraction", and data "utilization". , are displayed so that these data processes are processed in chronological order. Further, as shown in FIG. 6A, in an area 602, icons 603 for arranging data to be processed and icons 603 for instructing the next data processing along each stage of data processing. , and an icon 604 for connecting a plurality of different data processing icons is arranged. Examples of the icon 603 include data to be processed (“customer data A” in this example), processing status, and data volume.

In this way, the user can request predetermined data processing via the instruction icon, and can visually associate and understand the data processing operation and the data after data processing via the data icon. This embodiment can provide a data processing system and method with high operability.

<Process flow>
The flow of processing of the data processing method executed by the data processing system 1 of this embodiment will be described with reference to FIG. FIG. 8 is an example of a flow chart showing a data processing method according to the first embodiment of the present invention.

Here, in order to use the data processing system 1, the user accesses the server device 100 using the Internet browser or the like of the terminal device 200, receives predetermined authentication such as entering an ID and password, and logs in. By doing so, it becomes available. After this authentication, a user interface as shown in FIG. 6 is provided via a web screen or the like, and the process proceeds to step S101 shown in FIG.

First, as the process of step S101, the server apparatus 100 receives a request for selecting data to be candidates for data processing. For example, when the user operates the terminal device 200 to select data to be processed, the instruction receiving unit 131 of the control unit 130 of the server device 100 selects data to be processed from the terminal device 200 via the communication unit 110. Receive requests. Here, the user operates the terminal device 200 to select specific data (for example, a csv file with a file name of "data_type.csv") to be a candidate for processing.

As the process of step S102, the server device 100 receives a data processing request. For example, the data processing unit 132 of the control unit 130 of the server device 100 receives a request to perform "utilization" processing (for example, page flow analysis processing) on processing target data selected by the user. As a result, for example, the screen generation unit 133 of the control unit 130 of the server device 100, based on the icon image data and the selected data stored in the icon data storage unit 122, shows the example of the user interface in FIG. Processing is performed to generate icon 606 and place it in region 602 . For example, among the data processing shown in the area 601, an icon 606 indicating that utilization processing is to be performed on "customer data A" is arranged immediately below the "utilization" processing. Further, the server apparatus 100 stores the contents of the data processing together with the processed data in the processing flow storage section 123 of the storage section 120 .

As the processing of step S103, the server device 100 refers to the stored data processing content in response to the user's icon selection request, and performs processing for displaying the data processing content. For example, when the user selects the icon 606 indicating the page flow analysis process executed in the previous step in FIG. 6B, the image generator 133 of the controller 130 of the server device 100 displays the , a process for displaying information indicating the contents of the same data processing is performed. As data processing content, as basic information, the name of the application that processed the data, processing status (e.g., "before processing", "processing", "processing completed", data name, and other information such as data processing It is possible to display information such as history and usage history/analysis of the results of this data processing.

Subsequently, as the process of step S104, the server apparatus 100 performs the process of displaying the data processing contents of the previous step and the process of displaying information indicating the data used in the data processing. For example, as shown in FIG. 7A, the screen generation unit 133 of the control unit 130 of the server device 100 generates information indicating data used in the page flow analysis process ("customer data B" in this example). display.

In this way, by displaying the details of data processing as well as the information about the data used in the data processing, the user can refer to the information about the data that affects the data processing. Analyze how it affects the results. Here, along with the data processing content, the data processing content and other data processing of the data (data utilization destination) (in the example of FIG. 7A, "measures/analysis of summer sale for high-value customers", etc.) are referred to. Therefore, it is possible to refer to not only specific data and data processing, but also specific data that affects predetermined data processing, and predetermined data that can be used by specific data, so flexible use of data can be considered. can do.

As a modification, the user can refer to the details of the data by selecting "details" on the data processing content display screen of FIG. 7(a), as shown in FIGS. be able to. As details of the data used for the data processing, the user can refer to each item of data and its input content, as shown in FIG. 7(b). In this way, the user can further see and analyze the details of the data that affect the results of the data analysis.

Although the disclosed embodiments have been described above, they can be implemented in various other forms, and can be implemented with various omissions, substitutions, and modifications. These embodiments, modifications, omissions, substitutions and modifications are included within the technical scope of the claims and their equivalents.

1 data processing system 100 server device, 110 communication unit, 120 storage unit, 130 control unit, 200 terminal device, NW network

Claims (5)

A processing system for performing data processing, comprising:
an instruction receiving unit that receives a selection of data to be processed, processes the data, and receives a data processing request;
a data processing unit that executes the data processing and stores the data and the content of the data processing;
a processing system comprising: an image generator for displaying the contents of the stored data processing together with the information of the data. 2. The processing system of claim 1, wherein said data processing includes data extraction, manipulation, combination and utilization. 3. The processing system according to claim 2, wherein said image generation unit displays different data processing in chronological order, and generates an icon indicating data to be processed and a status for said different data processing. 4. The processing system according to claim 3, wherein said image generator displays a connection icon connecting different data processes. 2. The processing system according to claim 1, wherein said image generator further displays details of said data in response to a user's request.

Images