The NexusDB engine implements a large subset of the international standard ISO/IEC 9075 - SQL:2003, including most of the Core SQL functionality as well as many of the additional features defined in the standard. In addition, the NexusDB engine augments SQL:2003 with extensions to expose application-specific functionality.
While NexusDB does not claim full conformance to Core SQL, the grammar conforms closely to the syntax and processing rules defined in SQL:2003. Any difference between NexusDB SQL and SQL:2003 is documented in the Conformance summary at the bottom of each topic page in our manual.
The advantage of using standard SQL
While SQL has been the dominant database language for more than three decades, and also being standardized since 1986, the major RDBMS vendors have implemented proprietary grammar and SQL dialects to meet demands in the market not covered by the standard at the time. The result has been that SQL statements tuned to execute efficiently on a particular RDBMS, will often fail when ported to a different RDBMS.
The recent SQL standards, starting with SQL-92, and particularly the SQL:1999 major revision and the latest SQL:2003 minor revision, implement all commercially accepted functionality found in the proprietary implementations, and probably more than a single vendor will ever offer.
The NexusDB engine's SQL main features
• | Standard SQL:2003 |
• | Views |
• | Referential Integrity |
• | Triggers - Active Database |
• | Stored Procedures and Functions |
• | SQL/PSM Procedure Language |
• | Transaction Management |
• | Fulltext Index Support |
• | Tools |
Further information can be found in the SQL Reference guide