1 / 25

Database trends

Database trends. Philip Howard Research Director – Bloor Research. Agenda. Transactional trends (some common) Trends common to transactional and warehouse environments Warehousing trends. Transactional trends. XML Hardware integration Solid state disks Oracle portability Data migration

samson
Download Presentation

Database trends

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database trends Philip Howard Research Director – Bloor Research

  2. Agenda • Transactional trends (some common) • Trends common to transactional and warehouse environments • Warehousing trends

  3. Transactional trends • XML • Hardware integration • Solid state disks • Oracle portability • Data migration • Continuous availability

  4. XML • Increasing use of applications combining relational and XML data • Two ways to support XML: • Logically – means the database understands XML but converts it into relational format or stores it separately • Structurally – means the database stores XML as XML AND understands it logically

  5. Hardware integration

  6. Oracle portability

  7. Oracle portability IBM has tested more than 750,000 lines of PL/SQL and it has achieved an average compatibility of 98.43%.

  8. Data migration • Much less risky than it used to be • Better tools • More understanding • Methodologies and best practices • Zero-downtime migrations

  9. Continuous availability • High availability caters for unplanned downtime • Continuous availability caters of planned and unplanned downtime

  10. Transactional/Warehousing trends • Archival • Green • Appliances/Ease of implementation • Autonomics • Performance • Scalability

  11. Archival • Saves storage costs • Reduces footprint • Improves performance • Releases resources

  12. Green • Reduced electricity requirements • Reduced cooling • Reduced footprint Enables cost savings

  13. Appliances & implementation • Single install • Minimum time to system coming up • Convenience

  14. Autonomics • Reducing administration requirements • Automated performance tuning and recommendations

  15. Performance Always a requirement – enabled by many of the other trends under discussion photo by Amnemona

  16. Scalability • Always a requirement • Needs to be easy to achieve

  17. Warehousing trends • In-database analytics • Compression • Encryption • Low latency analytics • MapReduce and R • Spatial and other data

  18. In-database analytics Much, much faster and more accurate if run in-database

  19. Compression • Saves disk space • Reduces costs • Improves performance • The broader the application the better • Need implementation at column level for best results

  20. Encryption • Required for many data protection environments (with masking) • Should be implemented at column level to minimise performance implications

  21. Low latency applications Real-time web analytics, fraud detection, capital markets, telecommunications call analysis, online gaming, social media, web comparison sites, sensor-based applications …

  22. New analytics support

  23. Spatial data

  24. Conclusion • There are many trends in database technology • Some provide new or additional functionality • Almost all provide either reduced costs or better performance or both

More Related