Federation is introduced in SQL Azure for scalability. Federation helps both admin and developers to scale data. It helps admin by making easier in repartitioning and redistributing of data. It helps developers in routing layer and sharding of data. It helps in routing without application downtime.

Federation is basic scaling objects in SQL Azure Database. . Federations are the partinoed data. There can be multiple Federations within a database. And each different Federation represents different distribution scheme.

We create Federation on different distribution scheme and requirement. Student table and Grades table of a School Database may have different distribution requirement so they are put into different Federations.

Each Federation object scale out data to many system managed nodes. Federation object contains,

image

Federation members are managed directly by federation while data are partinoed. All Federation objects are stored in central system Database called Federation Root. Each Federation object is identified by a Federation Distribution key.

Federation key is used for partitioning the Data. A Federation key represents Distribution style and Data Domain.

Data is being scaled out in Atomic Unit. All Data of a particular atomic unit stick together. Atomic unit can be separated and all the rows of a particular Partition key stay and distributed together.

Atomic unit is instance of Federation key.

image

Let us create Federation with respect to a School Database. We are creating a Federation on Student table called Federation_Student.

image

So now any row in Student table with Roll Number between 100 to 1000 would be atomic unit for scalability.

Advertisements

2 thoughts on “Federation in SQL Azure

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s