Autors: Rozeva, A. G.
Title: Data Warehousing – Conceptual Scheme Design and Mapping into Relational Logical Scheme
Keywords: Data warehouse design, Conceptual scheme, Multidimensional model, Star scheme, Scheme generation

Abstract: The paper deals with data warehouse design issues concerning conceptual modeling and implementation by generating a logical scheme. Data warehouse system is intended to synthesize information from multiple operational sources making it suitable for direct querying and analysis for the sake of decision making. The synthesis of information and its representation from data warehouse centric perspective which is the multidimensional one is accomplished by implementing the multidimensional conceptual model into a conceptual scheme. Further logical modeling and respective logical scheme generation provides for data warehouse complex querying and analytical processing. Conceptual scheme for an operational retail database has been designed and it’s mapping into star scheme at logical level performed. Application issues concerning conceptual scheme elements’ and semantics’ formalization as well as mapping procedures have been presented

References

    Issue

    Proceedings of the International Conference Automatics and Informatics’06, pp. 149-152, 2006, Bulgaria, САИ Union of automation and informatics, ISBN ISBN -10: 954-9641-48-1 ISBN -13: 954-9641-48-6

    Full text of the publication

    Вид: публикация в международен форум, публикация в реферирано издание, индексирана в Google Scholar