Oracle Database 12c delivers big data and data warehousing for the Enterprise

By -
We have just released a series of five short video interviews with George Lumpkin, Vice President of Product Management, on the new 12c features that related to big data and data warehousing. I am pleased to see the new SQL pattern matching capabilities get in mention in chapter 2 - a quick recap if you missed my recent blog posts
SQL Pattern Matching introduces a new SQL syntax, along with optimized performance, for detecting patterns in a sequence of events stored in a database table. For example, one might want to look for trends in a stock price, or for suspicious behavior stored in activity log. With Oracle 12c, these queries can be expressed in a simple syntax, without requiring recursive joins or other complex SQL constructs.
For more information on SQL pattern matching visit the home page on OTN (click here).
In the section on easier management, chapter 3, George discusses the new partitioning features that we have added to make general maintenance and information lifecycle management operations much easier.
Oracle Database 12c now allows partition maintenance operations on multiple partitions as single atomic operation: for example, you can merge the three partitions ‘January 2012’, ‘February 2012’, and ‘March 2012’ into a single partition ‘Q1 2012’ with a single merge partition operation.

We haves extended the concept of partition-based information lifecyle management with the addition of Automatic Data Optimization (ADO). This allows you to define policies that specify when storage tiering and compression tiering should be implemented for a given partition, based on the usage statistics automatically collected by Heat Map. 
ADO policies are automatically evaluated and executed by the Oracle Database without any manual intervention required, making it possible to experience the cost savings and performance benefits of storage tiering and compression without creating complex scripts and jobs. For more information on partitioning visit the home page on OTN (click here).
So, if you want to know more about how 12c can benefit your data warehousing and big data projects then listen to these five short video interviews:
CHAPTER 1
Transformational Time for Data Warehousing		 CHAPTER 2
Uncovering More Business Value with Analytics		 CHAPTER 3
Easier Management and Administration		 CHAPTER 4
Lowering TCO		 CHAPTER 5
Ready for the Future with Big Data
1:37 2:05 1:40 1:20 1:17
 and if you want to learn more about  12c for data warehousing visit the home page on OTN (click here)


Technorati Tags: , , , , , ,

Comments

Post a Comment

Popular posts from this blog

My query just got faster - brief introduction to 12.2 in-memory cursor duration temp tables

By -
Image
Image courtesy of wikipedia This post covers one of the new SQL performance enhancements that we incorporated into Database 12c Release 2 . All of these enhancements are completely automatic, i.e. transparent to the calling app/developer code/query. These features are enabled by default because who doesn’t want their queries running faster with zero code changes? So in this post I am going to focus on the new In-Memory “cursor duration” temporary table  feature. Let’s start by looking at cursor duration temp tables… Above image courtesy of wikimedia.org What is a cursor duration temp table? This is a feature that has been around for quite a long time. Cursor duration temporary tables (CDTs) are used to materialize intermediate results of a query to improve performance or to support complex multi step query execution. The following types of queries commonly use cursor duration temp tables: WITH Clause and parallel recursive WITH Grouping Sets S...
Keep reading

SQL Pattern Matching Deep Dive - Part 1

By -
Image
There has been quite a lot of interest in the new 12c MATCH_RECOGNIZE feature for SQL pattern matching. Therefore, I thought now would be the perfect time to start a series of quick deep dive posts that explain how SQL pattern matching works. Over the coming weeks I will cover the following topics in a series of posts. This is the start of a series of posts based on a presentation that I put together for the recent annual  BIWA conferenc e at Oracle HQ. The Oracle BI, DW and Analytics user community always puts on a great conference and this year was the best yet. You can download any or all of the presentations from this year’s conference by following this link . My pattern matching deep dive presentation started life about a year ago as a post covering some of the new keywords in the explain plan that are linked to pattern matching, see here . It has now expanded to cover a much wider range of topics. Firstly, a huge vote of thanks to my development team (Lei Sheng and Chun-Chie...
Keep reading

SQL Pattern Matching Deep Dive - Part 6, state machines

By -
Image
The obvious way to start this particular post is to pose a couple of simple questions: what is a state machine and why should you care? In general I would say that you don't need to know about or care about state machines. That's the beauty of using SQL for pattern matching. The MATCH_RECOGNIZE clause encapsulates all the deep technical modelling and processing that has to be performed to run pattern matching on a data set. However, there are times when it is useful, probably vital, that you understand what is going on behind the scenes and one of the most obvious situations is when backtracking happens. Therefore, the content covered in this post is a going to be a gently lead-in into my next post where I am going to discuss the concept of “backtracking”  and the dreaded  ORA-30009 error. Let’s start our voyage of discovery…when you attempt to run a SQL statement containing a MATCH_RECOGNIZE clause during the compilation phase we generate a finite state machine ba...
Keep reading