Unlock instant, AI-driven research and patent intelligence for your innovation.

Database query method and system, medium and equipment

A query method and database technology, applied in the field of telecom business support, can solve the problems of easy installation and failure of the cx_Oracle package, and achieve the effect of efficient and fast query and simple and convenient implementation.

Active Publication Date: 2020-06-16
北京思特奇信息技术股份有限公司
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Due to some operating system versions, system core package versions, compiler versions, etc., the cx_Oracle package is prone to installation failures

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database query method and system, medium and equipment
  • Database query method and system, medium and equipment
  • Database query method and system, medium and equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0019] In the embodiment of the present invention, the oracleTool.py file is copied to a host computer equipped with python2.5 and an oracle client that needs to realize the database query function.

[0020] figure 1 A schematic flowchart of a database query method provided by an embodiment of the present invention. Such as figure 1 As shown, the method includes:

[0021] 110. Obtain an SQL query statement, preset row and column separators in the SQL query statement, and perform format conversion of the column to be queried, and generate an SQL query statement that meets the formatting requirements;

[0022] 120. Input the SQL query statement that meets the formatting requirements into SQL Plus to execute the que...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to a database query method and system, a medium and equipment, and the method comprises the steps: obtaining an SQL query statement, presetting row and column separators in the SQL query statement, carrying out the format conversion of a to-be-queried column, and generating the SQL query statement meeting the formatting requirements; inputting the SQL query statement meetingthe formatting requirement into an SQL Plus to execute a query operation, and obtaining a query result; analyzing the query result according to rows and columns, and assembling a query result character string in a standard JSON format according to an analysis result; and returning the standard JSON format query result character string to the query party. The database query method provided by the embodiment of the invention is not limited by an operating system version, a system core package version and a compiler version, is simple and convenient to implement, and is efficient and quick in query; and a return result in a standard JSON format can be obtained and can be directly used for input or report display of other systems.

Description

technical field [0001] The invention relates to the field of telecommunication service support, in particular to a database query method, system, medium and equipment. Background technique [0002] Telecommunications industry systems mainly use Oracle databases, and a lot of work in daily maintenance tasks is to do Oracle database queries, and some self-built maintenance assistance systems also need to be able to perform database query operations. Based on the requirement of fast and convenient modification, Python language is generally used to develop maintenance tools. Python access to the Oracle database needs to be supported by installing the cx_Oracle library on the host. Due to some operating system versions, system core package versions, compiler versions, etc., the cx_Oracle package is prone to installation failure. Contents of the invention [0003] The technical problem to be solved by the present invention is to provide a database query method, system, medium ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/242G06F16/2455G06F16/248G06F16/28
CPCG06F16/2433G06F16/24553G06F16/248G06F16/284
Inventor 韩志宏
Owner 北京思特奇信息技术股份有限公司