TWI283359B - System for accessing database in object-oriented program - Google Patents

Abstract

A system for accessing database in an object-oriented program (OOP) is disclosed. The present invention comprises a generator, at least one database object, and a database access engine. The at least one database object is generated by the generator according to a database schema. The object-oriented program can access the data in the database by calling the database access engine. With the use of the present invention, the codes written to access database in the object-oriented program can be simplified, the effort for maintaining the codes can be lowered, and the risk and the possibility of the program bugs can be reduced.

Description

I283359

V. INSTRUCTIONS () Field of the Invention: The present invention relates to a system for accessing a database, and particularly to accessing a database in an object-oriented program (〇bject 〇riented pr〇gram; OOP) The system. BACKGROUND OF THE INVENTION: A database is a soft system in which data is stored by a computer. First, the data is organized in a specific manner so that these resources can be effectively stored, searched, and accessed. . (5) The human database is relatively easy to use and manage. However, if it is for a large > repository system that contains many database files, you need to rely on more professional management techniques. For example, how to quickly find customer and order information across the country? How to ensure the correctness of the rounded data? How can I prevent people in different regions from changing the same data at the same time? How to establish the association between database files? How to make the format of each database compatible? If the blocks in different tables in the database are repeated repeatedly, it will cause duplication of data, which will lead to waste of storage media. Conversely, if different data sheets include a unique and common block, the data between the different data sheets can be combined and used by the unique and common unit. For example, the employee-related data sheet may have ', employee profile information, and employee performance data sheet. The two materials tables can have a common block, such as the employee number, to link, and the employee's personal data sheet and the employee's performance data sheet. This kind of database is called the association (Relati〇nal^^.) (Please read the notes on the back and write this page again)

,,|呑

I I I 缭_ 1283359

V. Inventions () (Please read the notes on the back and write this page again.) In the relational database, the data is organized into a data sheet. Each material element in the data table can be in its column ( Rgw) and shed ((3) delete) number to determine its index value. The data in each column represents information that is useful or meaningful to users of commercial or other database. The data in one column of each column of information is Represents a material element with a certain characteristic or attribute. For example, each column in a company's employee database can represent each specific employee. One shed can represent the employee's name and the other column can represent the employee's number. The programmer who builds the database can specify the columns, columns, and other features that define the schema of the relational database based on actual needs. The above-mentioned relational database is controlled by a certain type of programming language. Under the circumstance, the storage and retrieval functions of the data can be performed, and the programming language can be, for example, Structured Query Language (SQL). Because of the structured query Words and related databases are developed and improved at the same time. Therefore, structured query languages can properly process data in relational databases. For example, one of the features of structured query languages is that programmers can Specifying the column of a certain element in a data table and the number of the shed to access this element. In addition, the object-oriented stylized programming method has become popular. The Ministry of Economic Affairs, the Intellectual Property Bureau, the employee consumption cooperative, the printed object-oriented stylization The goal is to reduce the time and expense of developing complex software by building small, reusable code units that can be quickly and easily reorganized and reused to create new ones. Program. The above code unit is called object (0bject). The paper size of this object is applicable to China National Standard (CNS) A4 specification (210X297 mm) 1283359

V. Invention Description () Guided programming language, such as C + +, Kai Yi 4: % ^•丄& can be used in a more intuitive and intuitive way to program + external program . Another ten work. By using objects

Special tools for programming languages, & 4 Μ 4 A exotic features, programmers can write a program to define the soft objects of the stone people, benefit v 4 Gan this ancient also ~ path weight, to simulate the real Some pieces in the world. A soft object can simulate the properties or characteristics of an object in the real world, and in many cases can even simulate its behavior. Therefore, today's client programs in multi-Tier systems typically use the object-oriented language to write the required programs. However, on this f, the interface between the object-oriented programming and the associated database is not perfect. Therefore, when the object-oriented program needs to access the data of the database, it is usually used to access the data in the database by using the embedded structured query language in the object-oriented program. A schematic diagram of a system for accessing a database in an object-oriented program as depicted in the figure. The first _ mainly includes components such as the database 1 and the object-oriented program. The data 庠 is used to store the information required by the user. This information is stored in the database in the form of a number of different data sheets by the programmer. Information such as column names and column numbers is included in each different data sheet. These different material table names and information such as block names and column numbers in each data sheet constitute an abstract concept of the database specification 15. The programmer wants to access the data in the database in the object-oriented program 40 by embedding the structured language code 25 in the object-oriented program. That is to say, the object-oriented program 40 includes at least one program module 5 having various functions, and includes the Chinese National Standard (CNS) A4 specification (210×297 mm) for the paper scale. My family transcribes the sentence t ι〇分佃言言胃10 Inquiry

(Please read the notes on the back and write this page again.

1283359 A7 B7 5 Ministry of Economic Affairs Intellectual Property Bureau Employees Consumption Cooperative Printed Description of Invention (:) Constructs a query language code 25 so that the object-oriented program 40 can access the data in the database 10. However, this approach has a number of disadvantages. First, for the processing of lengthy structured query languages, the structured query language code 25 embedded in the object-oriented program 40 is bound to be difficult to compose. Secondly, the structured query language code 25 embedded in the object-oriented program 40 is difficult to maintain afterwards. Furthermore, due to the grammatical nature of structured query languages, the risks and possibilities for program errors are greatly increased. Therefore, it is necessary to seek a solution. OBJECT AND SUMMARY OF THE INVENTION: In view of the above-described background of the invention, there are many disadvantages in the use of an embedded structured query language in an object-oriented program to access data in a database. First, for the processing of lengthy structured query languages, the process is difficult to write. Second, the completed structured query language code is difficult to maintain afterwards. Furthermore, for structured query language programs, the risks and possibilities for error are extremely high. Accordingly, it is an object of the present invention to provide a system for accessing a database in an object-oriented program that can be used to simplify the code required to access a database in an object-oriented program. Another object of the present invention is to provide a system for accessing a database in an object-oriented program that can be used to reduce the effort required to maintain the code. It is still another object of the present invention to provide a system for accessing a database in an object-oriented program that can be used to reduce the risk and likelihood of program errors. In accordance with the above objects of the present invention, the present invention therefore provides a system for accessing a database in an object-oriented program, the database being applied to a plurality of data sheets of the Chinese National Standard (CNS) A4 specification (210 X 297 mm). (Please read the notes on the back and fill out this page) #· 订. Line A7 B7 Ministry of Economic Affairs Intellectual Property Bureau Staff Consumer Cooperative Printed 1283359 V. Inventions () Forms and information in this database According to a database specification, the database specification includes at least a plurality of data table names in the data table and a plurality of block names in each data table name, wherein the invention is accessed in the object oriented program. The database system includes at least: a generator; at least one database object is generated by the generator according to a database specification of the database, wherein each database object has a plurality of attributes, and the database object and the attribute system respectively correspond to In the above data sheet name and the interception name; and the data inventory retrieval engine is used to accept the object-oriented program call (Call), and according to The attribute of the database object is set to access the data in the database in the object-oriented mode, wherein the database object is embedded in the object-oriented program. DETAILED DESCRIPTION OF THE INVENTION: The present invention relates to a system for accessing a database in an object oriented program. Please refer to the schematic diagram of a system for accessing a database in an object-oriented program according to a preferred embodiment of the present invention. The figure 2 mainly includes components such as a repository 1 1 0, an object orientation program 1 4 〇, a generator 1 2 〇, a database object 130, and a data inventory retrieval engine 16 ,, wherein the generator 120 and the database object 130, and the data inventory taking engine 16 are the main features of the present invention. The database contains the information required by the user. These materials are sorted by the programmer and stored in the database in a number of different data sheets. Each different data sheet also includes information such as block names and column numbers. The information such as the names of the different data sheets and the column names and column numbers in the data sheet constitute the abstract concept of the so-called database specification 丨丨5. This paper scale applies to the Chinese National Standard (CNS) A4 specification (210x297 public interest) (please read the note on the back and write this page again)

A7 B7 Ministry of Economic Affairs Intellectual Property Bureau Employees Consumption Cooperative Printed 1283359 V. Invention Description () The Generating 120 Series Ten Thousand Object Generation Program can be created only at the beginning of the system implementation of the present invention and can be used permanently. Its function is to convert the data table name in the database specification 1 1 5 into the database object 1 3 0 , and the information such as the block name in each data table is the attribute of the database object 130. Therefore, when the programmer needs to design a program for accessing the data in the database 10 in the object orientation program, the program name, field name (〇bject.fieldK) can be inserted. The code is to be reached. For example, if you want to set the value of a field (represented by the name of the database object "), the value of the 'block name 〃 can be written by , the database object name · field name = value (ObjeCt.neld = Value; T code to achieve. In addition, because the database object 1 3 0 is in the form of objects in the object oriented program 14 4 program The module 150 is used, so that the program guide can fully utilize the features of the integrated development environment (IDE) of the program 140. That is, the programmer only needs to be in the object orientation program 140. When inputting, the name of the database object, and the code of the database, the decimal point, the name of the database object will appear immediately after the decimal point, and the available menus will be pulled down. The programmer enters the time and effort of the code and avoids errors caused by typing. As mentioned above, when the programmer wants to access the data in the database 1 1 0 in the object orientation program This is achieved by dropping the > library object 130 in the object orientation program i 40. That is, the object orientation program 14 is in the middle (please read the back note and then fill out this page)

A7 B7 1283359 - —---^ V. Invention Description () ', including at least one program module with different functions 1 $ ,, including > library object 1 3 0, in order to make the object oriented The preliminary setting work of the data can be entered in the program 140. In addition, the object guiding program 140 further includes a data inventory taking engine 16 for performing the actual processing of the data. That is, the function of the data inventory taking engine 160 is a 10,000-use sub-program, which can be established only at the beginning of the implementation of the system of the present invention, and can be used permanently in the future. After the object-oriented program inserts several lines and the code associated with the database object 丨3 ', the data in the database 1 1 实际 will be actually executed by calling the data inventory engine 丨 6〇. Access work. The data inventory fetch engine 160 described above can have all of the functionality of a structured query language. For example, the data inventory retrieval engine 16 can have the function of TransBegin and Transaction End (Dings ransEND). The function of the start of the transaction and the end of the transaction is a necessary function for accessing the data of the database. In this way, when the power is cut off or down, the data of the client and the database can remain consistent. In addition, the data inventory taking engine 16 in the present invention also has functions of Insert, Update, Delete, and Load. Therefore, some of the programs in the data inventory engine of the present invention can be as follows: DB.TransBegin

Objectl.attrl=valuel Objectl.attr2 = value2 DB.Load(Objectl) This paper size applies to China National Standard (CNS) A4 specification (210X297 mm) (fb read the back of the note and write this page again) Ministry of Economics intellectual property Bureau employee consumption cooperative printing

1283359 V. Invention description () A7 B7 DB . Insert (Obj ect2) DB.Update (0bject2) Ministry of Economic Affairs Intellectual Property Bureau employee consumption cooperative printed DB.Delete (Object) DB.TransEnd 〇 so 'by object-oriented program Using the data object 130 in the 140, the data inventory retrieval engine 160 can perform the structured query language during the execution of the program without writing a lengthy, unmaintainable, and error-prone structure in the object orientation program. The language code is queried, and the data in the database 1 can still be accessed in the object orientation program 140. The system for accessing a database in an object-oriented program of the present invention can be applied to various related databases such as 〇racle, DB2, or SqL Server. In addition, the object orientation program in the system of the present invention can be written in a variety of different object oriented programming languages, such as VB or C++. In addition, the actual benefits that the inventors have after applying the system of the present invention to actual program development are as follows. First, the loss due to a program error is reduced by about NT$300,000 per program. Furthermore, the development time of the program is reduced by about 2 person/per program, that is, about 习/5 (the development time of the conventional program is about 1 day/per program). In summary, one of the advantages of the present invention is to provide a system for accessing a database in an object-oriented program, which can be used to simplify the paper-based standard (CNS) A4 specification (21GX297) in the object-oriented program. ' ----^ (Please read the notes on the back and write this page again)

, \ one mouth line

1283359 ... V. Description of the invention () Take the code required to write the database. Another advantage of the present invention is to provide a system for accessing a database in an object-oriented program that can be used to reduce the effort required to maintain the code. Still another advantage of the present invention is to provide a system for accessing a database in an object-oriented program that can be used to reduce the risk and likelihood of program errors. The above description is only for the preferred embodiment of the present invention, and is not intended to limit the scope of the present invention as defined by the present invention; Modifications or modifications are intended to be included in the scope of the claims below. Brief Description of the Drawings: The preferred embodiment of the present invention has been supplemented by the following description of the text, and the J diagram is explained in more detail, wherein: Figure 1 shows the conventional access to data in the object-oriented program. A schematic diagram of a system of libraries; and FIG. 2 is a schematic diagram of a system for accessing a database in an object oriented program in accordance with a preferred embodiment of the present invention. The circle number comparison instructions: 1 〇 database 15 database specifications 2 5 structured query language program 4 0 · object-oriented program 50 program module (poor reading on the back of the note)

Line

Ministry of Economic Affairs Intellectual Property Bureau Staff Consumer Cooperatives Printing 1 1 5 Database Specifications 130 Databases 1 50 Program Modules 11 0 Database 120 Generators 140 Object Orientation Program 160 Data Stock Picking Engine 10 Paper Size Applicable to China Standard (CNS) A4 specification (210X297 public Chu)

Claims (1)

1283359 Sixth, the scope of application for patents 1. The system for accessing the database in the Obj ect-Oriented Program (OP), which is composed of a plurality of data tables (Table), and the data The data in the library is classified according to a database specification (Schema), and the database specification includes at least a plurality of data table names of the data tables and a plurality of field names in each of the data table names, wherein The system includes at least: a generator; a plurality of database objects generated by the generator according to the database specification of the database, wherein each of the database objects has a plurality of attributes' and the databases The object and the attributes correspond to the data table names and the block names respectively; and a data inventory fetching engine is configured to accept a call to an object-oriented program (Call) and according to each of the databases Setting the attributes of the object, accessing the data in the database in the object guiding program, wherein the database objects are embedded in the object guiding process In. 2. The system for accessing the database in the object-oriented program as described in item i of the patent application, wherein one of the programming languages for writing the object-oriented program is C + + 〇 (tb reading the back of the note and then writing the book) Page) Ministry of Economic Affairs, Intellectual Property Bureau, Employees, Consumer Cooperatives, Printing and Savings, ^=0, Chinese-style syllabic course, one-way, one-piece material course, in the direction of the article, the item, the first written in the article, Fan Qieli, Please refer to Shenzhiruku 3 Material B. V is also applicable to China National Standard (CNS) A4 specification (210X297 mm) for this paper scale. 1283359 A8 B8 C8 D8 Ministry of Economic Affairs Intellectual Property Bureau employee consumption cooperative printing VI. Application Patent Scope 4. The system for accessing a database in an object-oriented program as described in claim 1, wherein the database is a Relational database. 5. A system for storing a database in an object-oriented program as described in claim 1 of the patent scope, wherein the database is a 〇racle database. 6. A system for storing a database in an object-oriented program as described in claim 1 of the patent application, wherein the database is a DB2 database. 7. The system for storing a database in an object-oriented program as described in claim 1 of the patent scope, wherein the database is a SQL Server database. 8 · As described in claim 1 of the patent scope, the object storage program is stored in the object-oriented program, wherein the object-oriented program has an integrated development environment (IDE). 9. The system for storing a database in an object-oriented program as described in the scope of the patent application, wherein the data inventory engine has a TransBegin/TransEND function. 10. If you are in the object-oriented program as described in item 1 of the patent application scope (please fill in this page with the precautions for reading the back) -Order. Line paper size applies to China National Standard (CNS) A4 specification (210X297 mm) A8 B8 C8 D8 1283359 VI. System for patent access scope access database, where the data inventory engine has an insert (Insert) Features. Π A system for accessing a database in an object-oriented program as described in claim 1 of the patent application, wherein the data inventory has an update function. 12. The system for accessing a database in an object oriented program as described in claim 1 wherein the data inventory retrieval engine has a delete function. 1 3 · A system for accessing a database in an object-oriented program as described in claim 1 of the patent application, wherein the data inventory retrieval engine has a load function. 14·—— A system for accessing a database in an object-oriented program, comprising at least: a database consisting of a plurality of data tables, the data in the database being classified according to a database specification, wherein The database specification includes at least a plurality of data table names of the data tables and a plurality of field names in each of the data table names; a generator; a plurality of database objects, the database is based on the database The paper size applies to the Chinese National Standard (CNS) A4 specification (210X 297 public). • Subscription · Ministry of Economic Affairs Intellectual Property Bureau employee consumption cooperatives printed 1283359 々, the scope of the application for patent scope database, A忐 - where the mother of the database objects have a plurality of attributes, and the boats, Un AL ^ ^ ^ A library object and the attributes are initially associated with the data table names and the block names; a guide program, wherein the database objects are embedded in the object guide program, and The η-data inventory retrieval engine is configured to accept the call of the object-oriented program, and access the data in the database in the object-oriented program according to the setting of the attributes of each of the database objects. 1 5 · A system for accessing a billet library in an object-oriented program as described in claim 14 of the patent application, in which a program language of the object-oriented program is written 5 . 1 6 · A system for accessing a database in an object-oriented program as described in claim 14 of the patent application, wherein a program language for writing the object-oriented program is VB. 1 7. The system for accessing a database in an object-oriented program as described in claim 14 of the patent application, wherein the database is an associated database. 1 8 · A system for accessing a database in an object-oriented program as described in claim 14 of the patent application, wherein the database is an Oracle database. 14 This paper size is applicable to China National Standard (CNS) A4 specification (210X297 mm) (please read the notes on the back and fill out this page) Ministry of Economic Affairs, Intellectual Property Bureau, Staff and Consumer Cooperatives, Printing ABCD 1283359 ------ VI. Application for Patent Scope • The system for accessing the database in the object-oriented program as described in Item 14 of the Patent Requirement, which The library is a DB2 database. 20. A system for accessing a database in an object-oriented program as described in claim 14 of the patent application, wherein the database is a SQL Server database. 2 1 • A system for accessing a database in an object-oriented program as described in claim 14 of the patent application, wherein the object-oriented program has an integrated development environment. 2 2 . The system for accessing a database in an object-oriented program as described in claim 14 of the patent scope, wherein the data inventory taking engine has a transaction start/transaction end function. Please - first, read the back-to-back matters and then fill out the page in the syllabus, insert the syllabus into the guide, and have a slogan in the syllabus. Such as the library material 23 capital. The Ministry of Energy and Economics, the Intellectual Property Bureau, the staff, the consumer cooperative, the printing, the syllabus, the syllabus, the syllabus, the syllabus, the syllabus, the syllabus, the syllabus, the syllabus, the syllabus Such as the library material 24 capital. The storage of the Chinese-style guides is described in the 4 1X. The following is the application of the Chinese National Standard (CNS) A4 specification (210X297 mm). 9 5 3 3 82 ABCD Ministry of Economics Intellectual Property The Bureau of Employees' Consumer Cooperatives prints a system for applying for a patent-wide access database. The data inventory engine has a deletion function. 26. Accessing the database in the object-oriented program as described in claim 14 System, where the data stock picking engine has a loading function. This paper scale applies to the Chinese National Standard (CNS) A4 specification (210X297 mm). (Notes on the back of the heart.