A spatial DBMS buyer’s guide Wim de Haas - RWS Wilko Quak - TUDelft Maarten Vermeij - TUDelft 2008 -10 -01 FOSS 4 G 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 buyer’s guide Discussion 2008 -10 -01 Spatial DBMS Buyer's Guide OTB Research Institute for Housing, Urban and Mobility Studies 2
Background • 1994: Ph. D student in spatial DBMS performance • 1995: Wrote spatial extension to Monet. DB (was fastest in the world back then) • 2000 -now: work at GIS-technology department and test various DBMS for various reasons: • Products: Ingres, Oracle topology, Oracle Point Cloud, Informix, Post. GIS, My. SQL, Arc. SDE, … • 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 Use. Check out feature 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, My. SQL and Post. GIS. • 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: FOSS 4 G 2007: 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 There are big differences between query optimizers 2008 -10 -01 Spatial DBMS Buyer's Guide OTB Research Institute for Housing, Urban and Mobility Studies 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
Post. GIS 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 There is a breakpoint here 2008 -10 -01 Spatial DBMS Buyer's Guide OTB Research Institute for Housing, Urban and Mobility Studies 14
Open Source or not? • Vendor Lock-in is EVERYWHERE: Marks from old nonstandard sized toilet paper dispenser 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
Скачать презентацию A spatial DBMS buyer s guide Wim de Haas
3382b7712e2768e41fbce3216c574d23.ppt