Beginning Database Design- P12:This book focuses on the relational database model from a beginning perspective. The title is, therefore, Beginning Database Design. A database is a repository for data. In other words, you can store lots of information in a database. A relational database is a special type of database using structures called tables. Tables are linked together using what are called relationships. You can build tables with relationships between those tables, not only to organize your data, but also to allow later retrieval of information from the database | 8 Building Fast-Performing Database Models Man is a slow sloppy and brilliant thinker the machine is fast accurate and stupid. William M. Kelly Man is ingenious. Only by instructing a database properly will it perform well. Much of the information in this chapter has already been discussed perhaps even analyzed and often alluded to in previous chapters of this book. This chapter is intended to take everything you have learned so far all the theory and begin the process of putting it into practice. This chapter describes various factors affecting database performance tuning as applied to different database model types. Anything obviously repeated from a previous chapter should be considered as being doubly significant with respect to database modeling. Database performance is the most important factor as far as any database or database model is concerned. If performance is not acceptable your database model does not service the end-users in an acceptable manner. End-users are your clients and thus the most important people in your life at least as far as your database is concerned. A client can be a direct customer or an indirect customer. An indirect client could be someone else s customer your customer s client. Previous chapters have explained database modeling theory. This chapter forms a bridge between database modeling and related theoretical concepts described in the previous chapters and a large ongoing case study in chapters to follow this chapter. The following chapters dig into the practical aspects of database modeling by describing and demonstrating the full process of thinking about analyzing designing and building a database model in a real world environment. By the end of this chapter you should have a slightly less theoretical and slightly more real-world picture of database modeling techniques. Chapter 8 In this chapter you learn about the following Factors affecting tuning of different types of database models All the detail on writing efficient .
