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 [...]
Archive | Database Administration RSS feed for this section
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. [...]
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 [...]
Database Management 101
Author: Khaled Kahlouni Companies have a wealth of information systems as they continue to collect mountains of data on a daily basis. The need to house their information and have them readily available will always be there. Therefore, creating, monitoring, and maintaining the databases that house the data, pose higher challenges on the Information Technology [...]
- 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
