Expression and Processing of Inductive Queries

The very fast technological progress provokes the creation of a big volume of the astronomical data, which is fed in the different forms. There are various directions in science that use high dimensional data to be analyzed. In this paper we presented the few aspects of the "knowledge discovery in databases" (KDD) process in astronomy, analyzed and reviewed some data mining approaches. We presented the examples of astronomical instruments, data types, astronomical sources of Big Data, processing algorithms, which are used for the knowledge discovery in databases process in astronomy. The paper deals with applying the CoLiTec (Collection Light Technology) software for the online processing of the different types of astronomical data using the knowledge discovery in databases tasks. This is achieved by using of the developed OnLine Data Analysis System (OLDAS), which helps with solving of the knowledge discovery in databases tasks, like selection, transformation, data mining, interpretation, and evaluation.

The thriving medical applications of data mining in the fields of medicine and public health has led to the popularity of its use in knowledge discovery in databases (KDD). Data mining has revealed novel biomedical and healthcare acquaintances for clinical decision making that has great potential to improve the treatment quality of hospitals and increase the survival rate of patients. Disease diagnosis is one of the applications where data mining tools are establishing the successful results. Data mining intends to endow with a systematic survey of current techniques of knowledge discovery in databases using data mining techniques that are in use in today’s medical research. Discussion is made to enable the disease diagnosis and the breakthrough of hidden healthcare patterns from related databases is offered. Also, the use of data mining to discover such relationships as those between health conditions and a disease is presented. It further discusses about the tools that can be used for the processing and classification of data. This paper summarizes various technical articles on medical diagnosis and prognosis. It has also been focused on current research being carried out using the data mining techniques to enhance the disease(s) forecasting process. This research paper provides future trends of current techniques of KDD, using data mining tools for healthcare. It also confers significant issues and challenges associated with data mining and healthcare in general. The research found a growing number of data mining applications, including analysis of health care centers for better health policy-making, detection of disease outbreaks and preventable hospital deaths. The root causes of all diseases get closer towards drugs i.e. the foremost risk factor of all hilarious diseases. Drug addiction using WEKA has been used that brings into light concerning majority of drug abusers started abusing drugs at age below 20yrs.It is to make aware the druggist about the various diseases that are caused with heavy or long term intake of drugs in their life. So, to make an expert system that will awake the youth about precarious use of drugs and also alert the affected person.

The grant program for farmers is one of the government programs provided by the Cianjur Regency Agriculture Office. To accept the program, farmers submit proposals which will be reviewed by the proposal reviewer analyst. In making a decision to accept a grant proposal, it is necessary to make a quick and accurate decision. With quite a lot of proposal data that has been submitted, it can be used data patterns that have been stored with data mining methods to predict proposals that are accepted with proposals that are rejected. The algorithm used is K-Nearest Neighbor where the determination of acceptance of new proposal data is based on the closest distance to the acceptance of the previous proposal. There are six predictor variables used, namely assets, capital, business scale, length of business, cost plan and completeness of documents. The stages of data mining use the stages in Knowledge Discovery in Databases (KDD). Calculations use the weight of the assessment for each proposal criteria that have been determined. The results of the evaluation of the calculation of the kNN algorithm obtained a real accuracy of 76% and an error rate of 24%. From the calculation results, the kNN algorithm can be used as a model to determine recipients of agricultural grant programs. Program pemberian dana hibah untuk para petani merupakan salah satu program pemerintah yang diberikan oleh Dinas Pertanian Kabupaten Cianjur. Untuk menerima program tersebut petani mengajukan proposal yang akan diperiksa oleh analis pemeriksa proposal. Dalam mengambil keputusan penerimaan proposal hibah perlu adanya keputusan yang cepat dan akurat. Dengan cukup banyaknya data proposal yang telah diajukan , maka dapat digunakan pola data yang telah tersimpan dengan metode data mining untuk memprediksi proposal yang diterima dengan proposal yang ditolak. Algoritma yang digunakan yaitu K-Nearest Neighbor di mana penentuan penerimaan data proposal baru berdasarkan pada jarak terdekat dengan penerimaan proposal sebelumnya. Terdapat enam variabel prediktor yang digunakan yaitu aset, modal, skala usaha, lama usaha, rencana biaya dan kelengkapan dokumen. Tahapan data mining menggunakan tahapan dalam knowledge Discovery in Databases (KDD) . Perhitungan menggunakan bobot penilaian untuk setiap kriteria proposal yang sudah ditentukan. Hasil evaluasi perhitungan algoritma kNN diperoleh akurasi sebenar 76% dan tingkat error sebesar 24%. Dari hasil perhitungan, algoritma kNN ini dapat digunakan sebagai model untuk menentukan penerima program hibah pertanian.

Data mining, or Knowledge Discovery in Databases (KDD), is of little benefit to commercial enterprises unless it can be carried out efficiently on realistic volumes of data. Operational factors also dictate that KDD should be performed within the context of standard DBMS. Fortunately, relational DBMS have a declarative query interface (SQL) that has allowed designers of parallel hardware to exploit data parallelism efficiently. Thus, an effective approach to the problem of efficient KDD consists of arranging that KDD tasks execute on a parallel SQL server. In this paper we devise generic KDD primitives, map these to SQL and present some results of running these primitives on a commercially-available parallel SQL server.

SMART software for decision makers KDD experience

The aim of this study is to highlight the importance of the unsupervised learning in Data mining and CRM fields. Data mining commonly known by its acronym KDD: knowledge discovery in data base, it refers to all methods and algorithms used for data exploration or prediction in large data bases volumes, Data mining is very important in various fields such as science, business and other areas deal with a large data set. CRM: Customer Relationship Management is an integrated information system that is used to plan, schedule and control the pre-sales and post-sales activities in an organization, both CRM and data mining techniques helps organizations maximize the value of every customer interaction and drive superior corporate performance. Clustering is one of the favoured used methods in data mining: The objective of this study is to implement the clustering algorithm K-Medoids via a shell script applied on a set of Analytical CRM data stored in Teradata environment.

El presente trabajo pretende principalmente acercar a los investigadores del campo de las drogodependencias una metodología de análisis de datos orientada al descubrimiento de conocimiento en bases de datos (KDD). El KDD es un proceso que consta de una serie de fases, la más característica de las cuales se denomina Data Mining (DM), en la que se aplican diferentes técnicas de modelado para detectar patrones y relaciones en los datos. Se analizan los factores comunes y diferenciadores de las técnicas DM más ampliamente utilizadas, desde una visión principalmente metodológica, y ejemplificando su uso con datos provenientes del consumo de alcohol en adolescentes y su posible relación con variables de personalidad (N=7030). Aunque la precisión global obtenida (% de predicciones correctas) es muy similar en los tres modelos analizados, las redes neuronales generan el modelo más preciso (64.1%), seguidas de los árboles de decisión (62.3%) y Naive Bayes (59.9%).

Like other data-rich disciplines such as physics, biology, geology, and oceanography, astronomy is facing a data avalanche due to advances in telescope and detector technology, the exponential increase in computing capabilities, improvements in data-collection methods, and successful applications of theoretical simulations. As the era approaches in which data covers the full range of wavelengths from radio to gamma-rays, the expected data volumes will add up to terabytes, soon to be followed by petabytes. Proper management and processing of massive data sets requires efficient federation of database technologies. However, mining knowledge from huge data volumes is the ultimate goal and development of data-mining techniques is therefore critical. Knowledge discovery in databases (KDD) is the process of extracting useful knowledge from data. Data mining, the application of specific algorithms to discover rare or previously unknown types of object or phenomenon, is a particular step in the process.1 KDD is inherently interactive and iterative, as shown in Figure 1. Common KDD functions are classification, cluster analysis, and regression. In classification one develops a description or model for each class of data labeled with discrete integers (as opposed to cluster analysis, which is sometimes called ‘unsupervised classification’). Classification is used for the organization of future test data, better understanding of each data class, and predictions of certain properties and behaviors. It is based on spectra or images and, for example, may be used to describe galaxies by morphology. Cluster (or clustering) analysis is a multivariate procedure based on placing objects into more or less homogeneous groups such that the relationship between groups is revealed. It lacks an underlying body of statistical theory and is heuristic in nature, requiring decisions to be made by individual users (which can strongly affect results). Cluster analysis is used to classify groups or objectsmore objectively than subjectively and can help astronomers find unusual objects within a flood of data. ExamFigure 1. Knowledge discovery in databases.

With the increase of data, data mining has been introducing to solve the overloading problem and to discover valid, novel, potentially useful patterns in existing data. However, to discover quantitative data, we face a sharp boundary problem that the traditional data mining techniques can not overcome. To pinpoint this problem, a lot of researches have been applied fuzzy sets to discover patterns, especially in sequential patterns . As we know, U. Fayyad et al proposed a unifying process-centric framework for Knowledge Discovery in Database (KDD) which can explain the process from top to toe for the traditional data mining problems. Unfortunately, it fails to be workable in part to describe the process for discovering sequential patterns based on fuzzy concept. Therefore, to have more general viewpoint for discovering of that sort patterns, we devote to proposing a general framework modified from the KDD process. An application is proposed to demonstrate that the framework can be a generalization of the realm problem.

Knowledge discovery in databases is a process that aims at the discovery of associations within data sets. The analysis of geo-referenced data demands a particular approach in this process. This chapter presents a new approach to the process of knowledge discovery, in which qualitative geographic identifiers give the positional aspects of geographic data. Those identifiers are manipulated using qualitative reasoning principles, which allows for the inference of new spatial relations required for the data mining step of the knowledge discovery process. The efficacy and usefulness of the implemented system — Padrão — has been tested with a bank dataset. The results support that traditional knowledge discovery systems, developed for relational databases and not having semantic knowledge linked to spatial data, can be used in the process of knowledge discovery in geo-referenced databases, since some of this semantic knowledge and the principles of qualitative spatial reasoning are available as spatial domain knowledge.

Data mining, also known as knowledge discovery in databases, is a statistical analysis technique used to find hidden patterns and identify untapped value in large datasets. Clustering is a principal data discovery technique in data mining that segregates a dataset into subsets or clusters so that data values in the same cluster have some common characteristics or attributes. A number of clustering techniques have been proposed in the past by many researchers that can identify arbitrary shaped cluster; where a cluster is defined as a dense region separated by the low-density regions and among them DBSCAN is a prime density-based clustering algorithm. DBSCAN is capable of discovering clusters of any arbitrary shape and size in databases which even include noise and outliers. Many researchers have attempted to overcome certain deficiencies in the original DBSCAN like identifying patterns within datasets of varied densities and its high computational complexity; hence a number of augmented forms of DBSCAN algorithm are available. We present an incremental density-based clustering technique which is based on the fundamental DBSCAN clustering algorithm to enhance its computational complexity. Our proposed algorithm can be used in different knowledge domains like image processing, classification of patterns in GIS maps, x-ray crystallography and information security.

Knowledge discovery in databases, or data mining, is an important objective in the development of data- and knowledge-base systems. An attribute-oriented rough set method is developed for knowledge discovery in databases. The method integrates learning from example techniques with rough set theory. An attribute-oriented concept tree ascension technique is first applied in generalization, which substantially reduces the computational complexity of the database learning processes. Then the rough set techniques are applied to the generalized relation to derive different knowledge rules. Moreover, the approach can find all the maximal generalized rules in the data. Based on these principles, a prototype database learning system, DBROUGH, has been constructed. Our study shows that attribute-oriented induction combined with rough set techniques provide an efficient and effective mechanism for knowledge discovery in database systems.

At institutions of higher education, data is generated daily. This massive amount of information is stored in different repositories, and it is increasingly difficult to locate specific data on which decisions can be made because universities are unaware of processes that allow for the extraction of valuable and reliable information. In this paper, we present a methodology that includes the Knowledge Discovery in Databases (KDD) coupled with the HEFESTO version 2.0 methodology for the construction of Data Warehouses and the use of Data Mining (DM) techniques. By implementing the proposed methodology, problems stemming from a lack of information relating to student placement and admissions in the UNAE and New Student Orientation (NSO) departments at the Polytechnic School of Chimborazo (ESPOCH) may be resolved. To accomplish this established goal, a Data Warehouse (DW) was implemented based on the requirements of the UNAE to find reliable information through cleaning and data integration techniques while respecting the Extraction, Transformation, and Load (ETL) process. In addition, several methods of DM were analyzed, culminating in the discovery of the pertinent information to ascertain the classification of students by areas of study, gender analysis, as well as to know the projection of the number of students who will commence university careers offered by ESPOCH in upcoming years.

Telecommunications are one of the most dynamics and strategic areas in the world. In a complex and competitive scenario with pressure for better results with fewer resources, there is a constant need in the organizations for searching new and improved forms of administration with better understanding of the processes and customers. Techniques such as knowledge discovery in databases (KDD) and data mining (DM) appear as alternatives for enabling transform raw and complex data in models that may allow better decision making. This paper presents an application of multivariate regression analysis for modeling and explaining sales in the segment of corporate telecommunications, through acting indicators. A series of comparative analyses were accomplished with intend to identify the most appropriate or impacting indicators to perform the best decisions when selling corporate services. It is also presented a systemization of KDD activities which integrates the methodologies such as CRISPDM and SEMMA in an interactive design framework. Variable selection methods and statistical validation of the model are presented. Results are presented from real databases of large Brazilian telecommunications company.

Based on an overview on recent contributions with respect to data mining applications terms like “data mining”, “data warehousing” and “knowledge discovery in databases” are related to the well-known discussion where “data analysis” and “decision support” are combined with “expert knowledge research”. Next, commercial data mining tools are compared with the help of positioning and segmentation procedures to get a feeling for the support provided by software tailored for performing tasks concerning knowledge discovery in databases. Finally, an own modification of an association rule algorithm is used to handle buying histories in the area of consumer behavior interpretation.