an IROBIX dreamer

Simple Database Trigger in Oracle- Part 1

2009-06-22T05:27:00.000-07:00

create table AccountHolders(
ID VARCHAR2(4 BYTE) NOT NULL,
UserName VARCHAR2(10 BYTE),
AccountID VARCHAR2(10 BYTE),
CellPhoneNumber VARCHAR2(10 BYTE),
TotalAmount VARCHAR2(10BYTE)
)

insert into AccountHolders(ID, UserName, AccountID, CellPhoneNumber,TotalAmount)
values ('01','Rossi','001','+880172','2334' )

CREATE TABLE mytriggertable( event VARCHAR2(400) )

create or replace trigger mytrigger
BEFORE INSERT OR UPDATE OR DELETE ON AccountHolders
DECLARE
mymessage varchar2(200) ;
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
IF inserting THEN
mymessage := ' Insert into AccountHolders @ ' || to_char(sysdate, 'mm/dd/yyyy hh:mi') || ' by ' || user ;
ELSIF updating THEN
mymessage := ' Update of employee @ ' || to_char(sysdate, 'mm/dd/yyyy hh:mi') || ' by ' || user ;
ELSIF deleting THEN
mymessage := ' Delete of employee @ ' || to_char(sysdate, 'mm/dd/yyyy hh:mi') || ' by ' || user ;
END IF;
INSERT INTO mytriggertable VALUES(mymessage);
COMMIT;
END;

insert into AccountHolders(ID, UserName, AccountID, CellPhoneNumber,TotalAmount)
values ('02','Bapin','003','+880167','1334' )

Scrum

2009-02-07T02:15:00.000-08:00

http://www.codeproject.com/KB/architecture/scrum.aspx

Sourceforge Tips

2008-12-15T00:51:00.000-08:00

http://osdir.com/ml/linux.hams/2003-05/msg00059.html
http://alexandria.wiki.sourceforge.net/Subversion+Client+-+Command-line+SVN+client#top

Yahoo Antivirus

2008-12-09T03:34:00.000-08:00

http://techiecorner.blogspot.com/2006/10/yahoo-messenger-virus-attack-remove-it.html

UML Use Case

2008-09-23T00:32:00.001-07:00

http://www.developer.com/design/article.php/2109801

UML Class

2008-09-23T00:30:00.000-07:00

http://www.developer.com/design/article.php/2206791

Topcoder Design

2008-09-23T00:14:00.000-07:00

topcoder design

2008-09-23T00:11:00.001-07:00

http://www.topcoder.com/wiki/display/tc/How+to+Compete+in+Component+Design+Competitions?showChildren=true#children

http://www.topcoder.com/wiki/display/tc/Getting+Started+in+Component+Design+Competitions

http://www.topcoder.com/wiki/display/tc/Component+Design+Tutorial

http://www.topcoder.com/wiki/display/tc/Practicing+Component+Design

UML1 Sequence Diagram

2008-09-22T22:21:00.000-07:00

http://www.developer.com/design/article.php/3080941

executable jar file creation

2008-07-15T13:18:00.000-07:00

http://www.technowledgebase.com/2007/07/23/java-making-a-simple-executable-jar/

Create jar file from ant script- Nice tutorial

2008-06-27T09:17:00.000-07:00

http://www.rgagnon.com/javadetails/java-0532.html

Java Ant Tutorial

2008-06-27T09:07:00.000-07:00

http://www.visualbuilder.com/java/ant/tutorial/pageorder/10/

Linux /Windows Jar file Creation

2008-06-23T22:13:00.000-07:00

http://java.sun.com/docs/books/tutorial/rmi/compiling.html

Jdk installation in Different Platform Documentation

2008-06-14T11:26:00.000-07:00

http://java.sun.com/javase/6/webnotes/install/index.html

Java Eclipse Tutorial [Part 1 from java.net ] -

2008-05-15T00:32:00.000-07:00

https://eclipse-tutorial.dev.java.net/eclipse-tutorial/part1.html

Johnsons algorithm

2007-08-24T10:32:00.000-07:00

Warshall algorithm does in O(n^3)
Johnson in o(v(Elogv))time

First do the Bellman to find negative cycle
Then we go through Dijsktra

Plane sweep algorithm

2007-08-24T10:25:00.000-07:00

Given two lines
O(n^2)times to calculate the total intersection points
But we need to solve faster
Plane sweep does this in (nlog(n))time

FAQ:
When does it fail?
a.It fails if events are much .then plane sweep algo works in O(n^2)time

Nearest Neighbour search algorithm

2007-08-24T10:15:00.000-07:00

Also known as Closest point algorithm
Criterias are
a.Find nearest neighbour of a point
b.Find nearest neighbours of a point with a certain range specified
c.Given two sets of points.Find a nearest neighbour from both pairs.

we can use several approaches.
a.quad tree
b.k-d tree
c.Hash

Wi-Fi mobilization

2007-08-24T10:14:00.000-07:00

2008 will be the year of Wi-Fi
mobilization...

Stage has been set for it

Wi-Fi Future

2007-08-24T10:12:00.000-07:00

WiFi 1.0 is going

Comaparing to WEB-2.0
Wi-Fi-2.0 is coming

Free Fast service is the expected criteria

WiFi Security Steps

2007-08-24T10:11:00.001-07:00

VPN
WEP
WAP1
WAP2
EAP

more....

unix mysql nis and samba configure

2007-07-24T10:00:00.000-07:00

the steps are just described