![Page 1: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/1.jpg)
Managing Multi-DBMS
on a Single UI
a Web-based Spatial DB Manager
BJ Jang, Hyun Jong Cho
![Page 2: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/2.jpg)
Web-based Spatial DB Manager
Tadpole SDM
2
![Page 3: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/3.jpg)
3
TadpoleSDM
On a single UI by WEB
![Page 4: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/4.jpg)
4
![Page 5: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/5.jpg)
5
Spatial DB Manager
Tadpole SDM
DB
Admin
GIS
Guy
I don’t know how to manage Spatial Data.A geometry column is always shown as blank
or unknown characters.
I don’t know how to view common tables.What is Index? I just know Spatial Index.Do common tables
also have R-Tree Index?
![Page 6: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/6.jpg)
Features of Tadpole SDM
6
Is web-based
Manages spatial data
Works as SaaS
Draws Queried Geometry Quickly
Shows the selected Row in the table to the Map
Displays which DB object has Spatial Data
![Page 7: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/7.jpg)
7
![Page 8: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/8.jpg)
8
Do you know what Tadpole is?
![Page 9: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/9.jpg)
9
Do you know what Tadpole is?
![Page 10: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/10.jpg)
10
Internet
Cloud
https://github.com/hangum/TadpoleForDBTools
Since 2011
![Page 11: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/11.jpg)
Current Features of Tadpole
11
Manage user permissions Querying Tool View ERD Report DB Status Register/run Schedule Manage DML history Manage DDL history Manage User Resources Import RDB to NoSQL
![Page 12: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/12.jpg)
Emergency Event
Plan about Tadpole Version 2
12
Extends to be a Monitoring Tool
Monitoring SLOW Query
Query Profiling
Monitoring CPU & Disk
Adding User Indicators
Notify Users
Backup / Restore
REST API
![Page 13: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/13.jpg)
13
![Page 14: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/14.jpg)
Display on the normal map
14
![Page 15: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/15.jpg)
Display on the heatmap
15
![Page 16: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/16.jpg)
Display on the marker cluster map
16
![Page 17: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/17.jpg)
17
Architecture
Eclipse Equinox(OSGi)
SupportDB
Tadpole DB Hub System
SQLiteExt
CubridExt
MongoDB Ext
TajoExt
Tadpole Scheduler
Logger Manager
Audit Manager
Tadpole Extension Points
MySQLExt
OracleExt
MariaExt
MSSQLExt
User Manager
HiveExt
PgSQLExt
AWS Ext
ETC DBExt
SQLite
ERD Viewer
MySQL
SQL Manager
Tadpole Cipher
Map ViewExtension
![Page 18: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/18.jpg)
18
L.CanvasOverlay: http://bl.ocks.org/sumbera/11114288HeatmapOverlay: http://www.patrick-wied.at/static/heatmapjs/example-heatmap-leaflet.html
Leaflet.markercluster: https://github.com/Leaflet/Leaflet.markercluster
![Page 19: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/19.jpg)
19
![Page 20: Managing Multi-DBMS on a Single UI, a Web-based Spatial DB Manager-FOSS4G Asia 2014](https://reader033.vdocuments.us/reader033/viewer/2022060123/559772851a28ab3d0e8b4845/html5/thumbnails/20.jpg)
Contact Us
Download PPT http://www.slideshare.net/jangbi882/presen
tations
Tadpole SDM Homepage https://github.com/Gaia3D/SpatialDataMana
ger
Tadpole DB Hub Homepage https://github.com/hangum/TadpoleForDBT
ools/wiki
E-Mail jangbi882 at gmail.com (for Tadpole SDM) hangum at gmail.com (for Tadpole DB Hub)
20