KR102266073B1 - Electronic device that controls the efficient loading of each sheet that makes up a spreadsheet document based on a multi-thread and operating method thereof - Google Patents

Abstract

Disclosed are an electronic device for controlling efficient loading of each sheet constituting a spreadsheet document based on multi-thread, and an operating method thereof. According to the electronic device and the operating method thereof of the present invention, processes of allowing, when a saving command for a spreadsheet document is received from a user, editing time information for each of n sheets (where n is a natural number that is greater than or equal to 3) generated in the document to be included in a document file and stored, selecting, when an open command for the document file is received from the user, k sheets (where k is a natural number that is greater than or equal to 2 and less than n) among the n sheets based on an editing time for each of the n sheets included in the document file and a data size for each of the n sheets until all of the n sheets are loaded, and allocating the k sheets to k loading threads, respectively, to perform parallel loading are repeatedly performed, so that the efficient loading of each sheet constituting the spreadsheet document based on the multi-thread is supported.

Description

ELECTRONIC DEVICE THAT CONTROLS THE EFFICIENT LOADING OF EACH SHEET THAT MAKES UP A SPREADSHEET DOCUMENT BASED ON A MULTI-THREAD AND OPERATING METHOD THEREOF}

The present invention relates to an electronic device for efficiently controlling the load of each sheet constituting a spreadsheet document based on a multi-thread, and an operating method thereof.

Recently, as computers, smart phones, or tablet PCs are widely used, various types of electronic document-related programs have been released that allow users to read, write, and edit electronic documents using such electronic devices.

These electronic document-related programs include a word processor supporting basic document creation and editing, a spreadsheet supporting data input, arithmetic operations, and data management, and presentation programs supporting a presenter's presentation.

In relation to this, a document created in a spreadsheet can be composed of several sheets, and each sheet is configured so that data can be entered into a space called a cell created by intersecting horizontal and vertical rows to perform various calculations. have.

In general, after a spreadsheet document composed of a plurality of sheets is stored in a memory and then opened on the spreadsheet according to a user's document open command, the plurality of sheets constituting the spreadsheet document are sequentially loaded on the screen. do.

In this case, a 'thread', which means a unit of several flows executed in a process, receives system resources from the operating system to process the load operation in order to perform the load operation of the plurality of sheets according to the user's document open command. do.

In the past, as a single thread was created for each sheet to handle the load operation, the next sheet could be loaded only after the loading of one sheet was completed. If the number of sheets is too large or the data size of a specific sheet is very large, There is a problem in that the overall loading speed of the plurality of sheets is slowed down due to inefficient allocation of resources.

If a load operation of sheets according to the document open command can be processed based on a plurality of threads allocated to each of a plurality of sheets, a plurality of threads within one process share a resource, thereby increasing the throughput of the system and processing speed can be improved, so that efficient operation of resources will be possible.

In addition, by determining the load order of the plurality of sheets based on the user's editing time or data size for each sheet constituting the spreadsheet document, user convenience may be promoted.

Therefore, it is necessary to study a technique for efficiently controlling the load for each sheet composing a spreadsheet document based on multi-threading.

An electronic device and an operating method thereof according to the present invention, when a command to save a spreadsheet document is received from a user, edit time information for each of n (n is a natural number equal to or greater than 3) generated in the document is stored in a document file After including and storing, when an open command for the document file is received from the user, the editing time for each of the n sheets included in the document file and Based on the data size for each of the n sheets, k (k is a natural number less than 2 or more) of the n sheets is selected, and one is assigned to k loading threads for parallel loading. By repeating the process, we want to support efficient loading of each sheet composing a spreadsheet document based on multi-threading.

The electronic device for efficiently controlling the loading of each sheet constituting the spreadsheet document based on the multi-thread according to an embodiment of the present invention is n (n is a natural number greater than or equal to 3) in the spreadsheet document by the user's editing command. When n sheets are generated, the editing time for each of the n sheets - the editing time for each of the n sheets means the time during which each of the n sheets is active for document editing - is measured an editing time measuring unit that generates and stores a document file including editing time information for each of the n sheets when a document saving command is received from the user after the document editing for the n sheets is completed When an open command for the document file is received from the user, after checking the editing time for each of the n sheets included in the document file, the data size for each of the n sheets is checked A check unit, for each of the n sheets, a reference vector generation unit for generating a two-dimensional reference vector using an editing time for each of the n sheets and a data size for each of the n sheets as each component , an extraction unit for extracting a first reference sheet having the maximum editing time from among the n sheets, a two-dimensional reference vector for each of the remaining n-1 sheets excluding the first reference sheet among the n sheets After calculating the Euclidean Distance between the and the two-dimensional reference vector for the first reference sheet, the Euclidean distance from the two-dimensional reference vector for the first reference sheet among the n-1 sheets is A selection unit for selecting k-1 (k is a natural number greater than or equal to 2, less than n) first sheets having a minimum two-dimensional reference vector, and a load of the first reference sheet and the k-1 first sheets After generating k first loading threads for the , assigning each of the first reference sheet and the k-1 first sheets one to the k first loading threads, the k and a load unit for executing the first loading threads to load the first reference sheet and the k-1 first sheets in parallel.

In addition, the operating method of the electronic device for efficiently controlling the loading of each sheet constituting the spreadsheet document based on the multi-thread according to an embodiment of the present invention is that n sheets in the spreadsheet document are When generated, the editing time measuring unit calculates the editing time for each of the n sheets - the editing time for each of the n sheets means the time during which each of the n sheets is active for document editing Measuring, when the document editing of the n sheets is completed and a document storage command is received from the user, a storage unit generating and storing a document file including editing time information for each of the n sheets , when an open command for the document file is received from the user, a confirmation unit checks the editing time for each of the n sheets included in the document file, and then checks the data size for each of the n sheets step, the reference vector generating unit, for each of the n sheets, generating a two-dimensional reference vector using the editing time for each of the n sheets and the data size for each of the n sheets as each component step, extracting, by an extraction unit, a first reference sheet having a maximum editing time from among the n sheets, a selection unit 2 for each of the remaining n-1 sheets excluding the first reference sheet among the n sheets After calculating the Euclidean distance between the dimensional reference vector and the two-dimensional reference vector for the first reference sheet, the Euclidean distance between the two-dimensional reference vector for the first reference sheet among the n-1 sheets is selecting k-1 first sheets having a minimum two-dimensional reference vector, and a loader generating k first loading threads for loading the first reference sheet and the k-1 first sheets, , after allocating each of the first reference sheet and the k-1 first sheets to the k first loading threads, executing the k first loading threads and loading a first reference sheet and the k-1 first sheets in parallel.

An electronic device and an operating method thereof according to the present invention, when a command to save a spreadsheet document is received from a user, edit time information for each of n (n is a natural number equal to or greater than 3) generated in the document is stored in a document file After including and storing, when an open command for the document file is received from the user, the editing time for each of the n sheets included in the document file and Based on the data size for each of the n sheets, k (k is a natural number less than 2 or more) of the n sheets is selected, and one is assigned to k loading threads for parallel loading. By repeating the process, it is possible to support efficient loading of each sheet composing a spreadsheet document based on multiple threads.

1 is a diagram illustrating a structure of an electronic device for efficiently controlling a load for each sheet constituting a spreadsheet document based on a multi-thread according to an embodiment of the present invention.
2 is a flowchart illustrating a method of operating an electronic device for efficiently controlling a load for each sheet constituting a spreadsheet document based on a multi-thread according to an embodiment of the present invention.

Hereinafter, embodiments according to the present invention will be described in detail with reference to the accompanying drawings. These descriptions are not intended to limit the present invention to specific embodiments, and should be understood to include all modifications, equivalents, and substitutes included in the spirit and scope of the present invention. While describing each drawing, like reference numerals are used for similar components, and unless otherwise defined, all terms used in this specification, including technical or scientific terms, refer to those of ordinary skill in the art to which the present invention belongs. It has the same meaning as is commonly understood by those who have it.

In this document, when a part "includes" a certain component, it means that other components may be further included, rather than excluding other components, unless otherwise stated. In addition, in various embodiments of the present invention, each of the components, functional blocks or means may be composed of one or more sub-components, and the electrical, electronic, and mechanical functions performed by each component are electronic. A circuit, an integrated circuit, an ASIC (Application Specific Integrated Circuit), etc. may be implemented with various well-known devices or mechanical elements, and may be implemented separately or two or more may be integrated into one.

On the other hand, the blocks in the accompanying block diagram or steps in the flowchart are computer program instructions that are loaded in the processor or memory of equipment capable of data processing, such as general-purpose computers, special-purpose computers, portable notebook computers, and network computers, and perform specified functions can be interpreted as meaning Since these computer program instructions may be stored in a memory provided in a computer device or in a memory readable by a computer, the functions described in the blocks of the block diagrams or the steps of the flowcharts are produced as articles of manufacture containing instruction means for performing the same. could be In addition, each block or each step may represent a module, segment, or portion of code comprising one or more executable instructions for executing the specified logical function(s). It should also be noted that, in some alternative embodiments, it is also possible for the functions recited in blocks or steps to be executed out of the prescribed order. For example, two blocks or steps shown in succession may be performed substantially simultaneously or in the reverse order, and in some cases, some blocks or steps may be omitted.

1 is a diagram illustrating a structure of an electronic device for efficiently controlling a load for each sheet constituting a spreadsheet document based on a multi-thread according to an embodiment of the present invention.

Referring to FIG. 1 , the electronic device 110 for efficiently controlling the loading of each sheet constituting a spreadsheet document based on a multi-thread according to an embodiment of the present invention includes an editing time measuring unit 111 and a storage unit. 112 , a check unit 113 , a reference vector generation unit 114 , an extraction unit 115 , a selection unit 116 , and a load unit 117 .

The editing time measuring unit 111 measures the editing time for each of the n sheets when n (n is a natural number equal to or greater than 3) sheets in the spreadsheet document by the user's editing command.

Here, the editing time for each of the n sheets means a time during which each of the n sheets is activated for document editing.

For example, assuming that n is '9', the editing time measuring unit 111 sets '9' sheets ('Sheet 1', 'Sheet 2', and 'Sheet 3') in the spreadsheet document by the user's editing command. , 'Sheet 4', 'Sheet 5', 'Sheet 6', 'Sheet 7', 'Sheet 8', 'Sheet 9'), edit time for each of the '9' sheets It can be measured as shown in Table 1.

'9' sheets Editing time (minutes) sheet 1 300 sheet 2 250 sheet 3 230 sheet 4 220 sheet 5 100 sheet 6 60 sheet 7 50 sheet 8 30 sheet 9 15

The storage unit 112 generates and stores a document file including editing time information for each of the n sheets when a document storage command is received from the user after the document editing of the n sheets is completed.

For example, according to the preceding example, when the document editing of the '9' sheets is completed and a document storage command is received from the user, the storage unit 112 may store edit time information for each of the '9' sheets. You can create and save a document file containing

When an open command for the document file is received from the user, the check unit 113 checks the editing time for each of the n sheets included in the document file, and then checks the editing time for each of the n sheets included in the document file. Check the size.

The reference vector generating unit 114 generates, for each of the n sheets, a two-dimensional reference vector using an editing time for each of the n sheets and a data size for each of the n sheets as components. do.

The extraction unit 115 extracts a first reference sheet having the maximum editing time from among the n sheets.

The selection unit 116 is configured to determine the Euclidean distance between the two-dimensional reference vector for each of the remaining n-1 sheets of the n sheets except for the first reference sheet and the two-dimensional reference vector for the first reference sheet. After calculating (Euclidean Distance), k-1 having a two-dimensional reference vector having a minimum Euclidean distance from a two-dimensional reference vector with respect to the first reference sheet among the n-1 sheets (k is n) less than 2 natural numbers) first sheets are selected.

Here, the Euclidean distance refers to a distance between two vectors and may be calculated according to Equation 1 below.

In Equation 1, D denotes a Euclidean distance, and p _i and q _i denote i-th components included in the two vectors. As the Euclidean distance between two vectors is small, the two vectors can be regarded as similar vectors, and as the Euclidean distance between two vectors increases, the two vectors can be regarded as dissimilar vectors.

That is, the smaller the Euclidean distance between the two-dimensional reference vector for each of the n-1 sheets and the two-dimensional reference vector for the first reference sheet is, the smaller the two-dimensional reference for each of the n-1 sheets. The vector may be viewed as a vector similar to a two-dimensional reference vector for the first reference sheet, a two-dimensional reference vector for each of the n-1 sheets, and a two-dimensional reference vector for the first reference sheet As the Euclidean distance between them increases, the two-dimensional reference vector for each of the n-1 sheets may be regarded as a vector dissimilar to the two-dimensional reference vector for the first reference sheet.

The rod unit 117 generates k first loading threads for loading the first reference sheet and the k-1 first sheets, and provides the k first loading threads with the first reference sheet. After allocating a sheet and each of the k-1 first sheets, the k first loading threads are executed to load the first reference sheet and the k-1 first sheets in parallel.

Here, a thread means one unit of work that independently processes instructions executed within a process.

Hereinafter, an operation of the electronic device 110 that efficiently controls the load of each sheet constituting the spreadsheet document based on the multi-thread will be described in detail with an example.

According to the above-described example, when an open command for the document file is received from the user, the confirmation unit 113 is configured to, as recorded in Table 1, the '9' sheets included in the document file. After checking the editing time for each of the '9' sheets, the data size for each of the '9' sheets can be confirmed as shown in Table 2 below.

'9' sheets Data size (kB) sheet 1 150 sheet 2 200 sheet 3 100 sheet 4 150 sheet 5 60 sheet 6 50 sheet 7 100 sheet 8 25 sheet 9 25

Thereafter, for each of the '9' sheets, the reference vector generator 114 converts the editing time for each of the '9' sheets and the data size for each of the '9' sheets into each component. A two-dimensional reference vector can be generated as shown in Table 3 below.

'9' sheets two-dimensional reference vector sheet 1 [300 150] sheet 2 [250 200] sheet 3 [230 100] sheet 4 [220 150] sheet 5 [100 60] sheet 6 [60 50] sheet 7 [50 100] sheet 8 [30 25] sheet 9 [15 25]

The extraction unit 115 may extract 'sheet 1' having an editing time of '300 (minutes)' as a first reference sheet having the maximum editing time among the '9' sheets.

In this way, when 'sheet 1' is extracted as the first reference sheet, the selection unit 116 selects the remaining '8' sheets ('sheet 2', ', excluding 'sheet 1' among the '9' sheets). 2 for 'sheet 1' and a two-dimensional reference vector for each of 'sheet 3', 'sheet 4', 'sheet 5', 'sheet 6', 'sheet 7', 'sheet 8', 'sheet 9') The Euclidean distance between '[300 150]', which is a dimensional reference vector, can be calculated according to Equation 1, as shown in Table 4 below.

And, when it is assumed that k is '3', the selector 116 determines that the Euclidean distance from '[300 150]', which is a two-dimensional reference vector for 'sheet 1' among the '8' sheets, is the minimum. 'Sheet 2' and 'Sheet 4' may be selected as '2' first sheets having a two-dimensional reference vector.

In this way, when 'sheet 2' and 'sheet 4' are selected as the '2' first sheets, the rod unit 117 is configured to load 'sheet 1', 'sheet 2' and 'sheet 4'. 3' first loading threads can be created, and after each of 'sheet 1', 'sheet 2' and 'sheet 4' is allocated to the '3' first loading threads, the '3' 'Sheet 1', 'Sheet 2' and 'Sheet 4' may be loaded in parallel by executing the first loading threads.

At this time, according to an embodiment of the present invention, the extraction unit 115 is the first reference sheet and the first reference sheet in the n sheets when all of the first reference sheet and the k-1 first sheets are loaded. A second reference sheet having a maximum editing time may be extracted from among the remaining nk sheets other than the k-1 first sheets.

In addition, according to an embodiment of the present invention, the selection unit 116 includes a two-dimensional reference vector and the second reference for each of the remaining nk-1 sheets excluding the second reference sheet among the nk sheets. After calculating the Euclidean distance between the two-dimensional reference vectors for the sheets, the two-dimensional reference vector having the minimum Euclidean distance from the two-dimensional reference vector for the second reference sheet among the nk-1 sheets has k-1 second sheets may be selected.

In addition, according to an embodiment of the present invention, the rod part 117 generates k second loading threads for loading the second reference sheet and the k-1 second sheets, and the k second loading threads. After allocating the second reference sheet and the k-1 second sheets one by one to loading threads, the k second loading threads are executed to obtain the second reference sheet and the k-1 second sheets. can be loaded in parallel.

In this case, when nk-1 is 0, the selection unit 116 may not select the k-1 second sheets, and the rod unit 117 uses a second loading thread for loading the second reference sheet. , and after allocating the second reference sheet to the second loading thread, only the second reference sheet may be loaded by executing the second loading thread.

Also, when nk-1 is smaller than k-1, the selection unit 116 may select nk-1 second sheets, and the rod unit 117 may select the second reference sheet and the nk-1 second sheets. After generating nk second loading threads for loading sheets, and allocating each of the second reference sheet and the nk-1 second sheets to the nk second loading threads, the nk second loading threads By executing 2 loading threads, the second reference sheet and the nk-1 second sheets may be loaded in parallel.

In relation to this, according to the above-described example, when all of 'sheet 1', 'sheet 2', and 'sheet 4' are loaded, the extraction unit 115 performs 'sheet 1', ' from the '9' sheets. Edit among the remaining '6' sheets ('Sheet 3', 'Sheet 5', 'Sheet 6', 'Sheet 7', 'Sheet 8', and 'Sheet 9') except for 'Sheet 2' and 'Sheet 4' As the second reference sheet having the maximum time, 'Sheet 3' having an editing time of '230 (minutes)' may be extracted.

The selection unit 116 selects the remaining '5' sheets ('Sheet 5', 'Sheet 6', 'Sheet 7', 'Sheet 8', and 'Sheet' excluding 'Sheet 3' among the '6' sheets). 9') According to Equation 1, the Euclidean distance between the two-dimensional reference vector for each and the two-dimensional reference vector '[230 100]' for 'Sheet 3' can be calculated as shown in Table 5 below. have.

In addition, the selection unit 116 selects '2' having a two-dimensional reference vector having a minimum Euclidean distance from '[230 100]', which is a two-dimensional reference vector for 'sheet 3' among the '5' sheets. 'Sheet 5' and 'Sheet 6' may be selected as the 'second sheets'.

In this way, when 'sheet 5' and 'sheet 6' are selected as the '2' second sheets, the rod unit 117 is configured to load 'sheet 3', 'sheet 5' and 'sheet 6'. 3' second loading threads may be created, and after allocating one 'sheet 3', 'sheet 5' and 'sheet 6' to the '3' second loading threads, the '3' 'Sheet 3', 'Sheet 5' and 'Sheet 6' may be loaded in parallel by executing the second loading threads.

At this time, according to an embodiment of the present invention, the electronic device 110 for efficiently controlling the loading of each sheet constituting the spreadsheet document based on the multi-thread is configured to complete the loading of all the n sheets. It may further include a repeat execution control unit 118 .

The iteration control unit 118 repeatedly performs the operations of the extraction unit 115 , the selection unit 116 , and the loading unit 117 until all of the n sheets are loaded.

In this regard, as in the previous example, as an open command for the document file composed of the '9' sheets is received from the user, the '3' first loading threads are executed by the load unit 117 . 'Sheet 1', 'Sheet 2' and 'Sheet 4' are loaded in parallel, and the '3' second loading threads are executed to parallel load 'Sheet 3', 'Sheet 5' and 'Sheet 6' In this case, the iteration control unit 118 controls the extraction unit 115 until all loading of the 'sheet 7', 'sheet 8' and 'sheet 9' that have not yet been loaded among the '9' sheets is completed. The operations of the selection unit 116 and the load unit 117 may be repeatedly performed.

That is, when the loading of 'sheet 3', 'sheet 5' and 'sheet 6' is completed, the extraction unit 115 selects 'sheet 3', 'sheet 5' and 'sheet 6' from the '6' sheets. Among the remaining '3' sheets ('Sheet 7', 'Sheet 8', and 'Sheet 9'), the third reference sheet with the maximum editing time, 'Sheet 7' with an editing time of '50 (minutes)' can be extracted.

And, the selection unit 116 is a two-dimensional reference vector for each of the remaining '2' sheets ('sheet 8', 'sheet 9') except for 'sheet 7' among the '3' sheets and ' After calculating the Euclidean distance between '[50 100]', which is a two-dimensional reference vector for sheet 7', the Euclidean distance from '[50 100]', a two-dimensional reference vector for 'sheet 7', is the minimum. '2' third sheets having a two-dimensional reference vector may be selected.

At this time, the selection unit 116 selects the '2' third sheets because only 'Sheet 8' and 'Sheet 9' exist as the remaining unloaded sheets other than the 'Sheet 7', which is the third reference sheet. You can choose between 'Sheet 8' and 'Sheet 9'.

In this way, when 'sheet 8' and 'sheet 9' are selected as the '2' third sheets, the rod unit 117 is configured to load 'sheet 7', 'sheet 8' and 'sheet 9'. 3' third loading threads may be created, and after allocating one 'sheet 7', 'sheet 8' and 'sheet 9' to the '3' third loading threads, the '3' 'Sheet 7', 'Sheet 8' and 'Sheet 9' may be loaded in parallel by executing third loading threads.

Also, according to an embodiment of the present invention, the loading unit 117 may activate the last loaded sheet and temporarily display it on the screen whenever loading of each of the n sheets is completed.

For example, according to the preceding example, loading of 'Sheet 1', 'Sheet 2', and 'Sheet 4' among the '9' sheets is completed in the order of 'Sheet 1', 'Sheet 2', and 'Sheet 4'. In this case, the loading unit 117 may activate 'sheet 4', which is the last loaded sheet, and temporarily display it on the screen.

And, after loading of 'Sheet 1', 'Sheet 2', and 'Sheet 4' is completed, the loading of 'Sheet 3', 'Sheet 5', and 'Sheet 6' is changed to 'Sheet 5', 'Sheet 6', ' When the order of sheet 3' is completed, the loading unit 117 may activate 'sheet 3', which is the last loaded sheet, and temporarily display it on the screen. If 'Sheet 3' is before being loaded, the loading unit 117 may activate 'Sheet 6', which is the last loaded sheet, to be temporarily displayed on the screen.

Also, according to an embodiment of the present invention, when all of the n sheets are loaded, the load unit 117 may activate the first reference sheet among the n sheets to finally display it on the screen.

That is, when the loading of all of the n sheets is completed, the loading unit 117 displays the first reference sheet having the maximum editing time among the n sheets on the screen, so that the user is likely to read it. By displaying the highest sheet on the screen, the user's convenience can be achieved.

2 is a flowchart illustrating an operation method of an electronic device for efficiently controlling a load for each sheet constituting a spreadsheet document based on a multi-thread according to an embodiment of the present invention.

In step S210, when n sheets are generated in the spreadsheet document by the user's editing command, the editing time measuring unit edits the editing time for each of the n sheets (the editing time for each of the n sheets is the Measure the time each of n sheets is active for document editing).

In step S220, when the document editing of the n sheets is completed and a document storage command is received from the user, the storage unit generates and stores a document file including editing time information for each of the n sheets. .

In step S230, when an open command for the document file is received from the user, a confirmation unit checks the editing time for each of the n sheets included in the document file, and then Check the data size.

In step S240, for each of the n sheets, the reference vector generating unit generates a two-dimensional reference vector using the editing time for each of the n sheets and the data size for each of the n sheets as components. create

In step S250, the extraction unit extracts the first reference sheet having the maximum editing time from among the n sheets.

In step S260, the selection unit Euclidean between the two-dimensional reference vector for each of the remaining n-1 sheets of the n sheets except the first reference sheet and the two-dimensional reference vector for the first reference sheet After calculating the distance, k-1 first sheets having a two-dimensional reference vector having a minimum Euclidean distance from a two-dimensional reference vector with respect to the first reference sheet are selected from among the n-1 sheets. .

In step S270, a load unit generates k first loading threads for loading the first reference sheet and the k-1 first sheets, and includes the first reference sheet and the k first loading threads in the k first loading threads. After allocating each of the k-1 first sheets one by one, the k first loading threads are executed to load the first reference sheet and the k-1 first sheets in parallel.

At this time, according to an embodiment of the present invention, in the method of operating the electronic device, when all of the first reference sheet and the k-1 first sheets are loaded, the extraction unit selects the first reference sheet from the n sheets. extracting a second reference sheet having a maximum editing time from among the remaining nk sheets other than the reference sheet and the k-1 first sheets, wherein the selection unit selects the remainder of the nk sheets except for the second reference sheet After calculating the Euclidean distance between the two-dimensional reference vector for each of the nk-1 sheets and the two-dimensional reference vector for the second reference sheet, for the second reference sheet among the nk-1 sheets selecting k-1 second sheets having a two-dimensional reference vector having a minimum Euclidean distance from the two-dimensional reference vector, and the loading unit loads the second reference sheet and the k-1 second sheets After generating k second loading threads for , and allocating each of the second reference sheet and the k-1 second sheets to the k second loading threads, the k second loading threads It may further include the step of parallel loading the second reference sheet and the k-1 number of second sheets by executing .

At this time, according to an embodiment of the present invention, in the method of operating the electronic device, the iteration control unit repeatedly performs the operations of the extraction unit, the selection unit, and the loading unit until all the n sheets are loaded. It may include further steps.

In addition, according to an embodiment of the present invention, in the method of operating the electronic device, whenever the loading of each of the n sheets is completed, the loading unit activates the last loaded sheet and temporarily displays it on the screen It may further include the step of

In addition, according to an embodiment of the present invention, in the method of operating the electronic device, when all the n sheets are loaded, the loading unit activates the first reference sheet among the n sheets to be finally displayed on the screen It may further include the step of

In the above, an operating method of an electronic device for efficiently controlling a load for each sheet constituting a spreadsheet document based on a multi-thread according to an embodiment of the present invention has been described with reference to FIG. 2 . Here, the operating method of the electronic device for efficiently controlling the loading of each sheet constituting the spreadsheet document based on the multi-thread according to an embodiment of the present invention is a spreadsheet document based on the multi-thread described with reference to FIG. 1 . Since it may correspond to the configuration of the operation of the electronic device 110 for efficiently controlling the load on each sheet constituting the , a more detailed description thereof will be omitted.

An operating method of an electronic device for efficiently controlling the load of each sheet constituting a spreadsheet document based on a multi-thread according to an embodiment of the present invention is a computer program stored in a storage medium for execution through combination with a computer. can be implemented.

In addition, the operating method of the electronic device for efficiently controlling the load for each sheet constituting the spreadsheet document based on the multi-thread according to an embodiment of the present invention is in the form of a computer program command for execution through combination with a computer. It may be implemented and recorded in a computer-readable medium. The computer-readable medium may include program instructions, data files, data structures, etc. alone or in combination. The program instructions recorded on the medium may be specially designed and configured for the present invention, or may be known and available to those skilled in the art of computer software. Examples of the computer-readable recording medium include magnetic media such as hard disks, floppy disks and magnetic tapes, optical media such as CD-ROMs and DVDs, and magnetic such as floppy disks. - includes magneto-optical media, and hardware devices specially configured to store and execute program instructions, such as ROM, RAM, flash memory, and the like. Examples of program instructions include not only machine language codes such as those generated by a compiler, but also high-level language codes that can be executed by a computer using an interpreter or the like.

As described above, the present invention has been described with specific matters such as specific components and limited embodiments and drawings, but these are provided to help a more general understanding of the present invention, and the present invention is not limited to the above embodiments. , various modifications and variations are possible from these descriptions by those of ordinary skill in the art to which the present invention pertains.

Therefore, the spirit of the present invention should not be limited to the described embodiments, and not only the claims to be described later, but also all those with equivalent or equivalent modifications to the claims will be said to belong to the scope of the spirit of the present invention. .

110: Electronic device for controlling efficient loading of each sheet composing a spreadsheet document on a multi-threaded basis
111: editing time measurement unit 112: storage unit
113: check unit 114: reference vector generation unit
115: extraction unit 116: selection unit
117: load unit 118: repeat execution control unit

Claims (12)

When n (n is a natural number of 3 or more) sheets are generated in the spreadsheet document by the user's editing command, the editing time for each of the n sheets - The editing time for each of the n sheets is the n an editing time measuring unit that measures the time during which each of the sheets is active for document editing;
a storage unit for generating and storing a document file including editing time information for each of the n sheets when a document storage command is received from the user after the document editing of the n sheets is completed;
When an open command for the document file is received from the user, after checking the editing time for each of the n sheets included in the document file, a confirmation unit for checking the data size of each of the n sheets ;
a reference vector generator for generating, for each of the n sheets, a two-dimensional reference vector using an editing time for each of the n sheets and a data size for each of the n sheets as components;
an extraction unit for extracting a first reference sheet having a maximum editing time from among the n sheets;
Calculate the Euclidean distance between the two-dimensional reference vector for each of the remaining n-1 sheets of the n sheets except the first reference sheet and the two-dimensional reference vector for the first reference sheet Then, k-1 having a two-dimensional reference vector having a minimum Euclidean distance from a two-dimensional reference vector with respect to the first reference sheet among the n-1 sheets (k is a natural number of 2 or more less than n) ) a selection unit for selecting the first sheets; and
creating k first loading threads for loading the first reference sheet and the k-1 first sheets, and providing the k first loading threads with the first reference sheet and the k-1 After allocating each of the number of first sheets one by one, the load unit executes the k first loading threads to load the first reference sheet and the k-1 first sheets in parallel.
An electronic device that controls the efficient loading of each sheet composing a spreadsheet document based on a multi-thread containing According to claim 1,
The extraction unit
When the first reference sheet and the k-1 number of first sheets are all loaded, the editing time among the remaining nk sheets excluding the first reference sheet and the k-1 number of first sheets in the n sheets Extracting a second reference sheet that is this maximum,
the selection unit
After calculating the Euclidean distance between the two-dimensional reference vector for each of the remaining nk-1 sheets excluding the second reference sheet among the nk sheets and the two-dimensional reference vector for the second reference sheet, the selecting k-1 second sheets having a two-dimensional reference vector having a minimum Euclidean distance from a two-dimensional reference vector with respect to the second reference sheet from among nk-1 sheets,
the rod part
generating k second loading threads for loading the second reference sheet and the k-1 second sheets, and providing the k second loading threads with the second reference sheet and the k-1 second sheets. After allocating each sheet one by one, each sheet composing a spreadsheet document based on a multi-thread that executes the k second loading threads to load the second reference sheet and the k-1 second sheets in parallel Electronic devices that control the load efficiently. 3. The method of claim 2,
A repetition control unit for repeatedly performing the operations of the extraction unit, the selection unit, and the loading unit until the loading of the n sheets is completed.
Electronic device for controlling efficient loading for each sheet composing a spreadsheet document on a multi-threaded basis further comprising: According to claim 1,
the rod part
Whenever the loading of each of the n sheets is completed, the efficient loading of each sheet composing the spreadsheet document is controlled based on a multi-thread that activates the last loaded sheet and temporarily displays it on the screen. electronic device. 5. The method of claim 4,
the rod part
When all the n sheets are loaded, the first reference sheet among the n sheets is activated to control the efficient loading of each sheet constituting the spreadsheet document based on a multi-thread that is finally displayed on the screen electronic device. When n (n is a natural number greater than or equal to 3) sheets are generated in the spreadsheet document by the user's editing command, the editing time measuring unit edits time for each of the n sheets - Editing for each of the n sheets measuring time - which means the time during which each of the n sheets is active for document editing;
generating and storing, by a storage unit, a document file including editing time information for each of the n sheets, when a document saving command is received from the user after the document editing of the n sheets is completed;
When an open command for the document file is received from the user, a confirmation unit checks the editing time for each of the n sheets included in the document file, and then checks the data size for each of the n sheets step;
generating, by a reference vector generator, for each of the n sheets, a two-dimensional reference vector using an editing time for each of the n sheets and a data size for each of the n sheets as components;
extracting, by an extracting unit, a first reference sheet having a maximum editing time from among the n sheets;
Euclidean distance between the two-dimensional reference vector for each of the remaining n-1 sheets except for the first reference sheet among the n sheets and the two-dimensional reference vector for the first reference sheet by the selection unit After calculating , k-1 having a two-dimensional reference vector having a minimum Euclidean distance from a two-dimensional reference vector with respect to the first reference sheet among the n-1 sheets (k is two or more smaller than n) a natural number) of first sheets; and
A load unit generates k first loading threads for loading the first reference sheet and the k-1 first sheets, and provides the k first loading threads with the first reference sheet and the k - after allocating each of the -1 first sheets one by one, executing the k first loading threads to load the first reference sheet and the k-1 first sheets in parallel
A method of operation of an electronic device for controlling the efficient loading of each sheet composing a spreadsheet document based on a multi-thread comprising a. 7. The method of claim 6,
When the first reference sheet and the k-1 number of first sheets are all loaded, the extractor selects the remaining nk sheets from the n sheets except for the first reference sheet and the k-1 number of first sheets. extracting a second reference sheet having a maximum editing time among them;
The selection unit calculates the Euclidean distance between the two-dimensional reference vector for each of the remaining nk-1 sheets excluding the second reference sheet among the nk sheets and the two-dimensional reference vector for the second reference sheet. thereafter, selecting k-1 second sheets having a two-dimensional reference vector having a minimum Euclidean distance from a two-dimensional reference vector with respect to the second reference sheet from among the nk-1 sheets; and
The rod part generates k second loading threads for loading the second reference sheet and the k-1 second sheets, and the k second loading threads are connected to the second reference sheet and the k-1 number of the second reference sheet. After allocating each of the 2 second sheets one by one, executing the k second loading threads to load the second reference sheet and the k-1 second sheets in parallel
A method of operating an electronic device for controlling an efficient load for each sheet composing a spreadsheet document based on a multi-thread further comprising a. 8. The method of claim 7,
repeating the operation of the extracting unit, the selecting unit, and the loading unit until the iteration control unit completes the loading of the n sheets.
A method of operating an electronic device for controlling an efficient load for each sheet composing a spreadsheet document based on a multi-thread further comprising a. 9. The method of claim 8,
Whenever the loading of each of the n sheets is completed by the loading unit, activating the last loaded sheet and temporarily displaying it on the screen
A method of operating an electronic device for controlling an efficient load for each sheet composing a spreadsheet document based on a multi-thread further comprising a. 10. The method of claim 9,
When all of the n sheets are loaded, the loading unit activates the first reference sheet among the n sheets to finally display the first reference sheet on the screen
A method of operating an electronic device for controlling an efficient load for each sheet composing a spreadsheet document based on a multi-thread further comprising a. A computer-readable recording medium recording a computer program for executing the method of any one of claims 6 to 10 through combination with a computer. A computer program stored in a storage medium for executing the method of any one of claims 6 to 10 through combination with a computer.

Images