Netezza Database Schema: CREATE, ALTER, DROP and SET SCHEMA

In the previous version, the Netezza system supported one default schema per database. You can configure multiple schema within database in latest release. In this article, we will check on Netezza database schema and how to create, alter, drop and set schema for Netezza database. In the latest release, Netezza system can validate the schema information i.e. you can configure the system to return an error for any queries that specify an invalid or non-existent schema, or you can configure the system to return a warning message for queries that…

Continue ReadingNetezza Database Schema: CREATE, ALTER, DROP and SET SCHEMA
Comments Off on Netezza Database Schema: CREATE, ALTER, DROP and SET SCHEMA

Database ACID Properties and Explanation

ACID (Atomicity, Consistency, Isolation, Durability) is a set of database properties that makes sure that database transactions are processed reliably and completly. Relational databases makes sures that its transactions are completed propely as per ACID properties . Database ACID Properties Following sections explains about various database ACID properties: Atomicity In ACID properties, Atomicity requires that each and every transaction is fully completed and committed or nothing at all. If any one part of the current transaction fails, then the entire transaction fails, and the database state is left unchanged (databse…

Continue ReadingDatabase ACID Properties and Explanation
Comments Off on Database ACID Properties and Explanation