RE: New proposal on OTN - Create ASSERTION
From: Iggy Fernandez <iggy_fernandez_at_hotmail.com>
Date: Fri, 20 May 2016 03:36:43 -0700
Message-ID: <BLU179-W765103752A35433A27C455EB4B0_at_phx.gbl>
+1000
The creator of the relational model, Dr. Codd touted its simplicity and consequent appeal to users—especially casual users—who have little or no training in programming. He singles out this advantage in the opening sentence of his first paper on relational theory A Relational Model of Data for Large Shared Data Banks: “Future users of large data banks must be protected from having to know how the data is organized in the machine (the internal representation).” He made the point more forcefully in a subsequent paper, Normalized Data Base Structure: A Brief Tutorial in which he says: “In the choice of logical data structures that a system is to support, there is one consideration of absolutely paramount importance—and that is the convenience of the majority of users. … To make formatted data bases readily accessible to users (especially casual users) who have little or no training in programming we must provide the simplest possible data structures and almost natural language. … What could be a simpler, more universally needed, and more universally understood data structure than a table? Why not permit such users to view all the data in a data base in a tabular way?”But the true importance of the relational model is highlighted by the title Derivability, Redundancy, and Consistency of Relations Stored in Large Data Banks of the unpublished original—and shorter—version of Dr. Codd’s paper which predated the published version by a year. That title hints that the chief advantage of the relational model is its ability it gives us to assert arbitrarily-complex consistency constraints that must be satisfied by the data within the database; that is, the ability to put the “C” into “ACID.” An example of a complex constraint is: A pilot may fly a certain type of aircraft only if (1) he has flown that type of aircraft previously or (2a) he has attended a training class on flying that type of aircraft and (2b) the instructor of that class is one of the co-pilots.Oracle Rdb for the OpenVMS operating system already provides the SQL-92 CREATE ASSERTION specification (http://community.hpe.com/hpeb/attachments/hpeb/itrc-149/22979/1/15667.doc) so why not Oracle Database? Let’s put the “C” into “ACID.” We’ve waited 25 years but better late than never.
Date: Fri, 20 May 2016 03:36:43 -0700
Message-ID: <BLU179-W765103752A35433A27C455EB4B0_at_phx.gbl>
+1000
The creator of the relational model, Dr. Codd touted its simplicity and consequent appeal to users—especially casual users—who have little or no training in programming. He singles out this advantage in the opening sentence of his first paper on relational theory A Relational Model of Data for Large Shared Data Banks: “Future users of large data banks must be protected from having to know how the data is organized in the machine (the internal representation).” He made the point more forcefully in a subsequent paper, Normalized Data Base Structure: A Brief Tutorial in which he says: “In the choice of logical data structures that a system is to support, there is one consideration of absolutely paramount importance—and that is the convenience of the majority of users. … To make formatted data bases readily accessible to users (especially casual users) who have little or no training in programming we must provide the simplest possible data structures and almost natural language. … What could be a simpler, more universally needed, and more universally understood data structure than a table? Why not permit such users to view all the data in a data base in a tabular way?”But the true importance of the relational model is highlighted by the title Derivability, Redundancy, and Consistency of Relations Stored in Large Data Banks of the unpublished original—and shorter—version of Dr. Codd’s paper which predated the published version by a year. That title hints that the chief advantage of the relational model is its ability it gives us to assert arbitrarily-complex consistency constraints that must be satisfied by the data within the database; that is, the ability to put the “C” into “ACID.” An example of a complex constraint is: A pilot may fly a certain type of aircraft only if (1) he has flown that type of aircraft previously or (2a) he has attended a training class on flying that type of aircraft and (2b) the instructor of that class is one of the co-pilots.Oracle Rdb for the OpenVMS operating system already provides the SQL-92 CREATE ASSERTION specification (http://community.hpe.com/hpeb/attachments/hpeb/itrc-149/22979/1/15667.doc) so why not Oracle Database? Let’s put the “C” into “ACID.” We’ve waited 25 years but better late than never.
Date: Fri, 20 May 2016 11:07:13 +0100
Subject: New proposal on OTN - Create ASSERTION
From: niall.litchfield_at_gmail.com
To: oracle-l_at_freelists.org
For those who do not track the OTN ideas site Toon Koppelaars has created a suggestion that a future release of Oracle should incorporate support for the SQL92 ASSERTION feature. To vote, and for explanations of what this offers, see https://community.oracle.com/ideas/13028
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Fri May 20 2016 - 12:36:43 CEST