PostgreSQL for business data Gabriele Bartolini - Sardegna Ricerche

arizonahoopleΔιαχείριση Δεδομένων

28 Νοε 2012 (πριν από 4 χρόνια και 11 μήνες)

293 εμφανίσεις

www.2ndQuadrant.com
PostgreSQL for business data
Gabriele Bartolini
<Gabriele
at
2ndQuadrant.com>
http://www.2ndQuadrant.it/
Free Software – A Community for a new Business Model
10 June 2010, Pula, Sardinia
www.2ndQuadrant.com
Table of contents

Databases and database management systems

PostgreSQL: open-source database

PostgreSQL for business data

2ndQuadrant: open-source company
www.2ndQuadrant.com
Databases and DBMS
Software applications
Software applications
DBMS
SQL
www.2ndQuadrant.com
Databases? They are everywhere!

On the web:

Blogs and CMSs

Social networking

E-commerce applications

Home banking

In real life:

Bank

Supermarket

Telecommunications

For your business:

CRM and ERP systems

Business Intelligence and Decision Support Systems

...
www.2ndQuadrant.com
PostgreSQL (or simply Postgres)

Open-Source Database Management System

Community driven project

No single company that owns the code

High quality collaborative development

Some of its key features:

Compliance to standards (SQL)

Multi-Version Concurrency Control

ACID Transactions

Point In Time Recovery

Replication

Extensibility (data and functions)
www.2ndQuadrant.com
The European Commission ...


approved the acquisition of Sun by Oracle (January
21
st
2010)

The official statement: “
The Commission's
investigation showed that another open source
database, PostgreSQL, is considered by many database
users to be a credible alternative to MySQL and could
be expected to replace to some extent the
competitive force currently exerted by MySQL on the
database market.

Source:
http://europa.eu/rapid/pressReleasesAction.do?reference=IP/10/40&format=HTML&aged=0&language=EN&guiLanguage=en
www.2ndQuadrant.com
Databases should be ...

Fast

Consistent

Reliable

Secure

Integrable

Available

Recoverable
www.2ndQuadrant.com
PostgreSQL allows a database to be ...

Fast

Consistent

Reliable

Secure

Integrable

Available

Recoverable
www.2ndQuadrant.com

and reduces the costs

No license fee

Simple license model

No dual licensing headaches

Reduces the total cost of ownership (TCO) for a
database solution

Invest in knowledge

Removes any vendor lock-in / monopolisation

Largest community for an open-source database
management system project
www.2ndQuadrant.com
Many businesses run on PostgreSQL

Mission critical environments


Five nines” requirements for high availability (HA)

Disaster recovery

Scalability

An example:

Skype stores up to 1 billion user's profiles on PostgreSQL
databases
www.2ndQuadrant.com
About 2ndQuadrant

Professional Open-Source Software House

Directly represented in 6 countries

What we do

Open-Source business model

Design, Develop and Support PostgreSQL

We deliver high quality professional services

Leaders in HA, Recovery, Scalability and Performance

Training

24x7 support for PostgreSQL production environments

First company to adopt the “Follow the sun” support model,
with centres in America, Europe and Australia

R&D funding by European Union - FP7 programme for
Cloud extensions to PostgreSQL from 2010-12
www.2ndQuadrant.com
References

PostgreSQL:
http://www.postgresql.org/

2ndQuadrant:
http://www.2ndQuadrant.com/

Contact information:

Gabriele Bartolini <
gabriele@2ndQuadrant.com
>
www.2ndQuadrant.com
License

Creative Commons:

Attribution-Non-Commercial-Share Alike 2.5

You are free:

to copy, distribute, display, and perform the work

to make derivative works

Under the following conditions:

Attribution. You must give the original author credit.

Non-Commercial. You may not use this work for commercial
purposes.

Share Alike. If you alter, transform, or build upon this work, you
may distribute the resulting work only under a licence identical
to this one.