Why a Data Warehouse is separated from Operational Databases?

-


A data warehouse is kept separate from operational databases due to the following reasons:

  • Data Warehouse queries are complex because they involve the computation of large groups of data at summarized levels.
  • It may require the use of distinctive data organization, access, and implementation method based on multidimensional views.
  • Performing OLAP queries in an operational database degrade the performance of functional tasks.
  • Data Warehouse is used for analysis and decision making in which extensive database is required, including historical data, which operational database does not typically maintain.
  • The separation of an operational database from data warehouses is based on the different structures and uses of data in these systems.
  • Because the two systems provide different functionalities and require different kinds of data, it is necessary to maintain separate databases.

Comments

Post a Comment

Popular posts from this blog

Short note on Uniform Gradient Cash Flow and PERT

-
 Uniform Gradient Cash Flow If the cash flow has the proper form its present worth can be determined by using the uniform gradient factor(P=G(P/G, i, n). The uniform gradient factor finds the present worth a uniformly increasing cash flow. For example, if the cash flow in period 1 is 2000 and in period 2 is 2100. it would be uniform if the subsequent amounts increased by 100 in each subsequent period. This gradient in this example would be equal to 100. PERT A PERT chart is a project management tool that provides a graphical representation of a project's timeline. The Program Evaluation Review Technique (PERT) breaks down the individual tasks of a project for analysis. PERT charts are considered preferable to Gantt charts in some cases because they identify task dependencies, but they're often more difficult to interpret. A PERT chart allows managers to evaluate the time and resources necessary to manage a project. the Project Evaluation Review Technique, or PERT, is used to id...
Read more

Discuss different JavaFX layouts with suitable example.

-
Image
 JAVAFX LAYOUTS Layout panes are containers that are used for flexible and dynamic arrangements of UI controls within a scene graph of a JavaFX application. As a window is resized, the layout pane automatically repositions and resizes the nodes it contains. JavaFX has the following built-in layout panes: Flow Pane, HBox, VBox, BorderPane, GridPane, StackPane, TilePane, AnchorPane. 1. JAVAFX FlowPane Flow Pane positions nodes in a row or a column, where the nodes are wrapped when they all cannot be shown. The default orientation of a flow pane is horizontal. The class named FlowPane of the package javafx.scene.layout represents the Flow Pane layout. There are 8 constructors in the class that are given below. • FlowPane() • FlowPane (Double Hgap, Double Vgap) • Flow Pane (Double Hgap, Double Vgap, Node? children) • Flow Pane (Node... Children) • Flow Pane (Orientation orientation) • FlowPane(Orientation orientation, double Hgap, Double Vgap) • Flow Pane(Orientation orientation, doubl...
Read more

Discuss classification or taxonomy of virtualization at different levels.

-
Image
Taxonomy of virtualization Virtualization is mainly used to emulate the execution environment, storage, and networks. The execution environment is classified into two: – Process-level – implemented on top of an existing operating system.  – System-level – implemented directly on hardware and does not or minimum requirement of the existing operating system. OR,  Virtualization covers a wide range of emulation techniques that are applied to different areas of computing. A classification of these techniques helps us better understand their characteristics and use  V irtualization is mainly used to emulate  ● Execution Environments: To provide support for the execution of the programs eg. OS, and Application.  ○ Process Level: Implemented on top of an existing OS that has full control of the hardware  ○ System Level: Implemented directly on Hardware and do not require support from existing OS.  ● Storage: Storage vi...
Read more