TW554275B - Management device and method for managing a remote database - Google Patents

Abstract

The present invention discloses a device and method for managing a remote database, which is used by a database manager to link to a specific website through Internet; and, using the specific home pages provided by the specific web site as the operation interface to manage and maintain the database linked by the specific web sites.

Description

554275 V. Description of the invention (1) Field of the present invention] The present invention relates to a technical field for collecting a soil owed by the Internet via the Internet, and particularly related to management = ^ 一 逖 端 逖 料 j A specific page of a specific website is managed by f! From the internet and domain. The present invention proposes a technical method for managing a remote database of 1 ^ 7 ... for a manager to use a device and method of the Internet database to transfer a specific network provided by the specific website to a specific website, to borrow | Safeguard the database linked to that particular website. At first glance to manage and maintain the interface [Background of the present invention] | With the rapid development of computers and the Internet, the use of computer software to carry out business activities and data management has flourished, and many companies are quite expected to develop the software industry over the years. In the field of database management, the computerization of specialized data and the electronic database of the enterprise's customers require the construction, management, and maintenance of a very important industry. Has become a knowledge service in the era of the knowledge-based economy in the past two years. Due to the rapid and better service of information technology, the database management has been established for enterprise customers and is located at a remote enterprise customer data base. The enterprise managers who are scattered all over the place spend a lot of time and money on the database manager: ί; J needs to consume the database manager for transportation in the transportation system as Li :: It is not economical. Yes The update process is cost-effective seven times. At present, I often change the data storage medium of Type 1 or data or send it: Page 4 V. Invention Description (2) | The program or data to be updated is sent to the company. The process personnel update it by themselves. However, when more information is generated by the information worker of the enterprise customer and the enterprise process or the database must go to the enterprise customer during the operation, the database manager must still be outside, ": ί The database is processed further. This change: use the library manager to manage and maintain the database, for example, set or eliminate errors, modify the database carefully, test = #material library, or exclude errors for the database > etc., it is difficult to apply the above The method is reached. Due to the development and popularity of the Internet, most business customers with a database have a website or a link to the Internet. If the Internet is transparent, it can be used by the database administrator. Logging in to the database remotely and managing and maintaining it will save the database administrator a lot of time and costs, and provide the enterprise customer with the fastest management and maintenance services. At present, 'opening a database on the Internet for general use and accessing or querying data is a fairly common technology and application. However, it provides database managers to manage and maintain data within an enterprise via the Internet. Libraries are still quite lacking. Therefore, how to provide a database manager to remotely manage and maintain the database through the Internet has become an urgent problem. [Overview of the invention] I. A remote database Another object of the present invention is to propose a management of the present invention is to propose a management device and method for managing a remote database for a database manager To manage a clear remote Lokada via the Internet «Management of remote databases ΙΗΠΜ 554275 V. Description of the invention (3) Management device and method, for the database manager to browse a remote operation instruction to Manage the database. Another object of the present invention is to re-certify the device and method of a remote database to strengthen the remote data base according to a feature of the present invention, and to provide a terminal device and the Internet via a specific network and a data source. The network chain rarely includes: a communication module, which communicates with the terminal device via the Internet, and database communication; a login interface module, a terminal device, where the login interface uses data to manage certificates through the database; The operation interface module is used for installation. The operation interface is used for operation instructions to pass through the database, and display the specific data returned according to a specific format; and the result of the library authentication to determine whether to execute the data . According to another feature of the present invention, a user of a terminal device of a management device authentication module device provides a specific web page as an operation interface, and the data of the database and the input of the database are proposed to be managed via the Internet 'and With the security of the dual library of the device and the database. I 'The database management loading library link provided by the present invention is used by a user to manage the database, and the device is used by the database management device via the network and via the specific network and the The data is used to generate a login interface to be transmitted to the user for the user to enter the database. The log-in device is transmitted to the database to request identification of an operation interface to be transmitted to the terminal. The user enters a management device that manages the database and is transmitted to the device. The database requests to instruct the database to execute an operation instruction. The database is based on the data, the operation instruction and the specific data are returned. The remote database management device is even more packaged to link to the data. Library management bank certification, and judge based on the certification results

554275 V. Description of the invention (4) Whether the data and the login information of the login device are transmitted to the other special / more and the Internet from a specific network according to the present invention. And via a terminal device library, and storing the one or more communication modules are used to transmit to the user processing device via the special user input to display the material; according to the law, the material library tube is provided by an The final message is generated for the designated designated designated asset to be managed and transmitted to the designated designated subject, wherein it is determined whether or not to use a specific network communication module 'Shangzhitongshengsheng' to log in according to the present invention by using a management device. The user enters the database and logs on to the database to request the specified data. The specified database is executed. The other person who specified the execution should stay through the management of the data and a data for communication, and the interface transmits the data to the database. To this includes the database link for the management device to identify the color, the database link to the data is linked to the general network that manages the database, and the user specifies the data to pass The operation of the database refers to the library requesting to execute an operation instruction. The database is based on instructions and color transfer. The terminal device and the material library of the present invention, in which the library is bonded, and the database management via the specific to the terminal device Database login data, the database requests the user to enter the certificate module, requests the database management device to be updated, and is used for processing the more than one message, and more than one database, and the database management system is used for a data source. The asset is used as an interface, and according to the following information, it should be returned to the specially proposed Internet. The asset management method includes the device network and the device, and the data should be determined by the specific information returned by the asset. The steps included in the database road link material warehouse refer to the data card through the data login; use the management card. Included by the user's data: The library is used by the messenger device for the storage library to manage the fixed format and fixed asset database. The management party to a asset management device includes: mm Page 7 554275 V. Description of the invention (5) '— Device is sent to the database to request authentication; m is used to send interface to Xi = terminal device' This operation interface is used by the user to manage the asset ^ = , Give an instruction to transmit to the data μ binary value through the database management device and display a specific database according to a special formula * line one operation refers to specific data; and '# 中' the database according to the data = According to another feature of the present invention, the remote database management method further includes: managing the link to the database; f = the user of the method enters the system, and judges the input data to the database to request authentication according to the authentication result; and = further includes a method for the user to input the management device: The user of the device is authenticated. Another feature of the invention is that the database—the user via a terminal device and the Internet method—includes a device for managing more than one data: the management of the c-database is via a specific device! The database management device special network is linked to more than one database, " the communication module is to send the _ w ^ · message through the specific network; the login interface is used for the user ^ = to upload the database The general person turns into the designated database for registration and provides the messenger for transmission to the designated information. The company ’s management company will enter and manage the designated database / for the messenger device. Sent to the specified database to request execution :::: The database manages to display the specified database to perform an operation 1-specific format 7 specific corpse / T specific assets returned 554275 V. Description of the invention (6)-material And the designated database is based on the certification results of the database to determine whether to execute the operation instruction and return the specific data. In order to enable your review committee to further understand the structure, characteristics and purpose of the present invention, drawings and Better The detailed description of the embodiment is as follows. [Detailed description of the preferred specific embodiment] The following will take an embodiment as an example, the purpose is to facilitate the detailed description of the device and method of the present invention, not to limit the present invention. Sun and Moon. At present, the web pages provided by general websites on the Internet mostly use HTML (Hyper Text Markup Language), XML (eXtensible Markup Language), or ASP (Act ive Server Pages). , Dynamic server webpage) to write. However, general databases, especially relational databases, are mostly written and managed in another language format such as SQL (Structure Query Langiage), VB (Visual Basic), or Delphi. Therefore, the average person cannot directly access the database through the webpage, and the common practice is to do a good marriage and convert between the two language formats. The embodiment of the present invention uses a company's website as a database management device, and provides a specific web page as an operation interface for the database manager to manage a remote database. Please refer to the first figure. The first diagram illustrates a network architecture diagram of an embodiment of the present invention, in which a database manager (hereinafter referred to as a manager) uses a manager terminal device (10, hereinafter referred to as a terminal device) and the Internet The path (20) is linked to more than one database management device (31 to 33, hereinafter referred to as the management device). Management device

554275 V. Description of the invention (7) (3 1 ~ 3 3) is a website containing pull-to-road (20) transmission to the terminal / department # ^ interface web page, which is viewed by the Internet as its interface # ^ Display. It is generated by specific operations. Based on the data ... ⑷, enter the management or maintenance data in the body bank A ~ C (4H3) and make the relevant instructions via a specific network ^^ 3 value C 41 ~ 43), and then Pointing. (51 53) Transfer to the database A ~ C (4 ~ 43) and execute it, where the 'terminal device (10) is a terminal of the general Internet and a personal brain: ; -Data Arvu computer, workstation or other computer deviceΐ, such as data: ^ management program for management, etc. 'is particularly suitable for database management systems containing processing database management Li @., Associated with 贝贝 理 厗 &糸; embedded system, management device 〇Biao and data Kang Γ41 special second network (5 bu 53) refers to the non-public network between the link management-the enterprise's internal enterprise network 3) Road, such as road and so on. Xi Feng M ^ _ Dedicated line, local area network or a closed network node (such as the Internet) connection, 1: Network not set up with the public network. A number of dedicated links or private or corporate management devices provide specific web pages as ^ ^ database A management and setting (3) for example = γ ^ 'functions (that is, provided through the Internet except J Provide a general website terminal or computer), the management f set (3 η 2 ,,, °) to find the certificate module of the web page. ⑻,-communication module; more securely-management device identification ^; login interface module Group (312)

Page 10 554275 V. Description of the invention (8) and an operation interface function and execution steps). The following will explain each module (31) in more detail, and the ^ ^ f certificate module (31〇) is used to authenticate the identity of the person who is linked to the webpage of the management device to determine whether it is provided, = webpage as information Library ⑷) operation interface page. Because the management interface is downloaded by the management device, the user can download the specific web page arbitrarily, and (310) when any terminal device requests to download the special page 7, the weekly page must be downloaded by the terminal. Provide the login information of the management device (such as the administrator, user account name and password, etc.), and compare with the original use of the stored device: 2: II: 行, only after passing the authentication of the management device, Allow 1 to move the human interface module (312) or the operation interface module (313) to generate a login page or an operation interface page and send it to the terminal device requesting the download. 0 The communication module (3 11) is used for management. The device (3 υ) communicates with the terminal device (1 0) and the database (41). The communication module (3 丨 丨) is based on the general Internet protocol (such as HTTp, Tcp / Ip) and communicates with the terminal The device (10) uses §fl to transmit the webpage and the data or instructions returned by the webpage 'and according to the communication link of the general database, such as 〇DBC (〇pen

Database Connectivity) or 〇LE (〇bject Linking &

Embedding), communicating with the data base (41) for transmitting data or instructions from the terminal device (10), and returning the results of the data base (41) according to the data or instructions to the management device (31). Among them, the communication module

Page 11 554275 V. Description of the Invention (9) (3 1 1) —It generally uses a network card and its communication program. The login interface module (312) generates a login interface web page and sends it to the q-end device (10) for the administrator to input data :, and sends the database (⑴ login data to the second to perform login. Because the general In the database or database management system, is it possible that = Xu Yi requests the login user to log in to the database, it must be recognized by the * Ha database = 丄 Ξϊι The login interface page contains the login database (4U required J for management) Enter the database login data (for example, in the login module mm login data block;; = 丄 3;) J to = i41) Please, log in and wait for the response information. The database center is based on x 22 or β 2 The data is compared with the stored original manager authentication information, = ΐ = = manager. When requesting the login user to pass the database two: == according to the identity of the manager to provide corresponding to the = ί to the management device (31); If the requester fails to reject the% I &I; I5 I database (41), then reply to the failed authentication message, and refuse the requester to enter the asset (41), such as the management device (31) Database procedures: ϋ ΐ ΐ 2: Authentication procedures and information Library certification The original manager's certification information is not certified: the probability of being cracked in the database and the database. If you want to reduce the certification information and further strengthen the women's comprehensiveness, in addition to the general code :: certificate information, you can add more Terminal device (⑴'s π address is part of 纟 tolerance 5 and> δίΐ. 554275 V. Description of the invention (10) In order to simplify the implementation of the above two types of authentication procedures, the management device authentication and database authentication The barriers required for this type of authentication procedure are set on the login interface webpage. This method allows the administrator to enter the data required for the two types of authentication through the login interface webpage and send them to the management device (31). The management device authentication module (310) reads the login data of the management device for authentication, and the login interface module (3 丨 2) transmits the login data of the database to the database (41) to request authentication In this way, the administrator does not need to pass the authentication when requesting to download the login interface webpage, but can only request the operation after passing the above two types of authentication at the same time. Interface web page. 'The main function of the operation interface module (3 13) is to generate an operation interface web page based on the data returned by the database (41) and send (10) to display it. Among them, the operation interface web page is more Including the user to input the relevant instructions for managing the shell database (41). The operation interface is a combination of ASP and HTML to form Λ 鲂 ，, the purpose, 丨 renren τ Bao, ug Baibai deduction / and Dong Zhuangjia is the interface The webpage is an ASP webpage, and the ASP code that was mixed between the HTMUt pieces before sending the webpage out of the & management device (3 υ), and will generate a complete webpage and send it to the HTML and HTML files asp. The advantage of a web page is the L-end device. The use is in the management device (31, which is the second species of feeding clothing .: and the ASP code (1., which contains the license of the Pan browser): and 2 terminal devices with any browser can be presented as $ Α ς No matter whether the device is included or not. ^ ASP ^ 4 ^ # " ASP ^ 1 ^-can protect intellectual property rights, and clearly require the terminal to download the webpage to install the house right, and prevent others from arbitrarily going through the operation interface page 13 554275

Web page into the database. Applying the characteristics of the above ASP, when the manager transmits the data corresponding to the manager to the management " device, through the data database (41), the operation interface module (313) is based on the data from the database (41). ) ≪ data and its corresponding HTML element, to generate a complete operation interface webpage, which is transmitted to the terminal device (10) for display via the Internet (20). If it does not pass the database authentication, it will reply a failed authentication message to the terminal device (丨 〇). Among them, the HTMLtg file is used to set the display style of the data in the database, and because the data provided by the database (41) varies from different database components, in general, it is different. The component sets its display style. For example, when a manager wants to view a specific table and view in a database, the database sends the specific table and view data to the management device (31), and the operation interface module (31 3 ) Identify the data type in the data table and view data, select the corresponding HTML element to set the display style to generate a complete operation interface web page and send it to the terminal device (1 0). The browser displays the display style of the fact sheet and view. / General database management system ', especially a relational database management system, often uses a specific language to write data processing programs for managers to quickly find and manage data. The description is based on a relational database written in SQL language. SQL can be divided into three parts: Data Definition Language (DLL), Data Manipulation Language (DML), and Data Control. Language (Data Control Language, hereinafter referred to as DCL). its

554275 5. In the description of invention (12), general users only need DML to query, input, modify data in the database, etc. In addition to DML, managers also need dlL to build or define the structure and components of the database. , Such as creating or deleting tables, views, domains, and indexes in the database, and applying DCL to set and restrict the user's access to the components and data of the database Permissions.

Therefore, in addition to displaying the data from the database, the operation interface webpage also has a command input field for administrators to input operation instructions or data for managing and maintaining the database, such as DDL, DML, or DCL commands. It is sent to the management device (31) via the Internet (20). The operation interface depends on the group (3 ^ 3) to transmit the operation instruction or data in the instruction input block to the database (1), f, and receive the data returned by the database (41) to generate another 3 deductions 7 The operation interface webpage of the input block is sent to the terminal device (丨 0) via the Internet (20). More than one business customer has more than one database. Therefore, for example, (^ the present invention and another embodiment are used to set two or more databases D3 (44 ~ 46) through the management device. Among them The 'management device. The above embodiment' differs from the fact that the database D1 and D3 (44 ~ 46) on the specific screen name device M22 are connected, and the management

D D D3's Γ name and // etc. ^ D 3's _ information ’❹ database stop, take over its ™ 4. In addition, you need to add in the login interface webpage-it is said to enter or select when requesting the execution of the second database-the database name is performed with this database, and according to the address data stored in the management device (34)

Page 15 554275 V. Description of the invention (13) --------— The data format and display style of the database D3 and D3 may be different. The processing program of the database may use different programs. Therefore, the operation interface module (31 3) sets the display style according to each asset format and its HTML components to generate a pair # and negative. Because the operation interface module (313) is an operation finger / data that inputs instructions into the block Directly sent to the designated database to request execution, therefore, the management must judge for itself that the correct program is used for each database. Since the terminal device (10) and the management device (31 ~ 34) are ^ / series Data is transmitted by the 7 Internet (20). In order to increase the security of its transmission, the communication between the terminal device (10) and the management device (31 ~ 34) can be further secured, such as general The commonly used SSL (Secure Sc) cket layer 'network security protocol), VPN (Virtual private Network's virtual private network), or any other form of encryption and decryption equations are used to encrypt and decrypt data when transmitting data. Through the above-mentioned device and method, the administrator can browse the content of a specific database and issue instructions for managing and maintaining the database through a remote terminal device and its browser, as if the administrator went to the database in person Manage and maintain the database at the location. In summary, the present invention shows that it is superior to the known technology in terms of purpose, means and efficacy. I implore your reviewing committee to make a clear observation and grant a patent earlier, so as to benefit the society and feel good. It should be noted that the above-mentioned embodiments are merely examples for the convenience of description. The scope of the rights claimed in the present invention should be based on the scope of the patent application, and not limited to the above-mentioned embodiments.

Page 16 554275 Brief description of the drawings [Simplified description of the drawings] The first diagram: a network architecture diagram according to an embodiment of the present invention. FIG. 2 is a block diagram of a device according to an embodiment of the present invention. FIG. 3 is a network architecture diagram of another embodiment of the present invention. [Illustration of drawing number]

1 0 ~ Administrator terminal device; 2 0 ~ Internet; 3 1-3 4 ~ Database AD management device; 310 ~ Management device authentication module; 31 Communication module; 312 ~ Login interface module; 313 ~ Operation interface module; 41-43 ~ Database A-C; 44-46 ~ Database D1-D3; 51-54 ~ Special network.

Page 17

Claims (1)

554275 VI. Scope of patent application [Scope of patent application • Special network devices and networks are: a communication with the terminal; a boarding device, the material passes through an operating device, the operation instruction line, and executes the Exercise 2. Root road system is a 3. Root road system is a 4. Root road system is a database management server. Road and a database are connected to the Internet to manage the information module device access interface login. This information is used as an interface operation guide to pass a special fund, which is used as an instruction to apply for a business network application line. According to the application, the area network is used for the message, and the database management aggregation is used for a user to access the database through a terminal. The device at least includes the database management device to route the specific network via the Internet. The network and the database communication module surface is the library management module surface, the material is determined; the material library and the patent road. The patent is used for the management device, used for the supply bank to display the display and is based on the back to the special range to generate a login to the user to send to the asset to generate an operation of the user to send the device. Show the database identified information of the database. The device interface of item 1 is transmitted to the terminal to access the database to log in to the database to request authentication; the interface is transmitted to the terminal to manage the database to the database to request the execution of an operation instruction to verify the result to determine whether or not The device of the specific network scope item 1, wherein the specific network patent scope is the first route. 1 device, wherein the particular network 554275 5. According to the device in the scope of patent application, the road system is a closed network. "" Special network should log in to refer to the database and that specific database. 6 · According to the first item of the scope of patent application, the face is a web page, and the operation interface is a web page. 7 · According to the scope of patent application No. 6 Item 8. The device according to the operation instructions is a SQL instruction. 8 8 • According to the seventh item of the scope of the patent application, the format is HTML format. '9. According to the eighth item of the scope of the patent application, the asset management device It also contains: a management module authentication module for authenticating the user of the terminal device linked to the database management device, and determining whether to transfer the database login data to the database based on the authentication result Request for authentication. 10 • The device according to item 9 of the scope of patent application, wherein the management device authentication module further includes a management device login interface to be transmitted to the terminal device. The management device login interface is used for the device. The user inputs the management device login information to send to the management device authentication module to perform authentication; β and The login interface module determines whether to generate the login interface based on the authentication result of the database management device. 11 · The device according to item 9 of the scope of patent application, wherein the login interface further includes a method for the user to input the login information of the management device to be transmitted to the management device authentication module to request authentication. 1 2 · — database management device, wherein the database management device is Page 19 554275 VI. Scope of patent application = special network linking with more than one database for one to link through a cooking mountain # 成 — ^, clothes set and the Internet to manage the one or more Database, and Jianliu's book * 1-holds the communication data of more than one database, the device contains at least: n / 故 故, a message module for the database management device via the Internet ^ 鸲 device communication, and communication with the more than one asset database through the specific network; event-login interface module, used to generate-login interface is transmitted to the terminal ^ used to login interface is used for The user designates a database 'and for this = enter the login information of the specified database to be transmitted to the finger via the asset; the database requests authentication; the device nt:;: and ... generated-the operation interface is transmitted to the The selection of the terminal database is used by the user to manage the specified database request, and i is transmitted to the specified data in accordance with the specified cell. The operation is performed in the format searched by A to display the execution of the specified database. Returned after order Specific data; and a flat U Ding execute judgment: material library authentication result to U · a database management two mouth and pass information. Connect to the Internet link manager / user via a terminal library, where the database manages the device? Erli = Manage the data link. The method includes the steps: ···, a special network and a database k for a §fL module, which is used by the network to communicate with the terminal device. , And; :: J :: Physical device communicates with the database via the Internet, Zuoyou 4 special network m page 20 554275 6. Patent application scope communication; Generate a login interface and send it to the terminal device, the login interface is It is used for the user to input the database login information to be transmitted to the database to request authentication through the database management device. An operation interface is generated and transmitted to the terminal device. The operation interface is used for the user to input management information. The operation instruction of the database is transmitted to the database for execution through the database management device, and is based on the specific format to display the specific data returned after the database executes an operation instruction; and the database is based on the data The database authentication results are used to determine whether the operation instruction and the specific data are returned, and the method according to item 13 of the scope of patent application is used. Among them, the login " face It is a web page, and the operation interface is a web page. $ π! Α · The method according to item 13 of the patent application scope, wherein the database operation instruction is SQL ^ command. Τ 3 Beizhu 16 The method according to item 13 of the scope of patent application, wherein the material is not set to HTML format. 1 7 · According to the first step included in the scope of the patent application, the method of the 13th item is as follows: “The method of the terminal device of the method” is used to verify whether the user of the terminal device of the method transmits the database login information to the database management device , And judge according to the authentication result to send to the database to request authentication. 1 8 · According to the scope of the patent application, the more included steps are: 1 of the method of item 7 ′, wherein the method 554275 6. The scope of the patent application generates a management device login interface and transmits it to the terminal device. The management device login interface is used for the user to enter the management device login data to use the terminal device linked to the database management device. Perform authentication; and determine whether the login interface is generated and transmitted to the terminal device according to the database management device authentication result '. 19 · The method according to item 17 of the scope of patent application, wherein the login " surface further includes a method for the user to input the management setting login data to the terminal device linked to the database management device. The user authenticates. 2 〇 · —Database management method for a user to link to a database management device via a terminal device and the Internet to manage more than one database, wherein the database management device passes a specific network The method includes the following steps: 〃 providing a communication module for the database management device to communicate with the terminal device through the Internet and the specific network with the terminal device. A database communication on two; generating a login interface for transmission to the terminal device, the login interface is used for a user to specify a database, and for the user to enter the specified database login data for management by the database The device transmits to the finger to request authentication; it generates an operation interface to transmit to the terminal device for the user to input and manage the specified database, and the user " uses the database management device to transmit to the specified database request ^ 指 to perform an operation through the specific format to display the specified database; ^ 275 275 returned after The patentable scope of specific data; and wherein the specified database according to the database authentication result to determine whether to execute the operation command and returns the specific information. 9 Page 23