MonetDB - TU Delft

Download Report

Transcript MonetDB - TU Delft

A spatial DBMS buyer’s guide
Wim de Haas - RWS
Wilko Quak - TUDelft
Maarten Vermeij - TUDelft
2008-10-01 FOSS4G Cape Town
1
OTB Research Institute for Housing, Urban and Mobility Studies
Spatial DBMS Buyer's Guide
Overview
•
•
•
•
Short CV
Example: A camera buyer’s guide
Towards a spatial DBMS c
Discussion
2008-10-01
Spatial DBMS Buyer's Guide
OTB Research Institute for Housing, Urban and Mobility Studies
2
Background
• 1994: PhD student in spatial DBMS performance
• 1995: Wrote spatial extension to MonetDB (was fastest
in the world back then)
• 2000-now: work at GIS-technology department and
test various DBMS for various reasons:
• Products: Ingres, Oracle, Oracle topology, Oracle
Point Cloud, Informix, PostGIS, MySQL, ArcSDE, …
• Datasets: Cadastral, Laser Scanning Points, GPS
logs, road maintenance data.
2008-10-01
Spatial DBMS Buyer's Guide
OTB Research Institute for Housing, Urban and Mobility Studies
3
Example: A camera buyer’s guide
Figure out
your profile
2008-10-01
UseCheck
feature
out
matrix
the specs
that matter
Spatial DBMS Buyer's Guide
OTB Research Institute for Housing, Urban and Mobility Studies
4
Towards a spatial DBMS buyer’s
guide?
• Buyer’s Guide (does not exist)
• Feature Matrix:
• Last version compares only (SQLServer, MySQL and
PostGIS.
• Based on documentation and not verified
2008-10-01
Spatial DBMS Buyer's Guide
OTB Research Institute for Housing, Urban and Mobility Studies
5
Let’s write a ‘buyer’s’ guide:
1. Make categories of users:
• Done: FOSS4G2007: Server Builders, GIS Users,
Dataset Maintainer, Power User
2. Figure out relevant feature for each category:
• Todo: See rest of presentation
3. Fill feature matrix:
• Continuous JOB: For community?
2008-10-01
Spatial DBMS Buyer's Guide
OTB Research Institute for Housing, Urban and Mobility Studies
6
Buyer’s guide Feature list
•
•
•
•
•
•
•
•
•
2008-10-01
Functionality
Performance
Ease of Use
Documentation
Hardware needs
Total Cost of Ownership
Integration in business environment
Scaleability
Open Source vs Closed Source
Spatial DBMS Buyer's Guide
OTB Research Institute for Housing, Urban and Mobility Studies
7
Functionality
Same co-ordinate
transformation gives
meters of difference
• Check the documentation.
• Run cross check or test:
2008-10-01
Spatial DBMS Buyer's Guide
OTB Research Institute for Housing, Urban and Mobility Studies
8
Performance (= benchmarking)
• Not as important as you would expect
• In most cases performance is not an issue
• Moore’s law helps a lot
0.06
PostGIS
0.05
MySQL
0.04
0.03
0.02
2008-10-01
Spatial DBMS Buyer's Guide
0.01
OTB Research Institute for Housing, Urban and Mobility Studies
0
9
Ease of Use
• For 1 day of consultancy to improve performance you
can buy a lot of hardware!
• A cumbersome system is not fun:
• A self organizing DBMS might save a lot of work:
• Adherance to standards saves time (Learn another
dialect of SQL, Please: polygons in WKT)
• Readable documentation helps
2008-10-01
Spatial DBMS Buyer's Guide
OTB Research Institute for Housing, Urban and Mobility Studies
10
PostGIS
Documentation
Oracle
2008-10-01
Spatial DBMS Buyer's Guide
OTB Research Institute for Housing, Urban and Mobility Studies
11
Total Cost of Ownership
• Open Source = free
• Cost for support
• Hard to find support staff
2008-10-01
Spatial DBMS Buyer's Guide
OTB Research Institute for Housing, Urban and Mobility Studies
12
Integration
• How well does the DBMS integrate with other
products:
• SOAP
• JDBC
• Hibernate
• The rest of the GIS stack
2008-10-01
Spatial DBMS Buyer's Guide
OTB Research Institute for Housing, Urban and Mobility Studies
13
Scaleability
• Very hard to predict without testing.
• Most functions look like this:
There might be
another
breakpoint here
0.06
There is a
breakpoint
here
0.05
PostGIS
MySQL
0.04
0.03
0.02
2008-10-01
Spatial DBMS Buyer's Guide
0.01
OTB Research Institute for Housing, Urban and Mobility Studies
0
14
Open Source or not?
• Vendor Lock-in is EVERYWHERE:
2008-10-01
Spatial DBMS Buyer's Guide
OTB Research Institute for Housing, Urban and Mobility Studies
15
Discussion
2008-10-01
Spatial DBMS Buyer's Guide
OTB Research Institute for Housing, Urban and Mobility Studies
16