首页> 外国专利> Query statement execution device, query statement execution method, and query statement execution program

Query statement execution device, query statement execution method, and query statement execution program

机译:查询语句执行设备,查询语句执行方法和查询语句执行程序

摘要

To improve execution performance of an inquiry sentence, and to make it possible to refer to appropriate data on the basis of content of the inquiry sentence.SOLUTION: A database management device 2 comprises: an acquisition part 224 for acquiring an inquiry sentence corresponding to a database; a determination part 225 for, when an extraction condition for extracting data is included in the acquired inquiry sentence, determining whether or not there is a difference between data corresponding to the extraction condition included in a materialized view preliminarily created correspondingly to one or more tables as a reference destination of the inquiry sentence and data corresponding to the extraction condition included in the table corresponding to the materialized view; and an execution part 226 for, when it is determined that there is difference, executing processing corresponding to the inquiry sentence by referring to the table corresponding to the materialized view, and for, when it is determined that there is not any difference, executing the processing corresponding to the inquiry sentence by referring to the materialized view.SELECTED DRAWING: Figure 2
机译:为了提高查询句子的执行性能,并且可以基于查询句的内容来提及适当的数据。Solution:数据库管理装置2包括:获取部分224,用于获取对应的查询句子数据库;当用于提取数据的提取条件包括在获取的查询句中时,确定部分225,确定是否存在与包括在相应于一个或多个表中的物化视图中包括的物化视图中的提取条件之间的数据之间的差异。查询句子的参考目的地和与与物化视图相对应的表中包含的提取条件相对应的数据;和执行部分226,当确定存在差异时,通过参考与物流化视图对应的表来执行与查询句子对应的处理,并且在确定没有任何差异时,执行通过参考物化视图来处理对应的处理。选择绘图:图2

著录项

  • 公开/公告号JP6850720B2

    专利类型

  • 公开/公告日2021-03-31

    原文格式PDF

  • 申请/专利权人 KDDI株式会社;

    申请/专利号JP20170237054

  • 发明设计人 黒川 茂莉;

    申请日2017-12-11

  • 分类号G06F16/23;G06F16/2455;

  • 国家 JP

  • 入库时间 2022-08-24 17:59:36

相似文献

  • 专利
  • 外文文献
  • 中文文献
获取专利

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号