Tips

  • A bit wiser with Oracle technology

    Learn how to use a metadata repository to identify a "source of truth" for each customer attribute in a data warehouse. This tip explains how to use the base-two numbering values of the primary key...

  • Introduction to BPEL

    It's important for managers, developers and DBAs to have an understanding of how BPEL can benefit them. This article provides an introduction to BPEL including Oracle's BPEL Process Manager.

  • SQL puzzle: Finding equal sets

    A SQL puzzle in the December 1993 issue of Database Programming & Design magazine was to use a supplier and parts table to find pairs of suppliers who provide exactly the same parts. This is the same...

  • Open source databases place pressure on Oracle, SQL Ser

    Open source RDBMS PostgreSQL is making its way into businesses' software portfolios. Find out where PostgreSQL is best put to use and why businesses prefer a big name product.

  • PostgreSQL vs. SQL Server, Oracle: Enterprise-ready and

    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 ...

  • High availability with Flashback Database

    Flashback Database is a new approach to point-in-time (PIT) database recovery. This incomplete recovery strategy can be used to recover a database that has been logically corrupted due to human er...

  • The relational database dictionary

    This tip highlights three definitions from C.J. Date's new book, "The Relational Database Dictionary": 'primary key,' 'relational model' and 'table.'

  • Predictive modeling in Oracle

    Oracle professionals are now applying the proven predictive modeling techniques from Oracle data mining (ODM) and we are seeing them use special techniques to analyze database signatures and predic...

  • What is the DUAL table costing you?

    The DUAL table is one of the first things we learn as Oracle professionals. It is created by default as a single row table, understood by the optimizer and available to everyone for selection. Th...

  • Oracle RAC design: The effects of component failure

    This excerpt from the book "Oracle 10g Grid & Real Application Clusters" shows expert techniques used by real-world RAC professionals for designing a robust and scalable RAC system. This section pr...

  • Oracle vs. Sybase: 10 reasons to use Sybase on Linux

    Despite its fall from market leadership, Sybase is still a strong enterprise offering, says database consultant Dr. Mich Talebzadeh. In this tip, he gives 10 reasons why Sybase on Linux bests other...

  • Web Services 101

    Web services promise simplified interfaces for application-to-application interaction. This chapter describes the key technologies that enable them (such as XML, WSDL, SOAP and UDDI) and then peeks...

  • Developer and DBA: Working together for greater efficie

    There is often a disconnect between developers and DBAs. Bridging the gap between database design/development and operations management can make the difference between an efficient, well-managed bu...

  • Realizing tangible benefit from SOA in the near term

    This introduction to service-oriented architecture (SOA) clarifies some basic terms, such as service and Web services, and provides an overview as to how your organization can begin to see benefits...

  • Regulatory compliance and the DBA

    At the top of business executives' minds today is how to meet regulatory compliance and corporate governance rules. New laws are changing the way companies collect, retain and manage information. D...

  • Building an Oracle team

    In today's e-business environment, maintaining high availability, optimizing performance and delivering consistent service are essential. Building and maintaining an effective Oracle team is now mo...

  • Send email from Oracle 10g Server

    In order to send email within Oracle 10g you must install and set up the UTL_MAIL package. UTL_MAIL isn't installed when the database is installed because the SMTP_OUT_SERVER parameter must be conf...

  • Accounts unused for X days

    Here's a script that shows accounts and number of days since last use. It assumes session auditing is enabled.

  • Performance tuning a RAC implementation

    The performance tuning methodology for an Oracle Real Application Clusters (RAC) configuration can be broadly categorized into these seven steps.

  • Fax documents from database

    This tip offers several options for sending a fax from an Oracle database.