(Donna Cooksey and Arup Nanda) DBAs and IT professionals alike have long endured the task of protecting mission-critical data. Often a thankless job, until of course, recovery is required launching this mundane daily operation to the front-burner with critical importance and attention by upper manag
Tag: Oracle
Oracle showcases RFID partners, to launch data hub
(Rob Westervelt) Oracle Corp. is partnering with a hardware vendor to launch a product that addresses initial radio frequency identification (RFID) deployments. (R)
Oracle 10G Development & Design: Heterogeneous Database Access
(Boris Makushkin) The designers of a newer information system often faces the difficult task of heterogeneous data access unification. Heterogeneous means that data may be stored on different database platforms. Oracle Corporation provides the developer with tools to address heterogeneous data acces
Applying Oracle 10g’s Hierarchical Query options
(Scott Stephens) Oracle 10g adds new pseudo columns to the SQL Hierarchical Queries that use START WITH . . . CONNECT BY . . . clauses. For instance, you could specify a starting condition and continue to child rows using one or more connection conditions. As an example, suppose I have a table that
Protect Objects from Deletion
(Laurent Leturgez) This script is based on a SECURED_OBJECTS table and a CHECK_BEFOREDROP trigger that will prevent the deletion of objects. The trigger tests if the object you try to delete is in the table. If true, an error occurs and the object is not deleted. (script)
Recovering from ‘Compulsive Tuning Disorder’
(Sara Cushman) Performance tuning expert Gaja Krishna Vaidyanatha wants to help DBAs who suffer from what he calls “Compulsive Tuning Disorder” (CTD). Vaidyanatha, owner of consulting firm DBPerfMan.com and an author of several Oracle books, including “Oracle Performance Tuning 101,” coined the term
Does EJB 3.0 really make application development easy ?
(Raghu Kodali) After reading through articles and posts regarding how EJB 3.0 is going to make application development simpler, I decided to give EJB 3.0 a spin and see if the claims are true.
Grid Computing with Oracle
Grid computing is a new IT architecture that produces more resilient and lower cost enterprise information systems. With grid computing, groups of independent, modular hardware and software components can be connected and rejoined on demand to meet the changing needs of businesses. (pdf)
Why Oracle hashing is so cool
(Craig A. Shallahamer) Like politics, culture, and life’s adventures, searching algorithms can be diverse and fascinating. But what’s the best algorithm? (R)
The Globalization of Language in Oracle – The NLS_LANG variable
(James Koopmann) Firstly I need to thank the professionals at Oracle for their help in assisting me in getting the facts straight on these globalization articles. If you haven’t noticed, the facts and methods to setting the NLS_LANG variable, in the last article of this series, has been revised.