About the lecture:
Data Warehouse Architecture, Dr Asha Ambhaikar, Department of IT
Data warehouse is for transforming data into the information. How data is transformed to information? What is the process? Both the queries will be answered here. There are 3 layers which are bottom layer, middle layer and top layer. In bottom layer various data warehouse servers are there along with meta data, monitoring integrator and datamarts. We bring the data from operational sources to data ware house
With the help of a software tool which is Extract load and transform which is also called ETL tool, data is processed. The function of ETL tool is to transform the data in to information as per the format of the data warehouse. Converted data or filtered data will be loaded to the data warehouse.
Data mart is the data of the data which is the bridge between the OLAP , the end user server and the data warehouse. The middle layer is the layer which consists of the OLAP, is between the top layer and the bottom layer. It contains all OLAP engines. OLAP engines perform operation of all electrical processors.
It works on the data and transforms it into information. There are different types of OLAP Servers which are MOLAP- Multidimensional Online Analytical Processing, ROLAP- Relational Online Analytical Processing and HOLAP- Hybrid Online Analytical Processing . Hybrid Online Analytical Processing is the combination of MOLAP- Multidimensional Online Analytical Processing and ROLAP-Relational Online Analytical Processing. All these are present in the middle layer. The middle layer is the bridge between the top layer and the bottom layer.
Watch Video Lecture:
Author:
Dr. Asha Ambhaikar
Professor and HoD (Information Technology) & Dean Students Welfare
Kalinga University, Raipur
Degrees: Ph.D. in Computer Science & Engineering, M. Tech and B.E. in Computer Science
Specialties: Mobile Ad-hoc Networks, Data mining and Cloud Computing
Biography
Dr. Prof. Asha Ambhaikar is Professor & Dean Students Welfare at Kalinga University, New Raipur, Chhattisgarh. She is Ph.D. in Computer Science & Engineering, M. Tech and B.E. She has 25 years of Academic experience and has Guided 3 Ph. D. scholars.
She has published more than 75 Research Papers in reputed National and International Journals. Before joining Kalinga University she was holding the post of Principal at G. H. Raisoni College of Engineering, Amravati (Maharashtra). She was holding the posts of Chairman Board of Studies and Member of Academic Council of Information Technology in Chhattisgarh Swami Vivekananda Technical University, Bhilai (C.G.).
Dr. Prof. Asha Ambhaikar has conducted various National and International Conferences (CGCOST), Seminars, Workshops and FDP’s at Institute/University level. She was a member of Selection Committee as a Subject Chairman and Expert. She is a Member of Editorial Board and Reviewer of various reputed International Journals and Conferences.
Dr. Prof. Asha Ambhaikar has also received Awards like Bharat Excellence 2015, Personality of India at New Delhi etc.
She is also member of various professional societies like:
- Life member of IAENG (International Association of Engineers), Hong Kong
- Institute of Electrical and Electronics engineers (IEEE)
- Indian Society of Technical Education (ISTE)
- Computer Society of India (CSI)
- Institute of Engineering and Technology (IET)
- Association of Scientist Developer and Faculties (ASDF)
- Computer Science Teachers Association (CSTA)
- Association for Computing Machinery (ACM), New York, USA
- IACSIT (International Association of Computer Science and Information Technology), Singapore
- Member of SDIWC (The Society of Digital Information and Wireless Communication), USA
Dr. Prof. Asha Ambhaikar has also chaired various National and International Conferences in various countries as a Keynote Speaker and Session Chair. She has also published 4 books in Lambert Publication, Germany and Springer.
