Web site translator - 13 Advanced Database Structures and Hardware Resources This
13 Advanced Database Structures and Hardware Resources This final chapter of this book wraps up the database modeling design process, delving a bit into some advanced aspects of the implementation process. Implementation is essentially the actual database building process. When you build a database, as opposed to just the database model, you create the database itself. During the database-creation process, implementing the database model, you might want to consider various other factors. These other factors include specialized database model structures (other than tables and indexes). Additionally, there are certain hardware issues such as how big of a computer do you need? Other than hardware, there are certain database installation issues to consider, with respect to configuration. Configuration can affect various factors, such as how fast your database ultimately performs. Or how much recoverability do you need? How often should backups be executed? Configuration is computer jargon used to describe the way in which a computer system, or part thereof (such as a database) is installed and set up. For example, when you start up a Windows computer, all your desktop icons are part of the configuration of you starting up your computer. What the desktop icons are, and where on your desktop they are placed, are stored in a configuration file on your computer somewhere. When you start up your computer, the Windows software retrieves that configuration file, interprets its contents, and displays all your icons on the screen for you. This chapter essentially appears at the culmination of database model analysis and design; however, its contents should in the very least be considered as a part of the design process, before going ahead and purchasing hardware, and creating the physical database itself. By the end of this chapter, you will realize that database modeling is not just about creating tables, getting the correct relationships between them, and doing lots of hairy stuff with fields. Between the database modeling phase and the creation of a database, you might want to consider materialized views for a data warehouse, for example. Or, perhaps you might consider a specialized type of hardware configuration using something called a RAID array. In this chapter,you learn about the following:
Please visit our professional web hosting services to find out about cheap and reliable webhost service that will surely answer all your demands.