Oracle supplies with CEP installation a list of sample:

1. HelloWorld Always a good start
2. CQL Continues Query Language
3. Oracle Spatial Data Cartridge
4. Foreign Exchange
5. Signal Generation
6. Event Record and Playback Example

Hello world
A hello world is always a nice startingpoint to test new technology
Oracle CEP 11g Helloworld documentation

CQLexample
CQL (Continues Query Language) shows the the start of CEP running queries on streams of data finding specific patterns.
Oracle 11g CQL documentation

In the CQL example you will be guided to add rules in the CEP visualiser. Afther you have added the rule the documentation says that you have start the runloadgen script with prop file data-aggre.prop this file doesn’t exists in the installation. As you will see earlier in the documentation you see that they users there the orderData.prop to generate data for the CQL example so use this file instead.

runloadgen.sh data-aggre.prop

-bash: runloadgen.sh: command not found

Use orderData.prop instead:

runloadgen.sh orderData.prop

Settings:
test.propFile=orderData.prop
test.mode=client
test.host=
test.port=9100
test.verbose=false
test.statInterval=2000
test.latencyStats=false
test.rate=10
test.startRate=1
test.rampUpSecs=0
test.timeSyncPort=0
test.senders=1
test.reportUnchangedQuotes=true
test.filePerSender=false
test.secs=60000
test.packetType=CSV
test.stocksFile=
test.stocksFileLength=0
test.csvDataFile=orderData.csv
test.ticksPerPacket=20
test.loopBack=true
test.senderSkew=0

INFO: 1 senders
INFO:  PacketSender (name=Send0 host= port=9100) connected and ready to start.   Ticks/Second = 2000.   Micros per tick = 500.

Oracle Spatial Data Cartridge
It’s nice to see that Spatial gets also a place in the CEP of Oracle. With this example you can see a some Spatial data in practice. It’s a simple bus application checking if a bus stop has bean passed. It’s nicly displayed with Googlemaps but the use of Flash in this example is not so nice but it works.

Foreign Exchange example
Stock exchange is a nice case where you can implement CEP. You have there a lot of trading happening and as a Exchange Supervisor you would like to monitor the trade and use CEP to detect fraude etc.

Signal Generation example
This continues in the area of the fincancial market. Where in this case you want to control prices fluctuations of products with Oracle CEP. In this example you will find also some more CQL examples.

Event Record and Playback example
An example where CEP is working as a proxy for events. One component is receiving the events and an other adapter publish them again on the network.

When you get stuck with the CEP Visualizer url [http://host:9002/wlevs] you can always check the CEP Visualizer Documentation

The url of the CEP Visualizer is in all the exapmles the same and you can login with username: wlevs and password: wlevs

Have fun with the examples

Popularity: 11% [?]