5 Links from Around the Web (2007-05-04)

1 – Oracle 10g Security: Fine-Grained Auditing

This article demonstrates how to implement FGA in Oracle 10g and illustrates how to take advantage of the newest Oracle 10g Release 2 (10gR2) FGA features.
2 – Hammerora – The Open Source Oracle Load Test Tool

Multi-user Oracle database load testing, HTML and web load testing, pre-bullt workloads and Oracle trace replay and no license Fees, 100% open source.
3 – Don’t Let Referential Integrity Degrade Your Database Performance

Foreign key (FK) constraints without supporting indexes can cause severe performance problems during SQL queries and massive DML (Data Manipulation Language) operations, such as DELETEs or UPDATEs.
4 – Trees in SQL: Nested Sets and Materialized Path

This article investigates two approaches to modeling a tree in the database, materialized path and nested sets.
5 – Primary Keys: IDs versus GUIDs

GUID primary keys are a natural fit for many development scenarios, such as replication, or when you need to generate primary keys outside the database.

Filed in Links on 04 May 07

Comments are closed.