12c launch webcast - key data warehousing features explained
In case you missed Wednesday's Oracle Database 12c launch webcast then the good news is that it is now available for on-demand replay. The live session was amazingly well attended and the questions posted by the participants were great. There were quite a few data warehousing questions posted and I think I managed to answer nearly all of them. If I missed your particular question then let me know and I will make sure you get an answer.
During the webcast Tom Kyte offered his "Top 12 features of Oracle Database 12c" and there were quite a few data warehousing features that made it on to his list:
- SQL analytics row_limiting/Top-n
- Pattern matching
- Partitioning enhancements
- Adaptive execution plans
alternatively you can click here to watch the webcast. FYI - there is a registration process but it is quite painless.
Once you watched the webcast I expect you will want to get more information about each of these features so below I have provided a brief overview of each feature and a link to the feature whitepaper:
Adaptive Query Optimization - The new groundbreaking adaptive query optimization in Oracle Database 12c enables the Optimizer to make runtime adjustments to execution plans and to discover additional information that can lead to better statistics. Learn about this exciting new functionality here. The home page on OTN is here.
SQL Pattern Matching - The new groundbreaking SQL pattern matching capabilities brings the simplicity and efficiency of the most common data analysis language to the process of identifying patterns within a data set. It provides a completely new native SQL syntax that has adopted the regular expression capabilities of Perl by implementing a core set of rules to define patterns in sequences (streams of rows). Learn about this exciting new functionality here. The home page on OTN is here.
Partitioning - Oracle has enhanced the functionality of Oracle Partitioning with every release, by either adding new partitioning techniques, enhancing the scalability, or extending the manageability and maintenance capabilities. Oracle Database 12c is no different by offering enhanced composite partitioning strategies and vastly enhanced partition maintenance operations. Learn about this exciting new functionality here. The home page on OTN is here.
Heat Map- stores system-generated data usage statistics at the row and segment levels – information that can be used to automate the compression and movement of data in order to reduce storage costs, improve performance and optimize Oracle Database storage. Heat Map, used in conjunction with Automatic Data Optimization can automate compression and storage policies based on the usage of the data. Learn about this exciting new functionality here. The home page on OTN is here.
Hope the above is useful.