Volume 10 Number 3 (Jul. 2021)
Home > Archive > 2021 > Volume 10 Number 3 (Jul. 2021) >
IJCCE 2021 Vol.10(3): 68-74 ISSN: 2010-3743
DOI: 10.17706/IJCCE.2021.10.3.68-74

A Critical Review of SQL-Based Mining Relational Database

Yuexiao Teng
Abstract—Mining database aims to discover hidden, yet potentially useful knowledge in database and it has many applications. SQL-based mining relational database is one of its branches, which takes advantage of Standard Query Language to mine datasets. However, due to the little survey research emphasis on this very specific area, currently few literature review has been conducted to investigate, summarize or critique this field. In order to fill this existing gap, in this paper, an original critical review has been carried out, which is based on academic research papers since 1990. To author’s best knowledge, it is the first time to conduct such a review in a critical way regarding SQL-based mining relational database. This review highlights a strong point and a point of improvement and organized in a reversely chronologic order. The review result shows that since 1990, there have been some research work done to mine relational database by SQL. Almost all of it was empirical and some of it was based on the extension of the standard SQL, however all of research or proposed systems did not support distributed relational databases.

Index Terms—Data mining, mining relational database, SQL, review.

Yuexiao Teng is with East China University of Science and Technology, Shanghai, China.

Cite:Yuexiao Teng, "A Critical Review of SQL-Based Mining Relational Database," International Journal of Computer and Communication Engineering vol. 10, no. 3, pp. 68-74, 2021.

Copyright © 2021 by the authors. This is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited (CC BY 4.0).

General Information

ISSN: 2010-3743 (Online)
Abbreviated Title: Int. J. Comput. Commun. Eng.
Frequency: Quarterly
Editor-in-Chief: Dr. Maode Ma
Abstracting/ Indexing: INSPEC, Google Scholar, Crossref, EBSCO, ProQuest, and Electronic Journals Library
E-mail: ijcce@iap.org
  • Jun 20, 2019 News!

    IJCCE Vol. 6, No. 3 - Vol. 7, No. 3 have been indexed by EI (Inspec) Inspec, created by the Institution of Engineering and Tech.!   [Click]

  • Jun 10, 2021 News!

    IJCCE Vol.10, No.3 is published with online version!   [Click]

  • Mar 12, 2021 News!

    IJCCE Vol.10, No.2 is published with online version!   [Click]

  • Dec 09, 2020 News!

    IJCCE Vol.10, No.1 is published with online version!   [Click]

  • Sep 23, 2020 News!

    IJCCE Vol.9, No.4 is published with online version!   [Click]

  • Read more>>