An easy to use interface for Oracle Compression Advisor (DBMS_COMPRESSION). The COMPRESSION_ADVISOR package invokes Oracle Compression Advisor to gather compression-related information within a ...

Another year passes. I was hoping to write more articles instead of just these end-of-the-year screeds, but I almost died in the spring semester, and it sucked up my time. Nevertheless, I will go ...

RS: Emp_WS.Save_Emps - Save a list of new employees to database, returning list of ids with Julian dates; logging errors to err$ table RG: Emp_WS.Get_Dept_Emps - For given department id, return ...

Our research indicates that data platform wars have entered an entirely new phase, one where open data is no longer a marketing slogan and governance catalogs are now the new control point. We see ...

Like a shot to your dome piece, I'm back to hit you with my annual roundup of what happened in the rumble-tumble game of databases. Yes, I used to write this article on the OtterTune blog, but the ...

Abstract: DBAs face different problems when working with many database products from various manufactures in the same company. This paper proposes a J2EE-based software developed to access any ...

Referential integrity (RI)is a method for ensuring the “correctness” of data within a DBMS. People tend to oversimplify RI, stating that it is merely the identification of relationships between ...

This image, from a 1962 internal General Electric document, conveyed the idea of random access storage using a set of "pigeon holes" in which data could be placed. Fifty-three years ago a small team ...