OnLine Analytical Processing (OLAP)

Measure

dimension

See if can find OLAP cube editor and run a demo on small data

Data Mining

See if can run a Fourier Transform to find repeating data. Show an audio stream: raw data, plotted (time-domain), repeating wave pattern (frequency-domain) the number of times the pattern repeats in a second is the frequency of this pattern.

Generate the stream with the visualizer and view streams with the tuner.

Show example of transferring data from Oracle to Mysql using XML

Could also do this using PHP or Java by using two connection objects and selecting from one DB and writing to the other

Possibly with a transaction problem from PHP, if I can work that out.