Free Republic
Browse · Search
General/Chat
Topics · Post Article

Skip to comments.

Microsoft SQL Server Overtaking Oracle as Primary Database Among Surveyed Technology Professionals
PR Newswire ^ | 09/28/2010

Posted on 09/28/2010 5:04:24 PM PDT by WebFocus

InformationWeek Analytics, the leading service for peer-based IT research and analysis, today announced the release of its "Research: 2010 State of Database Technology" report. More than 750 business technology professionals weigh in on their database strategies. Report author Richard Winter is founder and president of WinterCorp, an independent consulting firm that specializes in the performance and scalability of data management systems.

Research Summary:

Our first InformationWeek Analytics State of Database Technology Survey reveals serious fault lines beneath the critically important enterprise database and data warehousing markets. The 755 business technology professionals taking part in our poll express discontent with rising license and upgrade fees as database sizes and workloads spiral ever larger. On the vendor side, a spate of acquisitions and the rise of appliances are creating uncertainty as well.

Findings:

* Most respondents, 88%, hail from enterprises where the primary operational database platform is from Microsoft (35%), Oracle (35%) or IBM (18%). While the majority are generally satisfied with features and performance, more than half, 52%, take issue with license fees; 13% of respondents characterize their costs as "highway robbery."

* A remarkably high percentage of respondents, 27%, are using as a secondary operational database the open source MySQL, which is now owned by Oracle and, more importantly, carries no license fee. In addition, 39% are interested in NoSQL, a term encompassing a group of large, clustered but nonrelational data management systems, often inexpensive or open source. Together these trends suggest we'll see movement toward alternatives to the commercially available relational database platforms that have been the near-universal standard for the past 25 years.

* The data warehousing market is also in flux. The good news is that 41% of respondents have a single enterprise data warehouse (EDW) or are working toward that goal—the largest percentage pursuing any single strategy in our survey. However, just over 60% are satisfied with the performance and features of their EDW platforms, while a quarter are unhappy with license fees.

* MySQL is frequently cited as a secondary data warehouse or data mart, and in the analytic databases category, which 48% see as distinct from data warehouses and data marts, a remarkable 22% of respondents are using, experimenting with or investigating the open source platform Hadoop; slightly fewer are looking at related tools, such as BigTable or MapReduce.

"One subject we really dug into for this report is database security, an area often underemphasized," says Lorna Garey, content director of InformationWeek Analytics. "We're worried that respondents are talking a good game here while not always following through. I say this because while 70% say their organizations perform database security assessments to identify weaknesses, only about half of those people were able to name the security assessment products in use. Maybe they're assuming that the CISO is handling this, but the phrase 'trust but verify' comes to mind for me."

InformationWeek Analytics is a subscription-based service, offering peer-based technology research. Its site currently houses more than 900 reports and briefs, and includes a dedicated area where technology professionals can access complete issues of InformationWeek Magazine.


TOPICS: Business/Economy; Computers/Internet
KEYWORDS: databases; microsoft; oracle; sqlserver
Navigation: use the links below to view more comments.
first previous 1-2021-34 last
To: WebFocus

Oracle is only run on the Solaris servers. MYSQL on both.


21 posted on 09/29/2010 9:35:10 AM PDT by bmwcyle (It is Satan's fault)
[ Post Reply | Private Reply | To 17 | View Replies]

To: bmwcyle

So, how do you compare MYSQL running on Windows compared to SQL Server? ( What versions of MYSQL and SQL Server are you guys using anyway?)

I believe the article is showing an increased market share for SQL Server because it has been designed and dedicated to the Windows platform.

Like it or not, Windows has over 90% of the OS market worldwide and Microsoft’s dominance in this area will simply ensure that any product they develop, be it Database Servers or Web servers or browsers will be OPTIMIZED for the Windows platform ( whatever version they’re coming up with ).


22 posted on 09/29/2010 10:02:30 AM PDT by WebFocus
[ Post Reply | Private Reply | To 21 | View Replies]

To: bmwcyle

SQL2005 still annoyed me, especially the full-text indexing as a separate process, very kludgy. SQL2008 is pretty sweet though, I love working with it.


23 posted on 09/29/2010 10:56:05 AM PDT by antiRepublicrat
[ Post Reply | Private Reply | To 13 | View Replies]

To: WebFocus

We are running MYSQL 5.5 using myphpadmin to build database on UNIX and MySQL admin to build databases on Windows.


24 posted on 09/29/2010 12:39:37 PM PDT by bmwcyle (It is Satan's fault)
[ Post Reply | Private Reply | To 22 | View Replies]

To: antiRepublicrat

We use these two databases to keep it simple and consistent. The web engineers know there databases well. We have over 100 web sites to keep running.


25 posted on 09/29/2010 12:42:04 PM PDT by bmwcyle (It is Satan's fault)
[ Post Reply | Private Reply | To 23 | View Replies]

To: bmwcyle

I generally use one these days, MSSQL. I’ve found over the years that what’s far more important for performance than the database engine or even the hardware you use is the design of the database and how it’s used by the application. I’ve achieved literally 100x+ performance improvements combined with 90% drops in server load by changing even small parts in the structure and access of databases created by others. They thought SQL Server or the hardware was just slow, but it was the design that was at fault. Why throw $50,000 more at hardware and SQL licenses when a few days of intelligent analysis and redesign will fix it?


26 posted on 09/29/2010 1:12:41 PM PDT by antiRepublicrat
[ Post Reply | Private Reply | To 25 | View Replies]

To: antiRepublicrat
(Sound of grey_whiskers purring.)

Once upon a time I acheived a factor of 30 speedup in a kernel for a computational routine at work by re-arranging and re-writing it to eliminate algebraic redundancies.

Cheers!

27 posted on 09/29/2010 10:02:53 PM PDT by grey_whiskers (The opinions are solely those of the author and are subject to change without notice.)
[ Post Reply | Private Reply | To 26 | View Replies]

To: antiRepublicrat
(Sound of grey_whiskers purring.)

Once upon a time I achieved a factor of 30 speedup in a kernel for a computational routine at work by re-arranging and re-writing it to eliminate algebraic redundancies.

Cheers!

28 posted on 09/29/2010 10:03:05 PM PDT by grey_whiskers (The opinions are solely those of the author and are subject to change without notice.)
[ Post Reply | Private Reply | To 26 | View Replies]

To: WebFocus
I am interested in learning why you think this strategy would help Microsoft's bottom line...

It would spur otherwise unnecessary purchases of Windows licenses.

29 posted on 09/29/2010 10:11:39 PM PDT by cynwoody
[ Post Reply | Private Reply | To 16 | View Replies]

To: WebFocus
SQL Server is a highly competent database.

But these days, I find no reason to go beyond SQLite, in those cases where I even need a RDBMS. There is no reason to pay for the licenses you need to run MSSQL, much less Oracle. Google doesn't do it, so why should I?

30 posted on 09/29/2010 10:16:56 PM PDT by cynwoody
[ Post Reply | Private Reply | To 1 | View Replies]

To: cynwoody
There is no reason to pay for the licenses you need to run MSSQL, much less Oracle.

There is if you have data requirements too big for SQLite. It is "lite" after all. It can't really handle highly transactional or large datasets.

Google doesn't do it, so why should I?

Oracle uses a custom, distributed, non-relational database system called BigTable that has a multi-tiered lookup architecture and is designed to work on top of Google's custom file system. It's designed for fast lookup within petabytes of data across thousands of servers. It's also not for sale.

31 posted on 09/30/2010 8:13:44 AM PDT by antiRepublicrat
[ Post Reply | Private Reply | To 30 | View Replies]

To: cynwoody

Why did I write Oracle? BigTable is of course Google.


32 posted on 09/30/2010 8:15:02 AM PDT by antiRepublicrat
[ Post Reply | Private Reply | To 30 | View Replies]

To: antiRepublicrat
BigTable isn't a relational database. When Google actually needs an RDBMS, they use MySQL. Which is what I would use if I needed an RDBMS beefier than SQLite.
33 posted on 09/30/2010 3:00:18 PM PDT by cynwoody
[ Post Reply | Private Reply | To 31 | View Replies]

To: cynwoody
BigTable isn't a relational database. When Google actually needs an RDBMS, they use MySQL.

I know BigTable isn't relational. As for MySQL, it has definitely come a long way. It couldn't even do transactions, stored procedures or referential integrity when I started using it. There are still limitations to MySQL. For example, for work use I don't want an RDBMS where pulling the plug on the server can cause data corruption. MSSQL and Oracle can recover from such a situation just fine, MySQL not so much.

But as always, horses for courses.

34 posted on 10/01/2010 7:51:31 AM PDT by antiRepublicrat
[ Post Reply | Private Reply | To 33 | View Replies]


Navigation: use the links below to view more comments.
first previous 1-2021-34 last

Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.

Free Republic
Browse · Search
General/Chat
Topics · Post Article

FreeRepublic, LLC, PO BOX 9771, FRESNO, CA 93794
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson