Method and device for accessing database

Abstract

A method for calling on databank includes receiving databank operation information by package layer of databank application program interface then generating structure query language and calling on databank by said package layer of databank application program interface according said databank operation information.

Description

technical field [0001] The invention relates to database technology, in particular to a database access method and device. Background technique [0002] At present, when telecommunications and other fields conduct their respective businesses, a large amount of data needs to be processed. For this kind of system that requires high data processing performance and has a large number of on-site customized development tasks, it is convenient and efficient to use a The database access mechanism is very necessary. At present, there are many solutions for encapsulating database access mechanisms in the industry, such as the O-R (object-relational) mapping mechanism of enterprise-level Java Beans (EJB) container management persistence, and the iBATIS SQL Maps mechanism And dormancy (hibernate) mechanism. [0003] However, each solution has its limitations: [0004] The O-R mapping mechanism of EJB's container-managed persistence does not allow the use of database-specific properti...

AI Technical Summary

Problems solved by technology

This method has a relatively high degree of automation, but because of the automatic generation of SQL statements, the configuration of hibernate tends to be complicated, that is to say, a lot of complicated configurations are required to complete the predetermined functions, especially when dealing with business statistics and multiple There are a lot of configurations and restrictions for businesses such as table association query; moreover, for large-scale systems, the performance of SQL is very critical. At present, the automatically generated SQL statements are still difficult to be intelligent enough to achieve good optimization, so it is necessary to Human intervention in the final SQL statement; In addition, HQL has many restrictions, and learning HQL is not as simple as SQL, so the corresponding use of HQL is not as effective as direct use of SQL

[0019] At present, the development of fields such as the telecom business operation support system (BOSS) not only requires the operation of a large amount of data, but also changes on-site requirements, requiring repeated on-site customized development, and this process often takes hundreds of people and takes several months to complete. , such a long-term and high-intensity on-site custom development work not only consumes a lot of resources of a company, but also makes it difficult to guarantee the quality of work and the progress of the project

In addition to the above-mentioned defects, the existing database access mechanisms are also developed for the purpose of generality, so it will be very difficult to build a business development platform on it.

Images