CFP last date
20 January 2025
Reseach Article

New Patterns for Reducing Number of Access to Database in Layered Information Systems

by Gholam Ali Nejad Haj Ali Irani, Ali Akbarpour Bonab
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 86 - Number 9
Year of Publication: 2014
Authors: Gholam Ali Nejad Haj Ali Irani, Ali Akbarpour Bonab
10.5120/15016-3302

Gholam Ali Nejad Haj Ali Irani, Ali Akbarpour Bonab . New Patterns for Reducing Number of Access to Database in Layered Information Systems. International Journal of Computer Applications. 86, 9 ( January 2014), 40-43. DOI=10.5120/15016-3302

@article{ 10.5120/15016-3302,
author = { Gholam Ali Nejad Haj Ali Irani, Ali Akbarpour Bonab },
title = { New Patterns for Reducing Number of Access to Database in Layered Information Systems },
journal = { International Journal of Computer Applications },
issue_date = { January 2014 },
volume = { 86 },
number = { 9 },
month = { January },
year = { 2014 },
issn = { 0975-8887 },
pages = { 40-43 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume86/number9/15016-3302/ },
doi = { 10.5120/15016-3302 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T22:03:48.451606+05:30
%A Gholam Ali Nejad Haj Ali Irani
%A Ali Akbarpour Bonab
%T New Patterns for Reducing Number of Access to Database in Layered Information Systems
%J International Journal of Computer Applications
%@ 0975-8887
%V 86
%N 9
%P 40-43
%D 2014
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Nowadays, most information systems are developing based on layered architectures. Connecting to database is the most important part of layered architectures and there are many connections to database. So, the performance of information systems can be improved by reducing the number of such connections. For this purpose, new patterns have proposed; also solution domain and structure of provided patterns have been explained by practical examples. Finally, reusability and performance of provided patterns have been examined and the results approve the productivity of provided patterns in comparison with previous methods. As a future work, a standard and reusable category of patterns will be reached by developing and categorizing other new patterns.

References
  1. S. Diev, Number 2, 2006. Software Estimation in the Maintenance Context, ACM SIGSOFT Software Engineering Notes, Volume 31.
  2. M. Fowler, D. Rice, M. Foemmel, E. Hieatt, R. Mee, R. Stafford, 2002. Patterns of Enterprise Application Architecture, Addison Wesley.
  3. A. Passi, ?V. Ajvaz, 2009 Oracle E-Business Suite Development & Extensibility Handbook, Oracle Press.
  4. Microsoft Patterns & Practices Team, 2009 Microsoft Application Architecture Guide, Second Edition, Patterns and Practices, Microsoft Press.
  5. M. Rosenblum, ?D. Delmolino, ?L. Cunningham, 2011 et al, Expert PL/SQL Practices: for Oracle Developers and DBAs, Apress.
  6. D. Comingore, D. Hinson, 2007. Professional SQL Server 2005 CLR Programming: with Stored Procedures, Functions, Triggers, Aggregates, and Types, Wiley Press.
  7. J. Gennick, 2005. Oracle SQL*Plus: The Definitive Guide, O'Reilly Press.
  8. B. Meyer, 1994. Object Oriented Software Construction, Second Edition, Prentice Hall International Series in Computer Science.
  9. J. Goodson, R. A. Steward, 2009. The Data Access Handbook Achieving Optimal Database Application Performance and Scalability, Pearson Education.
  10. Full source codes are available online at: http://www. 4shared. com/zip/YYyqCRb4/OMP-Final_Source_Codes. html
Index Terms

Computer Science
Information Sciences

Keywords

Software Analysis and Design Three Layer Software Architecture Quality Attributes XML.