METHOD FOR LOADING DATASETS INTO FORM

Abstract

To provide a method for loading a database into a format.SOLUTION: The present disclosure relates to the field of information processing and also relates to a method for loading a dataset into a format. Specifically, the present disclosure provides a method for acquiring a user input sentence structure according to original data, accessing a database on the basis of the user input sentence structure, and outputting the user input sentence structure to a user interface (UI) on the basis of the database.SELECTED DRAWING: Figure 1

Description

[Technical field]

[0001] The present disclosure relates to the field of information processing, and relates to a method for loading a data set into a form. In particular, the present disclosure provides a method for obtaining a User Input Statement for original data, accessing a database based on the User Input Statement, and outputting a User Interface (UI) based on the database. [Background technology]

[0002] With the development of computer technology, companies and government offices use various computer programs for business and administrative tasks. Such computer programs are capable of storing and processing a large amount of data necessary for business and administrative tasks such as accounting, human resources, finance, sales, trade, purchasing, materials, production, and inventory. By using such computer programs, users (practitioners, executives, and managers of companies and government offices) can store and manage data used in companies and government offices more conveniently and easily. Computer programs used in companies and government offices support functions for creating, editing, and managing documents in various formats. However, there is a problem in that human and material resources are wasted in the process of storing, processing, and outputting various unmanaged formats. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Republic of Korea Patent Publication No. 10-0593661 Summary of the Invention [Problem to be solved by the invention]

[0004] SUMMARY The present disclosure has been devised in response to the aforementioned background art and can provide a method for conveniently processing image data.

[0005] The technical problems in the present disclosure are not limited to the above-mentioned technical problems, and a person skilled in the art can clearly understand problems other than the above-mentioned technical problems based on the following description. [Means for solving the problem]

[0006] A method performed by a computing device in multiple embodiments for solving the above-mentioned problem, the method, when performed by the computing device, may include: obtaining first data including an image from a database based on a spreadsheet module; and displaying the first data in a spreadsheet through the spreadsheet module based on the first data.

[0007] In one embodiment, the spreadsheet module may include style control function parameters including at least one of cell style information, cell placement information, cell integration information, conditional formatting information, and chart output information to be displayed in the spreadsheet.

[0008] In one embodiment, the information relating to the image of the first data includes image storage path information, and the step of displaying the first data in a spreadsheet based on the first data through parameters of a style control function may include: acquiring the image based on the image storage path information; and converting the image into a standardized image and displaying it in the spreadsheet.

[0009] In one embodiment, the spreadsheet module includes an image list of images assigned with an image key value, and the step of displaying the first data in the spreadsheet based on the first data through parameters of a style control function may include a step of comparing the image of the first data with the image list; and if the image of the first data corresponds to any one of the images included in the image list, a step of displaying the image of the first data in the spreadsheet based on the image list.

[0010] In one embodiment, the method may further include the steps of: if the image of the first data is not included in the image list, assigning a new image key value to the image of the first data; and including the image of the first data in the image list.

[0011] In one embodiment, the method may include the steps of: replacing an image of the first data to generate second data; comparing the image of the second data with the image list; if the image of the second data corresponds to any one of the images included in the image list, generating a cache function based on the image list; and displaying in a spreadsheet based on the cache function.

[0012] In one embodiment, if the image of the second data is not included in the image list, assigning a new image key value to the image of the second data; and The method may further comprise the step of: including images of the second data in the image list.

[0013] In an embodiment, in generating second data by modifying the first data, modification may be possible only for a pre-defined area of ​​the first data.

[0014] In one embodiment, the method may include generating syntax for updating the first data in the database to the second data based on the cache function; and updating the database using the syntax.

[0015] Also disclosed is a computer program stored on a computer-readable storage medium for solving the above problems.

[0016] The computer program, when executed by one or more processors, causes the one or more processors to perform operations for displaying data in a spreadsheet, the operations may include an operation of obtaining first data including an image from a database; and an operation of displaying the first data in the spreadsheet through a spreadsheet module based on the first data.

[0017] A computing device for solving the problems described above is also disclosed.

[0018] The computing device includes at least one processor; and a memory; and the at least one processor may be configured to retrieve first data including an image from a database to display the data in a spreadsheet; and to display the first data in the spreadsheet through a spreadsheet module based on the first data. Effect of the Invention

[0019] SUMMARY The present disclosure has been devised in response to the aforementioned background art, and can provide a method for allowing users to conveniently access original data.

[0020] Additional scope of the present disclosure will become clear from the following detailed description. However, since various changes and modifications within the spirit and scope of the present invention will be clearly understood by those skilled in the art, it should be understood that the detailed description and specific examples such as preferred embodiments of the present invention are merely illustrative. [Brief description of the drawings]

[0021] Various aspects are described with reference to the drawings. In the following description of the drawings, like drawing numbers are used to generally refer to like components. In the following examples, for purposes of explanation, numerous specific details are provided to facilitate an overall understanding of one or more aspects. However, it will be apparent that such aspect(s) can be practiced without such specific details. In other instances, well-known structures and devices are shown in block diagram form to facilitate the description of one or more aspects. [Figure 1] FIG. 1 is a block diagram illustrating a computing device according to an embodiment of the present disclosure. [Diagram 2] FIG. 2 is a flowchart illustrating a method for extracting and outputting original data in an embodiment of the present disclosure. [Diagram 3] FIG. 3 is a flow chart illustrating a method for outputting a data set in a first program in a second program of a computing device in one embodiment of the present disclosure. [Figure 4] FIG. 4 is a flowchart illustrating a method for a spreadsheet module to access original data and output first data in an embodiment of the present disclosure. [Diagram 5] FIG. 5 is a signal flow diagram illustrating a method for a spreadsheet module to access original data and output first data in an embodiment of the present disclosure. [Figure 6] FIG. 6 is a conceptual diagram for explaining a spreadsheet module including parameters of a data extraction function and parameters of a style control function in an embodiment of the present disclosure. [Figure 7] FIG. 7 is a conceptual diagram for explaining a method for repeatedly specifying input values ​​of a formula included in a spreadsheet module in an embodiment of the present disclosure. [Figure 8] FIG. 8 is a general schematic diagram of an exemplary computing environment in which embodiments of the present disclosure can be implemented. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0022] Various embodiments are described below with reference to the drawings. Various descriptions are provided herein to facilitate understanding of the present disclosure. However, these embodiments can certainly be practiced without these specific descriptions.

[0023] As used herein, terms such as "component," "module," and "system" refer to computer-related entities, hardware, firmware, software, a combination of software and hardware, or software execution. For example, a component can be, but is not limited to, a procedure running on a processor, a processor, an object, a thread of execution, a program, and / or a computer. For example, both an application running on a computing device and the computing device can be a component. One or more components can reside within a processor and / or thread of execution. A component can be localized within one computer. A component can be distributed across two or more computers. Also, such components can execute from various computer-readable media having various data structures stored therein. Components can communicate, for example, through local and / or remote processing, such as by signals carrying one or more data packets (e.g., data from one component interacting with other components in a local system, a distributed system, and / or data transmitted over a network such as the Internet to other systems).

[0024] The suffixes "module" and "section" used in the following description are used or mixed together to refer to components for the sole purpose of facilitating the writing of the specification, and do not themselves have any specific meanings or roles.

[0025] Also, as used herein, the terms "information" and "data" are often used interchangeably.

[0026] When an element is described as being "connected," "coupled," or "connected" to another element, it should be understood that it may be directly connected, coupled, or connected to the other element, but that there may be other elements between them. On the other hand, when an element is described as being "directly connected," "directly coupled," or "directly connected" to another element, it should be understood that there are no other elements between them.

[0027] The term "or" is intended to mean an inclusive "or" rather than an exclusive "or." That is, unless otherwise specified and unless otherwise clear from the context, "X utilizes A or B" is intended to mean one of the natural inclusive permutations. That is, if X utilizes A; X utilizes B; or X utilizes both A and B, then "X utilizes A or B" can apply to any of these. Additionally, the term "and / or" as used herein is intended to refer to and include all possible combinations of one or more of the associated listed items.

[0028] Additionally, the term "comprise" as a predicate and / or the modifier "comprise" are understood to mean the presence of the stated feature and / or component, but not to exclude the presence or addition of one or more other further features, components and / or groups thereof. Additionally, unless a specific number is specified or the context is clear to indicate the singular form, the singular in the present specification and claims should generally be construed to mean "one or more."

[0029] Hereinafter, the same reference numerals are used for the same or similar components regardless of the reference numerals in the drawings, and duplicated descriptions thereof will be omitted. Furthermore, when describing the embodiments disclosed in this specification, if it is determined that a detailed description of the related known technology may make the gist of the embodiments disclosed in this specification unclear, the detailed description will be omitted. Furthermore, the attached drawings are merely for facilitating understanding of the embodiments disclosed in this specification, and the technical ideas disclosed in this specification are not limited by the attached drawings.

[0030] Furthermore, the term "at least one of A or B" should be interpreted as meaning "a case in which only A is included," "a case in which only B is included," or "a case in which a combination of A and B is included."

[0031] Those skilled in the art should further appreciate that the various exemplary logical blocks, configurations, modules, circuits, means, logic, and algorithm steps described in accordance with the embodiments disclosed herein can be realized by electronic hardware, computer software, or a combination of both. To clearly illustrate the interchangeability of hardware and software, the various exemplary components, blocks, configurations, means, logic, modules, circuits, and steps have been described above generally in terms of their functionality. Whether such functionality is implemented as hardware or software depends on the particular application and design limitations of the overall system. Skilled artisans can realize the described functionality in various ways for each particular application. However, such implementation decisions should not be interpreted as departing from the scope of the present disclosure.

[0032] The description of the embodiments set forth herein is provided to enable any person skilled in the art to use or practice the present disclosure. Various modifications to the embodiments will be apparent to those skilled in the art to which the present disclosure pertains. The generic principles defined herein may be applied to other embodiments without departing from the scope of the present disclosure. Thus, the present invention is not limited to the embodiments set forth herein. The present invention is to be accorded the broadest scope consistent with the principles and novel features disclosed herein.

[0033] The method for a computing device to extract and output original data in the present disclosure will be described below with reference to FIGS.

[0034] FIG. 1 is a block diagram illustrating a computing device according to an embodiment of the present disclosure.

[0035] The configuration of the computing device (100) illustrated in Figure 1 is merely a simplified example. In one embodiment of the present disclosure, the computing device (100) may include other components for implementing the computing environment of the computing device (100), and the computing device (100) may be configured with only some of the disclosed components.

[0036] The computing device (100) may include a processor (110), a memory (130), and a network unit (150).

[0037] The processor (110) may be configured with one or more cores and may include processors for data analysis and deep learning, such as a computing central processing unit (CPU), a general purpose graphics processing unit (GPGPU), and a tensor processing unit (TPU).

[0038] In one embodiment of the present disclosure, the memory 130 can store any type of information generated or determined by the processor 110 and any type of information received by the network unit 150.

[0039] In one embodiment of the present disclosure, the memory (130) may include at least one type of storage medium among flash memory type, hard disk type, multimedia card micro type, card type memory (e.g., SD or XD memory, etc.), Random Access Memory (RAM), Static Random Access Memory (SRAM), Read-Only Memory (ROM), Electrically Erasable Programmable Read-Only Memory (EEPROM), Programmable Read-Only Memory (PROM), magnetic memory, magnetic disk, and optical disk. The computing device (100) may also operate in conjunction with a web storage that performs the storage function of the memory (130) over the Internet. The above description of the memory is merely exemplary, and the present disclosure is not limited thereto.

[0040] In one embodiment of the present disclosure, the network unit (150) can use various wired communication systems such as a Public Switched Telephone Network (PSTN), x Digital Subscriber Line (xDSL), Rate Adaptive DSL (RADSL), Multi Rate DSL (MDSL), Very High Speed ​​DSL (VDSL), Universal Asymmetric DSL (UADSL), High Bit Rate DSL (HDSL), and a Local Area Network (LAN).

[0041] In addition, the network unit (150) in this specification can use various wireless communication systems such as CDMA (Code Division Multi Access), TDMA (Time Division Multi Access), FDMA (Frequency Division Multi Access), OFDMA (Orthogonal Frequency Division Multi Access), SC-FDMA (Single Carrier-FDMA), and other systems.

[0042] The network unit (150) in the present disclosure can be configured regardless of the type of communication, such as wired or wireless, and can be various communication networks such as a short-distance communication network (PAN: Personal Area Network), a short-distance communication network (WAN: Wide Area Network), etc. In addition, the above network can be the well-known World Wide Web (WWW), or can utilize wireless transmission technology used for short-distance communication, such as infrared (IrDA: Infrared Data Association) or Bluetooth (registered trademark).

[0043] The techniques described herein can be used in the networks mentioned above as well as other networks.

[0044] FIG. 2 is a flowchart illustrating a method for extracting and outputting original data in an embodiment of the present disclosure.

[0045] Referring to the contents shown in FIG. 2, the computing device of the present disclosure may include a step of receiving a data extraction function related to original data (S100), a step of generating a statement based on the data extraction function (S200), a step of executing the statement to extract data (S300), and a step of outputting the extracted data (S400).

[0046] The step of receiving a data extraction function for the original data (S100) may be input in the form of a function via a user interface (UI). In this case, the function may include a mathematical formula in which a variable is input to the function. As an example, the user interface (UI) may include one or more functions selected in a field setting unit for selecting a field in the original data or a data attribute setting unit for setting a data type, and may include a mathematical formula in which a setting value is input to the function. The user interface (UI) may further include an access setting unit for inputting access information to the original data. A method for the user interface (UI) to extract original data will be described later with reference to the contents shown in FIG. 5 and FIG. 6.

[0047] The functions can also be modularized. Programs for data conversion that may be somewhat complicated can be replaced with the modularized functions. The functions can be created based on predefined rules, which may include the same rules as program formulas.

[0048] On the other hand, a statement is a particular unit (e.g., one line) of code that performs a particular task. As an example, the statement can be a simple assignment of values ​​to variables, but can also be a more complex expression that includes multiple operations and functions. The statement can follow the program syntax of the original data. The grammar represents the rules and structure of a programming language and specifies the correct way to write code in that programming language, including the use of variables, operators, and control structures. The syntax varies depending on the type of program of the original data, and may be difficult for users to learn depending on the program of the original data, making it difficult to generate the statement. Thus, when using the modularized functions, the original data can be conveniently handled by the user in an abstract form, regardless of the program of the original data.

[0049] In the step of generating a statement based on the data extraction function (S200), the computing device (100) may first perform preprocessing, including operations such as defining a macro with a header and expanding certain constructs, before the data extraction function is sent to a statement generator. Next, the computing device (100) reads the source code and breaks the extraction function into a series of tokens, where a token refers to a single element included in the extraction function, such as a keyword, an identifier, a sentence code, etc. Next, the computing device (100) checks the extraction function for syntax errors and creates a tree-like structure called an abstract syntax tree (AST) to convert it to a form that is easy for the processor (110) to understand. Next, the computing device (100) may include a step of checking the extraction function for semantic errors, such as using a variable before it is declared or calling a module with the wrong argument, and converting the AST into a statement that can be executed in the program of the original data. That is, the abstracted extraction functions may be converted into lower level statements that the original data program can execute, such as loops, conditionals, and / or queries. In this case, the conversion process may include optimizing the query to take advantage of indexes or other performance enhancements available in the original data, or splitting the query into smaller parts for separate execution. The optimization may include optimizing the query to take advantage of indexes or other performance enhancements available in the original data, or splitting the query into smaller parts for separate execution.

[0050] The step of executing the statement to extract data (S300) may be performed by a program that accesses and manages the original data. The computing device (100) may also identify and prepare all symbols or references that may be used in the process of executing the statement. As an example, the statement may be executed by a database management system (DBMS) and the original data may be contained in a relational database. That is, the statement may be a database query statement, such as a SQL query statement. In the computing device (100), an application program first creates a link to the original data using a link string that specifies the name of the original data, the name of the user, and a password (if required). Once the link is established, the database management system may execute the SQL query statement against the original data, such as in the form of an API. Through the application program, the SQL query statement that has been generated based on the extraction function of the present disclosure may be executed, the results may be retrieved, and transactions may be managed.

[0051] In this case, the application program may analyze the SQL query syntax and redetermine the most efficient way to execute against the underlying data and process the query, which may include optimizing the query to take advantage of indexes or other performance enhancements available on the original data, or breaking the query into smaller parts to execute separately, which may be omitted if an optimized syntax was generated in step S200. The application program may also handle error checking, ensuring that any errors that occur during query execution are correctly reported to the application program.

[0052] In the step of outputting the extracted data (S400), for example, the data extracted as a result of executing the SQL query syntax is returned to the client program. The client program can then display the results on a screen or process them in other ways. The specific manner in which the results are displayed on the screen depends on the client application program being used. For example, if the client program is a command line interface (CLI), the results can be displayed in the form of a table on a terminal, but if the client program is a graphical user interface (GUI), such as one executed in a web browser, the results can be displayed in a table or other visual representation on the screen, allowing the user to conveniently use the graphical user interface (GUI).

[0053] FIG. 3 is a flow chart illustrating a method for outputting a data set in a first program in a second program of a computing device in one embodiment of the present disclosure.

[0054] Referring to the contents shown in FIG. 3, the computing device of the present disclosure may include a step of receiving a first user input related to a dataset (S110), a step of receiving a second user input for defining the dataset in a first program (S210), a step of executing the second user input to obtain the dataset (S310), and a step of outputting the dataset in a second program (S410).

[0055] In the step of receiving a first user input related to the data set (S110), the computing device may receive the first user input in a first user interface provided in the first program. As an example, the user terminal may use a touch screen or any form of display unit to output the first user interface including an object for executing an application or a function of the application desired by the user. In this case, when an object including a tab or icon displayed on the user terminal is selected, the user terminal may execute the application or the function of the application corresponding to the selected operation. In one embodiment of the present disclosure, a screen, area, identification information, indicator, input window, module, and / or tab, etc. including at least one object may constitute the user interface. As an example, the first program may be in the form of a spreadsheet, and the user interface may include one or more cells.

[0056] In the step of receiving a second user input for defining the dataset in the first program (S210), the computing device may receive a second user input through a first user interface for defining an identification of a dataset to correspond to at least a part of the identification of the first region included in the first user input acquired in step S110. For example, the identification of the first region may include a name of the first region and a first indicator for indicating that the first region is loaded from the first program to the second program, and the identification of the first region may further include the first indicator, an identifier, and a name of a dataset. If the name of the first region and the indicator of the first region are specified, the computing device may recognize that a particular dataset in the first program is loaded to the second program. Furthermore, the identification of the first region may mean any form of information for identifying or defining the first region.

[0057] The second user input may be related to various settings for extracting various first data. For example, the second user input may include at least one of a specified dataset name, a path, access rights, and field information. The second user input may be for setting columns related to syntax creation or for specifying record conditions. For example, even if the order of columns is changed or the column names are different between the original data and the output data, a data query statement that matches the syntax of the dataset may be executed. The second user input may further display annotations for the output data.

[0058] In the step of executing the second user input to obtain the data set (S310), the computing device can set a range of a certain number of data in a spreadsheet module, and when the computing device receives the input of the identification information of the second program for the range, the computing device can load the data set into the second program through a comparison between the identification information of the second program and the identification information of the first program. Also, the second program can additionally receive metadata including additional information in any form for identifying the name, range, etc. of data, such as identification information and / or information related to the range, and the metadata can generate a meta input object.

[0059] In addition, in the step of outputting the data set in the second program (S410), it is possible to determine the output size or change the arrangement of each data included in the data set loaded and output in the second program. The data set can be changed according to the result of querying metadata or data, and can include predetermined formulas (OFFSET, COUNTA, etc.). The second program can be included in a spreadsheet module, whereby the predetermined formulas can be set to the same or similar functions commonly used in commercial spreadsheets. The data output to the second program can also be set in various forms according to the access rights to data of the account that queries the data.

[0060] In the above example, the second program can be output to a fixed screen, so that the size and position of each of the included data can be changed depending on the output range of the data set. The second program can check the size of the display on which the data set is output and select a representation or arrangement method that fits the space in which the data set is placed. When the representation or arrangement method is determined, the second program can display the data in a table, list, or other format that fits the available space. In addition, the second program can continuously monitor the size and, when the size of the display used is changed, adjust the data representation or data arrangement as necessary so that the data set is displayed in an optimal state. The output form can allow the user to determine the items of data to be output. The second program can also include an integrated separate program module that can adjust the data representation or data arrangement so that the data set is displayed in an optimal manner in the available space.

[0061] Also, the form of the output can be changed into various forms such as a combo box and a multi-combo box, a text box containing text information, a calendar containing date information, etc. As an example, when a specific year is input in the third area, a plurality of data corresponding to the specific year in the dataset of the first program can be loaded and output in the second program.

[0062] As an example, in the second program, the additional information output together with the data set and the original data associated with the data set may not be linked to each other, in which case the computing device (100) may output the additional information to the second program without changing the information in the original data or making complex changes to the SQL query syntax.

[0063] 4 and 5 are a flow chart and a signal flow chart illustrating how a spreadsheet module accesses original data and outputs first data according to an embodiment of the present disclosure.

[0064] Referring to the contents shown in Figures 4 and 5, the computing device of the present disclosure may include a step (S120) of a spreadsheet module receiving parameters of a data extraction function, a step (S220) of generating a first syntax for accessing original data, a step (S320) of obtaining first data from the original data, and a step (S420) of outputting the first data through the spreadsheet module.

[0065] The original data may be contained in a relational database. As an example, the database may be Oracle. Registered trademark ), PostgreSQL, MySQL (Registered Trademark) , SQL Server (MS-SQL), or SQLite.

[0066] In the step (S120) of the spreadsheet module receiving parameters of the data extraction function, the spreadsheet module may receive parameters of the data extraction function from a first interface. The parameters may include first access setting information and first syntax setting information. The first access setting information may include settings related to at least one of the following: one or more associated database names, a database type, a sequence number, a path or access authority to a database, a sequence number related to an object table included in the database, and a number of fields related to the object table or access authority.

[0067] In the step of generating a first syntax for accessing the original data (S220), when the spreadsheet module performs settings related to the RDBMS corresponding to the first syntax, a statement tailored to the database according to the syntax can be generated according to the type of the database. As an example, through the present disclosure, a user can conveniently generate a statement using an abstracted formula provided in a user interface (UI) provided by the spreadsheet module, regardless of the type of database. The user interface (UI) in which the second user input is displayed can be displayed in a cell on the spreadsheet, and can be confirmed and controlled by the user.

[0068] The spreadsheet module may also be associated with a SQL query syntax, which syntax performs one or more of the following operations: Create, Read, Update, and Delete (CRUD). In this case, the SQL query syntax may be a signal related to one of the commands Insert, Update, and Delete, and the signal may be input or displayed in a cell of a spreadsheet as the name or abbreviation of the SQL query syntax. As an example, the display may be as shown in Table 1 below.

[0069] [Table 1]

[0070] The second user input can be for setting columns related to syntax creation or for specifying record conditions. As an example, it is possible to execute the SQL query syntax even if the order of columns is changed or the column names are different between the original data and the output data. The second user input can also display annotations for the output data.

[0071] In the step of acquiring the first data from the original data (S320), the first data may be acquired based on the first syntax. For example, the first syntax may search an original data list related to a model represented in a spreadsheet document, through which the first syntax may request the first data to be sent for output from a client. In this case, the spreadsheet module may provide a user interface component for editing a value of a cell designated for outputting the original data through a style control function. A configuration included in the style control function for outputting the first data will be described below with reference to FIG. 6.

[0072] In the step of outputting the first data through the spreadsheet module (S420), the spreadsheet module can output the original data according to the data extraction function or the style control function.

[0073] For example, the template document generated by the style control function of the spreadsheet module may be in a format used for a report, and the template document stored on a server or downloaded to a client may have the first data arranged and output according to parameters of the style control function. Conventionally, in order to output data on a database to a template, specialized knowledge of a separate SQL query syntax was required, and knowledge for data search was also required. Also, a connection for using a database connector must be separately set. However, when the spreadsheet module of the present disclosure is utilized, time and cost for separately setting such a SQL query syntax or database connector can be saved.

[0074] In addition, the step of displaying the first data in a spreadsheet through parameters of a style control function based on the first data may further include a step of acquiring the image based on the image storage path information, and a step of converting the image into an image that complies with a standard and displaying it in the spreadsheet.

[0075] The spreadsheet module of the present disclosure may further include an image list related to images to which an image key value is assigned, and the step of displaying the first data in the spreadsheet based on the first data through a parameter of a style control function may compare the image of the first data with the image list. The spreadsheet module of the present disclosure may further include a step of displaying the image of the first data in the spreadsheet based on the image list when the image of the first data corresponds to any one of the images included in the image list.

[0076] Meanwhile, the present disclosure may further include a step of changing the first data displayed on the spreadsheet. The step of changing the first data may further include a step of checking an area on a screen where the first data is output, and calculating the data record arrangement information based on information related to the value of the field and information related to the output area.

[0077] Also, in the step of changing the first data, a cache function can be generated to increase the efficiency of the change processing speed. Specifically, in the step of changing the first data, the first data can be modified to generate second data, and a cache function can be generated based on the second data. Next, the method can further include a step of outputting the second data through the spreadsheet module based on the cache function. In this case, the step of modifying the first data to generate the second data can prevent unnecessary data changes by allowing only preset items of the first data to be modified. Also, in order to generate a cache function based on the second data, when a referenced area in the second data is modified, a step of modifying another area that references the referenced area or the referenced area can be included. In this case, in the modifying step, data that needs to be updated among the second data can be automatically kept up to date.

[0078] Also, modifying the first data may include generating a second syntax for updating the first data of the database to the second data based on the cache function. Then, updating the database using the second syntax may be included. The second syntax may be automatically generated according to the type of database to be modified based on a function input by a user to a spreadsheet module, and the user may generate the second syntax without having to learn a syntax for the database separately.

[0079] FIG. 6 is a conceptual diagram for explaining a spreadsheet module including parameters of a data extraction function and parameters of a style control function in an embodiment of the present disclosure.

[0080] 6, the spreadsheet module (210) of the present disclosure may be for accessing a database including original data and processing the data into a first data format for output. The spreadsheet module (210) may also include a data extraction function (400) and a style control function (500).

[0081] To access the original data, the processor can generate a first syntax based on parameters of the data extraction function (400). For example, the data extraction function (400) can include all or a part of the original data. The parameters of the data extraction function (400) can include at least one of information on the data column name, information on data attributes, information on data field selection, and information on data inquiry authority.

[0082] Also, the spreadsheet module (210) can process the format in which the original data is output through the style control function (500). The style control function (500) can be controlled by a first interface such as a work window interface on the administrator side. Alternatively, the style control function (500) can be controlled by a second interface included in a client side application. Meanwhile, a user interface setting function related to the style control function (500) can be displayed in a second program if it satisfies a preset condition, and the display method will be described later with reference to the contents shown in FIG. 7.

[0083] The parameters of the style control function (500) may include at least one of data record layout information (510), data calculation information (520), image information (530), cell style information (540), or repeated cell style information (550) included in the spreadsheet. As another example, the parameters of the style control function (500) may further include at least one of cell integration information, conditional formatting information, and chart creation information. In addition, the data calculation information (520) may repeatedly specify an input value of a formula included in the spreadsheet module based on the data extraction function.

[0084] The data record layout information (510) can output the first data to a spreadsheet through a parameter of a style control function based on the first data, by checking an area on a screen where the first data is to be output, and calculating the data record layout information based on information related to the data, such as a field value, and information related to the area where the first data is to be output.

[0085] The data calculation information (520) may include repetitive calculation information for repeatedly specifying input values ​​of a formula included in the spreadsheet module based on the data extraction function. The repetitive calculation information will be described later with reference to the contents shown in FIG.

[0086] Furthermore, the image information (530) relating to the image of the first data includes image storage path information, and the step of displaying the first data on a spreadsheet through a parameter of a style control function based on the first data may include a step of acquiring the image based on the image storage path information. Also, the step of displaying the first data on a spreadsheet may include a step of converting the image into an image conforming to a standard and displaying it on the spreadsheet.

[0087] In addition, the information relating to the image of the first data includes image storage path information, and the step of displaying the first data in a spreadsheet based on the first data through parameters of a style control function may include a step of acquiring the image based on the image storage path information, and a step of converting the image into an image that complies with a standard and displaying it in the spreadsheet.

[0088] The spreadsheet module of the present disclosure may further include an image list for images to which an image key value is assigned, and the step of displaying the first data in the spreadsheet based on the first data through a parameter of a style control function may include a step of comparing the image of the first data with the image list. Next, if the image of the first data corresponds to any one of the images included in the image list, the image of the first data may be displayed in the spreadsheet based on the image list. On the other hand, if the image of the first data is not included in the image list, a new image key value may be assigned to the image of the first data, or the image of the first data may be included in the image list.

[0089] By adding an image of the first data to the database only if it is not included in the image list, not only can more free space be secured in the database, but duplicate image data can be minimized and utilization of the image data can be maximized.

[0090] In addition, in the step of generating second data in which the first data is modified, if the image of the first data is replaced, the computing device can compare the image of the second data with the image list, and if the image of the second data corresponds to one of the images included in the image list, the computing device can generate a cache function based on the image list and display the image in a spreadsheet based on the cache function.

[0091] Conversely, when the image is replaced, it is possible to check whether the image of the second data is included in the image list, and if the image of the second data is not included in the image list, it is possible to give the image of the second data a new image key value and include the image of the second data in the image list.

[0092] By adding an image of the second data to the database only if it is not included in the image list, not only can more free space be secured in the database, but duplicate image data can be minimized and utilization of the image data can be maximized.

[0093] Meanwhile, when the spreadsheet module outputs the first data, the whole template to be output can be set based on the cell style information (540). Also, the repeated cell style information (550) can allow the data record to be repeatedly output to the spreadsheet module for a cell that is repeated in the data record.

[0094] FIG. 7 is a conceptual diagram for explaining a method for repeatedly specifying input values ​​of a formula included in a spreadsheet module in an embodiment of the present disclosure.

[0095] According to the content shown in FIG. 7, in order to repeatedly specify the data calculation information (520) included in the spreadsheet module in one embodiment of the present disclosure, it is possible to further include the repeatedly specified cell calculation information (551), through which the spreadsheet module can repeatedly output a formula without making any additional settings related to the template cell.

[0096] FIG. 8 is a general schematic diagram of an exemplary computing environment in which embodiments of the present disclosure can be implemented.

[0097] Referring to the description of FIG. 8, the computer program, when executed by one or more processors, may be configured to perform an operation of extracting and outputting original data.

[0098] According to one embodiment of the present disclosure, the operations may include an operation of obtaining first data including an image from a database to cause the one or more processors to perform an operation for displaying the data in a spreadsheet; and an operation of displaying the first data in a spreadsheet through a spreadsheet module based on the first data.

[0099] According to another embodiment of the present disclosure, the operations may include: a spreadsheet module receiving parameters of a data extraction function to cause the one or more processors to perform operations for outputting data to a spreadsheet; generating a first syntax for accessing a database based on the parameters of the data extraction function; retrieving first data from the database using the first syntax; and outputting the first data through the spreadsheet module based on the parameters of the data extraction function.

[0100] According to yet another embodiment of the present disclosure, the present disclosure may relate to a computer-implemented method for finding and editing one or more parameter lists associated with a model represented in a spreadsheet document. The method includes requesting a web-based spreadsheet server to transmit a spreadsheet document to be displayed on a display device. The spreadsheet document includes a first subgroup of cells designated as parameters associated with the model and a second subgroup of cells not designated as parameters. The method includes retrieving one or more parameter lists associated with the model and displaying a user interface (UI) component for editing values ​​in cells of the first subgroup corresponding to parameters of the lists. The method may also include finding the parameter list through an application programming interface (API), displaying a UI component generally adjacent to the spreadsheet document, and requesting the parameter list through the UI component. The parameter list may be displayed as names of parameters in an associated user interface control area for receiving input from a user. The method may also include editing the parameters of the parameter list by entering new values ​​for the parameters through the associated user interface (UI) control.

[0101] In accordance with yet another embodiment of the present disclosure, the present disclosure describes a computer-implemented method for finding and editing parameters associated with a model represented in a spreadsheet document via a web-based spreadsheet service, the method involving sending the spreadsheet document to a server and requesting that the document be rendered on a display device of a client. The document includes a first subgroup of cells designated as parameters and a second subgroup of cells not designated as parameters. The method includes searching one or more parameter lists associated with the model and displaying a user interface component for editing values ​​of cells in the first subgroup of cells corresponding to the parameters.

[0102] The disclosure may also include discovering the parameter list through an application programming interface or requesting the parameter list through a user interface component. The parameter list may be displayed as names of parameters in a control area of ​​the user interface for receiving input from a user. The method may also include editing the parameters of the list by entering new values ​​into cells corresponding to the first subset of cells through the user interface component.

[0103] Meanwhile, the user interface components may be displayed adjacent to the spreadsheet document and may include user interface controls for receiving input from a user. Also, through the computing environment of the present disclosure, parameters may be selected from a list and certain parameters may be edited by entering new values ​​through the user interface controls. The process may also include updating the model with the new parameter values ​​and recalculating the model based on the updated parameters.

[0104] Also disclosed is a computer-readable medium having a data structure stored thereon in accordance with one embodiment of the present disclosure.

[0105] A data structure can refer to the organization, management, and storage of data that allows efficient access and modification of the data. A data structure can refer to the organization of data to solve a specific problem (e.g., data retrieval, data storage, data modification in the shortest time). A data structure can also be defined as a physical or logical relationship between multiple data elements designed to support a specific data processing function. A logical relationship between multiple data elements can include a linking relationship between multiple user-defined data elements. A physical relationship between multiple data elements can include an actual relationship between multiple data elements that is physically stored in a computer-readable storage medium (e.g., a permanent storage device). A data structure can specifically include a collection of data, the relationship between the data, and a function or instruction that can be applied to the data. By utilizing an effectively designed data structure, a computing device can perform operations while minimizing the use of computing device resources. Specifically, a computing device can increase the efficiency of operations, reading, retrieval, deletion, comparison, exchange, and search through an effectively designed data structure.

[0106] Data structures can be classified into linear data structures and non-linear data structures based on the shape of the data structure. A linear data structure can be a structure in which one piece of data is connected to one piece of data. Linear data structures can include lists, stacks, queues, and deques. A list can refer to a collection of a series of data that has an internal order. A list can include linked lists. A linked list can be a data structure in which data is linked in a manner in which each piece of data has a pointer and is connected in a line. In a linked list, the pointer can include information regarding the connection to the next piece of data or the previous piece of data. A linked list can be expressed as a singly linked list, a doubly linked list, or a circularly linked list depending on the shape. A stack can be a data array structure in which access to data is restricted. A stack can be a linear data structure in which data can be manipulated (e.g., inserted or deleted) only at one end of the data structure. Data stored in a stack can be a LIFO (Last in First Out) data structure. A queue is also a data structure that limits access to data, but unlike a stack, it can be said to be a first in, first out (FIFO) data structure. A deck can be a data structure that allows data to be processed at both ends of the data structure.

[0107] A nonlinear data structure can be a structure in which multiple data are connected after one piece of data. A nonlinear data structure can include a graph data structure. A graph data structure can be defined by vertices and edges, and an edge can include a line connecting two different vertices. A graph data structure can include a tree data structure. A tree data structure can be a data structure in which there is one path connecting two different vertices among multiple vertices included in the tree. In other words, the graph data structure can be a data structure that does not form a loop.

[0108] The data structure may include data to be input to the neural network. The data structure including the data to be input to the neural network may be stored on a computer-readable medium. The data to be input to the neural network may include training data input during the training process of the neural network and / or input data to the neural network after training has been completed. The data to be input to the neural network may include data that has been pre-processed and / or data that is the target of pre-processing. Pre-processing may include a data processing process for inputting data to the neural network. Thus, the data structure may include data that is the target of pre-processing and data that is generated by pre-processing. The above data structures are merely examples, and the present disclosure is not limited thereto.

[0109] The data structure may include weights of the neural network. (In this specification, weights and parameters may be considered to have the same meaning.) The data structure including the weights of the neural network may be stored in a computer-readable medium. The neural network may include multiple weights. The weights may be variable, but may be changed by a user or an algorithm to perform a function required by the neural network. For example, when one or more input nodes are interconnected to one output node by respective links, the output node may determine the value of data output from the output node based on multiple values ​​input to the input nodes connected to the output node and weights set to the links corresponding to each input node. The above data structures are merely examples, and the present disclosure is not limited thereto.

[0110] Although the present disclosure has been described above as generally being embodied in a computing device, those skilled in the art will appreciate that the present disclosure can also be embodied in combination with computer-executable instructions and / or other program modules capable of being executed on one or more computers and / or as a combination of hardware and software.

[0111] Generally, modules herein include routines, programs, components, data structures, etc. that perform particular tasks or implement particular abstract data types. Additionally, those skilled in the art will appreciate that the methods of the present disclosure can be practiced with other computer system configurations, including single-processor or multi-processor computer systems, minicomputers, mainframe computers, as well as personal computers, handheld computing devices, microprocessor-based or programmable consumer electronics, etc., each of which can operate in conjunction with one or more associated devices.

[0112] The embodiments described in this disclosure may also be practiced in distributed computing environments where certain tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote memory storage devices.

[0113] A computer includes a variety of computer-readable media. Any medium accessible by a computer can be a computer-readable medium, including volatile and non-volatile media, transitory and non-transitory media, mobile and non-mobile media. By way of example and not limitation, computer-readable media can include computer-readable storage media and computer-readable transmission media. Computer-readable storage media include volatile and non-volatile media, transitory and non-transitory media, mobile and non-mobile media implemented by any method or technology for storing information such as computer-readable instructions, data structures, program modules or other data. Computer-readable storage media include, but are not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, DVD (digital video disk) or other optical disk storage device, magnetic cassette, magnetic tape, magnetic disk storage device or other magnetic storage device, or any other medium that can be accessed by a computer and used to store information.

[0114] Computer-readable transmission media typically embodies computer-readable instructions, data structures, program modules or other data in a modulated data signal, such as a carrier wave or other transport mechanism, and includes all information delivery media. The term modulated data signal means a signal that has one or more of its characteristics set or changed in such a manner as to encode information in the signal. By way of example, and not limitation, computer-readable transmission media includes wired media, such as a wired network or direct-wired connection, and wireless media, such as acoustic, RF, infrared and other wireless media. Any combination of any of the above media should also be included within the scope of computer-readable transmission media.

[0115] An exemplary environment (1100) for implementing various aspects of the present disclosure is shown including a computer (1102) including a processing unit (1104), a system memory (1106), and a system bus (1108). The system bus (1108) couples system components, including, but not limited to, the system memory (1106), to the processing unit (1104). The processing unit (1104) can be any of a variety of commercially available processors. Dual processors and other multi-processor architectures can also be utilized as the processing unit (1104).

[0116] The system bus (1108) can be any of several types of bus structures that can be further interconnected to a memory bus, a peripheral bus, and a local bus using any of a variety of commercially available bus architectures. The system memory (1106) includes read only memory (ROM) (1110) and random access memory (RAM) (1112). The basic input / output system (BIOS) is stored in non-volatile memory (1110), such as ROM, EPROM, or EEPROM, and contains the basic routines that support the exchange of information between the various components of the computer (1102), such as during start-up. The RAM (1112) can also include high-speed RAM, such as static RAM, for caching data.

[0117] The computer 1102 also includes an internal hard disk drive (HDD) 1114 (e.g., EIDE, SATA) (the internal hard disk drive 1114 can also be configured for external use in a suitable chassis (not shown)), a magnetic floppy disk drive (FDD) 1116 (e.g., for reading from and writing to a removable diskette 1118), and an optical disk drive 1120 (e.g., for reading CD-ROM disks 1122 and for reading from and writing to other high-capacity optical media such as DVDs). The hard disk drive 1114, magnetic disk drive 1116, and optical disk drive 1120 can be connected to the system bus 1108 by a hard disk drive interface 1124, a magnetic disk drive interface 1126, and an optical drive interface 1128, respectively. The interface (1124) for implementing an external drive includes, for example, at least one or both of the Universal Serial Bus (USB) and IEEE 1394 interface technologies.

[0118] These drives and their associated computer-readable media provide non-volatile storage of data, data structures, computer-executable instructions, and the like. In the case of computer 1102, the drives and media accommodate the storage of any data in a suitable digital format. While the above description of computer-readable storage media refers to HDDs, removable magnetic disks, and removable optical media such as CDs or DVDs, those skilled in the art will appreciate that other types of computer-readable storage media, such as zip drives, magnetic cassettes, flash memory cards, cartridges, and the like, can also be used in the exemplary operating environment, and further that any such media can contain computer-executable instructions for performing the methods of the present disclosure.

[0119] A number of program modules may be stored in the drives and RAM 1112, including an operating system 1130, one or more application programs 1132, other program modules 1134, and program data 1136. All or portions of the operating system, applications, modules, and / or data may also be cached in RAM 1112. It will be appreciated that the present disclosure may be implemented with various commercially available operating systems or combinations of operating systems.

[0120] A user may enter commands and information into the computer 1102 through one or more wired or wireless input devices, such as a keyboard 1138 and a pointing device, such as a mouse 1140. Other input devices (not shown) may include a microphone, an IR remote control, a joystick, a game pad, a stylus pen, a touch screen, and the like. These and other input devices are often connected to the processing unit 1104 through an input device interface 1142 that is connected to the system bus 1108, but may also be connected through other interfaces, such as a parallel port, an IEEE 1394 serial port, a game port, a USB port, an IR interface, and the like.

[0121] A monitor 1144 or other type of display device is also connected to the system bus 1108 through an interface, such as a video adapter 1146. In addition to the monitor 1144, computers typically include other peripheral output devices (not shown), such as speakers, printers, etc.

[0122] The computer 1102 can operate in a networked environment using logical connections to one or more remote computers, such as remote computer(s) 1148, via wired and / or wireless communications. The remote computer(s) 1148 can be a workstation, a server computer, a router, a personal computer, a handheld computer, a microprocessor-based entertainment device, a peer device or other conventional network node, and typically includes many or all of the components depicted for the computer 1102, although for simplicity, only a memory storage device 1150 is illustrated. The logical connections depicted include wired and wireless connections in a local area network (LAN) 1152 and / or larger networks, such as a wide area network (WAN) 1154. Such LAN and WAN networking environments are commonplace in offices and companies and facilitate enterprise-wide computer networks, such as intranets, all of which may connect to a global computer network, such as the Internet.

[0123] When used in a LAN networking environment, the computer 1102 connects to the local network 1152 through a wired and / or wireless communication network interface or adapter 1156. The adapter 1156 can facilitate wired or wireless communication to the LAN 1152, which may also include a wireless access point installed thereon for communicating with the wireless adapter 1156. When used in a WAN networking environment, the computer 1102 can include a modem 1158 or have other means for establishing communications over the WAN 1154, such as connecting to a communications server on the WAN 1154 or through the Internet. The modem 1158, which can be internal or external and can be a wired or wireless device, connects to the system bus 1108 through the serial port interface 1142. In a networked environment, program modules described for computer 1102, or portions thereof, may be stored in a remote memory / storage device 1150. It will be readily appreciated that the network connections shown are exemplary and other means of establishing a communications link between the computers may be used.

[0124] The computer 1102 is operable to communicate with any wireless device or unit that is deployed and operates in wireless communication, such as printers, scanners, desktop and / or handheld computers, portable data assistants (PDAs), communication satellites, any equipment or location associated with a wirelessly detectable tag, and telephones. This includes at least Wi-Fi and Bluetooth wireless technologies. Thus, communication can be in a predefined structure, such as a traditional network, or simply ad hoc communication between at least two devices.

[0125] Wi-Fi (Wireless Fidelity) allows devices to connect to the Internet without being wired. Wi-Fi is a wireless technology like a cell phone that allows such devices, e.g., computers, to send and receive data indoors and outdoors, anywhere within the range of a base station. Wi-Fi networks use IEEE 802.11 (a, b, g, etc.) radio technology to provide secure, reliable, and fast wireless connections. Wi-Fi can be used to connect computers to each other, to the Internet, and to wired networks (using IEEE 802.3 or Ethernet). Wi-Fi networks can operate in the unlicensed 2.4 and 5 GHz radio bands, e.g., at data rates of 11 Mbps (802.11a) or 54 Mbps (802.11b), or in products that include both bands (dual bands).

[0126] Those of ordinary skill in the art will appreciate that information and signals may be represented using any of a variety of different technologies and techniques. For example, the data, instructions, commands, information, signals, bits, symbols, and chips referred to in the above description may be represented by voltages, currents, electromagnetic waves, magnetic fields, etc. or particles, optical fields, etc. or particles, or any combination thereof.

[0127] Those of ordinary skill in the art will appreciate that the various exemplary logic blocks, modules, processors, means, circuits, and algorithm steps described in the description of the embodiments disclosed herein can be implemented by electronic hardware, various forms of program or design code (for convenience, referred to herein as "software"), or a combination of all of these. To clearly illustrate such interoperability of hardware and software, the various exemplary components, blocks, modules, circuits, and steps have been generally described above with a focus on their functionality. Whether such functionality is implemented in hardware or software depends on the design constraints imposed on the particular application and the overall system. Those of ordinary skill in the art will appreciate that the described functionality can be implemented in various ways for each particular application, and such implementation decisions should not be interpreted as departing from the scope of the present disclosure.

[0128] The various embodiments described herein may be implemented by a method, apparatus, or article of manufacture using standard programming and / or engineering techniques. The term "article of manufacture" includes a computer program, carrier, or media accessible by any computer-readable device. For example, computer-readable storage media include, but are not limited to, magnetic storage devices (e.g., hard disks, floppy disks, magnetic strips, etc.), optical disks (e.g., CDs, DVDs, etc.), smart cards, and flash memory devices (e.g., EEPROM, cards, sticks, key drives, etc.). Additionally, the various storage media described herein include one or more devices and / or other machine-readable media for storing information.

[0129] It should be understood that the particular order or hierarchy of the process steps depicted is an example of an example approach. Based on design priorities, it should be understood that the particular order or hierarchy of the process steps can be rearranged within the scope of the present disclosure. The accompanying method claims provide elements of the various steps in an example order, but are not meant to be limited to the particular order or hierarchy depicted.

[0130] The description of the illustrated embodiments is provided to enable any person of ordinary skill in the art to which the disclosure pertains to the present disclosure to utilize or practice the present disclosure. Various modifications to such embodiments will be apparent to those of ordinary skill in the art to which the disclosure pertains, and the general principles defined herein may be applied to other embodiments without departing from the scope of the present disclosure. Thus, the present disclosure is not intended to be limited by the embodiments shown herein, but is to be accorded the broadest scope consistent with the principles and novel features disclosed herein.

[0131] This disclosure was made as part of a government sponsored project as described below. Project unique number: 1415169086 (Institution) Detailed assignment number: 20008795 Department name: Ministry of Trade, Industry and Energy Research management specialist agency: Korea Institute for Industrial Technology Evaluation and Management Research project name: Knowledge service industry core technology development - Manufacturing service integration Research topic: Development of smart devices equipped with noise reduction technology for voice recognition specialized for manufacturing sites and artificial intelligence virtual secretary service Contribution rate: 100% Administrative agency: Miso Information Technology Co., Ltd. Participating organization: BI Matrix Co., Ltd. Research period: May 1, 2020 ~ December 31, 2022

Claims

1. 1. A method of data output performed by a computing device, comprising: receiving parameters for a data extraction function by a spreadsheet module; generating a first syntax for accessing a database based on parameters of the data extraction function; retrieving first data from the database using the first syntax; outputting the first data through the spreadsheet module based on parameters of the data extraction function; modifying the first data to generate second data; generating a cache function based on the second data; and outputting the second data through the spreadsheet module based on the cache function; Including, method.

2. In claim 1, The parameters of the data extraction function are: At least one of information related to data name, information related to data column name, information related to data attribute, information related to data field selection, and information related to data inquiry authority is included; method.

3. In claim 1, outputting the first data through the spreadsheet module based on the parameters of the data extraction function, generating said first data based on a parameter of a style control function; method.

4. In claim 3, The parameters of the style control function are: At least one of data record layout information, data calculation information, image information, cell style information, cell integration information, conditional formatting information, and chart creation information included in the spreadsheet is included; method.

5. In claim 4, The parameters of the style control function are: The first data further includes repeatedly used cell style information, which is information for repeatedly outputting the record included in the first data. method.

6. In claim 4, The data calculation information is repeatedly specifying input values ​​for formulas included in the spreadsheet module based on the data extraction function; method.

7. In claim 4, outputting the first data to a spreadsheet through a parameter of the style control function based on the first data, confirming an area on a screen where the first data is to be output; and calculating the data record layout information based on information related to field values ​​and information related to the area to be output; Including, method.

8. In claim 1, The step of modifying the first data to generate second data includes: Only preset items of the first data can be modified. method.

9. In claim 1, The step of generating a cache function based on the second data includes: modifying another region that references the referenced region or the referenced region when the referenced region in the second data is modified; Including, method.

10. In claim 1, generating a second syntax for updating the first data in the database with the second data based on the cache function; and updating the database using the second syntax; Including, method.

11. A computer program stored on a computer readable storage medium, comprising: The computer program, when executed by one or more processors, causes the one or more processors to perform operations for outputting data to a spreadsheet, the operations comprising: The spreadsheet module receives parameters for the data extraction function; generating a first syntax for accessing a database based on parameters of the data extraction function; retrieving first data from the database using the first syntax; outputting the first data through the spreadsheet module based on parameters of the data extraction function; modifying the first data to generate second data; generating a cache function based on the second data; and outputting the second data through the spreadsheet module based on the cache function; Including, A computer program stored on a computer readable storage medium.

12. 1. A computing device comprising: At least one processor; and memory; Including, The at least one processor further comprises: The spreadsheet module receives the parameters of the data extraction function; generating a first syntax for accessing a database based on parameters of the data extraction function; obtaining first data from the database using the first syntax; and outputting the first data through the spreadsheet module according to parameters of the data extraction function; modifying the first data to generate second data; generating a cache function based on the second data; configured to output the second data through the spreadsheet module based on the cache function; Computing device.

Images