Abstract:Today, modern databases with "Big Dimensionality" are experiencing a growing trend. Existing approaches that require the calculations of pairwise feature correlations in their algorithmic designs have scored miserably on such databases, since computing the full correlation matrix (i.e., square of dimensionality in size) is computationally very intensive (i.e., million features would translate to trillion correlations). This poses a notable challenge that has received much lesser attention in the field of machine learning and data mining research. Thus, this paper presents a study to fill in this gap. Our findings on several established databases with big dimensionality across a wide spectrum of domains have indicated that an extremely small portion of the feature pairs contributes significantly to the underlying interactions and there exists feature groups that are highly correlated. Inspired by the intriguing observations, we introduce a novel learning approach that exploits the presence of sparse correlations for the efficient identifications of informative and correlated feature groups from big dimensional data that translates to a reduction in complexity from O(m2n) to O(mlogm + Ka mn), where Ka << min(m,n) generally holds. In particular, our proposed approach considers an explicit incorporation of linear and nonlinear correlation measures as constraints in the learning model. An efficient embedded feature selection strategy, designed to filter out the large number of non-contributing correlations that could otherwise confuse the classifier while identifying the correlated and informative feature groups, forms one of the highlights of our approach. We also demonstrated the proposed method on one-class learning, where notable speedup can be observed when solving one-class problem on big dimensional data. Further, to identify robust informative features with minimal sampling bias, our feature selection strategy embeds the V-fold cross validation in the learning model, so as to seek for features that exhibit stable or consistent performance accuracy on multiple data folds. Extensive empirical studies on both synthetic and several real-world datasets comprising up to 30 million dimensions are subsequently conducted to assess and showcase the efficacy of the proposed approach.

Optimization for Massive Data Query Method in Database

Optimization Factor Analysis Of Large-Scale Join Queries On Different Platforms

A Fast Algorithm for Density-Based Clustering in Large Database

A Study of Performance Optimization Method for Massive Spaito-temporal Data Based on Spatio-temporal Partition Clustering

Optimization Design of Apriori Algorithm Based on Big Data Analysis and Cloud Computing

Optimization of Big Data Parallel Scheduling Based on Dynamic Clustering Scheduling Algorithm

Using Optimization-Based Classification Method for Massive Datasets.

A Hybrid Approach to Clustering in Very Large Databases

Query optimization for massively parallel data processing.

Maximum average entropy-rate based correlation clustering for big data

Machine Learning for Databases

A Clustered Dwarf Structure to Speed Up Queries on Data Cubes

Approaches for Scaling Dbscan Algorithm to Large Spatial Databases

Optimization and ensemble of clustering algorithm for large datasets

Mining maximal correlated member clusters in high dimensional database

Database Physical Structure Optimization Technology

Making Trillion Correlations Feasible in Feature Grouping and Selection

New Coding Method To Reduce The Database Size And Algorithm With Significant Efficiency In Association Rules

Dboost: A Fast Algorithm for Dbscan-Based Clustering on High Dimensional Data

The analysis of the internet of things database query and optimization using deep learning network model

Query Optimization and Rebalancing Methods based on CMD.