Entity relationship stored procedure
Călin-Adrian Comes, Nicolae Ghişoiu, Vasile Paul Breşfelean, Ioan A. Rus · 2006
ER-SP(Entity Relationship - Stored Procedures) model is proposed like an extension to ER (Entity Relationship) model for conceptual, syntactic and semantic modeling of RDBMS in idea to create a link between external to physical models. ER-SPL (Entity Relationship - Stored Procedures Language) is proposed to be independent by RDBMS team players in idea to support their own SQL dialects. The model proposes a new entity type called Stored Procedures type and the language behind him in idea to be platform independent in relation with SQL dialects and their Procedural Languages. The concept of stored procedures type is abstract, helps in syntactic and semantic modeling, and is required in physical implementation. A stored procedures entity type along with his language captures the syntactic and semantics of an RDBMS schema in his dynamical evolution.