For the technical purpose of database developers and administrators, a database is simply a collection of operating system files. Database files are normally stored in a proprietary binary format that can only be mounted by an instance of the relational database software that created them. The purpose of the database instance is to to manage and [...]
About Michael Ritacco
Looking forward to SQL Server 2012
I finally got around to installing SQL Server 2012 RC 0 on VMware Fusion 4 yesterday. Like a kid on Christmas, I started looking for the enhancements that do not get much marketing attention, but will improve my development workflow or put an end to some administration pains. This is what I found so far: [...]
Introduction to Oracle Exadata V2
This post came out of the difficulty to find the information needed to prepare myself for a week long Exadata proof of concept I have scheduled next month at the Oracle Technology Center in Menlo Park. The topics listed below should confirm your suspicion that there is significant learning and study required to understand Exadata. [...]
Google Malware Warning
The dbanotes.com site was a recent victim of a published security vulnerability found in the framework our WordPress theme leverages, and as a result, may have been advertising malware to visitors. While we applied the security patch as quickly as possible, we were unfortunately attacked prior to the security patch being published. However, we take [...]
Oracle 11g Pivot Functions
Data mining, processing and its presentation are the key activities in a production environment. The views and analytic integrals of the information through multiple spectacles can help in better business forecasting and strategic implementations. This innovative exercise of creating varying views might involve aggregation, data transposing, or cross tabulation reporting. Data Pivoting, one of the [...]
Oracle Server Process
Server Process A server process handles the connection to the database on behalf of the client program and performs one or more of the following: Parse and run SQL statements and PL/SQL issued through the application/client. Read necessary data blocks from datafiles on disk into the shared database buffers of the SGA. Return results in such [...]
Oracle Software Code Area
Software Code Areas Oracle code is stored in a software area that is typically at a different location from users’ programs. Software areas are read only, usually static in size, and can be installed shared or nonshared. When possible, Oracle code is shared so that all Oracle users can access it without having multiple copies [...]
Basic UNIX Commands for the DBA
A collection of commonly used UNIX commands by the Oracle Database Administrator. File Manipulation Action Command Example list file contents cat cat myfile append to a file cat cat myfile >>newfile combine two files cat cat myfile1 myfile2 >newfile create a file cat cat >newfile copy a file cp cp myfile newfile create a file [...]
The History of PL/SQL
PL/SQL is Oracle’s Procedural Language extension to SQL. It is loosely based on Ada (a variant of Pascal developed for the US Dept of Defense). PL/SQL was first released in 1992 as an optional extension to Oracle 6. PL/SQL is now a technology present in most Oracle servers and products. PL/SQL Version: 1.0 - 1991 [...]
A General Philosophy for Data Modeling
The design of any application depends on the foundation of its data model. We must all accept the simple fact that the decisions made during the data modeling phase will determine the overall success of the application. Before we address any specific data modeling topics or problems, we must talk about the philosophy that will provide the [...]
- What is a Schema in SQL Server 2005?
- Oracle 11g New Features for Developers
- Introduction to Oracle 11g Cursors
- So you want to be a Data Modeler?
- Using Triggers and Compound Triggers in Oracle 11g
