This chapter describes the design requirements for SQL-AG. First, the common usage of the aggregates are listed, followed by the requirements posed by online aggregation. The last section gives the SQL-AG solution with design details relating to its requirements.