Equivalence of Relational Algebra and Relational Calculus Query Languages Having Aggregate Functions
Journal of the ACM (JACM)
A history and evaluation of System R
Communications of the ACM
Remarks on the algebra of non first normal form relations
PODS '82 Proceedings of the 1st ACM SIGACT-SIGMOD symposium on Principles of database systems
Summary-Table-By-Example: A Database Query Language for Manipulating Summary Data
Proceedings of the First International Conference on Data Engineering
A new normal form for nested relations
ACM Transactions on Database Systems (TODS)
A calculus for complex objects
PODS '86 Proceedings of the fifth ACM SIGACT-SIGMOD symposium on Principles of database systems
Some classes of multilevel relational structures
PODS '86 Proceedings of the fifth ACM SIGACT-SIGMOD symposium on Principles of database systems
ACM Transactions on Database Systems (TODS)
Extended algebra and calculus for nested relational databases
ACM Transactions on Database Systems (TODS)
The derivation problem of summary data
SIGMOD '88 Proceedings of the 1988 ACM SIGMOD international conference on Management of data
A user interface for database creation use and maintenance
SIGSMALL '88 Proceedings of the 1988 ACM SIGSMALL/PC symposium on ACTES
Time-by-Example Query Language for Historical Databases
IEEE Transactions on Software Engineering
Query processing techniques in the summary-table-by-example database query language
ACM Transactions on Database Systems (TODS)
Aggregate evaluability in statistical databases
VLDB '89 Proceedings of the 15th international conference on Very large data bases
On Roth, Korth, and Silberschatz's extended algebra and calculus for nested relational databases
ACM Transactions on Database Systems (TODS)
A universal-scheme approach to statistical databases containing homogeneous summary tables
ACM Transactions on Database Systems (TODS)
Rewriting of rules containing set terms in a logic data language LDL
Proceedings of the seventh ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
A language and a physical organization technique for summary tables
SIGMOD '85 Proceedings of the 1985 ACM SIGMOD international conference on Management of data
On an algebra for historical relational databases: two views
SIGMOD '85 Proceedings of the 1985 ACM SIGMOD international conference on Management of data
On optimizing summary-table-by-example queries
PODS '85 Proceedings of the fourth ACM SIGACT-SIGMOD symposium on Principles of database systems
Query Optimization in Database Systems
ACM Computing Surveys (CSUR)
The power of languages for the manipulation of complex values
The VLDB Journal — The International Journal on Very Large Data Bases
Statistical Relational Databases: Normal Forms
IEEE Transactions on Knowledge and Data Engineering
Mefisto: A Functional Model for Statistical Entities
IEEE Transactions on Knowledge and Data Engineering
Aggregates in the Temporal Query Language TQuel
IEEE Transactions on Knowledge and Data Engineering
Extending the Algebraic Framework of Query Processing to Handle Outerjoins
VLDB '84 Proceedings of the 10th International Conference on Very Large Data Bases
FAD, a Powerful and Simple Database Language
VLDB '87 Proceedings of the 13th International Conference on Very Large Data Bases
Extendible Arrays for Statistical Databases and OLAP Applications
SSDBM '96 Proceedings of the Eighth International Conference on Scientific and Statistical Database Management
Multidimensional databases
Operators for multidimensional aggregate data
Multidimensional databases
Nested bitemporal relational algebra
ISCIS'06 Proceedings of the 21st international conference on Computer and Information Sciences
TempoXML: Nested bitemporal relationship modeling and conversion tool for fuzzy XML
Information Sciences: an International Journal
| Hi-index | 0.00 |
A summary table is one of the useful data structures used in statistical databases. For an algebraic summary table manipulation language, we first extend relational algebra for nested relations and aggregate functions, then propose a summary table manipulation language based on the extended algebra. A new operator, called aggregation-by-template is introduced, and other operators of the relational algebra are modified to apply nested relations. A special case of summary tables, called primitive summary table, is distinquished since it can be directly represented by a nested relation. Primitive summary tables are viewed as building blocks of summary tables. Operators for constructing and manipulating summary tables, and their properties are also discussed.