Advantages and Disadvantages of Multidimensional Data Model.

-

Below are the advantages and disadvantages:

Advantages

  • Multi-Dimensional Data Models are workable on complex systems and applications, unlike simple one-dimensional database systems.
  • The Modularity in this type of Database is an encouragement for projects with lower bandwidth for maintenance staff.
  • Overall, organizational capacity and structural definition of the Multi-Dimensional Data Models aid in holding cleaner and more reliable data in the database. 
  • Clearly defined construction of the data placements makes it uncomplicated, in situations like one team constructs the database, another team works on it and some other team works on the maintenance. It serves as a self-learning system if and when required.
  • As the system is fresh and free of junk, the efficiency of the data and performance of the database system is found to be advanced & elevated. 

Disadvantages

  • As the Multi-Dimensional Data Model handles complex systems, these types of databases are typically complex in nature.
  • Being a complex system means the contents of the database are huge in amount as well. This makes the system to be highly risky when there is a security breach.
  • When the system caches due to the operations on the Multi-Dimensional Data Model, the performance of the system is affected greatly.
  • Though the end product in a Multi-Dimensional Data Model is advantageous, the path to achieving it is intricate most of the time.


Comments

Post a Comment

Popular posts from this blog

Short note on E-Government Architecture

-
Image
1)  Presentation layer The presentation layer identifies and describes the system users, who require access to government information at different capacities, and the channels through which information can be accessed.  During system development, one is required to explicitly identify the government user, the system is intended to serve, and also the means through which this information is to be accessed so that the system can be tailored to meet these requirements. It manages the user’s interface with the system. If a pro- project is to be successful, different stakeholders need to be identified at the beginning, involved in the initial stages and kept involved throughout development and implementation. 2) E-government layer E-government public services utilize very specialized applications that are only available to certain agencies and not all agencies participating in the consortium. The main goal of the e-government layer is to achieve a government that;  does not as...
Read more

What is the difference between persistent and transient objects?

-
Image
Object An object is a real-world entity with certain attributes that makes up the object's structure. Also, an object encapsulates the data code into a single unit which in turn provides data abstraction by hiding the implementation details from the user. Any object has two properties i.e. state & behavior hence, it's similar to the program variable but the object has a complex structure. There are two types of objects: Transient object Persistent object Transient object These objects exist during the execution but destroy once the program terminates.  Transient Objects that have been just instantiated. Transient objects don't have representation and identifier values in the databases. The transient objects will be destroyed by the garbage collector if they don't have any use and reference in the database. In this state, the database has the saved objects Example- An entity from a repository comes under persistent objects Persistent object These objects persist ...
Read more

Describe management functions and explain how each of them is interrelated./ Four key functions (planning, organizing, directing and controlling) make up the process of management. It is possible that the controlling function can affect the organizing function and organizing function can affect the leading functions? Explain.

-
Image
   Functions/Process of Management The management system is a system or process of interrelated and sequential components or function of management. The function of management have been specified and defined variously by different authors. Fayol has specified planning, organizing, commanding, coordinating and controlling as the function of management. Likewise, according to Koontz and O'donnell, planning, organizing, developing, coordinating and staffing as the functions of management. According to Linder Urbick, forecasting, planning, organizing, commanding, coordinating and controlling as the function of management. Luther Gulick has summarized the function of management as POSDCORB where P = Planning, O = Organizing, S = CO = Coordinating, R = Reporting and B = Staffing, D = Directing, Budgeting. In general, the following are the functions of management. 1. Planning Planning is the basic function of management. It is outlining the future course of action and decides in adva...
Read more