Distributed Database & SD-SQL Server Architecture
Databases are now often huge and growing at a high rate. Large tables are then typically hash or range partitioned into segments stored at different storage sites. Current Data Base Management Systems (DBSs), e.g., SQL Server, Oracle or DB2, provide static partitioning only. The DataBase Administrator (DBA) in need to spread these tables over new nodes has to manually redistribute the DataBase (DB). A better solution has become urgent. The structure of data to be stored by a Data Base Management System (DBMS) is usually decided by a database administrator. Individual users and applications are generally interested in only a subset of the data stored in the database.