Electronic device and data management method therefor
The electronic device and method address the challenge of managing abnormal data in large databases by creating and managing rules for data checks, enabling efficient detection and notification of exceptional data conditions, thus enhancing data quality monitoring and management.
Patent Information
- Application Number
- PCT/KR2023/007684
- Authority / Receiving Office
- WO · WO
- Patent Type
- Applications
- Current Assignee / Owner
- Priority Date
- 2023-05-30
- Filing Date
- 2023-06-21
- Publication Date
- 2024-12-05
AI Technical Summary
As online shopping increases, managing and detecting abnormal data patterns in large databases becomes challenging due to the sheer volume of data and potential gaps in data storage, necessitating a more efficient method to identify and notify users of exceptional data conditions.
An electronic device and method that create and manage rules for checking exceptional data in databases by using information about databases, tables, notification creation conditions, and time sets, allowing for user-defined rules and template rules to generate notifications based on data thresholds and priorities.
Enables users to conveniently create, view, and manage rules for detecting abnormal data, providing timely notifications to users based on data conditions, improving data quality monitoring and management efficiency.
Smart Images

Figure KR2023007684_05122024_PF_FP_ABST
Abstract
Description
Electronic devices and methods for managing their data
[0001] The present disclosure relates to an electronic device and a control method thereof for providing a platform that can more conveniently create and manage rules for checking exceptional data among data stored in a database.
[0002] As consumers increasingly purchase items online rather than offline, data related to orders and the delivery of items ordered by consumers is also increasing.
[0003] In a situation where a large amount of data is stored in a database every day, problems may arise where the number of specific data stored in the database is abnormally small or where specific types of data are not stored in the database for a certain period of time due to business or system reasons.
[0004] Accordingly, there is a need for a technology that allows users to more conveniently check whether such exceptional data exists.
[0005] In this regard, reference can be made to prior literature such as KR 10-2344661 B1.
[0006] The disclosed embodiments provide an electronic device and a data management method thereof. More specifically, the present invention aims to provide an electronic device and a control method thereof that provide a platform for more conveniently creating and managing rules for identifying exceptional data among data stored in a database.
[0007] The technical tasks to be achieved by this embodiment are not limited to the technical tasks described above, and other technical tasks can be inferred from the following embodiments.
[0008] One aspect of the present disclosure may provide a data management method, including: a step of checking information about a first rule including information about a first database, information about a first table stored in the first database, information about a first notification generation condition, and information about a first time set; a step of checking whether the first notification generation condition is satisfied for data included in the first table based on the information about the first time set; and a step of providing a notification to at least one user if the first notification generation condition is satisfied.
[0009] In addition, in one embodiment of the present disclosure, the data management method may further include a step of providing a list of a plurality of rules including the first rule.
[0010] In addition, in one embodiment of the present disclosure, the data management method may further include: a step of checking, based on information input from a user, information about a second database, information about a second table stored in the second database, information about a second time set, and a code about a second notification generation condition; a step of generating a second rule based on the information about the second database, the information about the second table, the information about the second time set, and the code about the second notification generation condition; and a step of adding the second rule to a list of the plurality of rules.
[0011] In addition, in one embodiment of the present disclosure, the data management method may further include: providing a list of one or more template rules; checking, based on information input from a user, information about a first template rule selected from among the one or more template rules, information about a third database, information about a third table stored in the third database, and information about a third time set; generating a third rule based on the information about the first template rule, the information about the third database, the information about the third table, and the information about the third time set; and adding the third rule to the list of the plurality of rules.
[0012] In addition, in one embodiment of the present disclosure, a data management method may be provided, wherein the information regarding the first template rule includes information regarding one or more parameters, and the one or more parameters are determined based on a code regarding the first template rule.
[0013] In addition, in one embodiment of the present disclosure, the data management method may further include a step of checking changed information regarding a fourth rule among the list of the plurality of rules based on information input by a user; and a step of storing information regarding the fourth rule including the changed information.
[0014] In addition, in one embodiment of the present disclosure, the information regarding the first rule further includes information regarding a first column in a first table, and the step of checking whether the first notification generation condition is satisfied for data included in the first table includes a step of checking whether the first notification generation condition is satisfied for data included in the first column in the first table based on information regarding the first time set, thereby providing a data management method.
[0015] Additionally, in one embodiment of the present disclosure, the information regarding the first rule may provide a data management method further including information regarding at least one user to whom a notification is to be provided.
[0016] In addition, in one embodiment of the present disclosure, information regarding the first rule further includes information regarding priority, and when there are multiple rules for checking whether a notification generation condition is satisfied for data included in the first table at the same time, a data management method can be provided in which whether a notification generation condition corresponding to a higher priority is satisfied is checked first.
[0017] In addition, in one embodiment of the present disclosure, information regarding a first notification generation condition includes information regarding a set period and information regarding one or more threshold values, and a data management method may be provided in which the step of checking whether the first notification generation condition is satisfied for data included in the first table includes the step of checking, based on information regarding the first time set, whether the number of data stored during the set period included in the first table is greater than or equal to one or more threshold values.
[0018] In addition, in one embodiment of the present disclosure, the step of providing a notification to the at least one user may include providing a notification to the at least one user by a first means when the number of data stored during the set period, included in the first table, is greater than or equal to a first threshold value, and providing a notification to the at least one user by a second means when the number of data stored during the set period, included in the first table, is less than the first threshold value and greater than or equal to a second threshold value. A data management method may be provided.
[0019] In addition, in one embodiment of the present disclosure, the step of providing a notification to the at least one user may include providing a notification to the at least one user by a first means when the number of data stored during the set period, included in the first table, is less than or equal to a first threshold value, and providing a notification to the at least one user by a second means when the number of data stored during the set period, included in the first table, is greater than the first threshold value and less than or equal to a second threshold value. A data management method may be provided.
[0020] In addition, in one embodiment of the present disclosure, the data management method may further include a step of providing a recommended value for the one or more threshold values based on a history of data stored in the first table.
[0021] Another aspect of the present disclosure provides an electronic device comprising a transceiver, a memory, and a processor, wherein the processor is configured to: check information about a first rule including information about a first database, information about a first table stored in the first database, information about a first notification generation condition, and information about a first time set; and, based on the information about the first time set, check whether the first notification generation condition is satisfied for data included in the first table; and, if the first notification generation condition is satisfied, provide a notification to at least one user.
[0022] Another aspect of the present disclosure may provide a computer-readable recording medium having recorded thereon a program for implementing a method performed by an electronic device.
[0023] Specific details of other embodiments are included in the detailed description and drawings.
[0024] According to the proposed embodiment, one or more of the following effects can be expected.
[0025] According to an embodiment of the present specification, if there is abnormal data among the data stored in the database, the user can receive notification about it more conveniently.
[0026] In addition, according to the embodiment of the present specification, a user can more conveniently create, search, and manage rules for checking abnormal data among data stored in a database by using previously created rules or template rules.
[0027] The effects of the invention are not limited to the effects mentioned above, and other effects not mentioned will be clearly understood by those skilled in the art from the description of the claims.
[0028] Figure 1 illustrates a system according to one embodiment.
[0029] FIG. 2 is a diagram illustrating a process in which an electronic device manages data according to one embodiment.
[0030] FIGS. 3A to 3D illustrate a user interface provided by an electronic device according to one embodiment.
[0031] FIGS. 4A to 4F illustrate a user interface provided by an electronic device according to one embodiment.
[0032] FIGS. 5A to 5C illustrate a user interface provided by an electronic device according to one embodiment.
[0033] FIGS. 6A and 6B illustrate a user interface provided by an electronic device according to one embodiment.
[0034] FIGS. 7A to 7D illustrate a user interface provided by an electronic device according to one embodiment.
[0035] FIGS. 8A and 8B illustrate a user interface provided by an electronic device according to one embodiment.
[0036] Figure 9 illustrates an example of a notification provided to a user when a notification generation condition is satisfied.
[0037] FIG. 10 illustrates a flowchart of a data management method of an electronic device according to one embodiment.
[0038] Figure 11 shows a block diagram of an electronic device according to one embodiment.
[0039] The terms used in the embodiments have been selected from widely used and common terms, taking into account the functions of the present disclosure. However, these terms may vary depending on the intentions of those skilled in the art, precedents, the emergence of new technologies, etc. Furthermore, in certain cases, terms may be arbitrarily selected by the applicant, in which case their meanings will be described in detail in the relevant description. Therefore, the terms used in this disclosure should not be defined simply as names of terms, but rather based on the meanings of the terms and the overall content of the present disclosure.
[0040] When a part of a specification is said to "include" a component, this does not mean that it excludes other components, but rather that it may include other components, unless otherwise stated.
[0041] The expression "at least one of a, b, and c" described throughout the specification may encompass 'a alone', 'b alone', 'c alone', 'a and b', 'a and c', 'b and c', or 'all of a, b, and c'.
[0042] The "terminal" mentioned below may be implemented as a computer or portable terminal that can connect to a server or other terminal via a network. Here, the computer includes, for example, a notebook, desktop, laptop, etc. equipped with a web browser, and the portable terminal may include, for example, a wireless communication device that guarantees portability and mobility, and may include all types of handheld-based wireless communication devices such as communication-based terminals such as IMT (International Mobile Telecommunication), CDMA (Code Division Multiple Access), W-CDMA (W-Code Division Multiple Access), LTE (Long Term Evolution), smartphones, tablet PCs, etc.
[0043] Below, embodiments of the present disclosure are described in detail with reference to the attached drawings so that those skilled in the art can easily implement the present disclosure. However, the present disclosure may be implemented in various different forms and is not limited to the embodiments described herein.
[0044] Hereinafter, embodiments of the present disclosure will be described in detail with reference to the drawings.
[0045] Figure 1 illustrates a system according to one embodiment.
[0046] Referring to FIG. 1, the system may include at least one of an electronic device (100), one or more terminals (120, 140, 160), and a network (180). Meanwhile, the system illustrated in FIG. 1 only illustrates components related to the present embodiment. Therefore, those skilled in the art will appreciate that, in addition to the components illustrated in FIG. 1, other general-purpose components may be included.
[0047] An electronic device (100) is a device that configures and provides various types of information. The electronic device (100) may provide the configured information as a web page or application screen, or may provide the information in a form that can be displayed as a web page or application screen on a receiving terminal.
[0048] According to one embodiment, the electronic device (100) may provide a service for users to more conveniently check the quality of data stored in a database. For example, the electronic device (100) may check information about a rule including information about a database, information about a table stored in the database, information about a notification generation condition, and information about a time set. Thereafter, based on the information about the time set, the electronic device (100) may determine whether a notification generation condition is satisfied for data included in the table, and if the notification generation condition is satisfied, may provide a notification to at least one user.
[0049] One or more user terminals (120, 140, 160) are terminals used by users, and users can access services provided by the network (180) using their respective terminals (120, 140, 160). For example, one or more user terminals (120, 140, 160) can obtain user input for setting databases and tables in which data is stored, time sets for executing rules, or notification generation conditions. Alternatively, one or more user terminals (120, 140, 160) can provide a notification to at least one user when a notification generation condition is satisfied.
[0050] One or more user terminals (120, 140, 160) and the electronic device (100) can communicate with each other within a network (180). The network (180) includes a Local Area Network (LAN), a Wide Area Network (WAN), a Value Added Network (VAN), a mobile radio communication network, a satellite communication network, and a combination thereof, and is a comprehensive data communication network that enables each network component illustrated in FIG. 1 to communicate smoothly with each other, and may include wired Internet, wireless Internet, and mobile radio communication networks. Wireless communication may include, but is not limited to, wireless LAN (Wi-Fi), Bluetooth, Bluetooth low energy, Zigbee, Wi-Fi Direct (WFD), ultra wideband (UWB), infrared communication (IrDA, infrared Data Association), NFC (Near Field Communication), etc., for example.
[0051] FIG. 2 is a drawing for explaining a process in which an electronic device (100) manages data according to one embodiment.
[0052] According to one embodiment, the electronic device (100) can check information about a rule including information about a database, information about a table stored in the database, information about a notification generation condition, and information about a time set based on information input from a user.
[0053] For example, the electronic device (100) may provide a user with a platform for more conveniently creating and managing rules for identifying exceptional data among data stored in a database via a user terminal. The user terminal may utilize the platform to obtain user input, such as setting the database and table where data is stored, the time set for rule execution, or the conditions for generating notifications, and transmit the obtained information to the electronic device (100).
[0054] According to one embodiment, the electronic device (100) can generate a new rule based on information obtained from a user and store the generated rule in a first database (200).
[0055] For example, the user terminal can use the platform to set a database and table where data is stored, a set of times to execute rules, etc., obtain user input for entering code regarding notification generation conditions, and transmit the obtained information to the electronic device (100). The electronic device (100) can create a new rule based on the information received from the user terminal and add the created rule to the rule list (220) of the first database (200). In addition, the electronic device (100) can add information regarding a sub-database corresponding to the created rule to the data source list (260).
[0056] For another example, the electronic device (100) may provide a list of one or more template rules via a user terminal. Thereafter, the user terminal may obtain a user input for selecting one of the one or more template rules, a database and table storing the data, a set of time periods for executing the rule, etc., and transmit the obtained information to the electronic device (100). The electronic device (100) may generate a new rule based on the information received from the user terminal and add the generated rule to the rule list (220) of the first database (200). In addition, the electronic device (100) may add information regarding a sub-database corresponding to the generated rule to the data source list (260).
[0057] At this time, the first database (200) and the second database (280) are data structures implemented in a predetermined storage space, and may include relational databases such as MySQL, Oracle, and Mssql, non-relational databases such as Redis, MongoDB, and CouchDB, open source search engines such as Elasticsearch, and combinations thereof.
[0058] According to one embodiment, the electronic device (100) can identify a rule corresponding to a time set that satisfies a set condition among a plurality of rules included in a rule list (220) and add the identified rule to a rule list (240) that is being executed.
[0059] For example, the electronic device (100) can identify a rule set to be repeatedly performed at a set time based on information about a time set corresponding to each of a plurality of rules included in the rule list (220), and add the rule to the rule list (240) that is being executed.
[0060] As another example, the electronic device (100) may identify a rule set to be executed within a specific time from the current time based on information about a time set corresponding to each of a plurality of rules included in the rule list (220), and add the rule to the rule list (240) that is being executed.
[0061] According to one embodiment, the electronic device (100) may perform an operation according to one or more rules included in the running rule list (240) based on information about a time set. More specifically, the electronic device (100) may determine whether a notification generation condition is satisfied for data stored in the second database (280) based on parameters corresponding to each of the one or more rules.
[0062] For example, the electronic device (100) can check the table regarding recommended stores stored in the first sub-database (282) of the second database (280) at 8:00 AM every day. Thereafter, the electronic device (100) can check whether the number of data stored in the table regarding recommended stores over the past 24 hours is greater than a threshold value.
[0063] For another example, the electronic device (100) can check the table regarding delivery task identifiers stored in the second sub-database (284) of the second database (280) every 12 hours. Thereafter, the electronic device (100) can check whether the number of data stored in the table regarding delivery task identifiers over the past 12 hours exists.
[0064] According to one embodiment, the electronic device (100) may perform an operation according to one or more rules based on information about a column corresponding to each of one or more rules included in the list of rules being executed (240).
[0065] For example, the electronic device (100) can check the table regarding user reviews stored in the first sub-database (282) of the second database (280) at 10:00 AM every day. Thereafter, the electronic device (100) can check whether the number of data stored in the first column of the table regarding user reviews over the past 24 hours is greater than or equal to a threshold value.
[0066] According to one embodiment, the electronic device (100) may perform an operation according to one or more rules based on information about a priority corresponding to each of one or more rules included in the running rule list (240).
[0067] For example, the electronic device (100) may check the first rule and the second rule set to check the data included in the table regarding the order task identifier stored in the second sub-database (284) of the second database (280) at 2:00 PM every day. In this case, the electronic device (100) may perform a task according to the first rule having a higher priority among the first and second rules, and then perform a task according to the second rule.
[0068] For another example, the electronic device (100) may check the third and fourth rules, which are set to check data included in the first column of the table regarding user reviews stored in the first sub-database (282) of the second database (280) at 10:00 AM every day. In this case, the electronic device (100) may perform a task according to the third rule, which has a higher priority among the third and fourth rules, and then perform a task according to the fourth rule.
[0069] According to one embodiment, the electronic device (100) may provide a notification to at least one user when a notification generation condition is satisfied based on information about at least one user to whom a notification corresponding to each of one or more rules included in the list of running rules (240) is to be provided. More specifically, the electronic device (100) may provide a notification to at least one user corresponding to each of one or more rules using a tool such as VictorOps or Slack, a text message, an email, or a phone call, when the notification generation condition is satisfied.
[0070] For example, the electronic device (100) may provide a notification to at least one user through a channel corresponding to the rule when the number of data stored in the last 24 hours, included in the table regarding the recommended store, is below a threshold.
[0071] As another example, the electronic device (100) may provide a notification to at least one user through a channel corresponding to the rule when the number of data stored in the last 24 hours, included in the first column of the table regarding user reviews, is below a threshold.
[0072] According to one embodiment, the electronic device (100) may provide notifications by different means based on information about one or more thresholds corresponding to each of one or more rules included in the list of rules being executed (240).
[0073] For example, if the number of data stored in the last 12 hours, which is included in the table regarding user ratings, is less than or equal to a first threshold, the electronic device (100) may provide a notification to at least one user using a text message, email, phone call, or the like. Additionally, if the number of data stored in the last 12 hours, which is included in the table regarding user ratings, is greater than the first threshold and less than or equal to a second threshold, the electronic device (100) may provide a notification to at least one user using a tool such as VictorOps or Slack.
[0074] For another example, if there is no data stored in the table regarding delivery task identifiers for the past 12 hours, the electronic device (100) may provide a notification to at least one user using a text message, email, phone call, or the like. Additionally, if the number of data included in the table regarding delivery task identifiers is greater than 0 and less than or equal to a third threshold, the electronic device (100) may provide a notification to at least one user using a tool such as VictorOps or Slack.
[0075] In this way, by providing notifications through different means according to the threshold value that serves as the basis for the corresponding notification generation condition of the electronic device (100), the user can quickly identify the problem according to the severity of the problem.
[0076] According to one embodiment, the electronic device (100) may provide the user with recommended values for one or more threshold values that serve as criteria for notification generation conditions based on the history of data stored in the second database (280).
[0077] For example, the electronic device (100) can check the average value of the number of data stored for every 24 hours included in the table regarding the recommended store and provide the average value as a recommended value.
[0078] As another example, the electronic device (100) can check the median value of the number of data stored for every 24 hours included in the first column of the table regarding user reviews, and provide the average value as a recommended value.
[0079] Meanwhile, although FIG. 2 illustrates that the first database (200) and the second database (280) exist outside the electronic device (100), this is merely an example, and the first database (200) and the second database (280) may be included in the electronic device (100). In addition, although FIG. 2 illustrates that the first database (200) and the second database (280) exist separately, this is merely an example, and the first database (200) and the second database (280) may exist as a single database.
[0080] FIGS. 3A to 3D illustrate a user interface (300) provided by an electronic device (100) according to one embodiment.
[0081] According to one embodiment, the electronic device (100) may provide a user interface (UI) (300) including a list of one or more rules to the user via the user terminal. For example, referring to FIG. 3A, the user terminal may receive information from the electronic device (100) in a form that can be displayed as a web page or an application screen, and display a user interface (300) including an area for displaying information for identifying one or more rules based on the received information, an area for displaying icons for triggering actions according to one or more rules, or an area for displaying descriptions of one or more rules.
[0082] At this time, the rule may represent a set of various parameters set by the user to check the quality of data stored in the database, and may be referred to as a data quality rule (DQC), but is not limited thereto.
[0083] According to one embodiment, the user interface (300) may include an area (320) that displays information for identifying one or more rules. For example, the area (320) may display 56 as information for identifying a first rule (302), 55 as information for identifying a second rule (304), and 47 as information for identifying a fourth rule (308).
[0084] According to one embodiment, the user interface (300) may include an area (325) that displays the names of one or more rules. For example, the area (325) may display "eats recommend valid store count greater than 160000" as the name of the third rule (306), and "dws_courier_v2 courier_Id count check" as the name of the fifth rule (310). In this case, the name of the rule is information entered when creating the rule so that the user can more easily distinguish the rule, and may include, but is not limited to, the type or content of data to be confirmed through the rule.
[0085] According to one embodiment, the user interface (300) may include an area (330) that displays the type of one or more rules. For example, the area (330) may display a Custom SQL rule as the type of the second rule (304), and a Template rule as the type of the fifth rule (310).
[0086] At this time, the rule type is a value indicating how the user set the relevant parameters when creating the rule. A Custom SQL rule indicates that the user created the rule by directly entering code, and a Template rule indicates that the user created the rule using a previously created template rule. This will be described in detail with reference to FIGS. 4A to 4F.
[0087] In one embodiment, the user interface (300) may include an area (335) that displays a set of times corresponding to one or more rules. For example, the area (335) may display 008*** indicating that a task according to the first rule (302) is set to be performed every day at 8:00 AM. Alternatively, the area (335) may display 0* / 12*** indicating that a task according to the third rule (306) is set to be performed every 12 hours at the top of the hour.
[0088] According to one embodiment, the user interface (300) may include an area (340) that displays a script corresponding to one or more rules. For example, in relation to the second rule (304) of the Custom SQL rule type, the area (340) may display a code directly entered by the user. Alternatively, in relation to the fifth rule (310) of the Template rule type, the area (340) may display a code corresponding to a template rule used by the user when creating the fifth rule (310).
[0089] According to one embodiment, the user interface (300) may include an area (345) that displays a user's description regarding one or more rules. For example, the area (345) may display "valid stores (app_display, not deleted) greater than 160 K" as the user's description regarding the third rule (306). Alternatively, if the user has not entered a description regarding the first rule (302), the area (340) may be blank. In this case, the user's description regarding the rule may include, but is not limited to, information entered by the user when creating or modifying the rule to more easily distinguish the rule, such as the type or content of data to be confirmed through the rule.
[0090] According to one embodiment, the user interface (300) may include an area (350) that displays an icon for stopping the performance of an operation according to each of one or more rules. More specifically, a toggle switch may be displayed in the area (350) as a user interface component for stopping the performance of an operation according to each of one or more rules.
[0091] For example, if the user activates the toggle switch corresponding to the third rule (306), the repeated execution of the task according to the third rule (306) may continue. Alternatively, if the user deactivates the toggle switch corresponding to the second rule (304), the repeated execution of the task according to the second rule (304) may be stopped or omitted.
[0092] According to one embodiment, the user interface (300) may include an area (355) for controlling and managing one or more rules. More specifically, the area (355) may display a note icon and a play icon as icons for controlling and managing each of the one or more rules.
[0093] For example, a user can change setting information related to the fourth rule (308) by selecting a note icon corresponding to the fourth rule (308). Alternatively, a user can trigger an action according to the first rule (302) by selecting a play icon corresponding to the first rule (302).
[0094] According to one embodiment, the user interface (300) may include, in addition to the areas illustrated in FIGS. 3A to 3D , areas that display various parameters regarding a rule based on user input, etc. For example, the user interface (300) may include areas that display information regarding a table corresponding to a rule, information regarding columns, information regarding one or more threshold values, or information regarding a user who created the rule.
[0095] According to one embodiment, the user interface (300) may include an area (360) for searching for a specific rule. For example, if a user inputs the name of a rule to be searched for, etc., into the area (360), a list of one or more rules corresponding to the input search term may be provided.
[0096] Referring to FIG. 3b, if a user enters "Rule Name - dws" in the field (360), a list of one or more rules corresponding to names containing dws may be provided. Alternatively, referring to FIG. 3c, if a user enters "Rule Type - Custom" in the field (360), a list of one or more rules corresponding to the Custom SQL rule type may be provided. Referring to FIG. 3d, if a user enters "Table to Check - Courier" in the field (360), a list of one or more rules corresponding to columns containing Courier may be provided.
[0097] Meanwhile, the specific examples of various parameters regarding the types and rules of the user interface components described above are merely examples, and it is obvious to a person skilled in the art to which the present disclosure pertains that the present disclosure can be implemented with examples different from the above.
[0098] FIGS. 4A to 4F illustrate a user interface (400) provided by an electronic device (100) according to one embodiment.
[0099] According to one embodiment, the electronic device (100) may provide a user interface (400) including a list of one or more rules to a user through a user terminal according to one embodiment. For example, referring to FIG. 4A, the user terminal may receive information from the electronic device (100) in a form that can be displayed as a web page or an application screen, and display a user interface (400) including an area for displaying information for identifying one or more rules based on the received information, an area for displaying icons for triggering actions according to one or more rules, or an area for displaying descriptions of one or more rules.
[0100] According to one embodiment, the electronic device (100) may provide a user interface (420) for creating a new rule through the user terminal based on input obtained from the user. For example, referring to FIGS. 4A and 4B , the user terminal may obtain a user input for selecting an additional icon (410) and transmit a user interface request for creating a new rule to the electronic device (100). The user terminal may receive information from the electronic device (100) in a form that can be displayed as a web page or application screen, and display a pop-up window for creating a new rule based on the received information.
[0101] Meanwhile, FIGS. 4b to 4f illustrate a pop-up window as a user interface (420) for creating a new rule, but the user interface (420) of the present disclosure may be implemented in various forms, such as a modal window, and is not limited thereto.
[0102] According to one embodiment, the user interface (420) may include an area (425) for setting a name of a rule. For example, when a user wishes to create a new rule, the user may input the type or content of data to be confirmed through the rule into the area (425) to more easily distinguish the rule. Meanwhile, the name of the rule entered into the area (425) may be displayed in the area (325) of the user interface (300) of FIGS. 3A to 3D.
[0103] According to one embodiment, the user interface (420) may include an area (430) for setting a user description of a rule. For example, when a user wishes to create a new rule, the user may input the type or content of data to be confirmed through the rule into the area (430) to more easily distinguish the rule. Meanwhile, the description of the rule entered into the area (430) may be displayed in the area (345) of the user interface (300) of FIGS. 3A to 3D .
[0104] According to one embodiment, the user interface (420) may include an area (435) for setting a time set corresponding to a rule. For example, a user may input time information for the electronic device (100) to perform a task according to the rule in units of minutes, hours, days, months, and weeks into the area (435). Meanwhile, the time set corresponding to the rule input into the area (435) may be displayed in the area (335) of the user interface (300) of FIGS. 3A to 3D .
[0105] According to one embodiment, the user interface (420) may include an area (440) for setting up a database or sub-database in which data for quality verification is stored. For example, when a user selects a downward pointing icon within the area (440) or positions a cursor within the area (440), a pull-down menu or drop-down list containing a list of databases may be provided. Thereafter, the user terminal may obtain a user input for selecting one database from the list and display the selected database in the area (440).
[0106] Referring to FIG. 4c, a pull-down menu (442) containing a list of databases storing data for quality verification may be provided. Thereafter, the user terminal may obtain a user input for selecting a third database and display the selected third database in an area (440).
[0107] According to one embodiment, the user interface (420) may include an area (445) for setting a table containing data for which quality is to be verified. For example, a user may input a table containing data for which quality is to be verified among one or more tables stored in a database set in the area (440) into the area (445).
[0108] According to one embodiment, the user interface (420) may include an area (450) for setting at least one user to whom a notification will be provided when a notification generation condition is determined to be satisfied. For example, when a user selects a downward pointing icon within the area (450) or positions a cursor within the area (450), a pull-down menu or drop-down list containing a list of messaging channels may be provided. Thereafter, the user terminal may obtain a user input for selecting one messaging channel from the list and display the selected messaging channel in the area (450).
[0109] Referring to FIG. 4d, a pull-down menu (452) may be provided that includes a list of messaging channels corresponding to at least one user to whom notifications are to be provided. Thereafter, the user terminal may obtain a user input for selecting a second messaging channel and display the selected second messaging channel in an area (450).
[0110] According to one embodiment, the user interface (420) may include an area (455) for setting the type of rule. For example, referring to FIGS. 4B to 4E , if a user selects a Template rule, an area may be displayed where parameters can be set according to an already created template rule. Alternatively, referring to FIG. 4F , if a user selects a Custom SQL rule, an area (495) may be displayed where code can be directly entered.
[0111] At this time, template rules can represent a specific format structure created to allow users to input common parameters, allowing them to more conveniently create rules for frequently used formats. Users can create template rules of any format by directly entering code, and can more conveniently create rules by selecting one of one or more template rules already created. This will be described in detail with reference to Figures 6a and 6b.
[0112] According to one embodiment, the user interface (420) may include an area (460) for setting template rules. For example, when a user selects a downward pointing icon within the area (460) or positions a cursor within the area (460), a pull-down menu or drop-down list containing a list of template rules may be provided. Thereafter, the user terminal may obtain a user input for selecting one template rule from the list and display the selected template rule in the area (460).
[0113] Referring to FIG. 4e, a pull-down menu (462) containing a list of one or more template rules may be provided. Thereafter, the user terminal may obtain a user input for selecting a template rule with a unique value or fixed value name, and display the selected template rule with a unique value or fixed value name in an area (460).
[0114] According to one embodiment, the user interface (420) may include areas (465, 470, 475, 480, 485) for setting one or more parameters according to a template rule selected by the user.
[0115] For example, if a user selects a template rule named Unique value, fixed value, the user terminal may display an area (465) for setting a filtering condition, an area (470) for setting a partition format, an area (475) for setting a column to be checked, an area (480) for setting a comparison method, and an area (485) for setting a threshold. However, this is only one embodiment, and depending on the template rule selected by the user, the user terminal may display an area for setting different parameters.
[0116] According to one embodiment, the user interface (420) may include an area (490) for setting whether to perform a task according to a rule. For example, if the user selects a check box displayed in the area (490), the repeated performance of the task according to the rule may continue. Alternatively, if the user does not select a check box displayed in the area (490), the repeated performance of the task according to the rule may be omitted. Meanwhile, if a check box displayed in the area (490) is selected, a toggle switch displayed in the area (350) of the user interface (300) of FIGS. 3A to 3D may be activated, and if a check box displayed in the area (490) is not selected, the toggle switch may be deactivated.
[0117] According to one embodiment, the electronic device (100) may create a new rule based on user input and add the created rule to a list of one or more rules. For example, if the user sets various parameters for a rule and selects a save icon, a rule may be created based on the set parameters, and the created rule may be newly displayed in a list of one or more rules on the user interface (400).
[0118] Meanwhile, the specific examples of various parameters regarding the types and rules of the user interface components described above are merely examples, and it is obvious to a person skilled in the art to which the present disclosure pertains that the present disclosure can be implemented with examples different from the above.
[0119] FIGS. 5A to 5C illustrate a user interface (500) provided by an electronic device (100) according to one embodiment.
[0120] According to one embodiment, the electronic device (100) may provide a user interface (500) including a list of one or more rules to a user through a user terminal according to one embodiment. For example, referring to FIG. 5A, the user terminal may receive information from the electronic device (100) in a form that can be displayed as a web page or an application screen, and display a user interface (500) including an area for displaying information for identifying one or more rules based on the received information, an area for displaying icons for triggering actions according to one or more rules, or an area for displaying descriptions of one or more rules.
[0121] According to one embodiment, the electronic device (100) may provide the user with a user interface (520) for changing setting information related to a rule through the user terminal based on an input obtained from the user. For example, referring to FIGS. 5A and 5B , the user terminal may obtain a user input for selecting a note icon corresponding to a first rule (510) and transmit a user interface request for changing setting information related to the first rule (510) to the electronic device (100). The user terminal may receive information in a form that can be displayed as a web page or application screen, etc. from the electronic device (100), and may display a pop-up window for changing setting information related to the first rule (510) on the display based on the received information.
[0122] Meanwhile, FIG. 5b illustrates a pop-up window as a user interface (520) for changing setting information related to rules, but the user interface (520) of the present disclosure may be implemented in various forms, such as a modal window, and is not limited thereto.
[0123] According to one embodiment, preset information regarding the first rule (510) may be displayed in one or more areas within the user interface (520).
[0124] For example, "Data exists in eats_dish_review_rating in past 24 hours" set as the name of the first rule (510) may be displayed in area (525), nothing may be displayed in area (530) because the user has not entered a description for the first rule (510), and * / 10**** may be displayed in area (535) indicating that the task according to the first rule (510) is set to be performed every 10 minutes. Additionally, default-hive-store set as a database storing data to be checked for quality according to the first rule (510) may be displayed in area (540), ods.eats_dish_review_rating set as a table containing data to be checked for quality according to the first rule (510) may be displayed in area (545), and eats_data_alert set as a messaging channel corresponding to at least one user to whom a notification will be provided may be displayed in area (550). Information that the first rule (510) type is a Custom SQL rule can be displayed in the area (555), and a code directly entered by the user in relation to the notification generation condition corresponding to the first rule (510) can be displayed in the area (560).
[0125] According to one embodiment, the electronic device (100) can identify changed information regarding the first rule (510) based on input obtained from the user, and store information regarding the first rule (510) including the changed information.
[0126] For example, the user terminal may change the time set for performing the task according to the first rule (510) displayed in the area (535) from * / 10**** to * / 12**** and obtain a user input selecting the save icon. Accordingly, referring to FIG. 5c, the user terminal may display * / 12**** in the area (565), indicating that the task according to the first rule (510) is set to be performed every 12 minutes, and transmit the changed information to the electronic device (100).
[0127] Meanwhile, the specific examples of various parameters regarding the types and rules of the user interface components described above are merely examples, and it is obvious to a person skilled in the art to which the present disclosure pertains that the present disclosure can be implemented with examples different from the above.
[0128] FIGS. 6A and 6B illustrate a user interface (600) provided by an electronic device (100) according to one embodiment.
[0129] According to one embodiment, the electronic device (100) may provide a user interface (600) including a list of one or more template rules to a user terminal. For example, referring to FIG. 6A, the user terminal may receive information from the electronic device (100) in a form that can be displayed as a web page or an application screen, and display a user interface (600) including an area for displaying information for identifying one or more template rules based on the received information, an area for displaying an icon for changing information related to one or more template rules, or an area for displaying a description of one or more template rules.
[0130] Meanwhile, one or more template rules displayed in the user interface (600) may correspond to one or more template rules included in the pull-down menu (462) of FIG. 4e.
[0131] According to one embodiment, the user interface (600) may include an area (620) for selecting one or more template rules. For example, a user may more conveniently manage template rules by selecting a check box corresponding to each of the one or more template rules included in the area (620).
[0132] According to one embodiment, the user interface (600) may include an area (625) that displays information for identifying one or more template rules. For example, the area (625) may display a number 5 as information for identifying a first template rule (605), a number 4 as information for identifying a second template rule (610), and a number 2 as information for identifying a third template rule (615).
[0133] According to one embodiment, the user interface (600) may include an area (630) that displays the names of one or more template rules. For example, the area (630) may display "Table row number, 1 day volatility" as the name of the third template rule (615), and "Number of null values, fixed values" as the name of the first template rule (605). In this case, the name of the template rule refers to information entered by the user when creating the template rule to more easily distinguish the template rule, and may include, but is not limited to, the format of the notification creation condition according to the template rule.
[0134] According to one embodiment, the user interface (600) may include an area (635) that displays a confirmation type corresponding to one or more template rules. For example, the area (635) may display "Column" to indicate that data contained in a specific column is configured to be confirmed when using the second template rule (610). Alternatively, the area (635) may display "Table" to indicate that data contained in a specific table is configured to be confirmed when using the third template rule (615).
[0135] According to one embodiment, the user interface (600) may include an area (640) that displays a script corresponding to one or more template rules. For example, with respect to the first template rule (605), the area (640) may display a code directly entered by the user.
[0136] According to one embodiment, the user interface (600) may include an area (645) that displays a user's description regarding one or more template rules. If the user does not enter a description regarding the second template rule (610), the area (645) may be blank. In this case, the user's description regarding the template rule may include, but is not limited to, information entered by the user when creating or modifying the template rule to more easily distinguish the template rule, such as information regarding parameters included in the template rule.
[0137] According to one embodiment, the user interface (600) may include an area (650) for controlling and managing one or more template rules. For example, a user may change setting information related to a third template rule (615) by selecting a note icon corresponding to the third template rule (615).
[0138] Meanwhile, the user interface (600) may include an area that displays various parameters regarding template rules based on user input, etc., in addition to the areas shown in FIGS. 6A and 6B.
[0139] According to one embodiment, the user interface (600) may include an area (655) for searching for a specific template rule. For example, if a user inputs the name of a template rule to be searched for, etc., into the area (655), a list of one or more template rules corresponding to the input search term may be provided.
[0140] Referring to FIG. 6b, if a user enters volatility in the field (655), a list of one or more template rules corresponding to names or scripts containing volatility may be provided.
[0141] Meanwhile, the specific examples of the types of user interface components and various parameters regarding template rules described above are merely examples, and it is obvious to a person skilled in the art to which the present disclosure pertains that the present disclosure can be implemented with examples different from the above.
[0142] FIGS. 7A to 7D illustrate a user interface (700) provided by an electronic device (100) according to one embodiment.
[0143] According to one embodiment, the electronic device (100) may provide a user interface (700) including a list of one or more template rules to a user terminal. For example, referring to FIG. 7A, the user terminal may receive information from the electronic device (100) in a form that can be displayed as a web page or an application screen, and display a user interface (700) including an area for displaying information for identifying one or more template rules based on the received information, an area for displaying an icon for changing information related to one or more template rules, or an area for displaying a description of one or more template rules.
[0144] According to one embodiment, the electronic device (100) may provide a user interface (720) for generating a new template rule through the user terminal based on input obtained from the user. For example, referring to FIGS. 7A and 7B , the user terminal may obtain a user input for selecting an additional icon (710) and transmit a user interface request for generating a new template rule to the electronic device (100). The user terminal may receive information from the electronic device (100) in a form that can be displayed as a web page or application screen, and may display a pop-up window for generating a new template rule based on the received information on the display.
[0145] Meanwhile, FIGS. 7b to 7d illustrate a pop-up window as a user interface (720) for creating a new template rule, but the user interface (420) of the present disclosure may be implemented in various forms, such as a modal window, and is not limited thereto.
[0146] According to one embodiment, the user interface (720) may include an area (730) for setting the name of a template rule. For example, when a user wishes to create a new template rule, the user may input the format of a notification generation condition according to the template rule into the area (730) to more easily distinguish the template rule. Meanwhile, the name of the template rule entered into the area (730) may be displayed in the area (630) of the user interface (600) of FIGS. 6A to 6D .
[0147] According to one embodiment, the user interface (720) may include an area (740) for setting a confirmation type corresponding to a template rule. For example, when a user selects a downward icon within the area (740) or positions a cursor within the area (740), a pull-down menu or drop-down list containing a list of confirmation types may be provided. Thereafter, the user terminal may obtain a user input for selecting one of the confirmation types from the list and display the selected confirmation type in the area (740).
[0148] Referring to FIG. 7c, a pull-down menu (750) containing a list of confirmation types corresponding to template rules may be provided. Thereafter, the user terminal may obtain a user input for selecting a table and display the selected table in the area (740).
[0149] Meanwhile, the input confirmation type selected in the area (740) may be displayed in the area (635) of the user interface (600) of FIGS. 6A to 6D.
[0150] According to one embodiment, the user interface (720) may include an area (760) for setting a user description regarding a template rule. For example, when a user wishes to create a new template rule, the user may input information regarding parameters included in the template rule into the area (760) to more easily distinguish the template rule. Meanwhile, the description regarding the template rule entered into the area (760) may be displayed in the area (645) of the user interface (600) of FIGS. 6A to 6D .
[0151] According to one embodiment, the user interface (720) may include an area (770) into which a user can enter code corresponding to a template rule. For example, a user may enter code configured to input common parameters among frequently used form rules into the area (770).
[0152] According to one embodiment, the electronic device (100) may determine parameters to be set by the user based on a script corresponding to a template rule. For example, referring to FIG. 7d, the electronic device (100) may determine filtering conditions (filter_condition), partition format (partition format), check_column, and threshold (threshold) as parameters to be set by the user based on a code entered by the user in the area (770).
[0153] According to one embodiment, the electronic device (100) may generate a new template rule based on a user's input and add the generated template rule to a list of one or more template rules. For example, if the user sets various parameters regarding a template rule and selects a save icon, a template rule may be generated based on the set parameters, and the generated template rule may be newly displayed in a list of one or more template rules on the user interface (700).
[0154] Meanwhile, the specific examples of the types of user interface components and various parameters regarding template rules described above are merely examples, and it is obvious to a person skilled in the art to which the present disclosure pertains that the present disclosure can be implemented with examples different from the above.
[0155] FIGS. 8A and 8B illustrate a user interface (800) provided by an electronic device (100) according to one embodiment.
[0156] According to one embodiment, the electronic device (100) may provide a user interface (800) including a list of one or more template rules to a user terminal. For example, referring to FIG. 8A, the user terminal may receive information from the electronic device (100) in a form that can be displayed as a web page or an application screen, and display a user interface (800) including an area for displaying information for identifying one or more template rules based on the received information, an area for displaying an icon for changing information related to one or more template rules, or an area for displaying a description of one or more template rules.
[0157] According to one embodiment, the electronic device (100) may provide the user with a user interface (820) for changing setting information related to a template rule through the user terminal based on an input obtained from the user. For example, referring to FIGS. 8A and 8B , the user terminal may obtain a user input for selecting a note icon corresponding to a first template rule (810) and transmit a user interface request for changing setting information related to the first template rule (810) to the electronic device (100). The user terminal may receive information in a form that can be displayed as a web page or an application screen from the electronic device (100) and display a pop-up window for changing setting information related to the first template rule (810) based on the received information.
[0158] Meanwhile, FIG. 8b illustrates a pop-up window as a user interface (820) for changing setting information related to rules, but the user interface (820) of the present disclosure may be implemented in various forms, such as a modal window, and is not limited thereto.
[0159] According to one embodiment, preset information regarding the first template rule (810) may be displayed in one or more areas within the user interface (820).
[0160] For example, "Summary value, 1 day volatility" may be displayed in the area (830) as the name of the first template rule (810), and a column may be displayed in the area (840) as the confirmation type corresponding to the first template rule (810). Additionally, since the user has not entered a description for the first template rule (810), no content may be displayed in the area (850), and a script corresponding to the first template rule (810) may be displayed in the area (860).
[0161] According to one embodiment, the electronic device (100) can identify changed information regarding the first template rule (810) based on input obtained from the user, and store information regarding the template rule (810) including the changed information.
[0162] For example, the user terminal may change a script corresponding to the first template rule (810) displayed in the area (860) and obtain a user input selecting a save icon. Accordingly, the user terminal may display information about the changed script in the area (870) and transmit the information about the changed script to the electronic device (100).
[0163] Meanwhile, the specific examples of the types of user interface components and various parameters regarding template rules described above are merely examples, and it is obvious to a person skilled in the art to which the present disclosure pertains that the present disclosure can be implemented with examples different from the above.
[0164] Figure 9 illustrates an example of a notification (900) provided to a user when a notification generation condition is satisfied.
[0165] According to one embodiment, when a notification generation condition is satisfied, the electronic device (100) may provide a notification (900) to at least one user. For example, referring to FIG. 9, when a notification generation condition is satisfied, the electronic device (100) may provide a notification (900) to at least one user, including information about at least one user to whom the notification will be provided, information about the notification generation condition, information about a database in which the confirmed data is stored, or information about a table including the confirmed data.
[0166] Meanwhile, the specific examples regarding the user who will provide the aforementioned notification, the database storing the data that has confirmed the notification creation conditions, or the table containing the confirmed data are merely exemplary, and it is obvious to a person skilled in the art to which the present disclosure pertains that the present disclosure can be implemented with examples different from the aforementioned.
[0167] Figure 10 illustrates a flowchart of a data management method for an electronic device according to one embodiment. The above description may apply to overlapping content.
[0168] At step S1000, the electronic device can check information about a first rule including information about a first database, information about a first table stored in the first database, information about a first notification generation condition, and information about a first time set.
[0169] In one embodiment, the information regarding the first rule may further include information regarding at least one user to whom a notification is to be provided.
[0170] According to one embodiment, information about the first rule further includes information about priority, and when there are multiple rules that check whether a notification generation condition is satisfied for data included in the first table at the same time, satisfaction of a notification generation condition corresponding to a higher priority may be checked first.
[0171] At step S1020, the electronic device can determine whether a first notification generation condition is satisfied for data included in the first table based on information about the first time set.
[0172] According to one embodiment, the information regarding the first rule further includes information regarding the first column in the first table, and when the electronic device determines whether the first notification generation condition is satisfied for data included in the first table, it can determine whether the first notification generation condition is satisfied for data included in the first column in the first table based on the information regarding the first time set.
[0173] According to one embodiment, information about a first notification generation condition includes information about a set period and information about one or more threshold values, and when the electronic device determines whether the first notification generation condition is satisfied for data included in the first table, it can determine whether the number of data stored during the set period included in the first table is greater than or equal to one or more threshold values based on information about the first time set.
[0174] At step S1040, the electronic device can provide a notification to at least one user if the first notification generation condition is satisfied.
[0175] According to one embodiment, the electronic device may provide a list of a plurality of rules including a first rule.
[0176] According to one embodiment, the electronic device may check information about a second database, information about a second table stored in the second database, information about a second time set, and a code about a second notification generation condition based on information input by a user, and may generate a second rule based on the information about the second database, the information about the second table, the information about the second time set, and the code about the second notification generation condition, and add the second rule to a list of a plurality of rules.
[0177] According to one embodiment, the electronic device may provide a list of one or more template rules, and, based on information input by a user, may identify information regarding a first template rule selected from among the one or more template rules, information regarding a third database, information regarding a third table stored in the third database, and information regarding a third time set. Thereafter, the electronic device may generate a third rule based on the information regarding the first template rule, the information regarding the third database, the information regarding the third table, and the information regarding the third time set, and may add the third rule to the list of multiple rules.
[0178] According to one embodiment, the information about the first template rule includes information about one or more parameters, and the one or more parameters can be determined based on a code about the first template rule.
[0179] According to one embodiment, the electronic device can identify changed information regarding a fourth rule among a list of multiple rules based on information input from a user, and store information regarding the fourth rule including the changed information.
[0180] According to one embodiment, when providing a notification to at least one user, the electronic device may provide a notification to at least one user by a first means if the number of data stored for a set period of time included in a first table is greater than or equal to a first threshold, and may provide a notification to at least one user by a second means if the number of data stored for a set period of time included in the first table is less than the first threshold and greater than or equal to a second threshold.
[0181] According to one embodiment, when providing a notification to at least one user, the electronic device may provide a notification to at least one user by a first means when the number of data stored for a set period of time included in a first table is less than or equal to a first threshold, and may provide a notification to at least one user by a second means when the number of data stored for a set period of time included in the first table is greater than the first threshold and less than or equal to a second threshold.
[0182] According to one embodiment, the electronic device may provide recommended values for one or more thresholds based on a history of data stored in the first table.
[0183] FIG. 11 shows a block diagram of an electronic device (100) according to one embodiment.
[0184] According to an embodiment, the electronic device (100) may include a transceiver (1120), a memory (1140), and a processor (1160). The electronic device (100) illustrated in FIG. 11 only illustrates components related to the present embodiment. Therefore, those skilled in the art will appreciate that, in addition to the components illustrated in FIG. 11, other general-purpose components may be included. In the embodiment, the transceiver (1120) may be included in a communication device. Additionally, in the embodiment, the processor (1160) may be included in a controller.
[0185] The transceiver (1120) is a device for performing wired / wireless communication and can communicate with external electronic devices. The external electronic devices may be terminals or servers. In addition, communication technologies used by the transceiver (1120) may include GSM (Global System for Mobile communication), CDMA (Code Division Multi Access), LTE (Long Term Evolution), 5G, WLAN (Wireless LAN), Wi-Fi (Wireless-Fidelity), Bluetooth (Bluetooth), RFID (Radio Frequency Identification), Infrared Data Association (IrDA), ZigBee, NFC (Near Field Communication), etc.
[0186] The processor (1160) can control the overall operation of the electronic device (100) and process data and signals. The processor (1160) can be composed of at least one hardware unit. In addition, the processor (1160) can operate by one or more software modules generated by executing program codes stored in the memory (1140). The processor (1160) can include a memory, and the processor (1160) can control the overall operation of the electronic device (100) and process data and signals by executing program codes stored in the memory.
[0187] The processor (1160) may check information about a first rule including information about a first database, information about a first table stored in the first database, information about a first notification generation condition, and information about a first time set, and may check whether the first notification generation condition is satisfied for data included in the first table based on the information about the first time set, and may provide a notification to at least one user if the first notification generation condition is satisfied.
[0188] The electronic device according to the above-described embodiments may include a processor, a memory for storing and executing program data, permanent storage such as a disk drive, a communication port for communicating with an external device, a user interface device such as a touch panel, a key, a button, etc. The methods implemented as software modules or algorithms may be stored on a computer-readable recording medium as computer-readable codes or program instructions executable on the processor. Here, the computer-readable recording medium includes a magnetic storage medium (e.g., read-only memory (ROM), random-access memory (RAM), floppy disk, hard disk, etc.) and an optical reading medium (e.g., CD-ROM, DVD: Digital Versatile Disc)). The computer-readable recording medium may be distributed to computer systems connected to a network, so that the computer-readable code may be stored and executed in a distributed manner. The medium may be readable by a computer, stored in a memory, and executed by a processor.
[0189] The present embodiment may be represented by functional block configurations and various processing steps. These functional blocks may be implemented by various hardware and / or software configurations that perform specific functions. For example, the embodiment may employ direct circuit configurations such as memory, processing, logic, look-up tables, etc., which may perform various functions under the control of one or more microprocessors or other control devices. Similarly, the present embodiment may be implemented in a programming or scripting language such as C, C++, Java, assembler, etc., including various algorithms implemented as a combination of data structures, processes, routines, or other programming configurations. Functional aspects may be implemented as algorithms that execute on one or more processors. Furthermore, the present embodiment may employ conventional techniques for electronic configuration, signal processing, and / or data processing. Terms such as "mechanism," "element," "means," and "composition" can be used broadly and are not limited to mechanical or physical structures. These terms can also encompass a series of software routines, such as those associated with a processor.
[0190] The above-described embodiments are merely examples, and other embodiments may be implemented within the scope of the claims set forth below.
Claims
1. In a method for managing data of an electronic device, A step of verifying information about a first rule including information about a first database, information about a first table stored in the first database, information about a first notification generation condition, and information about a first time set; A step of checking whether the first notification generation condition is satisfied for data included in the first table based on information about the first time set; and A data management method comprising a step of providing a notification to at least one user when the first notification generation condition is satisfied.
2. In the first paragraph, the data management method, A data management method further comprising the step of providing a list of a plurality of rules including the first rule.
3. In the second paragraph, the data management method, A step of checking information about a second database, information about a second table stored in the second database, information about a second time set, and a code about a second notification generation condition based on information entered by a user; A step of generating a second rule based on information about the second database, information about the second table, information about the second time set, and code about the second notification generation condition; and A data management method further comprising the step of adding the second rule to the list of the plurality of rules.
4. In the second paragraph, the data management method, A step of providing a list of one or more template rules; A step of checking information about a first template rule selected from the one or more template rules, information about a third database, information about a third table stored in the third database, and information about a third time set based on information input from a user; A step of generating a third rule based on information about the first template rule, information about the third database, information about the third table, and information about the third time set; and A data management method further comprising the step of adding the third rule to the list of the plurality of rules.
5. In paragraph 4, Information about the first template rule includes information about one or more parameters, A data management method, wherein the one or more parameters are determined based on a code relating to the first template rule.
6. In the second paragraph, the data management method, A step of checking changed information regarding a fourth rule among the list of multiple rules based on information input from a user; and A data management method further comprising a step of storing information regarding a fourth rule including the changed information.
7. In paragraph 1, The information regarding the first rule further includes information regarding the first column in the first table, The step of checking whether the first notification generation condition is satisfied for the data included in the first table is as follows: A data management method, comprising a step of checking whether the first notification generation condition is satisfied for data included in the first column in the first table based on information about the first time set.
8. In the first paragraph, the information regarding the first rule is: A data management method further comprising information about at least one user to whom a notification is to be provided.
9. In paragraph 1, The information regarding the above first rule further includes information regarding priority, A data management method in which, when there are multiple rules for checking whether a notification generation condition is satisfied for data included in the first table at the same time, whether a notification generation condition corresponding to a higher priority is satisfied is checked first.
10. In paragraph 1, Information about the first notification generation condition includes information about the set period and information about one or more thresholds, The step of checking whether the first notification generation condition is satisfied for the data included in the first table is as follows: A data management method, comprising a step of determining whether the number of data stored during the set period included in the first table is greater than or equal to one or more threshold values based on information regarding the first time set.
11. In the 10th paragraph, the step of providing a notification to at least one user comprises: A data management method comprising the steps of providing a notification to at least one user by a first means when the number of data stored during the set period included in the first table is greater than or equal to a first threshold value, and providing a notification to at least one user by a second means when the number of data stored during the set period included in the first table is less than the first threshold value and greater than or equal to a second threshold value.
12. In the 10th paragraph, the step of providing a notification to at least one user comprises: A data management method comprising the steps of providing a notification to at least one user by a first means when the number of data stored during the set period included in the first table is less than or equal to a first threshold value, and providing a notification to at least one user by a second means when the number of data stored during the set period included in the first table is greater than the first threshold value and less than or equal to a second threshold value.
13. In the 10th paragraph, the data management method, A data management method further comprising a step of providing a recommended value for one or more threshold values based on a history of data stored in the first table.
14. A non-transitory computer-readable recording medium having recorded thereon a program for executing the method of paragraph 1 on a computer.
15. As an electronic device, transceiver; memory; and A processor comprising: Check information about a first rule including information about a first database, information about a first table stored in the first database, information about a first notification generation condition, and information about a first time set; Based on the information about the first time set, it is checked whether the first notification generation condition is satisfied for the data included in the first table, An electronic device that provides a notification to at least one user when the above first notification generation condition is satisfied.
Citation Information
Patent Citations
Method of verifying modeling code, apparatus performing the same and storage media storing the same
KR101665962B1
Method for providing information based on expected result value and computing device using the same
KR102344661B1
