Page 173 - DCAP104_EXPOSURE_TO_COMPUTER_DISCPLINES
P. 173

Exposure to Computer Disciplines



                   Notes
                                                       Figure 8.2: Data Warehouse Architecture






















                                 Distributed Database
                                 These are databases of local work-groups and departments at regional offices, branch offices,
                                 manufacturing plants and other work sites. These databases can include segments of both
                                 common operational and common user databases, as well as data generated and used only at a
                                 user’s own site.

                                                          Figure 8.3: Distributed Database





                                                 Local DB
                                                                                Local DB
                                                  Local DB
                                                                                 Local DB
                                                   Seametal Stations              Seametal Stations





                                                                 Backap

                                                                   Central Server  Local DB

                                                    Viewing Stations              Supervising Stations

                                 End-user Database

                                 These databases consist of data developed by individual end-users. Examples of these are
                                 collections of documents in spreadsheets, word processing and downloaded files, even managing
                                 their personal baseball card collection.
                                 External Log Database

                                 These databases contain data collected for use across multiple organizations, either freely or via
                                 subscription. The Internet Movie Database is one example.





        166                               LOVELY PROFESSIONAL UNIVERSITY
   168   169   170   171   172   173   174   175   176   177   178