6
Shouts

Considerations When Building Database Schema with Federations in SQL Azure - SQL Azure - Cihan Biyikoglu

published 768 days, 9 hours, 32 minutes ago posted by KluggerKlugger 769 days, 10 hours, 38 minutes ago
Monday, April 18, 2011 2:01:52 PM GMT Sunday, April 17, 2011 12:55:44 PM GMT

When working with federations, database schema requires a special consideration.

With federations, you take parts of your schema and scale it out. With each federation in the root database, a subset of objects are scaled-out. You may create multiple federations because distribution characteristics and scalability requirements may vary across sets of tables. For example, with an ecommerce app, you may both have a large customer-orders set of tables and a very large product catalog that may have completely different distribution requirements.

All the schema artifacts in the root and in federation members are scoped to the database. Meaning objects in the root database are only visible when connected to root and objects in the members are only visible in the member. There is no schema enforcement across members of a federation to have exactly matching schema elements. So federation member 1 and 2 may have completely different schema...

category: Data | clicked: 1 | | source: blogs.msdn.com | show counter code
tags: Database Schema, SQL, SQL Azure, Database, Azure

No comments yet, be the first one to post comment.

To post your comment please login or signup