Chapter 2 DATABASE DESIGN FOR SQL SERVER 2000
Chapter 2 DATABASE DESIGN FOR SQL SERVER 2000 91 opposed to the specifics needed for the implementation. At this stage it is more important to simply categorize the data. Between the logical modeling and the physical implementation, the actual software is chosen (though in the example case it was really predetermined). If developing a system from scratch where no software exists, the business needs are laid out, the logical model represented, REVIEW BREAK and the system architecture is designed before any decisions are made about the physical design, software, and hardware. If certain software is already being used in a given business, then some of the logical design stages may be adjusted toward specific products. The next section looks at the architecture of different types of database systems from the smallest desktop environments to the large-scale Internet application becoming prevalent in today s IT environment. Models and Uses Now you have a model, and even have some ideas of how to control the model to maintain accuracy and prevent system breakdown due to loss of integrity. Many tools are available to prevent the bad data from getting in that could produce incorrect results. Imagine the result if a government agency bases its decisions that will affect an entire country on data that is inaccurate or misrepresented. (Governments have enough trouble making decisions with accurate data.) So now you have a high-performance model that has been made as efficient possible through normalization principles. You may have even applied some planned redundancy (denormalization) in an effort to improve the performance and make the data more meaningful. But what about the storage? Now that you have attributes of all shapes and sizes, you need something to put them in. It is now time to look into the data itself. THE CLIENT/SERVER MODEL . Handle client/server configurations of 50 to 5,000 or more users. One, two, and n tier operations Internet applications. Web configurations that use
If you looking for unlimited one inclusive web hosting plan please check unlimited web hosting website.