The development of database technology presents a new trend __ database

The development of database technology presents a new trend2006.01.18 from: Sadie

In the last two years, with the development of database technology and the advent of more high-performance CPUs, the user's attention to the performance of the database is decreasing, but the requirement for the reliability of database products, the integration of business and the total cost of ownership (TCO) of new products is increasing. In other words, the buyer's choice will depend on the product's overall performance, ease of use and price advantage, this is a new fierce battlefield in the commanding heights.

The development of database technology, but also presents some new trends.

　　provide continuous data availability

Building a high-availability IT infrastructure is critical to all businesses that want to remain invincible and successful in today's fast-changing economic environment.

As the market leader in the database, Oracle has enhanced the RAC technology in its latest version of the 10g database. In its latest database SQL Server 2005, Microsoft leverages features such as database mirroring, failover clustering, and improved online operations to minimize downtime and help ensure that the enterprise system receives access calls at any time.

　　scalability of the system with low cost

Most of the enterprise's major application systems have dedicated storage and server, so the traditional layout, individual looks like the effect is good. But the consequence is to pay a high price to meet the maintenance of a large number of systems, and due to the increase in fault nodes, the system is more prone to failure.

In addition, because a single system must be large enough to accommodate peak capacity, resources are difficult to move from one system to another, resulting in large amounts of idle enterprise storage and CPU resources. Analysts believe that the current enterprise-internal general memory utilization is only 50%, and CPU utilization is poor 15-20%.

　　ensure security under the Internet architecture

The enterprise will apply the architecture on the Internet platform, all face how to protect the data security problem under the Internet architecture. The large database vendors sniff the huge business opportunities and strengthen the data security support of their database products.

Oracle's 10g version of the storage data encryption, virtual private database, Label security and other technologies; Microsoft SQL Server 2005 through database encryption, default security settings, password policy implementation, Granular permission control and enhanced security model and other functional features for enterprise data to provide the highest level of security, is one of the best.

　　Integrated Business Intelligence features

In most enterprises, the deployment of business intelligence applications is divided along technical lines. The deployment of less complex reports and ad hoc query tools typically uses data warehouses and sql-based reporting tools, while more complex analysis and planning applications are deployed using other special databases and tools.

In addition to the major manufacturers have strengthened their online analysis products, reporting tools, ETL tool functions, but also try to integrate these things in a complete database platform. So that the database product is no longer just to provide the general data storage functions, but can provide from the data storage to the use of data analysis of the overall solution.

　　simplify the management of databases

Today, the business environment is becoming increasingly competitive, and managing the Information Technology (IT) infrastructure is a challenge for the enterprise at the lowest cost and not at the expense of lowering service levels.

More and more users hope that the database products can manage themselves, and can automatically monitor, adapt and adjust themselves, thus significantly reducing the number of IT managers and reducing the ability of management cost integration.