Database Management Systems Textbook

Jerry Post

Links to Sites Related to Cases and Applications

Site

Description

Chapter 1: Introduction

General References

http://www.microsoft.com/access/

Microsoft Access

http://www.microsoft.com/sql/

Microsoft SQL Server

http://www.oracle.com

Oracle

http://www.cai.com/products/ingres.htm

Ingres

http://www.sybase.com

Sybase

http://www.software.ibm.com/data/db2/

IBM DB2

http://www.acm.org

Association for Computing Machinery

news://comp.databases

Questions and sometimes answers on many topics and subtopics

http://www.amazon.com

A very large bookstore

Chapter 2: Database Design

Design Documentation

http://www.rational.com/uml/

The primary site for UML documentation and examples.

http://umlcenter.visual-paradigm.com/

UML documentation and comments.

Chapter 3: Data Normalization

Information on Database Design

http://www.dbpd.com/

Database Programming & Design magazine.

http://www.for.gov.bc.ca/isb/datadmin/

Canadian Ministry of Forests data administration site, with useful information on data administration and design. Start with the development standards.

http://www.sybase.com/products/whitepapers/pkey_wpaper.html

A paper on the relative merits and costs of surrogate keys, especially within Sybase database systems.

Chapter 4: Data Queries

Basic SQL References

http://www.opengroup.org/index.htm

Standards group including SQL.

Chapter 5: Advanced Queries and Subqueries

Detailed discussions of SQL

http://www.metis.com/

SQL consulting firm with interesting tips.

http://www.jcc.com/

Another database consulting firm.

http://www.acm.org/sigmod/

Association for Computing Machinery—Special Interest Group: Management of Data.

Chapter 6: Forms and Reports

Design Guidelines

http://www.microsoft.com/win32dev/uiguide

Windows interface 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: Calculations and Data Manipulation

Programming Guidelines

http://www.microsoft.com/vbscript/us/vbstutor/vbsCodingConventions.htm

Microsoft Hungarian notation variable naming convention.

http://www.acm.org/sigplan/

Association for Computing Machinery—Special Interest Group on Programming Languages (advanced).

Chapter 8: Application Development

Application Guidelines

http://www.microsoft.com/win32dev/uiguide/

Microsoft user interface guide.

http://www.microsoft.com/enable/

Microsoft site for accessibility issues.

http://www.ameritech.com/corporate/testtown/library/standard/std-guix.html

Ameritech user interface guide.

http://www.acm.org/sigapp/

Association for Computing Machinery: Special Interest Group on Applied Computing.

Chapter 9: Physical Design

Information on File and Data Storage

http://www.disktrend.com

Market research source on disk drives.

http://www.ciprico.com/raid.html

Tutorial on RAID storage.

http://www.baydel.com/tutorial.html

Tutorial on RAID storage.

http://www.broadbase.com/

Data warehouse vendors rely on optimizing physical data storage and retrieval.

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.for.gov.bc.ca/isb/datadmin/

Canadian Ministry of Forests data administration site, with useful information on data administration.

http://www.securityserver.com

Links to information on computer security.

http://www.capacityplanning.com/

Explores issues in capacity planning.

http://www.benchmarkresources.com

A related site that explores issues in benchmarking and performance.

http://swynk.com

Consultant/author with many links, and on-line full-text SQL Server book.

http://www.rational.com

A major CASE tool vendor.

http://www.sterling.com

A major CASE tool vendor.

http://support.microsoft.com/download/support/mslfiles/WX1051.exe

Microsoft’s original white paper on Access 2.0 security; but still one of the better explanations.

Chapter 11: Distributed Databases and The Internet

Basic Web Construction Help

http://www.microsoft.com/sitebuilder

Microsoft Web help (site builder network)

http://www.w3.org/

Web standards body.

http://home.netscape.com

Netscape Web support.

http://www.microsoft.com/vbasic/techmat/whitepapers/ado20/

Microsoft ADO and RDO white paper.

http://activeserverpages.com

Consulting group with comments and links on building Windows NT Web sites with databases.

Chapter 12: Object-Oriented Databases and Integrated Applications

Objects and SQL3

http://www.omg.org/

OMG and CORBA

http://www.odmg.org/

ODMG (OODBMS)

http://www.objs.com/x3h7/fmindex.htm

SQL3

http://www.jcc.com/sql_stnd.html

SQL3

http://www.service-architecture.com/object-oriented-databases/

Free, online articles about object-oriented database along with links to product vendors


Searching AltaVista Worldwide and fast.
Lycos General searches.
Hotbot Comprehensive searches.
Yahoo Useful categories.
White Pages U.S. personal phone numbers and addresses.
Yellow Pages U.S. business phone numbers.