Consolidating database

The other techniques are data propagation, which includes data replication, and data federation which enables the viewing of consolidated files.The third data integration technique, data consolidation, consists of two technologies: Extract, Transform and Load (ETL) and Extract, Load and Transform (ELT), which will be discussed later in this lesson.Data consolidation involves the collection of a vast amount of data or information from several networked servers, usually belonging to a company, organization or enterprise.Data consolidation is actually one of three data integration techniques in use today.As the first, it became the standard for uploading data to data warehouses and other storage facilities.With ETL, data are relocated from variable data sources, and the transformations are applied in the data stream and uploaded to its designated storage container.When completed, the transformed data are combined into a single record within a consolidated database and made available to the user.

Once the transformation is complete, the consolidated data is re-inserted into the database for subsequent research and analysis.As a member, you'll also get unlimited access to over 70,000 lessons in math, English, science, history, and more.Plus, get practice tests, quizzes, and personalized coaching to help you succeed.For instance, assume you want to collect customer records from your photography business and congregate the data into a single accessible table.As the diagram shows, relevant data and information is extracted from multiple sources and the consolidation effort begins.

Search for consolidating database:

consolidating database-65consolidating database-67consolidating database-48consolidating database-32

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “consolidating database”

  1. While this can sometimes make you feel like you are reading a review for some new product – admittedly it can save you many hours of sifting thru less than stellar profiles.