91280-281141-assign1-sl

of 7
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information Report
Category:

Documents

Published:

Views: 47 | Pages: 7

Extension: PDF | Download: 0

Share
Description
company Offers handle 100 trainees has 12 instructors 1 undertake s 1 5 Advanced technology courses 2 teaches 2. Identify at least 5 DBMS successfully running in market and compare their features. ANS: 1. IBM's DB2- The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on UNIX (namely AIX), Linux, IBM i, z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions. Alongside DB2 is another RDBMS: Inf
Tags
Transcript
    100 121 5 21 hasinstructors handletrainees Offers Adv ance d  technology coursesteaches un d ertake company  2. Identify at least 5 DBMS successfully running in market and compare their features. ANS: 1.   IBM' s D B2- The IBM D B2 Enterprise Ser  v er E d ition is a relational mo d el d atabase ser  v er  d e v elope d   by IBM .   I t primarily runs on UN IX (namely A IX), Linux ,   IBM i , z/OS an d Win d ows ser  v ers . D B2  also powers the d ifferent IBM   I nfoSphere Warehouse e d itions .   A longsi d e D B2 isanother RD BM S: I nformix , which was acquire d by IBM in 200 1. D B2 also lets you store some partsof your co d e at the ser  v er instea d of keeping all of it in your client application . This can ha v e performance an d maintenance benefits .  There are features to protect d ata an d to d efine relationships between d ata .   A s well , there are object - relational features to create flexible , a dv ance d applications . You can use some features in more thanone way . For example , constraints enable you to protect d ata an d to d efine relationships between d ata v alues . Here are some key D B2 features: y   C onstraints y   User  - d efine d types (UDTs ) an d large objects (LO B s )   y   User  - d efine d functions (UDFs )   y   Triggers y   Store d proce d ures 2 .   Oracle - The Oracle Database is an object - relational d atabase managementsystem(ORD BM S ) pro d uce d an d markete d by Oracle C orporation .  Larry Ellison an d his frien d s an d former co - workers B ob M iner an d E d Oates starte d the consultancySoftware De v elopment Laboratories (SDL ) in 1977. SDL d e v elope d the srcinal v ersion of theOracle software . The name Oracle comes from the co d e - name of a C I A - fun d e d project Ellison ha d  worke d on while pre v iously employe d by A mpex .   y   Scalability an d Performance y   M anageability y   B ackup an d Reco v ery y   High a v ailability y   B usiness I ntelligence y   C ontent M anagement y   Security y   Data integrity/Triggers y   I nformation I ntegration Features3 .   M icrosoft SQL Ser  v er  -   M icrosoft SQL Ser  v er is a relational mo d el d atabase ser  v er pro d uce d   by M icrosoft .   I ts primary query languages are T - SQL an d   A  NS I SQL .   y   Database M irroring y   Online Restore  y   Online I n d exing Operations y   Fast Reco v ery y   Stan d ar  d s -  base d   I nformation A ccess SQL y   Ser  v er  M anagement Stu d io y   De d icate d   Ad ministrator  C onnection4 .   PostgreSQL - PostgreSQL is a powerful , open source object - relational d atabase system .   I t has morethan 15 years of acti v e d e v elopment an d a pro v en architecture that has earne d it a strong reputationfor reliability ,   d ata integrity , an d correctness .   I t runs on all major operating systems , inclu d ingLinux , UN IX ( A IX,   B SD , HP - U X, SG I   I R  IX,   M ac OS X, Solaris , Tru64 ), an d Win d ows .   I t is fully A C I D compliant , has full support for foreign keys , joins ,   v iews , triggers , an d store d proce d ures (inmultiple languages ) .   I t inclu d es most SQL: 2008   d ata types , inclu d ing I  NTEGER  , NU M ER  I C ,   B OOLE A  N ,   C H A R  , V A R  C H A R  , D A TE ,   I  NTERV A L , an d T IM EST A M P .   I t also supportsstorage of binary large objects , inclu d ing pictures , soun d s , or  v i d eo .   I t has nati v e programminginterfaces for  C / C++ , Ja v a ,   .  Net , Perl , Python , Ruby , Tcl , OD B C , among others , an d exceptional d ocumentation .   5.   M Y SQL -   M ySQL is a relational d atabase management system (RD BM S ) [ 1] that runs as a ser  v er  pro v i d ing multi - user access to a number of  d atabases .   M ySQL is officially pronounce d /maskjul/ ( M y S - Q - L ), [2 ] but is often also pronounce d /masikwl/ ( M y Sequel ) .   I t is name d after  d e v eloper  M ichael Wi d enius '   d aughter  ,   M y . The SQL phrase stan d s for Structure d Query Language . [ 3 ]  The M ySQL d e v elopment project has ma d e its source co d e a v ailable un d er the terms of the GNUGeneral Public License , as well as un d er a v ariety ofproprietary agreements .   M ySQL was owne d  an d sponsore d by a single for  -  profit firm , the Swe d ish company M ySQL A B, now owne d   by Oracle C orporation .   Data base MaintainerReleasedateLatest stableversionLatestreleasedateSoftware licenseDB2 IBM   19 8 3 9.7   22   A  pr  200 9  Proprietary MicrosoftSQL Server M icrosoft   19 8 9   2008 R  2  ( v 1 0 .5 )  Proprietary MySQL Sun M icrosystems   1995 - 11   5.5. 8   20 1 0- 1 2- 15 GPL or Proprietary  O racle   Oracle C orporation 1979 - 11   11 g Release 2   200 9 - 9 Proprietary PostgreSQL   Global De v elopmentGroup 19 8 9 - 6 9. 0 . 2   20 1 0- 1 2- 1 6 PostgreSQL licenceThe operating systems the RD BM Ses can run on: Data base WindowsMac O SXLinux   BSDUNIX   Amiga O S   Symbian   z/OS 1   DB25 Yes Yes Yes No Yes No No Yes MicrosoftSQL Server Yes No No No No No No No MySQL Yes Yes Yes Yes Yes Yes Yes Yes O racle4 Yes Yes Yes No Yes No No Yes PostgreSQL   Yes Yes Yes Yes Yes No No No I nformation about what fun d amental RD BM S features are implemente d nati v ely .   ACID   ReferentialintegrityTransactions   UnicodeInterfaceDB2 Yes Yes Yes Yes GU I & SQL MicrosoftSQL Server Yes Yes Yes Yes GU I & SQL MySQL Yes 2 Yes 2 Yes 2 Yes SQL O racle   Yes Yes Yes Yes A P I & GU I & SQL PostgreSQL   Yes Yes Yes Yes GU I & SQL 3. How the various components of database management system interact for transactionProcessing.ANS: The v arious components of  d atabase management system are:
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks
SAVE OUR EARTH

We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

More details...

Sign Now!

We are very appreciated for your Prompt Action!

x