GDB Topic for Spring 2012 Semester

[ɀµԻ√ą ❀]

Let suppose you are hired as a Database Administrator (DBA) for a renowned IT service provider company with a task that you are required to choose any one from the given options Microsoft SQL Server, Oracle and MySQL in order to manage data about 5000 employees and its related transactions.

Its also one of the main requirement of the company to secure data as much as possible.

Highlight with very solid points (not more than 5) which RDBMS is more appropriate from your point of view.

 

Note: you can take help from internet but the posted data should be in your own words

[ɀµԻ√ą ❀]

wese to tamam store kar akte hain 5000 data 

[student]

Good.Ab question ya hai ke kon si language relationally more than 5000 records can store.  

[ɀµԻ√ą ❀]

jahan tk related transactions ka swal hai to wo bi sb mai ho sakte hai

lakin better in Orcale and MS sql.mysql mai itne achae nae hoti

 

[╰☆True☆╮]

yes ofcourse, oracle is best one, from all the relationl databases

[student]

The discussion is that "which language is best for RDBMS " .   5  main points are required hai aur 3 to us mai he diye huye hai . Ab ya he deakhana hai ke kon si language is best for these 3 points , baki 2 us ke advantages se he mil jaye ge.

[ɀµԻ√ą ❀]

ab raha swal ke data secure kis mai hta hai ziyada

[ɀµԻ√ą ❀]

or not more than 5.....matlb 5 se ziyada nae ho sakte

ap 3 bi bta sakte ho btana hai kun ziyada behtr hai

is mai mysql nae ata lakin ab malom yai karna hai

MS sql server better hai ya Orcale

[student]

Study karte hai 2 ko phir deakhate hai kiya result aata hai. Umeed hai ache points mil jaye ge.

[meshi khan]

Oracle is an object-relational database management system ...

Large scale projects developed in Oracle

while Mysql Mostyly used in web applications

[Awais (MCS)]

 

Most web says SQL Server is best and few says Oracle

SQL Server Most Secure Database;

Oracle Least Secure Database Since 2002

[zain mahmood]

Microsoft SQL Server has a
stronger security posture than the Oracle RDBMS.

[zain mahmood]

DISADVANTAGE PRESENT IN MYSQL:

MYSQL standard has diverted on the standards of implementation of Null and default values. Arithmetic operations are susceptible to integer over flow. Mode of operation of SQL is set to unusual tolerant state which developers hate.

• MySQL does not support a very large database size as efficiently

• MySQL does not support ROLE, COMMIT, and Stored procedures in versions less than 5.0
• Transactions are not handled very efficiently.