JP2024095584A - Method of loading dataset containing images - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a method of processing image data in the field of information processing.

SOLUTION: The present invention provides a method of obtaining user input syntax for original data, checking whether or not the user input syntax includes data related to image data, and outputting the user input syntax to a user interface (UI) according to the image data.

SELECTED DRAWING: Figure 1

COPYRIGHT: (C)2024,JPO&INPIT

Description

The present disclosure relates to a method for processing image data in the field of information processing. In particular, the present disclosure provides a method for acquiring a user input statement for original data, determining whether the user input statement includes data related to image data, and outputting the image data to a user interface (UI).

As computer technology advances, companies and government offices use a variety of computer programs for business management and administration. These computer programs can store and process a large amount of data necessary for business management and administration, such as accounting, human resources, finance, sales, trade, purchasing, materials, production, and inventory. By using these computer programs, users (practitioners, executives, and managers of companies and government offices) can more conveniently and easily store and manage data used by companies and government offices. Computer programs used by companies and government offices support functions for generating, editing, and managing documents in various formats. However, there is a problem in that image data is not managed when storing, processing, and outputting data, resulting in a waste of computing resources such as storage capacity.

Korean Patent Registration No. 10-0593661 (2006.06.20)

The present disclosure has been devised in response to the background art described above, and provides a method for conveniently processing image data.

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

In some embodiments, a method for solving the above-mentioned problems may be performed by a computing device, the method including: acquiring first data including an image from a database based on a spreadsheet module; and displaying the first data in a spreadsheet via the spreadsheet module based on the first data.

In one embodiment, the spreadsheet module may include style control function parameters including at least one of cell style information, cell alignment information, cell merging information, conditional formatting information, or chart output information to be displayed in the spreadsheet.

In one embodiment, the information about the image of the first data includes image storage path information, and the step of displaying the first data in a spreadsheet through a parameter of a style control function based on the first data may include a step of obtaining the image based on the image storage path information, and a step of converting the image into a standard image and displaying it in the spreadsheet.

In one embodiment, the spreadsheet module may include an image list for images assigned with image key values, and the step of displaying the first data in the spreadsheet through a parameter of a style control function based on the first data 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 in the image list, a step of displaying the image of the first data in the spreadsheet based on the image list.

In one embodiment, if the image of the first data is not included in the image list, the method may further include 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.

In one embodiment, the method further includes generating second data by modifying the first data, and the generating second data by modifying the first data may include replacing an image of the first data to generate second data, comparing the image of the second data with the image list, and if the image of the second data corresponds to any one of the images in the image list, generating a cache function based on the image list, and displaying in a spreadsheet based on the cache function.

In one embodiment, if the image of the second data is not included in the image list, the method may further include assigning a new image key value to the image of the second data, and including the image of the second data in the image list.

In one embodiment, the step of generating second data in which the first data is modified may allow modification only to a predefined area of the first data.

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.

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

The computer program, when executed by one or more processors, may cause the one or more processors to perform operations for displaying data in a spreadsheet, the operations including obtaining first data including an image from a database, and displaying the first data in a spreadsheet via a spreadsheet module based on the first data.

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

The computing device may include at least one processor and a memory, and the at least one processor may be configured to obtain first data including an image from a database to display the data in a spreadsheet; and display the first data in the spreadsheet via a spreadsheet module based on the first data.

The present disclosure has been devised in response to the background art described above, and can provide a method for users to conveniently access original data.

Further scope of applicability of the present disclosure will become apparent from the following detailed description. However, since various changes and modifications within the spirit and scope of the present invention will be apparent to those skilled in the art, it should be understood that the detailed description and specific embodiments, such as the preferred embodiments of the present invention, are given by way of example only.

Various aspects are described with reference to the drawings, where like reference numerals are used to generally refer to like components. In the following embodiments, for purposes of explanation, numerous specific details are presented to provide a general understanding of one or more aspects. It will be apparent, however, that such aspects may be practiced without such specific details. In other instances, well-known structures and devices are shown in block diagram form in order to facilitate describing one or more aspects.

FIG. 1 is a block diagram illustrating a computing device according to an embodiment of the present disclosure. FIG. 2 is a flowchart illustrating a method for extracting and outputting original data according to an embodiment of the present disclosure. FIG. 3 is a flowchart of a method for outputting a data set on a first program on a second program of a computing device according to one embodiment of the present disclosure. FIG. 4 is a flow chart illustrating a method for a spreadsheet module to access original data and output first data according to an embodiment of the present disclosure. FIG. 5 is a signal flow diagram illustrating how a spreadsheet module accesses original data and outputs first data according to an embodiment of the present disclosure. FIG. 6 is a conceptual diagram illustrating a spreadsheet module including parameters of a data extraction function and parameters of a style control function according to one embodiment of the present disclosure. FIG. 7 is a conceptual diagram for explaining a method for iteratively specifying input values of a formula included in a spreadsheet module according to an embodiment of the present disclosure. FIG. 8 is a general schematic diagram of an exemplary computing environment in which embodiments of the present disclosure may be implemented.

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.

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 may 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, an application running on a computing device and a computing device may both be components. One or more components may reside within a processor and/or thread of execution. A component may be localized within a computer. A component may be distributed across two or more computers. Such components may also execute from various computer-readable media having various data structures stored therein. Components may communicate through local and/or remote processing, etc., such as by signals (e.g., data from one component interacting with other components in a local system, distributed system, and/or data transmitted over a network such as the Internet to other systems) having one or more data packets.

The suffixes "module" and "part" used in the following description are given or mixed for the sole consideration of ease of drafting the specification, and do not have any distinct meanings or roles in themselves.

Also, as used herein, the terms "information" and "data" can often be used interchangeably.

When any component is referred to as being "coupled" or "connected" to another component, it should be understood that it may be directly coupled or connected to the other component, but there may be other components in between. On the other hand, when any component is referred to as being "directly coupled" or "directly connected" to another component, it should be understood that there are no other components in between.

The term "or" is also intended to mean an inclusive "or" rather than an exclusive "or." That is, unless otherwise specified or 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, or 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 should be understood to refer to and include all possible combinations of one or more of the associated listed items.

The predicate "comprises" and/or modifier "comprises" should be understood to mean the presence of the feature and/or component in question. However, the predicate "comprises" and/or modifier "comprises" should be understood not to exclude the presence or addition of one or more other features, components, and/or groups thereof. In addition, unless otherwise specified or unless the context is clear to indicate the singular form, the singular in the present specification and claims should generally be interpreted to mean "one or more."

Hereinafter, the same or similar components are denoted by the same reference numerals, regardless of the reference numerals, and repeated explanations are omitted. In addition, when explaining the embodiments disclosed in this specification, if a specific explanation of related publicly known technology is judged to make the gist of the embodiments disclosed in this specification unclear, the detailed explanation is omitted. In addition, the attached drawings are intended to make it easier to understand the embodiments disclosed in this specification, and the technical ideas disclosed in this specification are not limited by the attached drawings.

The term "at least one of A or B" should be interpreted as meaning "when only A is included," "when only B is included," or "when a combination of A and B is included."

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 implemented 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 constraints of the overall system. Skilled engineers can implement 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.

The description of the embodiments set forth herein is provided to enable one of ordinary skill in the art to use 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 set forth herein, but is to be accorded the broadest scope consistent with the principles and novel features set forth herein.

Below, Figures 1 to 8 explain how a computing device extracts and outputs original data in this disclosure.

Figure 1 is a block diagram illustrating a computing device according to one embodiment of the present disclosure.

The configuration of computing device 100 shown in FIG. 1 is merely a simplified example. As an example, computing device 100 may include other components for implementing the computing environment of computing device 100, and only some of the disclosed components may constitute computing device 100.

The computing device 100 may include a processor 110, a memory 130, and a network unit 150.

According to an embodiment of the present disclosure, the processor 110 may generally include any type of device capable of processing operations and data of the computing device 100. For example, it may refer to a data processing device built into hardware having a circuit physically structured to perform a function expressed by a code or instruction contained in a program. Examples of such a data processing device built into hardware may include a microprocessor, a central processing unit (CPU), a processor core, a multiprocessor, an application-specific integrated circuit (ASIC), a field programmable gate array (FPGA), etc., but the scope of the present invention is not limited thereto.

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

According to 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.

According to one embodiment of the present disclosure, the memory 130 may be a flash memory type, a hard disk type, a multimedia card micro type, a card type memory (e.g., SD or XD memory, etc.), a RAM (Random Access Memory, RAM), a SRAM (Static Random Access Memory, SRAM), a ROM (Read-Only Memory, ROM), an EEPROM (Electrically Erasable Programmable Read-Only Memory), a PROM (Programmable Read-Only Memory, PROM), a EEPROM (Electrically Erasable Program ... The memory 130 may include at least one type of storage medium, such as a memory, a magnetic memory, a magnetic disk, or an optical disk. The computing device 100 may also operate in association with 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.

The network unit 150 according to one embodiment of the present disclosure can use various wired communication systems such as the 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 Local Area Network (LAN).

In addition, the network unit 150 presented 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.

In the present disclosure, the network unit 150 may be configured regardless of the communication mode, such as wired or wireless, and may be configured with various communication networks, such as a short-range communication network (LAN: Local Area Network), a personal communication network (PAN: Personal Area Network), and a wide area communication network (WAN: Wide Area Network). In addition, the network may be the well-known World Wide Web (WWW: World Wide Web), or may use a wireless transmission technology used for short-range communication, such as infrared (IrDA: Infrared Data Association) or Bluetooth (registered trademark).

The techniques described herein may be used in the networks mentioned above as well as in other networks.

Figure 2 is a flowchart illustrating a method for extracting and outputting original data according to one embodiment of the present disclosure.

Referring to FIG. 2, the computing device of the present disclosure may include a step of receiving a data extraction function for 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).

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). Here, 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 from a field setting unit for selecting a field from the original data or a data attribute setting unit for setting a data type, or may include a mathematical formula in which a setting value is input to the function. The user interface (UI) may further include a connection setting unit for inputting access information for the original data. A method in which the user interface (UI) extracts original data will be described below with reference to FIG. 5, FIG. 6, etc.

The functions may also be modularized. The modularized functions can replace programming for data conversion, which can be somewhat complicated. The functions may be created according to predefined rules, which may include the same rules as program formulas.

On the other hand, the statement is a specific unit (e.g., one line) of code that performs a specific task. As an example, the statement may be a simple assignment of values to variables, or a more complex expression that includes various operations and functions. The statement may follow the program syntax of the original data. The grammar indicates 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 may vary depending on the program type of the original data, and the program of the original data may be difficult for a user to master, so generating the statement may be difficult. Therefore, when using the modularized functions, a user can conveniently handle the original data in an abstract form, regardless of the program of the original data.

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 and expanding a certain construct, in which the data extraction function is preprocessed into a statement generator. Next, the computing device 100 reads the source code and breaks down the extraction function into a series of tokens. Here, the tokens represent single elements included in the extraction function, such as keywords, identifiers, sentence symbols, etc. Next, the computing device 100 checks for syntax errors from the extraction function, creates a tree-like structure called an abstract grammar tree (AST), and converts it so that the processor 110 can easily understand it. The computing device 100 may then inspect the abstracted functions for semantic errors, such as using a variable before it is declared or calling a module with an incorrect number of arguments, and convert the AST into a statement that can be executed by the original data program. That is, the abstracted abstracted functions may be converted into lower level statements that can be executed by the original data program, such as one or more of a loop, conditional statement, or query. In this case, the conversion process may include optimizing the query to take advantage of indexes or other performance improvements available in the original data, or splitting the query into smaller fragments to be executed separately. The optimization may include optimizing the query to take advantage of indexes or other performance improvements available in the original data, or splitting the query into smaller fragments to be executed separately.

The step of executing the statement and extracting data (S300) may be performed by a program that accesses the original data and manages the original data. The computing device 100 may also check and prepare all symbols or references that can be used in the process of executing the statement. As an example, the statement may be performed by a database management system (DBMS), and the original data may be included in a relational database. That is, the statement may be a database query statement such as an SQL query statement. The computing device 100 creates a connection to the original data using a connection string that specifies the name, user name, and password (if necessary) of the data original by the application software. Once the connection is established, the database management system may execute the SQL query statement on the original data in the form of an API or the like. The application software may execute the SQL query statement generated based on the extraction function of the present disclosure, search the results, and manage transactions.

Here, the application software can analyze the SQL query statement and redetermine the most efficient way to execute against the underlying form of the original data to process the query. Examples include optimizing the query to take advantage of indexes or other performance enhancements available on the original data, or splitting the query into smaller fragments to execute separately, which may be omitted if an optimized syntax was generated in step S200. The application software can also handle error checking and handling, so that any errors that occur during query execution are correctly reported back to the application software.

In the step of outputting the extracted data (S400), for example, the result of executing an SQL query statement, the extracted data 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 varies depending on the client application software being used. For example, if the client program is a command line interface (CLI), the results may be displayed in the form of a table on the terminal, but if the client program is a graphical user interface (GUI) that runs in a web browser, the results may be displayed in a table or other visual representation on the screen, allowing the user to conveniently use the graphical user interface (GUI).

FIG. 3 is a flowchart of a method for outputting a data set on a first program on a second program of a computing device according to one embodiment of the present disclosure.

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

In the step of receiving a first user input for the data set (S110), the computing device may receive the first user input on a first user interface provided on the first program. As an example, the user terminal may output a first user interface including an object for executing a user's desired application or application function using a touch screen or any form of display unit. Here, when an object including a tap or icon displayed on the user terminal is selected, the user terminal may execute an application or application function corresponding to the selected operation. In one embodiment of the present disclosure, a screen, area, identification information, indicator, input window, module, and/or tap, etc. including at least one object may constitute a 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.

In the step of receiving a second user input for defining the dataset on the first program (S210), the computing device may receive a second user input via a first user interface for defining an identification of a dataset to correspond to at least a portion of the identification of the first region included in the first user input acquired in the 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 a first indicator, a separator, and a name of a dataset. When 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.

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, or field information. The second user input may also be for setting columns associated with syntax generation or for specifying record conditions. For example, even if the column order between the original data and the output data is changed or the column names are different, 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.

In the step of executing the second user input and acquiring the data set (S310), the computing device sets a range of specific data in a spreadsheet module, and when the identification information of the second program as described above is input for the range, the data set can be loaded on the second program through a comparison between the identification information of the second program and the identification information of the first program. In addition, the second program can further receive metadata including additional information of any form for identifying the name, range, etc. of data, such as identification information and/or range information, and the metadata can generate a meta input object.

In addition, in the step of outputting the data set on the second program (S410), the output size of each data included in the data set loaded and output on the second program can be determined or the arrangement can be changed. 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 be the same as or similar to functions commonly used in commercial spreadsheets. The data output to the second program can be set in various ways according to the data access permissions of the account that queries the data.

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

The output form can be changed in various ways, such as a combo box and 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, data corresponding to the specific year from the dataset of the first program can be loaded and output on the second program.

In addition, in the second program, the additional information output with the data set and the original data for the data set may not be linked to each other. In this case, the computing device 100 may output the additional information to the second program without changing the information of the original data or making complex changes to the SQL query statement.

Figures 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 one embodiment of the present disclosure.

Referring to FIG. 4 and FIG. 5, the computing device of the present disclosure may include a step of a spreadsheet module receiving parameters of a data extraction function (S120), a step of generating a first syntax for accessing original data (S220), a step of acquiring first data from the original data (S320), and a step of outputting the first data via the spreadsheet module (S420).

The original data may be contained in a relational database, and as an example, the database may be controlled by at least one relational database management system (RDBMS) such as ORACLE, PostgreSQL, MySQL, SQL Server (MS-SQL), or SQLite.

In the step (S120) of the spreadsheet module receiving parameters of the data extraction function, the spreadsheet module may receive the parameters of the data extraction function from a first interface. The parameters may include first connection setting information and first syntax setting information. The first connection setting information may include settings related to at least one of one or more associated database names, database types, serial numbers, paths or access rights to the databases, serial numbers for target tables included in the databases, and the number of fields or access rights to the target tables.

In the step of generating a first syntax for accessing the original data (S220), when the spreadsheet module sets the database management system (RDBMS) for the first syntax, a customized statement that matches the syntax according to the type of database may be generated. As an example, through the present disclosure, a user can conveniently generate a statement using an abstracted formula provided by 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 may be displayed in a cell on the spreadsheet, and may be confirmed and controlled by the user.

Also, the spreadsheet module may be associated with an SQL query statement, the syntax of which performs one or more operations among create, read, update, and delete (CRUD). Here, the SQL query statement may be a signal associated with any one of commands among insert, update, and delete, and the signal may be input or displayed as a name or an abbreviation of the SQL query statement in a cell of a spreadsheet. As an example, the display may be as shown in Table 1 below.

The second user input may also be for setting columns related to syntax generation or for specifying record conditions. As an example, a SQL query statement may be executed even if the column order between the original data and the output data is changed or the column names are different. The second user input may also display annotations for the output data.

In the step of acquiring first data from the original data (S320), the first data may be obtained based on the first syntax. As an example, the first syntax may search for an original data list associated with a model represented in a spreadsheet document. Through this, the first syntax may request the first data to be transferred for output from a client. Thus, the spreadsheet module may provide a user interface component for editing the value of a cell designated to output the original data through a style control function. The configuration that the style control function includes for outputting the first data will be described below with reference to FIG. 6.

In the step of outputting the first data through the spreadsheet module (S420), the spreadsheet module may output the original data through the data extraction function or the style control function.

As an 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 the parameters of the style control function. Conventionally, in order to output data from a database to a template, specialized knowledge of a separate SQL query statement is required, and knowledge for data search is also required separately. In addition, connections using database connectors must be set separately. However, when using the spreadsheet module of the present disclosure, it is possible to save time and costs for setting such SQL query statements or database connectors separately.

In addition, the step of displaying the first data in a spreadsheet through a parameter of a style control function based on the first data may further include a step of obtaining the image based on the image storage path information, and a step of converting the image into a standard image and displaying it in the spreadsheet.

The spreadsheet module of the present disclosure may further include an image list for images to which image key values are assigned, and the step of displaying the first data in a spreadsheet through a parameter of a style control function based on the first data 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 a spreadsheet based on the image list when the image of the first data corresponds to any one of the images in the image list.

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 the screen where the first data is to be output, and calculating the data record arrangement information based on information about the field value and information about the area where the first data is to be output.

In addition, in the step of changing the first data, a cache function may be generated to improve the efficiency of the change processing speed. Specifically, in the step of changing the first data, the first data may be modified to generate second data, and a cache function may be generated based on the second data. Next, the method may further include a step of outputting the second data through the spreadsheet module based on the cache function. Here, the step of modifying the first data to generate the second data may allow modification only to pre-set items of the first data, thereby preventing unnecessary data changes from occurring. In addition, in order to generate a cache function based on the second data, if a referenced area of the second data is modified, a step of modifying an area that references the referenced area may be included. In this case, data that needs to be updated of the second data in the modifying step may be automatically kept up to date.

In addition, the step of modifying the first data may include the step of generating a second syntax for updating the first data of the database to the second data based on the cache function. Then, the step of 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 second syntax may be generated without the user having to learn a separate database syntax.

Figure 6 is a conceptual diagram illustrating a spreadsheet module including parameters for a data extraction function and parameters for a style control function according to one embodiment of the present disclosure.

Referring to FIG. 6, the spreadsheet module 210 of the present disclosure may be for accessing a database including original data and processing the data into first data in a form for output. The spreadsheet module 210 may also include a data extraction function 400 and a style control function 500.

To access the original data, the processor can generate a first syntax based on parameters of the data extraction function 400. As an example, the data extraction function 400 may include all or a part of the original data. In addition, the parameters of the data extraction function 400 may include at least one of information on the data column name, data attribute information, data field selection information, or data query authority information.

The spreadsheet module 210 can also 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. In addition, a user interface setting function associated with the style control function 500 can be displayed in a second program if a predetermined condition is met, and the display method will be described later with reference to FIG. 7.

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 merging information, conditional formatting information, or chart generation information. In addition, the data calculation information 520 may repeatedly specify input values of a formula included in the spreadsheet module based on the data extraction function.

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. To this end, the area in the screen where the first data is to be output can be identified, and the data record layout information can be calculated based on information about the data, such as field values, and information about the area to be output.

The data calculation information 520 may also include iterative calculation information that iteratively specifies input values of a formula included in the spreadsheet module based on the data extraction function. The iterative calculation information will be described later with reference to FIG. 7.

In addition, the image information 530 for the image of the first data may include image storage path information, and the step of displaying the first data in a spreadsheet through a parameter of a style control function based on the first data may include a step of obtaining the image based on the image storage path information. In addition, the step of displaying the first data in a spreadsheet may include a step of converting the image into a standard image and displaying it in the spreadsheet.

In addition, the information regarding the image of the first data may include image storage path information, and the step of displaying the first data in a spreadsheet through a parameter of a style control function based on the first data may include a step of obtaining the image based on the image storage path information, and a step of converting the image into a standard image and displaying it in the spreadsheet.

The spreadsheet module of the present disclosure may further include an image list for images to which image key values are assigned, and the step of displaying the first data in the spreadsheet through parameters of a style control function based on the first data may include a step of comparing the image of the first data with the image list. Then, if the image of the first data corresponds to any one of the image lists, 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, and the image of the first data may be included in the image list.

If the image of the first data is added to the database only if it is not included in the image list, not only can the available space of the database be increased, but duplicate image data can be minimized and utilization of the image data can be maximized.

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 may compare the image of the second data with an image list. Then, if the image of the second data corresponds to any one of the images in the image list, the computing device may generate a cache function based on the image list and display the image in a spreadsheet based on the cache function.

Conversely, when the image is replaced, it can be checked whether the image of the second data is included in the image list. If the image of the second data is not included in the image list, a new image key value can be assigned to the image of the second data, and the image of the second data can be included in the image list.

If the image of the second data is added to the database only if it is not included in the image list, not only can the available space of the database be increased, but duplicate image data can be minimized and utilization of the image data can be maximized.

In addition, the cell style information 540 can set an overall template to be output when the spreadsheet module outputs the first data. In addition, the repetitive cell style information 550 can be used for a repetitive cell of a data record to output the data record to the spreadsheet module repeatedly.

Figure 7 is a conceptual diagram illustrating a method for iteratively specifying input values for a formula included in a spreadsheet module according to one embodiment of the present disclosure.

Referring to FIG. 7, the spreadsheet module according to one embodiment of the present disclosure may further include the repetitive cell operation information 551 in order to repeatedly specify the data operation information 520, and thereby the spreadsheet module may repeatedly output a formula without the need for a separate template cell setting.

Figure 8 is a general schematic diagram of an exemplary computing environment in which embodiments of the present disclosure may be implemented.

Referring to FIG. 8, the computer program, when executed by one or more processors, can perform an operation to extract and output original data.

According to one embodiment of the present disclosure, the operations may include an operation of the one or more processors obtaining first data including an image from a database 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.

According to another embodiment of the present disclosure, the operations may include a spreadsheet module receiving parameters of a data extraction function so that the one or more processors perform an operation to output data to a spreadsheet, generating a first syntax for accessing a database based on the parameters of the data extraction function, acquiring first data from the database using the first syntax, and outputting the first data via the spreadsheet module based on the parameters of the data extraction function.

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 subset of cells designated as parameters associated with the model and a second subset 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 subset corresponding to parameters of the lists. The method may also include finding the parameter lists via an application programming interface (API), displaying a UI component typically adjacent to the spreadsheet document, and requesting the parameter lists via the UI component. The parameter lists may be displayed by parameter name along with associated user interface controls for receiving input from a user. The method may also include editing the parameters of the parameter lists by entering new values for the parameters through associated user interface (UI) controls.

According to 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 requesting that the spreadsheet document be transferred from a server and rendered on a display device of a client. The document includes a first subset of cells designated as parameters and a second subset 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 subset of cells corresponding to the parameters.

The disclosure may also include discovering the parameter list via an application programming interface or requesting the parameter list via a user interface component. The parameter list may be displayed by parameter name along with a user interface control for receiving input from a user. The method may also include editing the parameters of the list by entering new values into corresponding cells of the first subset of cells via the user interface component.

In addition, 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, a particular parameter may be edited through the computing environment of the present disclosure by selecting the parameter from a list and entering a new value 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.

An embodiment of the present disclosure also discloses a computer-readable medium having a data structure stored thereon.

A data structure may refer to the organization, management, and storage of data that allows efficient access and modification of the data. A data structure may 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 may also be defined as a physical or logical relationship between data elements designed to support a specific data processing function. A logical relationship between data elements may include a linking relationship between user-defined data elements. A physical relationship between data elements may include an actual relationship between data elements that is physically stored in a computer-readable storage medium (e.g., a permanent storage device). A data structure may specifically include a collection of data, a relationship between data, and a function or instruction that can be applied to the data. Through 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.

Data structures may be classified into linear data structures and non-linear data structures according to the form of the data structure. A linear data structure may be a structure in which only one piece of data is linked after one piece of data. A linear data structure may include a list, a stack, a queue, and a deque. A list may mean a series of data sets that have an internal order. A list may include a linked list. A linked list may be a data structure in which data is linked in a manner in which each piece of data has a pointer and is linked in a row. In a linked list, the pointer may include information on the connection with the next or previous piece of data. A linked list may be expressed as a singly linked list, a doubly linked list, or a circularly linked list according to the form. A stack may be a data array structure in which access to data is restricted. A stack may be a linear data structure in which data can be processed (e.g., inserted or deleted) only at one end of the data structure. The data stored in a stack may be a last in, first out (LIFO) data structure. A queue is a data array structure that limits access to data and, unlike a stack, may be a first in, first out (FIFO) data structure. A deck may be a data structure that allows data to be processed at both ends of the data structure.

The nonlinear data structure may be a structure in which multiple data are linked after one piece of data. The nonlinear data structure may include a graph data structure. The graph data structure may be defined by vertices and edges, and an edge may include a line connecting two different vertices. The graph data structure may include a tree data structure. The tree data structure may 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 may be a data structure that does not form a loop.

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 a neural network training process and/or input data to be input to a neural network after training has been completed. The data to be input to the neural network may include data that has undergone pre-processing and/or data to be pre-processed. Pre-processing may include a data processing process for inputting data to the neural network. Thus, the data structure may include data to be pre-processed and data generated in pre-processing. The above-mentioned data structures are merely examples, and the present disclosure is not limited thereto.

The data structure may include weights of the neural network. (In this specification, weights and parameters may be used interchangeably.) The data structure including the weights of the neural network may be stored on a computer-readable medium. The neural network may include multiple weights. The weights may be variable and may be varied by a user or algorithm in order for the neural network to perform a desired function. For example, when one or more input nodes are interconnected to an output node by respective links, the output node may determine a data value to be output from the output node based on the values input to the input nodes connected to the output node and the weights set for the links corresponding to the respective input nodes. The above-mentioned data structures are merely examples, and the present disclosure is not limited thereto.

Although the disclosure has been described above as generally being embodied in a computing device, those skilled in the art will appreciate that the disclosure may 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.

Generally, program modules include routines, programs, components, data structures, etc. that perform particular tasks or implement particular abstract data types. Those skilled in the art will also appreciate that the methods disclosed herein can be implemented 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, and the like, each of which can operate in conjunction with one or more associated devices.

Moreover, the embodiments described in this disclosure may 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.

A computer typically 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-transient media, and 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 includes volatile and non-volatile media, transitory and non-transient 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.

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 include wired media, such as a wired network or direct-wired connection, and wireless media, such as acoustic, RF, infrared, and other wireless media. Combinations of any of the above media are also intended to be included within the scope of computer-readable transmission media.

An exemplary environment 1100 embodying various aspects of the present disclosure is shown including a computer 1102, which includes 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 may be any of a variety of commercially available processors. Dual processors and other multi-processor architectures may also be utilized as the processing unit 1104.

The system bus 1108 may be any of several types of bus structures that may 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. A basic input/output system (BIOS) is stored in non-volatile memory 1110, such as ROM, EPROM, or EEPROM, and includes basic routines that support transferring information between components within the computer 1102, such as during start-up. The RAM 1112 may also include a high-speed RAM, such as a static RAM, for caching data.

The computer 1102 also includes an internal hard disk drive (HDD) 1114 (e.g., EIDE, SATA) - which may 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 from and writing to a CD-ROM disk 1122 and other high-capacity optical media such as DVDs). The hard disk drive 1114, magnetic disk drive 1116, and optical disk drive 1120 may be coupled 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 at least one or both of USB (Universal Serial Bus) and IEEE 1394 interface technologies.

These drives and 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 media refers to HDDs, portable magnetic disks, and portable optical media such as CDs or DVDs, those skilled in the art will appreciate that other types of computer-readable media, such as zip drives, magnetic cassettes, flash memory cards, cartridges, and the like, may also be used in the exemplary operating environment, and that any such media may contain computer-executable instructions for performing the methods of the present disclosure.

A number of program modules, including an operating system 1130, one or more application programs 1132, other program modules 1134, and program data 1136, may be stored on the drive and in RAM 1112. All or portions of the operating system, applications, modules, and/or data may be cached in RAM 1112. It will be appreciated that the present disclosure may be embodied in a variety of commercially available operating systems or combinations of operating systems.

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 coupled to the processing unit 1104 through an input device interface 1142 that is coupled to the system bus 1108, but may also be coupled by a variety of interfaces, such as a parallel port, an IEEE 1394 serial port, a game port, a USB port, an IR interface, and the like.

The term user input in this disclosure may refer to any form of user input associated with a user request made within a user interface (or within a web page). For example, the user input may include a user input moving a pointer object. As another example, the user input may include a user input selecting a particular object on the user interface. For example, a user input may be made to an object (e.g., a module, a tap, etc.) by touching or clicking the object. When a user input associated with a selection is received, a new object may be displayed on the user interface or web page in response to the input, or attributes of the object may be changed and displayed.

As yet another example, user input may include information such as language, letters, numbers, and symbols entered by various input means. User input is not limited to the above examples, and various forms of user action are possible, such as mouse cursor control, mouse wheel scrolling, keyboard directional keys, mouse click, touch, etc.

A monitor 1144 or other type of display device is also coupled to the system bus 1108 via an interface, such as a video adapter 1146. In addition to the monitor 1144, a computer typically includes other peripheral output devices (not shown), such as speakers, printers, and the like. For example, the monitor 1144 or other type of display device may include at least one of a liquid crystal display (LCD), a thin film transistor-liquid crystal display (TFT LCD), an organic light-emitting diode (OLED), a flexible display, a three-dimensional display (3D display), and an e-ink display. The display unit also outputs (displays) data processed by the processor 110.

The computer 1102 can operate in a networked environment using logical connections to one or more remote computers, such as a remote computer 1148, via wired and/or wireless communications. The remote computer 1148 may be a workstation, a computing device 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 described for the computer 1102, although for simplicity, only a memory storage device 1150 is shown. The illustrated logical connections include wired or wireless connections to a local area network (LAN) 1152 and/or a larger network, 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 be coupled to a global computer network, such as the Internet.

When used in a LAN networking environment, the computer 1102 is coupled to the local network 1152 via 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 also includes a wireless access point installed to communicate with the wireless adapter 1156. When used in a WAN networking environment, the computer 1102 may include a modem 1158 or have other means for coupling to a communications computing device on the WAN 1154 or for establishing communications over the WAN 1154, such as via the Internet. The modem 1158, which may be internal or external and a wired or wireless device, is coupled to the system bus 1108 via the serial port interface 1142. In a networked environment, the program modules described for the computer 1102, or portions thereof, may be stored in a remote memory/storage device 1150. It will be appreciated that the network connections shown are exemplary and that other means of establishing a communications link between the computers may be used.

The computer 1102 operates to communicate with any wireless device or individual that is arranged and operates in wireless communication, such as printers, scanners, desktop and/or handheld computers, PDAs (portable data assistants), 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 may be of a predefined structure, such as a conventional network, or simply ad hoc communication between at least two devices.

Wi-Fi® (Wireless Fidelity) allows for connection to the Internet and the like without being wired. Wi-Fi® is a wireless technology like cell phones that allows such devices, e.g., computers, to send and receive data indoors or outdoors, i.e., anywhere within the coverage area of a base station. Wi-Fi® networks use IEEE 802.11 (a, b, g, etc.) wireless 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 11 Mbps (802.11a) or 54 Mbps (802.11b) data rates, or with products that include both bands (dual band).

Those of ordinary skill in the art of the present disclosure can appreciate that information and signals can 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 can be represented by voltages, currents, electromagnetic waves, magnetic fields or particles, optical fields or particles, or any combination thereof.

Furthermore, computer 1102 may be embodied as a user terminal. Therefore, the method according to one embodiment of the present disclosure may be applied without restriction to a terminal as hardware capable of carrying software. The user terminals described in this disclosure may include mobile phones, smart phones, laptop computers, digital broadcasting terminals, personal digital assistants (PDAs), portable multimedia players (PMPs), navigation devices, slate PCs, tablet PCs, ultrabooks, wearable devices (e.g., smartwatches, smart glass, head mounted displays (HMDs)), and the like. In addition, the user terminal may include, but is not limited to, a device that allows a user to input and output data, a device that can display data to a user, and a device that can be connected via wire or communication. For example, the computing device 100 may be a desktop, a notebook computer, a tablet PC, a portable terminal, etc.

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

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., EEPROMs, 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.

It should be understood that the particular order or hierarchy of the process stages depicted herein is an example of an exemplary approach. Based on design priorities, it should be understood that the particular order or hierarchy of the process stages may be rearranged within the scope of this disclosure. The accompanying method claims provide elements of the various stages in a sample order, but are not meant to be limited to the particular order or hierarchy depicted.

The description of the embodiments shown herein is provided to enable any person of ordinary skill in the art to which the disclosure pertains to the present disclosure to use 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.

Claims (11)

1. A method performed by a computing device, comprising:
obtaining first data including an image from a database based on a spreadsheet module;
and displaying the first data in a spreadsheet via the spreadsheet module based on the first data. The spreadsheet module includes:
The method of claim 1 , further comprising: a parameter of a style control function including at least one of cell style information, cell placement information, cell merging information, conditional formatting information, or chart output information displayed in the spreadsheet. The information about the image of the first data includes image storage path information;
displaying the first data in a spreadsheet through a parameter of a style control function based on the first data,
obtaining the image based on the image storage path information;
3. The method of claim 2, further comprising converting the image to a standard image and displaying it in a spreadsheet. The spreadsheet module includes:
Contains an image list for images with image key values,
displaying the first data in a spreadsheet through a parameter of a style control function based on the first data,
comparing the first data image with the image list;
4. The method of claim 3, further comprising: if the image of the first data corresponds to any one of the images in the image list, displaying the image of the first data on a spreadsheet based on the image list. 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;
5. The method of claim 4, further comprising the step of: including an image of said first data in said image list. The method comprises:
The method further includes generating second data by modifying the first data,
The step of generating second data by modifying the first data includes:
replacing an image of the first data to generate second data;
comparing the images of the second data with the image list;
generating a cache function based on the image list if the image of the second data corresponds to any one of the image lists;
and displaying in a spreadsheet based on said cache function. 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;
7. The method of claim 6, further comprising the step of: including an image of said second data in said image list. The step of generating second data by modifying the first data includes:
The method according to claim 6 , wherein only a predetermined area of the first data can be modified. generating syntax for updating the first data in the database with the second data based on the cache function;
and updating said database with said syntax. A computer program stored on a computer readable storage medium, the computer program, when executed by one or more processors, causing the one or more processors to perform operations for displaying data in a spreadsheet, the operations comprising:
obtaining first data from a database, the first data including an image;
and displaying the first data in a spreadsheet via a spreadsheet module based on the first data. 1. A computing device comprising:
At least one processor;
A memory,
The at least one processor further comprises:
An apparatus configured to: obtain first data, including an image, from a database; and display, based on the first data, via a spreadsheet module, the first data in a spreadsheet.