Monday, March 29, 2010

Accelerating SQL Database Operations on a GPU with CUDA

I have been watching nVidia's CUDA technologies for a while.

What I am waiting for is a solution for SQL Database (Oracle/DB2/Sybase/SQL Server/MySQL).

Here is a publish documents by Peter Bakkum and Kevin Skadron

Accelerating SQL Database Operations on a GPU with CUDA

Project base on SQLite focuse on SELECT queries.
Good point!

Will keep eye on it!

Sunday, March 28, 2010

Next-generation campaign management: How campaign management will evolve to enable interactive marketing

Read this white paper at:

Recommended reading.

Published in the Journal of Direct, Data and Digital Marketing Practice, this paper explains how marketers must redefine their approach to reflect radical shifts in channels and customer behavior ? including an accelerating shift toward addressability, growing convergence between online and direct channels, and increasing customer power to shape marketing dialogues and buying experiences. This paper addresses how marketers must engage customers and prospects in a personal, cross-channel conversation that builds upon that individual?s past and current behavior. It also explains how marketers must listen to all information provided, analyze it and respond ? sometimes in real-time ? in ways that are compelling, timely and relevant. Finally, the author discusses the fundamentally new marketing tools, stronger integration and revamped organizational structure that will be required to achieve these goals.

Sunday, March 21, 2010

xmarks:Seamlessly synchronize bookmarks across all your computers

Seamlessly synchronize bookmarks across all your computers

Can  synchronize bookmarks between FireFox, IE, Chrome and Safari.

Try it and you will love it.

Other Features:

Smarter Search And Account Password synchronize.

Best Online Backup Solution:

Best Online Backup Solution Mozy hold By EMC

Every Database/System/Storage Engineer knows EMC.
And they bought for $76 million.

I would say online storage/ Cloud Storage is the future.
$4.95/month with unlimited space and upload/download coast, there is nothing better than this for my Home Server ( with about 2 TB personal files).

And with EMC's support, I will give it a 5 start from the secure side.

Only thing is there is no Linux client right now.
Hope it coming soon.

Tuesday, March 9, 2010

"11g SQL Result Cache vs times Ten", version 11.1.0 @Ask Tom

From Ask Tom @ Oracle

A few monthes back i designed an architecture for one of our client. Then the main problem was their centeral database an Oracle 9i has so many problem that it was not possible for them to close it or ask us to redesign the system before we complete another project on the same database. I tried different architecture and java frame works but no vail until i find oracle Times Ten. what i did is i installed oracle Times ten and application server on the same machine and tried to save queries from the main database server. fortunately it work to some extent and i was able to complete the project. My question to you is.

Why oracle did not tried times tens on the middleware. Instead they introduce a new feature of sql resultset. which is pretty cool but not as cool if some lighter verions of Times Ten was used for caching data in the middleware. Why oracle opt to create a new feature while a product can already fulfil that need.

Also while designing this project i saw many possiblities in caching data also with combining different frame works like when i combine it with toplink it gave me a fast response time. May be because of data is availble on the same machine.

My Project Manager considers that in above project i went too extreme in terms of desgin and architect. Do you consider it extreme. because if that extreme then oracle would not have introduce sql resultset cache. what's your opinion

Amir Riaz 

and we said...

because more than one database is complex. because there are replication and syncronization issues with times ten

and because of people put 1% of the time into DESIGN that they did into slamming code out, we'd probably not need any of this stuff.

With the sql result cache, the plsql function result cache and the client result cache in 11g, the need for extra moving bits and pieces goes away in most all cases.

the client result cache - client issues query once and as long as the database doesn't change the answer, transparently keeps reusing it.

the server results cache - like a just in time materialized view, every client that connects to oracle takes advantage

the function results cache - see above

if you can do what you need with one thing, then one thing will make life less complicated.

And you are asking the wrong person if a middle tier was over designed or architected. I tend to think they are over engineered (glued together bit by bit) rather than over designed. I wish for over designed sometimes :)
From Ask Tom @ Oracle