IBM DB2 and others.pdf - DB2 DB2 is a Data Management...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
DB2 DB2 is a Data Management product from IBM. DB2 offers industry leading performance, scale and reliability on any choice of platform. It is mainly used in LINUX environments. DB2 technologies have the following features embedded in them: 1. Self-maintenance of databases and automation for the database administrators. 2. DB2 supports the standard Web services which are the new style of application processing. 3. Grid computing takes advantage of the clustered scalability of DB2 to support large scale databases & high availability to the large number of simultaneously accessing users. 4. DB2 is part of the infrastructure to support reliable, scalable and secure e-business on demand. 5. Business Intelligence in built into the DB2 engine. 6. DB2 content management supports for the both media asset management and enterprise content management. DB2 lowers the overall cost of managing data by offering the following features: 1. Autonomics 2. Deep Compression 3. Performance 4. Scalability 5. Security 6. Reliability 7. pureXML 8. Multi-vendor SQL and API support 9. Comprehensive Tools 10. Virtualization Advantages offered by DB2: Extensive support options Runs on multiple platforms Scalable for large environments Very stable Arguably fastest for large datasets Supported by many third-party applications Disadvantages of DB2: Can be very expensive Complicated licensing Limited training options Requires "hands on" administration Limited add-on tools
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Oracle Oracle is the first commercially available relational database management system (RDBMS). Below is the list of Oracle releases along with the year of release. Release Year Oracle6 1988 Oracle7 1992 Oracle8 1997 Oracle8i 1998 Oracle9i 2001 Oracle10g 2003 Oracle11g 2007 Oracle had included a number of capabilities into the Oracle 11g like self-tuning which include automated storage and memory management and intelligent tuning advisors. The most important 11g new automation features are: 1. Automatic Memory Tuning: In 11g all the memory can be tuned automatically by setting one parameter. 2. SQL Performance Analyzer : 11g automatically apply SQL profiles for statement which give 3-times better performance than the existing statement. 3. Automated Storage Load Balancing : Optimal Load balancing is achieved by allowing single storage pool to be shared by multiple databases. 4. Automatic Diagnostic Repository: An “incident” ticket is automatically raised to notify the DBA, when critical errors are detected. Oracle RAC/Grid Features: 1. RAC instance load balancing : Oracle JDBC provides connection pool load balancing facilities through the new Load Balancing Advisory tool.
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern