My previous article described how and why to use a surrogate key structure, as an alternative to natural data keys, to implement relationships between tables. It also provides eight stored procedures to support the architecture. This article builds on that foundation with a framework for the proposed database architecture. It describes six standard table columns, six standard stored procedures, one standard user-defined function and two standard triggers. It also provides 12 stored procedures to create and manage the standard objects.
Brian Walker Brian Walker is a senior database architect in an IS department that uses SQL Server 2000 and the .NET Framework. He has more than 25 years of experience in the IT industry with the last several years focused on databases and SQL Server. Walker is a software developer, database developer, database administrator and database consultant. He develops utility software as a hobby, including a large collection of SQL Server utilities. Copyright 2006TechTarget
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.
Home: Introduction
