Application of Java Technology in Dynamic Web Database Technology

With the development of Internet technology, Java has been applied to a variety of software design, including Database technology (hereinafter referred to as DT), web technology, which can enhance enterprise information and data management. DT can improve the efficient operation of information system, which needs to ensure the access performance of database. With the rapid increase of data volume, the data transmission between dynamic web pages is busy, which will lead to more and more database data access. Therefore, we have higher and higher requirements for dynamic web DT, which requires fast and efficient data interaction with server database. Java is one of the most commonly used programming software, which can solve many problems of dynamic web database. Therefore, more and more attention has been paid to the research of database optimization technology by Java.


Introduction
In the past decade, with the acceleration of the process of global economic integration. The practicality of Internet technology is a catalyst. In the 21st century, we have entered a new era of "Internet economy" [1] . At present, individuals, groups and enterprises must interact with each other through interconnection, so as to seek development or seek opportunities. Internet economy is an economy carried out through it technology, which can provide employees, customers and partners with the best way to connect. We can obtain the information through the Internet without the support of technology [2] . At the same time, in the Internet environment, people are no longer satisfied with the status quo of static hypertext mode for database applications, which can obtain static query results such as text, pictures and so on through the browser. Through Internet technology, we can put forward higher requirements for the interactivity of database applications. Java technology can better solve the problem of dynamic web DT, this paper mainly introduces the current application [3] .

Database connection pool technology
The first step of database access is to establish a connection with the database, and the last step is to disconnect from the database. Therefore, database connection plays an important role in database access. Each connection must complete user authentication, security context configuration and other tasks, which need to occupy a certain amount of communication and memory resources. Therefore, database access technology is often the most time-consuming operation. Therefore, the database connection should choose the best connection mode, which can greatly improve the database performance of the system [6] .
Database connection pool is a better database connection technology than JDBC direct connection technology. By establishing a buffer pool, we can store a certain number of database connection objects in it. Before the system accesses the database, we can request a database connection object from the connection pool. If there are free connection objects in the connection pool, the connection pool will allocate the idle objects to the system. After the system accesses the database, the connection pool releases the database connection and reclaims it. The core idea of database connection pool is connection reuse. Connection pool has its own mechanism, which can establish, manage and close connection objects. By controlling the number of connection objects and the duration of connection, connection pool will recycle the connection objects released after use to the connection pool for reuse, which can avoid frequent database connection establishment and closing in database access [7] . By

SQL statement tuning technology
SQL is a standard computer language for accessing and processing databases. Under the condition of ensuring the correctness of SQL statement, we can adjust and optimize it properly, which can greatly save the time needed for the system to access the database. By changing the format of SQL statement, we can reduce the amount of data to be scanned in table query, which will find out the best query path. There are many subtle points in SQL statement tuning technology, which may affect the performance of the whole SQL statement. The most commonly used optimization methods for SQL are as follows. First, filter and then connect. According to the query criteria, we can filter out a large number of data in the table to be joined. Then, through the union of multiple tables, there is no need to re filter all the data. Second, avoid subqueries. Subquery is to query all data in another table under one condition. Therefore, the amount of data will be the product of two tables. If there is another level of nesting, the data flow will increase dramatically, which will lead to more inefficiency. SQL can avoid subqueries as much as possible, which can increase the speed of checking. Third, if subqueries are unavoidable, you need to filter as much data as possible using filter conditions. In MySQL database, the parsing order of where statement is from left to right without index. The more detailed the query conditions, the more data records can be filtered out, which will avoid full table scanning. actual object. This object relationship is registered in the registration form of RMI. The caller finds the corresponding object through the name of the object and calls its method without considering the physical storage location of the object. This not only conforms to people's usage habits, but also improves the scalability and robustness of the system. RMI registers the names of multiple RMI objects in the same register (listening to a port). One object has one or more methods for remote call, so that one port can provide multiple services and save the port resources of the system.

Java IDL
Java IDL can realize the interaction between objects on different platforms on the network. The technology is based on CORBA specification of common object request broker architecture. IDL is a language independent interface definition language. All CORBA supported languages have IDL to language mapping. Java IDL supports mapping to the Java language. With Java IDL, CORBA objects can be defined, implemented and accessed in Java. For each java compiler, it generates a java interface and other necessary java files, including a client-side stub and a server-side skeleton. Through Java IDL, objects written in non Java language can be called remotely. Java IDL uses CORBA II IOP protocol. IIOP protocol can make objects generated in different languages on different platforms communicate in a standard way. In Java IDL, the client interacts with the remote object through the reference of the target object, that is, the client uses the stake to operate the object on the remote server, but does not copy the object on the server. Java IDL can ensure seamless interoperability and connectivity in heterogeneous computing.

Conclusion
After the database management is given the web interactive interface, its storage management will rise to a new height, which allows authorized persons to operate in the database. As the advantages of dynamic web database are widely recognized, such as unified standards, simple development process, cross platform support and so on, developers more and more like to use java to program. This paper mainly discusses the application of Java technology in dynamic web DT.