首页> 外国专利> ASSOCIATION INFORMATION QUERYING METHOD, TERMINAL, SERVER MANAGEMENT SYSTEM, AND COMPUTER READABLE STORAGE MEDIUM

ASSOCIATION INFORMATION QUERYING METHOD, TERMINAL, SERVER MANAGEMENT SYSTEM, AND COMPUTER READABLE STORAGE MEDIUM

机译:关联信息查询方法,终端,服务器管理系统和计算机可读存储介质

摘要

Embodiments of the present invention provide an association information querying method, a terminal, a server management system, and a computer readable storage medium. The method comprises: receiving querying objects input in vCenter by a user; screening, according to the querying objects, all object information associated with the querying objects in vCenter; creating data tables according to the querying objects and the object information and inserting related data in the data tables, the class of each object corresponding to a data table; generating a multi-layer relation tree diagram according to the data tables and fields in the data tables; receiving a data table and a field selected by the user in the multi-layer relation tree diagram, and a querying condition input by the user; generating a SQL statement according to the selected data table and field and the input querying condition; and executing the SQL statement and returning a querying execution result. The embodiments save the time for positioning and fault analysis, and improve the operation and maintenance management efficiency.
机译:本发明实施例提供了一种关联信息查询方法,终端,服务器管理系统和计算机可读存储介质。该方法包括:接收用户在vCenter中输入的查询对象;根据查询对象,筛选与vCenter中的查询对象相关的所有对象信息;根据查询对象和对象信息创建数据表,并在数据表中插入相关数据,每个对象的类别对应一个数据表;根据数据表和数据表中的字段生成多层关系树图;接收用户在多层关系树图中选择的数据表和字段,以及用户输入的查询条件;根据选择的数据表和字段以及输入的查询条件,生成一条SQL语句;执行该SQL语句,并返回查询执行结果。实施例节省了定位和故障分析的时间,提高了运维管理效率。

著录项

  • 公开/公告号WO2018205376A1

    专利类型

  • 公开/公告日2018-11-15

    原文格式PDF

  • 申请/专利权人 PING AN TECHNOLOGY(SHENZHEN)CO.LTD.;

    申请/专利号WO2017CN90923

  • 发明设计人 DAI KAIYUN;LIN BO;

    申请日2017-06-29

  • 分类号G06F17/30;

  • 国家 WO

  • 入库时间 2022-08-21 11:58:13

相似文献

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

客服邮箱:kefu@zhangqiaokeyan.com

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

  • 服务号