BI & Warehousing

Way Cool: Linear Algebra in the Oracle Database 1

Marcos Campos - Fri, 2007-04-20 15:32
New to the Oracle Database 10g Release 2 is a hidden gem, the UTL_NLA package. This not very well known package (you don't get many hits for it in Google) brings linear algebra functionality to the Oracle Database. It makes the Oracle Database an even better platform for scientific and advanced analytics programming. Now it is possible to write performant matrix code in the database easily and Marcos
Categories: BI & Warehousing

Wikipedia and Oracle Data Mining

Marcos Campos - Mon, 2007-02-12 15:44
Wikipedia has a nice page on Oracle Data Mining (link). It provides a good overview of the features and history of the product. Here is a snippet of the text:Oracle Data Mining (ODM) is a software product distributed as an option to Oracle Corporation's Relational Database Management System (RDBMS) Enterprise Edition (EE). This product supports a collection of data mining and data analysis Marcos
Categories: BI & Warehousing

New Oracle Statistical Functions Page

Marcos Campos - Mon, 2007-02-12 14:55
OTN has a new page (link) describing the statistical functions in the Oracle 10g Database. These functions are available in all versions of the database at no extra cost. Features include:Descriptive statisticsHypothesis testingCorrelations analysis (parametric and nonparametric)Ranking functionsCross Tabulations with Chi-square statisticsLinear regressionANOVATest Distribution fitWindow Marcos
Categories: BI & Warehousing

Welcome BIWA

Marcos Campos - Mon, 2007-02-12 14:37
The Business Intelligence, Warehousing and Analytics Special Interest Group (BIWA SIG, BIWA for short) has been recently created. Although it counts with a strong participation of Oracle employees, BIWA is an independent organization from Oracle.BIWA is a community in the making. It provides a number of benefits to its members (membership is free):Get the latest information about Business Marcos
Categories: BI & Warehousing

Merry Christmas, Happy New Year, and a Poll

Marcos Campos - Sun, 2006-12-24 04:30
It has been a great year. My daughter was born as well as this blog. I have launched this blog at the beginning of the year (January first to be more precise) and the readership has been great. Amongst the posts, Time Series and Automatic Pivoting were probably the most viewed. I am on vacation in Brazil right now enjoying a family reunion. I have a big family and it is hard to get everyone Marcos
Categories: BI & Warehousing

Announcement: Oracle Data Mining Consultants Partnership Program

Marcos Campos - Fri, 2006-12-15 10:03
We're starting a program to work with qualified data mining consultants.You and your colleagues are invited to participate in a 2 day hands-on session designed for data mining consultants here in the Oracle Burlington MA office February 7 & 8, 2007. It is also possible to attend remotely via webminar. Space is limited, so please RSVP asap.The Oracle Data Mining Consultants Partnership Program hasMarcos
Categories: BI & Warehousing

Free Webinar: Competing on Analytics

Marcos Campos - Tue, 2006-10-31 06:37
I blogged some time ago (link) about an article on The Harvard Business Review by Babson College's Tom H. Davenport on how analytics are becoming a key competitive factor for companies. I have just learned that Prof. Davenport is giving a free webinar today. The theme is "Competing on Analytics." What participants will learn:What data-driven marketing is (and isn't)How marketing visionaries like Marcos
Categories: BI & Warehousing

Oracle Data Mining in Argentina

Marcos Campos - Mon, 2006-10-30 19:22
I spent the week of the 18th in Buenos Aires spreading the word on Oracle Data Mining. I was invited by Snoop Consulting as a keynote speaker at their Update' 06 (warning, the site is in Spanish) event. Snoop Consulting has a very capable technical team. They are positioning themselves to become a leading company of added-value services for information technologies in the region, focused mainly Marcos
Categories: BI & Warehousing

Time Series Revisited

Marcos Campos - Sat, 2006-10-28 17:55
I have been asked a couple of times for a script that would reproduce the results in the time series forecasting series. I finally managed to do it. In the process I found out that a couple of the queries needed to be tuned:In the airline example described in Part 2, the normalization shift and scale parameters were computed using the whole data. A better methodology would be to use only the Marcos
Categories: BI & Warehousing

Oracle Data Mining 10gR2 Code Generation Release Now Available on OTN

Marcos Campos - Tue, 2006-10-10 19:24
I have just received this from Product Management:We are pleased to announce the newOracle Data Mining 10gR2 Code Generation releaseis now available for download (RTM) on OTN.This new ability to go directly from a data analyst building predictive models to having working in-database PL/SQL code for implementing a complete data mining solution is unrivaled in the industry. There is no data Marcos
Categories: BI & Warehousing


Subscribe to Oracle FAQ aggregator - BI & Warehousing