KR20070097660A - Method for managing multimedia files though using the structured query language in a mobile communication terminal - Google Patents

Abstract

A method for managing a multimedia file using an SQL(Structured Query Language) in a mobile terminal is provided to resolve user inconvenience in searching and managing various multimedia files by managing info files of the multimedia files as data in the format of an SQL including a unique ID in double words. When A terminal user inputs a user command for displaying a list of multimedia files stored in a memory of a mobile terminal(S21), an SQL application program allocates a portion of the memory as a data buffer(S22), accesses a DB(Database), reads a unique ID of each info file, and stores the read unique IDs in the data buffer(S23). The SQL application program unique IDs corresponding to the number of files that can be displayed as the file list one time among unique IDs stored in the data buffer(S24). The SQL application program searches the database to extract info data included in an info file corresponding to each unique ID, makes a multimedia file list and displays it on a screen of the terminal(S25). When a user command related to multimedia file management is inputted(S26), the SQL application program checks whether the user command is a request for displaying the multimedia file list or a request for deleting a particular multimedia file(S27). When the user command is a request for deleting a particular multimedia file, the SQL application program extracts a unique ID of a multimedia file requested to be deleted by the user(S28) and deletes an info file corresponding to the unique ID from the database(S29). The SQL application program deletes the multimedia file corresponding to the deleted info file(S30).

Description

METHOD FOR MANAGING MULTIMEDIA FILES THOUGH USING THE STRUCTURED QUERY LANGUAGE IN A MOBILE COMMUNICATION TERMINAL}

1 is a flow chart illustrating a series of operations for managing an info file using SQL in storing a multimedia file in an internal memory in a mobile communication terminal according to the present invention.

2 is a flowchart illustrating a series of multimedia file management operations such as file list display and file deletion of a multimedia file using SQL in a mobile communication terminal according to the present invention.

The present invention relates to a method for managing a multimedia file of a mobile communication terminal. In particular, an Info File of a multimedia file such as a sound source, an image, a video, etc. in a mobile communication terminal includes a unique query. By managing the data in the form of a sentence, it is possible to reduce the memory load in managing a large number of multimedia files and to solve the inconvenience of storing, retrieving and managing the files. The present invention relates to a multimedia file management method.

The conventional method of managing a multimedia information file stored in a mobile communication terminal is a method of storing basic information of each multimedia as a structure-type file and storing the same in a memory. The number of multimedia information files that can be stored is also limited. In addition, it is impossible to sort the multimedia information file stored in the memory by a name, a date, etc., which makes it difficult to efficiently manage the multimedia information file.

SQL (Structured Query Language) is a database sublanguage used for the operation and management of relational databases. It is mainly used on a PC or a server, and most of the information on the PC or server does not have a memory limit. (Name, full path information, etc.) has the advantage of being able to retrieve and use without limitation, but does not apply to the management of media information files, text messages, phonebook information, etc. of the mobile communication terminal.

Accordingly, the present invention has been proposed to solve the above-mentioned conventional problems, and in the mobile communication terminal, an info file for various multimedia files such as a sound source, an image, a video, etc., is a double word type unique ID. By managing the data in SQL (Structured Query Language) statement format that includes a, it is possible to reduce the memory load while managing a large number of multimedia files, and to eliminate the inconvenience of storing the multimedia files, searching and managing the files. The purpose is to provide a multimedia file management method using SQL.

The present invention for achieving the above object, in the management of the Info file (Info File) for the various multimedia files stored in the internal memory in the mobile communication terminal, SQL (for each multimedia file stored in the internal memory of the terminal) Generating information data in the form of Structured Query Language) and a unique ID for identifying the information data; Storing and managing an info file including the generated info data and a unique ID in a database; A mobile communication including managing an info file stored in the database in a SQL application according to a SQL command for managing a multimedia file of a terminal user and managing a multimedia file stored in the internal memory of the terminal in association with a file management system; A multimedia file management method using Escule in a terminal is featured.

Hereinafter, an embodiment according to the present invention will be described in detail with reference to the accompanying drawings.

In the present invention, in order to store and manage various multimedia files such as sound source, image, video, etc. used in the mobile communication terminal in the internal memory of the terminal, the information file (Info File) for each multimedia file, a unique double-word (dword) type By managing data in SQL (Structured Query Language) statement format including unique ID, it reduces the load on memory and manages the inconvenience of storing, searching and managing multimedia files. It will be resolved.

To this end, in the mobile communication terminal according to the present invention, in managing an info file for various multimedia files, a new multimedia file is stored in the internal memory of the terminal, an existing multimedia file is deleted, or a multimedia file list is displayed. In this case, the multimedia file is stored, deleted, or the file list is displayed by using a unique ID for identifying the info file for the corresponding multimedia file.

Here, the mobile communication terminal includes personal digital assistants (PDAs), DMB phones, other portable communication terminals, and the like, in addition to the usual mobile communication terminals.

In addition, in the present invention, the mobile communication terminal is a file management system for managing the internal memory in which various multimedia files such as sound source, image, video, etc. are stored, and storing the multimedia file in the internal memory, or deleting the stored multimedia file. And a database storing information data providing basic information on multimedia files stored in the internal memory, and user commands related to multimedia file management while managing and operating the database as data in SQL (Structured Query Language) statement format. In addition, the system further includes a SQL application processing a SQL command, which is a user command related to multimedia file management, and deletes or file leases of various multimedia files stored in internal memory by interworking with the SQL application and the file management system. The display and the like can be easily operated and managed.

At this time, the information data stored in the database, the basic information data included in the existing Info File (access path, storage date, size, etc. related to the multimedia file stored in the internal memory), and double to identify the basic information data It includes a unique ID in the form of a word (4 bytes). In addition, the information data stored in the database is managed through SQL commands such as search, add, delete, and read the total number by the SQL application. In particular, in the present invention, by limiting the types of statements to execute only the minimum functions necessary for the management of various multimedia files stored in the internal memory, the memory of the mobile communication terminal due to the 'read / write' of each multimedia file, including the info file Relieve the load. In addition, in order to solve the speed problem when registering (saving) a new multimedia file in the mobile terminal, the information data stored in the database so that the existing information can be maintained even if the mobile terminal is rebooted (booting) Data in SQL statement format is managed in file format.

The unique ID is a double word type field having a size of 4 bytes that can be recognized by the mobile communication terminal. The unique ID is used to identify each info data, that is, an info file, and executes an SQL command for multimedia file management. It plays a role of enabling access to the info data stored in the database (that is, the info data for the multimedia file managed by the SQL command) through the unique ID.

In addition, when a new multimedia file is to be stored in the internal memory of the mobile communication terminal, an information file including basic info data for the multimedia file is generated, stored in a database, and managed. Extract the bits corresponding to the creation date of the basic info data for the double word form to generate a unique ID, if the same date information file exists, that is, if the same unique ID exists, The info file existing in the file has a doubleword value according to the creation date as a unique ID, and the info file for the multimedia file to be newly stored has a specific value (for example, ' 1 ') is increased to create a unique ID. In addition, the unique ID may be generated using a mobile identification number (MIN), a serial number (ESN), or the like of the mobile communication terminal, in addition to the date of generating the information file.

Meanwhile, the mobile communication terminal according to the present invention provides a user interface (UI) related to multimedia file management to a terminal user by operating a file management system so that the terminal user can manage various multimedia files stored in the internal memory. The user's management commands such as saving, deleting, and displaying the list of multimedia files through the user interface are executed through the SQL application program.

In this case, an area in which information data providing basic information on various multimedia files stored in the internal memory of the terminal is stored is called a database, and user commands related to multimedia file management (save, delete, list display, etc.) are managed and operated. If an application that accesses a file management system by processing an SQL command (that is, a user management command) is an SQL application, the SQL application may store information data stored in a database according to user commands related to multimedia file management. It also manages the multimedia file stored in the internal memory of the terminal in conjunction with the file management system.

1 is a flowchart illustrating a series of operations for managing an info file using SQL in storing a multimedia file in an internal memory in a mobile communication terminal according to the present invention.

First, in the present invention, the mobile communication terminal should be provided with an internal memory for storing various multimedia files and a database for managing an info file for each multimedia file stored in the internal memory. In addition, the info file for various multimedia files stored in the internal memory of the mobile communication terminal should be stored in a database managed by a SQL application program.

In this state, when a terminal user (or a developer or an AS center employee, etc.) commands storage of a new multimedia file through a user interface (step S11), the file management system stores the new multimedia file in the terminal internal memory (step S11). Step S12).

After storing the new multimedia file in the terminal internal memory, the SQL application generates basic information data in the form of SQL statement including the access path, storage date, size, etc. related to the multimedia file stored in the internal memory (step) S13) After generating the basic information data in this way, a bit corresponding to the creation date of the information data is extracted in a doubleword form to generate a unique ID for identifying the basic information data generated earlier (step S14).

Thereafter, the SQL application checks whether or not the unique ID created above is a duplicate. For this purpose, the unique ID stored in the database is searched to determine whether a unique ID identical to the generated unique ID exists (step S15). ).

In this case, when it is determined that the same unique ID as the generated unique ID exists, the SQL application increases the specific value (for example, '1') to the unique ID generated earlier, that is, the multimedia file stored in the internal memory. The unique ID is regenerated by increasing a specific value to the doubleword value according to the creation date of the basic info data (step S16) .After generating the unique ID, the database is checked in the database to check whether the unique ID is duplicated. The operation of step S15 is repeated to check whether the unique ID that is identical to the generated unique ID exists by searching the stored unique ID. As a result, the SQL application program manages the unique IDs for identifying the info files for each multimedia file so that they do not overlap each other.

When the database is searched in step S15, and it is determined that there is no unique ID that is identical to the currently generated unique ID, the SQL application generates an information file including the basic information data and the unique ID generated earlier, that is, inside the terminal. An info file including the info data for the multimedia file newly stored in the memory and a unique ID for identifying the info data is stored in the database (step S17). Thus, a new multimedia file is stored in the internal memory of the mobile communication terminal, and a series of operations for storing and managing the info file for the multimedia file in a database is completed.

On the other hand, as described above, in the state that the info file for various multimedia files stored in the internal memory of the mobile communication terminal is stored and managed in a database by a SQL application program, the file list display and file deletion of the multimedia file using SQL and The same set of multimedia file management operations will be described in detail with reference to FIG. 2 as follows.

First, in performing a multimedia file management operation, in order for a terminal user to delete a multimedia file, a multimedia file list must be displayed on the screen of the terminal first, and a specific multimedia file is selected while the multimedia file list is displayed on the screen of the terminal. You can delete it.

Accordingly, when the terminal user (or a developer or an AS center employee, etc.) inputs a series of user commands for displaying a file list of the multimedia file stored in the internal memory of the mobile communication terminal through the user interface (step S21), The SQL application program analyzes the input user command and recognizes it as a user command for displaying a list of multimedia files.

When the SQL application recognizes a user command for displaying a list of multimedia files, it allocates a portion of memory to a data buffer (step S22), accesses a database, and sequentially reads a unique ID included in each info file. It will be stored in the previously allocated data buffer. That is, the SQL application program accesses the database, reads unique IDs included in the info file corresponding to each multimedia file stored in the terminal internal memory in order of name or creation date, and stores them in the data buffer (step S23). .

In this way, after reading all unique IDs included in each info file stored in the database and storing them in the data buffer, the SQL application checks the number of files that can be displayed as a file list at one time through the terminal screen, From among the unique IDs stored in the buffer, unique IDs corresponding to the number of files that can be displayed in the file list at one time are selected (step S24).

Subsequently, the database is searched by using a predetermined number of unique IDs selected above to extract information data included in the info file corresponding to each unique ID. Using the extracted information data, a list of multimedia files to be displayed on the terminal screen is extracted. The configuration is displayed on the terminal screen (step S25).

In addition, while a series of multimedia file lists are displayed on the terminal screen, the SQL application checks whether a user command related to multimedia file management is input from the terminal user. Step S26), the user command is analyzed to determine whether it is a user command for requesting the display of the next multimedia file list or a user command for deleting a specific multimedia file (step S27).

If it is confirmed that the user command input from the terminal user is a user command requesting the display of the next multimedia file list, the number of files that can be displayed as a file list at one time among the unique IDs stored in the data buffer is determined. After selecting the corresponding unique IDs, using the selected unique IDs to extract the information data contained in the corresponding info file from the database, a series of operations to configure the next multimedia file list to be displayed on the terminal screen to display on the terminal screen Will be repeated. As a result, the terminal user can sequentially check the multimedia file list stored in the terminal internal memory through the terminal screen based on the info file management using SQL.

However, if the user command input from the terminal user is confirmed to be a user command requesting the deletion of a specific multimedia file currently displayed on the terminal screen, that is, the terminal user selects a specific multimedia file from among the multimedia files displayed on the terminal screen. When requesting the deletion of the multimedia file, the SQL application extracts the unique ID of the multimedia file requested to be deleted by the terminal user (step S28), and then searches the database using the extracted unique ID to search for the corresponding information. The file (i.e., the info file for the multimedia file requested to be deleted by the terminal user) is deleted from the database (step S29).

In addition, the SQL application deletes the info file of the multimedia file requested to be deleted by the terminal user from the database and delivers the information about the deleted info file to the file management system, thereby storing the information file in the terminal internal memory through the file management system. The specified multimedia file, that is, the multimedia file corresponding to the info file deleted from the database, is deleted (step S30). Accordingly, the terminal user can delete a specific multimedia file from the terminal internal memory based on the info file management using SQL.

On the other hand, the embodiment according to the present invention is not limited to the above, it can be carried out by various alternatives, modifications and changes within the scope apparent to those skilled in the art with respect to the present invention, for example In the above-described embodiment, various multimedia files stored in the internal memory of the mobile communication terminal have been managed using an info file including data in SQL statement format. However, in addition to the multimedia files, phonebook data and text messages are managed. (Short Message Service, SMS), and other data can also be managed based on the info file management using SQL according to the present invention.

As described above, the present invention provides an Info File for various multimedia files such as a sound source, an image, a video, and the like in a mobile communication terminal, including a unique ID in a doubleword form. By managing the data in a sentence format, it is possible to reduce the memory load in managing a large number of multimedia files, and also to reduce the inconvenience of storing the multimedia files, searching for files, and managing the multimedia files. .

Claims (5)

In managing the info file (Info File) for various multimedia files stored in the internal memory in the mobile communication terminal, Generating information data in SQL (Structured Query Language) statement format for each multimedia file stored in the terminal internal memory and a unique ID for identifying the information data; Storing and managing an info file including the generated info data and a unique ID in a database; And managing an info file stored in the database in a SQL application according to a SQL command for managing a multimedia file of a terminal user, and simultaneously managing a multimedia file stored in the internal memory of the terminal by interworking with a file management system. Multimedia file management method using Escule in a mobile communication terminal. The method of claim 1, The unique ID is generated by extracting a bit corresponding to the date of generation of the information data for each multimedia file in the form of a double word (dword), or using a mobile identification number (MIN) or a product serial number ( Multimedia file management method using Escule in a mobile communication terminal, characterized in that it is generated in a double word form using any one of Electronic Serial Number (ESN). The method of claim 1, Generating a unique ID for identifying the info data and searching for an existing unique ID stored in a database to determine whether the unique ID is duplicated; If it is determined that the generated unique ID is a duplicate unique ID, increasing the specific value to the generated unique ID, generating a new unique ID that is not duplicated. How to manage multimedia files using Quell. The method of claim 1, Allocating a portion of memory as a data buffer in a SQL application when the terminal user commands the display of a list of multimedia files; Accessing the database, reading unique IDs included in each info file in order, and storing the unique IDs in the data buffer; Selecting unique IDs corresponding to the number of files that can be displayed as a file list at one time through a terminal screen from among the unique IDs stored in the data buffer; And extracting the information data included in the info file corresponding to each selected unique ID by searching the database, constructing a list of multimedia files to be displayed on the terminal screen, and displaying the same on the terminal screen. Multimedia file management method using Escule in mobile communication terminal. The method of claim 4, wherein Extracting a unique ID for the requested multimedia file from the multimedia file list displayed on the screen of the terminal; Deleting the info file corresponding to the extracted unique ID from the database by searching the database, and transmitting the information on the deleted info file to a file management system to delete a specific multimedia file stored in the internal memory of the terminal; Multimedia file management method using Escule in the mobile communication terminal further comprising.

Images