Wednesday, 30 October 2013

Oracle Magazine: Getting started with SQL Analytics

I am currently working on a series of podcasts covering the broad categories of our SQL analytical functions and features and while I was doing some research I came across of series of four articles in the Oracle Magazine.

This series of article is written by Melanie Caffrey who is a senior development manager at Oracle. She is a coauthor of Expert PL/SQL Practices for Oracle Developers and DBAs (Apress, 2011) and Expert Oracle Practices: Oracle Database Administration from the Oak Table (Apress, 2010).

The four articles are under the banner "Technology: SQL 101" and parts 9, 10, 11 and 12 cover SQL analytics. Here are the links to the four articles:

 
The articles cover topics such as GROUP BY, SUM, AVG, HAVING, window functions, RANK, FIRST, LAST, LAG, LEAD etc.  

The great news is that  you can try out the examples in this series. All you need is access to an Oracle Database instance. All the schemas, data sets and SQL statements that you will need can be downloaded from a link included in the January article

 

 I hope you find this series of articles useful.

 

Technorati Tags: , , , ,

Tuesday, 29 October 2013

Start your journey into Big Data with the Oracle Academy today!

 Big Data has the power to change the way we work, live, and think. The datafication of everything will create unprecedented demand for data scientists, software developers and engineers who can derive value from unstructured data to transform the world.

The Oracle Academy Big Data Resource Guide is a collection of articles, videos, and other resources organized to help you gain a deeper understanding of the exciting field of Big Data. To start your journey visit the Oracle Academy website here: https://academy.oracle.com/oa-web-big-data.html. This landing pad will guide through the whole area of big data using the following structure:

  1. What is “Big Data”
  2. Engineered Systems
  3. Integration
  4. Database and Data Analytics
  5. Advanced Information
  6. Supplemental Information

This is great resource packed with must-see videos and must-read whitepapers and blog posts by industry leaders. 

Enjoy

Technorati Tags: , , ,

Monday, 28 October 2013

Partitioning tutorial - new features in Oracle Database 12c

For data warehousing projects Oracle Partitioning really is a must-have feature because it delivers so many important benefits such as:

  • Dramatically improves query performance and speeds up database maintenance operations
  • Lowers costs by enabling a tiered storage approach that allows data to be stored on the most cost-effective storage for better resource utilisation
  • Combined with Oracle Advanced Compression, it provides an automated approach to information lifecycle management using a simple, efficient, yet powerful way to manage data growth and reduce complexity and costs

To help you get the most from partitioning we have released a new tutorial that covers the 12c new features. Topics include how to:

  1. Use Interval Reference Partitioning
  2. Perform Cascading TRUNCATE and EXCHANGE Operations
  3. Move Partitions Online
  4. Maintain Multiple Partitions
  5. Maintain Global Indexes Asynchronously
  6. Use Partial Indexes

For more information about this tutorial follow this link to the Oracle Learning Library: http://apex.oracle.com/pls/apex/f?p=44785:24:0::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:8408,2 where you can begin your tutorial right now!

For more information about Oracle Partitioning visit our home page on OTN: http://www.oracle.com/technetwork/database/bi-datawarehousing/dbbi-tech-info-part-100980.html



Technorati Tags: , , , ,

Wednesday, 23 October 2013

OOW content for Pattern Matching....

If you missed my sessions at OpenWorld then don't worry - all the content we used for pattern matching (presentation and hands-on lab) is now available for download.

My presentation "SQL: The Best Development Language for Big Data?" is available for download from the OOW Content Catalog, see here: https://oracleus.activeevents.com/2013/connect/sessionDetail.ww?SESSION_ID=9101

For the hands-on lab ("Pattern Matching at the Speed of Thought with Oracle Database 12c") we used the Oracle-By-Example content. The OOW hands-on lab uses Oracle Database 12c Release 1 (12.1) and uses the MATCH_RECOGNIZE clause to perform some basic pattern matching examples in SQL. This lab is broken down into four main steps:

  • Logically partition and order the data that is used in the MATCH_RECOGNIZE clause with its PARTITION BY and ORDER BY clauses.
  • Define patterns of rows to seek using the PATTERN clause of the MATCH_RECOGNIZE clause. These patterns use regular expressions syntax, a powerful and expressive feature, applied to the pattern variables you define.
  • Specify the logical conditions required to map a row to a row pattern variable in the DEFINE clause.
  • Define measures, which are expressions usable in the MEASURES clause of the SQL query.

You can download the setup files to build the ticker schema and the student notes from the Oracle Learning Library. The direct link to the example on using pattern matching is here: http://apex.oracle.com/pls/apex/f?p=44785:24:0::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:6781,2.

Enjoy!

Technorati Tags: , , , , , ,

Friday, 18 October 2013

OLL Live webcast - Using SQL for Pattern Matching in Oracle Database

You've visited our new web page on OTN, you've downloaded the pattern matching iBook, now register for the webcast!

If you are interested in learning about our exciting new 12c SQL pattern matching feature then mark your diaries. On Wednesday, October 30th at 8:00 am (US/Pacific time zone) Supriya Ananth, who is one of our top curriculum developers at Oracle, will be hosting an OLL webcast on our new SQL pattern matching feature.

The ability to recognize patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. Row pattern matching in native SQL improves application and development productivity and query efficiency for row-sequence analysis.

With Oracle Database 12c you can use the new MATCH_RECOGNIZE clause to perform pattern matching in SQL to do the following:

  • Logically partition and order the data using the PARTITION BY and ORDER BY clauses
  • Use regular expressions syntax to define patterns of rows to seek using the PATTERN clause. These patterns a powerful and expressive feature, applied to the pattern variables you define.
  • Specify the logical conditions required to map a row to a row pattern variable in the DEFINE clause.
  • Define measures, which are expressions usable in the MEASURES clause of the SQL query.

For more information and to register for this exciting webcast please visit the OLL Live website, see here: https://apex.oracle.com/pls/apex/f?p=44785:145:116820049307135::::P145_EVENT_ID,P145_PREV_PAGE:461,143

Please note - if the above link does not work then go to OLL (https://apex.oracle.com/pls/apex/f?p=44785:1:) and click the OLL Live icon (upper right, beneath the Login link or logout link if you are already logged in). The pattern matching webcast is listed on the calendar of events on 30 October.

 

Technorati Tags: , , , , , , ,

Thursday, 17 October 2013

OpenWorld 2013 in a box

This year's OpenWorld had major focus on data warehousing and big data. To help you find and download the most important presentations from the conference I have put together a new guide -  OpenWorld 2013 in a box.

This new guide is a follow-up to the Must-See guides that were published ahead of the conference. All the sessions listed in those conference guides are included in this new OpenWorld 2013 in a box guide. This new booklet is divided into the following sections

  • Overview - links to main keynotes
  • Database 12c - George Lumpkin, VP of Product Management talks about the exciting new features in Oracle Database 12c
  • Must-Download presentations- presentations delivered by the product management and development teams along with key customer presentations.
  • Links - everything you need to keep up to date on Oracle’s strategy and products for data warehousing and big data.

The list of must-download presentations is broken down into the following categories:

  • General - covers roadmaps, strategy and data models 
  • Performance and Scalability - covers partitioning, optimizer and tuning
  • In-Database Analytics - covers pattern matching, data mining, spatial and graph 
  • Unstructured data - covers text and XML DB 
  • Big Data - covers Big Data Appliance, Hadoop, Connectors, NoSQL Database and R Enterprise
 


You can download the "OpenWorld in a Box" from here. Enjoy!


Technorati Tags: , , , , , , ,

Get trained on Big Data

Interest in big data is growing rapidly and big data was a very hot topic at this year's OpenWorld conference. In response to this Oracle Education has released a new 3-day training course for big data to help customers and partners get hands-on time to develop the skills to acquire, organize, analyse big data so they can make key decisions based on these new data streams.

The course lasts 3 days and is offered as a classroom session and/or using or virtual training environment. In this course you will learn to:

  • Define Big Data.
  • Understand Oracle's Integrated Big Data Solution.
  • Describe the Oracle Big Data Components.
  • Define Cloudera's distribution of Hadoop and its components.
  • Acquire raw data using Oracle NoSQL Database and HDFS.
  • Organize the collected data using Hive and Oracle Big Data Connectors.
  • Analyze big data using the Oracle Analytics tool.
  • Derive business decisions using Oracle BI tools.
  • Study the case-scenarios where Oracle Big Data is applied successfully.

If you are about to start a big data project or just want to learn more about how big data can help drive new business opportunities then this is the course for you.

To get more information about this new course and to view the schedules for the classroom and virtual lessons see here: http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=609&p_org_id=28&lang=US&get_params=dc:D79456GC10,p_preview:N

 

Technorati Tags: , , ,