(Rudy Limeback) Can a foreign key also be used as the primary key in the same table? (R)

Materialized views are a data warehousing/decision support system tool that can increase by many orders of magnitude the speed of queries that access a large number of records. In basic terms, they allow a user to query potentially terabytes of detail data in seconds. They accomplish this by transpa

(David A. Kelly and David Baum) Organizations traditionally have invested in security technology to prevent unauthorized users from gaining access to private information or restricted IT services. Over the past few years, the scope and importance of security technologies in general, and identity man

(Lewis R Cunningham) A few days ago I answered a question from brat about converting 1 field into multiple rows. We solved that question but now we want to handle multiple rows in our source table.

(Ed Sutherland) Database software vendor Oracle announced an update to its PeopleSoft Enterprise platform.

(Karl Dias, Mark Ramacher, Uri Shaft, Venkateshwaran Venkataramani and Graham Wood) Performance tuning in modern database systems requires a lot of expertise, is very time consuming and often misdirected. Tuning attempts often lack a methodology that has a holistic view of the database. The absenc

(Mark Brunelli) Many IT professionals believe that Oracle’s recent moves in the open source software (OSS) market — including its purchase of open source stalwart Sleepycat Software Inc. — were undertaken in an effort to destabilize Microsoft. (R)

(Gregory Williams) In order to send e-mail within 10g you must install and set up the UTL_MAIL package. (R)

(Yunyou Yao) Enterprise Library is a library containing seven general purpose application blocks, which are reusable, extensible source-code components that provide guidance for common development challenges. Its major newest release is Enterprise Library 2.0 (EL 2.0) in January 2006, which has been

(Lewis R Cunningham) This effort is an example of how I decompose a problem and some fun SQL tricks. Not tricks, I guess but maybe a creative use of SQL.