For the development of healthcare information systems, an effective system of interaction between means of storing and processing structured and unstructured data is important. The paper describes the ways of reconciling the object and relational approaches to data processing between the application and the DBMS as suggested by the NORM methodology. It also describes the use of tabular modules for constructing data warehouses through the example of the new version of the Interin IPS platform for PostgreSQL.
References
1. Stonebraker M, et al. Third Generation Database System Manifesto. ACM SIGMOD Record. 1990; 19(3) : 31-34
2. Atkinson M, et al. The Object-Oriented Database System Manifesto. Proc. 1st Int. Conf. on Deductive and Object-Oriented Databases. Kyoto, Japan, 1989. New York, N.Y.: Elsevier Science, 1990.
3. Date CJ, Darwen H. Foundation for Object/Relational Databases: The Third Manifesto (2d edition). Reading, Mass.: Addison-Wesley, 2000.
4. Date CJ. Introduction to Database Systems, М., 2006. (In Russ).
5. Kuznetsov SD Object Oriented Databases — Basic Concepts, Organization and Management: An Overview. CIT Forum. (In Russ). Available at: http://citforum.ru/database/articles/art_24.shtml. Last accessed on : Oct 20 , 2021.
6. Kuznetsov SD Three Database Manifestos: Retrospective and Per spective. CIT Forum. ( In Russ ). Available at: http :// citforum. ru / database / articles / manifests. Last accessed on: Oct 20 , 2021.
7. Databases. Glo bal trends in Russia (In Russ). Available at: https :// habr. com / ru / post /533880. Last accessed on: Oct 20 , 2021.
8. DB - Engines Ranking. Available at: https :// db - engines. com / en / ranking.
9. Meyer В. The Future of Object Technology. IEEE Computer. 1998; 31(1) : 140-141.
10. Scott W. Ambler: Mapping Objects to Relational Databases: O/R Mapping In Detail. Available at: http://www.agiledata.org/essays/mappingObjects.html.
11. Kincaid T. Exploring Eliminating the ORM from Your Next PostgreSQL Application — Feb 23, 2021. Available at: https://www.enterprisedb.com/blog/how-no-object-relational-mapping-norm-improves-application-performance-postgre sql.
12. Dombrovskaya H, Novikov B, Bailliekova A. PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries — Apress , Berkeley, CA, 2021.
13. Healthca re Information System « Interin ». (In Russ). Available at: http://www.interin.ru.
14. Belyshev DV, Kochurov EV. Analysis of Data Storage Methods for Modern Healthcare Information Systems. Program systems: theory and applications. 2016; 2(29): 85-103. (In Russ).
15. Belyshev DV, Kochurov EV. Advanced Methods of Data Management in Healthcare Information Systems. Program systems: theory and applications, 2016; 3(30): 79-97. (In Russ).
16. Register of normative and reference information of the Ministry of Health of Russia (In Russ).
2. Atkinson M, et al. The Object-Oriented Database System Manifesto. Proc. 1st Int. Conf. on Deductive and Object-Oriented Databases. Kyoto, Japan, 1989. New York, N.Y.: Elsevier Science, 1990.
3. Date CJ, Darwen H. Foundation for Object/Relational Databases: The Third Manifesto (2d edition). Reading, Mass.: Addison-Wesley, 2000.
4. Date CJ. Introduction to Database Systems, М., 2006. (In Russ).
5. Kuznetsov SD Object Oriented Databases — Basic Concepts, Organization and Management: An Overview. CIT Forum. (In Russ). Available at: http://citforum.ru/database/articles/art_24.shtml. Last accessed on : Oct 20 , 2021.
6. Kuznetsov SD Three Database Manifestos: Retrospective and Per spective. CIT Forum. ( In Russ ). Available at: http :// citforum. ru / database / articles / manifests. Last accessed on: Oct 20 , 2021.
7. Databases. Glo bal trends in Russia (In Russ). Available at: https :// habr. com / ru / post /533880. Last accessed on: Oct 20 , 2021.
8. DB - Engines Ranking. Available at: https :// db - engines. com / en / ranking.
9. Meyer В. The Future of Object Technology. IEEE Computer. 1998; 31(1) : 140-141.
10. Scott W. Ambler: Mapping Objects to Relational Databases: O/R Mapping In Detail. Available at: http://www.agiledata.org/essays/mappingObjects.html.
11. Kincaid T. Exploring Eliminating the ORM from Your Next PostgreSQL Application — Feb 23, 2021. Available at: https://www.enterprisedb.com/blog/how-no-object-relational-mapping-norm-improves-application-performance-postgre sql.
12. Dombrovskaya H, Novikov B, Bailliekova A. PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries — Apress , Berkeley, CA, 2021.
13. Healthca re Information System « Interin ». (In Russ). Available at: http://www.interin.ru.
14. Belyshev DV, Kochurov EV. Analysis of Data Storage Methods for Modern Healthcare Information Systems. Program systems: theory and applications. 2016; 2(29): 85-103. (In Russ).
15. Belyshev DV, Kochurov EV. Advanced Methods of Data Management in Healthcare Information Systems. Program systems: theory and applications, 2016; 3(30): 79-97. (In Russ).
16. Register of normative and reference information of the Ministry of Health of Russia (In Russ).
For citation
Belyshev D.V., Kochurov E.V. Modular data warehouses in the Interin Ips platform for Postgre sql. Medical doctor and information technology. 2021; S5: 32-43. (In Russ.). doi : 1025881/18110193_2021_S5_32.
Keywords