使用HTM和HEALPix索引天文数据库表
Indexing astronomical database tables using HTM and HEALPix
摘要:
在各种天文项目中,坐标索引表是至关重要的。所有天空光学和红外目录都有多达10亿个物体,这些物体将随着即将到来的项目而增加。此外,在各种波长的部分天空调查可以收集信息(不仅仅是源列表),这些信息可以保存在坐标排序表中。如果不执行索引,则选择这些条目的子集或交叉匹配它们可能是不可行的。已经提出了具有各种映射函数的天空曲面细分。事实上,天文学界正在接受HTM和HEALPix模式分别作为对象目录和地图可视化和分析的默认模式。在MCS库项目中,我们现在已经将各种HTM和HEALPix工具作为MySQL可调用函数提供。这是由于MySQL 5.1提供的添加外部插件的功能。DIF(Dynamic Indexing Facilities)包分布在MCS库中,创建和管理视图,触发器,DB引擎和插件的组合,允许用户以完全透明的方式处理使用一个或两个像素化模式索引的数据库表。
英文摘要:
In various astronomical projects it is crucial to have coordinates indexed tables. All sky optical and IR catalogues have up to 1 billion objects that will increase with forthcoming projects. Also partial sky surveys at various wavelengths can collect information (not just source lists) which can be saved in coordinate ordered tables. Selecting a sub-set of these entries or cross-matching them could be un-feasible if no indexing is performed. Sky tessellation with various mapping functions have been proposed. It is a matter of fact that the astronomical community is accepting the HTM and HEALPix schema as the default for object catalogues and for maps visualization and analysis, respectively. Within the MCS library project, we have now made available as MySQL-callable functions various HTM and HEALPix facilities. This is made possible thanks to the capability offered by MySQL 5.1 to add external plug-ins. The DIF (Dynamic Indexing Facilities) package distributed within the MCS library, creates and manages a combination of Views, Triggers, DB-engine and plug-ins allowing the user to deal with database tables indexed using one or both these pixelisation schema in a completely transparent way.
机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。