1/25/2020 - Optimized for Firefox 72.0.2 (Quantum)

COPYRIGHT 1992-2020 - David R. Woodsmall

I created these websites ONLY to provide free information to help other people

I am NOT a business of any kind, and make NO money providing this information

There is NOTHING for sale here - Feel free to link to any of my web pages

NOT responsible for Errors, Omissions, out-of-date Data, or ANYTHING else



11G | ACCESS | ADO| Articles | BioMed | Btrieve | CORBA | Crystal Reports | DAO | DB2 | DBA | Database, General | Data Mining | Data Warehouse 2.0 | Data Warehousing | Daylight Saving Time DB2 | INFORMIX | JDBC | LEAP | Data Mining | MapReduce | MySQL | ODBC | ORACLE | PostgreSQL | R | RAC - Real Application Clusters | RGP - Report Generating Programs | SAS (Statistics) | Sphinx | SPSS | SQL | SQL Server| Tables, Ddatabase | T-SQL | VBA |


10 Easy Ways To Speed Up An Access Database


Microsoft's ActiveX Data Objects (ADO). more


Database monitoring, encryption vital in tight economy


coming soon...

Btrieve - click here

Crystal Reports

Crystal Reports / Crystal Decisions / Seagate Software - Now: BusinessObjects

DAO - Data Access Objects

Stay tuned...


Database Books There are two main types of database; flat-file and relational. Other recognized DB types are Hierarchical Model and Network Model. My friend/ex co-worker Buzz and I invented the term "Hierarchical", (for Tim Fulham and George Moore's SeaDogs oil finding project) which was deemed not a word, by the Chevron Oil Field Research Company, La Habra, California. Database Resources - cbtplanet - Thank you BRIAN & Ms. Henderson Database - Wikipedia Types of Database What is a Database? Database Resources - unifx

Data Mining

Stay tuned...

Data Warehousing 2.0 - DW2

DW 2.0 - Architecture for the Next Generation of Data Warehousing DW 2.0 - CONFERENCE November 23, 2009 DW 2.0: Next Generation of Data Warehousing on LinkedIn Events SAP NetWeAver ANd dW 2.0 - PDF DW 2.0: Next Generation of Data Warehousing, CONFERENCE - 3rd December 2009 What, Exactly, is 'Data Warehouse 2.0'? Opinions Vary Data warehousing software update: Bill Inmon makes the case for DW 2.0 DW 2.0 TM - Architecture for the Next Generation of Data Warehousing DW 2.0: The Architecture for the Next Generation of Data Warehousing - BOOK -

Data Warehousing

Data Warehousing Information Center **


DBA Support


IBM - DB2 Version 9.5 for Linux, UNIX and Windows English manuals DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep, 6th Edition DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam ... Pearson Education - DB2 9 for Linux, UNIX, and Windows


not yet


JDBC API - Sun JDBC Home Page Trail: JDBC - Database Access (The Java Tutorials) - Sun Java Database Connectivity - Wikipedia JDBC - Java Database Connectivity Tutorials PostgreSQL JDBC Driver JDBC Resources JDBC Drivers jGuru: JDBC FAQ Home Page JDBC Sample Code - Oracle Getting Started with JDBC C-JDBC - Home Page (Clustered JDBC) Microsoft SQL Server 2005 JDBC Driver jTDS JDBC Driver - pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server & Sybase - Open source SQL Summit Directory of JDBC Drivers Jdbc Control Developer's Guide - Apache

LEAP - free RDBMS that is used in universities

LEAP - Free open source Relational Database Management System


MapReduce - wikipedia MapReduce: Simplified Data Processing on Large Clusters - Google bashreduce: A Bare-Bones MapReduce Apache Hadoop Elastic MapReduce service on their EC2 platform - Amazon Hadoop - Yahoo bashreduce DOWNLOAD - GitHub is for Public Open Source and Private Business Code


MySQL is used in web applications and acts as the database component of the web server. MySQL Data and Table Types - MySQL Types of Table Relationships - MySQL: Learning the Database ... MySQL Commands "LAMP refers to the first letters of Linux (operating system), Apache HTTP Server, MySQL (database software, but now sometimes MariaDB) and originally PHP (but now sometimes Perl or Python)" - Wikipedia LAMP software stack. MySQL - The world's most popular open source database MySQL - MySQL Enterprise Server 5.0 MySQL - Wikiped NetBeans IDE 6.1 with Glassfish and MySQL NetBeans IDE 6.1 is a free open-source Integrated Development Environment MySQL :: MySQL Documentation PHP: MySQL - Manual Compare Microsoft SQL Server to MySQL MySQL - Sun MySQL Testing with Pearson VUE Planet MySQL PHP MySQL Tutorial MySQL for Python MySQL Gotchas MySQL :: MySQL Forums MySQL! (Japan) MySQL by T.c.X. DataKonsultAB Hughes mSQL site - NOT MySQL The Curious Case of the Failing MySQL Connections, Part 1 The Curious Case of the Failing MySQL Connections, Part 2 Quick and Dirty MySQL Performance Troubleshooting Understanding MySQL Appliances and Hardware Acceleration MySQL Sandbox: Treat MySQL Instances like Virtual Machines Mattkit: A Great MySQL Toolbox MySQL Performance from the Start Sphinx: Sphinx: Search Outside the Box - powerful, free full-text search engine that works extremely well with MySQL Sphinx: Queries and APIs Sphinx: Getting Practical

ODBC - Open Database Connectivity

not yet... Open Database Connectivity - Wikipedia ODBC--Open Database Connectivity Overview - Microsoft Microsoft Open Database Connectivity (ODBC) ODBC FAQ - Oracle FAQ

OLE (Object Linking and Embedding) & OLE DB

Object Linking and Embedding - Wikipedia OLE - Wikipedia OLE Concepts and Requirements Overview - Microsoft PEAR :: Package :: OLE OLE DB - Wikipedia Microsoft OLE DB OLE DB for the ODBC Programmer


Oracle Database 11g Release 2 Database 11g | Oracle Database 11g | Oracle Oracle Database - Wikipedia Oracle 11g - Session 1 - YouTube Oracle 11g step-by-step Installation Guide with Screenshots RAC - Real Application Clusters (RAC) | RAC Support | Database | Oracle Oracle Real Application Clusters 11g | Oracle RAC Introduction to Oracle Real Application Clusters Oracle 9i JDBC Developer's Guide and Reference Oracle - home page Types of Tables in Oracle

PostgreSQL - Open Source SQL

PostgreSQL ORG PostgreSQL: Documentation PostgreSQL - Wikipedia PHP: PostgreSQL Functions - Manual Planet dot PostgreSQL -

RGP - Report Generating Programs

Nothing at this time

See also: Crystal Reports


The Sixteenth International Static Analysis Symposium (SAS 2009) - 9-11 August 2009 SAS FAQ - Cornell Welcome to the UCLA SAS Portal Topics in SAS Programming SAS V8 Information Guides SAS: What You Need to Know to Write a SAS Program SAS Library - for educational and informational purposes only! SAS dot com Statistical Analysis with SAS/STAT Software Resources to help you learn and use SAS SAS Product Documentation How do I use a SAS setup file to import ASCII data? SAS Consultant Special Interest Group Google Directory - Computers > Programming > Languages > SAS SAS Programs - test data Introduction to SAS Version 8.2 - The employment web site for SAS Software professionals Obtaining SAS Notes Through Email Northeast SAS Users Group SAS Users - Information and resources for users of the SAS statistical software package Fire price SAS JMP 7.0 software - I know nothing about them SAS - Research Technologies at Indiana University INTERNET and Web Resources for SAS Programmers and Statisticians - commercial site? Western (USA) Users of SAS Software ITSweb | Documentation | SAS Open Directory - Computers: Programming: Languages: SAS PhilaSUG (Philadelphia Area SAS Users Group) Local SAS Users Group Professional Organization South Central (USA) SAS Users Group Data Mining Using SAS Enterprise Miner - Books SAS/STAT 9.2. 9.1 & 9.0 Software documentation - SAS Locally Written SAS Macros - Mayo Clinic SAS Tutorial - Statistical Consulting Center - UMass Amherst New clouds floated by NetSuite and SAS | IT Systems News - Betanews SAS Global Forum, formerly known as SAS Users Group International (SUGI) SAS OnlineDoc, Version 8 SAS PROGRAMMING CERTIFICATE FOR THE PHARMACEUTICAL INDUSTRY SAS/STAT User's Guide - A SAS User's Guide to Stata - UNC SAS Center at OnTheHub - links students, faculty and staff

SPSS - Statistical Package for the Social Sciences

coming soon...


SQL Tutorial - SQL Query Reference - Chuo-Han Ultimate Web Guide to SQL Database Language - Intuit - courtesy of Ms. West SQL Course SQL Course 2 SQL Tutorial ** Database Journal A Gentle Introduction to SQL SQL - Wikipedia

SQL Server

SQL Server Info



TABLES - Database

A Naming Scheme for Database Tables and Fields Types of Table Relationships (Visual Database Tools) MySQL Data and Table Types - MySQL

T-SQL (Transact-SQL)

Transact-SQL - Wikipedia Transact-SQL Reference (Transact-SQL) Transact-SQL Overview - Microsoft T-SQL - Introduction - DevGuru Quick Reference IF…ELSE (T-SQL) SQL Azure Team Blog : TSQL Support in SQL Data Services SSIS Junkie : String Aggregation in T-SQL & PL-SQL : SQL Nugget Flow control in T-SQL Scripts - Merrill Aldrich Top 10 T-SQL Code Smells TSQL Challenge - counting non zero columns - SimonS Blog on SQL Dynamic Search Conditions in T-SQL Levenshtein Distance Algorithm: TSQL Implementation My code library (SQL Server T-SQL code samples, snippets, examples ... T-SQL Best Practices T-SQL Best Practices – Part 2 CASE (T-SQL) Alternatives to CASE in T-SQL Part 1 - Defining Variables, and IF...ELSE logic Part 2 - Building a T-SQL Loop Part 3 - Processing Sequentially Through a Set of Records Part 4 - Setting Variables in Calling T-SQL T-SQL Programming Part 5 - Using the CASE Function


I am NOT Responsible for any Errors - Use at your own risk