Here's the status of the entire project and the status of each individual contributor.

Overall Project Status

July 6, 2006

Complete as of June 1, 2006.

The NetDB operations team put the Oracle version of NetDB into service on June 27, 2006.

For what it's worth:

The number of lines of code in the entire NetDB database, middleware, web and CLI applications was reduced from 165,500 to 87,500 (details).

The database code was reduced from 72,500 to 24,500 lines with no reduction in functionality. Not only that, the new code includes 8,500 lines of unit tests (the old code had no tests), meaning the real reduction was from 72,500 to 16,000. Some of this amazing reduction can be attributed to advanced features of Oracle PL/SQL, but most of it is the result of the programming team concentrating on a clean implementation. The old code was quite messy and had a tendency to wander around in search of the right thing; the new code is simple and to the point.

The middleware was reduced from 50,000 to 22,000 lines. This is due to streamlining the DB-MW interaction - instead of a protocol for each NetDB record type there's now a single generic DB-MW protocol (as originally intended).

This tremendous reduction in code yields more than bragging rights. Every line of code is a potential bug - fewer lines means fewer bugs. And when bugs do crop up there's less code to sift through to find them. Finally, when the time comes to change the code (and it will), it will be that much easier to find the right places to make the changes.

We must point out that these code reductions and architectural repairs were not part of the requirements of this project, nor was any extra time spent on them. They're a result of the team clearly understanding exactly what was necessary and implementing it properly. [In fact, it would have been more work to do it any other way.]

Done.

Done.

Done.

Package Status NetDB_Access complete NetDB_AdminTeam complete NetDB_DHCPoption complete NetDB_DHCPservice complete NetDB_Default complete NetDB_Domain complete NetDB_Interface complete NetDB_InterfaceType complete NetDB_IPaddress complete NetDB_IPaddressSpace complete NetDB_LimitedName complete NetDB_Location complete NetDB_Log complete NetDB_Make complete NetDB_Model complete NetDB_ModelType complete NetDB_MXrecord complete NetDB_Name complete NetDB_Network complete NetDB_Node complete NetDB_OS complete NetDB_Organization complete NetDB_Owner complete NetDB_Person complete NetDB_RecordType complete NetDB_ResName complete NetDB_SS complete NetDB_State complete NetDB_User complete NetDB_Util complete

reviewed: The group has reviewed the package and there were changes to be made. complete: The package is complete, pending the tests. complete: The package is complete. re-review: There have been changes to the package. The items listed need to be re-reviewed. Red: There are items to be revisted. Green: There are no items to be revisted.

Done.

Done.

Sunia is her own master. She does what she does and we're grateful for it.