Indexing the unusual

Monday, March 10th, 2008 by Peter Scott

For many years I had an interest in non-standard indexing and exotic data types, that is things that weren’t NUMBER or VARCHAR2. In fact before I came in to data warehousing I was involved in indexing free text such as conversation transcripts and and narrative reports; some of this was pushing the technology of the [...]

Oracle Data Integration Suite

Tuesday, February 5th, 2008 by Peter Scott

Keeping my head down building Oracle 11g OLAP cubes for research and self-education meant the I missed yesterday’s product announcement from Oracle, but with the wonders of Blog aggregators (and in particular Beth’s) I spotted a mention on Vincent McBurney’s blog of the newly announced (and available) Oracle Data Integration Suite. This is one of [...]

Virtually there

Wednesday, November 21st, 2007 by Peter Scott

I have a couple of days between assignments so I am spending a little time doing research. Ultimately, there is a piece to write on Oracle 11g OLAP, and some course notes on aspects of data warehousing. But do this sort of thing I need to get myself set up with a database (Enterprise Edition [...]

Looking at the unstructured

Saturday, October 6th, 2007 by Peter Scott

Curt Monash has been talking about text mining a lot this week, he also notes that, from a text point of view, that the four preeminent database vendors (data store not query tool) are Oracle, Microsoft, Teradata and Netezza, this seems to reflect my experiences of what is going on in the BI space as [...]

Super models

Wednesday, July 18th, 2007 by Peter Scott

No, not the size-zero (or below) fashion-sticks that pogo across the catwalks of the world enticing the somewhat-larger to buy, but the modeling of all of the information within an organisation in a single unified form. Said like that, it’s simple, but in reality there are lots of complexity buried away that need to be [...]

Website Design & Build: tymedia.co.uk