Multiple Depth DB Tables Indexing on the Sphere

Table 2

DIF functions available in MySQL.

SQL stored routines	SQL callable C++ utilities
DIF.getHTMDepth (db, tab)	HTMLookup (𝑑, Ra, Dec)
DIF.getHEALPOrder (db, tab)	HEALPLookup (s, 𝑘, Ra, Dec)
DIF.getHEALPNested (db, tab, 𝑘)	HTMBary (𝑑, ID)
DIF.getRa (db, tab)	HTMBaryC (𝑑, Ra, Dec)
DIF.getDec (db, tab)	HTMBaryDist (𝑑, ID, Ra, Dec)
Sky region/pixels selection	HTMNeighb (𝑑, ID)
DIF_HTMCircle (Ra, Dec, 𝑟)	HTMNeighbC (𝑑, Ra, Dec)
DIF_HTMRect (Ra, Dec, 𝑆1, [𝑆2])	HEALPBary (𝑠,𝑘, ID)
DIF_HTMRectV (Ra1, Dec1, Ra2, Dec2)	HEALPBaryC (s,𝑘, Ra, Dec)
DIF_HEALPCircle (Ra, Dec, 𝑟)	HEALPBaryDist (𝑠,𝑘, ID, Ra, Dec)
DIF_HTMNeighbC (Ra, Dec)	HEALPNeighb (𝑠,𝑘, ID)
DIF_HEALPNeighbC (Ra, Dec)	HEALPNeighbC (𝑠,𝑘, Ra, Dec)
DIF_setHTMDepth (𝑑)	Sphedist (Ra1, Dec1, Ra2, Dec2)
DIF_setHEALPOrder (𝑠, 𝑘)	Auxiliary functions
DIF_Sphedist(Ra1,Dec1,Ra2,Dec2)	DIF_useParam (𝑑 or 𝑘)
DIF_FineSearch (var)	DIF_cpuTime ()
	DIF_clear ()

Note: in DIF_HTMRect if 𝑆2 is omitted it is assumed =𝑆1, that is, query a square; 𝑠 is the HEALPix schema switch: 0 for ring, 1 for nested.