Important: Use custom search function to get better results from our thousands of pages

Use " " for compulsory search eg:"electronics seminar" , use -" " for filter something eg: "electronics seminar" -"/tag/" (used for exclude results from tag pages)


 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Technical Comparison of DB2 and MySQL
Post: #1

Technical Comparison of DB2 and MySQL


.pdf  mysql vs db2.PDF (Size: 767.09 KB / Downloads: 382)


Introduction

The database server is a standard part of almost every business these days. Common commercial
databases, such as DB2, Oracle, and Microsoft SQL Server include many features that people
have come to rely on to make their database servers "enterprise worthy". These features include
advanced database utilities, management tools, replication, disaster recovery, and performance
monitoring.
During the past ten years, the open-source community has improved the quality of its software,
making it ready for the enterprise. This popularity in open-source software has also initiated a new
trend: databases are quickly becoming an integral part of the open-source middleware stack such
as LAMP. The functionality of MySQL now makes it a competitor to commercial products such as
DB2 for some applications.


Install:

Being an open source database MySQL install could be binary-based or source-based. However,
DB2 is a binary-based only install. Binary-based installation methods supported by both MySQL
and DB2 are similar and both products support features such as silent installs/de-installs, etc. The
install times for both products can vary based on the edition, and the server your are installing on.

Embedded Capabilities:

Both MySQL and DB2 offer versions that can be embedded in other applications. These versions
have features such as a small disk and memory footprint with lightweight database functionality.
DB2 Cloudscape also includes some advanced offerings for easy embeddability including near
zero management requirements and easy upgrades. We will discuss more about these features in
the following sections.

Positioning Statements:

In commercial applications that require full transactional support including logging or read-intensive
applications, MySQL Pro would be the edition of choice. Open-source projects can choose from
the MySQL standard or MySQL Max flavors for development. In the rare situations where a
commercial application can function with just an in-memory storage engine (data consistency is not
important) MySQL Classic may be used. Clusters support may be included in the MySQL Pro
edition starting v5.0 (ETA mid 2005) however; this has not been announced yet.


Platform Support Comparison


The figure below lists the supported platforms by both MySQL and DB2. Both databases have
similar support models for the distributed platforms. However, DB2 offers a more complete list of
widely used platforms from mobile computing to mainframes.
 

Marked Categories : list of db2 seminar topics, db2 computer seminar topics, mysql and oracle comparison, db2 seminar topics, seminar topic on db2, mysql db2 comparison, mysql seminar topics,

[-]
Quick Reply
Message
Type your reply to this message here.

Image Verification
Image Verification
(case insensitive)
Please enter the text within the image on the left in to the text box below. This process is used to prevent automated posts.

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  viva questions and answers for ecad and vlsi lab jntuh Guest 1 191 Yesterday 10:34 AM
Last Post: jaseela123
  technical seminar topics on ppt cache coherence in distributed file system Guest 1 198 27-07-2017 10:36 AM
Last Post: jaseela123
  project to use newspaper to study and report on shares and dividends Guest 0 211 16-07-2017 12:20 AM
Last Post: Guest
  veri chip technical seminar abstract Guest 0 251 16-07-2017 12:20 AM
Last Post: Guest
Star latest technical topics poster presentation Guest 0 197 16-07-2017 12:20 AM
Last Post: Guest
  technical seminar topics for cse with ppts and documentation Guest 0 172 16-07-2017 12:20 AM
Last Post: Guest
  comparison of atorvastatin with atorvastatin -ezetimibe combination Guest 0 180 16-07-2017 12:20 AM
Last Post: Guest
  redshift rocket technical seminar Guest 0 207 16-07-2017 12:20 AM
Last Post: Guest
  pcb designing technical questions pdf Guest 0 234 16-07-2017 12:20 AM
Last Post: Guest
  ppt on performance and emission characteristics jatropha and pongamia biodiesel Guest 0 0 16-07-2017 12:20 AM
Last Post: Guest
This Page May Contain What is Technical Comparison of DB2 and MySQL And Latest Information/News About Technical Comparison of DB2 and MySQL,If Not ...Use Search to get more info about Technical Comparison of DB2 and MySQL Or Ask Here

Options: