Google pages will be migrating to Google sites :(

Google pages is migrating to Google sites and Google sites is forbidden at Türkiye, since I maintained for years all my SQL scripts mentioned here at my Google pages domain and these files are not a part of the planned migration this migration will cause lots of trouble for me and of course for the readers of this blog unfortunately.

To my taste blogs must be short and to the point, so I always proffered to link my long SQL scripts inside my posts to a text file uploaded at my Google pages, this way also the text file is opened inside browser and the file is not downloaded(you may check out for the behavior on this example post here).

I have hundreds of files linked to hundreds of blog posts, so this file maintainance will take lots of time. I will try to fix first the all time most read ten posts referenced from WordPress stats and as a workaround I will upload the text SQL files as word documents to wordpress media library(you may check out for an example migrated post here). I hope someone may advise a better alternative soon :)

I am busy with lots of reporting projects lately, most of them related to the 3g introduction in my country and CRM application migration at my company. This week I will be attending to Oracle 11g Data Warehousing Masterclass with Mark Rittman at Istanbul and at last I will have two days time to get away from the work and enjoy this seminar. And after 4 weeks I will be a family database guy now; I am getting married at the end of this July and I am very excited that for the first time in my 13 years career I will be having my first two consecutive weeks holiday as my honeymoon :)

ps: I was thinking what if apex.oracle.com or wordpress kind of free services also migrates with some constraints, too boring even to imagine, free services and their risks are like roses and their thorns.

Event-Driven Applications: Introduction to Oracle EDA Suite

Last week I was reading IBM’s Real-Time Data Analysis announcement, so this triggered me to ask local Oracle office if they have a similar application. I am pretty aware of the features at database side, thanks to Concepts Guide and tahiti search. But especially within the last years with Oracle’s purchases the features now outside the database Oracle has is an important question mark for me.

And quickly the answer came: Oracle Event Driven Architecture and there Complex Event Processing feature(aka BEA Weblogic Event Server).

Even I am a database guy I really liked the application until now, maybe it is because event processing language(EPL) is very similar to SQL, it is Eclipse based(at least for now), Jrockit JVM can promise deterministic garbage collection, its hot deployment capabilities and its monitor->analyze->act included business activity monitor application(business user oriented dashboards and alerts without writing a single line of code). We planned to do some PoC so maybe I will be sharing some of my experiences with this product later on. To make you more interested here are some concepts of this product:
• Extend the relational model to support “continuous” query
• Construct “windows” over event streams
– Bounded by time or count
– Partitioned based on values
– Processed incrementally or in batches
– Defines a “working set” of events to then apply queries to
• Use relational operators to characterize the event streams
– Filtering, aggregation, and correlation of events
• Add pattern matching
– Supports track-and-trace scenarios (e.g. detecting missing events)

Pattern Matching Example(Defined as regular expressions, In-Memory Continuous Queries): Stock Trading “W” Pattern


	SELECT FIRST(x.time), LAST(z.time)
	FROM ticker MATCH_RECOGNIZE (ONE ROW PER MATCH PARTITION BY name
		PATTERN (X+ Y+ W+ Z+)
			DEFINE X AS (price < PREV(price)) 			
                                   Y AS (price > PREV(price))
			           W AS (price < PREV(price)) 			
                                  Z AS (price > PREV(price)))

So here is an Introduction to Oracle EDA Suite presentation you may want to check for more details.

Conclusions: being aware of a feature you already purchased is very important not to re-invent a dumper wheel and in order to be time to market against competition. So I hope Oracle develops a Concepts Guide for its Fusion Middleware applications soon for people like me :)