Skip to main content

Posts

Showing posts with the label Database Design

Database Design Practices

In database discussions, it is common to hear the term normalization or database design come up. However, for the most parts these discussions revolve around splitting up the data that is stored between different  tables to improve performance and to eliminate duplication.  This is extremely important and should be  discussed in any discussion on tables but for the most part the discussions do not involve splitting up data  between databases.  This is either assumed or just not put into practice as often as it should be.  Either way,  it is important to consider when designing an application that will need to access data. Information Commonality Data could be defined as the actual values that are stored in the database itself and are static until they are changed by some process (either manually or automated). Data by itself is useless if not processed in such a way as to give it meaning.  Information, on the other hand, is data processed in such a way as to give it meani