Data loading: Difference between revisions

Revision as of 13:04, 10 February 2024

Revision as of 13:05, 10 February 2024

Line 21:

=== Tricle feed ===

Tricle feed or trickle loading means that when the source system is updated, the changes in the target system will occur almost immediately.<ref>{{Cite encyclopedia |chapter=Near Real-Time Data Warehousing with Multi-stage Trickle and Flip |publisher=Springer Berlin Heidelberg |chapter-url=http://link.springer.com/10.1007/978-3-642-24511-4_6 |date=2011 |volume=90 |pages=73–82 |doi=10.1007/978-3-642-24511-4_6 |author=Zuters, Janis |editor1=Grabis, Janis |editor2=Kirikova, Marite |title=Perspectives in Business Informatics Research |quote=a data warehouse typically is a collection of historical data designed for decision support, so it is updated from the sources periodically, mostly on a daily basis. today's business however asks for fresher data. real-time warehousing is one of the trends to accomplish this, but there are a number of challenges to move towards true real-time. this paper proposes `'multi-stage trickle {\&}and flip' methodology for data warehouse refreshment. it is based on the `'trickle {\&}and flip' principle and extended in order to further insulate loading and querying activities, thus enabling both of them to be more efficient. |isbn=978-3-642-24510-7}}</ref><ref>{{Cite web |title=Trickle Loading Data |url=https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/TrickleLoading/TrickleLoadingData.htm |access-date=2023-02-18}}</ref>

== Loading to systems that are in use ==