Learning the Database Landscape in the Opensource World

1
Learning the Database Landscape in the Opensource
World
Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
2
Learning the Database Landscape in the Opensource
World

• PART I surveying the land
• PART II taking a walk in the park, MySQL vs
  PostgreSQL
• PART III welcome to a brave new world, making
  the commitment
• PART IV concluding remarks

rbernier_at_mediosystems.com
3
PART I surveying the landscape

• About this presentation
• A definition of power
• In the beginning...
• The significance of license, "la raison d'être"
• Databases deciding which one is better... yeah
  right!

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
4
PART I surveying the landscape

• The objective of this talk is to empower you in
  your decision making process vis a vis database
  systems in the workplace

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
5
PART I surveying the landscape

• About Power
• it's not money or influence
• It's knowledge
• Power is the awarenes of the significance of
  events of the past and present and leveraging it
  to one's advantage before anyone else figures it
  out

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
6
PART I surveying the landscape

• IN THE BEGINNING...?

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
7
PART I surveying the landscape

• Dawn Of The Relational Model
• Ted Codd (1970) and his Rules for Relational
  Databases

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
8
PART I surveying the landscape

• Three Great Contemporary Forces
• IBM
• ORACLE
• University of Berkley California(a product of
  the Military-Industrial-Academic Complex)?

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
9
PART I surveying the landscape

• The Significance Of License, "La raison d'être"
• The implications of closed vs open vs bsd vs gpl
  licensing
• Berkeley Software Distribution (BSD)?
• GNU General Public License (GPL)GNU GNU General
  Public LicenseGNU GNU GNU General Public License

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
10
PART I surveying the landscape

• More About the Opensource Licenses
• BSD the race to get the best academic minds
• GPL revenge is sweet, the Richard Stallman saga

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
11
PART I surveying the landscape

• Deciding which one is better
• Corporate culture (established vs startup)?
• The people
• The DBA (or lack of)?
• Current technology (even the OS makes a
  difference)?
• The requirements
• Making comparisions the effects of licensing

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
12
PART II Taking a walk in the garden, MySQL vs
PostgreSQL

• An everyman's history of Postgres and MySQL IN
  THE 90's
• The effects of license

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
13
PART II Taking a walk in the garden, MySQL vs
PostgreSQL

• An everyman's history of Postgres and MySQL IN
  THE 90's
• Both have already been long in existence but then
  the Internet came along
• The state of PostgreSQL and its early adopters
• The state of MySQL and its early adopters

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
14
PART II Taking a walk in the garden, MySQL vs
PostgreSQL

• The effects of license
• popularization
• how the GPL license centralizes and coordinates
  mindshare
• how the BSD license encourages decentralization
  of control and encourages innovative paradigms
• perception, the appearance of superiority
• corporatization and the monetizing of mindshare
• GPL transforms into a commercial entity
• BSD fragments mindshare development is
  localized, overall development is only possible
  on the technology itself i.e. no marketing, no
  training, no publications etc.

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
15
PART III WELCOME TO A BRAVE NEW WORLD

• Finding qualified candidates
• Training new people
• Working with consultants
• The opensource help desk

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
16
PART III WELCOME TO A BRAVE NEW WORLD

• Finding qualified candidates
• Ideal educational background... you've got to be
  kidding!
• Work history traditional vs non-traditional
• Looking for people with an online presence
• mail lists
• forums
• Linklin
• Facebook
• Twitter
• Google

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
17
PART III WELCOME TO A BRAVE NEW WORLD

• Training new people
• educational institutions
• in house
• corporate

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
18
PART III WELCOME TO A BRAVE NEW WORLD

• Working with consultants (when employees aren't
  enough)?

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
19
PART III WELCOME TO A BRAVE NEW WORLD

• The opensource Help Desk.... HUH?

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
20
PART IV CONCLUDING REMARKS

• Fighting the rush towards opensource
• Fitting in with the traditionals
• Regarding the corporatization of opensource
• A final word...

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
21
PART IV CONCLUDING REMARKS

• Fighting the rush towards opensource.

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
22
PART IV CONCLUDING REMARKS

• Fitting in with the traditionals

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
23
PART IV CONCLUDING REMARKS

• Regarding the corporatization of opensource

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
24
PART IV CONCLUDING REMARKS

• A final word...
• it's not the technology (it's the politics),
  stupid!

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com
25
Learning the Database Landscape in the Opensource
World

• References

Learning the Database Landscape in the Opensource
World
rbernier_at_mediosystems.com