§Þ§Ñ§ã§ê§ä§Ñ§Ò§Ú§â§à§Ó§Ñ§ß§Ú§Ö §Ó Sql azure
?Download as PPTX, PDF?
0 likes?437 views
This document discusses federations in SQL Azure. Federations allow scaling out data by partitioning it across multiple databases. The document shows an example of a "CustData" federation with members for customer ID ranges that each contain sample data partitions. It also shows an "Orders_Fed" federation partitioned by customer ID that could include related order data spread across multiple databases. In the future, SQL Azure will support federations natively as a way to scale databases beyond a single server.
§Þ§Ñ§ã§ê§ä§Ñ§Ò§Ú§â§à§Ó§Ñ§ß§Ú§Ö §Ó Sql azure
- 3. T1 T2 T3 T4 T5 T6 T7 T8 T9 T1 0 T1 1 T1 2 T1 3 T1 4 T1 5 T1 6 T1 7 T1 8 T1 9 T2 0 §£§ã§Ö §Þ§à§Ú §Õ§Ñ§ß§ß§í§Ö §ç§â§Ñ§ß§ñ§ä§ã§ñ §Ó §à§Õ§ß§à§Û §¢§¥ §ß§Ñ §à§Õ§ß§à§Þ §ã§Ö§â§Ó§Ö§â§Ö
- 4. Covered by SQL Azure today Coming up in SQL Azure: Federations
- 5. Federation ¡°CustData¡± Member: [min, 100) AU PK= 5 AU PK=25 AU PK=35 Member: [100, 488) AU PK=10 5 AU PK=23 5 AU PK=36 5 Member: [488, max) AU PK=55 5 AU PK=25 45 AU PK=35 65 (Federation Key: CustID)
- 12. THANK YOU §¥§Ö§ß§Ú§ã §²§Ö§Ù§ß§Ú§Ü §²§å§Ü§à§Ó§à§Õ§Ú§ä§Ö§Ý§î §Õ§Ö§á§Ñ§â§ä§Ñ§Þ§Ö§ß§ä§Ñ §Ó§Ö§Ò-§â§Ñ§Ù§â§Ñ§Ò§à§ä§Ü§Ú, DCT Trainer, Microsoft Innovation Center Microsoft MVP (SQL Server) MCT, MCITP, MCPD, MCTS reznik@dctua.com http://reznik.uneta.com.ua/ http://twitter.com/DenisReznik