| 关系数据库中近似查询的自动采样改进方法研究 |
| |
| 引用本文： | 李庆红.关系数据库中近似查询的自动采样改进方法研究[J].娄底师专学报,2011(2):87-90. |
| |
| 作者姓名： | 李庆红 |
| |
| 作者单位： | 株洲职业技术学院信息工程系,湖南株洲412001 |
| |
| 摘 要： | 海量数据的传统精确查询易导致负载过大,而通过改进数据库近似查询自动采样,预先运行样本查询,然后根据每一个元组在样本关系表中出现的次数,将每个元组需要的存储信息作为元组的属性添加进数据表中,并通过DBMS在整个自动抽样过程对它们进行管理,对所得的结果进行分类并统计,得出每次采样过程中某个元组出现的次数,实验表明方法是有效的。
|
| 关 键 词： | 关系数据库 自动采样 SQL |
Research on Improved Method of Automatic Sampling of Approximate Question in Relational Databases |
| |
| LI Qing-Hong.Research on Improved Method of Automatic Sampling of Approximate Question in Relational Databases[J].Journal of Loudi Teachers College,2011(2):87-90. |
| |
| Authors: | LI Qing-Hong |
| |
| Institution: | LI Qing-Hong (Department of Information Engineering,Zhuzhou Professional and Technical College,Zhuzhou 41200,China) |
| |
| Abstract: | Traditional accurate query of mass data is easy to lead to overload.This paper improves the bootstrap method for approximate queries.The sample query is executed in advance,according to the number of every tuple which appears in the sample relation,store information that these tuples need be added into a data table as store information,they are managed by DBMS in the whole bootstrap processing to classify and count obtained results to get the number of certain tuple which appears in every bootstrap processing.The experiment shows that the method is effective. |
| |
| Keywords: | relational database automatic sampling SQL |
| 本文献已被 维普 等数据库收录！ |
|
