Warehouse, PNG Coffee Industry Board Office and Warehouse, Goroka

View of exterior wall to warehouse.

Downpipes, PNG Coffee Industry Board Office and Warehouse, Goroka

Detailed view of downpipes and drainage grill.

PNG Coffee Industry Board Office and Warehouse, Goroka

View past tiered amphitheatre and offices above to air strip beyond.

View along western elevation, PNG Coffee Industry Board Office and Warehouse, Goroka

View past timber blinds to balcony and timber sunscreens.

Under construction, PNG Coffee Industry Board Office and Warehouse, Goroka

View of post being hoisted into position during construction.

Warehouse, PNG Coffee Industry Board Office and Warehouse, Goroka

View of warehouse exterior.

Pole detail, PNG Coffee Industry Board Office and Warehouse, Goroka

Detailed view of poles used in construction. Poles were spliced in their length with steel bars (like 3 pin plugs) and these joints were restrained from splitting with steel strap belts. The belts were tightened with opposing wedges like the old Greene & Greene wrought iron detail.

Warehouse, PNG Coffee Industry Board Office and Warehouse, Goroka

View of warehouse exterior.

Roof structure, internal, PNG Coffee Industry Board Office and Warehouse, Goroka

View to underside of roof with steel beam and insulation.

Post and beam connection, PNG Coffee Industry Board Office and Warehouse, Goroka

Detailed view of cast iron brackets connecting beams and posts.

Front elevation, PNG Coffee Industry Board Office and Warehouse, Goroka

View of front elevation with entrance from exterior.

Post and beam connection, PNG Coffee Industry Board Office and Warehouse, Goroka

Detailed view of cast iron brackets connecting beams and posts.

Materialized view selection under the maintenance time constraint

A data warehouse is a data repository which collects and maintains a large amount of data from multiple distributed, autonomous and possibly heterogeneous data sources. Often the data is stored in the form of materialized views in order to provide fast access to the integrated data. One of the most important decisions in designing a data warehouse is the selection of views for materialization. The objective is to select an appropriate set of views that minimizes the total query response time with the constraint that the total maintenance time for these materialized views is within a given bound. This view selection problem is totally different from the view selection problem under the disk space constraint. In this paper the view selection problem under the maintenance time constraint is investigated. Two efficient, heuristic algorithms for the problem are proposed. The key to devising the proposed algorithms is to define good heuristic functions and to reduce the problem to some well-solved optimization problems. As a result, an approximate solution of the known optimization problem will give a feasible solution of the original problem. (C) 2001 Elsevier Science B.V. All rights reserved.