Database Design and Development – An Essential Guide for IT Professionals
An Essential Guide for IT Professionals
Gebonden Engels 2003 9780471218777Samenvatting
The first and only database primer for today′s global economy
Today′s businesses depend on their databases to provide information essential for their day–to–day operations and to help them take advantage of today′s rapidly growing and maturing electronic commerce opportunities. The primary responsibility for the design and maintenance of these databases rests with a company′s information technology department.
Unlike other IT resources currently available that tend to focus on a particular product, Database Design and Development: An Essential Guide for IT Professionals was created to give today′s IT directors and other IT staff a solid basic knowledge of database design and development to help them make educated decisions about the right database environment for their companies. Today′s IT professionals must understand the fundamentals in order to determine their next steps for specializing in the vast field of database technology.
Database Design and Development: An Essential Guide for IT Professionals answers such common questions as:
What is the purpose of a database system?
What are the components of a database system?
What type of data does your company need to capture?
How do you design a database for a particular goal?
How do you capture information through data modeling?
How do you determine which database will best meet your business objectives?
What′s involved in effective database management and maintenance?
How are database systems used to interface with the Internet?
With more than twenty–five years of experience teaching IT courses and designing databases for some of America′s top institutions, the author has succeeded in creating an essential resource for today′s IT managers as well as for students planning a career in information technology.
Specificaties
Lezersrecensies
Inhoudsopgave
<p>PART I BASIC DATABASE CONCEPTS 1</p>
<p>1 THE DATABASE APPROACH 3</p>
<p>2 OVERVIEW OF MAJOR COMPONENTS 36</p>
<p>PART II DATABASE DEVELOPMENT PROCESS 67</p>
<p>3 SIGNIFICANCE OF THE DATABASE ENVIRONMENT 69</p>
<p>4 DATABASE DEVELOPMENT LIFE CYCLE 93</p>
<p>PART III CONCEPTUAL DATA MODELING 141</p>
<p>5 DATA MODELING BASICS 143</p>
<p>6 OBJECT–BASED DATA MODEL: PRINCIPLES AND COMPONENTS 167</p>
<p>7 ENTITY–RELATIONSHIP DATA MODEL 206</p>
<p>PART IV THE RELATIONAL DATA MODEL 237</p>
<p>8 RELATIONAL DATA MODEL FUNDAMENTALS 239</p>
<p>9 SEMANTIC DATA MODEL TO RELATIONAL DATA MODEL 273</p>
<p>10 DATA NORMALIZATION METHOD 303</p>
<p>PART V DESIGN AND IMPLEMENTATION 331</p>
<p>11 COMPLETING THE LOGICAL DESIGN 333</p>
<p>12 THE PHYSICAL DESIGN PROCESS 351</p>
<p>13 SPECIAL IMPLEMENTATION CONSIDERATIONS 385</p>
<p>PART VI DATABASE ADMINISTRATION AND MAINTENANCE 423</p>
<p>14 OVERVIEW OF ADMINISTRATION FUNCTIONS 425</p>
<p>15 DATA INTEGRITY 446</p>
<p>16 DATABASE SECURITY 495</p>
<p>17 ONGOING MAINTENANCE AND GROWTH 525</p>
<p>PART VII ADVANCED DATABASE TOPICS 551</p>
<p>18 DISTRIBUTED DATABASE SYSTEMS 553</p>
<p>19 DATABASE SYSTEMS AND THE WEB 598</p>
<p>20 TRENDS IN DATABASE TECHNOLOGY 636</p>
<p>APPENDICES 685</p>
<p>A Legacy System Models: Hierarchical and Network 687</p>
<p>B Codd′s Relational Rules 692</p>
<p>C Diagramming Conventions and Symbols 694</p>
<p>D Use of CASE tools 700</p>
<p>E Review of major commercial DBMSs 703</p>
<p>F Database Design and Development Summary 712</p>
<p>References 716</p>
<p>Glossary 718</p>
<p>Index 729</p>
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan