About: Cube is a research topic. Over the lifetime, 2249 publications have been published within this topic receiving 30122 citations. The topic is also known as: 3-hypercube & regular hexahedron.
TL;DR: The cube operator as discussed by the authors generalizes the histogram, cross-tabulation, roll-up, drill-down, and sub-total constructs found in most report writers, and treats each of the N aggregation attributes as a dimension of N-space.
Abstract: Data analysis applications typically aggregate data across many dimensions looking for anomalies or unusual patterns. The SQL aggregate functions and the GROUP BY operator produce zero-dimensional or one-dimensional aggregates. Applications need the N-dimensional generalization of these operators. This paper defines that operator, called the data cube or simply cube. The cube operator generalizes the histogram, cross-tabulation, roll-up, drill-down, and sub-total constructs found in most report writers. The novelty is that cubes are relations. Consequently, the cube operator can be imbedded in more complex non-procedural data analysis programs. The cube operator treats each of the N aggregation attributes as a dimension of N-space. The aggregate of a particular set of attribute values is a point in this space. The set of points forms an N-dimensional cube. Super-aggregates are computed by aggregating the N-cube to lower dimensional spaces. This paper (1) explains the cube and roll-up operators, (2) shows how they fit in SQL, (3) explains how users can define new aggregate functions for cubes, and (4) discusses efficient techniques to compute the cube. Many of these features are being added to the SQL Standard.
TL;DR: This work developed a general methodology and a general computational tool, which identifies the minimal distance of a given structure to a desired general shape with the same number of vertexes, and employs this tool to evaluate quantitatively the degree of polyhedricity within distorted polyhedra.
Abstract: The continuous symmetry measures approach, designed to assess quantitatively the degree of any symmetry within any structure, is extended to the important class of the polyhedra. For this purpose, we developed a general methodology and a general computational tool, which identify the minimal distance of a given structure to a desired general shape with the same number of vertexes. Specifically, we employ this tool to evaluate quantitatively the degree of polyhedricity within distorted polyhedra, taking as examples the most central and abundant polyhedral structures in chemistry in general and in coordination chemistry in particular, namely the tetrahedron, the bipyramid, the octahedron, the cube, the icosahedron, and the dodecahedron. After describing the properties of the symmetry measurement tool, we show its application and versatility in a number of cases where the deviation from exact symmetry has been an issue, including z-axis Jahn−Teller type polyhedral distortions, tantalum hydride complexes, pen...
TL;DR: In this article, a simple transformation is introduced which facilitates the evaluation of integrals over certain square based pyramids or cubes in cases where the integrand has a singularity at a vertex.
Abstract: A simple transformation is introduced which facilitates the evaluation of integrals over certain square based pyramids or cubes in cases where the integrand has a singularity at a vertex.
TL;DR: The pruning in BUC, combined with an efficient sort method, enables BUC to outperform all previous algorithms for sparse CUBEs, even for computing entire CUBes, and to dramatically improve Iceberg-CUBE computation.
Abstract: We introduce the Iceberg-CUBE problem as a reformulation of the datacube (CUBE) problem. The Iceberg-CUBE problem is to compute only those group-by partitions with an aggregate value (e.g., count) above some minimum support threshold. The result of Iceberg-CUBE can be used (1) to answer group-by queries with a clause such as HAVING COUNT(*) >= X, where X is greater than the threshold, (2) for mining multidimensional association rules, and (3) to complement existing strategies for identifying interesting subsets of the CUBE for precomputation.We present a new algorithm (BUC) for Iceberg-CUBE computation. BUC builds the CUBE bottom-up; i.e., it builds the CUBE by starting from a group-by on a single attribute, then a group-by on a pair of attributes, then a group-by on three attributes, and so on. This is the opposite of all techniques proposed earlier for computing the CUBE, and has an important practical advantage: BUC avoids computing the larger group-bys that do not meet minimum support. The pruning in BUC is similar to the pruning in the Apriori algorithm for association rules, except that BUC trades some pruning for locality of reference and reduced memory requirements. BUC uses the same pruning strategy when computing sparse, complete CUBEs.We present a thorough performance evaluation over a broad range of workloads. Our evaluation demonstrates that (in contrast to earlier assumptions) minimizing the aggregations or the number of sorts is not the most important aspect of the sparse CUBE problem. The pruning in BUC, combined with an efficient sort method, enables BUC to outperform all previous algorithms for sparse CUBEs, even for computing entire CUBEs, and to dramatically improve Iceberg-CUBE computation.
TL;DR: This work introduces a robust technique for directly parametrizing a genus-zero surface onto a spherical domain, and proposes a scheme for sampling the spherical domain using uniformly subdivided polyhedral domains, namely the tetrahedron, octahedrons, and cube.
Abstract: The traditional approach for parametrizing a surface involves cutting it into charts and mapping these piecewise onto a planar domain. We introduce a robust technique for directly parametrizing a genus-zero surface onto a spherical domain. A key ingredient for making such a parametrization practical is the minimization of a stretch-based measure, to reduce scale-distortion and thereby prevent undersampling. Our second contribution is a scheme for sampling the spherical domain using uniformly subdivided polyhedral domains, namely the tetrahedron, octahedron, and cube. We show that these particular semi-regular samplings can be conveniently represented as completely regular 2D grids, i.e. geometry images. Moreover, these images have simple boundary extension rules that aid many processing operations. Applications include geometry remeshing, level-of-detail, morphing, compression, and smooth surface subdivision.