oracle aide

February 17, 2012

Actuate 11: How to move an encyclopedia volume

Filed under: actuate — Tags: — oracleaide @ 7:47 pm

Actuate 11 makes it very easy to move and copy encyclopedias between systems.
A possible use case: copy reports from production to QA and Dev.
(more…)

February 14, 2012

Sequel: α-corp vs ß-corp

Filed under: fun, social engineering — oracleaide @ 1:00 am

Part II.
———————————————————————————————–
α-corp:
“We have a problem to solve.
Let’s drink some beer downstairs.”
(more…)

February 13, 2012

Oracle NoSQL database: not an oxymoron anymore

Filed under: sql — Tags: — oracleaide @ 4:53 pm

Oracle NoSQL Database looks like a lot of fun.
Probably, deployed to SSD – even more.

Another prediction of an Oracle prophet came true:

“…when something truly useful database wise evolves – so evolves the RDBMS”

Of course, anyone needing fast and not-so-reliable data could simply drop ACID from a standard Oracle database by using asynchronous commit.

February 1, 2012

Model clause

Filed under: sql — Tags: , — oracleaide @ 2:49 am

Fascinating reading:

SELECT SUBSTR(country, 1, 20) country,
SUBSTR(product, 1, 15) product, year, sales
FROM sales_view
WHERE country IN ('Italy', 'Japan')
MODEL
PARTITION BY (country) DIMENSION BY (product, year)
MEASURES (sales sales)
RULES
(sales['Bounce', 2002] = sales['Bounce', 2001] + sales['Bounce', 2000],
sales['Y Box', 2002] = sales['Y Box', 2001],
sales['All_Products', 2002] = sales['Bounce', 2002] + sales['Y Box', 2002])
ORDER BY country, product, year;

Create a free website or blog at WordPress.com.