Transcript Document
Oracle Spatial Summit 2015 Session Title Presenter Name, Title Company All Oracle Spatial Summit Speakers – • Please complete the following Case Study Summary slide • Note: please insert quantified benefits where possible ($/time saved, efficiencies achieved, performance gains, # users, size of databases/ amount of spatial data) Organization Name Name of deployed project/system OVERVIEW Describe your organization & system at a high level. Your corporate marketing, website, or public relations/media usually contain this info • Industry, size of organization, customer base, # of customers, Insert your company logo here Insert application screenshot here etc., prominent corporate metrics. • Describe IT/database/spatial system at high level; internal & external /customer users CHALLENGES / OPPORTUNITIES Describe the challenges, requirements for spatial / business data management • Need for X% performance improvement on spatial queries, scalability, security for mission critical data • Need to integrate disparate data sets • Data integrity, accuracy issues SOLUTIONS List specific Oracle and other technologies used. Please include specific versions where available • Oracle Database 12c Enterprise Edition • Spatial Option with GeoRaster, Network Data Model • Partitioning • Oracle Fusion Middleware 11.1.1.7 • MapViewer • Oracle Business Intelligence Enterprise Edition RESULTS Include quanitified benefits where possible, and include size of spatial database / type of spatial data / # of users, departments served by production system • Achieved X% performance improvement and reduced query times • Consolidation of raster, vector, network data in X TB sized central repository • Organization now better understands activities in context of location • Improved precision thereby making system more useful to the public and business EXAMPLE: INFOTECH KKB (Credit Registry Office) - GEOMIS OVERVIEW • Customer : KKB (Turkish Credit Registry Office) • The Only Credit Registry Office in Turkey Supports, 145 Members 39 Banks, 13 Consumer Finance etc. • Supports Business Functions, Departments, Constituents CHALLENGES / OPPORTUNITIES • Nationwide address cleanup and geocoding ( 700 M records) • Map based statistical data display • Different access levels for different banks • Detailed reporting : Standard, trend, benchmark • Spatial, Datawarehouse and OLTP Requirements SOLUTIONS • Oracle Database 11g Enterprise Edition • Spatial Option with GeoRaster, Network Data Model • Partitioning • Oracle Fusion Middleware 11.1.1.7 • MapViewer • Oracle Business Intelligence Enterprise Edition • Oracle Exadata RESULTS • Instead of investing on different systems for Spatial, Datawarehouse, OLTP one system to serve all • Lower license and hardware costs • Easier management • Single system with no extra integration • Consolidation • OLTP and Reporting • Performance • 25x faster transaction processing • 100x faster reports • Storage • 5x compression • Fast spatial operations • 40 M Geocodes / day Speaker Bio Oracle Spatial Summit 2015 Agenda Oracle Spatial Summit 2015 Objectives Oracle Spatial Summit 2015 Key Takeaways Oracle Spatial Summit 2015 Oracle Spatial Summit 2015 Oracle Spatial Summit 2015