SQL Server Customer Advisory Team - SQL Server Best Practices

Enabling SQL Server customers to navigate the most challenging frontiers of large scale data management.

Whitepapers

Best Practices for Semantic Data Modeling for Performance and Scalability

Published: August 2008
Writer: Sharon Bjeletich
Reviewer: Thomas Kejser

More and more business applications are architected as business frameworks, where the core data model of the framework must support customers who work with different database objects and attributes, as well as allow for extensive customization. This paper covers some of the issues that can arise when it is difficult to decide whether to use an object-oriented or relational approach to designing the database. It includes approaches to improve performance and scalability. This paper is for database developers who are familiar with semantic modeling challenges.

For more information, please refer to the whitepaper Best Practices for Semantic Data Modeling for Performance and Scalability.

Comments

No Comments
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
Copyright 2008 Microsoft Corporation. All Rights Reserved.