Entity relationship stored procedure

  • Authors:
  • Călin-Adrian Comes;Nicolae Ghişoiu;Vasile Paul Breşfelean;Ioan Rus

  • Affiliations:
  • Petru Maior University, Târgu-Mureş, România;Babeş-Bolyai University, Cluj-Napoca, România;Babeş-Bolyai University, Cluj-Napoca, România;Petru Maior University, Târgu-Mureş, România

  • Venue:
  • ACS'06 Proceedings of the 6th WSEAS international conference on Applied computer science
  • Year:
  • 2006

Quantified Score

Hi-index 0.00

Visualization

Abstract

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.