Schema design -- either from the ground up, or to modify an existing system -- following principles of either normalization or dimensional modeling. This includes |1) object design - the use of tables, partitioned tables, views, materialized views, with appropriate indexing schemes to achieve fast retrieval of data; 2) instance design - the separation of functionality across two or more database instances, with appropriate schemas designed for each.