Project 3: Databases - Essay Example

Microsoft SQL server has several security features, which include authorization, authentication, auditing, policy based management and transparent data encryption. Database security is the only way of securing the platform and the applications. MSQL has other several features which can be used in any business to work with the data. MSQL can be defined as an engine which retrieves and stores data to the present users. SQL server enhances all the machinery, with the exclusion of the normal language service, which it removed (Ward, 2002).

Microsoft has added many other features which include XML data processing services and the capability to act in the back end service oriented architecture, multiple improvements and more encryption in security and speed. SQL server rounds out many other features and adds completely other new features, such as procedure based management, database warehouse and power shell for SQL server. Other features include; clustering services this is a server operating system operating system that SQL server leverages, and allows you to recuperate instantaneously in different systems.

Extensible markup language, documents can be able data transmit between assorted programs or data, basic XML capabilities which can fully support the native XML storage and dispensation and supporting the XQuery language. Oracle is owned by oracle web center it is built on top of JSF. It contains a set of components for building rich web applications and social sites. Oracle has many advanced features compared to MYSQL and SQL. The features include; easy to use content, authoring and design tools for business users.

Business user creates and can contribute or manage web content in real time, with spontaneous interfaces and drag and drop content authoring and layout capabilities designed for the non technical user. Administrators are empowered in order to create and manage a web sophisticated web presence with simplicity through an advanced interface for power users. Several lines of business are enabled to work together seamlessly through powerful, embattled interfaces to deliver online communications through a wide range of variety mobile and web properties.

Another important feature found in Oracle is an oracle cost optimizer, is an exceptionally sophisticated component which governs the query execution. CBO has changed into the most sophisticated components and has the challenging job evaluating any SQL statement and generating the best execution plan for the declaration (Jarratt, 2004). It determines the implementation speed for every oracle query oracle experts must be aware of how CBO has inclined by oracle external issues, data distribution and statistics.

Microsoft SQL server is among the cheapest and easiest database it is often used by many organizations to store and retrieve data. MSQL, when compared to other databases like Oracle, it's easy to manage and does not have to have gurus in order to manage the database. It is important to note, many of MSQL features do not need you to set up the engine in the SQL server, and they can stand by their own. For example, the reporting services,' this can be used exclusively of SQL server engine. In terms of security Oracle is the best database system to use, however, Oracle is a bit expensive to construct and maintain.

It also needs to equip professional who can be able to settle problems which might arise during the operational process. On the other hand,