Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Data Modeling Rss

Search for any content tagged data modeling

   Items 1 to 20 of 32    Older >>
 

Restructure 100 Million Row (or more) Tables in Seconds. SRSLY!

Changing the structure of a very large table doesn't need to require a maintenance window.  Read more...
By Solomon Rutzky 2012/10/05 (first published: 2011/04/26) | Source: SQLServerCentral.com | Category: data modeling
Rating: |  Discuss |   Briefcase | 18,880 reads

Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services

This white paper provides practical guidance to help BI professionals and decision makers decide whether SQL Server 2012 Analysis Services tabular or multidimensional modeling provides the best fit for your next BI solution.  Read more...
By Additional Articles 2012/09/14 | Source: Microsoft MSDN | Category: business intelligence
Rating: (not yet rated)  Rate this |   Briefcase | 2,553 reads

PASS Data Architecture Virtual Chapter presents Audrey Hammonds – Database Makeover: Renovate You Data Model

On Thursday January 19th at 12 noon Central, Audrey Hammonds will discuss renovating your data model while keeping you’re the production system humming  Read more...
By Press Release 2012/01/19 | Source: SQLServerCentral.com | Category: events
Rating:  Rate this |   Briefcase | 1,462 reads

Going Beyond the Relational Model with Data

SQL is a powerful tool for querying data, and for aggregating it. However, you can't easily use it to draw inferences, to make predictions, or to tease out subtle correlations. To provide ever more sophisticated inferences to businesses, the race is on to combine the power of the relational model with advanced statistical packages. Both IBM and PostGres are ready with solutions. And SQL Server? Hmm...  Read more...
By Additional Articles 2011/10/13 | Source: SimpleTalk | Category: relational
Rating:  Rate this |   Briefcase | 2,344 reads

Restructure 100 Million Row (or more) Tables in Seconds. SRSLY!

Changing the structure of a very large table doesn't need to require a maintenance window.  Read more...
By Solomon Rutzky 2012/10/05 (first published: 2011/04/26) | Source: SQLServerCentral.com | Category: data modeling
Rating: |  Discuss |   Briefcase | 18,880 reads

Naturally Increasing Data Value with Hierarchical Structures

Hierarchical structures have an inherent ability for significant data value increases beyond the data collected. This will be shown to exist in hierarchical structures and even more powerfully in their natural hierarchical processing capabilities. These will demonstrate flexible and efficient ways to increase data value automatically and will be discussed in this article. SQL will be used to perform a wide range of hierarchical processing operations that easily demonstrate these increasing data value capabilities.  Read more...
By Additional Articles 2011/03/23 | Source: Other | Category: data modeling
Rating:  Rate this |   Briefcase | 2,923 reads

Extending Hierarchical Data Modeling Demonstrated in SQL

The capability of extending the limits of combining multiple node hierarchical structures has not been fully explored. Michael M. David presents a solution to advanced structure combining that is simple to use, generic and freely extends the way hierarchical structures can be semantically combined to produce advanced new hierarchical data structure mashups that dynamically increase the value of the data.  Read more...
By Additional Articles 2010/07/16 | Source: Database Journal | Category: data modeling
Rating:  Rate this |   Briefcase | 2,855 reads

Overusing Identities

Do you put an identity column on every table? That might be a bad habit you want to kick, but not all at once. Steve Jones comments on this common data modeling practice.  Read more...
By Steve Jones 2010/03/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 292 reads

How Oslo can you go?

Some developers have reacted with dismay to the recent news that Microsoft’s Oslo project is being integrated into the SQL Server platform and renamed SQL Server Modeling. The overwhelming feeling seems to be that their DSL dream is being snatched away.  Read more...
By Tony Davis 2009/11/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 70 reads

Enforcing Data Quality while using Surrogate Keys

Data quality is important in a database, but so many people fail to implement good referential integrity. New author Marvin Elder brings us an article that looks at surrogate keys for ensuring data quality.  Read more...
By Marvin Elder 2009/09/08 | Source: SQLServerCentral.com | Category: data modeling
Rating: |  Discuss |   Briefcase | 6,141 reads

The Joy of Data Modelling.

You may think that the task of teasing out the exact nature of the data and processes within a company...  Read more...
By Phil Factor 2009/08/17 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,335 reads

The 10-Minute Data Model Review, Part 2

Data modeling is based on the precept of knowing your data and knowing how the data is interrelated with other data. Everyone knows their data – right? If so, then why do we have so many problems building systems that do what the users want?  Read more...
By Additional Articles 2008/08/26 | Source: TDAN | Category: data modeling
Rating: (not yet rated)  Rate this |   Briefcase | 2,720 reads

Data Lineage: The Next Generation

Bill Lewis describes the benefits of an application development environment in which all data dependencies begin and remain clearly, precisely and explicitly defined.  Read more...
By Additional Articles 2008/08/19 | Source: TDAN | Category: data modeling
Rating:  Rate this |   Briefcase | 1,688 reads

Achieve Flexible Data Modeling with the Entity Framework

Here the author answers questions regarding the Entity Framework and provides an understanding of how and why it was developed.  Read more...
By Additional Articles 2008/08/01 | Source: Microsoft MSDN | Category: data modeling
Rating:  Rate this |   Briefcase | 2,673 reads

Dimensional Model Components: Dimensions Part II

Business Intelligence Architect Bill Pearson continues his subseries surrounding components of the Analysis Services dimensional model. In the second half of this article, we extend our focus on dimensions to include property settings for Cube Dimensions.  Read more...
By Additional Articles 2008/03/06 | Source: Database Journal | Category: data modeling
Rating: (not yet rated)  Rate this |   Briefcase | 1,978 reads

The Stewardship Approach to Data Governance: Chapter 8

This is the eighth article in a continuing series, and this installment discusses the Data Steward Coordinator.  Read more...
By Additional Articles 2008/03/06 | Source: TDAN | Category: data modeling
Rating: (not yet rated)  Rate this |   Briefcase | 1,003 reads

The Stewardship Approach to Data Governance: Ch 7

This is the seventh article in a continuing series, and this installment discusses the tactical layer of the Data Governance Framework.  Read more...
By Additional Articles 2008/02/28 | Source: TDAN | Category: data modeling
Rating: (not yet rated)  Rate this |   Briefcase | 1,065 reads

The Stewardship Approach to Data Governance: Ch. 6

This is the sixth article in a continuing series, and this installment discusses the establishment and role of a Data Governance Council.  Read more...
By Additional Articles 2008/02/21 | Source: TDAN | Category: data modeling
Rating: (not yet rated)  Rate this |   Briefcase | 1,027 reads

5 Tips for Becoming a Better Data Modeler

5 quick tips to help you become a better data modeler and increase your value to your team and organization.  Read more...
By Troy Ketsdever 2008/02/19 | Source: SQLServerCentral.com | Category: data modeling
Rating: |  Discuss |   Briefcase | 11,538 reads

The Data Stewardship Approach to Data Governance: Chapter 5

Part 5 looks at beginning with a Data Governance Best Practice Assessment  Read more...
By Additional Articles 2008/02/14 | Source: TDAN | Category: data modeling
Rating: (not yet rated)  Rate this |   Briefcase | 1,058 reads
   Items 1 to 20 of 32    Older >>