Novosibirsk State University Journal of Information Technologies|
ISSN 2410-0420 (Online), ISSN 1818-7900 (Print)
ORM queries optimization using the Autofetch technology by the example of university informational system (UIS)
F. N. Yudanov
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
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
© 2006-2017, Novosibirsk State University.