Muutke küpsiste eelistusi

Database Development and Management [Kõva köide]

3.67/5 (6 hinnangut Goodreads-ist)
(University of Houston-Victoria, Sugar Land, Texas, USA)
  • Formaat: Hardback, 634 pages, kõrgus x laius: 254x178 mm, kaal: 1292 g, 98 Tables, black and white; 508 Illustrations, black and white
  • Sari: Foundations of Database Design
  • Ilmumisaeg: 13-Jan-2006
  • Kirjastus: Auerbach
  • ISBN-10: 0849333180
  • ISBN-13: 9780849333187
Teised raamatud teemal:
Database Development and ManagementSuurem pilt
  • Formaat: Hardback, 634 pages, kõrgus x laius: 254x178 mm, kaal: 1292 g, 98 Tables, black and white; 508 Illustrations, black and white
  • Sari: Foundations of Database Design
  • Ilmumisaeg: 13-Jan-2006
  • Kirjastus: Auerbach
  • ISBN-10: 0849333180
  • ISBN-13: 9780849333187
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780849333187.html
Märksõnad:
Today's database professionals must understand how to apply database systems to business processes and how to develop database systems for both business intelligence and Web-based applications.

Database Development and Management explains all aspects of database design, access, implementation, application development, and management, as well as data analysis for business intelligence. This self-contained text gives students hands-on projects required for professionally developing and managing databases. It provides detailed instruction via an easy-to-follow, step-by-step case-based approach.

Following an introduction to database components, the book uses case studies to illustrate the modeling process, covers table structures and normalization, and analyzes the transformation of a data model to a relational database. It explains the use of SQL in managing database objects and in querying databases, then discusses Transact-SQL and the views, indexes, and cursors that bridge databases and their applications.

The book examines three major data-accessing techniques, and then shows how to develop sophisticated applications based upon the material included in previous chapters. It explores the use of databases in network environments, and details the multiple tasks handled by database administrators (DBAs).

The text also discusses the OnLine Analytical Processing (OLAP) system, data warehousing, and other analysis tools that support business intelligence and decision making. It concludes with a review of data mining.
Preface xvii
Acknowledgments xxv
Introduction to Database Systems
1(16)
Objectives
1(1)
Functions of a Database
1(1)
Database Management System
2(6)
Database Components
8(6)
Database Development Process
14(1)
Summary
15(2)
Review Questions
16(1)
Conceptual Design and Data Modeling
17(40)
Objectives
17(1)
Introduction to Database Design Process
17(2)
Conceptual Design
18(1)
Database Design
18(1)
Physical Design
18(1)
Understanding Business Process
19(5)
Business Process
19(1)
Case Study: Hillcrest Computing Business Process
20(1)
Investigating Business Requirements
21(3)
Entity-Relationship Data Model
24(11)
Entities
25(1)
Attributes, Identifiers, and Domains
25(1)
Relationships
26(4)
Cardinality
30(1)
Relationship Naming
31(1)
Recursive Relationships
32(1)
Ternary Relationships
33(1)
Business Rules
34(1)
Representing Business Process with Entity-Relationship Model
35(17)
Determining Entities from Business Information
35(1)
Identifying Attributes from Business Information
36(3)
Identifying Relationships among Entities
39(1)
Identifying Cardinalities
40(3)
Creating Entity-Relationship Diagrams
43(1)
Creating Entities
43(3)
Creating Relationships
46(4)
Entity-Relationship Modeling
50(2)
Summary
52(5)
Review Questions
52(1)
Case Study Projects
53(1)
Computer Service
53(1)
University Registration
54(1)
Mail Order
54(3)
Table Structure and Normalization
57(30)
Objectives
57(1)
Introduction to Tables
57(5)
Tables
57(1)
Keys
58(2)
Linking Tables
60(1)
Functional Dependency
60(2)
Table Normalization
62(21)
Why Table Normalization
62(4)
Normal Forms
66(1)
First Normal Form (1NF)
67(1)
Second Normal Form (2NF)
67(1)
Third Normal Form (3NF)
68(2)
Boyce--Codd Normal Form (BCNF)
70(1)
Fourth Normal Form (4NF)
71(4)
Domain-Key Normal Form (DKNF)
75(8)
Denormalization
83(1)
Summary
83(4)
Review Questions
84(1)
Case Study Projects
84(1)
Computer Service
85(1)
University Registration
85(1)
Mail Order
85(2)
Transforming Data Models to Relational Databases
87(36)
Objectives
87(1)
Introduction
87(1)
DBMS Selection
88(1)
Transforming Data Models to Relational Databases
89(13)
Representing Entities
89(4)
Representing Relationships
93(9)
Enforcing Constraints
102(2)
Creating Database for Business Process
104(17)
Creating the Hillcrest Computing Database
110(1)
Designing Tables
111(2)
Creating Surrogate Keys
113(2)
Enforcing Constraints
115(3)
Creating Relationship Diagrams
118(3)
Summary
121(2)
Review Questions
121(1)
Case Study Projects
122(1)
Computer Service
122(1)
University Registration
122(1)
Mail Order
122(1)
Physical Design and Database Implementation with SQL
123(36)
Objectives
123(1)
Introduction
123(1)
Physical Design
124(1)
Database System Architecture
124(1)
Data Type and Size
124(1)
Database Accessing
125(1)
Data Usage
125(1)
Creating, Controlling, and Modifying Database Objects with SQL
125(17)
Creating Database Objects
126(1)
Creating Databases
126(1)
Defining Data Types
127(1)
Creating Tables
128(5)
Creating Views
133(1)
Creating Database Objects in Query Analyzer
133(3)
Modifying Database Objects
136(4)
Manipulating Data in Tables
140(1)
Controlling Database Object Privileges
141(1)
Transporting Database Data
142(12)
Entering Data Manually
142(1)
Importing and Exporting Data
143(1)
Import/Export Wizard
143(2)
Bulk Copy Program (bcp)
145(4)
Bulk Insert
149(1)
Accessing External Data
149(3)
Copying Database
152(2)
Summary
154(5)
Review Questions
154(2)
Case Study Projects
156(1)
Computer Service
156(1)
University Registration
157(1)
Mail Order
157(2)
Querying Databases
159(26)
Objectives
159(1)
Introduction
159(1)
Retrieving Data from Tables
159(22)
Querying with Select, From and Where Statements
160(1)
Logical Operators
160(5)
Comparison Operators
165(2)
Arithmetic Operators
167(2)
Subqueries
169(3)
Joining Multiple Tables with SQL
172(2)
Inner Join
174(1)
Outer Join
175(1)
Multiple Joins
176(1)
Self Join
176(3)
SQL Built-In Functions
179(2)
Summary
181(4)
Review Questions
182(1)
Case Study Projects
183(1)
Computer Service
183(1)
University Registration
183(1)
Mail Order
184(1)
SQL Procedures
185(36)
Objectives
185(1)
Introduction
185(1)
SQL Programming Extension
186(4)
Variables
186(1)
Flow-Control Structures
187(3)
Procedures and Functions
190(12)
Functions
190(1)
Built-In Functions
191(2)
User-Defined Functions
193(3)
Procedures
196(1)
Viewing and Executing Stored Procedures
197(1)
Creating, Modifying, and Deleting Stored Procedures
198(4)
Triggers
202(8)
About Triggers
203(1)
Trigger Execution
203(1)
Creating, Modifying, and Deleting Triggers
204(2)
Using Triggers
206(1)
Validating Business Constraints
206(2)
Implementing Dynamic Application Logic
208(1)
Keeping Referential Integrities
209(1)
Debugging SQL Procedures
210(7)
Procedure Debugger
211(2)
Return Statement
213(2)
@ @ Error
215(1)
Raiserror
216(1)
Summary
217(4)
Review Questions
217(1)
Case Study Projects
218(1)
Computer Service
218(1)
University Registration
219(1)
Mail Order
219(2)
Database Views, Indexes, and Cursors
221(36)
Objectives
221(1)
Introduction
221(4)
Creating and Managing Views
225(8)
Creating Views
225(1)
Creating a View Using Enterprise Manager
225(1)
Creating a View by Create View Statement
226(1)
Creating a View by Create View Wizard
227(2)
Modifying Views
229(1)
Modifying Data in Views
230(1)
Creating Calculated Columns in Views
230(3)
Deleting Views
233(1)
Creating and Managing Indexes
233(6)
Creating Indexes
234(1)
Creating Indexes with Enterprise Manager
234(1)
Creating Indexes with Wizard
235(1)
Creating Indexes with Create Index Statement
235(1)
Managing Indexes
236(1)
Managing Indexes with Enterprise Manager
236(1)
Managing Indexes with Query Analyzer
237(1)
Managing Indexes with Stored Procedures
237(2)
Updating Indexes
239(1)
Deleting Indexes
239(1)
Creating and Managing Cursors
239(3)
Client Cursors
240(1)
Application Programming Interface (API) Server Cursors
240(1)
Transact-SQL Cursors
241(1)
Case Study: Hillcrest Computing
242(11)
Summary
253(4)
Review Questions
253(1)
Case Study Projects
254(1)
Computer Service
254(1)
University Registration
254(1)
Mail Order
255(2)
Accessing Data
257(30)
Objectives
257(1)
Introduction
257(1)
Database Accessing
258(2)
Open Database Connectivity (ODBC)
260(6)
Object Linking and Embedding Database (OLE DB)
266(3)
Active Data Object (ADO)
269(14)
Example: Creating an ADO RecordSet Object
279(4)
Summary
283(4)
Review Questions
283(1)
Case Study Projects
284(1)
Computer Service
284(1)
University Registration
284(1)
Mail Order
285(2)
Database Application Development
287(52)
Objectives
287(1)
Introduction
287(1)
Understanding Business Process
288(2)
User Interface Design and Format
290(6)
Graphical User Interface
290(3)
Enforcing Cardinality Constraints
293(3)
Creating Forms
296(27)
Creating Forms with Form Wizard
297(1)
Creating Forms Based on Views with Form Wizard
297(1)
Creating Forms Based on Tables with Form Wizard
298(2)
Creating Forms Based on Stored Procedures with Form Wizard
300(2)
Creating Forms without Wizard
302(1)
Creating Company Logo
303(2)
Creating Views for Forms
305(1)
Placing Controls to Forms
305(1)
Configuring Properties for Controls
306(2)
Configuring Option Group with Control Wizard
308(1)
Configuring Text Box with Conditional Formatting
309(3)
Programming Event Procedures
312(1)
Configuring Click Event for Combo Box
312(2)
Creating Subforms
314(1)
Creating Subform with Wizard
315(3)
Configuring Click Event for Command Button
318(3)
Configuring Command Button Using Wizard
321(2)
Creating Reports
323(12)
Creating Reports Using Wizards
323(1)
Creating Report Based on Table or View
323(1)
Embedding Subreport in Main Report
323(2)
Creating Report Based on Stored Procedure
325(2)
Dynamically Formatting Report Using Conditional Formatting
327(1)
Creating Comprehensive Reports Using Forms, Reports, and Graphics
328(1)
Creating More Sophisticated Sales Report
328(1)
Creating Sales Chart
329(1)
Creating Select Sales Center Form
330(5)
Summary
335(4)
Review Questions
336(1)
Case Study Projects
336(1)
Computer Service
337(1)
University Registration
337(1)
Mail Order
337(2)
Network Databases
339(72)
Objectives
339(1)
Introduction
339(1)
Client/Server Computing
340(4)
Two-Tier Architecture
341(1)
Three-Tier Architecture
342(2)
Introduction to Extensible Markup Language (XML)
344(12)
XML Data File (.xml File)
346(1)
XML Schema Definition Language File (.xsd File)
347(3)
Extensible Stylesheet File (.xsl file)
350(3)
Export/Import XML Data
353(3)
Developing Database Applications with Visual Studio .NET
356(28)
Developing Windows Application
357(1)
GUI Design for Windows Application
358(3)
Accessing Data with ADO.NET
361(6)
Writing Code to Perform Activities for Windows Application
367(5)
Testing Windows Application Project
372(1)
Developing Web Application
372(4)
GUI Design for Web Application
376(1)
Creating Data Adapters and Generating Dataset
377(3)
Writing Code to Perform Activities for Web Application
380(3)
Testing Web Application Project
383(1)
XML Web Services and InfoPath
384(21)
Creating Web Services with Visual Studio .NET
385(6)
Creating InfoPath Forms
391(1)
Creating Form Based on Existing Data Source
392(3)
Creating Form Receiving Data from XML Web Service Data Source
395(5)
Creating Form to Submit Data to XML Web Service Data Source
400(5)
Summary
405(6)
Review Questions
407(1)
Case Study Projects
407(1)
Computer Service
407(1)
University Registration
408(1)
Mail Order
409(2)
Database Administration
411(54)
Objectives
411(1)
Introduction
411(1)
Managing Database User Accounts and Security
412(12)
Server Authentication
412(1)
Windows Authentication Mode
412(1)
Mixed Authentication Mode
413(1)
Server Authorization
414(1)
Database Users
414(1)
Permissions
415(1)
Roles
415(2)
Creating Roles and Users, and Auditing Log-Ins
417(1)
Creating Roles
418(1)
Creating Users
418(2)
Auditing Log-Ins
420(4)
Backing Up and Recovering Databases
424(13)
About Database Backups
426(3)
About Database Recovery
429(2)
Configuring Recovery Model
431(1)
Creating Backup Device
431(1)
Backing Up Database
432(3)
Restoring Database
435(2)
Database Replication
437(5)
Creating Distribution Database
438(1)
Configuring Replication Publisher
439(1)
Configuring Replication Subscriber
440(2)
Optimizing Database Performance
442(17)
Transactions and Locks
443(2)
Tools Used in Performance Tuning
445(1)
Using Enterprise Manager
446(2)
Using Profiler
448(2)
Using Query Analyzer
450(6)
Impact of Database Structure on Performance
456(1)
RAID 0
457(1)
RAID 1
457(1)
RAID 5
457(2)
RAID 10
459(1)
Database Maintenance Plan
459(3)
Summary
462(3)
Review Questions
463(1)
Case Study Projects
463(1)
Computer Service
463(1)
University Registration
464(1)
Mail Order
464(1)
Data Analysis Services
465(48)
Objectives
465(1)
Introduction
465(2)
Data Warehouse
467(19)
Data Warehouse Components
468(1)
Data Warehouse Developing Tools
469(1)
Data Warehouse Design
470(1)
Design Goals
470(1)
About Dimensional Modeling
470(1)
Fact Table
471(1)
Dimension Table
472(2)
Data Transformation
474(1)
Data Extraction
474(1)
Data Cleaning
474(1)
Data Loading
475(1)
Data Transformation Services (DTS)
476(10)
OnLine Analytical Processing (OLAP)
486(22)
OLAP Terminology
487(1)
Cube
487(2)
OLAP Architecture
489(2)
Analysis Manager
491(1)
Setting OLAP Data Source
492(1)
Defining Shared Dimensions
492(1)
Creating Cube
493(2)
Data Analysis with Cube
495(1)
Creating Security Role
496(4)
PivotTable Service
500(1)
Building and Manipulating PivotTable in Excel
501(5)
Building and Manipulating PivotTable List for Web Application
506(2)
Summary
508(5)
Review Questions
510(1)
Case Study Projects
511(2)
Data Mining
513(82)
Objectives
513(1)
Introduction
513(2)
Data-Mining Process
515(8)
Data-Mining Process Standards
515(1)
Understanding Business
516(2)
Understanding Data
518(1)
Data Preparation
519(1)
Mining
520(2)
Evaluation
522(1)
Deployment
522(1)
Data-Mining Algorithms
523(12)
Decision Tree Algorithm
524(1)
Constructing Top-Level Node
525(3)
Constructing Second-Level Node
528(3)
Clustering Algorithm
531(4)
Developing Data-Mining Models in SQL Server
535(29)
Preparing Data-Mining Tools in Analysis Services
535(1)
Using Data Transformation Services to Prepare Data for Data Mining
536(3)
Exploring Relationships between Predictable Columns and Input Columns
539(5)
Creating Decision Tree Data-Mining Model Using Single Relational Table
544(3)
Creating Cluster Data-Mining Models
547(1)
Creating Cluster Data-Mining Model Using Single Relational Table
547(2)
Creating Cluster Data-Mining Model Using Multiple Relational Tables
549(4)
Creating Cluster Data-Mining Model Using OLAP
553(2)
Deploying Data-Mining Results with DTS
555(1)
Creating Table for Data-Mining Model and Table for Prediction
556(1)
Training Data-Mining Model
557(1)
Predicting Member Cards with DTS
557(7)
Creating Form to Display Data-Mining Results
564(1)
Summary
564(3)
Review Questions
565(1)
Case Study Projects
566(1)
APPENDICES
Appendix A: Sample Databases
567(18)
Student_Club Database
567(8)
Hillcrest Computing Database
575(10)
Appendix B: Installation of SQL Server
585(6)
SQL Server Installation
585(6)
Appendix C: Suggested Resources
591(4)
Web Sites
591(1)
Books and Articles
592(1)
Professional Books
592(1)
Textbooks
593(1)
Articles
593(2)
Index 595