Object Oriented Database Management System for Decision Support System
نویسنده
چکیده
To get best performance for an analytic system or data warehouse systems, two technologies, column oriented database management systems and main memory database management system can be combined to get advantages of these two. Both technologies give best performance to its opponent database system, for example Main memory database management systems are faster as they reside in main memory as compared to disk resident database systems. This is because main memory is faster in comparison to hard drive/disk. The performance of main memory database systems is 15-20 % higher than that of disk resident database systems. Whereas column based database systems are faster than the row based database because in column based database systems, data is stored in columns and indexed as compared to row based database systems. Performance of column based database systems is 15-30% higher than that of row based database systems. It is important to mention about static drive which way faster than conventional hard drives and provide similar performance as of main memory can improve and give best performance if used as hard drive to have database created and maintained on it. By combining these two technologies, we can achieve 30-50% higher performance for analytics systems they needs to be high performing in analysis and computation. Whereas by having databases & data warehouse created and maintained on static drives will further improve performance to ~50-60%
منابع مشابه
Decision Support System for Age-Related Macular Degeneration Using Convolutional Neural Networks
Introduction: Age-related macular degeneration (AMD) is one of the major causes of visual loss among the elderly. It causes degeneration of cells in the macula. Early diagnosis can be helpful in preventing blindness. Drusen are the initial symptoms of AMD. Since drusen have a wide variety, locating them in screening images is difficult and time-consuming. An automated digital fundus photography...
متن کاملDecision Support Systems using Object - Oriented
Object-oriented databases are a relatively new technology that has great potential for a variety of business applications. The primary advantage of the object-oriented database is that it preserves the natural hierarchical structure of the real world, and for certain cases allows more efficient communication between the database application software and the stored data. This thesis examines two...
متن کاملDevelopment of decision support tool for municipal solid waste management system in Iran based on life cycle assessment approach
Background and Objective: Various aspects including the environmental burdens, social and economic consequences of the waste management(WM) scenarios must be considered to come up with a comprehensive WM plan. Life Cycle Assessment (LCA) approach is a systematic method to quantify the environmental burdens of each WM scenario. Materials and Methods: This study used an LCA approach to develop a...
متن کاملClinical Views: Object-Oriented Views for Clinical Databases
We present here a prototype ofa clinical information system for the archiving and the management of multimedia and temporally-oriented clinical data related to PTCA patients. The system is based on an object-oriented DBMS and supports multiple views and view schemas on patients' data. Remote data access is supported too.
متن کاملPresentation Of Pattern Management Information System Requirements Analysis For Recruiting Sport Vollunteers
Volunteer Movement and deliver services to society is phenomenons of coeval universe.The aim of this research work was to present a pattern for Iran`s sports volunteer absorbance management information system requirement analysis. This investigation was of descriptive-analytic sort and in regard for practical goal, it was type of (UML) methodology and it used object-oriented design model (RUP)...
متن کاملData Mart Schema Construction from Object Oriented Databases
This paper proposes a bottom-up method that helps designers of decision support systems to construct data mart schemas based on an object database. Our method extracts the database schema from the repository of the object DBMS in order to work on the most recent version of the transactional system’s data model. It then applies a set of rules to identify facts, measures, dimensions and their att...
متن کامل