POI结构化和非结构化数据存储检索策略  

The Storage and Retrieval Strategy Structured and Unstructured Data of POI

作　　者：吴姗 赵健 刘丹丹 余江顺 伍思睿 WU Shan;ZHAO Jian;LIU Dandan;YU Jiangshun;WU Sirui(POWERCHINA Guizhou Electric Power Design&Research Institute Co.,ltd.,Guiyang 550002,China)

机构地区：[1]中国电建集团贵州电力设计研究院有限公司,贵阳550002

出　　处：《科技和产业》2023年第3期267-272,共6页Science Technology and Industry

摘　　要：POI(兴趣点)数据具有结构化和非结构化属性,使用关系型数据库存储时,非结构化占用内存空间大,检索时直接从数据库读取,且POI空间信息需要通过HBase的rowkey进行多条件检索,效率低下。通过研究POI数据特点,构建数据模型,针对POI结构化属性数据和非结构化数据提出不同的存储和检索策略并创建索引。最后使用Sqoop完成POI属性数据和非结构化数据的交互并嵌入Solr技术进行检索。经实验验证,应用该方法针对POI非结构化数据检索效率有所提高。POI data has both structured and unstructured attributes.When relational database storage is used,unstructured storage occupies large memory space,The data is directly retrieved from the database.In addition,the HBase rowkey is used for multi-condition retrieval of POI space information,which is inefficient.By studying the characteristics of POI data and building a data model,Different storage and retrieval strategies are proposed for structured attribute data and unstructured data of POI and create index.Finally,Sqoop is used to complete the interaction between POI attribute data and unstructured data,and Solr technology is embedded for retrieval.Experimental results show that the proposed method can improve the efficiency of POI unstructured data retrieval.

关 键 词：POI HBASE SOLR POI存储 POI检索 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]