Rittman Mead - Delivered Intelligence

The other day I posted an article about dimensions in Oracle 9i, and went through an example where we created some dimensions using an analytic workspace. The particular part of the article went as follows; "…  Next, we need to create some dimensions. In our case we want to create two dimensions, a new one [...]

When Worlds Collide, Content Joins Data : "The systems that manage content and data are on a collison course. New synergies will change the course of content. The technologies that manage unstructured content and structured data are on a collision course, and signs of the convergence are everywhere. Take, for example, the widely expected news [...]

Better to Best NDS : "In recent years, dynamic SQL has become a much more common aspect of PL/SQL programming. Prior to the availability of Native Dynamic SQL (NDS) in Oracle8i, dynamic SQL was available in PL/SQL only through the DBMS_SQL package. Although very robust, DBMS_SQL was very difficult to use and relatively slow. Now, [...]

If you’re in your mid-thirties and work in the IT industry you probably grew up using home computers such as the Sinclair Spectrum, Commodore-64, Acorn Atom and Atari 800. If this sounds like you, you’ll probably be interested in a new book that I got hold of recently entitled "Digital Retro" by Gordon Laing. The [...]

A reader asks: “I am new to OLAP and Oracle OLAP and I have a question. I have an Oracle 10g Database with relational tables in it. I want to create dimensions and cubes from that data. Do I need to create separate dimension and fact tables from that relational data, or do I just [...]