Export Citations
Save this search
Please login to be able to save your searches and receive alerts for new content matching your search criteria.
- research-articleDecember 2021
Matrix Query Languages
ACM SIGMOD Record (SIGMOD), Volume 50, Issue 3September 2021, Pages 6–19https://doi.org/10.1145/3503780.3503782Due to the importance of linear algebra and matrix operations in data analytics, there has been a renewed interest in developing query languages that combine both standard relational operations and linear algebra operations. We survey aspects of the ...
- research-articleNovember 2019
Technical Perspective for: MATLANG: Matrix Operations and Their Expressive Power
ACM SIGMOD Record (SIGMOD), Volume 48, Issue 1March 2019, Page 59https://doi.org/10.1145/3371316.3371330The main processing paradigm in data management is bulk processing. As introduced by Codd in the early 70's, under this paradigm relations are processed in bulk, one operator at a time. When applied to relations, this paradigm leads to relational ...
- columnOctober 2012
Temporal features in SQL:2011
ACM SIGMOD Record (SIGMOD), Volume 41, Issue 3September 2012, Pages 34–43https://doi.org/10.1145/2380776.2380786SQL:2011 was published in December of 2011, replacing SQL:2008 as the most recent revision of the SQL standard. This paper covers the most important new functionality that is part of SQL:2011: the ability to create and manipulate temporal tables.
-
- research-articleMay 2011
Scalable SQL and NoSQL data stores
ACM SIGMOD Record (SIGMOD), Volume 39, Issue 4December 2010, Pages 12–27https://doi.org/10.1145/1978915.1978919In this paper, we examine a number of SQL and socalled "NoSQL" data stores designed to scale simple OLTP-style application loads over many servers. Originally motivated by Web 2.0 applications, these systems are designed to scale to thousands or ...
- columnSeptember 2010
The declarative imperative: experiences and conjectures in distributed logic
ACM SIGMOD Record (SIGMOD), Volume 39, Issue 1March 2010, Pages 5–19https://doi.org/10.1145/1860702.1860704The rise of multicore processors and cloud computing is putting enormous pressure on the software community to find solutions to the difficulty of parallel and distributed programming. At the same time, there is more--and more varied--interest in data-...
- research-articleOctober 2009
ASSET queries: a declarative alternative to MapReduce
ACM SIGMOD Record (SIGMOD), Volume 38, Issue 2June 2009, Pages 35–41https://doi.org/10.1145/1815918.1815926Today's complex world requires state-of-the-art data analysis over truly massive data sets. These data sets can be stored persistently in databases or flat files, or can be generated in realtime in a continuous manner. An associated set is a collection ...
- research-articleSeptember 2008
Null values in SQL
ACM SIGMOD Record (SIGMOD), Volume 37, Issue 3September 2008, Pages 23–25https://doi.org/10.1145/1462571.1462575In various writings over the past 20 years, such as [3], Date has pointed out that SQL produces incorrect answers to some queries where a null value is included in a table. In a recent article in the ACM SIGMOD Record, [8], Rubinson states that "Date ...
- research-articleSeptember 2008
- research-articleDecember 2007
Nulls, three-valued logic, and ambiguity in SQL: critiquing date's critique
ACM SIGMOD Record (SIGMOD), Volume 36, Issue 4December 2007, Pages 13–17https://doi.org/10.1145/1361348.1361350Date's popular critique of SQL's three-valued logic [4, 3] purports to demonstrate that SQL queries can produce erroneous results when nulls are present in the database. I argue that this critique is flawed in that Date misinterprets the meaning of his ...
- articleMarch 2007
A parallel general-purpose synthetic data generator
ACM SIGMOD Record (SIGMOD), Volume 36, Issue 1March 2007, Pages 19–24https://doi.org/10.1145/1276301.1276305PSDG is a parallel synthetic data generator designed to generate "industrial sized" data sets quickly using cluster computing. PSDG depends on SDDL, a synthetic data description language that provides flexibility in the types of data we can generate.
- articleMarch 2006
Report on the 10th International Symposium on Database Programming Languages: (DBPL 2005)
ACM SIGMOD Record (SIGMOD), Volume 35, Issue 1March 2006, Pages 45–47https://doi.org/10.1145/1121995.1122004DBPL 2005 was held on August 28-29, 2005, in the charming surroundings of Trondheim, Norway, and was one of the eleven meetings that were co-located with VLDB. DBPL meets every two years and presents the very best work at the intersection of database ...
- articleMarch 2006
Join minimization in XML-to-SQL translation: an algebraic approach
ACM SIGMOD Record (SIGMOD), Volume 35, Issue 1March 2006, Pages 20–25https://doi.org/10.1145/1121995.1121999Consider an XML view defined over a relational database, and a user query specified over this view. This user XML query is typically processed using the following steps: (a) our translator maps the XML query to one or more SQL queries, (b) the ...
- articleJune 2005
Nested intervals tree encoding in SQL
ACM SIGMOD Record (SIGMOD), Volume 34, Issue 2June 2005, Pages 47–52https://doi.org/10.1145/1083784.1083793Nested Intervals generalize Nested Sets. They are immune to hierarchy reorganization problem. They allow answering ancestor path hierarchical queries algorithmically - without accessing the stored hierarchy relation.
- articleMay 2001
Models and languages for describing and discovering E-services
ACM SIGMOD Record (SIGMOD), Volume 30, Issue 2June 2001, Page 626https://doi.org/10.1145/376284.375812Also Published in:
SIGMOD '01: Proceedings of the 2001 ACM SIGMOD international conference on Management of data: ISBN 1581133324, May 2001 - articleMay 2001
Semantic B2B integration
ACM SIGMOD Record (SIGMOD), Volume 30, Issue 2June 2001, Page 625https://doi.org/10.1145/376284.375810The tutorial “Semantic B2B Integration” will give an introduction to the field of business-to-business (B2B) integration from a technical viewpoint with the focus on semantic integration aspects. The set of B2B integration concepts is introduced as well ...
Also Published in:
SIGMOD '01: Proceedings of the 2001 ACM SIGMOD international conference on Management of data: ISBN 1581133324, May 2001 - articleMay 2001
XML data management (panel session): go native or spruce up relational systems?
ACM SIGMOD Record (SIGMOD), Volume 30, Issue 2June 2001, Page 620https://doi.org/10.1145/376284.375792XML data is likely to be widely used as a data exchange format but users also need to store and query XML data. The purpose of this panel is to explore whether and how to best provide this functionality.
Also Published in:
SIGMOD '01: Proceedings of the 2001 ACM SIGMOD international conference on Management of data: ISBN 1581133324, May 2001 - articleMay 2001
Materialized view and index selection tool for Microsoft SQL server 2000
ACM SIGMOD Record (SIGMOD), Volume 30, Issue 2June 2001, Page 608https://doi.org/10.1145/376284.375769Also Published in:
SIGMOD '01: Proceedings of the 2001 ACM SIGMOD international conference on Management of data: ISBN 1581133324, May 2001