IBM(2009) states that there is an e-commerce associated with their database product named DB2 that can connect with a web server to create robust, high-volume e-commerce applications. DB2 Connect provides several solutions that improve web-based application performance. Stored procedures allow DB2 Connect users to reduce the number of queries being sent to the database, furthermore, IBM offers a program suite that is DB2(R) Universal Database that supports all the key Internet standards, making it an ideal database for use on the Web. It has in-memory speed to facilitate Internet searches and complex text matching combined with the scalability and availability characteristics of a relational database. Because DB2 Universal Database supports WebSphere(R), Java(TM) and XML Extender, it makes it easy for you to deploy your e-business applications. In additional, DB2 Universal Developer's Edition has several tools that provide Web enablement support. WebSphere Studio Application Developer, Version 4, is an integrated development environment (IDE) that enables you to build, test, and deploy Java applications to a WebSphere Application Server and DB2 Universal Database. WebSphere Studio is a suite of tools that brings all aspects of Web site development into a common interface. WebSphere Application Server Advanced Edition (single-server) provides a robust deployment environment for e-business applications. Its components let you build and deploy personalized, dynamic Web content quickly and easily.
IBM 's DB2 compares with mysql, in details, please refer IBM web site at http://www.ibm.com/developerworks/data/library/techarticle/dm-0602tham2/
a.) Container comparision between DB2 and MySQL
Depending on the table type being used, MySQL stores data in either single files, multiple files, or tablespaces.
In contrast to MySQL, DB2 Express stores everything in tablespaces. Tablespaces are logical representations of physical containers in filesystems, DB2 database structure is laid out in this fashion, with each layer in the hierarchy to represent the following that is better than MySQL.
b.) Availabilty comparision between DB2 and MySQL
MySQL supports user-defined functions, store procedure, views, updateable views, triggers and DB2 supports user-defined table, user-defined functions, user-defined data types, store procedure, views, updateable views, triggers, recursive SQL, squences. So DB2 is more powerful than MySQL.
Oracle(2009) states that there is an e-commerce associated with their database product , that is using “Oracle E-Business Suite On Demand” which offers business benefits that give you enhanced security and compliance as well as improved system scalability, performance, and availability. It also provides change management services, including product updates and upgrade processes that are engineered to give you access to the latest product innovations and capabilities. Oracle experts use Information Technology Infrastructure Library (ITIL)–based processes and automation to manage your software on proven configurations across the entire Oracle technology stack.
Oracle On Demand delivers the following core services designed specifically for Oracle E-Business Suite:
• Infrastructure management—Provides, manages, and maintains hardware, network
connections, and facilities for customers
• Software management—Uses a closed loop process with Oracle experts to solve
customer problems quickly, along with rootcause analysis to avoid problems altogether
• Security management—Manages the security tools, processes, and precautions
that protect the privacy and security of customer data and solutions
• Service level management—Provides a service-desk escalation process, meets service levels, and then measures and reports results directly through customer portals
• IT governance—Provides a service delivery manager to work closely with customers, resolve problems, plan and execute changes, and keep customer IT solutions aligned with the business.
There are many points of comparison between Oracle and mysql, in detail, please refer oracle web site at http://download.oracle.com/docs/cd/E12151_01/doc.150/e12155/oracle_mysql_compared.htm
a. Database Authentication Comparsion between Oracle and MySQL
MySQL is unlike Oracle (when set up to use database authentication) and most other databases that use only the user name and password to authenticate a user, MySQL uses an additional location parameter when authenticating a user. This location parameter is usually the host name, IP address, or a wildcard (Ò%Ó). With this additional parameter, MySQL may further restrict a user access to the database to a particular host or hosts in a domain. Moreover, this also allows a different password and set of privileges to be enforced for a user depending on the host from which the connection is made. Thus, user scott, who logs on from abc.com may or may not the same as user scott who logs on from xyz.com. It seems MySQL that is flexible but it’s not secure.
b. Privileges Comparsion between Oracle and MySQL
MySQL is unlike in Oracle, there is no concept of role in MySQL. Thus, in order to grant a group of users the same set of privileges, the privileges have to be granted to each user separately. Alternately, though less satisfactory for auditing, users performing tasks as a role may all share a single user account that is designated for the "role" and with the required privileges granted. So Oracle is easy to define the privileges by role than MySQL.
Microsoft (2009) states that there is an e-commerce associated with their database product named Microsoft® SQL Server™ that is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions. SQL Server 2008, the latest version, includes enhanced XML support, integration of .NET Framework objects in databases, improved integration with Microsoft Visual Studio and the Microsoft Office System, as well as improved analysis, reporting, and data integration services, that offers a comprehensive suits for e-commerce development. Refer to Microsoft official web site (http://www.microsoft.com/sqlserver/2008/en/us/compare-mysql.aspx#partner) that has an article titled “Compare SQL Server to MySQL”,
states that Microsoft SQL Server 2008 outperforms MySQL as a database platform in all business-critical areas. It provides a large resource network, industry-leading performance and enterprise-ready scalability, the highest level of security, the highest availability, a comprehensive Business Intelligence (BI) platform—all at a low total cost of ownership (TCO). Moreover,Microsoft SQL Server 2008 has fully compared with MySQL with the following points:
· Partner Ecosystem
· Scalability
· Security
· High Availability
· Business Intelligence
· Total Cost of Ownership (TCO)
Sybase (2003) states that there is an e-commerce associated with their database product named Sybase Communications e-Business Solution (CeBs) is a suite of e-Care and e-Commerce applications with a vertical focus in Communications. With Communications e-Business Solution, Communications Service Providers can tap the cost savings, personalization, and efficiency of Web-based self-service through simplified browser-based access to business support systems for customers, channel partners, and employees. However, Sybase Communications e-Business Solution (CeBs) is no longer offered by Sybase.
Sybase does a performance Comparison between their product named ASE 15 and MySQL 5.0, and it states that Adaptive Server® Enterprise (ASE) is a highly scalable, mission critical database server that provides a portable, multi-platform system for high performance data management. The new features of ASE 15.0 deliver an operational advantage with lower cost and risk, and they achieve higher performance on mixed workload systems. Testing with ASE 15.0 has shown an advantage in overall performance for transaction processing over MySQL 5.0, and many complex queries show significant improvements. For more details, please refer to Sybase official article at http://www.sybase.com/detail?id=1045499
References:
IBM (2009). “DB2 Connect and web applications”. Received 24th March, 2009 from URL - http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/wareh/getsta06im.htm
ORACLE (2008). “Improve Your Business Performance with Oracle E-Business Suite On Demand” . Received 24th March, 2009 from URL - http://www.oracle.com/ondemand/collateral/oracle-e-business-suite-on-demand-brief.pdf
Microsoft (2009). “Microsoft SQL Server” . Received 24th March, 2009 from URL -
http://technet.microsoft.com/en-us/library/bb545450.aspx
Sybase(2003), “Communications e-Business Solution”. Received 24th March, 2009 from URL -
http://www.sybase.com/products/archivedproducts/communicationse-businesssolution
沒有留言:
發佈留言