Free Essay

Week 4 Essay: Comparing Dbms

In: Computers and Technology

Submitted By gonnetwork10
Words 917
Pages 4
PT2520: Database Concepts
Week 4 Essay: Comparing DBMS

Comparing DBMS
What is database management system (DBMS)? Database management system is reliable mean to organize date into a single location that can be searched and updated at any time. By adding all the information in one location or in this case a server you are storing the information for later use. You can than search any information you require and update it or even remove old items from the database. Today there are several different options or providers for a DBMS server. Among the top providers you have Oracle, MySQL, IBM DB, MS SQL Server.
Oracle 12C
Oracle 12C is a cloud base database management system. It supports the following operating systems (OS) Microsoft Windows, Linux, Oracle Solaris and some Unix. It is a web-based interface that stores all the procedures on the Oracle Management Repository. The most recent update was released on September 30, 2014. Some of the benefits of Oracle 12c are the following. Per oracle documentation “It provided a secure multitenant application by adding a layer of abstraction or containerization. It allows you to use the cloud providers for an easy and quick mean to allocate and manage the database across multiple systems and data centers without changing the application”. It also provides a disaster recovery, backup, patching, cloning and upgrading flexibility. Oracle is able to replace or move any information while you use either of the following RMAN, Data Guard, or other Oracle base tools. With PDB’s it consumes less memory than a standalone server. You don’t have to change anything to be able to implement the new PDB’s. It allows easy upgrade functions without having to redo your entire database. The most noted disadvantage is that if one table becomes corrupted it affects all customer on the database. Also the application complexity might also be added in trying to always determine the query of which record you are trying to retrieve.
MySQL
MySQL is another option of a DBMS. MySQL works on Oracle Solaris, Microsoft, Apple OS, IBM AIX and Linux. There are two main version of MySQL you have the Community which is a free version of a Server/Database for personal or small business. There is also the enterprise which is a payed service from oracle for bigger database that is made in mind for bigger business or enterprises. MySQL promises that it is easy to use with the basic knowledge of SQL. It is also secure layers that promise to protect your data. They also promise that it’s fast by making it consume fewer resources. It manages the memory well and prevents memory leak. It also supports several development interfaces i.e. visual studios PHP, Pearl and others. It also supports Novell Cluster Service on Netware. Per DataRealm site the disadvantages of MySQL are: few stability issues, suffers from relatively poor perforce scaling, development is not community driven, and its functionality tends to be heavy dependent on addons.
IBM DB2
This DBMS is able to be used on Microsoft, Linux, Unix, and IBM iSeries OS. DB2 is able to connect to palm-top application to the use mainframe and mini-computer hosting debase. IBM DB2 allows self-configuration. The database its self is ready to use instantly but you can configure it to any way you like. DB2 provides high end security based of the object-based security model that IBM provides. It has digital signing that help prevent unauthorized access, 128 bit data encryption and SSL along with US Government C2 security compliances and auditing. It includes automatic performs tuner that will adjust the system resourced based ont eh predictive analysis. Some disadvantages is that the table relationship is not well adapted to this new demand. It requires a lot of XML file data that is transformed into the type of relationship between the tables.
Microsoft SQL Server
Microsoft SQL Server supports only on Microsoft. That is one of the biggest disadvantages that its based of a single operating system. Some of the main advantages are streamline installation, better perforce features, great security features and excellent data recovery support. Another disadvantage is the cost for the program it’s pretty high up there. Limited compatibility.
My decision
After reviewing all the major options out there I have chosen to use the IBM DB2. The main reason is that it compatible with most operating systems out there to date. It offers top shelf security protection. It is reliable and also able to recover data if corrupted. My other choice would have been Microsoft SQL Server for its great recovery support but with so many operating systems out there I believe that IBM would be a better choice.

References
Mack, J. (2014, May 28) Five Advantages & Disadvantages of MySQL. Retrieved July 12, 2015 https://www.datarealm.com/blog/five-advantages-disadvantages-of-mysql/ Supported Platforms: MySQL Database. (n.d.). Retrieved July 12, 2015. http://www.mysql.com/support/supportedplatforms/database.html
Garrett,, B. (2013, August 1). Introducing Oracle Database 12c: Manage Many Databases as One. Retrieved July 12, 2015 http://www.oracle.com/us/corporate/analystreports/industries/esg-database-12c-research-note-1999799.pdf Hess, K. (2015, May 1). Top 10 Enterprise Database Systems to Consider in 2015. Retrieved July 12, 2015. http://www.serverwatch.com/trends/article.php/3883441/Top-10-Enterprise-Database-Systems-to-Consider.htm IBM DB2 for i. (n.d.). Retrieved July 12, 2015. http://www-03.ibm.com/systems/power/software/i/db2/index.html

Similar Documents

Free Essay

Comparing Dbms

...PT2520: Database Concepts Week 4 Essay: Comparing DBMS ITT Technical Institute – Westminster Walter Gonzales 7/12/15 Comparing DBMS What is database management system (DBMS)? Database management system is reliable mean to organize date into a single location that can be searched and updated at any time. By adding all the information in one location or in this case a server you are storing the information for later use. You can than search any information you require and update it or even remove old items from the database. Today there are several different options or providers for a DBMS server. Among the top providers you have Oracle, MySQL, IBM DB, MS SQL Server. Oracle 12C Oracle 12C is a cloud base database management system. It supports the following operating systems (OS) Microsoft Windows, Linux, Oracle Solaris and some Unix. It is a web-based interface that stores all the procedures on the Oracle Management Repository. The most recent update was released on September 30, 2014. Some of the benefits of Oracle 12c are the following. Per oracle documentation “It provided a secure multitenant application by adding a layer of abstraction or containerization. It allows you to use the cloud providers for an easy and quick mean to allocate and manage the database across multiple systems and data centers without changing the application”. It also provides a disaster recovery, backup, patching, cloning and upgrading flexibility. Oracle is able to replace or move any information...

Words: 926 - Pages: 4

Premium Essay

Management

...EFFECTS OF COMMUNICATION IN MANAGEMENT OF EMPLOYEES IN THE TRANSPORT SECTOR IN KENYA: A CASE STUDY OF AL NASAR TRADING AND TRANSPORTERS LIMITED BY HASSAN ABDIRIZACK MOHAMED A RESEARCH PROPOSAL SUBMITTED IN PARTIAL FULFILLMENT FOR THE REQUIREMENT FOR THE AWARD OF DIPLOMA IN MANAGEMENT (BUSINESS MANAGEMENT OPTION) TO THE KENYA INSTITUTE OF MANAGEMENT MAY 2012 DECLARATION Declaration by the Student This research proposal is my original work and has not been presented to any other examination body. No part of this research should be reproduced without my consent or that of The Kenya Institute of Management. Name: …………………………… Signature: -------------------------Date: -------------------- NRB/DBM/43972 Declaration by the Supervisor This research proposal has been submitted for examination with my approval as The Kenya Institute of Management Supervisor. Name:……………………………. Signature: ……………………… Date: ----------------- Lecturer Supervising For and on behalf of The Kenya Institute of Management Name-----------------------------------------Sign-------------------------------Date----------------- Branch Manager Nairobi DEDICATION This proposal is dedicated to my parents and friends, whose support and encouragement made a strong pillar in my successful completion of the study. ACKNOWLEDGEMENT I acknowledge this research work with a heartfelt...

Words: 9054 - Pages: 37

Premium Essay

Hands on Database

...HANDS-ON DATABASE AN INTRODUCTION TO DATABASE DESIGN AND DEVELOPMENT Steve Conger Seattle Central Community College Prentice Hall Boston Columbus Indianapolis New York San Francisco Upper Saddle River Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto Delhi Mexico City Sao Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo Editorial Director: Sally Yagan Editor in Chief: Eric Svendsen Executive Editor: Bob Horan Product Development Manager: Ashley Santora Editorial Project Manager: Kelly Loftus Editorial Assistant: Jason Calcaño Director of Marketing: Patrice Lumumba Jones Senior Marketing Manager: Anne Fahlgren Marketing Assistant: Melinda Jensen Production Project Manager: Renata Butera Creative Art Director: Jayne Conte Cover Designer: Suzanne Behnke Cover Art: Kheng Guan Toh/Fotolia, Inc Media Editor: Denise Vaughn Media Project Manager: Lisa Rinaldi Full-Service Project Management: Chitra Sundarajan/Integra Software Services Pvt. Ltd. Printer/Binder: Edwards Brothers Cover Printer: Lehigh-Phoenix Color/Hagerstown Text Font: Palatino Microsoft® and Windows® are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. Screen shots and icons reprinted with permission from the Microsoft Corporation. This book is not sponsored or endorsed by or affiliated with the Microsoft Corporation. Copyright © 2012 Pearson Education, Inc., publishing as Prentice Hall, One Lake Street, Upper Saddle...

Words: 70521 - Pages: 283

Premium Essay

Business Administration

... ISSION (2012) HIGHER EDUCATION COMMISSION ISLAMABAD 1 CURRICULUM DIVISION, HEC Prof. Dr. Syed Sohail H. Naqvi Mr. Muhammad Javed Khan Malik Arshad Mahmood Dr. M. Tahir Ali Shah Mr. Farrukh Raza Mr. Abdul Fatah Bhatti Executive Director Adviser (Academics) Director (Curri) Deputy Director (Curri) Asstt. Director (Curri) Asstt. Director (Curri) Composed by: Mr. Zulfiqar Ali, HEC, Islamabad 2 CONTENTS 1. Introduction……………………………………...........6 2. BBA Programme....................................................11 a. Structure of BBA Programme..……………....12 b. Layout for BBA Programme..........................13 c. Semester-wise Breakup for BBA…...............14 3. Bachelor of Business Studies (BBS)......................15 4. MBA Programme....................................................16 a. Structure of MBA Programme........................17 b. Semester-wise Breakup for MBA...................19 5. MS in Management Sciences................................20 a. Structure of MS Programme...........................20 b. Eligibility for Non-business Degree Holders...21 6. Roadmap for Business Education…………............24 7. BBA Course outlines...............................................25 a. Compulsory Courses for BBA...…….…..........25 b. Foundation Core Courses...........…....…....... 41 c. Major Core Courses........................................59 d. Major Elective Courses...................................75 e. Management Specialisation Courses..........

Words: 58162 - Pages: 233

Premium Essay

Hai, How Are U

...UNIVERSITY OF KERALA B. TECH. DEGREE COURSE 2008 ADMISSION REGULATIONS and I  VIII SEMESTERS SCHEME AND SYLLABUS of COMPUTER SCIENCE AND ENGINEERING B.Tech Comp. Sc. & Engg., University of Kerala 2 UNIVERSITY OF KERALA B.Tech Degree Course – 2008 Scheme REGULATIONS 1. Conditions for Admission Candidates for admission to the B.Tech degree course shall be required to have passed the Higher Secondary Examination, Kerala or 12th Standard V.H.S.E., C.B.S.E., I.S.C. or any examination accepted by the university as equivalent thereto obtaining not less than 50% in Mathematics and 50% in Mathematics, Physics and Chemistry/ Bio- technology/ Computer Science/ Biology put together, or a diploma in Engineering awarded by the Board of Technical Education, Kerala or an examination recognized as equivalent thereto after undergoing an institutional course of at least three years securing a minimum of 50 % marks in the final diploma examination subject to the usual concessions allowed for backward classes and other communities as specified from time to time. 2. Duration of the course i) The course for the B.Tech Degree shall extend over a period of four academic years comprising of eight semesters. The first and second semester shall be combined and each semester from third semester onwards shall cover the groups of subjects as given in the curriculum and scheme of examination ii) Each semester shall ordinarily comprise of not less than 400 working periods each of 60 minutes duration...

Words: 34195 - Pages: 137

Free Essay

Gd-Pi

...Hundreds(of(real(personal(accounts(of Group'Discussions'&'Personal'Interviews during(MBA(admissions(to(India’s(best(B9schools Written'by Compiled'by Loads'of'MBA'Aspirants The'PaGaLGuY'MadCapz'Group PaGaLGuY.com Antholo gy Hundreds of real personal accounts of Group Discussions and Personal Interviews during MBA admissions to India’s best business schools. In this edition: The IIMs at Ahmedabad, Bangalore, Calcutta, Lucknow, Indore & Kozhikode. Written by Loads of MBA aspirants Compiled by The PaGaLGuY MadCapz Team PaGaLGuY GD-PI Anthology Copyright © 2011, PaGaLGuY.com All text and content in this document is solely owned by PaGaLGuY.com. Reproduction without permission in any form or means is illegal. Special copy prepared exclusively for mustafa rokerya Get your own Free personalized copy (with your name on it) of this book from http://www.pagalguy.com/books/ What this book is about What is a real IIM interview like? What kind of questions do they ask and what judgments do applicants have to make while answering them? Since 2003, those with real Group Discussion and Personal Interview calls from India’s top bschools have been posting entire and detailed transcripts of their admission interviews immediately after they happen, so that others slotted for later interviews can learn what GDPI is going to be like this year. This book is a collection of dozens of handpicked GDPI experiences from the country’s top bschools during the admission...

Words: 178933 - Pages: 716

Premium Essay

Esrgt

...UNDERGRADUATE REGULATIONS & SYLLABUSES 2014 - 2015 THE FACULTY OF SOCIAL SCIENCES TABLE OF CONTENTS MESSAGE FROM THE DEAN ............................................................. 3 UNDERGRADUATE PROGRAMMES ................................................ 4 ACADEMIC CALENDAR 2014-2015 ................................................ 5 DEFINITIONS ...................................................................................... 13 GENERAL INFORMATION & REGULATIONS .............................. 14 General Regulations for Bachelor of Science Degrees 14 Special Regulations for Degrees in Hospitality and Tourism Management........................................................... 27 Franchise Agreements .......................................................... 27 EVENING UNIVERSITY -GENERAL INFORMATION & REGULATIONS ................................................................................... 28 General Regulations for Bachelor of Science Degrees 28 General Regulations for Diploma Programmes ............ 36 General Regulations for Certificate Programmes ......... 37 STUDENT PRIZES .............................................................................. 38 CODE OF CONDUCT ........................................................................ 39 UNIVERSITY REGULATIONS ON PLAGIARISM .......................... 40 THE ACADEMIC SUPPORT/ DISABILITIES LIAISON UNIT (ASDLU) ..............................................................................................

Words: 77086 - Pages: 309

Premium Essay

Management Information Systems

...Course Technology’s Management Information Systems Instructor and Student Resources Introduction to IS/MIS Principles of Information Systems, Eighth Edition • Stair, Reynolds Fundamentals of Information Systems, Fourth Edition • Stair, Reynolds Management Information Systems, Sixth Edition • Oz Information Technology in Theory • Aksoy, DeNardis Office Applications in Business Problem-Solving Cases in Microsoft Access & Excel, Sixth Annual Edition • Brady, Monk Succeeding in Business Applications with Microsoft Office 2007 • Bast, Gross, Akaiwa, Flynn, et.al Succeeding in Business with Microsoft Office Excel 2007 • Gross, Akaiwa, Nordquist Succeeding in Business with Microsoft Office Access 2007 • Bast, Cygman, Flynn, Tidwell Databases Database Systems, Eighth Edition • Rob, Coronel Concepts of Database Management, Sixth Edition • Pratt, Adamski Data Modeling and Database Design • Umanath, Scamell A Guide to SQL, Seventh Edition • Pratt A Guide to MySQL • Pratt, Last Guide to Oracle 10g • Morrison, Morrison, Conrad Oracle 10g Titles Oracle9i Titles Enterprise Resource Planning Concepts in Enterprise Resource Planning, Third Edition • Monk, Wagner Data Communications Data Communications and Computer Networks: A Business User’s Approach, Fourth Edition • White Systems Analysis and Design Systems Analysis and Design in a Changing World, Fifth Edition • Satzinger, Jackson, Burd Object-Oriented Analysis and Design with the Unified Process • Satzinger, Jackson, Burd Systems Analysis and...

Words: 223685 - Pages: 895

Premium Essay

Sistem Informasi

...PRENTICE HALL MA NAGEMENT INFORMATION SYSTEMS TITLES MIS: Brown/DeHayes/Hoffer /Martin/Perkins, Managing Information Technology 6/e © 2009 JessuplValacich, Information Systems Today 31e © 2008 Kr oenke, Using MIS 21e © 2009 Kr oenke, Experiencing MIS © 2008 Laudon/Laudon, Management Information Systems 10le © 2007 Laudon/Laudon, Essentials of Management Information Systems 81e © 2009 Luftman et aI., Managing the IT Resource © 2004 Malaga, Information Systems Technology © 2005 McKeen/Smith, IT Strategy in Action © 2009 McLeod/Schell, Management Information Systems 10le © 2007 McNurlin/Spr ague, Information Systems Management In Practice 7Ie © 2006 Miller, MIS Cases: Decision Making with Application Software 41e © 2009 Senn, Information Technology 31e © 2004 Database Management: BordoloilBock, Oracle SOL © 2004 Bordoloi/Bock, SOL for SOL Server © 2004 Fr ost/DaylVanSlyke, Database Design and Development: A Visual Approach © 2006 Hoffer/Prescott/Topi, Modern Database Management 91e © 2009 Kroenke/Auer, Database Concepts 31e © 2007 Kroenke, Database Processing 10Ie © 2006 Perry/Post, Introduction to Oracle10g, © 2007 Per ry/Post, Introduction to SOL Server 2005 © 2007 Systems Analysis and Design: Hoffer /GeorgelValacich, Modern Systems Analysis qnd Design 5'/e © 2008 Kendall/Kendall, Systems Analysis and Design 7Ie © 2008 Valacich/George/Hoffer, Essentials of Systems Analysis and Design 31e © 2006 Object-Oriented Systems Analysis and Design: ...

Words: 39287 - Pages: 158

Free Essay

Customer Satisfaction

...Transforming Lives Communities The Nation …One Student at a Time Disclaimer Academic programmes, requirements, courses, tuition, and fee schedules listed in this catalogue are subject to change at any time at the discretion of the Management and Board of Trustees of the College of Science, Technology and Applied Arts of Trinidad and Tobago (COSTAATT). The COSTAATT Catalogue is the authoritative source for information on the College’s policies, programmes and services. Programme information in this catalogue is effective from September 2010. Students who commenced studies at the College prior to this date, are to be guided by programme requirements as stipulated by the relevant department. Updates on the schedule of classes and changes in academic policies, degree requirements, fees, new course offerings, and other information will be issued by the Office of the Registrar. Students are advised to consult with their departmental academic advisors at least once per semester, regarding their course of study. The policies, rules and regulations of the College are informed by the laws of the Republic of Trinidad and Tobago. iii Table of Contents PG 9 PG 9 PG 10 PG 11 PG 11 PG 12 PG 12 PG 13 PG 14 PG 14 PG 14 PG 14 PG 15 PG 17 PG 18 PG 20 PG 20 PG 20 PG 21 PG 22 PG 22 PG 22 PG 23 PG 23 PG 23 PG 23 PG 24 PG 24 PG 24 PG 24 PG 25 PG 25 PG 25 PG 26 PG 26 PG 26 PG 26 PG 26 PG 26 PG 27 PG 27 PG 27 PG 27 PG 27 PG 27 PG 28 PG 28 PG 28 PG 28 PG 28 PG 33 PG 37 Vision Mission President’s...

Words: 108220 - Pages: 433

Free Essay

Nit-Silchar B.Tech Syllabus

...Semester-1 Chemistry/Physics Basic Electrical Engineering Mathematics-I Engineering Graphics Communication Skills Chemistry/Physics Laboratory Workshop Physical Training-I NCC/NSO/NSS L 3 3 3 1 3 0 0 0 0 13 T 1 0 1 0 0 0 0 0 0 2 1 1 1 1 0 0 0 0 4 1 1 0 0 0 0 0 0 2 0 0 0 0 P 0 0 0 3 0 2 3 2 2 8 0 0 0 0 0 2 2 2 2 0 0 0 0 0 2 2 2 6 0 0 8 2 C 8 6 8 5 6 2 3 0 0 38 8 8 8 8 6 2 0 0 40 8 8 6 6 6 2 2 2 40 6 6 8 2 Course No EC-1101 CS-1101 MA-1102 ME-1101 PH-1101/ CH-1101 CS-1111 EE-1111 PH-1111/ CH-1111 Course Name Semester-2 Basic Electronics Introduction to Computing Mathematics-II Engineering Mechanics Physics/Chemistry Computing Laboratory Electrical Science Laboratory Physics/Chemistry Laboratory Physical Training –II NCC/NSO/NSS Semester-4 Structural Analysis-I Hydraulics Environmental Engg-I Structural Design-I Managerial Economics Engg. Geology Laboratory Hydraulics Laboratory Physical Training-IV NCC/NSO/NSS Semester-6 Structural Design-II Structural Analysis-III Foundation Engineering Transportation Engineering-II Hydrology &Flood Control Concrete Lab Structural Engineering Lab L 3 3 3 3 3 0 0 0 0 0 15 3 3 3 3 3 0 0 0 0 15 3 3 3 3 3 0 0 T 0 0 1 1 1 0 0 0 0 0 3 1 1 0 1 0 0 0 0 0 3 1 1 1 0 0 0 0 P 0 0 0 0 0 2 2 2 2 2 6 0 0 0 0 0 2 2 2 2 4 0 0 0 0 0 2 2 C 6 6 8 8 8 2 2 2 0 0 42 8 8 6 8 6 2 2 0 0 40 8 8 8 6 6 2 2 MA-1201 CE- 1201 CE -1202 CE -1203 CE-1204 CE-1211 Semester-3 Mathematics-III Building Materials and...

Words: 126345 - Pages: 506

Premium Essay

Intro to Linux

...offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales, which may include electronic versions and/or custom covers and content particular to your business, training goals, marketing focus, and branding interests. For more information, please contact: U.S. Corporate and Government Sales (800) 382-3419 corpsales@pearsontechgroup.com For sales outside the United States, please contact: International Sales international@pearson.com Visit us on the Web: informit.com/ph Library of Congress Cataloging-in-Publication Data Sobell, Mark G. A practical guide to Linux commands, editors, and shell programming / Mark G. Sobell.—2nd ed. p. cm. Includes bibliographical references and index. ISBN 978-0-13-136736-4 (pbk.) 1. Linux. 2. Operating systems (Computers) I. Title. QA76.76.O63S59483 2009 005.4'32—dc22 2009038191 Copyright © 2010 Mark G. Sobell All rights reserved. Printed in the United States of America....

Words: 228961 - Pages: 916

Free Essay

Meteorological Instruments

...Guide to Meteorological Instruments and Methods of Observation WMO-No. 8 Guide to Meteorological Instruments and Methods of Observation WMO-No. 8 Seventh edition 2008 WMO-No. 8 © World Meteorological Organization, 2008 The right of publication in print, electronic and any other form and in any language is reserved by WMO. Short extracts from WMO publications may be reproduced without authorization, provided that the complete source is clearly indicated. Editorial correspondence and requests to publish, reproduce or translate this publication in part or in whole should be addressed to: Chairperson, Publications Board World Meteorological Organization (WMO) 7 bis, avenue de la Paix P.O. Box No. 2300 CH-1211 Geneva 2, Switzerland ISBN 978-92-63-10008-5 NOTE The designations employed in WMO publications and the presentation of material in this publication do not imply the expression of any opinion whatsoever on the part of the Secretariat of WMO concerning the legal status of any country, territory, city or area, or of its authorities, or concerning the delimitation of its frontiers or boundaries. Opinions expressed in WMO publications are those of the authors and do not necessarily reflect those of WMO. The mention of specific companies or products does not imply that they are endorsed or recommended by WMO in preference to others of a similar nature which are not mentioned or advertised. Tel.: +41 (0) 22 730 84 03 Fax: +41 (0) 22 730 80 40 E-mail: publications@wmo...

Words: 216230 - Pages: 865