Database Design announcement
The following list of database design resources is not intended to be exhaustive or ‘the correct list’. Items are included simply because one of the Moderators knew the material and offered it as a suggestion. If you wish to offer suggestions for inclusion, please do so.
Eric Johnson and Joshua Jones
Lex de Haan, Toon Koppelaars
Architecting Regulatory-Compliant Architectures
Mike Walker, Microsoft
Graeme Simsion and Graham Witt
Practical Issues in Database Management: A Reference for the Thinking Practitioner
Louis Davidson, Kevin Kline, et al
A Simple Guide to Five Normal forms and Relational Database Theory
Data Modeling vs. Database Design
Database Design - Ten Common Database Design Mistakes, Louis Davidson
Database Design Issues -EAV Model Discussion (Querying an EAV Table)
Database Design Issues –EAV and OTLT
Database Design ROI by Paul Nielsen
Introduction to the Unified Dimensional Model (UDM)
Library of database models
On Normalization and Repeating Groups by Fabian Pascal
ORM white paper
Overview of the Relational Model
Understanding Data Model Quality, Graeme Simsion
Out of Scope
Some topics are out of scope for this forum.
1. Bugs, Product Decisions, and Feedback: The purpose of this forum is not to ask the product team why decisions were made and to ask them to make other changes. That feedback belongs in Connect. The purpose of this forum is to help you out with specific issues, if possible. Please post your feedback via Connect:
Rules of Conduct
· Relevance to Topics: We encourage you to keep your postings as close to the subject as possible.
· Respect: Please be respectful of other participants, and their contributions; avoiding insults, demeaning remarks and slurs.
· Tolerance: Please don’t assume someone’s curtness was meant to insult, slur, or demean you.
· Confidentiality: Confidential information should not be posted. This is a publicly available forum.
· Appropriate Language: Please keep the conversation on a professional level, avoiding any hint of profanity in your interactions.
· Advertising/Solicitation: Advertisements should not be posted, and will be removed.
Forum Moderators may, at their discretion, edit posts for clarity, readability and inappropriate language; split post into separate threads when appropriate; and delete post that do not positively contribute to the thread. Failure to comply with these 'Rules of Conduct' may result in your posts being edited to remove the offending comments, censure, or expulsion from participating in the Forums. The bottom line is: this Forum should feel like a ‘safe’ place to ask hard questions that invoke passionate responses.
By their very nature, many database design questions will not have a easily decernible 'answer'. You are encouraged to give folks 'credit' for helping you when appropriate. If someone's response was 'Helpful', use the 'Vote as Helpful' button. If a response answered some part of your question, or provided you one or more clues that led you to a solution, then use the 'Mark as Answer' option. Just as a thread may evolve into multiple questions, it may also have more than one 'Answer'.
Welcome to the Database Design Forum
This is a Forum for questions and discussions about database designs for Microsoft technologies, including: SQL Server, Access, SQL Azure, SQL Express, SQL Compact, etc. Often Database Designs will be generic and can be ported to any vendor's technology. Design problems that are best solved with other technologies will be welcomed and addressed to the best of our knowledge and ability.
We ask that you recognize that database design is a mixture of art and science. You may receive conflicting suggestions, for there can be multiple paths to a workable solution. You will have to use your own judgment and knowledge of your business requirements to determine the best solution for your particular problem. The 'right' design is compounded by many factors, including business, regulatory, hardware/software requirements, as well as staff expertise. We also encourage you to share your experiences with a particular design issue if it will serve to help others encountering similar problems.
In order to receive useful responses, please spend some time and properly present your scenario. Attempts to 'save time and effort' by cutting out parts of the scenario will often lead to wasted time and effort as the suggestions have to be discarded because they don't work with other parts of the unseen puzzle.
But there are limits to what you can expect from volunteers through a disconnected medium. The questions most likely to receive a good and targeted answer, are those that present a small problem, that give a very clear description of that problem within its context, and that are placed by people with a fair understanding of the subject who need help getting over a few nasty bumps. The questions that are almost impossible to answer satisfactorily are those that present a huge problem, with no clear description, and asked by someone totally new to the subject matter.
We hope that you will understand when we say that most of us that volunteer our time on this Forum do so in order to help folks learn. We will be pleased if you find the Forum to be useful. However, it is difficult or impossible for us to engage with folks privately. We don't have time to do both, and our commitment is help folks using the Forums.
Do not hesitate to read all of the threads, join in the discussions, offer your own experiences and information, and ask questions to increase your knowlege. Seek out blogs from those who write in a manner that you appreciate, and consider reviewing the Database Design Resources for additional guidance and help.
Unanswered0VotesHi! I'm trying to define a rathr large ER diagram and am constantly stumbling over the designer's insistence on renaming columns. Like, I have three tables, X, Y ...
Proposed1VotesDear all, I have a pool of data which are based organized has CATEGORY and SUB-CATEGORY. When I am configuring the database I should be able to define all categories at once, then ...
Unanswered0VotesHi, I am designing web based application. The scenario I am working on is - I have around 50+ odd objects. They have few common things but other fields will change (Say e.g. Employee / Customers/ ...
Answered0VotesHello, I am getting scan count 17 and logical reads 145634 and some time the query takes 2 minutes and sometime 5 seconds.Thelogical reads showing against a big table(Product and ...
Answered1VotesHI, I need to know how much bits will be allocate/occupy for the Varchar(50) in the sql server 2008/R2, Ex, Create table Memory_Test ...
Answered0VotesI am trying to build a SQL database to keep track of home inventory. I get SQL Server for free from school so I figure IT should be easy to set up a ...
Answered0VotesI have two table with some common field. I want to select row from one table excluding common row after inner joining two table
Answered0VotesHello. I have a 3 tables Patient,Test and Video as shown in the image. The relationships shown are set to cascade on ...
Answered0VotesDear all, In AW sample DB there is a ShopingCartItem table where user can place product they want to buy. In from that ShopingCardItem there seems to be no ...
Answered0VotesDear all, I generate a script from my database in order to be able to re create it manually. The script contains a set of ALTER DATABASE statement at the ...
Answered0VotesI'm designing a table with a hierarchyid to represent our organisational structure. This part I'm OK with, but if we had to support other organisational structures, should I just define each ...
Answered0VotesDear all, I need to build a database structure for a shop which is actually selling home furniture and I have seen that quite many table from the AW database could fit my scenario ...
Answered0VotesDear all, I have open the Adventure works database sample and have few technical design question about it : 1- I have seen that seen that some function has ...
Answered0VotesI have a hierarchyid that's roughly like this: / /1/... /2/ I want to move /1/... so that it and all its children are below ...
Answered0VotesDear all, I am actually studing the database structure of the AW sample database, which is quite close to one of my current project architecture. I have seen ...
Answered0VotesExplanation of table... the Wall Mart and Jim's Grocery is the location.. i decided to create 1 table each for these 2 locations. highlighted in blue, i.e A11, ...
Answered0VotesGood afternoon! I have a table that contains Company Account Number, Individual (People) Names and Social Security numbers. We are going to be implementing a ...
Discussion2VotesHere is the code I use to estimate compression savings. I'm only looking at the top 10 partitions. This script can take a couple of minutes to more depending on the size of the partitions. If ...
Answered0VotesCreate table empproj ( proj_id int, Emp_id int, Hours ...
- Items 1 to 20 of 2525 Next ›