The week's pick
Random Articles
Reseach Article
Implementation of Object Oriented Data Warehousing using a Narrower Compassed Data Model in Oracle 10g
| International Journal of Computer Applications |
| Foundation of Computer Science (FCS), NY, USA |
| Volume 17 - Number 5 |
| Year of Publication: 2011 |
| Authors: K.G. Verma, Brajesh Kumar Kaushik, Raghuvir Singh |
10.5120/2215-2821
|
K.G. Verma, Brajesh Kumar Kaushik, Raghuvir Singh . Implementation of Object Oriented Data Warehousing using a Narrower Compassed Data Model in Oracle 10g. International Journal of Computer Applications. 17, 5 ( March 2011), 20-25. DOI=10.5120/2215-2821
Abstract
A data warehouse (DW) is a database used for reporting Paper describes Object Oriented Data Warehousing using a narrower compassed data model. The data is offloaded from the operational systems for reporting. The data may pass through an operational data store for additional operations before it is used in the Data warehousing for reporting. An Object Oriented Data Warehouse system includes a data warehouse and underlying data sources. A narrower compassed model is used for storing the data in Object Oriented Data warehouse. Oracle 10g Language is specifically used for the programming. Object Oriented Data Warehousing provides complex objects which include multiple atomic types and user defined object types. The steadiness between the data warehouse and the source databases is maintained by certain algorithms such as insertion, deletion and update. In the past research work on data warehouse was primarily focused on relational data models. The concept of object oriented data warehousing is introduced and implementation of Object oriented data warehouse in oracle 10g. Data model will form new classes according to the definition of views such that query performance & security can be improved.
References
- S. Chaudhuri and U. Dyal, “An overview of Data warehousing and OLAP Technology”, ACM SIGMOD record, vol 21, no.1.
- W.C. Chen, T.P Hong and W.Y. Lin, “Object- Oriented data warehousing and its maintenance technology”, technical note, 1998.
- W.C. Chen, T.P Hong and W.Y. Lin, “View maintenance in an object oriented data warehousing”, Proceeding of the Fourth international conference on computer science and informatics, North Carolina, USA, pp 353-356, 1998.
- N.Hyun, “Efficient self maintenance of materialized views”, Technical note, 1996.
- W.C chen, “Object Oriented data warehousing and its maintenance technologies, Master Dissertation, I-Shou University, Taiwan, R.O.C April, 1999.
- Dobrovnik M., Eder J.: Logical data independence and modularity through views in OODBMS. Proceedings of the Engineering Systems Design and Analysis Conference, Vol. 2, 1996, pp. 13-20
- Dobrovnik M., Eder J.: Partial Replication of Object–Oriented Databases. Proceedings of the Second East-European Conference on Advances in Databases and Information Systems – ADBIS'98. Poland, 1998, LNCS No. 1475, pp. 260-271
- Eder J., Frank H., Liebhart W.: Optimization of Object–Oriented Queries by Inverse Methods. Proceedings of East/West Database Workshop, Austria, 1994
- Gupta A., Mumick I.S. (eds.): Materialized Views: Techniques, Implementations, and Applications. The MIT Press, 1999.
- GRAY W. HANSEN.JAMES V.HANSEN, “Data Base Management System”.
- N.Huyn. “Efficient view self maintenance” Proceeding of the ACM Workshop on Materialized Views, Monteral, Canada, June7, 1996.
- N. Huyn. ”Efficient self-maintenance of materialized views,” Technical Note, 1996.
- N. Huyn. “Multiple-view self-maintenance in data warehousing environments,” Proceedings of the 23d CZDB Conference, Athens, Greece, 1997.
- W. H. Inmon and C. Kelley, RdbMS: Developing The Data Warehouse, QED Publishing Group, Boston, Massachusetts, 1 993.
- W. J. Labio and H. Garcia-Molina. “Efficient snapshot differential algorithms for data warehousing,’’ Procwdings of VZDB Conference, Mumbai, India, September 1996, pp.
- W. J. Labio, Y. Zhuge, J. L. Wiener, H. Gupta, H. Garcia- Molina and J. Widom. “The W ” S prototype for data warehouse creation and maintenance,” Proceedings of the ACMSIGMOD Conference, Tuscon, Arizona, May 1997.
- W. Kim, ”Modern Database Systems”, ACM Press. New York, New York, 1995.
- I. Mumick, D. Quass and B. Mumick. “Maintenance of data cubes and summary tables in a warehouse,” Proceedings of the ACM SIGMOD Conference, Tucson, Arizona, May, 1997.
- P. O’Neil and D. Quass. “Improved query performance with variant indexes,” Proceedings of the ACM SIG\IOD Conference, Tucson, Arizona, May, 1997.
- D. Quass. Maintenance expressions for views with aggregation,” Proceedings of the ACM Workshop on Materialized Ems, Montreal, Canada, June 7, 1996.
- D. Quass, A. Gupta, I. S. Mumick, and J. Widom “Making views self-maintainable for data warehousing,” Proceedings of the Conference on Parallel and Distributed Information Systems, Miami Beach, FL, December 1996.
- Y. G. Ra, E. A. Rundensteiner, “A Transparent Schema- Evolution System Based on Object-Oriented View Technology”, IEEE Transaction on Knowledge and Data Engineering, Vol. 9, No. 4,600-624.
- E. A. Rundensteiner, “A Methodology for supporting Multiple Views in Object-Oriented Databases”, Proceedings of 18th International Conference on Very Large Data Bases 1992, Vancouver, Canada, 187-198.
- M. H. Scholl, C. Laasch, M. Tresch, “Updateable Views in Object-Oriented Databases”, Second International Conference on Deductive and Object-Oriented Databases, Munich, Germany, 1991, 189-207.
- J. Widom, “Research problems in data warehousing, ”Proceedings of the 41h Int’l Conference on Information and Knowledge Management, November 1995.
- Y. Zhuge and H. Garica-Molina. “Graph structured views and their incremental maintenance,” Proceedings of the International Conference on Data Engineering, Orlando, FL, 1998.
- Y. Zhuge, H. Garcia-Molina, J. Hammer and J. Widom, “View maintenance in a warehousing environment” Proceedings of the ACM SIGMOD Conference, San Jose, California, May 1995. Y. Zhuge, H. Garcia-
Index Terms
Keywords