KR102640115B1 - Operating method for electronic apparatus for providing information and electronic apparatus supporting thereof - Google Patents

Abstract

According to the present disclosure, in a method for an electronic device to provide information, data source management information for managing a data source for storing event data obtained in response to an event on a service related to the electronic device in a database acquiring; Obtaining data storage management information for managing database settings for storing the event data in the database; Setting to store processed data obtained by processing the event data in the database according to a data management format set based on the data source management information and the data storage management information; And it may include providing information related to a data set including one or more processed data confirmed from the database in response to a data inquiry request for searching data in the database.

Description

Method of operating an electronic device that provides information and an electronic device supporting the same {OPERATING METHOD FOR ELECTRONIC APPARATUS FOR PROVIDING INFORMATION AND ELECTRONIC APPARATUS SUPPORTING THEREOF}

The present invention relates to a method and device for providing information, and more specifically, a method for providing information related to data corresponding to a data inquiry request based on a database in which an electronic device is built to store data according to a certain format. and electronic devices thereof.

With the development of electronic technology, e-commerce has become a field of shopping. Customers can purchase items online without having to go to a shopping mall or market in person, and items purchased online are delivered to the delivery address requested by the customer.

In the case of e-commerce, the provision of detailed and accurate information about products has a significant impact on service satisfaction, so various ways to provide more detailed and accurate information are being discussed.

In relation to this, prior literature such as KR101756594B1 or KR101500849B1 may be referred to.

According to the method of the present invention, an electronic device can provide information related to data corresponding to a data inquiry request based on a database built to store data according to a certain format.

The technical problems to be achieved in the present invention are not limited to the technical problems mentioned above, and other technical problems not mentioned will be clearly understood by those skilled in the art from the description below. You will be able to.

Various embodiments may provide a method of operating an electronic device to provide information and an electronic device that supports the method.

In a method for an electronic device to provide information according to various embodiments, data source management information for managing a data source for storing event data obtained in response to an event on a service related to the electronic device in a database Obtaining a; Obtaining data storage management information for managing database settings for storing the event data in the database; Setting to store processed data obtained by processing the event data in the database according to a data management format set based on the data source management information and the data storage management information; And it may include providing information related to a data set including one or more processed data confirmed from the database in response to a data inquiry request for searching data in the database.

In an example embodiment, the event data may be queued based on a message queue that includes one or more message queues.

In an exemplary embodiment, the data source management information includes information about one or more data sources, and a first data source included in the one or more data sources is selected from one or more topics corresponding to the one or more message queues. It may correspond to the first topic selected for the first data source.

In an exemplary embodiment, the information about the first data source included in the data source management information may include information about the data subject corresponding to the first topic.

In an exemplary embodiment, the data storage management information may include identification information that identifies a data subject corresponding to the first topic.

In an exemplary embodiment, the identification information may be generated based on one of the user's customer ID (Identifier) on the service, the user's mail ID, the user's IP (Internet Protocol) address, and the user's terminal ID. You can.

In an exemplary embodiment, the data management format may classify and manage data in the form of rows set as units of the identification information.

In an exemplary embodiment, the data storage management information may include information about one or more data items corresponding to the first topic.

In an exemplary embodiment, the data storage management information may store the plurality of data when a plurality of data related to a data subject corresponding to the first topic are identified in a first data item included in the one or more data items. It may include information for setting the first data item corresponding to the data subject in the form of a column.

In an exemplary embodiment, the data management format includes, for each data item included in one or more data items corresponding to the first topic, and each data item, for identification information identifying a data subject corresponding to the first topic. In an item, one or more data identified for the data subject can be classified and managed in the form of columns corresponding to the identification information.

In an exemplary embodiment, the data storage management information may include information about a valid period for which data is stored in the database.

In an exemplary embodiment, the processed data includes identification information identifying a data subject corresponding to a topic included in the data source management information, a data item set corresponding to the topic in the data storage management information, and the event data. It may include a data value confirmed based on the data subject and the data item, and a point in time when the event data was obtained on the service.

In an exemplary embodiment, the data inquiry request includes input information required for data inquiry, and the input information required for data inquiry may be set based on the data management format.

In an exemplary embodiment, the data inquiry request may include information on a subject for data inquiry and information on a data operator for the subject.

In an example embodiment, the information related to the data set may include information about a result of calculating the one or more processed data based on the data operator.

In an exemplary embodiment, the data inquiry request may include information about a inquiry period for data inquiry.

In an exemplary embodiment, each processed data included in the one or more processed data may be confirmed based on the fact that the time when each event data corresponding to each processed data was acquired on the service is included in the inquiry period. You can.

In an exemplary embodiment, the data inquiry request may include information about the data subject and data item for data inquiry.

An electronic device that provides information according to various embodiments includes: a processor; and one or more memories storing one or more instructions, wherein the one or more instructions, when executed, cause the processor to: generate event data obtained in response to an event on a service related to the electronic device. Obtaining data source management information for managing data sources for storage in a database; Obtaining data storage management information for managing database settings for storing the event data in the database; Setting to store processed data obtained by processing the event data in the database according to a data management format set based on the data source management information and the data storage management information; And in response to a data search request for searching data in the database, the processor may be controlled to perform a step of providing information related to a data set including one or more processed data confirmed from the database.

The various embodiments of the present disclosure described above are only some of the preferred embodiments of the present disclosure, and various embodiments reflecting the technical features of the various embodiments of the present disclosure can be understood by those skilled in the art. It can be derived and understood based on the detailed description described below.

The present invention proposes a method for providing information related to data corresponding to data inquiry requests based on a database built by an electronic device to store data according to a certain format, thereby storing and managing data obtained from a service. It has a technical effect in terms of effectively promoting provision convenience.

The effects that can be obtained from the present invention are not limited to the effects mentioned above, and other effects not mentioned can be clearly understood by those skilled in the art from the description below. will be.

FIG. 1 is a diagram illustrating an information provision system in which a method of operating an electronic device for providing information according to various embodiments can be implemented.
FIG. 2 is a diagram illustrating the configuration of a server device 100 and a user device 200 according to various embodiments.
FIG. 3 is a diagram illustrating a method of operating the server device 100 for providing information according to various embodiments.
Figure 4 is a diagram showing an example of how data source management information is set.
Figure 5 is a diagram showing an example of how data storage management information is set.
Figure 6 is a diagram showing an example of how data is stored in a database according to a data management format.
Figure 7 is a diagram showing an example of how processed data obtained from event data is stored in a database.
Figure 8 is a diagram showing an example of input information for a data inquiry request.
Figure 9 is a diagram illustrating an example of a data operator that can be set in a data inquiry request.
Figure 10 is a diagram showing an example of how information related to a data set including processed data corresponding to a data inquiry request is provided.
Figures 11 and 12 are diagrams showing the overall appearance of the present invention in which the server device 100 sets up a database based on a data management format and provides information corresponding to data inquiry requests.

The following embodiments combine components and features of various embodiments in a predetermined form. Each component or feature may be considered optional unless explicitly stated otherwise. Each component or feature may be implemented in a form that is not combined with other components or features. Additionally, various embodiments may be configured by combining some components and features. The order of operations described in various embodiments may change. Some features or features of one embodiment may be included in other embodiments or may be replaced with corresponding features or features of other embodiments.

In the description of the drawings, procedures or steps that may obscure the gist of the various embodiments are not described, and procedures or steps that can be understood at the level of a person with ordinary knowledge in the relevant technical field are not described. did.

Throughout the specification, when a part is said to “comprise or include” a certain element, this means that it does not exclude other elements but may further include other elements, unless specifically stated to the contrary. do. In addition, terms such as "... unit", "... unit", and "module" used in the specification refer to a unit that processes at least one function or operation, which refers to hardware, software, or a combination of hardware and software. It can be implemented as: Additionally, the terms “a or an,” “one,” “the,” and similar related terms are used herein in the context of describing various embodiments (particularly in the context of the claims below). Unless otherwise indicated or clearly contradicted by context, it may be used in both singular and plural terms.

Hereinafter, preferred embodiments according to various embodiments will be described in detail with reference to the attached drawings. The detailed description set forth below in conjunction with the accompanying drawings is intended to illustrate exemplary embodiments of various embodiments and is not intended to represent the only embodiment.

In addition, specific terms used in various embodiments are provided to aid understanding of the various embodiments, and the use of such specific terms may be changed to other forms without departing from the technical spirit of the various embodiments. .

FIG. 1 is a diagram illustrating an information provision system in which a method of operating an electronic device for providing information according to various embodiments can be implemented.

Referring to FIG. 1, information providing systems according to various embodiments may be implemented in various types of electronic devices. For example, the information provision system may be implemented in the server device 100 and the user device 200. In other words, the server device 100 and the user device 200 may perform operations according to various embodiments of the present disclosure based on the information provision system implemented in each device. Meanwhile, the information provision system according to various embodiments is not limited to what is shown in FIG. 1, and may be implemented in a wider variety of electronic devices and servers.

The server device 100 according to various embodiments may be a device that performs wireless and wired communication with a plurality of user devices 200 and includes storage with a large storage capacity. For example, the server device 100 may be a cloud device that works with a plurality of user devices 200.

The user device 200 according to various embodiments may be a device that can be used by an individual user, such as a desktop PC, tablet PC, or mobile terminal. In addition, other electronic devices that perform similar functions may be used as the user device 200.

An information provision system according to various embodiments may include various modules for operation. Modules included in the information provision system are implemented so that the physical device (e.g., server device 100 and user device 200) on which the information provision system is implemented (or included in the physical device) can perform specified operations. It may be computer code or one or more instructions. In other words, the physical device in which the information provision system is implemented stores a plurality of modules in the memory in the form of computer code, and when the plurality of modules stored in the memory are executed, the plurality of modules are designated by the physical device corresponding to the plurality of modules. Actions can be performed.

FIG. 2 is a diagram illustrating the configuration of a server device 100 and a user device 200 according to various embodiments.

Referring to FIG. 2, the server device 100 and the user device 200 may include an input/output unit 210, a transceiver (or communication unit) 220, storage 230, and a processor 240. .

The input/output unit 210 may be various interfaces or connection ports that receive user input or output information to the user. The input/output unit 210 may include an input module and an output module, and the input module receives user input from the user. User input can take various forms, including key input, touch input, and voice input. Examples of input modules that can receive such user input include traditional keypads, keyboards, and mice, as well as touch sensors that detect the user's touch, microphones that receive voice signals, cameras that recognize gestures through image recognition, etc. A proximity sensor including at least one of an illumination sensor or an infrared sensor that detects user approach, a motion sensor that recognizes user movement through an acceleration sensor or gyro sensor, and various other types of sensors that detect or receive user input. There is an input means, and the input module according to an embodiment of the present disclosure may include at least one of the devices listed above. Here, the touch sensor may be implemented as a piezoelectric or capacitive touch sensor that detects touch through a touch panel or touch film attached to the display panel, or an optical touch sensor that detects touch by an optical method. In addition, the input module may be implemented in the form of an input interface (USB port, PS/2 port, etc.) that connects an external input device that receives user input instead of a device that detects user input itself. Additionally, the output module can output various information. The output module may include at least one of a display that outputs an image, a speaker that outputs sound, a haptic device that generates vibration, and various other types of output means. In addition, the output module may be implemented in the form of a port-type output interface that connects the individual output means described above.

As an example, a display-type output module can display text, still images, and moving images. Displays include liquid crystal display (LCD), light emitting diode (LED) display, organic light emitting diode (OLED) display, flat panel display (FPD), and transparent display. Among various types of devices that can perform image output functions such as display, curved display, flexible display, 3D display, holographic display, projector, and other It can contain at least one. This display may be in the form of a touch display integrated with the touch sensor of the input module.

Transceiver 220 may communicate with other devices. Accordingly, the server device 100 and the user device 200 can transmit and receive information with other devices through the transceiver 220. For example, the server device 100 and the user device 200 may communicate with each other or with other devices using the transceiver 220.

Here, communication, that is, transmission and reception of data, can be accomplished wired or wirelessly. For this purpose, the transceiver 220 includes a wired communication module that connects to the Internet, etc. through a LAN (Local Area Network), a mobile communication module that transmits and receives data by connecting to a mobile communication network through a mobile communication base station, and a WLAN such as Wi-Fi. A short-range communication module that uses a Wireless Local Area Network (Wireless Local Area Network) series communication method or a WPAN (Wireless Personal Area Network) series communication method such as Bluetooth or Zigbee, and a GNSS (Global Positioning System) such as GPS (Global Positioning System). It may include a satellite communication module using a Navigation Satellite System or a combination thereof.

Storage 230 can store various types of information. Storage 230 may store data temporarily or semi-permanently. For example, the storage 230 of the server device 100 contains an operating program (OS: Operating System) for running the server device 100, a program for generating data or Braille for hosting a website, or an application (e.g. For example, data related to a web application) may be stored. Additionally, the storage 230 may store modules in the form of computer code as described above.

Examples of storage 230 include hard disk drive (HDD), solid state drive (SSD), flash memory, read-only memory (ROM), random access memory (RAM), etc. This can be. This storage 230 may be provided as a built-in type or a detachable type.

The processor 240 controls the overall operation of the server device 100 and the user device 200. To this end, the processor 240 can perform calculations and processing of various information and control the operation of components of the server device 100. For example, the processor 240 may execute a program or application to provide information. The processor 240 may be implemented as a computer or similar device using hardware, software, or a combination thereof. In hardware, the processor 240 may be implemented in the form of an electronic circuit that processes electrical signals to perform a control function, and in software, it may be implemented in the form of a program that drives the hardware processor 240. Meanwhile, unless otherwise specified in the following description, the operations of the server device 100 and the user device 200 may be interpreted as being performed under the control of the processor 240. That is, when modules implemented in the above-described information provision system are executed, the modules may be interpreted as the processor 240 controlling the server device 100 and the user device 200 to perform the following operations.

In summary, various embodiments may be implemented through various means. For example, various embodiments may be implemented by hardware, firmware, software, or a combination thereof.

In the case of hardware implementation, methods according to various embodiments include one or more application specific integrated circuits (ASICs), digital signal processors (DSPs), digital signal processing devices (DSPDs), programmable logic devices (PLDs), and FPGAs. It can be implemented by (field programmable gate arrays), processor, controller, microcontroller, microprocessor, etc.

In the case of implementation by firmware or software, methods according to various embodiments may be implemented in the form of modules, procedures, or functions that perform the functions or operations described below. For example, software code can be stored in memory and run by a processor. The memory may be located inside or outside the processor, and may exchange data with the processor through various known means.

Below, various embodiments will be described in more detail based on the above technical idea. The contents described above may be applied to various embodiments described below. For example, operations, functions, terms, etc. that are not defined in various embodiments described below may be performed and explained based on the contents described above.

In the following description, the server device 100 sets up a database for storing and managing data, and when the user device 200 transmits a request for data inquiry to the server device 100, the server device 100 Various embodiments will be described on the premise that an operation is performed to provide information related to data corresponding to a request.

FIG. 3 is a diagram illustrating a method of operating the server device 100 for providing information according to various embodiments.

According to FIG. 3, the server device 100 provides information related to a data set corresponding to a request for data inquiry, and specifically, a data source (data source) for storing event data obtained in response to an event on the service in a database. acquire data source management information that manages (301) data source management information, acquire data storage management information that manages database settings for storing event data in a database (303), and obtain data source management information and data storage management information. Processed event data is set to be stored in the database according to a data management format set based on it (305), and in response to a data inquiry request to search data in the database, one or more processed data confirmed from the database Information related to the data set including the data may be provided (307).

According to FIG. 3, the operation of the server device 100 providing information related to the data set may be performed for a service provided by the server device 100 or a service related to the server device 100, and the service may be performed in the service. It may correspond to a service that allows multiple users using the service to order and purchase multiple items being sold. The plurality of items sold in the service are not limited to the type or type of the item and may include various types or types of items registered by the seller to sell the item.

In addition, in FIG. 3, the user device 200 through which a request for data inquiry is input is a user device 200 corresponding to an administrator who manages data on the service to be searched, and the user device 200 corresponding to the administrator receives information from the user device 200 corresponding to the administrator. When a request for inquiry of data desired by the administrator is obtained, the request is confirmed by the server device 100, and the server device 100 can provide information related to the data set including data corresponding to the request from the database. there is.

Meanwhile, the operation of the server device 100 according to FIG. 3 consists of setting a database for storing and managing data in operations 301 to 305 and providing information related to data in response to a data inquiry request in operation 307. They can be distinguished, and specific examples for each operation will be described later.

According to various embodiments, in operation 301, the server device 100 may obtain data source management information for managing a data source for storing event data obtained in response to an event on a service in a database. .

For example, an event on a service may be an event that occurs according to an action performed by a user on the service. For example, when a user performs an action to purchase an item on a service, the action may be confirmed as an event and event data related to the confirmed event may be generated. Data generated in this way includes data about the user who is the subject of the action to purchase the item, data about the item that is the object of the action to purchase the item, and/or the price and order of the item confirmed according to the action to purchase the item. Data on quantity, etc. may be included.

For example, event data obtained in response to an event on a service may be queued based on a message queue that includes one or more message queues. Message queues may include Kafka, which can initiate, subscribe, store, and process streaming data in real time. Kafka is a large-capacity real-time log processing system that uses the publish/subscribe paradigm to message messages. It may be a message queuing system that processes . Event data obtained in response to events on the service can be queued based on Kafka.

For example, data source management information may include information about one or more data sources for queuing event data on a service to a message queue. That is, information about the data source that serves as the basis for queuing event data to be transmitted to the message queue may be included in the data source management information.

For example, the first data source included in one or more data sources identified in the data source management information corresponds to the first topic among one or more topics in Kafka corresponding to one or more message queues for queuing event data. It can be a data source. In other words, each topic included in Kafka corresponds to each message queue, and an individual data source is set for queuing event data to each message queue, so that each data source for each topic can be set.

For example, information about the first data source included in the data source management information may include information related to the first topic to which the first data source corresponds. As an example, the information related to the first topic included in the data source management information may include information for identifying the subject of the data that performs an action on the service to generate event data corresponding to the first topic. . With respect to the first topic corresponding to the first data source included in the data source management information, information identifying the subject of the data that generates data belonging to the first topic on the service is set in the data source management information, The first data source may be set so that event data confirmed to occur on the service through a certain data subject for the topic is queued. If the first topic is identified as a target for queuing event data that is confirmed to have occurred through the userId of a general user on the service, the event occurs when the general user on the service performs an action related to the first topic on the service through the userId Data may be queued into a message queue corresponding to the first topic.

Once each data source for each message queue is set through data source management information, setting of the data source for the database can be completed.

Figure 4 is a diagram showing an example of how data source management information is set.

By setting data source management information as shown in Figure 4, a data source can be set for queuing event data corresponding to a specific topic into a message queue. In particular, in Figure 4, an event corresponding to the 'Payment' topic in Kafka is displayed. A data source for queuing data can be set (401).

In Figure 4, information userId is specified to identify the data subject performing an action that generates event data corresponding to the 'Payment' topic on the service, and an action related to the 'Payment' topic including the specified subject is specified. Event data generated through can be set to be queued in a message queue corresponding to the 'Payment' topic. At this time, the information for identifying the subject of data corresponding to the 'Payment' topic may be set to be mapped as a field of the data source (403).

If information that identifies the subject of the data, such as 403, is set through the data source management information in FIG. 4, as will be described later, in the data storage management information that manages the database settings, several data items included in the 'Payment' topic Among these, you can check the data items corresponding to the event data according to the data subject set in the data source management information. Additionally, a format may be set to manage each data value in the event data corresponding to each data item identified based on the data storage management information to be stored in correspondence with the subject of the data and each data item.

According to various embodiments, in operation 303, the server device 100 may obtain data storage management information that manages database settings for storing event data in a database.

For example, data storage management information may be information set for a specific data source for a database or a specific topic corresponding to a specific data source, and may be used to process and store event data on a data source or topic basis. Data storage management information may be set.

For example, data storage management information may include identification information for identifying the subject of data identified for a topic corresponding to a data source. For example, with respect to a first data source included in one or more data sources for a database, the subject of the data identified for the first topic set as corresponding to the first data source in the data source management information can be identified. , data storage management information may include identification information about the subject of the data. For example, if event data that is confirmed to have occurred through the user's userId is confirmed as a target for queuing for the first topic corresponding to the first data source, based on the mail ID, terminal ID, etc. that can identify the user's userId, By doing so, identification information can be generated and managed so that the subject of the data is identified in the database according to the identification information.

For example, the identification information in the data storage management information that identifies the subject of data for the topic corresponding to the data source specifically includes the customer ID (Identifier) of the user on the service, the mail ID of the user on the service, and the user's email ID on the service. It may be information generated based on one of the IP (Internet Protocol) address and/or the user's terminal ID on the service. As an example, the subject of the data that is usually confirmed to be generating data on the service will correspond to a general user, so various items such as customer ID, mail ID, IP (Internet Protocol) address, and terminal ID that can identify the general user on the service are used. Identification information generated based on the identifier may be included in data storage management information, and through this, data can be managed to be classified and stored in the database according to the identification information.

For example, event data that is confirmed to have occurred through a data subject to be identified through identification information may be set to be stored in a database with the value of each data differentiated according to the data item on the topic that classifies the data object. , data storage management information can be utilized for this purpose.

One Kafka topic corresponding to one data source may contain multiple data items, and event data confirmed to have occurred through the subject of the data may be one or more data items in the topic depending on the object included in the event data. can respond. As an example, the 'Payment' topic may include data items such as 'amount', 'count', and 'ip (Internet Protocol)', and occurs depending on the user's payment action on the service. The event data may include the value of each data corresponding to each data item included in the data items. At this time, through data storage management information, the event data can be set to be processed and stored in the database as data containing values for the data items 'amount' and 'count' among the above data items. In this case, the event data can be set to be stored in the database. Event data can be processed and stored in the database as processed data that includes the data value corresponding to 'amount' and the data value corresponding to 'count' among various values.

For example, if a specific topic corresponding to a specific data source is specified in the data source management information, multiple data items included in the specific topic are confirmed. At this time, among the multiple data items identified in this way, the database Data storage management information may include information specifying some data items for data in the event data to be stored and processed. In other words, the data storage management information may include information about one or more data items corresponding to the topic specified in the data source management information.

For example, data storage management information may include information about the validity period for which data is stored in the database. That is, how long data will be stored in the database can be set in the data storage management information. For example, the data storage management information can be set so that one piece of data is stored in the database for one week.

For example, data storage management information may include information for setting the form in which data is listed and stored in the database in the form of a column for the subject of the data.

Figure 5 is a diagram showing an example of how data storage management information is set.

The format in which data is stored in the database can be determined by setting the data storage management information as shown in Figure 5, and in patent Figure 5, 'validity period', 'identification information', and 'column' are defined through the data storage management information. and 'data item' may be set (501).

Specifically, 1) in the case of 'validity period', the data is set to be stored in the database for 7 days, and 2) in the case of 'identification information (Row Key)', the user's information is used to identify the user on the service corresponding to the subject of the data. It is created by adding a hash value to one of mail ID, customer ID, IP (Internet Protocol) address, and terminal ID, and the identification information generated in this way can be used to store data in a database in connection with the user. In addition, 3) data in the database can be managed to be set in the form of a column for user identification information, and 4) specific data items (amount, ip, count, etc.) may be set for data storage in the database (503).

The format in which data can be stored in the database can be determined by setting the data storage management information as shown in FIG. 5, and based on the determined format, the data can be stored in the database according to the form shown in FIG. 6, which will be described later.

According to various embodiments, in operation 305, the server device 100 stores processed data obtained by processing event data in a database according to a data management format set based on data source management information and data storage management information. You can set it.

For example, a data management format for processing data and storing it in a database may correspond to a format in which data is organized based on identification information that identifies the subject of data corresponding to a topic. As an example, the data management format may be a format that classifies and manages data in the form of rows set as a unit of identification information that identifies the subject of the data. In other words, the data management format can be set by setting identification information that identifies the subject of the data as a row, and setting object data on various data items related to the subject of the data as columns corresponding to the row. there is.

If information about one or more data items included in a specific topic is included in the data storage management information that manages database settings, identification information identifying the subject of the data is set as a row, and the one or more data items are stored in the row. The data management format can be set by setting columns corresponding to rows. To this end, with respect to the first data item included in the one or more data items, if a plurality of data is confirmed corresponding to the identification information in the first data item, the plurality of data is selected as the first data corresponding to the identification information. Information that manages items to be set in the form of columns may be included in the data storage management information.

In other words, the data management format targets identification information that identifies a data subject corresponding to a specific topic, each data item included in one or more data items corresponding to a specific topic, and each data item identified in response to the identification information. It may be in the form of a format that classifies and manages one or more data into columns corresponding to the identification information.

As a result, the processed data that processes event data according to the data management format includes identification information that identifies the data subject corresponding to the topic included in the data source management information and one or more data items set corresponding to the topic in the data storage management information. It may include each data item included, the data value confirmed based on the data subject and each data item in the event data, and the point in time when the event data was acquired on the service.

Figure 6 is a diagram showing an example of how data is stored in a database according to a data management format.

In Figure 6, each data item ('ip') set to store data in the database corresponding to a certain topic ('Payment') is centered on a row for identification information (Row Key) generated to identify a user on the service. ', 'amount', 'count'), a plurality of data identified for the identification information may be listed and stored as a column of each data item.

Specifically, for a user with identification information '237289098' (601), 1) a plurality of data identified for the user in the data item 'ip' included in the topic 'Payment' are listed and stored in column form; (603), 2) A plurality of data identified for the user in the data item 'amount' included in the topic 'Payment' are also listed and stored in column form (606), 3) The data item 'amount' included in the topic 'Payment' A plurality of data identified for the user in the data item 'count' may also be listed and stored in column form (607).

At this time, each processed data stored in FIG. 6 may include a time stamp when event data corresponding to the processed data was acquired on the service, a specific value of the data, etc. Each processed data of each data item generated from one event may include the value of the same timestamp, as can be seen in the processed data of multiple data items included in one row.

Through the data management format shown in Figure 6, data about users other than the user with the identification information '237289098' can be added as a new row and stored in the database, and 'ip', 'amount', and 'count' In addition, if the data storage management information is set to store data for other data items included in the topic 'Payment', the data that is processed to be classified into that other data item will be added as a new column for that other data item and stored in the database. You can.

Additionally, for new topics other than the topic 'Payment', the data management format as shown in FIG. 6 can be newly managed according to the settings of the data source for the new topic and the settings of the data items included in the new topic.

An example of event data being converted into processed data and stored in a database according to FIGS. 4 to 6 may be as shown in FIG. 7 .

Figure 7 is a diagram showing an example of how processed data obtained from event data is stored in a database.

In Figure 7, when event data (business data) obtained from an event that occurred on the service is confirmed, the event data is queued in a message queue (701) and processed according to the data management format set based on data source management information and data storage management information. It can be acquired as data and stored in a database.

Data storage management information for setting up a database includes identification information (Row Key) set to identify the subject of data for the topic indicated in the pre-set data source management information and data items instructing data to be stored on the topic ( qualifier), etc. can be set (703), and based on the data storage management information, the user's identification information is divided into rows, and each data item included in the topic and the data corresponding to each data item are divided into columns. Data may be stored according to the data management format set (705).

According to various embodiments, in operation 307, the server device 100 may provide information related to a data set including one or more processed data identified from the database in response to a data inquiry request for searching data in the database. there is.

For example, a data inquiry request may be that the server device 100 receives and confirms a request to inquire data from an external user device 200, etc., and such a data inquiry request may include input information required for data inquiry. Includes, and at this time, the input information required for data inquiry may be information set based on the data management format. In other words, the data stored in the database is data that has been processed to fit a certain data management format, so in order to search the processed data, you can manage to set input information that fits the data management format, and a data inquiry request can use this input information. When included, the server device 100 can check processed data corresponding to the received data inquiry request from the database.

For example, a data inquiry request may include information about a subject for data inquiry and information about a data operator for the subject. The user device 200 that wishes to search data may input a subject desired by the user device 200 and a data operator required for the desired subject to request data. The server device 100 may check processed data for the subject and operate the confirmed processed data according to the data operator, in response to the subject and data operator included in the data inquiry request. Additionally, when providing information related to processed data confirmed in response to a data inquiry request, the server device 100 may be set to include results of calculating the processed data according to data operators. That is, the information related to the data set provided by the server device 100 according to operation 307 may include information about the result of calculating one or more processed data included in the data set according to a data operator.

For example, a data inquiry request may include information about the inquiry period for data inquiry. That is, the user device 200 that wishes to query data can input a desired query period for the data query request, and the server device 100 responds to the query period included in the data query request, Processed data that confirms that the point in time when event data was acquired on the service is included in the inquiry period can be checked in the database.

For example, a data inquiry request may include information about the data subject and data item for data inquiry. That is, the user device 200 that wishes to inquire data can input the data subject and data item to specify the desired data in order to confirm the value of the desired data.

When a data inquiry request including input information on the subject, data subject, data item, data operator, inquiry period, etc. for data inquiry is obtained as above, the server device 100 retrieves the processed data selected through the input information from the database. You can check it.

Figure 8 is a diagram showing an example of input information for a data inquiry request.

The data inquiry request in FIG. 8 may be set to obtain input information identified as necessary according to the data management format set for the database, and the administrator may request the user device 200 User Interface/Experience (UI/ You can enter each information for a data inquiry request through UX). Here, setting input information for a data inquiry request can also be understood as setting a feature for obtaining information about desired processed data from a database.

The data inquiry request in Figure 8 includes 1) subject for data inquiry (801), 2) data subject and data item for data inquiry (803), 3) inquiry period for data inquiry (805), and 4) data. It can be set to input information related to the data operator 807 for the subject of inquiry. In Figure 8, based on the sum operator (Calc-function: SUM-I) for data, data included in the price data item (Object Target: amount) corresponding to the subject (Subject Target: userId) of certain data You can see that the input information to calculate the sum (FeatureName and DataView) of 3 days (Calc-window: 3d) has been set.

As shown in FIG. 8, when a data inquiry request including each input information is obtained, the server device 100 checks one or more processed data corresponding to the data inquiry request in the database, and then creates a data set including the one or more processed data and Information including an operation result of calculating the one or more processed data included in the data set according to a data inquiry request may be provided to the user device 200.

Figure 9 is a diagram illustrating an example of a data operator that can be set in a data inquiry request.

Data operators may include various operators that are determined to be supported for data stored in the database, and are supported for the data depending on whether the data type is in the form of a number or string. Data operators that are determined to be possible may be confirmed.

In the example of FIG. 9, the functions for data operators include the sum of data (Sum-I), the number of data (Count-I), the maximum value of the data (Max-I), and the minimum value of the data (Min- It can be seen that various operators can be set, such as I) and average of data (Avg-I).

Figure 10 is a diagram showing an example of how information related to a data set including processed data corresponding to a data inquiry request is provided.

Figure 10 shows calculation results for processed data corresponding to each data item ('ip', 'amount') included in a certain topic ('Payment') targeting identification information for a specific user on the service. It shows the appearance.

First, in the three processed data included in the 'ip' data item, 1) the calculation result in response to a data inquiry request to check the number of each IP entity included in the processed data with timestamp values for the past hour Information indicating that is 2 may be provided (1001). Additionally, 2) In response to a data inquiry request to check the total number of IP entities included in processed data with timestamp values for the past hour, information indicating that the result of the calculation is 3 is provided (1003), or 3 ) In response to a data inquiry request to check the list of each IP entity included in the processed data with a timestamp value for the past hour, information indicating each IP address corresponding to the calculation result may be provided (1005 ).

In the three processed data included in the 'amount' data item, 4) in response to a data inquiry request to check the total sum of transaction prices included in the processed data with timestamp values for 1 hour within the past day Information indicating that the result of the calculation is 96.9 may be provided (1007).

Figures 11 and 12 are diagrams showing the overall appearance of the present invention in which the server device 100 sets up a database based on a data management format and provides information corresponding to data inquiry requests.

At 1101 of FIG. 11, the server device 100 sets up a database in the form shown in FIG. 7 described above, so that event data obtained from the service can be converted into processed data suitable for a certain data management format and stored therein. In addition, as shown in 1103, the server device 100 checks the data inquiry request or a feature related to the data inquiry request obtained from the user device 100, and confirms the processed data that matches the data inquiry request or feature. Information including confirmed processing data and calculation results for the confirmed processing data can be provided.

FIG. 12 may correspond to an example of an information providing system that generalizes the operation of the server device 100 according to FIG. 11. The system of FIG. 12 includes a structure for managing event data matching preset data sources and topics to be processed to a certain data management format and storing the processed data in a database (1201). A structure for managing processed data that matches the feature for a data inquiry request to be identified, calculated, and provided with related information may also be included (1203). Additionally, in the information provision system of FIG. 12, various features for data inquiry and information provided in response to various features are learned, compared with information provided in response to actual data inquiry requests, and feedback is provided to make decisions for service. A management structure can also be built to be reflected in (1205).

It is obvious that each piece of information used in the process of the server device 100 performing an operation method for providing information according to FIGS. 3 to 12 can be combined in various forms.

The embodiments of the present invention disclosed in the specification and drawings are merely provided as specific examples to easily explain the technical content of the present invention and to facilitate understanding of the present invention, and are not intended to limit the scope of the present invention. In other words, it is obvious to those skilled in the art that other modifications based on the technical idea of the present invention can be implemented. Additionally, each of the above embodiments can be operated in combination with each other as needed. For example, all embodiments of the present invention can be implemented by a system by combining parts of each other.

Additionally, the method according to the system according to the present invention may be implemented in the form of program instructions that can be executed through various computer means and recorded on a computer-readable medium.

As such, various embodiments of the present invention may be implemented as computer readable code on a computer readable recording medium in certain respects. A computer-readable recording medium is any data storage device capable of storing data that can be read by a computer system. Examples of computer readable recording media include read only memory (ROM), random access memory (RAM), and compact disk-read only memory (CD-ROM). ), magnetic tapes, floppy disks, optical data storage devices, and carrier waves (data transmission over the Internet, etc.). Computer-readable recording media may also be distributed across networked computer systems, such that computer-readable code is stored and executed in a distributed manner. Additionally, functional programs, codes, and code segments for achieving various embodiments of the present invention can be easily interpreted by programmers skilled in the field to which the present invention is applied.

Additionally, it will be appreciated that the devices and methods according to various embodiments of the present invention can be implemented in the form of hardware, software, or a combination of hardware and software. Such software may, for example, use any storage device, volatile or non-volatile, such as ROM, whether erasable or rewritable, or memory such as, for example, RAM, memory chips, devices or integrated circuits; Alternatively, it may be stored on a storage medium that is optically or magnetically recordable and readable by a machine (e.g., a computer), for example, a compact disk (CD), DVD, magnetic disk, or magnetic tape. . Methods according to various embodiments of the present invention may be implemented by a computer including a control unit and a memory, or a vehicle including such memory or a computer, and such memory is a program containing instructions that implement the embodiments of the present invention. Alternatively, you can see that it is an example of a machine-readable storage medium suitable for storing programs.

Accordingly, the present invention includes a program containing code for implementing the device or method described in the claims of this specification and a machine-readable storage medium (such as a computer) storing such a program. Additionally, such programs may be transmitted electronically through any medium, such as communication signals transmitted over a wired or wireless connection, and the present invention includes equivalents thereof as appropriate.

Although the present invention has been described above with reference to embodiments of the present invention, the embodiments of the present invention disclosed in the specification and drawings are merely presented as specific examples to easily explain the technical content of the present invention and to aid understanding of the present invention. It is not intended to limit the scope. In addition, the embodiments according to the present invention described above are merely illustrative, and those skilled in the art will understand that various modifications and equivalent scope of embodiments are possible therefrom. Therefore, the true technical protection scope of the present invention should be determined by the following patent claims.

Claims (19)

In a method for an electronic device to provide information,
Obtaining data source management information for managing a data source for storing event data obtained in response to an event on a service related to the electronic device in a database;
Obtaining data storage management information for managing database settings for storing the event data in the database;
Setting to store processed data obtained by processing the event data in the database according to a data management format set based on the data source management information and the data storage management information; and
In response to a data inquiry request for searching data in the database, providing information related to a data set including one or more processed data confirmed from the database,
The data storage management information includes at least some data items designated by an administrator to set a data management format among a plurality of data items included in a specific topic corresponding to a specific data source related to the data source management information, ,
The step of providing information related to the data set is:
Confirming a specific data item corresponding to a data inquiry subject included in the data inquiry request among the at least some data items;
determining one data operator for the data search subject among one or more data operators set for the specific data item according to the data type of the specific data item; and
Comprising the step of providing information related to the data set set to include a result of calculating the one or more processed data according to the one data operator,
How to provide information. According to claim 1,
The event data is queued based on a message queue including one or more message queues,
How to provide information. According to claim 2,
The data source management information includes information about one or more data sources,
The first data source included in the one or more data sources corresponds to a first topic selected for the first data source among one or more topics corresponding to the one or more message queues,
How to provide information. According to claim 3,
The information about the first data source included in the data source management information includes information about the data subject corresponding to the first topic,
How to provide information. According to claim 3,
The data storage management information includes identification information identifying a data subject corresponding to the first topic,
How to provide information. According to claim 5,
The identification information is generated based on one of the user's customer ID (Identifier) on the service, the user's mail ID, the user's IP (Internet Protocol) address, and the user's terminal ID,
How to provide information. According to claim 5,
The data management format classifies and manages data in the form of rows set as units of the identification information,
How to provide information. According to claim 3,
The data storage management information includes information about one or more data items corresponding to the first topic.
How to provide information. According to claim 8,
The data storage management information is,
When a plurality of data related to a data subject corresponding to the first topic are identified in a first data item included in the one or more data items, the plurality of data is stored in a row of the first data item corresponding to the data subject. Contains information to set in (column) form,
How to provide information. According to clause 9,
The data management format includes identification information identifying a data subject corresponding to the first topic,
Classifying and managing each data item included in one or more data items corresponding to the first topic and one or more data identified for the data subject in each data item into columns corresponding to the identification information,
How to provide information. According to claim 1,
The data storage management information includes information about the validity period for which data is stored in the database,
How to provide information. According to claim 1,
The processed data is,
Identification information that identifies the data subject corresponding to the topic included in the data source management information,
Data items set corresponding to the topic in the data storage management information,
A data value identified in the event data based on the data subject and the data item, and
Including the time when the event data was obtained on the service,
How to provide information. According to claim 1,
The data inquiry request includes input information necessary for data inquiry,
The input information required for the data inquiry is set based on the data management format,
How to provide information. According to claim 13,
The data inquiry request includes information on a specific data inquiry subject and information on a specific data operator for the specific data inquiry subject.
How to provide information. According to claim 14,
The information related to the data set includes information about a result of calculating the one or more processed data based on the specific data operator,
How to provide information. According to claim 13,
The data inquiry request includes information about the inquiry period for data inquiry,
How to provide information. According to claim 16,
Each processed data included in the one or more processed data is confirmed based on the fact that the time when each event data corresponding to each processed data was acquired on the service is included in the inquiry period,
How to provide information. According to claim 13,
The data inquiry request includes information about the data subject and data item for data inquiry,
How to provide information. In an electronic device that provides information,
processor; and
Contains one or more memories that store one or more instructions,
The one or more instructions, when executed, cause the processor to:
Obtaining data source management information for managing a data source for storing event data obtained in response to an event on a service related to the electronic device in a database;
Obtaining data storage management information for managing database settings for storing the event data in the database;
Setting to store processed data obtained by processing the event data in the database according to a data management format set based on the data source management information and the data storage management information; and
In response to a data search request for searching data in the database, controlling the processor to perform a step of providing information related to a data set including one or more processed data identified from the database,
The data storage management information includes at least some data items designated by an administrator to set a data management format among a plurality of data items included in a specific topic corresponding to a specific data source related to the data source management information, ,
The step of providing information related to the data set is:
Confirming a specific data item corresponding to a data inquiry subject included in the data inquiry request among the at least some data items;
determining one data operator for the data search subject among one or more data operators set for the specific data item according to the data type of the specific data item; and
Comprising the step of providing information related to the data set set to include a result of calculating the one or more processed data according to the one data operator,
Electronic devices.

Images