|
Dynamic contexts of relational-type database
S. V. Zykin Sobolev Institute of Mathematics, Siberian Branch of the Russian Academy of Sciences, 4 Acad. Koptyug Av., Novosibirsk 630090,Russian Federation
Abstract:
The technology of dynamic formation of data presentation is sugessted. This technology is the development of online analytical processing. Data source is a relational database with any scheme (not necessarily hierarchical). Target data presentation is a composite table which allows to present multivariate data on a plane. This table assumes separate formation of dimensions with the following juxtaposition of measures to dimensions in the table. The foundation of data presentation is a table of connected joins, which satisfies contextual and logic restrictions. The algorithms used to form such tables are suggested and their properties are investigated. Special attention is given to contexts which are used to form tables of connected joins. The algorithm of directed search for creation of contexts is proposed and comparative analysis of algorithms of contexts formation is performed on an example. The investigated properties of contexts and the offered algorithms are intended to automate user work to form new data presentations.
Keywords:
relational database; context; lossless join; composite table.
Received: 09.01.2013
Citation:
S. V. Zykin, “Dynamic contexts of relational-type database”, Inform. Primen., 8:1 (2014), 77–88
Linking options:
https://www.mathnet.ru/eng/ia300 https://www.mathnet.ru/eng/ia/v8/i1/p77
|
|