スライド 1

newshumansvilleGestion des données

16 déc. 2012 (il y a 4 années et 9 mois)

164 vue(s)

Collaborating with OSS
communities
SRA
OSS, Inc.
Japan
Copyright ©2006 Japan OSS Promotion Forum1
Agenda

PostgreSQL
is “world’s most advanced
open source database”

Very popular among world-wide users
especially in Japan

OSS collaboration case studies on
PostgreSQL

The community

Collaboration examples
Copyright ©2006 Japan OSS Promotion Forum2
PostgreSQL
development community

PostgreSQL
Global Development Group

core members and major developers

Core members

7 core members

Highly skilled developers

Advocacy activities

Support for development infrastructures

Mailing lists, CVS…

Major developers

20-30 developers

some developers have commit rights
Copyright ©2006 Japan OSS Promotion Forum3
PostgreSQL
user community

Regional user communities (in 12
countries including Japan)

Probably the largest user community is in
Japan
Copyright ©2006 Japan OSS Promotion Forum4
Japan PostgreSQL
Users Group(JPUG)

Non-profit organization established in 1999

has 2856 members (as of 2006/4/10)

has 18 sponsor members

Fujitsu, NEC, NTT group, SRA OSS, Inc. etc.

community support for Japanese using mailing
lists

Document translation

Seminars

Publishing
Copyright ©2006 Japan OSS Promotion Forum5
PostgreSQL
and other DBMSs
usage on
Linux systems in Japan
.
Z4
2-



%#
  
4ZNGP
SXBS
F







)J3%# 


1PX
F
S(SFT 

ﬞ  
0S
BDMF





1PTUHSF42- 

Data from IT
ʢ̌̌̏ﳥ)
Copyright ©2006 Japan OSS Promotion Forum6
SRA OSS, Inc.

PostgreSQL
and other OSS related
business

Packages: PowerGres

Based on PostgreSQL

Comes with GUI tool

PostgreSQL
support

Providing high-level support

Certification

PostgreSQL
CE

World wide (Japanese and English)

Training
Copyright ©2006 Japan OSS Promotion Forum7
Helping PostgreSQL
community

Helping JPUG in various areas

Financial support

JPUG office/clerk

Presentation in seminars hosted by JPUG

“PostgreSQL
conference 2006”
in Tokyo

~100 audiences
Copyright ©2006 Japan OSS Promotion Forum8
Collaboration example: PowerGres

PowerGres

commercial database based on
PostgreSQL

Ported to Windows

Until 2003 PostgreSQL
was not
available on Windows

Techiniques
on porting to
Windows were contributed to
PostgreSQL
community

PostgreSQL
community version
for Windows released on 2004
Copyright ©2006 Japan OSS Promotion Forum9
Other case studies

Bug/security fixes

Data loss problem was reported from a PostgreSQL
support customer. We worked with a payed
consultant
and sent the fix to community(1999)

We found a DoS
attack possibility with PostgreSQL
running on Windows and reported to core members then
version was released(2006)

Internationalization

Key feature for Asian users

Code for i18n has been contributed since 1998
Copyright ©2006 Japan OSS Promotion Forum10
Conclusion

Collaboration between OSS communities
and business entities is key for OSS future
Business
entities
OSS
communities
Experiment in the real world
Bug fix and code enhancement
Financial support
High performance, reliable
high quality Open Source Software
Users
Commercial support
Certification
Training