Muutke küpsiste eelistusi

E-raamat: Business Database Systems

3.50/5 (17 hinnangut Goodreads-ist)
, ,
  • Formaat: PDF+DRM
  • Ilmumisaeg: 02-Feb-2010
  • Kirjastus: Addison Wesley
  • Keel: eng
  • ISBN-13: 9781405874502
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 57,19 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Business Database SystemsSuurem pilt
  • Formaat: PDF+DRM
  • Ilmumisaeg: 02-Feb-2010
  • Kirjastus: Addison Wesley
  • Keel: eng
  • ISBN-13: 9781405874502
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Business Database Systems arms you with the knowledge to analyse, design and implement effective, robust and successful databases. This book is ideal for students of Business/Management Information Systems, or Computer Science, who will be expected to take a course in database systems for their degree programme. It is also excellently suited to any practitioner who needs to learn, or refresh their knowledge of, the essentials of database management systems.

Guided Tour xvi
Preface xviii
Part I Background
1(98)
Introduction
3(29)
Preview
3(1)
Learning objectives
3(1)
Examples of the use of database systems
4(2)
Database approach
6(8)
Database design
14(2)
Historical perspective of database system development
16(4)
Three-level ANSI-SPARC architecture
20(5)
Functions of a DBMS
25(3)
Advantages and disadvantages of the database approach
28(4)
Chapter summary
29(1)
Review questions
30(1)
Exercises
31(1)
The relational model
32(14)
Preview
32(1)
Learning objectives
32(1)
Brief history of the relational model
33(1)
What is a data model?
34(1)
Terminology
34(5)
Relational integrity
39(4)
Relational languages
43(3)
Chapter summary
44(1)
Review questions
45(1)
Exercises
45(1)
SQL and QBE
46(37)
Preview
46(1)
Learning objectives
46(1)
Structured Query Language (SQL)
46(3)
Data manipulation
49(21)
Query-By-Example (QBE)
70(13)
Chapter summary
77(1)
Review questions
78(1)
Exercises
79(4)
The database system development lifecycle
83(16)
Preview
83(1)
Learning objectives
83(1)
The software crisis
83(1)
The information systems lifecycle
84(1)
The database system development lifecycle
85(1)
Database planning
85(2)
System definition
87(1)
Requirements collection and analysis
88(3)
Database design
91(1)
DBMS selection
91(1)
Application design
92(2)
Prototyping
94(1)
Implementation
94(1)
Data conversion and loading
95(1)
Testing
95(1)
Operational maintenance
96(3)
Chapter summary
96(1)
Review questions
97(2)
Part II Database analysis and design techniques
99(80)
Fact-finding
101(30)
Preview
101(1)
Learning objectives
101(1)
When are fact-finding techniques used?
102(1)
What facts are collected?
102(1)
Fact-finding techniques
103(5)
The StayHome Online Rentals case study
108(23)
Chapter summary
129(1)
Review questions
130(1)
Exercise
130(1)
Entity-relationship modeling
131(21)
Preview
131(1)
Learning objectives
132(1)
Entities
132(1)
Relationships
133(2)
Attributes
135(3)
Strong and weak entities
138(1)
Multiplicity constraints on relationships
138(7)
Attributes on relationships
145(1)
Design problems with ER models
146(6)
Chapter summary
149(1)
Review questions
150(1)
Exercises
151(1)
Enhanced ER modeling
152(10)
Preview
152(1)
Learning objectives
152(1)
Specialization/generalization
153(9)
Chapter summary
159(1)
Review questions
159(1)
Exercises
160(2)
Normalization
162(17)
Preview
162(1)
Learning objectives
162(1)
Introduction
163(1)
Data redundancy and update anomalies
163(3)
First normal form (1NF)
166(1)
Second normal form (2NF)
167(2)
Third normal form (3NF)
169(10)
Chapter summary
174(1)
Review questions
174(1)
Exercises
175(4)
Part III Database design methodology
179(90)
Conceptual database design
181(27)
Preview
181(1)
Learning objectives
181(1)
Introduction to the database design methodology
181(2)
Overview of the database design methodology
183(1)
Step 1: Conceptual database design methodology
184(24)
Chapter summary
204(1)
Review questions
204(1)
Exercises
205(3)
Logical database design
208(28)
Preview
208(1)
Learning objectives
208(1)
Step 2: Map ER model to tables
208(28)
Chapter summary
231(1)
Review questions
231(1)
Exercises
231(5)
Physical database design
236(33)
Preview
236(1)
Learning objectives
236(1)
Comparison of logical and physical database design
237(1)
Overview of the physical database design methodology
237(1)
Step 3: Translate the logical database design for the target DBMS
238(10)
Step 4: Choose file organizations and indexes
248(4)
Step 5: Design user views
252(2)
Step 6: Design security mechanisms
254(4)
Step 7: Consider the introduction of controlled redundancy
258(2)
Step 8: Monitor and tune the operational system
260(9)
Chapter summary
265(1)
Review questions
266(1)
Exercises
266(3)
Part IV Current and emerging trends
269(192)
Database administration and security
271(18)
Preview
271(1)
Learning objectives
271(1)
Data administration and database administration
271(3)
Database security
274(15)
Chapter summary
286(1)
Review questions
287(1)
Exercises
288(1)
Professional, legal, and ethical issues in data management
289(20)
Preview
289(1)
Learning objectives
289(1)
Defining legal and ethical issues in information technology
290(2)
Legislation and its impact on the IT function
292(6)
Establishing a culture of legal and ethical data stewardship
298(5)
Intellectual property
303(6)
Chapter summary
307(1)
Review questions
307(1)
Exercises
308(1)
Transaction management
309(23)
Preview
309(1)
Learning objectives
309(1)
Transaction support
310(2)
Concurrency control
312(10)
Database recovery
322(10)
Chapter summary
329(1)
Review questions
330(1)
Exercises
330(2)
eCommerce and database systems
332(38)
Preview
332(1)
Learning objectives
332(1)
eCommerce
333(8)
Web-database integration
341(2)
Web-database integration technologies
343(7)
eXtensible Markup Language (XML)
350(9)
XML-related technologies
359(1)
XML query languages
360(3)
Database integration in eCommerce systems
363(7)
Chapter summary
368(1)
Review questions
369(1)
Exercises
369(1)
Distributed and mobile DBMSs
370(41)
Preview
370(1)
Learning objectives
371(1)
DDBMS concepts
371(7)
Distributed relational database design
378(10)
Transparencies in a DDBMS
388(9)
Date's 12 rules for a DDBMS
397(2)
Replication servers
399(4)
Mobile databases
403(8)
Chapter summary
405(2)
Review questions
407(1)
Exercises
407(4)
Object DBMSs
411(32)
Preview
411(1)
Learning objectives
412(1)
Advanced database applications
412(3)
Weaknesses of relational DBMSs (RDBMSs)
415(2)
Storing objects in a relational database
417(2)
Object-oriented DBMSs (OODBMSs)
419(10)
Object-relational DBMSs (ORDBMSs)
429(14)
Chapter summary
439(2)
Review questions
441(1)
Exercises
441(2)
Business intelligence
443(18)
Preview
443(1)
Learning objectives
443(1)
Business intelligence (Bl)
444(1)
Data warehousing
444(6)
Online analytical processing (OLAP)
450(4)
Data mining
454(7)
Chapter summary
459(1)
Review questions
460(1)
Exercises
460(1)
Appendix A The Buyer user view for StayHome Online Rentals
461(2)
Appendix B Second case study - PerfectPets
463(5)
Appendix C Alternative data modeling notations
468(7)
Appendix D Summary of the database design methodology
475(7)
Appendix E Advanced SQL
482(14)
Appendix F Guidelines for choosing indexes
496(9)
Appendix G Guidelines for denormalization
505(8)
Appendix H Object-oriented concepts
513(8)
Appendix I Common data models
521(15)
Glossary 536(20)
References 556(2)
Index 558
The authors

Prof. Thomas Connolly is Chair of the ITCE in Education Research Group at the University of the West of Scotland, and Director of the Scottish Centre for Enabling Technologies. He is a winner of the British Design Award for his work on database systems.

Dr. Carolyn Begg is a lecturer in the School of Computing at the University of the West of Scotland where she teaches Business Database Systems, Advanced Business Systems, and Business Intelligence. Prof. Connolly and Dr. Begg are authors of the best-selling Database Systems which has sold over ¼ million copies worldwide.

Dr. Richard Holowczak is Associate Professor of Computer Information Systems at Zicklin School of Business, City University of New York where he has taught courses on databases, business intelligence, security and financial information technologies since 1997. Dr. Holowczak is also director of the Wasserman Trading Floor / Subotnick Financial Services Centre.

 
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97814058745022e.html
Märksõnad: