ETL Process (Extraction, Transformation, and Loading)

Extracting data from source systems and bringing it into the data warehouse is commonly called ETL (Extract-Transform-Load)

Methodlogy can be vary but the process remains same

Usually all the three phases execute in parallel since the data extraction takes time, so while the data is being pulled another transformation process executes, processing the already received data and prepares the data for loading and as soon as there is some data ready to be loaded into the target, the data loading kicks off without waiting for the completion of the previous phases.(Wiki, 2015)

References

http://docs.oracle.com/cd/B19306_01/server.102/b14223/ettover.htm

http://en.wikipedia.org/wiki/Extract,_transform,_load

MVC Architecture ~ Introduction ~

MVC stands for Model-View-Controller .Simply it is another kind of development architecture which seperates user attraction interfaces and business layers (which is logics ,services, functions,objects and etc..)

• VIEW ? 

View it the part which responsible for communicate with the users of application.It is responsible only for show data & get data from the users . If its doing more than that you are wrong !

• CONTROLLER ?

Responsible for send data to the associated view and update the ‘model’ state.

• MODEL ?  

Manages data ,functions which means response according to requests from the controller and view .