Technology Integration of Information Resources

Major: Information Systems and Technologies
Code of subject: 7.126.01.E.017
Credits: 5.00
Department: Information Systems and Networks
Lecturer: Ph.D., Associate Professor Basyuk Taras Mykhailovych
Semester: 2 семестр
Mode of study: денна
Мета вивчення дисципліни: The purpose of teaching the discipline is to study the main technologies of information resource integration, to get acquainted with various integration systems and methods of data transmission in order to successfully perform professional duties in the specialty. Formation of students in-depth theoretical and practical knowledge of data integration, in particular: concepts and principles of system integration, typical architectures of data integration systems, well-known solutions of leading software companies for system integration, methods of data transfer between different systems and service-oriented architecture of information systems integration.
Завдання: FCS 1.2. The ability to effectively choose appropriate directions and appropriate methods for solving problems in the field of information technologies and distributed systems of databases and knowledge.
Learning outcomes: PR1.2. The ability to develop knowledge bases in the conditions of designing intelligent systems with the help of appropriate software, using survey results, requests, features of the chosen method of presenting knowledge.
Required prior and related subjects: Security of distributed information systems Practice on the subject of the master's qualification work Data and knowledge engineering Distributed information systems
Summary of the subject: The knowledge gained in the process of studying this discipline consists in studying the main technologies and methods of integration (GAV (Global As View), LAV (Local As View), ETL (Extract, Transform and Load), EII (Enterprise Information Integration), EAI (Enterprise Application Integration) and ECM (Enterprise Content Management), integration of enterprise information systems and modern data integration tools (IBM WebSphere, Oracle Data Integrator).
Опис: Introduction to data integration technologies Technologies and methods of data integration ETL technology (Extract, Transform and Load) Integration of corporate applications. EAI technology ECM (Enterprise Content Management) technology EII technology (Enterprise Information Integration EDI technology (Electronic Data Interchange) Integration of enterprise information systems
Assessment methods and criteria: Diagnostics of knowledge is carried out by evaluating the completed laboratory work and examination control (written and oral components) in the form of test questions of three levels of difficulty.
Критерії оцінювання результатів навчання: • Current control (40%): written reports on laboratory work, essay, oral examination; • Final control (60% of exam): in written, verbally
Порядок та критерії виставляння балів та оцінок: 100–88 points – (“excellent”) is awarded for a high level of knowledge (some inaccuracies are allowed) of the educational material of the component contained in the main and additional recommended literary sources, the ability to analyze the phenomena being studied in their interrelationship and development, clearly, succinctly, logically, consistently answer the questions, the ability to apply theoretical provisions when solving practical problems; 87–71 points – (“good”) is awarded for a generally correct understanding of the educational material of the component, including calculations, reasoned answers to the questions posed, which, however, contain certain (insignificant) shortcomings, for the ability to apply theoretical provisions when solving practical tasks; 70 – 50 points – (“satisfactory”) awarded for weak knowledge of the component’s educational material, inaccurate or poorly reasoned answers, with a violation of the sequence of presentation, for weak application of theoretical provisions when solving practical problems; 49-26 points - ("not certified" with the possibility of retaking the semester control) is awarded for ignorance of a significant part of the educational material of the component, significant errors in answering questions, inability to apply theoretical provisions when solving practical problems; 25-00 points - ("unsatisfactory" with mandatory re-study) is awarded for ignorance of a significant part of the educational material of the component, significant errors in answering questions, inability to navigate when solving practical problems, ignorance of the main fundamental provisions.
Recommended books: 1. Loshin D. ETL (Extract, Transform, Load) // Business Intelligence. Morgan Kaufmann, 2012. – 400 p. – ISBN 978-0-12-385890-0. 2. Ahmed K. Elmagarmid, Panagiotis G. Ipeirotis, Vassilios S. Verykios. Duplicate Record Detection: A Survey. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, VOL. 19, NO. 1, JANUARY 2007. 3. Ralph Kimball, Joe Caserta. The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data. – John Wiley & Sons, 2004. – 528 p. –ISBN 978-0-764-56757-5. 4. David Haertzen. ETL Tools // The Analytical Puzzle: Profitable Data Warehousing, Business Intelligence and Analytics. – Technics Publications, 2012. – 346 p. – ISBN 978-1-935504-20-7. 5. Application Integration Architecture [Electronic Resource] - Mode of access: http://www.oracle.com/applications/oracle-application-integration-architecture.html 6. Data Integration – Fusion Middleware – Oracle [Electronic Resource] – Mode of access: http://www.oracle.com/products/middleware/odi/index.html
Уніфікований додаток: Lviv Polytechnic National University ensures the realization of the right of persons with disabilities to obtain higher education. Inclusive educational services are provided by the Service of accessibility to learning opportunities "Without restrictions", the purpose of which is to provide permanent individual support for the educational process of students with disabilities and chronic diseases. An important tool for the implementation of the inclusive educational policy at the University is the Program for improving the qualifications of scientific and pedagogical workers and educational and support staff in the field of social inclusion and inclusive education. Contact at: St. Karpinsky, 2/4, 1st floor, room 112 E-mail: nolimits@lpnu.ua Websites: https://lpnu.ua/nolimits https://lpnu.ua/integration
Академічна доброчесність: The policy regarding the academic integrity of the participants of the educational process is formed on the basis of compliance with the principles of academic integrity, taking into account the norms "Regulations on academic integrity at the Lviv Polytechnic National University" (approved by the academic council of the university on June 20, 2017, protocol No. 35).