Re: Oracle licence question

Tony Rogerson wrote:
What level is ANSI SQL compliance does Microsoft claim - can you provide a citation ?


ANSI 92 - check Books Online.

I did and I couldn't find the citation, which is why I asked you for it. I want to check what level of ANSI compliance MS claims, to validate your claim that their implementation of SQL is somehow more the ANSI standard compliant than Oracle's. Note that Oracle does this at http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/ap_standard_sql003.htm#i7719

I'm looking for the MS corresponding compliance statement. Can you provide a URL ?


Here's the published current salary costs of both sets of DBA's in the UK
Oracle - http://www.itjobswatch.co.uk/jobs/uk/oracle.do
SQL Server - http://www.itjobswatch.co.uk/jobs/uk/sql%20server%20dba.do

There shows that there is less than a 3-13% differential between the min and max salary ranges. Hardly a lot higher at all.



Very clever Mark, but I think you really want to compare like for like, so you ought to compare Oracle DBA with SQL Server DBA (like for like) and you get a more accurate result, if you compare 'oracle' with 'sql server' its even worse....

DBA...
Oracle Min/Max £40,073 £45,219

SQL Server Min/Max £36,128 £40,846


Just search on product...
£39,363 £46,026

SQL Server Min/Max £33,665 £38,797


Thats a big difference!


I did. The page references I gave you provide the following

Min MAX
Oracle 39,363 46,026
SQL Server 36,128 40,846

I'm not sure where you are getting some of your figures from

The math is as follows

Difference 8.95% 12.68%

In the previous post, I did make a mistake in the maths with the low end. So the range is 9-13% higher than SQL Server ranges. This is a higher, bit is not substantially higher. And as I indicated, I believe that this is because, on average, the Oracle DBAs are managing systems with more mission critical requirements.



http://www.theedison.com/research/gems/040401rdbmscmcs.pdf


I wonder who has commissioned the report? Looking at the detailed tasks it starts to get a bit interesting and bias toward Oracle starts to be shown, for instance; the set up and seperate service pack installation - counted as one and not broken down - mmmm.

I await the next report with interested and will also look for more bias, perhaps I will download your trial and try it for myself and write up the results as a whitepaper of my own!

Please do. Feel free to bring your own bias to the party. We have admired your constraint in not doing so so far.

.

Relevant Pages

  • Re: Oracle licence question
    ... SS isn't completely ANSI 92 compliant at ... So, I guess let me rephrase the question - does Oracle have ENTRY, ... INTERMEDIATE and FULL compliance to FIPS 127-2 because I can only find ... SQL Server MVP ...
    (comp.databases.oracle.server)
  • Re: Oracle licence question
    ... What level of ANSI 92 or didn't you know there are different levels? ... SQL Server - http://www.itjobswatch.co.uk/jobs/uk/sql%20server%20dba.do ... you ought to compare Oracle DBA with SQL Server DBA and ... starts to get a bit interesting and bias toward Oracle starts to be shown, ...
    (comp.databases.oracle.server)
  • Re: Oracle licence question
    ... Oracle - http://www.itjobswatch.co.uk/jobs/uk/oracle.do ... SQL Server - http://www.itjobswatch.co.uk/jobs/uk/sql%20server%20dba.do ... Very clever Mark, but I think you really want to compare like for like, so ... What you mean - they use portable SQL as definied by the ANSI SQL ...
    (comp.databases.oracle.server)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)