UML Tool used by Cameron + OO question

Hi Cameron,

1. Which UML tool do you use for the SCJA Certification Guide?

2. I am very database oriented.
If I write a program I filter the database (sql statements in Delphi)

Now I am learning a complete other way of thinking OO and JAVA.
When do I use database filtering and when do I create objects.

Example:
I want to search in a database of 10000 records.
Now I filter the data for the specific record with SQL.

The OO method would be to create 10000 objects in memory and
to look for the specific object. Am I correct?
When do I create objects and when do I filter data?

Thanks in advance.

Rene' van der Ven
The Netherlands

I actually just used the UML tool in Eclipse. It just shows classes and interfaces and their method/properties in boxes. There was nothing too magical there, which is what I wanted - just keep it simple so it's easy to learn.

For large records, you want the database to do the filtering. Then, the Java part can perhaps do a secondary filtering or formatting on a smaller set of records. You don't want 10,000 Java objects being created on the JVM for each query, that's for sure.

-Cameron McKenzie