Changing Database Market

basesprocketData Management

Oct 31, 2013 (4 years and 2 months ago)

94 views

Get Prepared for the
Changing Database Market

Effectively meet the challenges of
heterogeneous environments

Fall 2006

Do you fit this profile?


42 years old


Bachelor’s degree or higher


At least one IT certification


15 years in a computer
-
related field


9 years in DB development/administration



Do you fit this profile?


Worked 7 years at present company


Plans to stay with present company
indefinitely


Works hard

47 hours/week, performing a
wide

variety of tasks. In fact, …

About the Data


Web
-
based survey conducted June

July 2006, by IT
Community Research (ITCR)


Sample drawn from
Oracle Magazine

readers,
SQL
Server Magazine

readers, and ITCR’s DBA Research
Advisory Panel


Respondents include DB and other IT managers (40%),
DBAs and other IT staff (32%), developers (19%), and
others (9%)


434 respondents completed the survey (+/
-
4.7% margin
of error at 95% confidence)



Agenda


The DBMS market

then & now


DBMSs businesses use

and why


Preparing for the future


Q & A



The DBMS Market

Then

Mid
-
’90s landscape …


Continuing decline of pre
-
relational and object
-
oriented DBMSs


Dramatic growth

of DB sales on Windows NT platform: $180M
in 1995 to $1.5B in 1996


Companies primarily support
single DBMS

platform


Key players:

Oracle, IBM, Microsoft, Sybase, Informix


Notable events:


1995
IBM releases Windows version of DB2



1996
IBM announces DB2 Universal Database; Microsoft releases
SQL Server 6.5; Oracle & IBM jockey for market leadership


1998
Microsoft releases SQL Server 7.0

new architecture and
built
-
in OLAP capabilities elevate SQL Server to enterprise DBMS


1999
Oracle releases Oracle 8
i;

IBM & Oracle deliver Linux versions

The DBMS Market

Then

At the turn of the century …


Emergence of
specialized DBMSs

(Java, XML, mobile,
embedded)


Economic downturn

slows DBMS market growth, but relational
DBMSs exceed 80% of total DBMS market


Price/performance

wars heat up as Oracle, IBM, and Microsoft
battle for market dominance


Notable events:


2000

Oracle releases Oracle 9
i;

Microsoft ships SQL Server 2000

gains unit leadership position in Windows DB market


2002

Microsoft ships Visual Studio .NET and the .NET Framework


2003
Oracle embraces grid computing with Oracle 10
g


The DBMS Market

Now

2004 through today …


Open
-
source DBMSs:
MySQL, PostgreSQL


Emergence of
free/low
-
cost versions

of DBMSs from CA,
Microsoft, Oracle, Sybase, and others


Hot features:

support for Web services, self
-
healing/autonomic,
native support for wider variety of data types, BI/data mining


Migration

to latest versions of products: Oracle 10
g,
SQL Server
2005, IBM DB2 8.2


Proliferation of DBs drives
standardization & consolidation


Explosive growth of data + government regulations drive interest
in
data warehousing & BI


Increasing demand for real
-
time
integration

of structured and
unstructured data

The DBMS Market

Now

Notable events:


2004
DBMS

Market Share (based on revenue)*




Oracle

48.9%

Teradata

3.2%





IBM

22.4%

Sybase

3.0%




Microsoft

13.9%

Others

8.5%




2005
Microsoft releases SQL Server 2005 & Visual Studio 2005



2005

DBMS Market Share (based on revenue)*




Oracle

48.6%

Teradata

3.2%




IBM

22.0%

Sybase

2.9%




Microsoft

15.0%

Others

8.2%



2005

Total relational DBMS revenues increase 8.3% over 2004



Growth rates in revenue (2004 to 2005): Oracle 7.8%, IBM 6.3%,
Microsoft 16.6%
,


Teradata 6.9%, Sybase 6.3%*


*Source: Gartner Dataquest, May 2006

It’s a Heterogeneous World

In addition, a 2006 survey of IOUG members reports that only 7% run pure Oracle
shops

Source: IOUG members survey, April 2006

ITCR survey indicates even higher use of SQL Server and
comparable use of DB2, Sybase, and MySQL

Not only are companies using multiple DBMS platforms

DB use
is more dispersed throughout the company

Business Applications

Top Types Run on Oracle

Top Types Run on SQL Server

1. Financial

1. Business intelligence

2. Enterprise data warehouse

2. Financial

3. Business intelligence

3. Enterprise data warehouse

4. Human resources

4. CRM

5. CRM

5. Human resources

6. ERP

6. Knowledge management

Companies are increasing use of SQL Server for mission
-
critical apps:
68% require SLAs for apps running on SQL vs. 71% for Oracle

Planning for the Future


It’s the perfect time to be in this industry


DBMSs remain at the heart of the IT infrastructure

supporting critical business operations in companies of
all sizes


Gartner predicts a 5
-
yr compound annual growth rate of
7.2% in the relational DBMS market through 2009*


Gartner also maintains that hiring the most highly skilled
and trained DBAs will give companies the greatest
staffing flexibility**

* “Forecast: DB Management Systems Software, Worldwide, 2003
-
2009,” Gartner, September 2005

** “Ten Factors Affect DBA Staffing Requirements,” Gartner, February 2006


Top DB Initiatives in Next 12 Months

Trends

Beyond 2006


Heterogeneous environments are here to stay

companies will choose best
-
of
-
breed DBMSs to gain
flexibility in meeting dynamic business needs


Standardization/consolidation

initiatives will
continue

more doesn’t mean better for TCO


Securing DBs

will remain a high priority, as will
improving
availability

and
disaster recovery


Demand for
automation

will increase, as will the need
for simpler, more unified DB management


Trends

Beyond 2006


Need to handle “
unstructured data
” will grow


Emails, Web pages, call
-
tracking data, reports,
images, voice, …


Forrester estimates that 90% of all business data is
unstructured*


Searchable, easy
-
to
-
access

new requirements


Increasing need for effective
data integration

capabilities

*Forrester, “The Future of DBMS Technology,” 2005

So, what does all this mean to you?

You made the right choice when you entered
the DB field a decade or so ago …


Importance of data management to business has
escalated over time, yielding a
robust career path


Hottest technology jobs:*

#1 (tie) Networking & Help desk/end
-
user support

#2 Applications development

#3 Data/database management





* Robert Half Technology IT Hiring Index and Skills Report, June 9, 2005

You made the right choice when you entered
the DB field a decade or so ago …



Careers in DB management are satisfying, well paid,
and provide ample opportunities for advancement


On a 7
-
point scale, where 1 = Totally dissatisfied and 7 = Totally
satisfied, the
median satisfaction rating

is 6


Top 3 reasons

why:

Challenge of the work, opportunity to work
with/implement new technologies, and overall compensation
received


Managing DBs is challenging work

but also very interesting


Requires creative problem
-
solving skills; successful project
completion increases satisfaction in work performed


Working with new technologies provides opportunity to increase
skills & knowledge

and value as an employee

Compensation & Advancement


58% say their company adequately compensates
them

for their work


42% need an average
increase of 18%

to reach fair
compensation


Median 2006 total compensation: $77,000


DB pros with both Oracle & SQL Server experience: $80,000


Other experience: $75,000


10% premium on SQL Server & Oracle skills
;
7% on IBM skills*


55% have received
4 or more promotions

within
current company


* Robert Half Technology 2006 Salary Guide

How do you prepare for the changing
DB market?

1.
Leverage your knowledge and experience


Companies want individuals who possess strong technological
skills and know how to put those skills to practical use



Core DB education & training

that prepared you for your first
job is still the foundation going forward


Your
skills will transfer

to other platforms


“Learn the basics. If you understand the basics/best practices
of DBs and DB design, the platform won’t matter that much to
you”


How do you prepare for the changing
DB market?

2.
Acquire new skills


Technical
skill sets most in demand

in IT
departments:*


#1 Windows administration

77%


#2 Wireless network management

48%


#3 SQL Server management

47%


#4 Cisco network administration

43%


#5 Check Point Firewall administration

29%


* Robert Half Technology IT Hiring Index and Skills Report, June 9, 2005


Advantages of Oracle & SQL Training

To Your Employer

To You

More efficient & cost
-
effective staffing

Deeper understanding of
relational DBMSs

Capitalize on business
opportunities faster

Ability to select best tool for
each project

Balanced view of both
solutions; not tied to a
single supplier

Career advancement

qualified for more
challenging jobs

Solve a great range of
business problems

Versatility on the job

can
better serve your company

How do you prepare for the changing
DB market?

2.
Acquire new skills, cont’d.


If you have basic knowledge/skills in SQL Server,
keep up
-
to
-
date

and
deepen your knowledge


If SQL Server is new to you,
take action!


Ways to build your SQL Server knowledge


View live or on
-
demand Web casts


http://www.microsoft.com/sql/techinfo/events.mspx


Take a training class or an elearning class

http://www.microsoft.com/sql/techinfo/training
-
courses.mspx


Participate in hands
-
on labs

http://msdn.microsoft.com/virtuallabs/sql/default.aspx



How do you prepare for the changing
DB market?


More ways to build your SQL Server knowledge


Download and use
SQL Server 2005 Express



http://www.microsoft.com/sql/downloads/2005/default.mspx


Check out
SQL Server 2005 Developer Edition



it’s
in your bag


Join SQL Server
user groups/online communities


http://msdn.microsoft.com/sql/community/default.aspx


Bookmark these and other
Web sites
:


http://msdn.microsoft.com/sql/


http://www.microsoft.com/technet/prodtechnol/sql/default.mspx


http://www.microsoft.com/sql/oracledba





How do you prepare for the changing
DB market?

3.
Get certified


“Whether it’s Oracle, SQL Server, or any other DB for that
matter

if you have the time and the resources, get certified
ASAP”


Employers value certification

provides evidence of some
familiarity with the technology & employee initiative


Employees can negotiate
higher salaries


Median salary with both Oracle & SQL Server: $88,000


Median salary with one (Oracle or SQL Server): $80,000


Median salary with neither Oracle nor SQL Server: $75,000


Find complete
SQL Server certification information


http://www.microsoft.com/sql/techinfo/certifications.mspx




In Summary …


Heterogeneous DB environments are here to stay
because they’re beneficial to businesses


Standardize on 2 or 3 DBMSs


SQL Server will likely play some type of role in your
company’s DBMS strategy


Get trained in both Oracle and SQL Server

both you
and your employer win




Q & A