You shouldn’t care where your data resides, or which computer processes your request. You should be able to request information or computation and have it delivered – as much as you want, and whenever you want. This is analogous to the way electric utilities work, in that you don’t know where th

GeoRaster is a feature of Oracle Spatial in Oracle Database 10g that lets you store, index, query, analyze, and deliver GeoRaster data, that is, image and gridded raster data and its associated metadata. GeoRaster provides Oracle Spatial data types and an objectrelational schema. You can use these d

Oracle9i introduces a family of new features to support more scalable and efficient ETL (Extraction, Transformation, Load) processing for data warehouses and business intelligence systems. One of the most significant ETL additions is the Multitable Insert feature. The multitable insert feature a

(David A. Kelly) It’s a difficult and ultimately futile effort to try to categorize a typical Linux-using enterprise today. Consider, for example, Eu Yan Sang (EYS), a 120-year-old company headquartered in Singapore that specializes in traditional Chinese medicine—including some 3,000-year-old herba

A primary key is a single field or combination of fields that uniquely defines a record. None of the fields that are part of the primary key can contain a null value. A table can have only one primary key.

(James Koopmann) Do you have SQL running within your database? Of course you do. This article is the first in a series to introduce you to a method of finding information about the SQL your users are executing in your databases. Your ability as a DBA to detect who is accessing the database and th

(Arup Nanda) Wow! This is the final week of our amazing journey into the most important new features for DBAs in Oracle Database 10g. Over these last 19 installments I have attempted to cover all the tools, tips, and techniques that have this fundamental appeal: making our jobs easier and more satis

(Jeff Hunter) Structured Query Language (SQL) is an implementation of a “data sublanguage” used in almost all relational database systems. SQL was developed by IBM in the early 1970s for use in System R, and is “de facto” standard, as well as an ISO and ANSI standard. (R)

(Kelli Wiseth) Ask Whit Andrews about Web services, and he’ll tell you a story about plastic. At some point, explains the Gartner research director, “plastic became integral to a variety of other products and established a new baseline—consider the dosage cup that’s packaged with cough medicine thes

(Jim Czuprynski) Oracle 9i offers the ability to pass data to a PL/SQL function in the form of a cursor variable. When this feature is paired with the concept of the table function, the resulting PL/SQL code increases significantly in flexibility and scalability. This article builds upon the author’