Oracle Database Synchronization

Oracle user status

Currently, databases, especially Oracle databases, are used in many industries. However, many enterprises seldom invest in database management and maintenance. The actual problems are self-evident:

1. DBAs have worked very hard to constantly optimize databases based on limited networks and hardware, hoping to increase performance.

2. database developers keep writing complicated SQL statements to meet the ever-increasing database statistics and analysis functions, and the database operation speed is getting slower and slower.

3. The business staff constantly raise query statistics and analysis requirements, complaining about the speed and query response time developed by the technical staff.

4. The boss keeps worrying about hardware upgrades, network upgrades, database upgrades, database tuning, and database maintenance.

It seems that many users who use Oracle databases are worried about the above chores. Some users even simply change Oracle to another database, the original intention is that Oracle requires too much maintenance work and requires too many technical requirements, and Oracle's requirements for machines are constantly increasing, these bring the IT systems that provide services into the high-cost vortex.

Cost reduction from Database Synchronization

In any case, Oracle is the most trusted database vendor, and many users still want to continue using it. But how can we resolve the crisis mentioned above? Currently, Oracle manufacturers are also developing Database Synchronization strategies for users to save more users who are struggling with costs.

Can Database Synchronization change the current situation in essence?

Why Does Oracle propose this solution?

In fact, Database Synchronization is no longer a new concept, from 911 incidents 10 years ago to 311 nuclear radiation last year, database Synchronization began to appear in the database application field as a key Technology for Hot disaster recovery. At that time, the requirement was that the application core database needs to be synchronized to another or several places in real time to prevent the occurrence of disasters, so that the backup database can be used in time when a disaster occurs.

However, such an application is not enough, because the demand for hot disaster recovery is only for group enterprises, large financial institutions, and multinational companies. The demands of other small and medium enterprises are not so urgent, however, with the increase of Data and Applications, databases are getting slower and slower for small and medium-sized enterprises. Many applications are currently very complex data statistics and analysis, occupying very serious system resources.

How can Database Synchronization solve this problem?

For large Oracle Applications, statistical analysis functions are independent from the application system, and important real-time data security Query Systems (VIDRSQS) are established ), this ensures that the processing speed of the application system is the highest under the current hardware network conditions, the Database Synchronization Technology must be able to copy the data that requires statistical analysis from the application system to another query database in real time to ensure real-time data reliability.

The following functions of synchronization technology are also required:

1. You cannot install programs in the master database.

2. Filter by user name, table, and field (keyword field desensitization)

3. Ability to synchronize large objects (BLOB, CLOB, BFILE, and NCLOB)

4. Synchronize encryption Fields

5. Support for Synchronous log auditing

6. Database initialization without stopping services

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12