Free Essay

Comparing Dbms

In:

Submitted By gonnetwork10
Words 926
Pages 4
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 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

Netw 360 Ilab 2

...power can be measured in two ways: on the linear scale, by the number of watts that are being transmitted; and on a relative scale, by the number of decibels (dBs) instead of watts. Decibel milliwatt (dBm) is the logarithmic power ratio (in dB) of the measured power in milliwatts referenced to one milliwatt (mW). Notice that the reference point is specified as 1 mW = 0 dBm. 3’s and 10’s rules are shortcuts for estimating the increase or decrease of these power levels. In this lab, students will practice basic RF calculations, including · converting from mW to dBm; · converting from dBm to mW; and · estimating power levels using the 3’s and 10’s rules. Task 1: Converting between dBm and mW Applying the 3’s and 10’s rules, the relationship between dBm and mW is estimated as shown in the following (partial) table. 3’s rule|10’s rule| ……|……| 0.125 mW = -9 dBm|0.001 mW = -30 dBm| 0.25 mW = -6 dBm|0.01 mW = -20 dBm| 0.5 mW = -3 dBm|0.1 mW = -10 dBm| 1 mW = 0 dBm|1 mW = 0 dBm| 2 mW = 3 dBm|10 mW = 10 dBm| 4 mW = 6 dBm|100 mW = 20 dBm| 8 mW = 9 dBm|1,000 mW = 30 dBm| ……|……| Notice that as the mW value increases or decreased by the factor of 10, the dBm value increases and decrease by adding or subtracting 10. As the mW value doubles or halves, the corresponding dBm value increases and decrease by adding or...

Words: 894 - Pages: 4

Free Essay

Week 4 Essay: Comparing Dbms

...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...

Words: 917 - Pages: 4

Premium Essay

Dbm 502 Expert Tutor/ Indigohelp

...DBM 502 Entire Course For more classes visit www.indigohelp.com DBM 502 Individual Assignment: Implementing an Enterprise DBMS DBM 502 Individual Assignment: Comparing Database Software PART 2 OF 2 DBM 502 Individual Assignment: Comparing Database Software PART 1 OF 2 DBM 502 Individual Assignment: Data Dictionary DBM 502 Individual Assignment: Database Security DBM 502 Learning Team Assignment: DBMS Implementation Plan ………………………………………………… DBM 502 Individual Assignment Comparing Database Software PART 1 OF 2 For more classes visit www.indigohelp.com Individual Assignment: Comparing Database Software Create a list of criteria that can be used to compare database software. Create a table that uses the list of criteria to compare and contrast Microsoft® Access, SQL, DB2, and Oracle®. Write a 2- to 3-page paper that discusses Refer to “Standards for Written Work” and “Standards•your results. for Presentations” in your Program Handbook, which can be accessed through the student Web site. ………………………………………………… DBM 502 Individual Assignment Comparing Database Software PART 2 OF 2 For more classes visit www.indigohelp.com Individual Assignment: Comparing Database Software Create a list of criteria that can be used to compare database software. Create a table that uses the list of criteria to compare and contrast Microsoft® Access, SQL, DB2, and Oracle®. Write a 2- to 3-page paper that discusses your results. Refer to “Standards for Written Work...

Words: 537 - Pages: 3

Premium Essay

Dbm 502 Learning Consultant / Tutorialrank.Com

...DBM 502 Entire Course (UOP) For more course tutorials visit www.tutorialrank.com DBM 502 Individual Assignment: Implementing an Enterprise DBMS DBM 502 Individual Assignment: Comparing Database Software PART 2 OF 2 DBM 502 Individual Assignment: Comparing Database Software PART 1 OF 2 DBM 502 Individual Assignment: Data Dictionary DBM 502 Individual Assignment: Database Security DBM 502 Learning Team Assignment: DBMS Implementation Plan ---------------------------------------------------------------------------- DBM 502 Individual Assignment: Comparing Database Software PART 1 OF 2 (UOP) For more course tutorials visit www.tutorialrank.com Individual Assignment: Comparing Database Software Create a list of criteria that can be used to compare database software. Create a table that uses the list of criteria to compare and contrast Microsoft® Access, SQL, DB2, and Oracle®. Write a 2- to 3-page paper that discusses Refer to “Standards for Written Work” and “Standards•your results. for Presentations” in your Program Handbook, which can be accessed through the student Web site. ------------------------------------------------------------------- DBM 502 Individual Assignment: Comparing Database Software PART 2 OF 2 (UOP) For more course tutorials visit www.tutorialrank.com Individual Assignment: Comparing Database Software Create a list of criteria that can be used to compare database software. Create a table that uses the list of criteria to compare...

Words: 548 - Pages: 3

Premium Essay

Dbm 265 Expert Tutor/ Indigohelp

...DBM 265 Entire Course For more classes visit www.indigohelp.com DBM 265 Week 1 DQ 1 DBM 265 Week 1 DQ 2 DBM 265 Week 1 Summary DBM 265 Week 2 Individual Assignment Comparing the DBA and DA DBM 265 Week 2 DQ 1 DBM 265 Week 2 DQ 2 DBM 265 Week 2 Summary DBM 265 Week 3 Individual Assignment Preparing to Install a Database DBM 265 Week 3 DQ 1 DBM 265 Week 3 DQ 2 DBM 265 Week 3 Summary DBM 265 Week 4 Individual Assignment DBMS Support and Security Paper DBM 265 Week 4 DQ 1 DBM 265 Week 4 DQ 2 DBM 265 Week 4 Summary DBM 265 Week 5 Learning Team Assignment Virtual Organization Project Proposal Paper and Presentation DBM 265 Week 5 DQ 1 DBM 265 Week 5 DQ 2 DBM 265 Week 5 Summary ………………………………………………… DBM 265 Week 1 DQ 1 For more classes visit www.indigohelp.com What are three database administrator responsibilities? Which is the most challenging? Explain why. ………………………………………………… DBM 265 Week 1 DQ 2 For more classes visit www.indigohelp.com What are some of the first tools a database administrator (DBA) would use? Why would a DBA use these tools first? How would this benefit the company? ………………………………………………… DBM 265 Week 1 Summary For more classes visit www.indigohelp.com Write a 100-150 words Summary ………………………………………………… DBM 265 Week 2 DQ 1 For more classes visit www.indigohelp.com Why is it important to set guidelines for naming database objects? What possible IT issues could arise if the naming...

Words: 427 - Pages: 2

Free Essay

Dbm 265 Learning Consultant / Tutorialrank.Com

...DBM 265 Week 1 DQ 1 (UOP Course) For more course tutorials visit www.tutorialrank.com What are three database administrator responsibilities? Which is the most challenging? Explain why. ----------------------------------------------------------------- DBM 265 Week 1 DQ 2 (UOP Course) For more course tutorials visit www.tutorialrank.com What are some of the first tools a database administrator (DBA) would use? Why would a DBA use these tools first? How would this benefit the company? ----------------------------------------------------------------- DBM 265 Week 1 Summary (UOP Course) For more course tutorials visit www.tutorialrank.com Write a 100-150 words Summary ----------------------------------------------------------------- DBM 265 Week 2 DQ 1 (UOP Course) For more course tutorials visit www.tutorialrank.com Why is it important to set guidelines for naming database objects? What possible IT issues could arise if the naming is not uniform? ----------------------------------------------------------------- DBM 265 Week 2 DQ 2 (UOP Course) For more course tutorials visit www.tutorialrank.com Why is it important to understand the CPU environment before installing the database management system? What issues can arise if you fail to do so? ----------------------------------------------------------------- DBM 265 Week 2 Individual Assignment Comparing the DBA and DA (UOP Course) For more course tutorials visit www.tutorialrank...

Words: 284 - Pages: 2

Premium Essay

Research Medical Paper Acl's

...cortical allografts serve as a stabilizing strut while undergoing bone remodeling by the mechanism of creeping substitution. The processing of cortical bone, intended to remove undesirable immunologically active elements, may also remove desirable elements (including endogenous growth factors) and affect the bone’s ability to undergo creeping substitution. Summary, continued Results of this study suggest that: • DBM prepared from MTF ATP cortical tissue was consistently osteoinductive in this model; 7 out of 7 ranked samples were osteoinductive (1 sample could not be ranked due to histological artifacts). The average bone score for the 7 ranked samples was 2.17 ± 0.82. • DBM prepared from RTI BioCleanse cortical tissue was not osteoinductive in this model; 7 out of 7 ranked samples were not osteoinductive (1 sample could not be ranked due to histological artifacts). The average bone score for the 7 ranked samples was 0.00 ± 0.00, exactly the same as the heatinactivated negative control. In addition, histological views showed fibrous tissue/inflammatory response. • DBM prepared from LifeNet Allowash cortical tissue was partially osteoinductive in this model; 3 out of 7 ranked samples were...

Words: 1748 - Pages: 7

Premium Essay

Market Feasinility

...Information Systems Analysis and Design CSC340 VII. The Feasibility Study What is a Feasibility Study? Feasibility Study? Types of Feasibility Cost/Benefit Analysis Risk Analysis Comparing Alternatives Information Acquisition Acquisition Feasibility Study Contents Contents Do it! 2004 Jaelson Castro and John Mylopoulos The Feasibility Study -- 1 Information Systems Analysis and Design CSC340 The Feasibility Study The objective of a feasibility study is to find out if an information system project can be done, and if so, how. A feasibility study should tell management: Whether the project can be done; What are alternative solutions? What are the criteria for choosing among them? Is there a preferred alternative? After a feasibility study, management makes a go/no-go decision. • A feasibility study is a • management-oriented activity 2004 Jaelson Castro and John Mylopoulos The Feasibility Study -- 2 Page ‹#› Information Systems Analysis and Design CSC340 Dimensions of Feasibility Operational -- how will the solution work? Technical -- is the technology needed available? Economic -- return on investment Schedule -- can the system be delivered on time? Constraints may be hard or soft 2004 Jaelson Castro and John Mylopoulos The Feasibility Study -- 3 Information Systems Analysis and Design CSC340 Economic Feasibility The bottom line for many projects! Economic feasibility amounts to judging whether possible benefits of the project are worthwhile. As soon as...

Words: 2891 - Pages: 12

Free Essay

Introduction to Communication Systems

...LABORATORY EXPERIMENT #1 THE OSCILLOSCOPE ABSTRACT The purpose of this lab was to become familiar with the EE 390 communication laboratory equipment available in the lab, particularly the Agilent 54621A digital oscilloscope. In this lab, electrical signals were measured using the oscilloscope in both time domain and frequency domain. Two electrical signals were displayed- a 1 kHz, 2.78VPP as well as a 2 kHz, 278mVPP. In this lab, methods of improving measurement accuracy, dealing with floor noise and averaging were all explored. Overall this lab was a useful tool in understanding the lab equipment. RESULTS AND DISCUSSION: PART 1 - QUESTION 1 i) A 1 kHz, 2.78 VPP sinusoid wave is displayed with trigger level at 200 mV (rising edge). See Fig.1 Fig.1: Time Domain Representation of Signal Power dissipated in the load: P_load=〖V_rms〗^2/R , where V_rms=V_amp/√2 and V_amp=V_PP/2 So, V_amp=(2.78 "V" )/2=1.39 "V" and V_rms=(1.39 "V" )/√2=0.9829 "V" Hence, P_load=((〖0.9829 "V" )〗^2)/(50 "Ω" )=19.32 "mW" ii) When we set the triggering level to 1.5V, the resulting signal displayed is an unstable one. The reason for this is because the trigger level must be on the rising or falling edge. iii) A 1 kHz, 2.78 VPP sinusoid wave is displayed and the accuracy of the measurement is calculated. The volts/division is equal to 500 mV. See Fig.2 Fig.2: Accuracy of Time Domain Representation of Signal error = 2% Vfs , where Vfs= (number of spaces) x (volts/division) ...

Words: 1274 - Pages: 6

Premium Essay

Test

...Data Warehousing Methodologies Using a common set of attributes to determine which methodology to use in a particular data warehousing project. DATA INTEGRATION TECHNOLOGIES have experienced explosive growth in the last few years, and data warehousing has played a major role in the integration process. A data warehouse is a subjectoriented, integrated, time-variant, and nonvolatile collection of data that supports managerial decision making [4]. Data warehousing has been cited as the highest-priority post-millennium project of more than half of IT executives. A large number of data warehousing methodologies and tools are available to support the growing market. However, with so many methodologies to choose from, a major concern for many firms is which one to employ in a given data warehousing project. In this article, we review and compare several prominent data warehousing methodologies based on a common set of attributes. Online transaction processing (OLTP) systems are useful for addressing the operational data needs of a firm. However, they are not well suited for supporting decision-support queries or business questions that managers typically need to address. Such questions involve analytics including aggregation, drilldown, and slicing/dicing of data, which are best supported by online analytical processing (OLAP) systems. Data warehouses support OLAP applications by storing and maintaining data in multidimensional format. Data in an OLAP warehouse is extracted and loaded...

Words: 4067 - Pages: 17

Premium Essay

Feasiblity

...Information Systems Analysis and Design CSC340 VI. The Feasibility Study What is a feasibility study? What to study and conclude? Benefits and costs Cost/Benefit analysis Accounting methods Comparing alternatives Do it! 2002 Jaelson Castro and John Mylopoulos The Feasibility Study -- 1 Information Systems Analysis and Design CSC340 The Feasibility Study Phase n The objectives of a feasibility study are to find out if an information system project can be done (...is it possible?...is it justified?) and to suggest possible alternative solutions. n A feasibility study should provide management with enough information to decide: - whether the project can be done - whether the final product will benefit its intended users - what are the alternatives among which a solution will be chosen (during subsequent phases) - is there a preferred alternative n After a feasibility study, management makes a go/no go decision The feasibility study is a management-oriented activity 2002 Jaelson Castro and John Mylopoulos The Feasibility Study -- 2 Page 1 Information Systems Analysis and Design CSC340 What to Study? ...What to Conclude? n Things to be studied during the feasibility study phase: ü The present organizational system, including users, policies, functions, objectives,... ü Problems with the present system (inconsistencies, inadequacies in functionality, performance,..., ü Objectives and other requirements for the new system (what needs to...

Words: 3859 - Pages: 16

Premium Essay

Data Base

...Database Design Table of Contents CHAPTER 1 .............................................................................................................................................. 2 INTRODUCTION ................................................................................................................................... 2 DATABASE MANAGEMENT SYSTEMS .................................................................................................. 2 Database ......................................................................................................................................... 2 Database Management System (DBMS) ......................................................................................... 2 Schemas, Instances and Data Independence.................................................................................. 3 DATA MODELS..................................................................................................................................... 3 Hierarchical Model .......................................................................................................................... 3 Network Model ............................................................................................................................... 4 Relational Model ............................................................................................................................. 5 CHAPTER 2 ............................................

Words: 4347 - Pages: 18

Premium Essay

Harrah's Entertainment Inc

...1) What is this case all about? By the mid-1990s competitors had entered the gambling market with better and fleshlier properties. The Mirage in Las Vegas had set a new standard and began to spawn imitators and Harrah’s was facing the formidable task of growing the business in a limited market. Philip Satre joined Harrah’s as CEO realized that the people strategy helped the company initially was no sufficient to grow patronage and play at existing casinos. Harrah’s knew it had to come up with a new strategy to survive. The company, being an old player, could not replicate the kind of highly themed environments that were sprucing up in Las Vegas and other parts of the US. Against this Stare decided that they focused on the customer loyalty and tried to be an industry leader based on that skill. Harrah’s realized early on that sustained competitive advantage will only come from a rigorous customer focus and nothing else. The principal anomaly around which they organized everything else was that for customers who visited Harrah’s once a year or more, the Harrah’s got 36 cents out of their gaming dollar. This fact was derived from the lack of effective marketing. The company had excellent technology and great operations, but did not have the marketing horsepower. The company had to move from an operations-driven company that viewed each property as a “standalone business” to a marketing –driven company with focus on target customers and what it took to build their loyalty to Harrah’s...

Words: 1454 - Pages: 6

Premium Essay

Syaran

...MEC/CEC, CA/CWA, B.Com & B.Sc. Master Minds 4. Data Storage, Retrieval & DBMS Q.No.1. Write about different coding schemes. BCD: » » » » » » » » » » » » » » » » » » BCD stands for binary Coded Decimal system. This is a 6 bit code i.e. each character is expressed in terms of a 6 bit code. There will be 64 ways of representing digits, alphabets and special symbols. There is no parity bit in this coding scheme. ASCII: ASCII stands for American Standard Code for Information Interchange. This code is extensively used in small computers, peripherals, instruments and communication devices. It is a seven-bit code and has replaced many of the special codes that were previously used. Microcomputers using 8-bit word length use 7 bits to represent the basic code. The 8th bit is used for parity or it may be permanently 1 or 0. With 7 bits, up to 128 characters can be coded. A letter, digit or special symbol is called a character. It includes upper and lower case alphabets, numbers, punctuation marks, special and control characters. Here the first 3 bits are zone bits and the remaining 4 bits represent digit values. ASCII-8: A newer version of ASCII is ASCII-8 code, which is an 8-bit code. With 8 bits, the code capacity is extended to 256 characters. EBCDIC: EBCDIC stands for Extended Binary Coded Decimal Interchange Code. It is a standard character code for large computers. It is a 8-bit code without parity and 9th bit can be used as parity bit. Using 8 bits 256 characters...

Words: 14549 - Pages: 59

Premium Essay

Database Management Systems

...Database Management System Basith Shaik Southern New Hampshire University September 7, 2015 Abstract The intent of this paper is to design and propose a database management system solution to Grandfield College for tracking software installed. I have analyzed the organizational issues and needs and developed conceptual, logical, and physical designs of DBMS solution. In order to implement the solution, substantial research had been done on best practices in design, available products, and the legal and ethical standards to which we must adhere during design. This paper includes Business rules, Conceptual, Logical, and Physical database designs, Recommendations on best DBMS required for Grandfield College, Data model, Legal Compliance, Ethical Practices, Security Needs and Security Plan Keywords: Grandfield College, Database Design, Recommendations, Business Rules, Data model, Security Plan Database Management System Grandfield College is in need of Database Management System as law requires that any business, including a school, track its software. It is important to know what software the school owns, in what versions, and what the license agreement for that software is. For this purpose I have developed a Software Tracking database for Grandfield College. Problem Grandfield College is in need of a database for effectively tracking faculty and staff computers, the software installed on those systems, User access to each computer, and requests for new software installation...

Words: 4672 - Pages: 19