Seth Grimes on Text Mining "Text analytics provide concept discovery, automated classification, and innovative displays for volumes of unstructured documents." writes Seth Grimes [http://www.intelligententerprise.com/cgi-bin/printable.cgi?file=../031210/619decision1_1.shtml] in another good IntelligentEnterprise [http://www.intelligententerprise.com/] article.
Information on Oracle Embedded Data Warehouse > "I am trying to find information about Oracle EDW, which is supposed to be a datawarehouse out of the box for Oracle applications. Only thing that pops up at Oracle is the warehouse builder FAQ and that is no help. Please send me link to any documentation."
Tom Kyte On Data Warehousing vs OLTP, and Oracle 9i New DW Features There's a couple of good questions just appeared on asktom.com [http://asktom.oracle.com]: The first concerns the differences between data warehouses and OLTP systems [http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:5560484386129] , particularly with regard to developer and DBA skills;
Dealing With “Cannot Get List Of Connections” 9iAS Discoverer Error Just came across an interesting error when plugging a new Discoverer mid-tier instance into an existing 9iAS Farm. The Discoverer server was running on Windows 2000, the server on Unix. When I tried to create the first public connection (to check that Discoverer portlets work), I got the error message
Oracle OLAP User Privileges Explained A recent poster on the OTN OLAP Forum asked the question "What are the minimum privileges needed by an Oracle user when viewing BI Beans reports against an analytic workspace?". This was a question I was thinking about as well, so I decided to do a bit of
New BPEL and Web Services Blog By Mike Lehmann Mike Lehmann, who works at Oracle on their BPEL [http://otn.oracle.com/oramag/webcolumns/2003/techarticles/bpl_news.html] and Web Services technology, has started a new blog [http://radio.weblogs.com/0132036/]. Being a RadioUserLand blog, you can also subscribe to the RSS feed here [http://radio.weblogs.
Slashdot reviews “Softwar: An Intimate Portrait Of Larry Ellison” One of the new Larry Ellison / Oracle books [http://www.rittman.net/2003/10/13.html#a182] recently published, "Softwar: An Intimate Portrait Of Larry Ellison [http://www.amazon.com/exec/obidos/ASIN/074322504X/markrittmanso-20/104-0471549-1777548] " has just been featured in Slashdot's book review section [http:
Combining Embedded Total and Unsolved Dimensions In A Single Cube There's an interesting thread on the OTN OLAP Forum [http://forums.oracle.com/forums/thread.jsp?forum=16&thread=210779&tstart=0&trange=15] at the moment. > "I am trying to define a cube using the cwm2_olap packages, where not all dimensions
Is Oracle Flexible Architecture Still A Sensible Approach? "I am new to Oracle and am preparing to install on a Linux box. Is Optimal Flexible Architecture (OFA) commonly used?" asks a recent poster [http://groups.google.com/groups?dq=&hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=8Dcub.35268%241K.24225%
Data Warehousing Articles By Jonathan Lewis Jonathan Lewis [http://www.jlcomp.demon.co.uk] has written a few articles that might be of interest to Oracle data warehousing developers; * An Explanation Of The Bitmap Star Transformation [http://www.jlcomp.demon.co.uk/06_bitmap_2i.html] * An Introduction To Bitmap Indexes [http://www.jlcomp.demon.co.
Using OWB and the AWM To Create Analytic Workspaces Now that the 9.2.0.4.1 Oracle Database patchset is available [http://www.rittman.net/stories/2003/10/19/analyticWorkspaceManagerFirstImpressions.html] , together with the Analytic Workspace Manager and OWB9.2, I thought I'd take a look at the different options available for populating an Analytic Workspace
Accessing 9i OLAP Cubes Using ASP and Visual Basic > "Hi Mark, I am facing a problem in accessing Oracle Cubes with ASP. How to access cubes using ASP or VB code? Presently i am using MS Analysis services with Data Source pointing to Oracle Cubes, and in asp code i am using MSOLAP provider and ADOMD Which
Resolving “ALTER SESSION command already exists” Issue With 9i OLAP Patch 3140662 A recent poster on the OTN OLAP Forum [http://forums.oracle.com/forums/thread.jsp?forum=16&thread=209685&tstart=0&trange=15] had a problem applying the Oracle OLAP Patch 3140662. This patch is sometimes needed when BI Beans can't connect to the OLAP
Displaying Descriptions In Discoverer LOVs There's a good thread going on [http://forums.oracle.com/forums/thread.jsp?forum=56&thread=36526&tstart=0&trange=15] the OTN Discoverer Forum regarding showing full descriptions in Discoverer LOVs. The original question to the group was; > "What I have is
Accessing 9i OLAP Cubes Using ASP or VB Code > "Hi Mark, I am facing a problem in accessing Oracle Cubes with ASP. How to access cubes using ASP or VB code? Presently i am using MS Analysis services with Data Source pointing to Oracle Cubes, and in asp code i am using MSOLAP provider and ADOMD Which
Update On Last Week’s Stories I've had a couple of bits of useful feedback on two of last weeks stories. First up is "Creating Database Standard Form Analytic Workspaces [http://www.rittman.net/2003/10/30.html#a205]", where I talked about the new DB_CREATE_STDFORM utility that takes migrated
New Discoverer 9.0.2.54 Versions Available On Metalink A new version of Discoverer Plus/Viewer 9iAS, version 9.0.2.54, is now available on metalink as patch no. 3079487. It supercedes the version of Discoverer that comes with 9ias 9.0.2.0.1 (9.0.2.39) and the 9.0.2.53.x versions that
AskTom On Star Queries There's a good discussion going on [http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1271400550105] at asktom.oracle.com [http://asktom.oracle.com] at the moment concerning star queries; take a look if you get a chance.
Differences Between Discoverer Desktop, Plus, Viewer and Portlets > "Hi Mark. Do you know where I can find a comparison between the Discoverer Client/Server versus the Discoverer Intranet versions?" If you're interested, i've put together an explanation of the differences between the different Oracle Discoverer client tools, which you can take
Creating Database Standard Form Analytic Workspaces The 9.2.0.4.1 release of Oracle OLAP [http://otn.oracle.com/products/bi/olap/olap.html] introduces a new concept known as
How Do I Combine Relational And Multidimensional Data In A Single OLAP Cube? > "Everytime I do a web search for anything to do with OLAP, I always seem to be directed to your web-site! So I have a query for you, having viewed your presentation on BI Beans. The Oracle9i Release 2 OLAP option appears to allow us to store both
Alternative Approaches For Partitioning Existing Tables Arup Nanda has written an article for dbazine.com [http://www.dbazine.com/] on the various methods for implementing partitioning for existing Oracle tables [http://www.dbazine.com/nanda6.shtml]. Arup goes through a number of different options, including * Creating the partitioned table from scratch, using CREATE TABLE ... AS SELECT
Useful Guide To iSQL*Plus Garry Robinson [http://www.oracleadvice.com/] has put together a useful guide to iSQL*Plus [http://www.oracleadvice.com/Tips/isqlplus.htm], a version of SQL*Plus introduced from Oracle 9iR2 that is delivered through a web browser. It talks you through setting up the tool, configuring it to work
Ralph Kimball On Reviewing Dimensional Data Models Ralph Kimball [http://www.ralphkimball.com], author of The Data Warehouse Lifecycle Toolkit [http://www.amazon.com/exec/obidos/ASIN/0471255475/markrittmanso-20], has put together a new article on reviewing data warehouse data models [http://www.intelligententerprise.com/031010/616warehouse1_1.shtml?/bi|busintel] . Ralph was an early advocate [http:
