Design factors
Requirements:
- integrate loading, preparation, and query operations
- extend system’s capabilities
- few INSERT or DELETE operations, but each affects many rows
- large, complex queries
Conclusions:
- do as much as possible using SQL
- extend using Java
- less emphasis on concurrent update
- use compression & exploit locality