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 [...]
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. [...]
Understanding Oracle 11g Constraints
Introduction to Constraints Oracle constraints are defined as the rules to preserve the data integrity in the application. These rules are imposed on a column of a database table, so as to define the basic behavioral layer of a column of the table and check the sanctity of the data flowing into it. The data [...]
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 [...]
Introduction to Oracle 11g Cursors
Cursors are one of the most common and fundamental terms in the database terminology. It is one of the core database programming concepts, which forms a basic unit of execution of SQL statement. A cursor is a pointer, which points towards a pre allocated memory location in the SGA. For transparent understanding, it is a [...]
Using Triggers and Compound Triggers in Oracle 11g
In database terminology, triggers are the objects which demonstrate the logic of schedule and automation. Triggers are automatically invoked at a defined event and timing without any explicit calls. The logic embedded within the trigger and invocation must be well directed and synchronized to maintain database purity. Oracle 11g made remarkable enhancements in Database Triggers. [...]
Oracle 11g R2 SQL Enhancements
With each and every release of RDBMS, Oracle has achieved great commercial success and attained zeniths of exploration. The year 2007 saw the release of Oracle RDBMS version 11g (second grid computed version after Oracle 10g). First release of Oracle 11g facilitated the developers with multiple enhancements and language features. The introduction of advanced core [...]
Using EXISTS in Oracle SQL Queries
By definition, an operator works with the data items (known as operands) and returns a result. Oracle provides multiple operators under various categories which can be used in queries to filter the result set. In SQL, EXISTS is an operator which can be used in WHERE clause to validate an “IT EXISTS” condition. In 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
