Archive for August, 2009
Tuesday, August 25th, 2009
A new waves of apps is on the smartphone app stores and market places. Those are the bar code scanners that allow you to link real world of products with the huge internet database. Instead of trying to use words to provide a vague description of the product, its bar ...
Posted in Mobile Development | 2 Comments »
Monday, August 24th, 2009
Query number of records in each partition of the table:
SET SERVEROUTPUT ON SIZE 100000;
DECLARE
CURSOR c1
IS
SELECT table_name,
partition_name
FROM all_tab_partitions
WHERE table_name = 'MCP_CDR_HIST' order by partition_name asc;
v_sql VARCHAR2(2000);
temp_var NUMBER:=0;
BEGIN
dbms_output.put_line('Start');
FOR rec IN c1
LOOP
EXECUTE immediate 'select count(*) from '||rec.table_name||' partition('||rec.partition_name||')' INTO temp_var;
dbms_output.put_line('The Partition '||rec.partition_name||' of table '||rec.table_name||' has '||temp_var||' rows');
END ...
Posted in Databases | 1 Comment »
Tuesday, August 18th, 2009
Sliding window is a classical solution for the most historical databases. A partition is switched in and out. The scenario is supported by majority of database providers.
The following article describes partition switching in or partition exchange for Oracle: http://www.oracle-base.com/articles/misc/PartitioningAnExistingTableUsingExchangePartition.php
Posted in Databases, Programming | No Comments »
Tuesday, August 18th, 2009
Clearcase plugin for the Galileo Eclipse:
http://www3.software.ibm.com/ibmdl/pub/software/rationalsdp/clearcase/60/update/windows/
This link is actually broken. Installed Open Source plugin (http://eclipse-ccase.sourceforge.net/) and it works fine. Follow these installation instructions(http://eclipse-ccase.sourceforge.net/documents/user_guide.pdf ):
use the update site.
Update site has the following url: http://eclipse-ccase.sourceforge.net/update/
In Eclipse select menu Help → Install New Software...
Use the update site. Update site has the following URL: http://eclipse-ccase.sourceforge.net/update/. In ...
Posted in Software | No Comments »
Monday, August 17th, 2009
I couldn't find any tool similar to Foxmarks for Google Chrome. However, I encountered this article (http://metaed.blogspot.com/2008/12/using-google-bookmarks-in-google-chrome.html) that suggested adding Google Bookmarks to a list of enabled searche engines in the Google Chrome instance. This basically allows using Google bookmarks.
To add Google Bookmark search to the Chrome address bar, right-click ...
Posted in Web | No Comments »
Monday, August 17th, 2009
Here is a nice tutorial on XML and parsing methodes:
http://www.cafeconleche.org/books/xmljava/
Posted in Java | No Comments »
Monday, August 17th, 2009
Ontario Ministry of Transportation provides traffic data in various formats:
Construction Reports
Traffic Flow Reports
Live Traffic Cameras
Road Closure Announcements
All that data can be found in the online TRIP (http://www.mto.gov.on.ca/english/traveller/trip/) and COMPASS (http://www.mto.gov.on.ca/english/traveller/trip/traffic_cameras.shtml ) systems.
The following page provides KML files from MTO with the most updated information about the traffic that can be nicely overlayed ...
Posted in Web | No Comments »
Sunday, August 9th, 2009
In the latest article on Technorati Which search engine do you choose in the blind test I read about latest Microsoft's marketing compaign targeting to prove that Google search is no better than any other search. I don't think it is place for argument. What was important is the ...
Posted in Uncategorized | No Comments »
Thursday, August 6th, 2009
You can find many unofficial images for your iPaq 4700:
http://www.winmobile.us/hpmain.htm
Posted in Gadgets | No Comments »
Wednesday, August 5th, 2009
Don't understand why getting Facebook API gotta be so complicated. Here is a video tutorial that would save an hour of your precious time:
[youtube]http://www.youtube.com/watch?v=jYqx-RtmkeU[/youtube]
If you are looking for a Java Facebook client, look no further then Facebook Java API. That's a well maintained open source project hosted by Google. Java ...
Posted in Java, Programming | No Comments »