A developer's guide to data modeling for SQL server : by Eric Johnson

By Eric Johnson

A Developer’s advisor to facts Modeling for SQL Server explains the ideas and perform of information modeling with a readability that makes the know-how available to a person development databases and data-driven applications.

“Eric Johnson and Joshua Jones mix a deep figuring out of the technological know-how of knowledge modeling with the paintings that includes years of expertise. If you’re new to facts modeling, or locate the necessity to brush up on its suggestions, this booklet is for you.”
Peter Varhol, govt Editor, Redmond Magazine

Model SQL Server Databases That paintings greater, Do extra, and Evolve extra easily

Effective info modeling is key to making sure that your databases will practice good, scale good, and evolve to satisfy altering necessities. despite the fact that, if you’re modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic facts modeling wisdom isn’t sufficient: types that don’t replicate SQL Server’s specific real-world strengths and weaknesses frequently bring about disastrous functionality.

A Developer’s consultant to information Modeling for SQL Server is a realistic, SQL Server-specific advisor to info modeling for each developer, architect, and administrator. This booklet provides you with priceless start-to-finish counsel for designing new databases, remodeling current SQL Server information versions, and migrating databases from different systems.

You’ll start with a concise, functional assessment of the center info modeling innovations. subsequent, you’ll stroll via necessities amassing and realize the right way to convert specifications into powerful SQL Server logical versions. eventually, you’ll systematically rework these logical versions into actual versions that utilize SQL Server’s prolonged performance. All of this book’s many examples can be found for obtain from a better half website.

This e-book permits you to

  • Understand your info model’s actual components, from garage to referential integrity
  • Provide programmability through saved tactics, user-defined services, triggers, and .NET CLR integration
  • Normalize information versions, one step at a time
  • Gather and interpret specifications extra effectively
  • Learn a good method for developing logical models
  • Overcome modeling difficulties relating to entities, characteristic, facts kinds, garage overhead, functionality, and relationships
  • Create actual models—from constructing naming guidance via enforcing enterprise principles and constraints
  • Use SQL Server’s particular indexing functions, and triumph over their limitations
  • Create abstraction layers that improve safety, extensibility, and flexibility

Show description

Read Online or Download A developer's guide to data modeling for SQL server : covering SQL server 2005 and 2008 PDF

Best data modeling & design books

Polynomial Algorithms in Computer Algebra

For a number of years now i've been instructing classes in desktop algebra on the Universitat Linz, the college of Delaware, and the Universidad de Alcala de Henares. within the summers of 1990 and 1992 i've got equipped and taught summer season faculties in machine algebra on the Universitat Linz. steadily a suite in fact notes has emerged from those actions.

Data Dissemination and Query in Mobile Social Networks

With the expanding popularization of non-public handheld cellular units, extra humans use them to set up community connectivity and to question and percentage info between themselves within the absence of community infrastructure, growing cellular social networks (MSNet). due to the fact that clients are just intermittently attached to MSNets, consumer mobility might be exploited to bridge community walls and ahead facts.

Big Practical Guide to Computer Simulations

"This precise ebook is a musthave for any pupil making an attempt first steps in laptop simulations. Any new pupil becoming a member of my computational physics crew is predicted to first paintings via Hartmann's consultant earlier than beginning a study venture. " Helmut Katzgraber affiliate Professor Texas A&M collage "This ebook is choked with important info for everybody doing laptop simulations.

Additional resources for A developer's guide to data modeling for SQL server : covering SQL server 2005 and 2008

Sample text

If the value does not match, prevents the delete from taking place. Cascade: Deletes all matching entries from the child entity (in addition to the instance in the parent entity) based on the match of primary key value and foreign key value between the entities. Null (Set Null): Similar to Restrict; if the value does not match, sets the child foreign key value to NULL (or a specified default value) and permits the delete. This creates orphaned instances in the child entity. Child entity INSERT None: Takes no action; enforces no restrictions.

Rather than painstakingly create and maintain these attributes in each individual entity, you can use domains. A domain is a definition of an attribute that is maintained as part of the logical model but outside a given entity. Whenever an attribute that is part of a domain is used, that domain is added to the entity. Generally, a data model does not provide a visual indication that a given attribute is actually part of a domain. Most data modeling tools provide a separate section or document, such as a data dictionary, to store domain information.

You gain an exponential benefit when you start working with many base tables in a single view. Using views also allows you to change the tables or the location where the data is stored without affecting users. In the end, as long as you update the view definition so that it accommodates the table changes you made, your users will never need to know that there was a change. You can also use views to better manage security. If you have users who need to see some employee data but not sensitive data such as social security numbers or salary, you can build a view that displays only the information they need.

Download PDF sample

Rated 4.72 of 5 – based on 13 votes