Database Management Systems Textbook

Jerry Post

Return to Database Book index

Links to Sites Related to Cases and Applications

Site

Description

Chapter 1: Introduction General References
http://www.microsoft.com/office/access/ Microsoft Access
http://www.microsoft.com/sql/ Microsoft SQL Server
http://www.oracle.com Oracle
http://www.oracle.com/technetwork Oracle technology network
http://www.ingres.com Ingres
http://www.sybase.com Sybase
http://www.software.ibm.com/data/db2/ IBM DB2
http://www.mysql.com Free DBMS now controlled by Oracle
http://www.PostgreSQL.org A better free DBMS
http://www.acm.org Association for Computing Machinery
http://groups.google.com/groups/dir?sel=usenet%3Dcomp.databases Questions and sometimes answers on many topics and subtopics
http://dbforums.com Discussion group
http://dbasupport.com Discussion group
http://www.devx.com/dbzone/Door/7022 Discussion group
http://www.sqlservercentral.com News group on SQL Server
http://www.cms.hsss.gov/IDC10 U.S. government Web site (HHS) with ICD-10 codes.
http://webopedia.internet.com Dictionary of computer terms
Chapter 2: Database Design Design Documentation
http://www.rational.com/uml/ The primary site for UML documentation and examples.
http://www.iconixsw.com/umlzone.html UML documentation and comments.
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#i54330 Oracle data type descriptions
http://msdn2.microsoft.com/en-us/library/ms187752(SQL.90).aspx SQL Server data type descriptions
http://jerrypost.com/dbdesign Database design system
Chapter 3: Data Normalization Information on Database Design
http://www.for.gov.bc.ca/isb/datadmin/ Database Programming & Design magazine.
http://support.microsoft.com/support/kb/articles/q209/5/34.asp Introducton to normalization.
http://www.phpbuilder.com/columns/barry20000731.php3 Normalization examples.
Chapter 4: Data Queries Basic SQL References
http://www.iso.org/iso/en/stdsdevelopment/tc/tclist/TechnicalCommitteeDetailPage.TechnicalCommitteeDetail?COMMID=160 ISO SQL committee.
http://www.jtc1sc32.org Standards documents
http://www.wiscorp.com/SQLStandards.html Free versiosn of draft standards.
http://www.dbazine.com Magazine and blogs on SQL.
http://www.sqlmag.com Magazine with SQL emphasis.
http://www.sqlteam.com SQL hints and comments.
http://www.sqlcourse.com Online SQL notes.
http://www.w3.org/TR/xquery XQuery reference.
http://oracle.com/technology/pub/articles/jain-xmldb.html Oracle XML documentation.
http://www.aivosto.com/vbtips/regex.html One regex tutorial.
http://msdn.microsoft.com/en-us-magazine/cc163473.aspx Microsoft article with the CLR regex function.
http://msdn.microsoft.com/library/default.asp? URL=/library/psdk/sql/portal_7ap1.htm Microsoft SQL Server notes.
http://www.sqlcourse.com Introductory SQL help.
Chapter 5: Advanced Queries and Subqueries Detailed discussions of SQL
http://www.acm.org/sigmod/ Association for Computing Machinery—Special Interest Group: Management of Data.
http://www.acm.org/dl ACM digital library with thousands of searchable full-text articles.
http://www.oracle.com/technology/documentation/database.html Oracle online documentation library, including SQL Reference.
http://msdn.microsoft.com/en-us/library/ms130214.aspx Microsoft SQL Server Books Online reference.
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp IBM DB2 reference.
dev.mysql.com/doc MySQL reference.
Chapter 6: Forms, Reports and Applications Design Guidelines
http://www.microsoft.com/enable Accessibility guidelines.
http://www.unicode.org Primary site for Unicode information...
http://www.acm.org/sigchi/ Association for Computing Machinery—Special Interest Group: Computer and Human Interaction.
http://www.acm.org/sigcaph/ Association for Computing Machinery—Special Interest Group: Computers and the Physically Handicapped.
Chapter 7: Database Integrity and Transactions Programming Guidelines
http://www.acm.org/sigplan/ Association for Computing Machinery—Special Interest Group on Programming Languages (advanced).
http://support.microsoft.com/support/kb/articles/q115/9/86.asp Avoiding common database programming mistakes.
Chapter 8: Applications Design Background
http://www.microsoft.com/enable Microsoft site for accessibility issues.
http://msdn.microsoft.com/windowsvista/uxguide Microsoft design guide for Windows.
http://www.pinpub.com/oracle/tips Oracle application tips.
http://www.useit.com Web site run by Jakob Nielson (a researcher in usability).
http://helpware.net/mshelp3/intro.htm Introduction and small examples of Microsoft Help 3.
Chapter 9: Data Warehouses and Data Mining Application Guidelines
http://www.oracle.com/technology/products/bi/olap/index.html Oracle OLAP process
http://msdn.microsoft.com/en-us/library/ms173767.aspx Microsoft Business Intelligence Studio.
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp IBM Cognos OLAP tools
http://www.wintercorp.com/rwintercolumns/SQL_99snewolapfunctions.html SQL 99 OLAP standards
Chapter 10: Database Administration Planning, Performance, and Security
http://www.dama.org Data Management organization.
http://www.aitp.org Association for Information Technology Professionals organization.
http://www.acm.org/sigsac Association for Computing Machinery: Special Interest Group on Security, Audit, and Control.
http://www.cert.org Internet organization tracking security topics.
http://www.dbazine.com/ Web site for general discussion of DBA issues, covering multiple DBMSs.
http://www.databasejournal.com Database security and other database management topics.
Chapter 11: Distributed Databases and The Internet Basic Web Construction Help
http://www.w3.org/ Web standards body.
http://msdn.microsoft.com Search for Microsoft's .NET framework and documentation.
http://java.sun.com/products/jdbc Java and JDBC documentation and references.
Chapter 12: Physical Database Design Performance and Management
http://www.sql-server-performance.com Hints on improving performance for SQL Server.
http://www.oracle.com/technology/deploy/performance/index.html Oracle performance tuning.
http://www.bluerwhite.org/btree General B-tree information and coding.