 |
|
|
Microsoft SQL Server Federated DatabaseThere is another interesting architecture provided by Microsoft SQL-Server Federated Database. SQL Server 2000 shares the database-processing load across a group of servers by horizontally partitioning the SQL Server data. These SQL servers are configured and managed independently, but cooperate to process the database requests. Such a cooperative group of SQL servers is called a federated database. Federated database tiers can achieve high levels of performance only if the application sends each SQL statement to the member server that has most of the data required by the statement. This is called collocating the SQL statement with the data required by the statement. Thus, a federation of servers presents a single database server to the applications. However, it requires careful planning, and designing a set of distributed partitioned views that spread the data across the different servers. This configuration means significantly higher administration costs, since each individual server requires its own separate maintenance operations, and prevents access of any data if any server fails. Additionally, the performance of the complete federated database is dependent on how much of the data requested is on a local server, and how much is on other servers, demanding careful partitioning of data across the multiple servers to gain performance advantages. Single Server Federated ServerOne instance of SQL Server on the production server. There is one instance of SQL Server on each member server. The production data is stored in one database. Each member server has a member database. The data is spread through the member databases. Each table is typically a single entity. The tables from the original database are horizontally partitioned into member tables. There is one member table per member database, and distributed partitioned views are used. All connections are made to the single server, and all SQL statements are processed by the same instance of SQL Server. The application layer must be able to collocate SQL statements on the member server containing most of the data referenced by the statement Table 3.3 - Differences between single databases and federated databases. For more information, see the book Oracle 11g Grid and Real Application Clusters - 30% off if you buy it directly from Rampant TechPress . Written by top Oracle experts, this RAC book has a complete online code depot with ready to use RAC scripts.
|
|
|
