An alternative solution of skyline operation to reduce computational complexity

P. Ghosh, S. Sen
{"title":"An alternative solution of skyline operation to reduce computational complexity","authors":"P. Ghosh, S. Sen","doi":"10.1109/ICRCICN.2016.7813676","DOIUrl":null,"url":null,"abstract":"Single-criteria decision making queries can be answered using simple SQL queries, however a multi-criteria decision making problems are often not answered by normal SQL queries. In order to solve these types of queries we may need to use co-operative query languages etc. However using additional query based system incurs extra cost. Moreover, if the criteria in a query are complementary to each other simple SQL queries are not capable of addressing this issue. A query in which multi-criteria decision making is required, often more than a single attribute of the relation is analyzed to fetch the desired result. In this context dominance analysis is performed to obtain a set of points (tuples) those are at least equally good in all the dimensions in compare to other points in the dataset. Skyline points are computed to find points which are not dominated (dominance analysis) by any other point in the system. A point is called “skyline point” if and only if it is not dominated by any other points in the system. Computation of skyline requires comparison of each point to all the other points in the system which in turn increases complexity. The complexity may increase at exponential rate when the numbers of dimensions increase. This research work focuses on the reduction of computational complexity. It is incorporated here by selecting the most important dimension of the database and transfers the other entire dimension in that form. And finally ranks the points accordingly.","PeriodicalId":254393,"journal":{"name":"2016 Second International Conference on Research in Computational Intelligence and Communication Networks (ICRCICN)","volume":"28 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2016-09-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"4","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"2016 Second International Conference on Research in Computational Intelligence and Communication Networks (ICRCICN)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICRCICN.2016.7813676","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 4

Abstract

Single-criteria decision making queries can be answered using simple SQL queries, however a multi-criteria decision making problems are often not answered by normal SQL queries. In order to solve these types of queries we may need to use co-operative query languages etc. However using additional query based system incurs extra cost. Moreover, if the criteria in a query are complementary to each other simple SQL queries are not capable of addressing this issue. A query in which multi-criteria decision making is required, often more than a single attribute of the relation is analyzed to fetch the desired result. In this context dominance analysis is performed to obtain a set of points (tuples) those are at least equally good in all the dimensions in compare to other points in the dataset. Skyline points are computed to find points which are not dominated (dominance analysis) by any other point in the system. A point is called “skyline point” if and only if it is not dominated by any other points in the system. Computation of skyline requires comparison of each point to all the other points in the system which in turn increases complexity. The complexity may increase at exponential rate when the numbers of dimensions increase. This research work focuses on the reduction of computational complexity. It is incorporated here by selecting the most important dimension of the database and transfers the other entire dimension in that form. And finally ranks the points accordingly.
一种降低计算复杂度的天际线运算替代方案
单标准的决策查询可以用简单的SQL查询来回答,但是多标准的决策问题通常不能用普通的SQL查询来回答。为了解决这些类型的查询,我们可能需要使用协作查询语言等。然而,使用额外的基于查询的系统会产生额外的成本。此外,如果查询中的条件是相互补充的,则简单的SQL查询无法解决此问题。需要进行多标准决策的查询,通常需要分析关系的多个属性来获取所需的结果。在这种情况下,执行优势分析以获得一组点(元组),这些点(元组)与数据集中的其他点相比,在所有维度上至少同样好。计算天际线点是为了找到不受系统中任何其他点支配的点(支配分析)。一个点被称为“天际线点”,当且仅当它不受系统中任何其他点的支配。计算天际线需要将每个点与系统中的所有其他点进行比较,这反过来又增加了复杂性。当维数增加时,复杂性可能以指数速率增加。本研究的重点是降低计算复杂度。这里通过选择数据库中最重要的维度并以该形式传输其他整个维度来合并它。最后对分数进行排序。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
求助全文
约1分钟内获得全文 求助全文
来源期刊
自引率
0.00%
发文量
0
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
copy
已复制链接
快去分享给好友吧!
我知道了
右上角分享
点击右上角分享
0
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:604180095
Book学术官方微信