EDBT 2026 Demo / reviewers in the wild / expert
Heikki Mannila
dblp:m/HMannila
· DBLP profile ↗
156ranked-venue papers
47as first author
4since 2021 · last 2026
0009-0000-3772-6073ORCID · corroborated
Domains — the database's venue-derived domains; a paper can count in several
Databases, data management, data science and information retrieval · 109 · 31 first-author · 3 since 2021Artificial intelligence and machine learning · 64 · 17 first-author · 1 since 2021Theory of computation · 24 · 11 first-author · 1 since 2021Applied, interdisciplinary, general and emerging computing · 14 · 3 first-authorSoftware engineering, systems software and programming languages · 3 · 1 first-authorSystems, architecture and hardware · 2 · 1 first-authorGraphics, computer vision, multimedia, augmented reality and games · 2
| Year | Publication | Venue | Position |
|---|---|---|---|
| 2026 | Khatri-Rao Clustering for Data SummarizationabstractAs datasets continue to grow in size and complexity, finding succinct yet accurate data summaries poses a key challenge. Centroid-based clustering, a widely adopted approach to address this challenge, finds informative summaries of datasets in terms of few prototypes, each representing a cluster in the data. Despite their wide adoption, the resulting data summaries often contain redundancies, limiting their effectiveness particularly in datasets characterized by a large number of underlying clusters. To overcome this limitation, we introduce the Khatri-Rao clustering paradigm that extends traditional centroid-based clustering to produce more succinct but equally accurate data summaries by postulating that centroids arise from the interaction of two or more succinct sets of protocentroids. We study two approaches to centroid-based clustering, the well-established -Means algorithm and the increasingly popular deep clustering, under the lens of the Khatri-Rao paradigm. To this end, we introduce the Khatri-Rao--Means algorithm and the Khatri-Rao deep clustering framework. Extensive experiments show that Khatri-Rao--Means can strike a more favorable trade-off between succinctness and accuracy in data summarization than standard -Means. Leveraging representation learning, the Khatri-Rao deep clustering framework offerseven greater benefits, reducing even more the size of data summaries given by deep clustering while preserving their accuracy Martino Ciaperoni, Collin Leiber, Aristides Gionis, Heikki Mannila |
EDBT | 4 |
| 2026 | Optimal Union Probability Interval Is NP-HardabstractA problem dating back to Boole [Laws of Thought, Walton & Maberly,1854] is what can be computed about the probability of a finite union of events when given as input the probabilities of intersections of some of the events. The modern geometric study of the problem can be traced back to Hailperin [Amer. Math. Monthly 2 (1965) 343--359] who phrased the problem in the language of linear programming and generalized it to logical formulas of the events other than disjunction, heralding a substantial body of work in probabilistic logic [Nilsson, Artif.\ Intell.\ 28 (1986) 71--87], including the probabilistic satisfiability problem of Georgakopoulos, Kavvadis, and Papadimitriou [J.Complexity 4 (1988) 1--11], as well as fundamental connections to the geometry of metrics via cut and correlation polytopes [Deza and Laurent, Geometry of Cuts and Metrics, Springer, 1997] and to the study of marginal polytopes in graphical models of machine learning [Wainwright and Jordan, Found.\ Trends Mach.\ Learn. 1 (2008) 1--305]. This paper (i) describes the pertinent geometry of Boole's problem via coordinate projections of an elementary polytope arising essentially from Hailperin's linear program on the atoms of a Venn diagram, and (ii) shows that computing the optimal interval for the union probability is NP-hard, resolving an apparent gap in the literature highlighted by Pitowsky [Math.\ Programming 50 (1991) 395--414] and Boros et al. [Math.\ Oper.\ Res. 39 (2014) 1311--1329 and 51 (2026) 134--148]. Petteri Kaski, Heikki Mannila, Chandra Kanta Mohapatra |
ESA | 2 |
| 2025 | Sample and Expand: Discovering Low-Rank Submatrices With Quality Guarantees
Martino Ciaperoni, Aristides Gionis, Heikki Mannila |
ECML/PKDD (5) | 3 |
| 2024 | The Hadamard decomposition problemabstractAbstract We introduce the Hadamard decomposition problem in the context of data analysis. The problem is to represent exactly or approximately a given matrix as the Hadamard (or element-wise) product of two or more low-rank matrices. The motivation for this problem comes from situations where the input matrix has a multiplicative structure. The Hadamard decomposition has potential for giving more succint but equally accurate representations of matrices when compared with the gold-standard of singular value decomposition (svd). Namely, the Hadamard product of two rank- $$h$$ h matrices can have rank as high as $${h}^2$$ h 2 . We study the computational properties of the Hadamard decomposition problem and give gradient-based algorithms for solving it approximately. We also introduce a mixed model that combines svd and Hadamard decomposition. We present extensive empirical results comparing the approximation accuracy of the Hadamard decomposition with that of the svd using the same number of basis vectors. The results demonstrate that the Hadamard decomposition is competitive with the svd and, for some datasets, it yields a clearly higher approximation accuracy, indicating the presence of multiplicative structure in the data. Martino Ciaperoni, Aristides Gionis, Heikki Mannila |
Data Min. Knowl. Discov. | 3 |
| 2011 | Analyzing Word Frequencies in Large Text Corpora Using Inter-arrival Times and Bootstrapping
Jefrey Lijffijt, Panagiotis Papapetrou, Kai Puolamäki, Heikki Mannila |
ECML/PKDD (2) | 4 |
| 2011 | Permutation Structure in 0-1 Data
Heikki Mannila |
ECML/PKDD (1) | 1 |
| 2011 | A Shapley Value Approach for Influence Attribution
Panagiotis Papapetrou, Aristides Gionis, Heikki Mannila |
ECML/PKDD (2) | 3 |
| 2011 | Randomization techniques for assessing the significance of gene periodicity resultsabstractBACKGROUND: Modern high-throughput measurement technologies such as DNA microarrays and next generation sequencers produce extensive datasets. With large datasets the emphasis has been moving from traditional statistical tests to new data mining methods that are capable of detecting complex patterns, such as clusters, regulatory networks, or time series periodicity. Study of periodic gene expression is an interesting research question that also is a good example of challenges involved in the analysis of high-throughput data in general. Unlike for classical statistical tests, the distribution of test statistic for data mining methods cannot be derived analytically. RESULTS: We describe the randomization based approach to significance testing, and show how it can be applied to detect periodically expressed genes. We present four randomization methods, three of which have previously been used for gene cycle data. We propose a new method for testing significance of periodicity in gene expression short time series data, such as from gene cycle and circadian clock studies. We argue that the underlying assumptions behind existing significance testing approaches are problematic and some of them unrealistic. We analyze the theoretical properties of the existing and proposed methods, showing how our method can be robustly used to detect genes with exceptionally high periodicity. We also demonstrate the large differences in the number of significant results depending on the chosen randomization methods and parameters of the testing framework.By reanalyzing gene cycle data from various sources, we show how previous estimates on the number of gene cycle controlled genes are not supported by the data. Our randomization approach combined with widely adopted Benjamini-Hochberg multiple testing method yields better predictive power and produces more accurate null distributions than previous methods. CONCLUSIONS: Existing methods for testing significance of periodic gene expression patterns are simplistic and optimistic. Our testing framework allows strict levels of statistical significance with more realistic underlying assumptions, without losing predictive power. As DNA microarrays have now become mainstream and new high-throughput methods are rapidly being adopted, we argue that not only there will be need for data mining methods capable of coping with immense datasets, but there will also be need for solid methods for significance testing. Aleksi Kallio, Niko Vuokko, Markus Ojala, Niina Haiminen, Heikki Mannila |
BMC Bioinform. | 5 |
| 2011 | Banded structure in binary matrices
Gemma C. Garriga, Esa Junttila, Heikki Mannila |
Knowl. Inf. Syst. | 3 |
| 2010 | Gaussian Clusters and Noise: An Approach Based on the Minimum Description Length Principle
Panu Luosto, Jyrki Kivinen, Heikki Mannila |
Discovery Science | 3 |
| 2010 | Finding effectors in social networksabstractAssume a network (V,E) where a subset of the nodes in V are active. We consider the problem of selecting a set of k active nodes that best explain the observed activation state, under a given information-propagation model. We call these nodes effectors. We formally define the k-Effectors problem and study its complexity for different types of graphs. We show that for arbitrary graphs the problem is not only NP-hard to solve optimally, but also NP-hard to approximate. We also show that, for some special cases, the problem can be solved optimally in polynomial time using a dynamic-programming algorithm. To the best of our knowledge, this is the first work to consider the k-Effectors problem in networks. We experimentally evaluate our algorithms using the DBLP co-authorship graph, where we search for effectors of topics that appear in research papers. Theodoros Lappas, Evimaria Terzi, Dimitrios Gunopulos, Heikki Mannila |
KDD | 4 |
| 2010 | Evaluating Query Result Significance in Databases via RandomizationsabstractMany sorts of structured data are commonly stored in a multi-relational format of interrelated tables.Under this relational model, exploratory data analysis can be done by using relational queries.As an example, in the Internet Movie Database (IMDb) a query can be used to check whether the average rank of action movies is higher than the average rank of drama movies.We consider the problem of assessing whether the results returned by such a query are statistically significant or just a random artifact of the structure in the data.Our approach is based on randomizing the tables occurring in the queries and repeating the original query on the randomized tables.It turns out that there is no unique way of randomizing in multi-relational data.We propose several randomization techniques, study their properties, and show how to find out which queries or hypotheses about our data result in statistically significant information and which tables in the database convey most of the structure in the query.We give results on real and generated data and show how the significance of some queries vary between different randomizations. Markus Ojala, Gemma C. Garriga, Aristides Gionis, Heikki Mannila |
SDM | 4 |
| 2009 | Randomization Methods for Assessing the Significance of Data Mining Results
Heikki Mannila |
ISMIS | 1 |
| 2009 | Tell me something I don't know: randomization strategies for iterative data miningabstractThere is a wide variety of data mining methods available, and it is generally useful in exploratory data analysis to use many different methods for the same dataset. This, however, leads to the problem of whether the results found by one method are a reflection of the phenomenon shown by the results of another method, or whether the results depict in some sense unrelated properties of the data. For example, using clustering can give indication of a clear cluster structure, and computing correlations between variables can show that there are many significant correlations in the data. However, it can be the case that the correlations are actually determined by the cluster structure. Sami Hanhijärvi, Markus Ojala, Niko Vuokko, Kai Puolamäki, Nikolaj Tatti, Heikki Mannila |
KDD | 6 |
| 2009 | Randomization methods in data miningabstractData mining research has developed many algorithms for various analysis tasks on large and complex datasets. However, assessing the significance of data mining results has received less attention. Analytical methods are rarely available, and hence one has to use computationally intensive methods. Randomization approaches based on null models provide, at least in principle, a general approach that can be used to obtain empirical p-values for various types of data mining approaches. I review some of the recent work in this area, outlining some of the open questions and problems. Heikki Mannila |
KDD | 1 |
| 2009 | Applying Electromagnetic Field Theory Concepts to Clustering with Constraints
Huseyin Hakkoymaz, Georgios Chatzimilioudis, Dimitrios Gunopulos, Heikki Mannila |
ECML/PKDD (1) | 4 |
| 2009 | Low-Entropy Set SelectionabstractMost pattern discovery algorithms easily generate very large numbers of patterns, making the results impossible to understand and hard to use. Recently, the problem of instead selecting a small subset of informative patterns from a large collection of patterns has attracted a lot of interest. In this paper we present a succinct way of representing data on the basis of itemsets that identify strong interactions. This new approach, LESS, provides a more powerful and more general technique to data description than existing approaches. Low-entropy sets consider the data symmetrically and as such identify strong interactions between attributes, not just between items that are present. Selection of these patterns is executed through the MDL-criterion. This results in only a handful of sets that together form a compact lossless description of the data. By using entropy-based elements for the data description, we can successfully apply the maximum likelihood principle to locally cover the data optimally. Further, it allows for a fast, natural and well performing heuristic. Based on these approaches we present two algorithms that provide high-quality descriptions of the data in terms of strongly interacting variables. Experiments on these methods show that high-quality results are mined: very small pattern sets are returned that are easily interpretable and understandable descriptions of the data, and can be straightforwardly visualized. Swap randomization experiments and high compression ratios show that they capture the structure of the data well. Hannes Heikinheimo, Jilles Vreeken, Arno Siebes, Heikki Mannila |
SDM | 4 |
| 2009 | Finding Links and Initiators: A Graph-Reconstruction ProblemabstractConsider a 0-1 observation matrix M , where rows correspond to entities and columns correspond to signals; a value of 1 (or 0) in cell (i, j) of M indicates that signal j has been observed (or not observed) in entity i.Given such a matrix we study the problem of inferring the underlying directed links between entities (rows) and finding which entries in the matrix are initiators.We formally define this problem and propose an MCMC framework for estimating the links and the initiators given the matrix of observations M .We also show how this framework can be extended to incorporate a temporal aspect; instead of considering a single observation matrix M we consider a sequence of observation matrices M 1 , . . ., M t over time.We show the connection between our problem and several problems studied in the field of social-network analysis.We apply our method to paleontological and ecological data and show that our algorithms work well in practice and give reasonable results. Heikki Mannila, Evimaria Terzi |
SDM | 1 |
| 2009 | Approximating the Minimum Chain Completion problem
Tomás Feder, Heikki Mannila, Evimaria Terzi |
Inf. Process. Lett. | 2 |
| 2009 | A randomized approximation algorithm for computing bucket orders
Antti Ukkonen, Kai Puolamäki, Aristides Gionis, Heikki Mannila |
Inf. Process. Lett. | 4 |
| 2009 | ACM TKDD special issue ACM SIGKDD 2007 and ACM SIGKDD 2008abstractNo abstract available. Heikki Mannila, Dimitrios Gunopulos |
ACM Trans. Knowl. Discov. Data | 1 |
| 2009 | Determining Attributes to Maximize Visibility of ObjectsabstractIn recent years, there has been significant interest in the development of ranking functions and efficient top-k retrieval algorithms to help users in ad hoc search and retrieval in databases (e.g., buyers searching for products in a catalog). We introduce a complementary problem: How to guide a seller in selecting the best attributes of a new tuple (e.g., a new product) to highlight so that it stands out in the crowd of existing competitive products and is widely visible to the pool of potential buyers. We develop several formulations of this problem. Although the problems are NP-complete, we give several exact and approximation algorithms that work well in practice. One type of exact algorithms is based on integer programming (IP) formulations of the problems. Another class of exact methods is based on maximal frequent item set mining algorithms. The approximation algorithms are based on greedy heuristics. A detailed performance study illustrates the benefits of our methods on real and synthetic data. Muhammed Miah, Gautam Das 0001, Vagelis Hristidis, Heikki Mannila |
IEEE Trans. Knowl. Data Eng. | 4 |
| 2008 | Randomization Techniques for Data Mining Methods
Heikki Mannila |
ADBIS | 1 |
| 2008 | Finding Total and Partial Orders from Data for Seriation
Heikki Mannila |
ALT | 1 |
| 2008 | Feature Selection in Taxonomies with Applications to Paleontology
Gemma C. Garriga, Antti Ukkonen, Heikki Mannila |
Discovery Science | 3 |
| 2008 | Finding Total and Partial Orders from Data for Seriation
Heikki Mannila |
Discovery Science | 1 |
| 2008 | Standing Out in a Crowd: Selecting Attributes for Maximum VisibilityabstractIn recent years, there has been significant interest in development of ranking functions and efficient top-k retrieval algorithms to help users in ad-hoc search and retrieval in databases (e.g., buyers searching for products in a catalog). In this paper we focus on a novel and complementary problem: how to guide a seller in selecting the best attributes of a new tuple (e.g., new product) to highlight such that it stands out in the crowd of existing competitive products and is widely visible to the pool of potential buyers. We develop several interesting formulations of this problem. Although these problems are NP-complete, we can give several exact algorithms as well as approximation heuristics that work well in practice. Our exact algorithms are based on integer programming (IP) formulations of the problems, as well as on adaptations of maximal frequent itemset mining algorithms, while our approximation algorithms are based on greedy heuristics. We conduct a performance study illustrating the benefits of our methods on real as well as synthetic data. Muhammed Miah, Gautam Das 0001, Vagelis Hristidis, Heikki Mannila |
ICDE | 4 |
| 2008 | Banded structure in binary matricesabstractA 0--1 matrix has a banded structure if both rows and columns can be permuted so that the non-zero entries exhibit a staircase pattern of overlapping rows. The concept of banded matrices has its origins in numerical analysis, where entries can be viewed as descriptions between the problem variables; the bandedness corresponds to variables that are coupled over short distances. Banded data occurs also in other applications, for example in the physical mapping problem of the human genome, in paleontological data, in network data and in the discovery of overlapping communities without cycles. Gemma C. Garriga, Esa Junttila, Heikki Mannila |
KDD | 3 |
| 2008 | Finding Subgroups having Several Descriptions: Algorithms for Redescription MiningabstractGiven a 0–1 dataset, we consider the redescription mining task introduced by Ramakrishnan, Parida, and Zaki. The problem is to find subsets of the rows that can be (approximately) defined by at least two different Boolean formulae on the attributes. That is, we search for pairs (α, β) of Boolean formulae such that the implications α → β and β → α both hold with high accuracy. We require that the two descriptions α and β are syntactically sufficiently different. Such pairs of descriptions indicate that the subset has different definitions, a fact that gives useful information about the data. We give simple algorithms for this task, and evaluate their performance. The methods are based on pruning the search space of all possible pairs of formulae by different accuracy criteria. The significance of the findings is tested by using randomization methods. Experimental results on simulated and real data show that the methods work well: on simulated data they find the planted subsets, and on real data they produce small and understandable results. Arianna Gallo, Pauli Miettinen, Heikki Mannila |
SDM | 3 |
| 2008 | Mining Association Rules of Simple Conjunctive QueriesabstractWe present an algorithm for mining association rules in arbitrary relational databases.We define association rules over a simple, but appealing subclass of conjunctive queries, and show that many interesting patterns can be found.We propose an efficient algorithm and a database-oriented implementation in SQL, together with several promising and convincing experimental results. Bart Goethals, Wim Le Page, Heikki Mannila |
SDM | 3 |
| 2008 | Randomization of real-valued matrices for assessing the significance of data mining resultsabstractRandomization is an important technique for assessing the significance of data mining results. Given an input data set, a randomization method samples at random from some class of datasets that share certain characteristics with the original data. The measure of interest on the original data is then compared to the measure on the samples to assess its significance. For certain types of data, e.g., gene expression matrices, it is useful to be able to sample datasets that share row and column means and variances. Testing whether the results of a data mining algorithm on such randomized datasets differ from the results on the true dataset tells us whether the results on the true data were an artifact of the row and column means and variances, or due to some more interesting phenomena in the data. In this paper, we study the problem of generating such randomized datasets. We describe three alternative algorithms based on local transformations and Metropolis sampling, and show that the methods are efficient and usable in practice. We evaluate the performance of the methods both on real and generated data. The results indicate that the methods work efficiently and solve the defined problem. Markus Ojala, Niko Vuokko, Aleksi Kallio, Niina Haiminen, Heikki Mannila |
SDM | 5 |
| 2008 | Determining significance of pairwise co-occurrences of events in bursty sequencesabstractBACKGROUND: Event sequences where different types of events often occur close together arise, e.g., when studying potential transcription factor binding sites (TFBS, events) of certain transcription factors (TF, types) in a DNA sequence. These events tend to occur in bursts: in some genomic regions there are more genes and therefore potentially more binding sites, while in some, possibly very long regions, hardly any events occur. Also some types of events may occur in the sequence more often than others. Tendencies of co-occurrence of binding sites of two or more TFs are interesting, as they may imply a co-operative role between the TFs in regulatory processes. Determining a numerical value to summarize the tendency for co-occurrence between two TFs can be done in a number of ways. However, testing for the significance of such values should be done with respect to a relevant null model that takes into account the global sequence structure. RESULTS: We extend the existing techniques that have been considered for determining the significance of co-occurrence patterns between a pair of event types under different null models. These models range from very simple ones to more complex models that take the burstiness of sequences into account. We evaluate the models and techniques on synthetic event sequences, and on real data consisting of potential transcription factor binding sites. CONCLUSION: We show that simple null models are poorly suited for bursty data, and they yield many false positives. More sophisticated models give better results in our experiments. We also demonstrate the effect of the window size, i.e., maximum co-occurrence distance, on the significance results. Niina Haiminen, Heikki Mannila, Evimaria Terzi |
BMC Bioinform. | 2 |
| 2008 | Optimal segmentation using tree models
Robert Gwadera, Aristides Gionis, Heikki Mannila |
Knowl. Inf. Syst. | 3 |
| 2008 | The Discrete Basis ProblemabstractMatrix decomposition methods represent a data matrix as a product of two factor matrices: one containing basis vectors that represent meaningful concepts in the data, and another describing how the observed data can be expressed as combinations of the basis vectors. Decomposition methods have been studied extensively, but many methods return real-valued matrices. Interpreting real-valued factor matrices is hard if the original data is Boolean. In this paper, we describe a matrix decomposition formulation for Boolean data, the Discrete Basis Problem. The problem seeks for a Boolean decomposition of a binary matrix, thus allowing the user to easily interpret the basis vectors. We also describe a variation of the problem, the Discrete Basis Partitioning Problem. We show that both problems are NP-hard. For the Discrete Basis Problem, we give a simple greedy algorithm for solving it; for the Discrete Basis Partitioning Problem we show how it can be solved using existing methods. We present experimental results for the greedy algorithm and compare it against other, well known methods. Our algorithm gives intuitive basis vectors, but its reconstruction error is usually larger than with the real-valued methods. We discuss about the reasons for this behavior. Pauli Miettinen, Taneli Mielikäinen, Aristides Gionis, Gautam Das 0001, Heikki Mannila |
IEEE Trans. Knowl. Data Eng. | 5 |
| 2007 | Recurrent Predictive Models for Sequence Segmentation
Saara Hyvönen, Aristides Gionis, Heikki Mannila |
IDA | 3 |
| 2007 | Finding low-entropy sets and trees from binary dataabstractThe discovery of subsets with special properties from binary data hasbeen one of the key themes in pattern discovery. Pattern classes suchas frequent itemsets stress the co-occurrence of the value 1 in the data. While this choice makes sense in the context of sparse binary data, it disregards potentially interesting subsets of attributes that have some other type of dependency structure. Hannes Heikinheimo, Jouni K. Seppänen, Eino Hinkkanen, Heikki Mannila, Taneli Mielikäinen |
KDD | 4 |
| 2007 | Nestedness and segmented nestednessabstractConsider each row of a 0-1 dataset as the subset of the columns for which the row has an 1. Then a dataset is nested, if for all pairs of rows one row is either a superset or subset of the other. The concept of nestedness has its origins in ecology, where approximate versions of it has been used to model the species distribution in different locations. We argue that nestedness and its extensions are interesting properties of datasets, and that they can be applied also to domains other than ecology. Heikki Mannila, Evimaria Terzi |
KDD | 1 |
| 2007 | Finding Outlying Items in Sets of Partial Rankings
Antti Ukkonen, Heikki Mannila |
PKDD | 2 |
| 2007 | A random walk approach to sampling hidden databasesabstractA large part of the data on the World Wide Web is hidden behind form-like interfaces. These interfaces interact with a hidden back-end database to provide answers to user queries. Generating a uniform random sample of this hidden database by using only the publicly available interface gives us access to the underlying data distribution. In this paper, we propose a random walk scheme over the query space provided by the interface to sample such databases. We discuss variants where the query space is visualized as a fixed and random ordering of attributes. We also propose techniques to further improve the sample quality by using a probabilistic rejection based approach. We conduct extensive experiments to illustrate the accuracy and efficiency of our techniques. Arjun Dasgupta, Gautam Das 0001, Heikki Mannila |
SIGMOD Conference | 3 |
| 2007 | Comparing segmentations by applying randomization techniquesabstractBACKGROUND: There exist many segmentation techniques for genomic sequences, and the segmentations can also be based on many different biological features. We show how to evaluate and compare the quality of segmentations obtained by different techniques and alternative biological features. RESULTS: We apply randomization techniques for evaluating the quality of a given segmentation. Our example applications include isochore detection and the discovery of coding-noncoding structure. We obtain segmentations of relevant sequences by applying different techniques, and use alternative features to segment on. We show that some of the obtained segmentations are very similar to the underlying true segmentations, and this similarity is statistically significant. For some other segmentations, we show that equally good results are likely to appear by chance. CONCLUSION: We introduce a framework for evaluating segmentation quality, and demonstrate its use on two examples of segmental genomic structures. We transform the process of quality evaluation from simply viewing the segmentations, to obtaining p-values denoting significance of segmentation similarity. Niina Haiminen, Heikki Mannila, Evimaria Terzi |
BMC Bioinform. | 2 |
| 2007 | Constrained hidden Markov models for population-based haplotypingabstractBACKGROUND: Haplotype Reconstruction is the problem of resolving the hidden phase information in genotype data obtained from laboratory measurements. Solving this problem is an important intermediate step in gene association studies, which seek to uncover the genetic basis of complex diseases. We propose a novel approach for haplotype reconstruction based on constrained hidden Markov models. Models are constructed by incrementally refining and regularizing the structure of a simple generative model for genotype data under Hardy-Weinberg equilibrium. RESULTS: The proposed method is evaluated on real-world and simulated population data. Results show that it is competitive with other recently proposed methods in terms of reconstruction accuracy, while offering a particularly good trade-off between computational costs and quality of results for large datasets. CONCLUSION: Relatively simple probabilistic approaches for haplotype reconstruction based on structured hidden Markov models are competitive with more complex, well-established techniques in this field. Niels Landwehr, Taneli Mielikäinen, Lauri Eronen, Hannu Toivonen, Heikki Mannila |
BMC Bioinform. | 5 |
| 2007 | Assessing data mining results via swap randomizationabstractThe problem of assessing the significance of data mining results on high-dimensional 0--1 datasets has been studied extensively in the literature. For problems such as mining frequent sets and finding correlations, significance testing can be done by standard statistical tests such as chi-square, or other methods. However, the results of such tests depend only on the specific attributes and not on the dataset as a whole. Moreover, the tests are difficult to apply to sets of patterns or other complex results of data mining algorithms. In this article, we consider a simple randomization technique that deals with this shortcoming. The approach consists of producing random datasets that have the same row and column margins as the given dataset, computing the results of interest on the randomized instances and comparing them to the results on the actual data. This randomization technique can be used to assess the results of many different types of data mining algorithms, such as frequent sets, clustering, and spectral analysis. To generate random datasets with given margins, we use variations of a Markov chain approach which is based on a simple swap operation. We give theoretical results on the efficiency of different randomization methods, and apply the swap randomization method to several well-known datasets. Our results indicate that for some datasets the structure discovered by the data mining algorithms is expected, given the row and column margins of the datasets, while for other datasets the discovered structure conveys information that is not captured by the margin counts. Aristides Gionis, Heikki Mannila, Taneli Mielikäinen, Panayiotis Tsaparas |
ACM Trans. Knowl. Discov. Data | 2 |
| 2007 | Clustering aggregationabstractWe consider the following problem: given a set of clusterings, find a single clustering that agrees as much as possible with the input clusterings. This problem, clustering aggregation , appears naturally in various contexts. For example, clustering categorical data is an instance of the clustering aggregation problem; each categorical attribute can be viewed as a clustering of the input rows where rows are grouped together if they take the same value on that attribute. Clustering aggregation can also be used as a metaclustering method to improve the robustness of clustering by combining the output of multiple algorithms. Furthermore, the problem formulation does not require a priori information about the number of clusters; it is naturally determined by the optimization function. In this article, we give a formal statement of the clustering aggregation problem, and we propose a number of algorithms. Our algorithms make use of the connection between clustering aggregation and the problem of correlation clustering . Although the problems we consider are NP-hard, for several of our methods, we provide theoretical guarantees on the quality of the solutions. Our work provides the best deterministic approximation algorithm for the variation of the correlation clustering problem we consider. We also show how sampling can be used to scale the algorithms for large datasets. We give an extensive empirical evaluation demonstrating the usefulness of the problem and of the solutions. Aristides Gionis, Heikki Mannila, Panayiotis Tsaparas |
ACM Trans. Knowl. Discov. Data | 2 |
| 2006 | Analysis of Linux Evolution Using Aligned Source Code Segments
Antti Rasinen, Jaakko Hollmén, Heikki Mannila |
Discovery Science | 3 |
| 2006 | Optimal Segmentation Using Tree ModelsabstractSequence data are abundant in application areas such as computational biology, environmental sciences, and telecommunication. Many real-life sequences have a strong segmental structure, with segments of different complexities. In this paper we study the description of sequence segments using variable length Markov chains (VLMCs), also known as tree models. We discover the segment boundaries of a sequence and at the same time we obtain a VLMC for each segment. Such a context tree contains the probability distribution vectors that capture the essential features of the corresponding segment. We use the Bayesian information criterion (BIC) and the Krichevsky-Trofimov probability (KT) to select the number of segments of a sequence. On DNA data the method selects segments that closely correspond to the annotated regions of the genes. Robert Gwadera, Aristides Gionis, Heikki Mannila |
ICDM | 3 |
| 2006 | What is the Dimension of Your Binary Data?abstractMany 0/1 datasets have a very large number of variables; however, they are sparse and the dependency structure of the variables is simpler than the number of variables would suggest. Defining the effective dimensionality of such a dataset is a nontrivial problem. We consider the problem of defining a robust measure of dimension for 0/1 datasets, and show that the basic idea of fractal dimension can be adapted for binary data. However, as such the fractal dimension is difficult to interpret. Hence we introduce the concept of normalized fractal dimension. For a dataset D, its normalized fractal dimension counts the number of independent columns needed to achieve the unnormalized fractal dimension of D. The normalized fractal dimension measures the degree of dependency structure of the data. We study the properties of the normalized fractal dimension and discuss its computation. We give empirical results on the normalized fractal dimension, comparing it against PCA. Nikolaj Tatti, Taneli Mielikäinen, Aristides Gionis, Heikki Mannila |
ICDM | 4 |
| 2006 | Assessing data mining results via swap randomizationabstractThe problem of assessing the significance of data mining results on high-dimensional 0-1 data sets has been studied extensively in the literature. For problems such as mining frequent sets and finding correlations, significance testing can be done by, e.g., chi-square tests, or many other methods. However, the results of such tests depend only on the specific attributes and not on the dataset as a whole. Moreover, the tests are more difficult to apply to sets of patterns or other complex results of data mining. In this paper, we consider a simple randomization technique that deals with this shortcoming. The approach consists of producing random datasets that have the same row and column margins with the given dataset, computing the results of interest on the randomized instances, and comparing them against the results on the actual data. This randomization technique can be used to assess the results of many different types of data mining algorithms, such as frequent sets, clustering, and rankings. To generate random datasets with given margins, we use variations of a Markov chain approach, which is based on a simple swap operation. We give theoretical results on the efficiency of different randomization methods, and apply the swap randomization method to several well-known datasets. Our results indicate that for some datasets the structure discovered by the data mining algorithms is a random artifact, while for other datasets the discovered structure conveys meaningful information. Aristides Gionis, Heikki Mannila, Taneli Mielikäinen, Panayiotis Tsaparas |
KDD | 2 |
| 2006 | Algorithms for discovering bucket orders from dataabstractOrdering and ranking items of different types are important tasks in various applications, such as query processing and scientific data mining. A total order for the items can be misleading, since there are groups of items that have practically equal ranks.We consider bucket orders, i.e., total orders with ties. They can be used to capture the essential order information without overfitting the data: they form a useful concept class between total orders and arbitrary partial orders. We address the question of finding a bucket order for a set of items, given pairwise precedence information between the items. We also discuss methods for computing the pairwise precedence data.We describe simple and efficient algorithms for finding good bucket orders. Several of the algorithms have a provable approximation guarantee, and they scale well to large datasets. We provide experimental results on artificial and a real data that show the usefulness of bucket orders and demonstrate the accuracy and efficiency of the algorithms. Aristides Gionis, Heikki Mannila, Kai Puolamäki, Antti Ukkonen |
KDD | 2 |
| 2006 | Finding Trees from Unordered 0-1 Data
Hannes Heikinheimo, Heikki Mannila, Jouni K. Seppänen |
PKDD | 2 |
| 2006 | The Discrete Basis Problem
Pauli Miettinen, Taneli Mielikäinen, Aristides Gionis, Gautam Das 0001, Heikki Mannila |
PKDD | 5 |
| 2006 | Segmentation and dimensionality reductionabstractSequence segmentation and dimensionality reduction have been used as methods for studying high-dimensional sequences — they both reduce the complexity of the representation of the original data. In this paper we study the interplay of these two techniques. We formulate the problem of segmenting a sequence while modeling it with a basis of small size, thus essentially reducing the dimension of the input sequence. We give three different algorithms for this problem: all combine existing methods for sequence segmentation and dimensionality reduction. For two of the proposed algorithms we prove guarantees for the quality of the solutions obtained. We describe experimental results on synthetic and real datasets, including data on exchange rates and genomic sequences. Our experiments show that the algorithms indeed discover underlying structure in the data, including both segmental structure and interdependencies between the dimensions. Ella Bingham, Aristides Gionis, Niina Haiminen, Heli Hiisilä, Heikki Mannila, Evimaria Terzi |
SDM | 5 |
| 2006 | Seriation in Paleontological Data Using Markov Chain Monte Carlo MethodsabstractGiven a collection of fossil sites with data about the taxa that occur in each site, the task in biochronology is to find good estimates for the ages or ordering of sites. We describe a full probabilistic model for fossil data. The parameters of the model are natural: the ordering of the sites, the origination and extinction times for each taxon, and the probabilities of different types of errors. We show that the posterior distributions of these parameters can be estimated reliably by using Markov chain Monte Carlo techniques. The posterior distributions of the model parameters can be used to answer many different questions about the data, including seriation (finding the best ordering of the sites) and outlier detection. We demonstrate the usefulness of the model and estimation method on synthetic data and on real data on large late Cenozoic mammals. As an example, for the sites with large number of occurrences of common genera, our methods give orderings, whose correlation with geochronologic ages is 0.95. Kai Puolamäki, Mikael Fortelius, Heikki Mannila |
PLoS Comput. Biol. | 3 |
| 2005 | Clustering AggregationabstractWe consider the following problem: given a set of clusterings, find a clustering that agrees as much as possible with the given clusterings. This problem, clustering aggregation, appears naturally in various contexts. For example, clustering categorical data is an instance of the problem: each categorical variable can be viewed as a clustering of the input rows. Moreover, clustering aggregation can be used as a meta-clustering method to improve the robustness of clusterings. The problem formulation does not require a-priori information about the number of clusters, and it gives a natural way for handling missing values. We give a formal statement of the clustering-aggregation problem, we discuss related work, and we suggest a number of algorithms. For several of the methods we provide theoretical guarantees on the quality of the solutions. We also show how sampling can be used to scale the algorithms for large data sets. We give an extensive empirical evaluation demonstrating the usefulness of the problem and of the solutions. Aristides Gionis, Heikki Mannila, Panayiotis Tsaparas |
ICDE | 2 |
| 2005 | Mining Chains of RelationsabstractTraditional data mining applications consider the problem of mining a single relation between two attributes. For example, in a scientific bibliography database, authors are related to papers, and we may be interested in discovering association rules between authors. However, in real life, we often have multiple attributes related though chains of relations. For example, authors write papers, and papers concern one or more topics. Mining such relational chains poses additional challenges. In this paper we consider the following problem: given a chain of two relations R/sub 1/ (A, P) and R/sub 2/(P, T) we want to find selectors for the objects in T such that the projected relation between A and P satisfies a specific property. The motivation for our approach is that a given property might not hold on the whole dataset, but it might hold when projecting the data on a selector set. We discuss various algorithms and we examine the conditions under which the a priori technique can be used. We experimentally demonstrate the effectiveness of our methods. Foto N. Afrati, Gautam Das 0001, Aristides Gionis, Heikki Mannila, Taneli Mielikäinen, Panayiotis Tsaparas |
ICDM | 4 |
| 2005 | Parameter-Free Spatial Data Mining Using MDLabstractConsider spatial data consisting of a set of binary features taking values over a collection of spatial extents (grid cells). We propose a method that simultaneously finds spatial correlation and feature co-occurrence patterns, without any parameters. In particular, we employ the minimum description length (MDL) principle coupled with a natural way of compressing regions. This defines what "good" means: a feature co-occurrence pattern is good, if it helps us better compress the set of locations for these features. Conversely, a spatial correlation is good, if it helps us better compress the set of features in the corresponding region. Our approach is scalable for large datasets (both number of locations and of features). We evaluate our method on both real and synthetic datasets. Spiros Papadimitriou, Aristides Gionis, Panayiotis Tsaparas, Risto A. Väisänen, Heikki Mannila, Christos Faloutsos |
ICDM | 5 |
| 2005 | Finding partial orders from unordered 0-1 dataabstractIn applications such as paleontology and medical genetics the 0-1 data has an underlying unknown order (the ages of the fossil sites, the locations of markers in the genome). The order might be total or partial: for example, two sites in different parts of the globe might be ecologically incomparable, or the ordering of certain markers might be different in different subgroups of the data. We consider the following problem. Given a table over a set of 0-1 variables, find a partial order for the rows minimizing a score function and being as specific as possible. The score function can be, e.g., the number of changes from 1 to 0 in a column (for paleontology) or the likelihood of the marker sequence (for genomic data). Our solution for this task first constructs small totally ordered fragments of the partial order, then finds good orientations for the fragments, and finally uses a simple and efficient heuristic method for finding a partial order that corresponds well with the collection of fragments. We describe the method, discuss its properties, and give empirical results on paleontological data demonstrating the usefulness of the method. In the application the use of the method highlighted some previously unknown properties of the data and pointed out probable errors in the data. Antti Ukkonen, Mikael Fortelius, Heikki Mannila |
KDD | 3 |
| 2005 | A Hidden Markov Technique for Haplotype Reconstruction
Pasi Rastas, Mikko Koivisto, Heikki Mannila, Esko Ukkonen |
WABI | 3 |
| 2005 | Using Markov chain Monte Carlo and dynamic programming for event sequence data
Marko Salmenkivi, Heikki Mannila |
Knowl. Inf. Syst. | 2 |
| 2004 | Hidden Markov Modelling Techniques for Haplotype Analysis
Mikko Koivisto, Teemu Kivioja, Heikki Mannila, Pasi Rastas, Esko Ukkonen |
ALT | 3 |
| 2004 | Approximating a collection of frequent setsabstractOne of the most well-studied problems in data mining is computing the collection of frequent item sets in large transactional databases. One obstacle for the applicability of frequent-set mining is that the size of the output collection can be far too large to be carefully examined and understood by the users. Even restricting the output to the border of the frequent item-set collection does not help much in alleviating the problem.In this paper we address the issue of overwhelmingly large output size by introducing and studying the following problem: What are the k sets that best approximate a collection of frequent item sets? Our measure of approximating a collection of sets by k sets is defined to be the size of the collection covered by the the k sets, i.e., the part of the collection that is included in one of the k sets. We also specify a bound on the number of extra sets that are allowed to be covered. We examine different problem variants for which we demonstrate the hardness of the corresponding problems and we provide simple polynomial-time approximation algorithms. We give empirical evidence showing that the approximation methods work well in practice. Foto N. Afrati, Aristides Gionis, Heikki Mannila |
KDD | 3 |
| 2004 | Dense itemsetsabstractFrequent itemset mining has been the subject of a lot of work in data mining research ever since association rules were introduced. In this paper we address a problem with frequent itemsets: that they only count rows where all their attributes are present, and do not allow for any noise. We show that generalizing the concept of frequency while preserving the performance of mining algorithms is nontrivial, and introduce a generalization of frequent itemsets, dense itemsets. Dense itemsets do not require all attributes to be present at the same time; instead, the itemset needs to define a sufficiently large submatrix that exceeds a given density threshold of attributes present.We consider the problem of computing all dense itemsets in a database. We give a levelwise algorithm for this problem, and also study the top-$k$ variations, i.e., finding the k densest sets with a given support, or the k best-supported sets with a given density. These algorithms select the other parameter automatically, which simplifies mining dense itemsets in an explorative way. We show that the concept captures natural facets of data sets, and give extensive empirical results on the performance of the algorithms. Combining the concept of dense itemsets with set cover ideas, we also show that dense itemsets can be used to obtain succinct descriptions of large datasets. We also discuss some variations of dense itemsets. Jouni K. Seppänen, Heikki Mannila |
KDD | 2 |
| 2004 | Geometric and Combinatorial Tiles in 0-1 Data
Aristides Gionis, Heikki Mannila, Jouni K. Seppänen |
PKDD | 2 |
| 2004 | Relational link-based ranking
Floris Geerts, Heikki Mannila, Evimaria Terzi |
VLDB | 2 |
| 2004 | Editorial
Usama M. Fayyad, Heikki Mannila, Raghu Ramakrishnan 0001 |
Data Min. Knowl. Discov. | 2 |
| 2004 | Editorial
Usama M. Fayyad, Heikki Mannila, Raghu Ramakrishnan 0001 |
Data Min. Knowl. Discov. | 2 |
| 2003 | Fragments of orderabstractHigh-dimensional collections of 0--1 data occur in many applications. The attributes in such data sets are typically considered to be unordered. However, in many cases there is a natural total or partial order ≺ underlying the variables of the data set. Examples of variables for which such orders exist include terms in documents, courses in enrollment data, and paleontological sites in fossil data collections. The observations in such applications are flat, unordered sets; however, the data sets respect the underlying ordering of the variables. By this we mean that if A ≺ B ≺ C are three variables respecting the underlying ordering ≺, and both of variables A and C appear in an observation, then, up to noise levels, variable B also appears in this observation. Similarly, if A1 ≺ A2 ≺ … ≺ Al-1 ≺ Ai is a longer sequence of variables, we do not expect to see many observations for which there are indices i < j < k such that Ai and Ak occur in the observation but Aj does not.In this paper we study the problem of discovering fragments of orders of variables implicit in collections of unordered observations. We define measures that capture how well a given order agrees with the observed data. We describe a simple and efficient algorithm for finding all the fragments that satisfy certain conditions. We also discuss the sometimes necessary postprocessing for selecting only the best fragments of order. Also, we relate our method with a sequencing approach that uses a spectral algorithm, and with the consecutive ones problem. We present experimental results on some real data sets (author lists of database papers, exam results data, and paleontological data). Aristides Gionis, Teija Kujala, Heikki Mannila |
KDD | 3 |
| 2003 | Rule Discovery and Probabilistic Modeling for Onomastic Data
Antti Leino, Heikki Mannila, Ritva Liisa Pitkänen |
PKDD | 2 |
| 2003 | The Pattern Ordering Problem
Taneli Mielikäinen, Heikki Mannila |
PKDD | 2 |
| 2003 | A Simple Algorithm for Topic Identification in 0-1 Data
Jouni K. Seppänen, Ella Bingham, Heikki Mannila |
PKDD | 3 |
| 2003 | Finding recurrent sources in sequencesabstractMany genomic sequences and, more generally, (multivariate) time series display tremendous variability. However, often it is reasonable to assume that the sequence is actually generated by or assembled from a small number of sources, each of which might contribute several segments to the sequence. That is, there are h hidden sources such that the sequence can be written as a concatenation of k > h pieces, each of which stems from one of the h sources. We define this (k,h)-segmentation problem and show that it is NP-hard in the general case. We give approximation algorithms achieving approximation ratios of 3 for the L1 error measure and √5 for the L2 error measure, and generalize the results to higher dimensions. We give empirical results on real (chromosome 22) and artificial data showing that the methods work well in practice. Aristides Gionis, Heikki Mannila |
RECOMB | 2 |
| 2003 | Mixture Models and Frequent Sets: Combining Global and Local Methods for 0-1 DataabstractWe study the interaction between global and local techniques in data mining. Specifically, we study the collections of frequent sets in clusters produced by a probabilistic clustering using mixtures of Bernoulli models. That is, we first analyze 0–1 datasets by a global technique (probabilistic clustering using the EM algorithm) and then do a local analysis (discovery of frequent sets) in each of the clusters. The results indicate that the use of clustering as a preliminary phase in finding frequent sets produces clusters that have significantly different collections of frequent sets. We also test the significance of the differences in the frequent set collections in the different clusters by obtaining estimates of the underlying joint density. To get from the local patterns in each cluster back to distributions, we use the maximum entropy technique [17] to obtain a local model for each cluster, and then combine these local models to get a mixture model. We obtain clear improvements to the approximation quality against the use of either the mixture model or the maximum entropy model. Jaakko Hollmén, Jouni K. Seppänen, Heikki Mannila |
SDM | 3 |
| 2003 | Beyond Independence: Probabilistic Models for Query Approximation on Binary Transaction DataabstractWe investigate the problem of generating fast approximate answers to queries posed to large sparse binary data sets. We focus in particular on probabilistic model-based approaches to this problem and develop a number of techniques that are significantly more accurate than a baseline independence model. In particular, we introduce two techniques for building probabilistic models from frequent itemsets: the itemset maximum entropy model and the itemset inclusion-exclusion model. In the maximum entropy model, we treat itemsets as constraints on the distribution of the query variables and use the maximum entropy principle to build a joint probability model for the query attributes online. In the inclusion-exclusion model, itemsets and their frequencies are stored in a data structure, called an ADtree, that supports an efficient implementation of the inclusion-exclusion principle in order to answer the query. We empirically compare these two itemset-based models to direct querying of the original data, querying of samples of the original data, as well as other probabilistic models such as the independence model, the Chow-Liu tree model, and the Bernoulli mixture model. These models are able to handle high-dimensionality (hundreds or thousands of attributes), whereas most other work on this topic has focused on relatively low-dimensional OLAP problems. Experimental results on both simulated and real-world transaction data sets illustrate various fundamental trade offs between approximation error, model complexity, and the online time required to compute a query answer. Dmitry Pavlov, Heikki Mannila, Padhraic Smyth |
IEEE Trans. Knowl. Data Eng. | 2 |
| 2003 | Discovering all most specific sentencesabstractData mining can be viewed, in many instances, as the task of computing a representation of a theory of a model or a database, in particular by finding a set of maximally specific sentences satisfying some property. We prove some hardness results that rule out simple approaches to solving the problem.The a priori algorithm is an algorithm that has been successfully applied to many instances of the problem. We analyze this algorithm, and prove that is optimal when the maximally specific sentences are "small". We also point out its limitations.We then present a new algorithm, the Dualize and Advance algorithm, and prove worst-case complexity bounds that are favorable in the general case. Our results use the concept of hypergraph transversals. Our analysis shows that the a priori algorithm can solve the problem of enumerating the transversals of a hypergraph, improving on previously known results in a special case. On the other hand, using results for the general case of the hypergraph transversal enumeration problem, we can show that the Dualize and Advance algorithm has worst-case running time that is sub-exponential to the output size (i.e., the number of maximally specific sentences).We further show that the problem of finding maximally specific sentences is closely related to the problem of exact learning with membership queries studied in computational learning theory. Dimitrios Gunopulos, Roni Khardon, Heikki Mannila, Sanjeev Saluja, Hannu Toivonen, Ram Sewak Sharm |
ACM Trans. Database Syst. | 3 |
| 2002 | Local and Global Methods in Data Mining: Basic Techniques and Open Problems
Heikki Mannila |
ICALP | 1 |
| 2002 | OSSM: A Segmentation Approach to Optimize Frequency CountingabstractComputing the frequency of a pattern is one of the key operations in data mining algorithms. We describe a simple yet powerful way of speeding up any form of frequency counting satisfying the monotonicity condition. Our method, the optimized segment support map (OSSM), is a light-weight structure which partitions the collection of transactions into m segments, so as to reduce the number of candidate patterns that require frequency counting. We study the following problems: (1) what is the optimal number of segments to be used; and (2) given a user-determined m, what is the best segmentation/composition of the m segments? For Problem 1, we provide a thorough analysis and a theorem establishing the minimum value of m for which there is no accuracy lost in using the OSSM. For Problem 2, we develop various algorithms and heuristics, which efficiently generate OSSMs that are compact and effective, to help facilitate segmentation. Carson K. Leung, Raymond T. Ng, Heikki Mannila |
ICDE | 3 |
| 2002 | A Theory of Inductive Query AnsweringabstractWe introduce the Boolean inductive query evaluation problem, which is concerned with answering inductive queries that are arbitrary Boolean expressions over monotonic and anti-monotonic predicates. Secondly, we develop a decomposition theory for inductive query evaluation in which a Boolean query Q is reformulated into k sub-queries Q/sub i/ = Q/sub A/ /spl and/ Q/sub M/ that are the conjunction of a monotonic and an anti-monotonic predicate. The solution to each subquery can be represented using a version space. We investigate how the number of version spaces k needed to answer the query can be minimized. Thirdly, for the pattern domain of strings, we show how the version spaces can be represented using a novel data structure, called the version space tree, and can be computed using a variant of the famous a priori algorithm. Finally, we present experiments that validate the approach. Luc De Raedt, Manfred Jaeger, Sau Dan Lee, Heikki Mannila |
ICDM | 4 |
| 2002 | Topics in 0--1 dataabstractLarge 0--1 datasets arise in various applications, such as market basket analysis and information retrieval. We concentrate on the study of topic models, aiming at results which indicate why certain methods succeed or fail. We describe simple algorithms for finding topic models from 0--1 data. We give theoretical results showing that the algorithms can discover the epsilon-separable topic models of Papadimitriou et al. We present empirical results showing that the algorithms find natural topics in real-world data sets. We also briefly discuss the connections to matrix approaches, including nonnegative matrix factorization and independent component analysis. Ella Bingham, Heikki Mannila, Jouni K. Seppänen |
KDD | 2 |
| 2002 | Long-range control of expression in yeastabstractAbstract Contact: [email protected] * To whom correspondence should be addressed. Heikki Mannila, Anne Patrikainen, Jouni K. Seppänen, Juha Kere |
Bioinform. | 1 |
| 2001 | Combining Discrete Algorithmic and Probabilistic Approaches in Data Mining
Heikki Mannila |
ECML | 1 |
| 2001 | Time Series Segmentation for Context Recognition in Mobile DevicesabstractRecognizing the context of use is important in making mobile devices as simple to use as possible. Finding out what the user's situation is can help the device and underlying service in providing an adaptive and personalized user interface. The device can infer parts of the context of the user from sensor data: the mobile device can include sensors for acceleration, noise level, luminosity, humidity, etc. In this paper we consider context recognition by unsupervised segmentation of time series produced by sensors. Dynamic programming can be used to find segments that minimize the intra-segment variances. While this method produces optimal solutions, it is too slow for long sequences of data. We present and analyze randomized variations of the algorithm. One of them, global iterative replacement or GIR, gives approximately optimal results in a fraction of the time required by dynamic programming. We demonstrate the use of time series segmentation in context recognition for mobile phone applications. Johan Himberg, Kalle Korpiaho, Heikki Mannila, Johanna Tikanmäki, Hannu Toivonen |
ICDM | 3 |
| 2001 | Random projection in dimensionality reduction: applications to image and text dataabstractRandom projections have recently emerged as a powerful method for dimensionality reduction. Theoretical results indicate that the method preserves distances quite nicely; however, empirical results are sparse. We present experimental results on using random projection as a dimensionality reduction tool in a number of cases, where the high dimensionality of the data would otherwise lead to burden-some computations. Our application areas are the processing of both noisy and noiseless images, and information retrieval in text documents. We show that projecting the data onto a random lower-dimensional subspace yields results comparable to conventional dimensionality reduction methods such as principal component analysis: the similarity of data vectors is preserved well under random projection. However, using random projections is computationally significantly less expensive than using, e.g., principal component analysis. We also show experimentally that using a sparse random matrix gives additional computational savings in random projection. Ella Bingham, Heikki Mannila |
KDD | 2 |
| 2001 | Probabilistic modeling of transaction data with applications to profiling, visualization, and predictionabstractTransaction data is ubiquitous in data mining applications. Examples include market basket data in retail commerce, telephone call records in telecommunications, and Web logs of individual page-requests at Web sites. Profiling consists of using historical transaction data on individuals to construct a model of each individual's behavior. Simple profiling techniques such as histograms do not generalize well from sparse transaction data. In this paper we investigate the application of probabilistic mixture models to automatically generate profiles from large volumes of transaction data. In effect, the mixture model represents each individual's behavior as a linear combination of "basis transactions." We evaluate several variations of the model on a large retail transaction data set and show that the proposed model provides improved predictive power over simpler histogram-based techniques, as well as being relatively scalable, interpretable, and flexible. In addition we point to applications in outlier detection, customer ranking, interactive visualization, and so forth. The paper concludes by comparing and relating the proposed framework to other transaction-data modeling techniques such as association rules. Igor V. Cadez, Padhraic Smyth, Heikki Mannila |
KDD | 3 |
| 2001 | Finding simple intensity descriptions from event sequence dataabstractSequences of events are an important type of data arising in various applications, including telecommunications, bio-statistics, web access analysis, etc. A basic approach to modeling such sequences is to find the underlying intensity functions describing the expected number of events per time unit. Typically, the intensity functions are assumed to be piecewise constant. We therefore consider different ways of fitting intensity models to event sequence data. We start by considering a Bayesian approach using Markov chain Monte Carlo (MCMC) methods with varying number of pieces. These methods can be used to produce posterior distributions on the intensity functions and they can also accomodate covariates. The drawback is that they are computationally intensive and thus are not very suitable for data mining applications in which large numbers of intensity functions have to be estimated. We consider dynamic programming approaches to finding the change points in the intensity functions. These methods can find the maximum likelihood intensity function in O(n2k) time for a sequence of n events and k different pieces of intensity. We show that simple heuristics can be used to prune the number of potential change points, yielding speedups of several orders of magnitude. The results of the improved dynamic programming method correspond very closely with the posterior averages produced by the MCMC methods. Heikki Mannila, Marko Salmenkivi |
KDD | 1 |
| 2001 | Combining Discrete Algorithmic and Probabilistic Approaches in Data Mining
Heikki Mannila |
PKDD | 1 |
| 2001 | Decomposition of Event Sequences into Independent Componentsabstract1 Introduction Many real-world processes result in an extensive logs of sequences of events, i.e., events coupled with time of occurrence. Examples of such process logs include alarms produced by a large telecommunication network, web-access data, biostatistics, etc. In many cases, it is useful to decompose the incoming stream of events into the number of independent streams. Such decomposition may reveal valuable information about the event generating process, e.g. dependencies among alarms in the telecommunication network, relationships between web-users and relevant symptoms of the decease. It may, as well, facilitate further analysis of the data by working with independent components separately. Heikki Mannila, Dmitry Rusakov |
SDM | 1 |
| 2001 | Finding similar situations in sequences of events via random projectionsabstractSequences of events arise naturally in various applications. Such sequences consist of pairs of event type and occurrence time. The similarity search problem is the following: given a query window into the sequence, i.e., the subsequence consisting of the events occurring within a period of time, find all windows of the sequence such that they are similar to the query window. The similarity between two windows is defined by an edit distance notion. The edit distance between two windows in an event sequence can be computed using dynamic programming algorithms, but such computations are slow. We show how a fingerprinting approach can radically improve the performance. We map fixed-width windows of the data to k-dimensional real vectors by random projections, i.e., by assigning to each event type a random vector and combining the vectors corresponding to the events of a window in a sum, weighted by the relative positions of the events. Then, the ordinary Euclidean distance between k-vectors is used as the approximate distance between windows. We show that small variations in a window have a small expected effect in the feature space. Thus, if two windows have small edit distance, the random projections can be expected to have small distance, and vice versa. The time and space complexity of the mapping is O(kn), where n is the length of the input sequence. We give test results on telecommunications alarm data and the Entree Chicago data of the UCI KDD Archive, showing that the method indeed finds similar situations and works quite fast. Heikki Mannila, Jouni K. Seppänen |
SDM | 1 |
| 2000 | Gene Mapping by Haplotype Pattern MiningabstractGenetic markers are being increasingly utilized in gene mapping. The discovery of associations between markers and patient phenotypes - such as a disease status - enables the identification of potential disease gene loci. The rationale is that, in diseases with a reasonable genetic contribution, diseased individuals are more likely to have associated marker alleles near the disease susceptibility gene than control individuals. We describe a new gene mapping method-haplotype pattern mining (HPM) - that is based on discovering recurrent marker patterns. We define a class of useful haplotype patterns in genetic case-control data, give an algorithm for finding disease-associated haplotypes, and show how to use them to identify disease susceptibility loci. Experimental studies show that the method has good localization power in data sets with large degrees of phenocopies and with lots of missing and erroneous data. We also demonstrate how the method can be used to discover several genes simultaneously. Hannu Toivonen, Paivi Onkamo, Kari Vasko, Vesa Ollikainen, Petteri Sevon, Heikki Mannila, Juha Kere |
BIBE | 6 |
| 2000 | Approximate Query Answering with Frequent Sets and Maximum Entropy
Heikki Mannila, Padhraic Smyth |
ICDE | 1 |
| 2000 | Global partial orders from sequential dataabstractSequences of events arise in many applications, such a s w eb browsing, e-commerce, and monitoring of processes.An importan t problem in mining sets of sequences of ev ents is to get an o verview of the ordering relationships in the data.W e presen t a method for nding partial orders that describe the ordering relationships between the events in a collection of sequences.The method is based on viewing a partial order as a generative model for a set of sequences, and applying mixture modeling techniques to obtain a descriptive s e t o f partial orders.Runtimes for our algorithm scale linearly in the number of sequences and polynomially in the number of dierent e v ent t ypes.Thus, the methods scales to handle large data sets and can be used for reasonable numbers of dierent t ypes of events.We illustrate our technique by applying it to studen tenrollment data and web browsing data. Heikki Mannila, Christopher Meek |
KDD | 1 |
| 2000 | Context-Based Similarity Measures for Categorical Databases
Gautam Das 0001, Heikki Mannila |
PKDD | 2 |
| 2000 | Probabilistic Models for Query Approximation with Large Sparse Binary Data Sets
Dmitry Pavlov, Heikki Mannila, Padhraic Smyth |
UAI | 2 |
| 1999 | Modeling KDD Processes within the Inductive Database Framework
Jean-François Boulicaut, Mika Klemettinen, Heikki Mannila |
DaWaK | 3 |
| 1999 | Similarity between Event Types in Sequences
Heikki Mannila, Pirjo Moen |
DaWaK | 1 |
| 1999 | Prediction with Local Patterns using Cross-EntropyabstractSets of local patterns in the forms of rules and co-occurrence counts are produced by many data mining methods such as association rule algorithms.While such patterns can yield useful insights it is not obvious how to synthesize local sparse information into a coherent global predictive model.We study the use of a cross-entropy approach to combining local patterns.Each local pattern is viewed as a constraint on an appropriate high-order joint distribution of interest.Typically, a set of patterns returned by a data mining algorithm under-constrains the high-order model.The cross-entropy criterion is used to select a specific distribution in this constrained family relative to a prior.We review the iterative-scaling algorithm which is an iterative technique for hiding a joint distribution given constraints.We then illustrate the application of this method to two specific problems.The first problem is combining information about frequent itemsets.We show that the cross-entropy approach can be used for query selectivity estimation for O/l data sets.The results show that we can accurately answer a large class of queries using just a small set of aggregate information.The second problem involves sequence modeling using historical rules, with an application to protejn sequences.We conclude that viewing local patterns as constraints on a high-order probability model is a useful and principled framework for prediction based on large sets of mined patterns. Heikki Mannila, Dmitry Pavlov, Padhraic Smyth |
KDD | 1 |
| 1999 | Association Rule Selection in a Data Mining Environment
Mika Klemettinen, Heikki Mannila, A. Inkeri Verkamo |
PKDD | 2 |
| 1999 | Reasoning with Examples: Propositional Formulae and Database Dependencies
Roni Khardon, Heikki Mannila, Dan Roth 0001 |
Acta Informatica | 2 |
| 1999 | Interactive exploration of interesting findings in the Telecommunication Network Alarm Sequence Analyzer (TASA)
Mika Klemettinen, Heikki Mannila, Hannu Toivonen |
Inf. Softw. Technol. | 2 |
| 1999 | Borders: An Efficient Algorithm for Association Generation in Dynamic Databases
Yonatan Aumann, Ronen Feldman, Orly Liphstat, Heikki Mannila |
J. Intell. Inf. Syst. | 4 |
| 1998 | Learning, Mining, or Modeling? A Case Study from Paleocology
Heikki Mannila, Hannu Toivonen, Atte Korhola, Heikki Olander |
Discovery Science | 1 |
| 1998 | Rule Discovery from Time Series
Gautam Das 0001, King-Ip Lin, Heikki Mannila, Gopal Renganathan, Padhraic Smyth |
KDD | 3 |
| 1998 | Similarity of Attributes by External Probes
Gautam Das 0001, Heikki Mannila, Pirjo Ronkainen |
KDD | 2 |
| 1998 | Querying Inductive Databases: A Case Study on the MINE RULE Operator
Jean-François Boulicaut, Mika Klemettinen, Heikki Mannila |
PKDD | 3 |
| 1997 | Time-Series Similarity Problems and Well-Separated Geometric SetsabstractGiven a pair of nonidentical complex objects, defining (and determining) how similar they are to each other is a nontrivial problem. In data mining applications, one frequently needs to determine the similarity between two time series. We analyze a model of timeseries similarity that allows outliers, different scaling functions, and variable sampling rates. We present several deterministic and randomized algorithms for computing this notion of similarity. The algorithms are based on nontrivial tools and methods from computational geometry. In particular, we use properties of families of well-separated geometric sets. The randomized algorithm has provably good performance and also works extremely efficiently in practice. 1 Introduction Being able to measure the similarity between objects is a crucial issue in many data retrieval and data mining applications; see [10] for a general discussion on similarity queries. Typically, the task is to define a function Sim(X;Y ), where X and Y are... Béla Bollobás, Gautam Das 0001, Dimitrios Gunopulos, Heikki Mannila |
SCG | 4 |
| 1997 | Discovering All Most Specific Sentences by Randomized Algorithms
Dimitrios Gunopulos, Heikki Mannila, Sanjeev Saluja |
ICDT | 2 |
| 1997 | Methods and Problems in Data Mining
Heikki Mannila |
ICDT | 1 |
| 1997 | Finding Similar Time Series
Gautam Das 0001, Dimitrios Gunopulos, Heikki Mannila |
PKDD | 3 |
| 1997 | Data mining, Hypergraph Transversals, and Machine LearningabstractSeveral data mining problems can be formulated as problems of finding maximally specific sentences that are interesting in a database. We first show that this problem has a close relationship with the hypergraph transversal problem. We then analyze two algorithms that have been previously used in data mining, proving upper bounds on their complexity. The first algorithm is useful when the maximally specific interesting sentences are "small". We show that this algorithm can also be used to efficiently solve a special case of the hypergraph transversal problem, improving on previous results. The second algorithm utilizes a subroutine for hypergraph transversals, and is applicable in more general situations, with complexity close to a lower bound for the problem. We also relate these problems to the model of exact learning in computational learning theory, and use the correspondence to derive some corollaries. Dimitrios Gunopulos, Roni Khardon, Heikki Mannila, Hannu Toivonen |
PODS | 3 |
| 1997 | Distance Measures for Point Sets and their Computation
Thomas Eiter, Heikki Mannila |
Acta Informatica | 2 |
| 1997 | Levelwise Search and Borders of Theories in Knowledge Discovery
Heikki Mannila, Hannu Toivonen |
Data Min. Knowl. Discov. | 1 |
| 1997 | Discovery of Frequent Episodes in Event Sequences
Heikki Mannila, Hannu Toivonen, A. Inkeri Verkamo |
Data Min. Knowl. Discov. | 1 |
| 1997 | Disjunctive DatalogabstractWe consider disjunctive Datalog, a powerful database query language based on disjunctive logic programming. Briefly, disjunctive Datalog is a variant of Datalog where disjunctions may appear in the rule heads; advanced versions also allow for negation in the bodies which can be handled according to a semantics for negation in disjunctive logic programming. In particular, we investigate three different semantics for disjunctive Datalog: the minimal model semantics the perfect model semantics, and the stable model semantics. For each of these semantics, the expressive power and complexity are studied. We show that the possibility variants of these semantics express the same set of queries. In fact, they precisely capture the complexity class Σ P 2 . Thus, unless the Polynomial Hierarchy collapses, disjunctive Datalog is more expressive that normal logic programming with negation. These results are not only of theoretical interest; we demonstrate that problems relevant in practice such as computing the optimal tour value in the Traveling Salesman Problem and eigenvector computations can be handled in disjunctive Datalog, but not Datalog with negation (unless the Polynomial Hierarchy collapses). In addition, we study modularity properties of disjunctive Datalog and investigate syntactic restrictions of the formalisms. Thomas Eiter, Georg Gottlob, Heikki Mannila |
ACM Trans. Database Syst. | 3 |
| 1996 | Schema Design and Knowledge Discovery (Abstract)
Heikki Mannila |
ER | 1 |
| 1996 | Knowledge Discovery from Telecommunication Network Alarm DatabasesabstractA telecommunication network produces daily large amounts of alarm data. The data contains hidden valuable knowledge about the behavior of the network. This knowledge can be used in filtering redundant alarms, locating problems in, the network, and possibly in predicting severe faults. We describe the TASA (Telecommunication Network Alarm Sequence Analyzer) system for discovering and browsing knowledge from large alarm databases. The system is built on the basis of viewing knowledge discovery as an interactive and iterative process, containing data collection, pattern discovery, rule postprocessing, etc. The system uses a novel framework for locating frequently occurring episodes from sequential data. The TASA system offers a variety of selection and ordering criteria for episodes, and supports iterative retrieval from the discovered knowledge. This means that a large part of the iterative nature of the KDD process can be replaced by iteration in the rule postprocessing stage. The user interface is based on dynamically generated HTML. The system is in experimental use, and the results are encouraging: some of the discovered knowledge is being integrated into the alarm handling software of telecommunication operators. Kimmo Hätönen, Mika Klemettinen, Heikki Mannila, Pirjo Ronkainen, Hannu Toivonen |
ICDE | 3 |
| 1996 | Data Mining and Machine Learning (Abstract)
Heikki Mannila |
ICML | 1 |
| 1996 | Discovering Generalized Episodes Using Minimal Occurrences
Heikki Mannila, Hannu Toivonen |
KDD | 1 |
| 1996 | Multiple Uses of Frequent Sets and Condensed Representations (Extended Abstract)
Heikki Mannila, Hannu Toivonen |
KDD | 1 |
| 1996 | TASA: Telecommunication Alarm Sequence Analyzer or how to enjoy faults in your networkabstractToday's large and complex telecommunication networks produce large amounts of alarms daily. The sequence of alarms contains valuable knowledge about the behavior of the network, but much of the knowledge is fragmented and hidden in the vast amount of data. Regularities in the alarms can be used in fault management applications, e.g., for filtering redundant alarms, locating problems in the network, and possibly in predicting severe faults. In this paper we describe TASA (Telecommunication Alarm Sequence Analyzer), a novel system for discovering interesting regularities in the alarms. In the core of the system are algorithms for locating frequent alarm episodes from the alarm stream and presenting them as rules. Discovered rules can then be explored with flexible information retrieval tools that support iteration. The user interface is hypertext, based on HTML, and can be used with a standard WWW browser. TASA is in experimental use and has already discovered rules that have been integrated into the alarm handling software of an operator. Kimmo Hätönen, Mika Klemettinen, Heikki Mannila, Pirjo Ronkainen, Hannu Toivonen |
NOMS | 3 |
| 1996 | Data Mining: Machine Learning, Statistics, and DatabasesabstractKnowledge discovery in databases and data mining aim at semiautomatic tools for the analysis of large data sets. We give an overview of the area and present some of the research issues, especially from the database angle. Heikki Mannila |
SSDBM | 1 |
| 1995 | A Perspective on Databases and Data Mining
Marcel Holsheimer, Martin L. Kersten, Heikki Mannila, Hannu Toivonen |
KDD | 3 |
| 1995 | Discovering Frequent Episodes in Sequences
Heikki Mannila, Hannu Toivonen, A. Inkeri Verkamo |
KDD | 1 |
| 1995 | Recognizing Renamable Generalized Propositional Horn Formulas Is NP-complete
Thomas Eiter, Pekka Kilpeläinen, Heikki Mannila |
Discret. Appl. Math. | 3 |
| 1995 | Ordered and Unordered Tree InclusionabstractThe following tree-matching problem is considered: Given labeled trees P and T, can P be obtained from T by deleting nodes? Deleting a node u entails removing all edges incident to u and, if u has a parent v, replacing the edge from v to u by edges from v to the children of u. The problem is motivated by the study of query languages for structured text databases. Simple solutions to this problem require exponential time. For ordered trees an algorithm is presented that requires $O(|P||T|)$ time and space. The corresponding problem for unordered trees is also considered and a proof of its NP-completeness is given. An algorithm is presented for the unordered problem. This algorithm works in $O(|P||T|)$ time if the out-degrees of the nodes in P are bounded by a constant, and in polynomial time if they are $O(\log |T|)$. Pekka Kilpeläinen, Heikki Mannila |
SIAM J. Comput. | 2 |
| 1995 | Approximate Inference of Functional Dependencies from Relations
Jyrki Kivinen, Heikki Mannila |
Theor. Comput. Sci. | 2 |
| 1994 | Finding Interesting Rules from Large Sets of Discovered Association RulesabstractAssociation rules, introduced by Agrawal, Imielinski, and Swami, are rules of the form "for 90 % of the rows of the relation, if the row has value 1 in the columns in set W , then it has 1 also in column B". Efficient methods exist for discovering association rules from large collections of data. The number of discovered rules can, however, be so large that browsing the rule set and finding interesting rules from it can be quite difficult for the user. We show how a simple formalism of rule templates makes it possible to easily describe the structure of interesting rules. We also give examples of visualization of rules, and show how a visualization tool interfaces with rule templates. 1 Introduction Data mining (knowledge discovery in databases) is a field of increasing interest combining databases, artificial intelligence, and machine learning. The purpose of data mining is to facilitate understanding large amounts of data by discovering interesting regularities or exceptions (see e... Mika Klemettinen, Heikki Mannila, Pirjo Ronkainen, Hannu Toivonen, A. Inkeri Verkamo |
CIKM | 2 |
| 1994 | Query Primitives for Tree-Structured Data
Pekka Kilpeläinen, Heikki Mannila |
CPM | 2 |
| 1994 | An ALgorithm for Learning Hierarchical Classifiers
Jyrki Kivinen, Heikki Mannila, Esko Ukkonen, Jaak Vilo |
ECML | 2 |
| 1994 | Adding Disjunction to DatalogabstractWe study the expressive power and complexity of disjunctive datalog, i.e., datalog with disjunctive rule heads, under three different semantics: the minimal model semantics, the perfect models semantics, and the stable model semantics. We show that the brave variants of these semantics express the same set of queries. In fact, they precisely capture the complexity of class ΣP/2. The combined complexity of disjunctive datalog is shown to be NEXPTIMENP-complete. Thomas Eiter, Georg Gottlob, Heikki Mannila |
PODS | 3 |
| 1994 | The Power of Sampling in Knowledge DiscoveryabstractWe consider the problem of approximately verifying the truth of sentences of tuple relational calculus in a given relation M by considering only a random sample of M. We define two different measures for the error of a universal sentence in a relation. For a set of n universal sentences each with at most k universal quantifiers, we give upper and lower bounds for the sample sizes required for having a high probability that all the sentences with error at least ε can be detected as false by considering the sample. The sample sizes are O((log n)/ε) or O((|M|1–1/k)log n/ε), depending on the error measure used. We also consider universal-existential sentences. Jyrki Kivinen, Heikki Mannila |
PODS | 2 |
| 1994 | Algorithms for Inferring Functional Dependencies from Relations
Heikki Mannila, Kari-Jouko Räihä |
Data Knowl. Eng. | 1 |
| 1993 | Retrieval from Hierarchical Texts by Partial PatternsabstractStructured texts (for example dictionaries and user manuals) typically have a heirarchical (tree-like) structure. We describe a query language for retrieving information from collections of hierarchical text. The language is based on a tree pattern matching notion called tree inclusion. Tree inclusion allows easy expression of queries that use the structure and the content of the document. In using it a user need not be aware of the whole structure of the database. Thus a language based on tree inclusion is data independent, a property made necessary because of the great variance in the structure of the texts. Pekka Kilpeläinen, Heikki Mannila |
SIGIR | 2 |
| 1993 | Right Invariant Metrics and Measures of Presortedness
Vladimir Estivill-Castro, Heikki Mannila, Derick Wood |
Discret. Appl. Math. | 2 |
| 1992 | Learning Hierarchical Rule SetsabstractWe present an algorithm for learning sets of rules that are organized into up to k levels. Each level can contain an arbitrary number of rules "if c then l" where l is the class associated to the level and c is a concept from a given class of basic concepts. The rules of higher levels have precedence over the rules of lower levels and can be used to represent exceptions. As basic concepts we can use Boolean attributes in the infinite attribute space model, or certain concepts defined in terms of substrings. Given a sample of m examples, the algorithm runs in polynomial time and produces a consistent concept representation of size O((log m) k n k ), where n is the size of the smallest consistent representation with k levels of rules. This implies that the algorithm learns in the PAC model. The algorithm repeatedly applies the greedy heuristics for weighted set cover. The weights are obtained from approximate solutions to previous set cover problems. Key words: computational learni... Jyrki Kivinen, Heikki Mannila, Esko Ukkonen |
COLT | 2 |
| 1992 | Grammatical Tree Matching
Pekka Kilpeläinen, Heikki Mannila |
CPM | 2 |
| 1992 | Approximate Dependency Inference from Relations
Jyrki Kivinen, Heikki Mannila |
ICDT | 2 |
| 1992 | On the Complexity of Inferring Functional Dependencies
Heikki Mannila, Kari-Jouko Räihä |
Discret. Appl. Math. | 1 |
| 1992 | Discovering functional and inclusion dependencies in relational databasesabstractWe consider the problem of discovering the functional and inclusion dependencies that a given database instance satisfies. This technique is used in a database design tool that uses example databases to give feedback to the designer. If the examples show deficiencies in the design, the designer can directly modify the examples. the tool then infers new dependencies and the database schema can be modified, if necessary. the discovery of the functional and inclusion dependencies can also be used in analyzing an existing database. the problem of inferring functional dependencies has several connections to other topics in knowledge discovery and machine learning. In this article we discuss the use of examples in the design of databases, and give an overview of the complexity results and algorithms that have been developed for this problem. © 1992 John Wiley & Sons, Inc. Martti Kantola, Heikki Mannila, Kari-Jouko Räihä, Harri Siirtola |
Int. J. Intell. Syst. | 2 |
| 1989 | Practical Algorithms for Finding Prime Attributes and Testing Normal FormsabstractSeveral decision problems for relational schemas with functional dependencies are computationally hard. Such problems include determining whether an attribute is prime and testing if a schema is in normal form. Algorithms for these problems are needed in database design tools. The problems can be solved by trivial exponential algorithms. Although the size of the instance is usually given by the number of attributes and hence is fairly small, such exponential algorithms are not usable for all design tasks. We give algorithms for these problems whose running time is polynomial in the number of maximal sets not determining an attribute or, equivalently, the number of generators of the family of closed attribute sets. There is theoretical and practical evidence that this quantity is small for the schemas occurring in practice and exponential only for pathological schemas. The algorithms are simple to implement and fast in practice. They are in use in the relational database design tool Design-By-Example. Heikki Mannila, Kari-Jouko Räihä |
PODS | 1 |
| 1989 | Automatic Generation of Test Data for Relational Queries
Heikki Mannila, Kari-Jouko Räihä |
J. Comput. Syst. Sci. | 1 |
| 1987 | Dependency Inference
Heikki Mannila, Kari-Jouko Räihä |
VLDB | 1 |
| 1986 | The Set Union Problem with Backtracking
Heikki Mannila, Esko Ukkonen |
ICALP | 1 |
| 1986 | Inclusion Dependencies in Database DesignabstractA design methodology for relational databases is developed. The main aspects of the methodology are the following. (a) It uses functional dependencies and inclusion dependencies. The latter are essential to model properly e.g. isa-relationships. (b) It is incremental: the database scheme evolves step by step as new information is considered. (c) It is based on an interaction between the designer and a tool that implements the methodology. The basis of the methodology is a normal form for schemes with functional dependencies and inclusion dependencies. Transformations for incrementally changing a scheme into normal form are given. Heikki Mannila, Kari-Jouko Räihä |
ICDE | 1 |
| 1986 | On the Complexity of Unification Sequences
Heikki Mannila, Esko Ukkonen |
ICLP | 1 |
| 1986 | Test Data for Relational QueriesabstractAn automatic technique for generating a comprehensive test database for a given query is studied.The test database is large enough to cover all essentially different situations under the given set of dependencies, and also large enough to illustrate the effect of each operation appearing in the query.On the other hand, the database attempts to do this in a minimal way.The method can be applied in the testing of queries, e.g. as an aid in learning a new query language.The basis of the construction is the definition of an adequate test case.We characterize this concept using Armstrong relations and show that adequate examples have the desired properties.We also give a method for producing reasonably small example databases for select-project-join queries where each relation scheme appears at most once in the query. Heikki Mannila, Kari-Jouko Räihä |
PODS | 1 |
| 1986 | Design by Example: An Application of Armstrong Relations
Heikki Mannila, Kari-Jouko Räihä |
J. Comput. Syst. Sci. | 1 |
| 1985 | Small Armstrong Relations for Database DesignabstractArticle Free Access Share on Small Armstrong relations for database design Authors: Heikki Mannila View Profile , Kari-Jouko Räihä View Profile Authors Info & Claims PODS '85: Proceedings of the fourth ACM SIGACT-SIGMOD symposium on Principles of database systemsMarch 1985 Pages 245–250https://doi.org/10.1145/325405.325449Published:25 March 1985Publication History 5citation113DownloadsMetricsTotal Citations5Total Downloads113Last 12 Months9Last 6 weeks1 Get Citation AlertsNew Citation Alert added!This alert has been successfully added and will be sent to:You will be notified whenever a record that you have chosen has been cited.To manage your alert preferences, click on the button below.Manage my AlertsNew Citation Alert!Please log in to your account Save to BinderSave to BinderCreate a New BinderNameCancelCreateExport CitationPublisher SiteeReaderPDF Heikki Mannila, Kari-Jouko Räihä |
PODS | 1 |
| 1985 | A Fast Algorithm for Renaming a Set of Clauses as a Horn Set
Heikki Mannila, Kurt Mehlhorn |
Inf. Process. Lett. | 1 |
| 1985 | Measures of Presortedness and Optimal Sorting AlgorithmsabstractThe concept of presortedness and its use in sorting are studied. Natural ways to measure presortedness are given and some general properties necessary for a measure are proposed. A concept of a sorting algorithm optimal with respect to a measure of presortedness is defined, and examples of such algorithms are given. A new insertion sort algorithm is shown to be optimal with respect to three natural measures. The problem of finding an optimal algorithm for an arbitrary measure is studied, and partial results are proven. Heikki Mannila |
IEEE Trans. Computers | 1 |
| 1985 | On the Suitability of Trace Semantics for Modular Proofs of Communicating Processes
Ralph-Johan Back, Heikki Mannila |
Theor. Comput. Sci. | 2 |
| 1984 | Measures of Presortedness and Optimal Sorting Algorithms (Extended Abstract)
Heikki Mannila |
ICALP | 1 |
| 1984 | A Semantic Approach to Program Modularity
Ralph-Johan Back, Heikki Mannila |
Inf. Control. | 2 |
| 1984 | A Simple Linear-Time Algorithm for in Situ Merging
Heikki Mannila, Esko Ukkonen |
Inf. Process. Lett. | 1 |
| 1983 | Derivation of Efficient DAG Marking AlgorithmsabstractThe best known linear-time list marking algorithms also require a linear amount of workspace. Algorithms working in bounded workspace have been obtained only by allowing quadratic execution time or by restricting the list structures to trees. We improve on this here by deriving a new linear-time, bounded workspace marking algorithm that works for dags. The algorithm is derived using correctness-preserving program transformations, which prove the correctness of the algorithm. Our derivation of the marking algorithm provides an example where this method has actually been used to derive a new, more efficient algorithm, rather than just to establish the correctness of a previously known algorithm. Ralph-Johan Back, Heikki Mannila, Kari-Jouko Räihä |
POPL | 2 |
| 1983 | On the Relationship of Minimum and Optimum Covers for a Set of Functional Dependencies
Heikki Mannila, Kari-Jouko Räihä |
Acta Informatica | 1 |
| 1983 | A topological characterization of (λ, μ)*-compactness
Heikki Mannila |
Ann. Pure Appl. Log. | 1 |
| 1982 | Locality in Modular Systems
Ralph-Johan Back, Heikki Mannila |
ICALP | 2 |
| 1982 | A Refinement of Kahn's Semantic to Handle Non-Determinism and Communication (Extended Abstract)abstractSystems of processes connected together by communication channels are studied semantically. A model for such systems, based on traces of communication events, is described. This semantic model is more general than the stream function model described by Kahn, in that it permits processes to have a nondeterministic behaviour. The relationship between these two semantics is discussed. It is shown that the merge anomaly of Brock and Ackermann does not arise in the trace semantics. Ralph-Johan Back, Heikki Mannila |
PODC | 2 |