Entries from The Data Warehouse Insider tagged with 'SQL'
Next Generation Data Warehouse Platforms
Rather than entertain you all with my own theories I decided to be a literature critic and discuss a paper / survey done by TDWI's Philip Russom. The report goes into "what a next generation DW platform should try to...
Edition Based Redefinition
Or, how can I use 11gR2 to update my operational data warehouse with real time data loads and still patch the schema to deal with errors or with upgrades due to changing business demands. The Theory In a time when...
In-Database MapReduce (Map-Reduce)
The Map-Reduce model has become a popular way for programmers to describe and implement parallel programs. These custom map-reduce programs are often used to process a large data set in parallel. This post shows how to implement Map-Reduce Programs within...
11gR2 - What is in it for me?
By now you probably heard the news of the Oracle Database 11g Release 2. It is available and comes with a number of very interesting features for data warehousing. Obviously now you want to try this, so here is the...
Partitioning and/or/with Exadata?
Got a little busy there with all the comments on the Netezza posting, but now we're back into some of the outstanding topics. This post is the next one on discussing some of the ODTUG session questions (see this post)....
Best Practices at ODTUG
Today was the last day in Monterey. Bye bye aquarium and all the other wonderful things Monterey has to offer. I got lucky with owning one of the sessions in the last block of the conference. But if there is...
Unloading data using External Table and Data Pump
Just for being complete and to update people on a minor detail, here is a quick example of a data pump driven External Table. SQL> CREATE TABLE EMP_50 2 ORGANIZATION EXTERNAL 3 ( TYPE oracle_datapump 4 DEFAULT DIRECTORY dmp_dir 5...
Oracle Releases Industry Data Models
There is a lot of interesting news coming out of Oracle these days... And while the sun is shining here in California there are interesting things going on. We just made the first in a series of industry data models...
Compressing Individual Partitions in the warehouse
Partitioning, now that is a topic that we talk a lot about here at Oracle. If you look in the data warehouse guide and related publications you will see lots on partition pruning, partition wise joins and partitioned indexing. For...
Pivot, extract and more fun SQL stuff
I was thinking back to the Warehouse Builder days and the pivot and unpivot operators we built into the tool. Wanted to check out the SQL commands in 11g and see how that works, so I dug around in the...
New External Table Functionality - PreProcessing and Data Pump
I'm not sure everyone is aware of the fact that you can use external tables these days to work with data pump export files. You can read in data using an external table, or you can unload data. For more...
Search All Blogs
Google Search
Feed Subscription
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'SQL'.
