Muutke küpsiste eelistusi

Database Management Systems-Designing & Building Business Applications 3rd edition [Kõva köide]

3.88/5 (139 hinnangut Goodreads-ist)
  • Formaat: Hardback, 512 pages, kõrgus x laius x paksus: 262x206x23 mm, kaal: 1025 g, Illustrations
  • Ilmumisaeg: 16-Mar-2004
  • Kirjastus: McGraw-Hill Professional
  • ISBN-10: 0072973129
  • ISBN-13: 9780072973129
Teised raamatud teemal:
  • Kõva köide
  • Hind: 149,67 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
Database Management Systems-Designing & Building Business Applications 3rd editionSuurem pilt
  • Formaat: Hardback, 512 pages, kõrgus x laius x paksus: 262x206x23 mm, kaal: 1025 g, Illustrations
  • Ilmumisaeg: 16-Mar-2004
  • Kirjastus: McGraw-Hill Professional
  • ISBN-10: 0072973129
  • ISBN-13: 9780072973129
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780072973129.html
Märksõnad:
Gerald Posts Database Management Systems takes an introductory approach to developing database applications; teaching students to evaluate a business situation and then build and design a database application. From systems design to distribution and integration of the system --and everything in between--, students will gain knowledge by getting a hands-on experience. The Third Edition has been revised to offer a more flexible way to deliver database management applications. Post continues to have a textbook that covers the core theories and ideas of database management. Now, it offers two different workbooks depending on the software that the instructor utilizes. One workbook covers Oracle and the other workbook covers Access; thus enabling the instructor to pick the workbook that will be employed in the course and to go more in-depth with either tool.
Introduction
1(28)
A Developer's View
2(1)
Introduction
2(1)
Databases and Application Development
2(2)
Components of a Database Management System
4(6)
Database Engine
4(1)
Data Dictionary
5(1)
Query Processor
6(1)
Report Writer
6(2)
Forms Generator
8(1)
Application Generator
9(1)
Communication and Integration
9(1)
Security and Other Utilities
10(1)
Advantages of the Database Management System Approach
10(3)
Focus on Data
11(1)
Data Independence
12(1)
Data Independence and Client/Server Systems
13(1)
Leading Commercial Databases
13(1)
Brief History of Database Management Systems
14(6)
Hierarchical Databases
14(1)
Network Databases
14(2)
Relational Databases
16(1)
Object-Oriented Databases
16(4)
Application Development
20(1)
Sally's Pet Store
21(1)
Rolling Thunder Bicycles
22(1)
The Feasibility Study
22(3)
Costs
23(1)
Benefits
24(1)
Summary
25(1)
Key Terms
26(1)
Review Questions
26(1)
Exercises
26(2)
Website References
28(1)
Additional Reading
28(1)
PART ONE SYSTEMS DESIGN
29(114)
Database Design
30(47)
A Developer's View
31(1)
Introduction
31(1)
Getting Started
32(1)
Designing Databases
33(4)
Identifying User Requirements
33(1)
Business Objects
34(1)
Tables and Relationships
35(1)
Definitions
35(1)
Primary Key
36(1)
Class Diagrams
37(10)
Classes and Entities
37(1)
Associations and Relationships
38(1)
Class Diagram Details
39(8)
Sally's Pet Store Class Diagram
47(2)
Data Types (Domains)
49(4)
Text
50(1)
Numbers
50(1)
Dates and Times
51(1)
Binary Objects
52(1)
Computed Values
52(1)
User-Defined Types (Domains/Objects)
53(1)
Events
53(2)
Large Projects
55(1)
Rolling Thunder Bicycles
56(5)
Application Design
61(1)
Summary
62(1)
Key Terms
63(1)
Review Questions
63(1)
Exercises
64(5)
Website References
69(1)
Additional Reading
69(1)
Appendix: Database Design System
70(7)
Sample Problem: Customer Orders
70(1)
Getting Started: Identifying Columns
70(1)
Creating a Table and Adding Columns
71(2)
Relationships: Connecting Tables
73(1)
Grading: Detecting and Solving Problems
73(3)
Specifying Data Types
76(1)
Data Normalization
77(66)
A Developer's View
78(1)
Introduction
78(1)
Tables, Classes, and Keys
79(4)
Composite Keys
79(1)
Surrogate Keys
80(1)
Notation
81(2)
Sample Database for a Video Store
83(6)
Initial Objects
84(1)
Initial Form Evaluation
85(2)
Problems with Repeating Sections
87(2)
First Normal Form
89(2)
Repeating Groups
89(1)
Nested Repeating Groups
90(1)
Second Normal Form
91(3)
Problems with First Normal Form
91(1)
Second Normal Form Definition
92(1)
Dependence
93(1)
Third Normal Form
94(4)
Problems with Second Normal Form
94(1)
Third Normal Form Definition
95(2)
Checking Your Work
97(1)
Beyond Third Normal Form
98(4)
Boyce-Codd Normal Form
98(1)
Fourth Normal Form
99(1)
Domain-Key Normal Form
100(2)
Data Rules and Integrity
102(2)
The Effects of Business Rules
104(2)
Converting a Class Diagram to Normalized Tables
106(6)
One-to-Many Relationships
106(2)
Many-to-Many Relationships
108(1)
N-ary Associations
108(1)
Generalization or Subtypes
108(2)
Composition
110(1)
Reflexive Associations
111(1)
Summary
112(1)
Sally's Pet Store Example
112(3)
View Integration
115(8)
Sally's Pet Store Example
115(2)
Rolling Thunder Sample Integration Problem
117(6)
Data Dictionary
123(6)
DBMS Table Definition
123(4)
Data Volume and Usage
127(2)
Summary
129(1)
Key Terms
130(1)
Review Questions
130(1)
Exercises
131(7)
Website References
138(1)
Additional Reading
138(1)
Appendix: Formal Definitions of Normalization
139(4)
Initial Definitions
139(1)
Normal Form Definitions
140(3)
PART TWO QUERIES
143(78)
Data Queries
144(38)
A Developer's View
145(1)
Introduction
145(1)
Three Tasks of a Query Language
146(1)
Four Questions to Retrieve Data
146(2)
What Output Do You Want to See?
147(1)
What Do You Already Know?
147(1)
What Tables Are Involved?
147(1)
How Are the Tables Joined?
147(1)
Sally's Pet Store
148(1)
Vendor Differences
149(1)
Query Basics
149(10)
Single Tables
149(2)
Introduction to SQL
151(1)
Sorting the Output
151(1)
Distinct
152(1)
Criteria
153(1)
Boolean Algebra
154(1)
DeMorgan's Law
155(3)
Useful Where Clauses
158(1)
Computations
159(4)
Basic Arithmetic Operators
159(1)
Aggregation
159(3)
Functions
162(1)
Subtotals and Group By
163(3)
Conditions on Totals (Having)
164(1)
Where versus Having
165(1)
The Best and the Worst
166(1)
Multiple Tables
166(8)
Joining Tables
167(1)
Identifying Columns in Different Tables
168(1)
Joining Many Tables
169(1)
Hints on Joining Tables
170(2)
Table Alias
172(1)
Create View
172(2)
Summary
174(1)
Key Terms
175(1)
Review Questions
175(1)
Exercises
175(3)
Website References
178(1)
Additional Reading
178(1)
Appendix: SQL Syntax
179(3)
Alter Table
179(1)
Commit Work
179(1)
Create Index
179(1)
Create Table
179(1)
Create Trigger
179(1)
Create View
180(1)
Delete
180(1)
Drop
180(1)
Insert
180(1)
Grant
180(1)
Revoke
180(1)
Rollback
181(1)
Select
181(1)
Select Into
181(1)
Update
181(1)
Advanced Queries and Subqueries
182(39)
A Developer's View
183(1)
Introduction
183(1)
Sally's Pet Store
184(1)
Subqueries
184(3)
Calculations or Simple Lookup
184(1)
Subqueries and Sets of Data
185(1)
Subquery with Any and All
185(2)
Subtraction: Not In
187(1)
Outer Joins
188(2)
Correlated Subqueries Are Dangerous
190(3)
More Features and Tricks with SQL Select
193(6)
Union, Intersect, Except
193(1)
Multiple Join Columns
194(1)
Reflexive Join
195(1)
Case Function
196(1)
Inequality Joins
197(1)
Questions with ``Every'' Need the Exists Clause
197(2)
SQL Select Summary
199(1)
SQL Data Definition Commands
199(2)
SQL Data Manipulation Commands
201(2)
Insert and Delete
201(1)
Update
202(1)
Quality: Testing Queries
203(2)
Summary
205(1)
Key Terms
206(1)
Review Questions
206(1)
Exercises
206(4)
Website References
210(1)
Additional Reading
210(1)
Appendix: Introduction to Programming
211(10)
Variables and Data
211(1)
Variable Scope
212(1)
Computations
213(1)
Standard Internal Functions
214(1)
Input and Output
215(1)
Conditions
216(1)
Loops
217(1)
Subroutines
218(2)
Summary
220(1)
PART THREE APPLICATIONS
221(108)
Forms, Reports, and Applications
222(43)
A Developer's View
223(1)
Introduction
223(1)
Effective Design of Reports and Forms
224(6)
Human Factors Design
224(2)
Window Controls
226(2)
User Interface---Web Notes
228(1)
User Interface---Accessibility Issues
229(1)
Form Layout
230(5)
Tabular Forms
230(1)
Single-Row or Columnar-Forms
231(1)
Subform Forms
232(1)
Switchboard Forms
233(2)
Creating Forms
235(10)
Updateable Queries
235(1)
Linked Forms
236(1)
Properties and Controls
236(1)
Controls on Forms
237(4)
Multiple Forms
241(2)
International Attributes
243(2)
Direct Manipulation of Graphical Objects
245(2)
Sally's Pet Store Example
245(1)
The Internet
246(1)
Complications and Limitations of a Graphical Approach
247(1)
Reports
247(8)
Report Design
248(1)
Terminology
248(2)
Basic Report Types
250(4)
Graphs
254(1)
Application Features
255(6)
Menus and Toolbars
255(2)
Custom Help
257(4)
Summary
261(1)
Key Terms
262(1)
Review Questions
262(1)
Exercises
262(2)
Website References
264(1)
Additional Reading
264(1)
Database Integrity and Transactions
265(33)
A Developer's View
266(1)
Introduction
266(1)
Procedural Languages
266(3)
Where Should Code Be Located?
267(1)
User-Defined Functions
268(1)
Looking Up Data
269(1)
Data Triggers
269(5)
Statement versus Row Triggers
270(1)
Canceling Data Changes in Triggers
271(1)
Cascading Triggers
272(1)
Instead of Triggers
273(1)
Transactions
274(2)
A Transaction Example
274(1)
Starting and Ending Transactions
274(2)
Savepoint
276(1)
Multiple Users and Concurrent Access
276(5)
Pessimistic Locks: Serialization
277(1)
Multiuser Databases: Concurrent Access and Deadlock
278(2)
Optimistic Locks
280(1)
ACID Transactions
281(2)
Key Generation
283(2)
Database Cursors
285(4)
Cursor Basics
285(1)
Scrollable Cursors
286(1)
Changing or Deleting Data with Cursors
287(1)
Cursors with Parameters
288(1)
Merchandise Inventory at Sally's Pet Store
289(4)
Summary
293(1)
Key Terms
294(1)
Review Questions
294(1)
Exercises
294(2)
Website References
296(1)
Additional Reading
297(1)
Data Warehouses and Data Mining
298(31)
A Developer's View
299(1)
Introduction
299(1)
Indexes
300(3)
Binary Search
300(1)
Pointers and Indexes
301(1)
Bitmap Index and Statistics
301(1)
Problems with Indexes
302(1)
Data Warehouses and Online Analytical Processing
303(3)
Data Warehouse Goals
303(2)
Data Warehouse Issues
305(1)
Olap Concepts
306(2)
Olap Database Design
308(10)
Olap Data Analysis
310(2)
Olap in SQL
312(4)
SQL Analytic Functions
316(1)
SQL Olap Windows
316(2)
Data Mining
318(7)
Classification
320(1)
Association Rules/Market Basket Analysis
321(2)
Cluster Analysis
323(1)
Geographic Analysis
324(1)
Summary
325(1)
Key Terms
326(1)
Review Questions
326(1)
Exercises
326(1)
Website References
327(1)
Additional Reading
328(1)
PART FOUR DATABASE ADMINISTRATION
329(66)
Database Administration
330(30)
A Developer's View
331(1)
Introduction
331(1)
Data Administrator
332(1)
Database Administrator
333(1)
Database Structure
334(1)
Metadata
335(1)
Database Tasks by Development Stages
336(3)
Database Planning
336(1)
Database Design
337(1)
Database Implementation
338(1)
Database Operation and Maintenance
338(1)
Backup and Recovery
339(2)
Security and Privacy
341(10)
Data Privacy
341(1)
Threats
342(1)
Physical Security
342(2)
Managerial Controls
344(1)
Logical Security
344(5)
Division of Duties
349(1)
Software Updates
350(1)
Encryption
351(2)
Sally's Pet Store
353(2)
Summary
355(1)
Key Terms
356(1)
Review Questions
356(1)
Exercises
357(2)
Website References
359(1)
Additional Reading
359(1)
Distributed Databases and the Internet
360(35)
A Developer's View
361(1)
Introduction
361(1)
Sally's Pet Store
361(1)
Distributed Databases
362(11)
Goals and Rules
363(1)
Advantages and Applications
364(2)
Creating a Distributed Database System
366(1)
Distributed Query Processing
367(2)
Data Replication
369(1)
Concurrency, Locks, and Transactions
370(2)
Independent Transaction Managers
372(1)
Distributed Design Questions
372(1)
Client/Server Databases
373(7)
Client/Server versus File Server
374(1)
Three-Tier Client/Server Model
375(2)
The Back End: Server Databases
377(1)
The Front End: Windows Clients
377(1)
Maintaining Database Independence in the Client
378(2)
Electronic Commerce Databases
380(1)
The Web as a Client/Server System
381(4)
HTML-Limited Clients
381(2)
Web Server Database Fundamentals
383(2)
Data Transmission Issues in Applications
385(2)
XML: Transferring Data to Diverse Systems
387(4)
Java and JDBC
391(1)
Summary
392(1)
Key Terms
393(1)
Review Questions
393(1)
Exercises
394(1)
Website References
395(1)
Additional Reading
396


Gerald Post teaches at the University of the Pacific.