SQL multimedia and application packages (SQL/MM)

Melton, Jim; Eisenberg, Andrew

doi:10.1145/604264.604280

Cited by 62 publications

(23 citation statements)

References 1 publication

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…It is the standard language for relational database management, and has the ability to perform tasks such as retrieving data from a database, or updating a database (Melton & Eisenberg, 2001). It is a widely used standard on the Internet.…”

Section: Structured Query Language and Simple Protocol And Rdf Query mentioning

confidence: 99%

Web 3.0: Governance, Risks and Safeguards

Bruwer¹,

Rudman²

2015

JABR

View full text Add to dashboard Cite

show abstract

Section: Structured Query Language and Simple Protocol And Rdf Query mentioning

confidence: 99%

Web 3.0: Governance, Risks and Safeguards

Bruwer¹,

Rudman²

2015

JABR

View full text Add to dashboard Cite

show abstract

“…The prefix stood originally for Spatial and Temporal. The SQL/MM Spatial standard defines SQL: 1999 structured user-defined types and associated methods to provide the ability to support such applications [3].…”

Section: Objects In Spacementioning

confidence: 99%

An Empirical Study of Spatial Datatypes and their Integration into Query Language

Kawatra¹,

Uppal²

2015

IJCA

View full text Add to dashboard Cite

With the expeditious development in Geographic Information System (GIS) and their applications, leads to the increment in the geo-graphical databases that have been developed by different vendors. However, the amalgam of data and accessing is still havoc for the development of GIS. Spatial or geometric data types provide basic abstraction for modeling the geometric structure of objects in space and building the relationships among objects, properties and their operations. Operations on spatial data types include spatial operations on the area of a region, topological relationships checking the relative position of spatial objects to each other like overlap, meet, disjoint, or inside, and cardinal direction relationships like north or southeast.

show abstract

“…Moreover, the SQL standard does not include specifications for selection criteria based on similarity. However, there is currently a trend in support them, including the development of a standard to handle spatial data including similarity queries, as part of the ISO SQL/MM (SQL Multimedia Spatial Standard) [1,19].…”

Section: Motivationmentioning

confidence: 99%

Efficient algorithms to execute complex similarity queries in RDBMS

Arantes¹,

Vieira²,

Traina³

et al. 2004

J. Braz. Comp. Soc.

View full text Add to dashboard Cite

Search operations in large sets of complex objects usually rely on similarity-based criteria, due to the lack of other general properties that could be used to compare the objects, such as the total order relationship, or even the equality relationship between pairs of objects, commonly used with data in numeric or short texts domains. Therefore, similarity between objects is the core criterion to compare complex objects. There are two basic operators for similarity queries: Range Query and k-Nearest Neighbors Query. Much research has been done to develop effective algorithms to implement them as standalone operations. However, algorithms to support these operators as parts of more complex expressions involving their composition were not developed yet. This paper presents two new algorithms specially designed to answer conjunctive and disjunctive operations involving the basic similarity criteria, providing also support for the manipulation of tie lists when the k-Nearest Neighbor query is involved. The new proposed algorithms were compared with the combinations of the ba- the Slim-tree metric access methods, measuring the number of disk accesses, the number of distance calculations, and wall-clock time. The experimental results show that the new algorithms have better performance than the composition of the two basic operators to answer complex similarity queries in all measured aspects, being up to 40 times faster than the composition of the basic algorithms. This is an essential point to enable the practical use of similarity operators in Relational Database Management Systems.

show abstract

SQL multimedia and application packages (SQL/MM)

Cited by 62 publications

References 1 publication

Web 3.0: Governance, Risks and Safeguards

Web 3.0: Governance, Risks and Safeguards

An Empirical Study of Spatial Datatypes and their Integration into Query Language

Efficient algorithms to execute complex similarity queries in RDBMS

Contact Info

Product

Resources

About