Hi, Please find the notes of the $subject below. seshika ------------------------------------------------------
RDBMS Event Table 1. Add lot of comments - globally 2. Add Method a. Comment about caching (default – off and bloom filter - on ) b. Disconnections - if you can’t connect -> reinitialize -> still if you can’t connect, drop the event c. Change method name – initializeConnection() to initializeIfNotConnected() d. Do the synchronize after checking if(!isInitialized) e. Use hadoop counting bloom filter in the add event instead of buildBbloomFilters() f. When ClassNotFoundException, throw the exception 3. Update Method a. Disconnections - if you can’t connect -> reinitialize -> still if you can’t connect, drop the event b. Do an if/else for atomic event and listevent c. Handle updates of selected columns only 4. Delete Method a. Do the StringBuilder/StatementBuilder stuff outside of this method b. Put a comment explaining why you append a “OR” c. Use hadoop counting bloom filter in the add event instead of buildBbloomFilters() d. When ClassNotFoundException, throw the exception 5. Contains Method a. If condition is not ‘==’ we have to do the non-bloomfilter case b. If the condition has AND/OR stuff, that needs to be handled (if the query is complicated, can choose to do the non-bloomfilter case) c. Take the prepareStatement() stuff out of this method 6. SQL classes a. Naming convention – SQLBlahBlahBlah
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
