Novosibirsk State University Journal of Information Technologies
Scientic Journal

ISSN 2410-0420 (Online), ISSN 1818-7900 (Print)

Switch to
Russian

All Issues >> Contents: Volume 07, Issue No 2 (2009)

ORM queries optimization using the Autofetch technology by the example of university informational system (UIS)
F. N. Yudanov

Abstract
The current article describes the research work to optimize enterprise level informational system. The optimizations were focused on persistence layer based on ORM tool (Object Relational Mapping − a programming technique for converting data between incompatible type systems in relational databases and object-oriented programming languages). The main line of investigation was to determine the efficacy of such optimization type as data prefetching in ORM queries to minimize the number of interactions with database and to solve so-called «N + 1 select problem». The most of optimizations were made using the Autofetch library. All researches were based on University Informational System (UIS) − the development of CNIT (Center of New Informational Technologies) NSU. The system is currently in exploitation in NSU and a few other organizations.

Full Text in Russian

Available in PDF

Publication information
Main title Vestnik NSU Series: Information Technologies, Volume 07, Issue No 2 (2009).
Parallel title: Novosibirsk State University Journal of Information Technologies Volume 07, Issue No 2 (2009).

Key title: Vestnik Novosibirskogo gosudarstvennogo universiteta. Seriâ: Informacionnye tehnologii
Abbreviated key title: Vestn. Novosib. Gos. Univ., Ser.: Inf. Tehnol.
Variant title: Vestnik NGU. Seriâ: Informacionnye tehnologii

Year of Publication: 2009
ISSN: 1818-7900 (Print), ISSN 2410-0420 (Online)
Publisher: Novosibirsk State University Press
DSpace handle


|Home Page| |All Issues| |Information for Authors| |Journal Boards| |Ethical principles| |Editorial Policy| |Contact Information| |Old Site in Russian|

inftech@vestnik.nsu.ru
© 2006-2017, Novosibirsk State University.