Azure Table Storage Database Diagramming

1
votes

I'm wondering what the professional way is to create a database schema for a Azure Storage Tables database (not SQL Azure).

For a datawarehouse you usually make a starscheme or snowflake (OLAP cube) and for a database with a lot of transactions you'd probably make a normalized relational database (SQL Azure/SQL Server). But with Azure Storage Tables there aren't any relations to make so what's the best practice for creating a professional Azure Storage Tables database?

1
azureazure-storageazure-table-storage

1 Answers

8
votes

So, Azure Storage tables do not have schema. When you save an object to an azure table, that object is just there. You do not create schema for a table. Visualization tools, like Cerebrata's Storage Studio or Visual Studio's table viewer attempt to visualize the data in the azure table as columns, but in reality, all they're doing is showing you properties of objects as columns for convenience.