Why data updating is important

Heck, data management even made it into the US State of the Union Address.

why data updating is important-54

In a purely designed database these values would be divested into an extra entity or Reference Table called 'status' in order to achieve database normalization.

So, with reference tables available as an option to represent an enumeration, let's look at why the ENUM data-type is evil: Male/Female, Mr/Mrs/Ms, Africa/Asia/etc: these bits of text that people use ENUM columns for are .

She is a Microsoft SQL Server MVP, specializing in data modeling and database design.

She’s an advisor to the DAMA, International Board and a member of the Advisory Board of Zachman, International.

I also need to be able to share the models in formats that can be easily consumed by dozens of other modeling and development tools.

Most of the lesser tools don’t have these shiny features.

She is a frequent speaker, blogger and panelist on data quality, data governance, logical and physical modeling, data compliance, development methodologies and social issues in computing.

Karen is an active user on social media and has been named one of the top 3 technology influencers by IBM Canada and one of the top 17 women in information management by Information Management Magazine.

At first glance it seems like an efficient solution for declaring a set of permitted values from which only one can be chosen for each record.

A good example is a having a table of countries with a 'continent' column: every country belongs to a continent and the seven continents aren't likely to change anytime soon.

With all these questions about data model coming in, I thought I’d answer the most common ones here so that I can share them more widely. Often when I’m hired as the sole architect, I’m swamped with real work and no one has time to be trained nor is there time allocated for me to train anyone. If they specialize, really, in data modeling, it may be worth it. I want to warn you that hiring a data architect that really is one is difficult.

Tags: , ,