Readings and Resources Information Processing

orcmid> readings> infoware> 2008-08-28 -17:24 -0700

see also:

Readings in Software Tools

Readings in Computer Science
Readings in Computing Milieu

[Baklarz2003]

Baklarz, George., Wong, Bill.  DB2 Universal Database v8.1 for Linux, UNIX, and Windows Database Administration Certification Guide.  ed. 5.  Foreword by Janet Perna.  Prentice Hall Professional Technical Reference (Upper Saddle River, NJ: 2003).  ISBN 0-13-046361-2 pbk + CD-ROM.
     I have begun to notice that some of the most authoritative sources on specific technologies are books designed for certification preparation.  I have found this true for mastering aspects of my operating system, studying Java, and now using DB2 as part of a course project.  This volume, although providing coverage appropriate for certification, is also an excellent, well-organized guide. 
     One missing provision of this document and of related materials is any attempt to reconcile the DBMS against the SQL:1992 and SQL:1999 specifications.  I find that a seriously missed opportunity for the promotion of interoperable SQL solutions.  --dh:2003-11-16
     "This Certification Guide is an excellent way to learn about DB2, to develop new skills, and to provide new opportunities for yourself in the computer industry.  This book includes a trial copy of DB2 and a demo that will give you an opportunity to develop skills using hands-on experience."  From the Foreword, pp.xvii-xviii.

   Content
     Foreword
     Preface
     Part One Introduction to DB2 UDB
          1. Product Overview
          2. Getting Started
          3. Getting Connected
          4. Controlling Data Access
     Part Two Using SQL
          5. Database Objects
          6. Manipulating Database Objects
          7. Advanced SQL
          8. Concurrency
     Part Three DB2 UDB Administration
          9. Data Storage Management
          10. Maintaining Data
          11. Database Recovery
          12. Monitoring and Tuning
     Part Four Developing Applications
          13. Application Development Overview
          14. Development Considerations
          15. Development SQL
     Part Five Appendices
          A. DB2 UDB V8.1 Certification Test Objectives
          B. CD-ROM Installation
     Index
          

[Bray2000]   

Bray, Tim., Paoli, Jean., Sperberg-McQueen, C.M., Maler, Eve (eds.).  Extensible Markup Language (XML) 1.0 (Second Edition).  W3C Recommendation.  2000 October 6.  See [XML2000]
   

[Coronel2002]

Rob, Peter., Coronel, Carlos.  Database Systems: Design, Implementation, and Management, ed.5.  Course Technology (Boston: 2002).  ISBN 0-619-06269-X.  See [Rob2002].
   

[Darwen2003]

Date, C. J., Darwen, Hugh., Lorentzos, Nikos A.  Temporal Data and the Relational Model: A Detailed Investigation into the Application of Interval and Relational Theory to the Problem of Temporal Database Management.  Morgan Kaufmann (San Francisco: 2003).  ISBN 1-55860-855-9 pbk.  See [Date2003]
   

[Date1992]

Date, C.J., Fagin, Ronald.  Simple Conditions for Guaranteeing Higher Normal Forms in Relational Databases.  ACM Trans. Database Systems 17, 3 (September 1992), 456-476.
   

[Date2003]

Date, C. J., Darwen, Hugh., Lorentzos, Nikos A.  Temporal Data and the Relational Model: A Detailed Investigation into the Application of Interval and Relational Theory to the Problem of Temporal Database Management.  Morgan Kaufmann (San Francisco: 2003).  ISBN 1-55860-855-9 pbk.
   Content
     Preface
     Part I: Preliminaries
          1. A Review of Relational Concepts
          2. An Overview of Tutorial D
     Part II: Laying the Foundations
          3. Time and the Database
          4. What is the Problem?
          5. Intervals
          6. Operators on Intervals
          7. The EXPAND and COLLAPSE Operators
          8. The PACK and UNPACK Operators
          9. Generalizing the Relational Operators
     Part III: Building on the Foundations
          10. Database Design
          11. Integrity Constraints I: Candidate Keys and Related Constraints
          12. Integrity Constraints II: General Constraints
          13. Database Queries
          14. Database Updates
          15. Stated Times and Logged Times
          16. Point and Interval Types Revisited
     Appendixes
          A. Implementation Considerations
          B. Generalizing the EXPAND and COLLAPSE Operators
          C. References and Bibliography
     Index
     About the Authors
   

[Englebart2003]

Park, Jack (ed.)., Hunting, Sam (tech.ed.).  XML Topic Maps: Creating and Using Topic Maps for the Web.  Foreword by Douglas C. Englebart.  Addison-Wesley (Boston, MA: 2003).  ISBN 0-201-74960-2 pbk.  See [Park2003]
   

[Fagan1992]

Date, C.J., Fagin, Ronald.  Simple Conditions for Guaranteeing Higher Normal Forms in Relational Databases.  ACM Trans. Database Systems 17, 3 (September 1992), 456-476.  See [Date1992]
   

[Gulutzan1999]

Gulutzan, Peter., Pelzer, Trudy.  SQL-99 Complete, Really: An Example-Based Reference Manual of the New Standard.  R&D Books Miller Freeman (Lawrence KS: 1999).   ISBN 0-87930-568-1 pbk + CD-ROM.
     [dh:2003-11-02] The latest information on Ocelot, the SQL:1999 DBMS offered with the book, is now at <http://sourceforge.net/projects/ocelot>.  The authors information on the book and other material are at their site, <http://www.ocelot.ca>.
     I thought this would be a smooth way to become acquainted with SQL as an interoperable standard.  Now I can't be sure.  As I work through class materials on relational database systems and SQL, I find that I can't trust this book to be authoritative after all.  I am beginning to suspect that there is no resource that is authoritative on SQL:1992 and SQL:1999, and that the confusion of implementations with the specified standards is continuing to be muddled up.  A large part of the difficulty may be that the same SQL processor is used in implementations to accomplish implementation-specific administrative operations, tuning operations, and also offer a given vendor's improvements and enhancements.  There seems to be no practice of accounting for specific compliance and identifying omissions and extensions in a careful way.  The present book does not take the opportunity to acquaint us with the "leveling" method introduced in SQL:1999 and how it fits against features preserved (and not) from SQL:1992.  I still look to this book for examples, but it seems "off" enough times that I have come to be distrustful.  [dh:2003-11-16]

   Content
     Preface
     1. Introduction
     2. General Concepts
     3. Numbers
     4. Bit Strings
     5. Binary Strings
     6. Characters
     7. Character Strings
     8. Temporal Values
     9. Boolean Values
     10. Collection Types
     11. Row Types
     12. Reference Types
     13. NULLs
     14. SQL Clusters
     15. AuthorizationIDs
     16. SQL Catalogs
     17. SQL Schemas
     18. SQL Tables and Views
     19. SQL Domains
     20. SQL Constraints and Assertions
     21. SQL Character Sets
     22. SQL Collations
     23. SQL Translations
     24. SQL Triggers
     25. SQL-Invoked Routines
     26. PSM; Not Just Persistent Stored Modules
     27. User-Defined Types
     28. Introduction to SQL-Data Operations
     29. Simple Search Conditions
     30. Searching with Joins
     31. Searching with Subqueries
     32. Searching with Set Operators
     33. Searching with Groups
     34. Sorting Search Results
     35. Changing SQL-Data
     36. SQL Transactions
     37. SQL Transaction Concurrency
     38. SQL Sessions
     39. Embedded SQL Binding Style
     40. SQL/CLI Binding Style
     41. SQL/CLI: env Functions
     42. SQL/CLI: dbc Functions
     43. SQL/CLI: stmt Functions
     44. SQL/CLI Statement Functions
     45. SQL/CLI: Cursor Functions
     46. SQL/CLI: desc Functions
     47. SQL/CLI: Diagnostic Functions
     48. SQL/CLI: General Functions
     49. SQL/CLI: Deferred Parameter Functions
     50. SQL/CLI: Locator Functions
     51. SQL/CLI: Catalog Functions
     52. Module Binding Style
     53. Style
     Index
     Appendices on the CD-ROM
          A. Remote Database Access
          B. SQL Taxonomy
          C. Non-portable SQL Features
          D. Incompatibilities with SQL-92
          E. SQL Web Sites
          F. Glossary
          G. Errata
   

[Hunting2003]

Park, Jack (ed.)., Hunting, Sam (tech.ed.).  XML Topic Maps: Creating and Using Topic Maps for the Web.  Foreword by Douglas C. Englebart.  Addison-Wesley (Boston, MA: 2003).  ISBN 0-201-74960-2 pbk.  See [Park2003]
   

[Lorentzos2003]

Date, C. J., Darwen, Hugh., Lorentzos, Nikos A.  Temporal Data and the Relational Model: A Detailed Investigation into the Application of Interval and Relational Theory to the Problem of Temporal Database Management.  Morgan Kaufmann (San Francisco: 2003).  ISBN 1-55860-855-9 pbk.  See [Date2003]
   

[Maler2000]

Bray, Tim., Paoli, Jean., Sperberg-McQueen, C.M., Maler, Eve (eds.).  Extensible Markup Language (XML) 1.0 (Second Edition).  W3C Recommendation.  2000 October 6.  See [XML2000]
   

[Park2003]

Park, Jack (ed.)., Hunting, Sam (tech.ed.).  XML Topic Maps: Creating and Using Topic Maps for the Web.  Foreword by Douglas C. Englebart.  Addison-Wesley (Boston, MA: 2003).  ISBN 0-201-74960-2 pbk.
   Content
     Foreword [Douglas C. Englebart]
     Preface
     Acknowledgments
     Contributors
     1. Let There Be Light [Jack Park]
     2. Introduction to the Topic Maps Paradigm [Michel Biezunski]
     3. A Perspective on the Quest for Global Knowledge Interchange [Steven R. Newcomb]
     4. The Rise and Rise of Topic Maps [Sam Hunting]
     5. Topic Maps from Representation to Identity: Conversion, Names, and Published Subject Indicators [Bernard Vatant]
     6. How to Start Topic Mapping Right Away with the XTM Specification [Sam Hunting]
     7. Knowledge Representation, Ontological Engineering, and Topic Maps [Leo Obrst and Howard Liu]
     8. Topic Maps in the Life Sciences [John Park and Nefer Park]
     9. Creating and Maintaining Enterprise Web Sites with Topic Maps and XSLT [Nikita Ogievetsky]
     10. Open Source Topic Map Software
          SemanText [Eric Freese]
          XTM Programming with TM4J [Karl Ahmed]
          Nexist Topic Map Testbed [Jack Park]
          GooseWorks Toolkit [Sam Hunting]
     11. Topic Map Visualization [Bénédicte Le Grand]
     12. Topic Maps and RDF [Eric Freese]
     13. Topic Maps and Semantic Networks [Eric Freese]
     14. Topic Map Fundamentals for Knowledge Representation [H. Holger Rath]
     15. Topic Maps in Knowledge Organization [Alexander Sigel]
     16. Prediction: A Profound Paradign Shift [Kathleen M. Fisher]
     17. Topic Maps, The Semantic Web, and Education [Jack Park]
     Glossary
     Appendix A: Tomatoes Topic Map
     Appendix B: Topic Map for Chapter 9
     Appendix C: XSLT Style Sheet for Chapter 9
     Appendix D: Genealogical Topic Map
     Index
   

[Paoli2000]

Bray, Tim., Paoli, Jean., Sperberg-McQueen, C.M., Maler, Eve (eds.).  Extensible Markup Language (XML) 1.0 (Second Edition).  W3C Recommendation.  2000 October 6.  See [XML2000]
   

[Pelzer1999]

Gulutzan, Peter., Pelzer, Trudy.  SQL-99 Complete, Really: An Example-Based Reference Manual of the New Standard.  R&D Books Miller Freeman (Lawrence KS: 1999).   ISBN 0-87930-568-1 pbk + CD-ROM.  See [Gulutzan1999]
   

[Rob2002]

Rob, Peter., Coronel, Carlos.  Database Systems: Design, Implementation, and Management, ed.5.  Course Technology (Boston: 2002).  ISBN 0-619-06269-X.
   Content
     Preface
     Part I: Database Concepts
          1. File Systems and Databases
          2. The Relational Database Model
     Part II: Design Concepts and Implementation
          3. Entity Relationship (E-R) Modeling
          4. Normalization of Database Tables
          5. Structured Query Language (SQL)
     Part III: Advanced Design & Implementation
          6. Database Design
          7. The University Lab: Conceptual Design
          8. The University Lab: Conceptual Design Verification, Logical Design, and Implementation
     Part IV: Advanced Database Concepts
          9. Transaction Management and Concurrency Control
          10. Distributed Database Management Systems
     Part V: New Developments
          11. Object-Oriented Databases
          12. Client/Server Systems
          13. The Data Warehouse
          14. Databases in Electronic Commerce
          15. Web Database Development
     Part VI: Database Administration
          16. Database Administration
     Appendix: Client/Server Network Infrastructure
     Glossary
     Index
   

[Sperberg-McQueen2000]

Bray, Tim., Paoli, Jean., Sperberg-McQueen, C.M., Maler, Eve (eds.).  Extensible Markup Language (XML) 1.0 (Second Edition).  W3C Recommendation.  2000 October 6.  See [XML2000]
      

[Unicode2003]

Aliprand, Joan., Allen, Julie., Becker, Joe., Davis, Mark., Everson, Michael., Freytag, Asmus., Jenkins, John., Ksar, Mike., McGowan, Rick., Muller, Eric., Moore, Lisa., Suignard, Michel., Whistler, Ken.(eds.).  The Unicode Standard, Version 4.0: The Unicode Consortium.  Addison-Wesley (Boston, MA: 1991-2003).  ISBN 0-321-18578-1 with CD-ROM.
   Content
     Acknowledgments
     Unicode Consortion Members and Directors
     Figures
     Tables
     Preface
     1. Introduction
     2. General Structure
     3. Conformance
     4. Character Properties
     5. Implementation Guidelines
     6. Writing Systems and Punctuation
     7. European Alphabetic Scripts
     8. Middle Eastern Scripts
     9. South Asian Scripts
     10. Southeast Asian Scripts
     11. East Asian Scripts
     12. Additional Modern Scripts
     13. Archaic Scripts
     14. Symbols
     15. Special Areas and Format Characters
     16. Code Charts
     17. Han Radical-Stroke Index
     Appendices
     A. Han Unification History
     B. Abstracts of Unicode Technical Reports
     C. Relationship to ISO/IEC 10646
     D. Changes from Unicode Version 3.0
     G. Glossary
     R. References
     I. Indices
   

[Wong2003]

Baklarz, George., Wong, Bill.  DB2 Universal Database v8.1 for Linux, UNIX, and Windows Database Administration Certification Guide.  ed. 5.  Prentice Hall Professional Technical Reference (Upper Saddle River, NJ: 2003).  ISBN 0-13-046361-2 pbk + CD-ROM.  See [Baklarz2003]

 

[XML2000]  

Bray, Tim., Paoli, Jean., Sperberg-McQueen, C.M., Maler, Eve (eds.).  Extensible Markup Language (XML) 1.0 (Second Edition).  W3C Recommendation.  2000 October 6.  Current edition published on the web at http://www.w3.org/TR/REC-xml.

You are navigating Orcmid's Lair

created 2003-09-10-14:24 -0700 (pdt) by orcmid $$Author: Orcmid $ $$Date: 08-08-28 17:26 $ $$Revision: 28 $