Databases on Linux:

TABLE OF CONTENTS    Trends    General information    Oracle    MySQL    IBM DB2    Sybase    PostgreSQL

Trends

Return to Table of Contents

• Column: Why open source databases are ripe for acquisition in 2006 (SearchEnterpriseLinux.com)
• Article: Oracle can't stop open source databases (eWEEK)
  The open source database community is too resilient for even Oracle to subvert, despite the sinister conspiracy theories swirling around the buyouts of Innobase and Sleepycat.
• Article: Oracle users concerned with open source support (SearchOracle.com)
  Oracle customers are taking to open source technologies, but old concerns about support and security remain, a new IOUG member survey finds.
• Article: Oracle vs. Microsoft: The open source factor (SearchOracle.com)
  Many IT pros believe Oracle's recent endorsements of the open source movement were designed specifically to destabilize Microsoft.
• Article: Are open source databases more secure? (SearchSecurity.com)
  They may not be. But a new survey suggests more IT shops are taking an interest in open source options, partly because of security holes in mainstream databases.
• Article: Open source databases interest more companies (NewsFactor)
  Databases like MySQL and PostgreSQL are drawing more attention, and large database vendors like Oracle and IBM have come out with competing open source databases.

General information

Return to Table of Contents

• Tutorial: A gentle introduction to SQL (SQLzoo)
  An interactive SQL tutorial using SQL Server, Oracle, MySQL, DB2, Mimer SQL, PostgreSQL and Access.
• Advice: Migration: Planning and choosing (SearchEnterpriseLinux.com)
  Migration expert Ken Milberg gives some advice for migrating off Windows NT.
• Advice: Can I use OSS apps in a Windows database and network environment? (SearchEnterpriseLinux.com)
  Migration expert John H. Terpstra explains some pros and cons of using open source software applications in a Windows database and network environment.
• Advice: Migrating from Oracle to Linux -- tips and TCO considerations SearchEnterpriseLinux.com)
  Ken Milberg discusses some of the considerations for a database migration.
• Resources: PHP database tutorials (WeberDev.com)
  A small collection of tips and tutorials about PHP, MySQL, and PostgreSQL, including descriptions of common data types, simple ODBC connections with PHP, and more.

Oracle

Return to Table of Contents

• Glossary: A definition of Oracle (SearchOracle.com)
• Advice: Oracle on Unix/Linux vs. Windows (SearchOracle.com)
• Advice: Migrating from Oracle to Linux -- tips and TCO considerations (SearchEnterpriseLinux.com)
  Ken Milberg discusses some of the considerations for a database migration.
• Advice: Migrating SQL Server 2000 db on Windows to Oracle 10g on Linux (SearchOracle.com)
• Advice: Migrating .mdb files into Oracle on Linux (SearchEnterpriseLinux.com)
• Case Study: With Linux, fisheries authority hauls in ROI (SearchEnterpriseLinux.com)
  The Australian Fisheries Management Authority recently moved its database management system from Windows NT to Linux and open source.
• Tip: Sybase vs. Oracle: Users speak out (SearchOracle.com)
  Users respond to a recent column touting the merits of Sybase on Linux over Oracle as a database management system (DBMS). Some say Sybase is easier to manage; others claim Oracle is more stable and more powerful.
• Tip: Installing Oracle9i (9.2.0) on Red Hat Linux 8.0 using RAW devices (SearchOracle.com)
  The following article is a summary of the steps required to successfully install the Oracle9i (9.2.0) RDBMS software on Redhat Linux 8.0 and create a database using RAW devices.
• Tip: Installing Oracle10g on RHEL4 (SearchEnterpriseLinux.com)
  Ken Milberg describes how to install an Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for x86 on a server running RHEL 4.0.
• Resources: SearchOracle.com (SearchOracle.com)
  Our sister site offers a vast library of Oracle-on-Linux information, including news, tips, advice and more.

MySQL

Return to Table of Contents

• Glossary: A definition of MySQL (SearchEnterpriseLinux.com)
• Article: MySQL CEO Mickos: Beware of proprietary vendors' giveaways (SearchEnterpriseLinux.com)
  Beware proprietary vendors bearing free software. MySQL AB CEO Marten Mickos warns users to watch out for vendor lock-in strategies and overpriced service organizations.
• Article: MySQL's Marten Mickos on GPLv3 and automated enterprise monitoring (SearchEnterpriseLinux.com)
  MySQL CEO Marten Mickos wants the everyday DBA to become more powerful. In this interview, he talks about automated monitoring technology in MySQL Enterprise that does just that.
• Tip: MySQL 5.0: When, why and how to upgrade (SearchEnterpriseLinux.com)
  Here are some reasons from Mike Hillyer to upgrade from MySQL 4.0 to MySQL 5.0.
• Tip: Tips for tackling MySQL 5.0 (SearchEnterpriseLinux.com)
  MySQL expert Mike Hillyer gives the skinny on when, why and how to upgrade to MySQL 5.0.
• Tip: Mastering MySQL: Drivers, clustering and remote access (SearchEnterpriseLinux.com)
  MySQL expert Scott Noyes describes the tricky aspects of clustering with MySQL and upgrading from MySQL 4.0 to MySQL 5.0.
• Tip: SQL Server vs. MySQL: Syntax differences, similar GUIs (SearchEnterpriseLinux.com)
  Discover syntax differences between SQL Server and MySQL, code for a timestamp automation workaround and why it's important to keep your version of MySQL current.
• Advice: Converting SQL Server procedure to MySQL 5.0 (SearchEnterpriseLinux.com)
• Advice: Using a query without a subselect (SearchEnterpriseLinux.com)
• Advice: MySQL login issues (SearchEnterpriseLinux.com)
• Advice: Replication or symbolic links for databases (SearchEnterpriseLinux.com)
• Advice: Finding rows that exist in one table but not another (SearchEnterpriseLinux.com)
• Advice: Characters in syntax (SearchEnterpriseLinux.com)

IBM DB2

Return to Table of Contents

• Glossary: A definition of DB2 (SearchDataCenter.com)
• Tip: "Low IT" and DB2 (SearchDataManagement.com)
  Wayne Kernochan examines the needs of what he terms "Low-IT" users, as well as how IBM's DB2 Express is proving itself to be a highly useful alternative in the Low-IT market.
• Tip: DB2 and the event-driven architecture (SearchDataManagement.com)
  Oracle is now coming out with an EDA (event-driven architecture) based on its ability to support business rules. How could DB2 help users to achieve the full benefits of an EDA?
• Tip: IBM DB2 and Master Data Management (SearchSAP.com)
  What is master data management? And what role can DB2 play in making master data management a success?
• Tip: How to configure DB2 on a single Lotus Domino server (SearchDomino.com)
  Here are 10 simple steps to configure DB2 on a single standalone Lotus Domino server, courtesy of SearchDomino.com member Ashutosh Chandra.
• Advice: Migrating DB2 UDB database to Oracle on Linux (ExpertAnswerCenter.com)
• Learning guide: DB2 (SearchDataManagement.com)
  Explore a wealth of reference material on everything from DB2 installation, administration and optimization to migration, development and more.

Sybase

Return to Table of Contents

• Glossary: A definition of Sybase (SearchEnterpriseLinux.com)
• Diagram: Sybase ASE 15 diagram (SearchEnterpriseLinux.com)
  Sybase expert Mich Talebzadeh has created a diagram of Sybase ASE 15's architecture for those who need a quick reference.
• Article: Sybase ASE: Performance benefits of DPL and DRL (SearchEnterpriseLinux.com
  With data page locking (DPL) and data row locking (DRL) of Sybase ASE, users can take advantage of improved table scans, decreased logical I/O consumption and more.
• Tip: Sybase vs. Oracle: 10 reasons to use Sybase on Linux (SearchEnterpriseLinux.com)
  Despite its fall from market leadership, Sybase is still a strong enterprise offering, says database consultant Dr. Mich Talebzadeh.
• Tip: 10 tips in 10 minutes: Sybase-on-Linux how-tos (SearchEnterpriseLinux.com)
  Here are 10 quick shortcuts for using Sybase on Linux, compliments of Mich Talebzedah, SearchEnterpriseLinux.com's Sybase expert.
• Advice: Test versions of Sybase (SearchEnterpriseLinux.com)
  Sybase expert Mich Talebzadeh recommends a link to a user seeking to test out Sybase.
• Advice: Types of joins and set theory (SearchEnterpriseLinux.com)
• Advice: Views vs. Stored procedures (SearchEnterpriseLinux.com)
• Advice: How are checkpoints used in Sybase? (SearchEnterpriseLinux.com)
• Advice: Avoiding deadlocks in ASE (SearchEnterpriseLinux.com)
• Advice: Dropping a stored procedure properly (SearchEnterpriseLinux.com)
• Advice: Creating a simple backup log (SearchEnterpriseLinux.com)

PostgreSQL

Return to Table of Contents

• Glossary: A definition of PostgreSQL (WhatIs.com)
• Article: Five reasons why you should never use PostgreSQL -- ever (SearchEnterpriseLinux.com)
  In an effort to dispel some of the FUD (fear, uncertainty and doubt) surrounding this impressive product, this article puts forth several of the most commonplace reasons for not further investigating PostgreSQL.
• Article: PostgreSQL vs. SQL Server: PostgreSQL is right for the Microsoft stack (SearchEnterpriseLinux.com)
  Is OS database PostgreSQL ready to replace Microsoft's SQL Server in the enterprise? Web application developer and author W. Jason Gilmore tackles the question in this column.
• Article: PostgreSQL experts: Why are you still using a big bucks database (SearchEnterpriseLinux.com)
  Learn how PostgreSQL matches up to other commercial database systems, why it's suitable for large- and small-scale enterprises and how it offers admins and users more control.
• Article: Open source databases place pressure on Oracle, SQL Server (SearchEnterpriseLinux.com)
  Open source RDBMS PostgreSQL is making its way into business' software portfolios. Find out where PostgreSQL is best put to use and why businesses prefer a big name product.
• Tip: PostgreSQL vs. SQL Server, Oracle: Enterprise-ready and able to compete (SearchEnterpriseLinux.com)
  Why pay licensing costs and maintenance fees for proprietary databases when you can get open source RDBMS PostgreSQL for free? Discover the drawbacks and advantages to using PostgreSQL over Oracle or SQL Server.
• Tip: Why PostgreSQL can best SQLServer, Oracle (SearchEnterpriseLinux.com)
  Authors Robert Treat and Jason Gilmore explain why the PostgreSQL open source database management system can take on heavy-duty enterprise jobs.
• Tip: Running PostgreSQL in a cross-platform environment (SearchEnterpriseLinux.com)
  This article by Robert Treat explains how PostgreSQL facilitates cross-platform development and points out various tools within PostgreSQL that help database administrators get the job done.
• Chapter download: Chapter 2, Relational database principles, of Beginning Databases with PostgreSQL (SearchEnterpriseLinux.com)
  Delve into database architectures, data types, commands for multiple tables and how data is stored in this excerpt from Beginning Databases with PostgreSQL.
• Advice: PostgreSQL 7.4.2 Documentation
  This is the official documentation of PostgreSQL. It is being written by the PostgreSQL developers and other volunteers in parallel to the development of the PostgreSQL software.
• Website: What is PostgreSQL?
  Here are a short history of the PostgreSQL Global Development Group, some case studies, a description of PostgreSQL's advantages and more.
• Website: PostgreSQL.org
  A hub site for the PostgreSQL community, this site has downloads, events listings, news, technical documents and more.