An Optimized algorithm to select the appropriate Schema in Data Warehouses
Journal Title: International Journal of Engineering Sciences & Research Technology - Year 30, Vol 1, Issue 4
Abstract
The successful organization is the result of the successful decisions made by the top management. These are the collaborated decisions and require a lump sum data or the consolidated view of organization, which is provided by data warehousing system. These systems are used as an organization repository to support strategic decision making. Data schema represents the arrangement of fact table and dimension tables and the relations between them. In data warehouse development, selecting a right and appropriate has an important Impact on performance and usability of the designed data warehouse. One of the problems that exist in data warehouse development is lack of a comprehensive and sound selection framework to appropriate schema for the data warehouse at hand by considering application domain research work, presents a stepwise algorithm for schema selection, which solves the problem of choosing right schema for a data warehouse. The main selection criteria are query type, attribute type, dimension table type and existence of index. Authors also tried to described efficient way of answering queries that are coming from multiple classes of users
Authors and Affiliations
Rahul Kumar Shrivastava
Keywords
Related Articles
- EP ID EP164188
- DOI -
- Views 61
- Downloads 0
Analysis of Diverse Reversible Watermarking Methods in Image Processing
Watermarking is the current area of research in Image Processing. Since, there would be need that the data may be image, text, video and so on transferred via internet to be more secure and helps to hide something...
Performance Prediction Methods for Reducing Losses in Intermediate Pressure Steam Turbine by Using Steam Path Appraisal
Quality of fuel is of paramount importance for producing quality of steam which finally affects the performance of thermal power plant. This not only hampers the performance of turbine but also helps to reduce the...
LOW POWER DESIGN METHODOLOGY FOR ARITHMETIC CIRCUITS
In this paper a modified Constant Delay Logic is been proposed to provide improved performance. Continues scaling in technology of VLSI circuits leads to increase in power consumption. Therefore designing a VLSI c...
Development and Study of Properties of Natural Fiber Reinforced Polyester Composites
Fiber reinforced composites offer varied advantages in various applications. Today fiber composites aeronautically used in such diverse applications as automobiles, aircraft, space vehicles, offshore structures, c...
A NOVEL BOTNET DETECTION SYSTEM TO IDENTIFY RESILIENT P2P-BOTNET
Peer-to-peer (P2P) botnets are the modern and most resilient bot structures which are harder to take down and stealthier to detect their malicious activities, because of which these are adopted by many of the recent bot...