Database Management Trends:  1987 to 2008 and onwards

Database Management Trends: 1987 to 2008 and onwards

Loading
Loading Social Plug-ins...
Language: English
Save to myLibrary Download PDF
Go to Page # Page of 10

Description: Since I Believe the Following The earth is flat, LBJ "pulled the trigger"… presentation covers Database Management Influencers, automation, what has changed, less manual intervention, more software complexity, GUIs: Oracle, IBM DB2, SQL Server, MySQL, how IT Initiatives get Derailed. Outsourcing Can Fail If Decision based on price alone Offshore selected with little attention to bandwidth and native infrastructure Management "legislates" Technicians not 100% fluent in language of the company.

 
Author: Michael S. Abbey —Database Officer, Oracle Practice (Fellow) | Visits: 1570 | Page Views: 1571
Domain:  High Tech Category: IT Subcategory: Databases 
Upload Date:
Short URL: https://www.wesrch.com/electronics/pdfEL11TZG09RAZL
Loading
Loading...



px *        px *

* Default width and height in pixels. Change it to your required dimensions.

 
Contents:
www.ntirety.com

Disclaimer Trends in Database Managenent
is this 1987 or 2008? NOUG March 5, 2008
Michael S. Abbey -- Database Officer Oracle Practice

If anything I say pinches a nerve ... please remember that I can take objection to just about anything. Things I say or do for the next 40-50 minutes are deliberately "lightened-up" for the sake of the delivery of this keynote and your enjoyment . . .
2

Michael S. Abbey -- Trends in Database Management

Since I Believe the Following
� The earth is flat � LBJ "pulled the trigger" � An email you receive may format your hard drive � Your offspring will not wet the bed if you cut them off from all liquids after 7PM � America will never elect an ex-Hollywood actor President
3

Underpinnings of Our Industry

Michael S. Abbey -- Trends in Database Management

4

Michael S. Abbey -- Trends in Database Management

1

Brief History of Computers
1640 Blaise Pascal invents the first commercial calculator, a hand powered adding machine. 1801 Joseph-Marie Jacquard builds a loom that weaves by reading punched holes stored on small sheets of hardwood. 1820's Charles Babbage begins his lifelong quest for a programmable machine, working on a "difference engine".
5

Brief History of Computers
1842 Using Babbage's technology, Ada Lovelace mechanically translates a short written work. 1892 Shortly after the marketing of the first printing calculator, William Burroughs follows with the release of an electronic model. 1925 Vannevar Bush of MIT builds a machine he calls the differential analyzer ... the machine can handle simple calculus problems, but accuracy is a problem.
6

Michael S. Abbey -- Trends in Database Management

Michael S. Abbey -- Trends in Database Management

Brief History of Computers
1936 John Vincent Atanasoff begins work on a digital computer in the basement of the Physics building on the campus of Iowa State. 1944 The Havard Mark I is introduced, based on a series of proposals from Howard Aiken in the late 1930's. 1951 UNIVAC delivered to the Census Bureau, resulting in a tremendous financial loss to its manufacturer, Remington-Rand.
7

Brief History of Computers
1961 Fairchild Semiconductor introduces the integrated circuit. Within ten years all computers use these instead of the transistor. 1964 IBM introduces the System/360. While a technical marvel, the main feature of this machine is business oriented. 1975 The first personal computer is marketed in kit form. The Altair features 256 bytes of memory. Bill Gates, with others, writes a BASIC compiler for the machine
8

Michael S. Abbey -- Trends in Database Management

Michael S. Abbey -- Trends in Database Management

2

Brief History of
1979 First commercial SQL RDBMS. 1984 1985 1986 1988 1992 1993 1994
9

Brief History of
1996 Open-standards, web-enabled architecture. 1997 1998 1999 2000 2001 2002 First web database First to release comprehensive CRM Suite, First database with XML support. First Internet development suite. TCP-H world record on 3 terabyte repository. First to pass 15 industry standard security evaluations

First database with read consistency. First parallel server database. First client-server database. PL/SQL released. Full suite of applications. Character-mode moved to client-server model. First video server supporting media on demand.
10

Michael S. Abbey -- Trends in Database Management

Michael S. Abbey -- Trends in Database Management

Brief History of
2003 Introduction of Enterprise Grid Computing with Oracle Database 10g 2004 First to provide a single customer view from multiple data sources. 2005 Releases its first "free" database. 2006 First Unstructured Content Database. 1 2 3 4 5 6
12

What Version are you Running
?? 1980 1982 1984 1986 1988 Written in assembly language for the PDP11 and never released. First commercial database using SQL. Written in "C" and bragged about transaction processing. Read consistency. A true client-server solution. Parallel server and a tpo add-on.

11

Michael S. Abbey -- Trends in Database Management

Michael S. Abbey -- Trends in Database Management

3

What Version are you Running
7 8 9 10 11 1993 Landmark release with procedural, distributed, and parallel query options. 1997 Scalability and object relational features. 2001 Strong (?) Application Server offering, RAC, and suite of analytical functions. 2004 Welcome to grid computing and ASM 2007 The benefits of grid computing, automation, and more self-management. Michael S. Abbey -- Trends in Database Management

Database Management Influencers
� � � � Automation Compliance issues Insistence on best practices More robust high-availability solutions � Swelling volumes of data � Increased complexity of the software
14

13

Michael S. Abbey -- Trends in Database Management

Automation
� Is it a good thing
� does the vendor know best � how does the vendor know � "mickey-mouse" minding of this and that

Compliance
� Ongoing or probl�me du jour
� the latest and greatest � here today gone tomorrow?

� Password management . . .
� universally inconvenient � who is exempt � soxadmin s0xadm1n Michael S. Abbey -- Trends in Database Management

� How far should it go
� unattended this and that � risk of un-noticed failure Michael S. Abbey -- Trends in Database Management

15

16

4

Best Practices
� Are they universal
� so subjective based on one's successes in the past � generic industry standard or softwarespecific

High-availability
� Has always been a raison d'�tre for the DBA � So vaat's new ...
� when you really get into the bowels of the offering ... not much !!!!!!!! � new packaging of rock-solid solutions

� How does one teach an old dog new tricks? � Formulation is easy; implementation difficult; enforcement next to impossible
17

� What is really new?
� pricing � bundling
18

Michael S. Abbey -- Trends in Database Management

Michael S. Abbey -- Trends in Database Management

19

010100011101001010101011101010101000010101 000111010010101010111010101010000101010111 010100011101001010101011101010101000010101 000111010010101010111010101010000101010111 010100011101001010101011101010101000010101 � 000111010010101010111010101010000101010111 Gigabytes Terabytes Petabyte Exabyte 010100011101001010101011101010101000010101 000111010010101010111010101010000101010111 010100011101001010101011101010101000010101 000111010010101010111010101010000101010111 010100011101001010101011101010101000010101 000111010010101010111010101010000101010111 � 010100011101001010101011101010101000010101 Advancements in disk and memory speed ... 000111010010101010111010101010000101010111 � influenced the size of repositories 010100011101001010101011101010101000010101 � not completely negated the effect 000111010010101010111010101010000101010111 010100011101001010101011101010101000010101 Michael S. Abbey -- Trends in Database Management 000111010010101010111010101010000101010111

More and More Data

Increased Complexity
� Is that the
� nature of the problem? � or the nature of the solution?

� Driving force behind increased complexity
� the customer � a very small percentage of clients � thirst of the vendor Michael S. Abbey -- Trends in Database Management

20

5

What Has Really Changed
� Less manual intervention ... negated by the complexity of the software and the size of the repositories � Automatic space management ... negated by the the sheer number of databases being managed � Fancy GUI tools ... are they part of the solution or part of the problem
21

GUI Database Management
� Oracle: Database control / Grid control � IBM: DB2 Performance Expert ... DB2 Query Patroller � SQL Server: All encompassing management console � MySQL: Administrator / Query Browser / Workbench
22

Michael S. Abbey -- Trends in Database Management

Michael S. Abbey -- Trends in Database Management

What Do They Offer
� � � � � � � Lots of screens Timely information Advisors Drill-down Pretty graphs Enhanced VFM One-stop shopping � � � � � � � Too many screens Too much information Confusers Confusers Too much information Enhanced A/R One-stop shopping

When They Make Sense
� New administrators / getting up to speed � Quick access to powerful management � Look under the covers not available any other way � Knowledge is information
24

� Would you trust them with the password(s)? � Easier to mess things up (turbo-prop Airbus) � Too much information, making change decisions more complicated � Knowledge can be dangerous

23

Michael S. Abbey -- Trends in Database Management

Michael S. Abbey -- Trends in Database Management

6

The Human Factor
� Strategic IT decisions made at the top of organizations influenced by
� personal preferences � past employment history � past experiences with vendors

IT Initiatives Derailed By
� � � � � � Bickering Empire building Pursuit of job security Immaturity Lack of co-operation Fixed in my ways � Personal prejudices � Self-centred participants � Poor hardware and software decisions � Stubborn people

� The public sector controlled by those with a "right" to be promoted
25

Michael S. Abbey -- Trends in Database Management

26

Michael S. Abbey -- Trends in Database Management

What Has Changed
� � � � � � The players The strength of the hardware The features of the software The throughput of the networks � � � �

Database Management 80's
In-house Full-time employees Some 3rd party consultants in the mix Benefits / sick leave / holidays add 20-30% on top of base salary � Training and keeping up expensive and a human resource management nightmare
28

The cost of the hardware The cost of the software
Michael S. Abbey -- Trends in Database Management

27

Michael S. Abbey -- Trends in Database Management

7

Database Management 90's
� Mix of employees and 3rd party vendors
� pieces of the pie outsourced completely � cost savings in the short-term � state-of-the-art support moving forward with the software

Database Management 20's
� Outsourcing on the rise � Over $55 billion and rising � Upwards of 40% cost savings
� attractive � double-edged sword

� Dwindling IT budgets peaking towards end of decade � Asia and the far east
29

� Same firm providing support in related areas (database management / system administration)
30

Michael S. Abbey -- Trends in Database Management

Michael S. Abbey -- Trends in Database Management

Outsourcing Can Fail If ...
� Decision based on price alone � Offshore selected with little attention to bandwidth and native infrastructure � Management "legislates" the move � Provider unwilling to share � Technicians not 100% fluent in language of the company
31

According to Gartner
1. To control cost over time 2. To provide access to highly skilled technical resources as needed 3. To enable the internal IT organisation to refocus on mission-critical, businessdifferentiating services to provide a higher level of strategic value to the business units
32

Michael S. Abbey -- Trends in Database Management

Michael S. Abbey -- Trends in Database Management

8

According to Gartner
4. To increase the quality of service delivery 5. To create access to scalability

The single characteristic of IT that makes one wonder ... is this 1987 or 2008???

. . . organisations need to take a longer term view of what an outsourcing relationship can accomplish for their operations overall.
33

Michael S. Abbey -- Trends in Database Management

34

Michael S. Abbey -- Trends in Database Management

Unique Opportunity
� � � � Within the next 6-9 years Something that has never happened before Could revolutionize the industry May allow companies to explore new ways to
� manage their databases � satisfy their business' thirst for quality � undue mistakes of the past
35

Michael S. Abbey -- Trends in Database Management

36

Michael S. Abbey -- Trends in Database Management

9

37

Michael S. Abbey -- Trends in Database Management

fenderpbs
39

Michael S. Abbey -- Trends in Database Management

10

Subscribe
x