經濟部智慧財產局員工消費合作社印製 497051 A7 B7 五、發明說明() 發明領域: 本發明係與資料庫(database)相關,尤指一種具有儲 存查詢指令(query)之表單(table)的資料庫。 發明背景: 目前有許多資料庫的用戶應用程式(database client application),可讓使用者存取資料庫。結構化查詢語言 (Structured Query Language,以下簡稱 SQL)為一種特殊用 途的資料次語言(data sublanguage),可透過關聯性資料管 理系統(relational database management system)中的資料 庫,來界定並操作資料庫中的資料。雖然SQL無法用來編 寫可於資料庫中存取資訊的用戶應用程式,但這樣的應用 .程式卻可以使用含有SQL的一般用途之應用程式語言(如 C或COBOL)來編寫。換言之,SQL的指令(statement)内 嵌(e m b e d e d)於應用程式語言的程式中,而且該程式可經由 編碼(compile)而產生資料庫的用戶應用程式。 在資料庫用戶應用程式中的SQL指令,可用來儲存並 取出關聯性資料庫中的資料。例如,公司的資料庫可能包 含"employees ”(,'員工·’)的表單,以儲存公司中每一個員工 的姓名,社會安全號碼,住宅地址,公司地址,部門,及 薪資等等。以這樣的資料庫而言,SQL的指令:"insert into employees values (’Jones,Red’,111-22-333,·.·)’’ 便將員工 Fred Jones的相關資料,設定在”employees"的資料庫表單 中。同樣地,SQL 指令:’’select name,serialNumber from 第3頁 本紙張尺度適用中國國家標準(CNS)A4規格(210 X 297公釐) --------------------訂---------線 (請先閱讀背面之注意事項再填寫本頁) 經濟部智慧財產局員工消費合作社印製 497051 A7 B7 五、發明說明() employees”,便將在'’employees”資料庫表單中的所有員工 的姓名,及序列碼存取出來。在操作時,用戶應用程式便 提供像這樣的内嵌式的SQL指令給下層的資料庫管理系 統,以操作資料庫中的資料。例如,要顯示所需求的資訊, 用戶應用程式便發出SQL查詢指令(query)給資料庫管王里 系統,然後擷取所產生的資訊,格式化資訊,再顯示資訊 給使用者。 當資料庫用戶應用程式以内嵌的SQL指令來編寫 時’並將應用程式中的操作轉換為應用程式的原始碼時, 這將產生許多缺點。首先,當應用程式所使用的SQL指令 更改時’資料庫用戶應用程式的原始碼也必須跟著更改。 因為SQL指令是儲存在應用程式的原始碼中,所有對SQL 指令的更動,在原始碼中也要作相對的更動,然後重新編 碼。因此’對S Q L指令的更動,必須在產品週期中對原始 碼改變的那段時間内完成,或透過用戶應用程式的特約商 來執行。 另外,原始碼中的SQL指令必須可為大眾所應用,以 使大多數的用戶可以使用該應用程式。因此,Sql指令龙 操法輕易地為特定的用戶特製化(C U S t 〇 m i z e d )或最佳化。 ”二而’特l化只能透過應用程式的特約商來執行更改。而 且’資料庫的效能微調是在客戶端持續性的工作,一般是 當資料庫應用程式的程式碼在產生時執行的。然而,因為 用戶環境的改變(如,在工作負荷,資料庫大小,或資料 庫使用的改變),SQL指令的微調或改變通常必須超時地 第4頁 本紙張尺度適用中―豕保準(CNS)A4規格(21G χ 297公髮) -------------衣--------訂 ---------線 (請先閱讀背面之注意事項再填寫本頁) 497051 A7Printed by the Employees' Cooperative of the Intellectual Property Bureau of the Ministry of Economic Affairs 497051 A7 B7 V. Description of the invention () Field of the invention: The present invention is related to a database, especially a form with a table that stores query instructions. Library. BACKGROUND OF THE INVENTION: There are currently many database client applications that allow users to access databases. Structured Query Language (hereinafter referred to as SQL) is a special purpose data sublanguage, which can be defined and operated through a database in a relational database management system. Information. Although SQL cannot be used to write user applications that can access information in a database, such applications can be written using general-purpose application programming languages (such as C or COBOL) that include SQL. In other words, the SQL statement is embedded (e m b e d e d) in the program of the application language, and the program can compile to generate the user application of the database. SQL commands in the database user application can be used to store and retrieve data from the relational database. For example, a company's database might contain a form called "employees" (, 'employees') to store the name, social security number, residential address, company address, department, and salary of each employee in the company. For such a database, the SQL command: "insert into employees values ('Jones, Red', 111-22-333, ...") sets the relevant data of employee Fred Jones to "employees " Database form. Similarly, the SQL instruction: `` select name, serialNumber from page 3 This paper size applies the Chinese National Standard (CNS) A4 specification (210 X 297 mm) --------------- ----- Order --------- line (please read the notes on the back before filling out this page) Printed by the Employee Consumer Cooperative of the Intellectual Property Bureau of the Ministry of Economic Affairs 497051 A7 B7 V. Invention Description () employees ” , The names and serial numbers of all employees in the "employees" database form will be accessed. In operation, the user application program provides such embedded SQL commands to the underlying database management system to manipulate the data in the database. For example, to display the required information, the user application sends a SQL query to the database management system, then retrieves the generated information, formats the information, and displays the information to the user. When a database user application is written with embedded SQL instructions' and operations in the application are translated into the application's source code, this creates many disadvantages. First, when the SQL command used by the application changes, the source code of the database user application must also change. Because the SQL commands are stored in the source code of the application, all changes to the SQL commands must be changed in the source code and then recoded. Therefore, the modification of the S Q L instruction must be completed within the period of the source code change in the product cycle, or executed through the contractor of the user application. In addition, the SQL instructions in the source code must be applicable to the general public so that most users can use the application. Therefore, the Sql instruction dragon operation can be easily customized (C U S t om i z e d) or optimized for a specific user. "Secondly, 'Specialization can only be implemented through the application's contractor. Moreover, the performance tuning of the database is a continuous work on the client side, and is generally performed when the database application code is generated However, due to changes in the user's environment (eg, changes in workload, database size, or database usage), fine-tuning or changing SQL instructions must often time out. Page 4 (CNS) A4 specification (21G χ 297 hair) ------------- clothing -------- order --------- line (please read the back first (Notes on this page, please fill out this page) 497051 A7
五、發明說明() 經濟部智慧財產局員工消費合作社印製 來執行。以内嵌的SQL指令,庫闲和』^ I用裎式的程式碼必須隨著 每一起SQL指令的更動而更改。 "^也將須要與供應商訂立 特殊的服務契約。 另外’甚至如果用戶签下膝 争W服務的契约時,供應商 必須被通知來執行任何更改。例 _ 例如’每當資料庫管理者 (database administrator)在用戶端判 崎刊疋須要對SQL指令加 以修改時,資料庫管理者必須血_ ,、與應用程式的供應商共同合 作執行這樣的修改。由於,至少右;μ,, ㈤、芏/有兩個人力必須參與應用程 式的修改及測試,修改SQL指令的 伯7的成本便因而提高了。對 於必須一天24小時,每週+ 士 此 天地執行之使用率高的資料 庫應用程式而言,還有另-個缺點。以内&的s以指令而 言,每次對SQL指令修改時,用戶應用程式必須停擺。然 而,這對使用率高或非常追切的應用程式而言,這樣的干 擾是不可能且無法接受的。 而且,如果資料庫應用程式的程式碼中包含了 SQL 指令,而且SQL指令的更改須要超時,此資料庫應用程式 本身目前的版本,必須與資料庫的表單一起記錄。也就 是’如果SQL指令已改為提供給具彳1〇〇 〇〇〇筆記錄的資 料庫使用’具有SQL指令的應用程式也必須隨著資料庫備 份。同樣,表單名冑,及資料攔位也可逾時地更改,所以 應用程式將無法正確地操作,除非資料庫應用程式目前的 版本儲備有這樣的資料庫。另外,如果應用程式的程式碼 必須隨著每個SQL指令的更動而改變,則應用程式供應商 可能在原本只是要對SQL指令修改時,而不經意地將(有 第5頁 本紙張尺度適用中國國家標準(CNS)A4規格(210 X 297公爱) --------------------訂---------線 (請先閱讀背面之注意事項再填寫本頁) 497051V. Description of the invention () Printed by the Consumer Cooperatives of the Intellectual Property Bureau of the Ministry of Economic Affairs for implementation. With the built-in SQL commands, the library code must be changed with each SQL command change. " ^ It will also require special service contracts with suppliers. In addition, even if the user signs a contract for the service, the supplier must be notified to perform any changes. Example _ For example, 'Every time a database administrator determines that a SQL command needs to be modified on the client side, the database manager must work with the vendor of the application to implement such a modification. . Because, at least right; μ, ㈤, 芏 / have two manpower must participate in the modification and testing of the application program, the cost of modifying the SQL instruction is increased. There is another disadvantage to high-usage database applications that must be run 24 hours a day, + weekly. Within & s is a command, every time the SQL command is modified, the user application must stop. However, it is impossible and unacceptable for such applications to be highly utilized or highly sought after. Furthermore, if the SQL code is included in the code of the database application and the SQL command changes need to time out, the current version of the database application itself must be recorded with the database form. That is, 'if the SQL command has been provided to a database with 10,000 records,' an application with a SQL command must also be backed up with the database. Similarly, the form name and data block can also be changed over time, so the application will not operate correctly unless the current version of the database application has such a database. In addition, if the application's code must change with each SQL instruction change, the application provider may inadvertently modify the SQL instruction originally (the 5th page of this paper applies to China) National Standard (CNS) A4 Specification (210 X 297 Public Love) -------------------- Order --------- Line (Please read the back first (Notes for filling out this page)
經濟部智慧財產局員工消費合作社印製 五、發明說明() 關或典關)瑕疵;加到程式碼中。 另-個使用内嵌式SQL指令的缺點是,不同的資料庫 管理系統(如,IBM dB/2,0racle,及Sybase)對SQL指令 白有不同的法要求。為其中一種平台而寫的SQL指令可 能不適用於另-種平台。同樣地,SQL指令可以隨平台的 差異而有不同的表現。因此,具有内嵌式的SQL指令之資 料庫用戶應用程式可能只限制在特定的資料庫平台,而且 不同的平台必須使用不同,的應用程式來編寫。同樣地,當 SQL指令内嵌於應用程式的程式碼中時,資料庫應用程式 就不是可被各式產品所使用之一般目的的應用程式。相反 地,此應用程式便是特定用途的產品,無法被其它須要存 取該資料庫的不同產品所使用。 發明目的及概述: 就這些缺點而觀之,本發明之目的在於去除上述之缺 點,並提供一個具有一可儲存資料庫查詢指令之表單的資 料庫,且該資料庫查詢指令可被資料庫用戶應用程式所使 用。建JL 一個資料庫表單以儲存查詢指令,在程式執行時 (run time),資料庫用戶應用程式便從資料庫表單中存取查 詢指令。因此,資料庫用戶應用程式的查詢指令可以被輕 易地更改,而不必改變應用程式的程式碼,或將應用程式 重新編碼。依此,’’資料庫查詢指令,,(database quedes)包 含所有型態的資料定義,以及操作的指令(如SQL指令), 不論這些資訊是否要從資料庫存取。例如,在SQL的環境 第6頁 本紙張尺度適用中國國家標準(CNS)A4規格(210 X 297公釐) --------^ -----------衣--------訂---------線 (請先閱讀背面之注意事項再填寫本頁) 經濟部智慧財產局員工消費合作社印製 497051 A7 __B7 五、發明說明() 中,”資料庫查詢指令"包括”insert,,及”select"指令。 本發明之實施例之一提供存取資料庫的方法。依據本 方法,資料庫查詢指令由資料庫的一個表單中存取出來, 而且該資料庫查詢指令可發出至資料庫中執行查詢。在一 實施例中,資料庫查詢指令乃由資料庫的表單中,依據查 詢指令識別碼查詢出來。符合該查詢指令識別碼的資料庫 查詢指令便被接收,且在發出該資料庫查詢指令之前,參 數便被插入所接收到的資,料庫查詢指令中。 本發明之另一實施例提供一資料庫用戶應用程式,以 用來與一資料庫溝通,該資料庫具有一查詢指令表單,以 儲存複數個資料庫查詢指令,以及其它儲存資料庫訊息的 表單。資料庫用戶應用程式包含,存取裝置,用以自資料 •庫的查ί句扣令表單中,取出至少一個資料庫查詢指令;以 及查詢需求發出裝置,用以將所取出的資料庫查詢指令發 出至该貝料庫中查詢。在一較佳實施例中,存取裝置包含 查詢裝置,用以自資料庫的查詢指令表單中,使用一查詢 指令識別碼,以查詢一個資料庫查詢指令;以及接收裝 置,用以接收符合該查詢指令識別碼的資料庫查詢指令。 在另一較佳實施例中,查詢需求發出裝置包括插入裝置, 用以在發出眾取出之資料庫查詢指令之前,將參數插入所 接收到的資料庫查詢指令中。 本發明(其e的目的’特徵,及優點可由下列之詳細 的描述中更為清楚地顯示出來。然而,本發明之最佳實 施例之詳細的描述及特殊的例予只是做為說明之用,凡 第7頁 本纸張尺度適用中國國家標準(CNS)A4規格(210 X 297 ------------衣--------訂---------線 (請先閱讀背面之注意事項再填寫本頁) A7 B7 明之較佳實施例之資料 五、發明說明( 依本發明中請專利範園 本發明專利涵蓋之範圍内。~寺變化與修飾皆仍 圖式簡單: 弟1圖為一流程国 观%圖,顯示本 法。 ""月 < 貝料庫系統的操作方 弟2圖為一功能> 月匕万塊圖,顯示本發 庫系統。 & 第3圖為一流程圖,顯示 p ^ m , 、 又月又較佳實施例之資料庫用 戶應用程式查詢資料庫的程序。 第4圖為-功能方塊圖, 〜、不貝枓庫伺服器與用戶。 發明詳細說9^| ; " '~' —1~. ^發明之較佳實施例將依據所附之圖㈣細說明如 〇 T列《插述說明中’”資料庫查詢指令"(database queries)包含所有資 、, 貝枓疋我的型態,以及操作的指令,無 論資訊是否建立扁咨私 ” 庫中或是從資料庫存取。例如,在 結構性的查詢語士厂 。(Structured Query Language,SQL)環境 中’:資料庫查詢指令,,包括,,insert’,及,,select,,的指令。 第1圖顯7JT 一依據本發明之實施例的操作資料庫系統 之方法的"“王圖。在資料庫中,查詢指令表單⑽⑷ 的建上是用來儲存資料庫查詢指令及其識別碼。資料庫用 戶應用&式所使用的資料庫查詢指令儲存在查詢指令表 單中’以備將來在應用程式中使用(步驟S 1 0)。換而言之, 第8頁 本紙張尺度適用尹國國家標準(CNS)A4規格(210 X 297公釐) --------IT---------^· (請先閱讀背面之注意事項再填寫本頁) 經濟部智慧財產局員工消費合作社印製 497051 A7 ---—--------- —__B7______ 五、發明說明() 旦"句扣T不疋放在應用程式的原始碼中,而是放在資料庫 的旦,句^令表單中,而且每一個查詢指令只有一個識別碼 放在原始碼中。 (請先閱讀背面之注意事項再填寫本頁) 在^作時’資料庫用戶應用程式執行各種執行應用程 式本身所Λ、的功能(步驟§丨2)。每當須要存取資料庫時(步 驟S 1 4)用戶應用程式便使用儲存的識別碼,從查詢指令 表單中取出相對應的資料庫查詢指令(步驟S16)。所取出 的旦為扣令便發送給資料庫,查詢的結果便被傳回(步驟 S 1 8) ”’:後應用程式持續執行各種不同的功能(步驟s 1 2)。 因為資料庫查詢指令儲存在資料庫的查詢指令表單中,而 且只有其識別碼儲存在應用程式的原始碼中,所以資料庫 的查詢指令可輕易地被資料庫的使用者更新,或微調。而 且,資料庫查詢指令的更新,可不必更改原始碼或對應用 程式重新編碼,或微調。因此,本發明之方法可提供更有 彈性且更有效率的用戶應用程式。 經濟部智慧財產局員工消費合作社印製 本發明所舉例之資料庫系統的應用程式是作為資料 庫資訊網際網路服務。第2圖顯示資料庫系統的一般安 排。資料庫管理系統42管理位於資料庫4〇中的資訊,包 括一般之資料儲存表單48,及查詢指令表單46,以儲存 用戶應用程式44所使用之資料庫查詢指令。用戶應用程 式44 ’如Java應用程式’ HTML應用程式,或在網際網 路瀏覽器所執行的Java applet,透過網際網路伺服器43 而與資料庫管理系統42溝通。資料庫40,資料庫管理系 統42,以及網際網路伺服器43可位於同一個系統中,也 第9頁 本紙張尺度適用中國國家標準(CNS)A4規格(21G x 297公餐) "'- 497051 A7 B7 經濟部智慧財產局員工消費合作社印製 五、發明說明() 可以透過連接的網路分佈於各個系統中。 在操作時’當用戶應用程式44對資料庫40發出存取 的需求時’所須之資料庫指令(如SQL指令)之識別碼便被 傳送至資料庫管理系統42中。資料庫管理系統42便可以Printed by the Consumer Cooperatives of the Intellectual Property Bureau of the Ministry of Economic Affairs. 5. Defects of the invention description (or customs clearance); added to the code. Another disadvantage of using embedded SQL commands is that different database management systems (such as IBM dB / 2, Oracle, and Sybase) have different legal requirements for SQL commands. SQL instructions written for one platform may not work for the other. Similarly, SQL instructions can behave differently depending on the platform. Therefore, database user applications with embedded SQL commands may be restricted to specific database platforms, and different platforms must be written using different applications. Similarly, when SQL commands are embedded in the application's code, database applications are not general-purpose applications that can be used by various products. On the contrary, this application is a special-purpose product and cannot be used by other different products that need to access the database. Object and Summary of the Invention: In view of these disadvantages, the object of the present invention is to remove the above disadvantages and provide a database with a form capable of storing database query instructions, and the database query instructions can be used by database users. Used by the application. Create a database form in JL to store the query instructions. At run time, the database user application accesses the query instructions from the database form. Therefore, the query commands of the database user application can be easily changed without changing the code of the application or recoding the application. According to this, the 'database query command' (database quedes) contains all types of data definitions and operation commands (such as SQL commands), regardless of whether the information is to be obtained from the database. For example, in the SQL environment, page 6, this paper size applies the Chinese National Standard (CNS) A4 specification (210 X 297 mm) -------- ^ ----------- clothing- ------- Order --------- line (please read the notes on the back before filling out this page) Printed by the Consumers' Cooperative of Intellectual Property Bureau of the Ministry of Economic Affairs 497051 A7 __B7 V. Description of Invention () In the "database query command" includes "insert," and "select" commands. One embodiment of the present invention provides a method for accessing a database. According to this method, the database query command is included in a form of the database It can be accessed, and the database query command can be sent to the database to execute the query. In one embodiment, the database query command is queried from the database form according to the query command identifier. It is identified by the query command. The database query instruction of the code is received, and the parameters are inserted into the received data and database query instructions before the database query instruction is issued. Another embodiment of the present invention provides a database user application program To communicate with a database, the resource The database has a query instruction form to store a plurality of database query instructions, and other forms to store database information. The database user application includes, an access device for querying the sentence deduction form from the database. Taking out at least one database query instruction; and a query demand issuing device for sending the retrieved database query instruction to the shell database for query. In a preferred embodiment, the access device includes a query device, A query command identification code used to query a database query command from the database query command form; and a receiving device for receiving a database query command matching the query command identifier. In the embodiment, the query demand issuing device includes an inserting device for inserting parameters into the received database query instruction before issuing the database query instruction taken out by the public. The present invention (its purpose of e's features and advantages) This can be more clearly shown in the following detailed description. However, the details of the preferred embodiment of the present invention The descriptions and special examples are for illustrative purposes only. The paper size on page 7 applies to the Chinese National Standard (CNS) A4 specification (210 X 297 ------------ clothing --- ----- Order --------- line (please read the precautions on the back before filling this page) A7 B7 information of the preferred embodiment V. Description of the invention (according to the patent claims in this invention The scope of the invention patent is covered by the scope. ~ The temple changes and modifications are still simple in the diagram: Figure 1 is a process view of the country view, showing this method. &Quot; " month " Figure 2 is a function > Moon Dagger Block Diagram showing the library system. & FIG. 3 is a flowchart showing the procedure of the database user application querying the database of p ^ m,, and the preferred embodiment. Figure 4 is a functional block diagram, ~, not the server and user. Detailed description of the invention 9 ^ |; " '~' —1 ~. ^ The preferred embodiment of the invention will be explained in detail according to the attached figure, such as the column "Tentative Interpretation" "Database query instructions" ( database queries) contains all the information about the type, and operation instructions, regardless of whether the information is created in the "Private Consulting" database or from the database. For example, in the structured query language factory. (Structured Query Language, SQL) environment: ': Database query instructions, including ,, insert', and, select ,, instructions. Fig. 1 shows 7JT, a "king diagram" of a method for operating a database system according to an embodiment of the present invention. In the database, the query instruction form ⑽⑷ is built to store the database query instruction and its identification code. The database query commands used by the database user application & formula are stored in the query command form 'for future use in the application (step S 1 0). In other words, page 8 of this paper applies to Yin National Standard (CNS) A4 (210 X 297 mm) -------- IT --------- ^ (Please read the notes on the back before filling this page) Ministry of Economic Affairs Printed by the Intellectual Property Bureau's Consumer Cooperatives 497051 A7 -------------- --__ B7______ V. Description of the Invention () Once the "sentence T" is not placed in the source code of the application, but In the database, the sentence ^ order form, and each query command has only one identification code in the source code. (Please read the precautions on the back before filling this page) At the time of the 'database user application Perform various functions of the application itself (step § 丨 2). When accessing the database (step S 1 4), the user application uses the stored identification code to retrieve the corresponding database query command from the query command form (step S16). The retrieved order is sent to the data once the deduction order is issued. Library, the results of the query are returned (step S 1 8) "": After the application continues to perform various functions (step s 1 2). Because the database query command is stored in the database query command form, and only its identification code is stored in the application's source code, the database query command can be easily updated or fine-tuned by the database user. Furthermore, database query instructions can be updated without having to change the source code, recode the application, or fine-tune. Therefore, the method of the present invention can provide more flexible and efficient user applications. Printed by the Consumer Cooperatives of the Intellectual Property Bureau of the Ministry of Economic Affairs. The application of the database system exemplified in the present invention is a database information Internet service. Figure 2 shows the general arrangement of the database system. The database management system 42 manages information located in the database 40, including a general data storage form 48 and a query instruction form 46 to store database query instructions used by the user application 44. The user application 44 'such as a Java application' HTML application, or a Java applet executed in an Internet browser, communicates with the database management system 42 through the Internet server 43. The database 40, the database management system 42, and the Internet server 43 can be located in the same system, also on page 9. This paper size applies the Chinese National Standard (CNS) A4 specification (21G x 297 meals) " ' -497051 A7 B7 Printed by the Consumer Cooperatives of the Intellectual Property Bureau of the Ministry of Economic Affairs V. Invention Description () Can be distributed in various systems through the connected network. In operation, when the user application 44 issues a request for access to the database 40, the identification code of the database command (such as a SQL command) is transmitted to the database management system 42. Database management system 42
識別碼當作索引’查Ί句資料庫4 〇中依據識別碼而儲存s Q L 指令的查詢指令表單46。資料庫管理系統42將任何從用 戶應用程式所接收的參數輸入至所取出的SQL指令中,然 後發出產生的SQL指令至資料庫40中。查詢指令的查詢 結果便透過網際網路伺服器4 3傳回至用戶應用程式4 4, 然後用戶應用程式將資訊格式化,並顯示給使用者。 在一較佳之實施例中,用戶應用程式44與網際網路 伺服器43透過廣域網路(Wide are a net work)溝通,如網際 網路,網際網路伺服器43則透過區域網路與資料庫管理 系統42溝通。而且,資料庫管理系統42是以資料庫伺服 器上所執行的資料庫Java儲存程序(Java st〇red prMedM幻 來實現的,而網際網路伺服器是以網際網路伺服器 servlet來實現的。Java servlet的作用猶如一安全的通道, 可由網際網路的用戶應用程式44 一直通到位於資料庫飼 服器中的資料庫管理系統42。因此,查詢指令的字串便被The identification code is used as an index, and the query command form 46 storing the sQL instruction according to the identification code is stored in the query database 4. The database management system 42 inputs any parameters received from the user application into the retrieved SQL command, and then issues the generated SQL command to the database 40. The query result of the query command is returned to the user application 4 4 through the Internet server 4 3, and then the user application formats the information and displays it to the user. In a preferred embodiment, the user application 44 communicates with the Internet server 43 through a wide area network (Wide are a net work), such as the Internet, and the Internet server 43 communicates with the database through a local area network. The management system 42 communicates. Moreover, the database management system 42 is implemented by a database Java stored procedure (Java st predMedM) executed on a database server, and the Internet server is implemented by an Internet server servlet The Java servlet acts as a secure channel, from user applications 44 on the Internet all the way to the database management system 42 in the database server. Therefore, the query command string is
Java儲存程序所取得,java儲存程序在資料庫伺服器中執 行的方式猶如插入(plug-in)。在資料庫伺服器中執行查詢 指令,系統的效能大約比使用區域塑的咨社由^ ^ % 土的貝枓庫系统提高了 1〇倍。另外’系統效能不會因為在網路上發出額外^詢 指令以存取查詢指令的字串而降低。 第10頁 (請先閱讀背面之注意事項再填寫本頁) 訂---------線赢 經濟部智慧財產局員工消費合作社印製 497051 A7 ________B7 五、發明說明() 由於貫際發出給資料庫的SQL指令是由儲存在查詢 指令表單中的SQL指令所導出來的,因此SQL指令可以 藉由更改由識別碼所指之Sql指令而隨時更改。另外,網 際網路服務將可自動開始使用任何放在查詢指令表單中 新的SQL指令,而不會降低伺服器的效能。從查詢指令表 單中存取SQL指令所須的額外時間可以被忽略,因為查詢 指令表單只有兩欄(column),且一般少於1〇〇列(r〇w)的資 料。 , 為了說明的目的,本發明之實施例在Sql環境中查詢 資料庫的方法,可參考第3圖的流程圖來詳細說明。起初, 資料庫用戶應用程式ClientApp,及SQL指令中的識別碼 ID及其它參數 PARMS的呼叫,可以透過指令: ”(:以1^八??(10 = 1,?八113 = ’’3(^1^〇11”)’’(步驟320)。用戶 應用程式發出查詢的指令:',select SQL from SQLTBL where ID = ;T至資料庫管理系統,以存取符合於識別碼id 的SQL指令。(SQL指令表單SQLTBL的前兩列顯示於下 方的表一中。) 接下來,資料庫管理系統回覆所需求之SQL指令: 丨’select name, serialN umber from employee where workLocation = ? for read only”,至用戶應用程式(步驟 S24)。然後,用戶應用程式將所有在回覆的SQL指令中的 空白處(如”?’’),以所接收到的參數PARMS來取代(步驟 S26),然後發出完成後的SQL指令至資料庫管理系統: ’’select name , serialNumber from employee where 第11頁 本紙張尺度適用中國國家標準(CNS)A4規格(210 X 297公釐) -----I--------------訂 —-------I (請先閱讀背面之注意事項再填寫本頁) 經濟部智慧財產局員工消費合作社印製 497051 A7 B7 五、發明說明() workLoaction=丨’Boca Raton,,for read only,,(步賢 蚨 S 2 8)然 後’資料庫管理系統回覆所發出之查詢指令的結果,(即 符合的姓名與序號)至用戶應用程式(步驟S3〇),用戶應用 程式回覆,或將結果顯示給使用者以作象佳 尸义延一步的處理 (步驟S32)。 表一:SQL指令表單(SQLTBL) ID SQL指令 , 1 select name, serialNumber from employee where workLocation = ? For read only 2 insert into employee(name,serialNumber)v ” 如先前所述’本發明使用一個資料庫表單以儲存資料 庫用戶應用程式所使用之資料庫查詢指令。資料庫用戶庭 用程式在執行的時間(run time)中存取資料庫表單中的杳 询指令。由於#料庫的查询指令(如S Q L指令)可以在資料 庫的表單中存取,因此並不須由的原始碼更改及重新編碼 來對用戶應用程式的查詢指令作更改。因此,資料庫的查 詢指令可以由資料庫管理者在資料庫的表單中作更新,而 不須應用程式之供應商的協助。而且,使用資料庫的杏^句 指令表單,可以將資料庫的查詢指令在用戶端特製化並最 佳化,以提供最好的功能及最有效率的效能。 當用戶應用程式所使用之資料庫查詢,指令儲存在資 料庫的表單中時’因用戶環境改變的資料庫效能微調程序 第12頁 本紙張尺度適用中國國家標準(CNS)A4規格(210 X 297公釐) ---------------I----^--------- (請先閱讀背面之注意事項再填寫本頁) 丄 A7 B7 經濟部智慧財產局員工消費合作社印製 五、發明說明( 亦簡化了。特別的是,軍 、 萄的且詢指令可隨時更改,而不 須應用程式供應商的協助。 、 甚且’儲存查詢的指令於一資 料庫的表單中,也使捲彳欠 ’ 4改可由一個人來操作(如資料 管理者),因此修改的成太A t 成本也降低了。同樣,資料庫查詢 指令的更改並不須改蠻屌 又原七碼,所以也不會有不小心對應 用程式的程式碼造成問題的機會。 因為且珣私令的更改不必改變原始碼也不必重 新編碼’所以查詢指A可 二 7 了,以互即有效地更新,而且不會使 應用私式停擺。這對使用老丄 1更用率尚或急迫性高的應用程式而 口更疋有利而且,因為資料庫查詢指令儲存在資料庫 的表單中戶斤以查詢指令便自動地與資料庫資訊儲存在一 起因此€料庫查狗指令便與資料庫的資訊同步地被保 存而且因為應用考王式本身不須被儲存,戶斤以儲存的程序 也簡化了。 資料庫查詢指令儲存在資料庫的表單中也使得查詢 指令可以被微調,而使應用程式可與客戶所使用的特定資 料庫平台正常且有效率的運作。同樣地,應用程式可當做 般用途的應用程式來編寫。因此,應用程式可用來當作 資料庫介面層,以溝通不同的資料庫平台及其它須要存取 琢資料庫的產品。總之,本發明提出了可依據特殊用戶的 須要來調整之有彈性的資料庫用戶應用程式。 本發明之資料庫系統可以硬體,軟體或兩者的結合來 貫現。例如’本系統中至少有一部份可以用儲存在電腦可 渭取之媒體(如,磁碟,光碟,或非揮發性的記憶體)的軟 第13頁 本紙張尺度適用中國國家標準(CNS)A4規格(210 X 297公釐) --------------------訂---------線 (請先閱讀背面之注意事項再填寫本頁) 497051 的 經濟部智慧財產局員工消費合作社印製 而 該 明Obtained by the Java stored procedure, the Java stored procedure is executed in the database server like a plug-in. When the query command is executed in the database server, the performance of the system is approximately 10 times higher than that of the Beibei library system using ^^^% soil. In addition, the system performance will not be degraded by issuing additional ^ query commands on the network to access the query command string. Page 10 (Please read the precautions on the back before filling this page) Order --------- Printed by the Consumer Property Cooperative of the Intellectual Property Bureau of the Ministry of Economic Affairs, printed 497051 A7 ________B7 V. Description of the invention () The SQL command issued to the database is derived from the SQL command stored in the query command form, so the SQL command can be changed at any time by changing the Sql command indicated by the identification code. In addition, the Internet service will automatically start using any new SQL commands placed in the query command form without degrading server performance. The extra time required to access the SQL instruction from the query instruction list can be ignored, because the query instruction form has only two columns and is generally less than 100 columns of data. For the purpose of illustration, the method for querying a database in a Sql environment according to an embodiment of the present invention may be described in detail with reference to the flowchart in FIG. 3. Initially, the database user application ClientApp, and the ID ID and other parameters of the SQL command called PARMS, can be called via the command: "(: with 1 ^ eight? (10 = 1,? Eight 113 =` `3 ( ^ 1 ^ 〇11 ")" (step 320). The user application issues a query command: ', select SQL from SQLTBL where ID =; T to the database management system to access the SQL command that matches the id (The first two columns of the SQL command form SQLTBL are shown in Table 1 below.) Next, the database management system responds to the required SQL command: 丨 'select name, serialN umber from employee where workLocation =? For read only " To the user application (step S24). Then, the user application replaces all blank spaces (such as "?") In the response SQL command with the received parameter PARMS (step S26), and then sends The completed SQL instructions are sent to the database management system: '' select name, serialNumber from employee where page 11 This paper size applies the Chinese National Standard (CNS) A4 specification (210 X 297 mm) --- --I -------------- Order --------- I (Please read the precautions on the back before filling out this page) Printed by the Consumer Cooperatives of the Intellectual Property Bureau of the Ministry of Economic Affairs 497051 A7 B7 V. Description of the invention () workLoaction = 丨 'Boca Raton ,, for read only ,, (step Xian 蚨 S 2 8) and then' Database management system responds to the result of the query instruction issued, (that is, the name of the match And serial number) to the user application (step S30), the user application responds, or displays the result to the user for further processing (step S32). Table 1: SQL Command Form (SQLTBL) ID SQL command, 1 select name, serialNumber from employee where workLocation =? For read only 2 insert into employee (name, serialNumber) v ”As mentioned earlier, the present invention uses a database form to store the database user application used Database query instructions. Database user programs access query instructions in database forms during run time. Because #material library query instructions (such as SQL commands) can be used in database forms Save And therefore does not change the source code and shall be re-coded to make changes to the query command user application. Therefore, the database query command can be updated by the database manager in the database form without the assistance of the application vendor. In addition, using the database command form, the database query command can be customized and optimized on the client side to provide the best functions and the most efficient performance. When the database used by the user application is queried and the instructions are stored in the database form, the database performance fine-tuning procedure due to changes in the user's environment Page 12 This paper size applies Chinese National Standard (CNS) A4 specification (210 X 297 Mm) --------------- I ---- ^ --------- (Please read the notes on the back before filling this page) 丄 A7 B7 Economy Printed by the Consumer Cooperatives of the Ministry of Intellectual Property Bureau 5. Invention description (also simplified. In particular, the military and public information instructions can be changed at any time without the assistance of the application provider. The instructions in a database form also make the volume owed '4 can be operated by one person (such as the data manager), so the cost of modifying the Attachment is also reduced. Similarly, the changes to the database query instructions are not Must be changed to the original seven yards, so there will be no chance of accidentally causing problems to the application code. Because the change of the private order does not need to change the original code or re-encoding ', the query refers to A may 2 7 To effectively update each other and not Make the application private. This is more conducive to using the old application 1 which is more popular or urgent. Also, because the database query command is stored in the database form, the user can automatically query the command. It is stored with the database information, so the database check dog command is saved in synchronization with the database information, and because the application of the test king style itself does not need to be stored, the procedure for storing data is simplified. Database query instructions The form stored in the database also allows the query instructions to be fine-tuned, so that the application can operate normally and efficiently with the specific database platform used by the customer. Similarly, the application can be written as a general-purpose application . Therefore, the application program can be used as a database interface layer to communicate with different database platforms and other products that need to access the database. In short, the present invention proposes a flexible, which can be adjusted according to the needs of special users. Database user application. The database system of the present invention can be implemented in hardware, software, or a combination of both. For example, 'this At least part of the system can be stored in computer-accessible media (such as magnetic disks, optical disks, or non-volatile memory). Page 13 This paper applies the Chinese National Standard (CNS) A4 specification ( 210 X 297 mm) -------------------- Order --------- line (Please read the precautions on the back before filling this page) 497051 printed by the Consumer Cooperative of the Intellectual Property Bureau of the Ministry of Economic Affairs
(請先閱讀背面之注意事項再填寫本頁) A7 B7 五、發明說明( 體程式來實現,以被電腦執 紡了、,+ 仃冋樣,至少有一部份的系 一 。4用戶中被實施,如第4圖所 不。另外,如上所述之虚资拉 〃、枓庫系統相關的本發明之實施 例係在SQL的環境中操作。炊 …、而,本發明之系統並不限制 :此㈣,而且可以利用其它的語言,在任何型 路上’或單獨的電腦上使用。其它設計上的選擇,如資料 查詢指令的號碼及型態’資料庫的查詢指令表單… 以及從資料庫存取查詢指,令及資" J少驟,也可適用。 且,本發明之實施例可以不包括所有上述之特徵。 以上所述僅為本發明之較佳實施例而已; 項技藝者對本發明之修改,及均等之變化,皆屬^、σ 之範圍内。另外,依據本發明所述 發 心万法,可作許多 改以適用於特殊的情況,而不達 工逆 < 本發明 神。因此,本發明之範圍並不以上述 貝她例為限 依本發明所作之所有的實施例,皆仍屬本發明專利 之範圍内。 第 14Ί* 本紙張尺度適用中國國家標準(CNS)A4規格(21〇 χ 297公釐)(Please read the precautions on the back before filling this page) A7 B7 V. Description of the invention (The program is implemented by the computer, + + sample, at least part of the system is one. 4 users The implementation is as shown in Fig. 4. In addition, the embodiments of the present invention related to the virtual capital system and the library system described above are operated in a SQL environment. However, the system of the present invention is not limited. : This, and can be used in other languages, on any model 'or on a separate computer. Other design choices, such as the data query command number and type' database query command form ... and from the data inventory The query instructions, orders and information are also applicable. Moreover, the embodiments of the present invention may not include all of the above-mentioned features. The above description is only the preferred embodiments of the present invention. Modifications of the invention, and equivalent changes, are within the scope of ^ and σ. In addition, according to the invention of the invention, many changes can be made to apply to special situations without reaching the adverse conditions < the invention God. So The scope of the present invention is not limited to the above-mentioned Beta examples. All the embodiments made according to the present invention are still within the scope of the patent of the present invention. Article 14Ί * This paper size applies the Chinese National Standard (CNS) A4 specification 21〇χ 297 mm)