A Composite Pattern with BLOB data types is used to model a hierarchical
network, and includes a path-like construct for locating each component
within the network model. Database procedures are used to efficiently
search, modify and retrieve individual nodes from the network model using
the database server's memory pool so that client applications are not
required to retrieve and deserialize the entire Composite-BLOB hierarchy
in order to make modifications or search for individual elements, thereby
substantially reducing the transfer of data between the application layer
and database. To avoid the need for dynamic memory restructuring during
deserialization, the size required to store component data at each
composite is stored when the composite is serialized, and during
deserialization, the size is retrieved and used to obtain sufficient
memory for the deserialized composite.