CN109918392A - Structured query language localization method, device, server and storage medium - Google Patents
Structured query language localization method, device, server and storage medium Download PDFInfo
- Publication number
- CN109918392A CN109918392A CN201811537799.2A CN201811537799A CN109918392A CN 109918392 A CN109918392 A CN 109918392A CN 201811537799 A CN201811537799 A CN 201811537799A CN 109918392 A CN109918392 A CN 109918392A
- Authority
- CN
- China
- Prior art keywords
- port
- address
- sql
- database server
- query language
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Computer And Data Communications (AREA)
Abstract
The present invention provides a kind of structured query language localization method, the described method includes: according to SQL_ID, it is searched in the V $ SESSION view of database server and computer installation and port corresponding to the SQL_ID, wherein the SQL_ID refers to the mark for the SQL statement being carrying out；Obtain the occupied information of the port, wherein the occupied information of the port includes: IP address corresponding to the port；From IP address corresponding to the port, filter out for establishing IP address used in connection with the database server；And determine the SQL statement being carrying out from which application program according to the filtered out IP address.The present invention also provides a kind of device, server and storage mediums for realizing the structured query language localization method.Which application program is the present invention maintain easily personnel's Quick locating structure query language from, solves the problems, such as that structured query language location efficiency is low.
Description
Technical field
The present invention relates to field of computer technology, and in particular to a kind of structured query language localization method, device, service
Device and storage medium.
Background technique
The database of many companies is often that multiple systems share, and a database often have it is thousands of or even more than one hundred million
Structured query language (SQL, Structured Query Language) executes.Sometimes, operation personnel needs to know
Which application program certain SQL in execution specifically comes from, and for being unfamiliar with the colleague of service logic or traffic table, often has no way of
It sets about, the exploitation colleague's scan code for the system for needing contact data base correlation to be related to is claimed to verify.So, it works very
Passively, positioning time is often also very long.
Summary of the invention
In view of the foregoing, it is necessary to propose a kind of structured query language localization method, device, server, Yi Jicun
Storage media, to solve the problems, such as that structured query language location efficiency is low.
The first aspect of the present invention provides a kind of structured query language localization method, which comprises
According to SQL_ID, searched in the V $ SESSION view of database server and meter corresponding to the SQL_ID
Calculation machine device and port, wherein the SQL_ID refers to the mark for the SQL statement being carrying out；
Obtain the occupied information of the port, wherein the occupied information of the port includes: IP corresponding to the port
Address；
From IP address corresponding to the port, filter out for being established used in connection with the database server
IP address；And
Determine that destination application, the SQL statement being carrying out come from the mesh according to the IP address filtered out
Mark application program.
Preferably, the occupied information for obtaining the port includes:
The computer installation is controlled using the occupied information of port described in netstat instructions query, thus to obtain described
The occupied information of port.
Preferably, the occupied information for obtaining the port includes:
Controlling the computer installation and use netstat-anp | grep port instruction is believed to inquire the occupancy of the port
Breath, thus to obtain the occupied information of the port.
Preferably, described to determine that destination application includes: according to the IP address filtered out
A target process is determined according to the IP address filtered out, wherein the IP address filtered out is distributed to
The target process；And
Determine that the destination application is application program corresponding to the target process.
Preferably, the IP address filtered out according to determines a target process, wherein the IP filtered out
Address is allocated to the target process
The IP address retrieval configuration management database filtered out according to described determine described in the IP address that filters out be specifically
It is allocated to which process, determines that the process for being assigned with the IP address filtered out is the target process, wherein described to match
Which IP address set that the process of the pre-recorded each application program of management database is specifically assigned to is.
Preferably, the occupied information of the port further includes process number corresponding to the port, wherein described according to institute
The IP address filtered out determines that destination application includes:
From the occupied information of the port, determine for establishing IP address used in connection with the database server
And process number；
Obtain the details of the process number；
According to described for IP address used by establishing connection with the database server, from the detailed of the process number
Obtained in thin information with application program corresponding to the process number, determine the destination application for the process number institute
Corresponding application program.
Preferably, the details for obtaining the process number include:
The details of the process number are obtained using ps order.
The second aspect of the present invention provides a kind of database server, and the database server includes processor and storage
Device, the memory is for storing at least one instruction, and the processor is for executing at least one described instruction to realize
State structured query language localization method.
The third aspect of the present invention provides a kind of computer readable storage medium, the computer-readable recording medium storage
There is at least one instruction, at least one described instruction realizes the structured query language localization method when being executed by processor.
The fourth aspect of the present invention provides a kind of structured query language positioning device, and described device includes:
Searching module, for being searched and the SQL_ in the V $ SESSION view of database server according to SQL_ID
Computer installation corresponding to ID and port, wherein the SQL_ID refers to the mark for the SQL statement being carrying out；
Execution module, for obtaining the occupied information of the port, wherein the occupied information of the port includes: described
IP address corresponding to port；
The execution module is also used to from IP address corresponding to the port, filter out for the database
Server establishes IP address used in connection；And
The execution module is also used to determine destination application according to the IP address filtered out, described to be carrying out
SQL statement come from the destination application.
Structured query language localization method, device, server and storage medium described in the embodiment of the present invention,
First according to SQL_ID, lookup and computer installation and port numbers corresponding to the SQL_ID in V $ SESSION view, so
IP corresponding to the port numbers is found using netstat instruction afterwards, and is filtered out for establishing connection with database server
IP address used.Finally according to the filtered out IP address, it is specific that the IP address filtered out is found out by CMDB
It is allocated to which application program, to navigate to which application program the SQL statement being carrying out specifically comes from.It is fixed
Position process is without relying on developer's scan code, and maintenance personnel is without being familiar with service logic or data bank service table information, side
Method quick and precisely, and can form general scheme, and position fixing process reduces human input, improve location efficiency, maintenance personnel
It can complete independently.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
The embodiment of invention for those of ordinary skill in the art without creative efforts, can also basis
The attached drawing of offer obtains other attached drawings.
Fig. 1 is the application environment architecture diagram for the structured query language localization method that the embodiment of the present invention one provides.
Fig. 2 is the flow chart of structured query language localization method provided by Embodiment 2 of the present invention.
Fig. 3 is the structure chart for the structured query language positioning device that the embodiment of the present invention three provides.
Fig. 4 is the schematic diagram for the database server that the embodiment of the present invention four provides.
Following specific embodiment will further illustrate the present invention in conjunction with the attached drawing.
Specific embodiment
It is with reference to the accompanying drawing and specific real in order to be more clearly understood that the objects, features and advantages of the invention
Applying example, the present invention will be described in detail.It should be noted that in the absence of conflict, the embodiment of the present invention and embodiment
In feature can be combined with each other.
In the following description, numerous specific details are set forth in order to facilitate a full understanding of the present invention, described embodiment is only
It is only a part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, ordinary skill
Personnel's every other embodiment obtained without making creative work, shall fall within the protection scope of the present invention.
Unless otherwise defined, all technical and scientific terms used herein and belong to technical field of the invention
The normally understood meaning of technical staff is identical.Term as used herein in the specification of the present invention is intended merely to description tool
The purpose of the embodiment of body, it is not intended that in the limitation present invention.
Embodiment one
As shown in fig.1, the application environment frame of the structured query language localization method provided for the embodiment of the present invention one
Composition.
Structured query language localization method of the invention is applied in a database server and one or more calculating
In the environment that machine device is constituted.For example, in the environment being made of database server 3 and computer installation 4.
In the present embodiment, the computer installation 4 can be PC.
In one embodiment, the database server 3 and computer installation 4 can pass through wired (such as USB
(Universal Serial Bus, universal serial bus) or wirelessly establish communication connection.The wireless mode can be with
It is any type of conventional wireless communication, such as radio, Wireless Fidelity (Wireless Fidelity, WIFI), honeycomb, defends
Star, broadcast etc..Wireless communication technique may include, but be not limited to, global system for mobile communications (Global System for
Mobile Communications, GSM), General Packet Radio Service (General Packet Radio Service,
GPRS), CDMA (Code Division Multiple Access, CDMA), wideband code division multiple access (W-CDMA),
CDMA2000, IMT single carrier (IMT Single Carrier), enhanced data rates for gsm evolution (Enhanced Data
Rates for GSM Evolution, EDGE), it is Long Term Evolution (Long-Term Evolution, LTE), advanced long-term
Evolution technology, time-division Long Term Evolution (Time-Division LTE, TD-LTE), high performance radio local area network (High
Performance Radio Local Area Network, HiperLAN), high performance radio wide area network (High
Performance Radio Wide Area Network, HiperWAN), local multiple spot distribute business (Local
Multipoint Distribution Service, LMDS), full micro-wave access global inter communication (Worldwide
Interoperability for Microwave Access, WiMAX), ZigBee protocol (ZigBee), bluetooth, orthogonal frequency division multiplexing
It is empty with technology (Flash Orthogonal Frequency-Division Multiplexing, Flash-OFDM), large capacity
Division multiple access (High Capacity Spatial Division Multiple Access, HC-SDMA), General Mobile electricity
Letter system (Universal Mobile Telecommunications System, UMTS), Universal Mobile Telecommunications System time-division
Duplexing (UMTS Time-Division Duplexing, UMTS-TDD), evolved high-speed packet access (Evolved High
Speed Packet Access, HSPA+), TD SDMA (Time Division Synchronous Code
Division Multiple Access, TD-SCDMA), evolution data optimization (Evolution-Data Optimized,
EV-DO), Digital Enhanced Cordless Communications (Digital Enhanced Cordless Telecommunications, DECT) and
Other.
Embodiment two
Fig. 2 is the flow chart of structured query language localization method provided by Embodiment 2 of the present invention.
In the present embodiment, the structured query language localization method can be applied in database server, for
It needs to carry out the database server of structured query language positioning, can directly be integrated on database server of the invention
Function provided by method for structured query language positioning, or with Software Development Kit (Software
Development Kit, SDK) form operate on database server.
As shown in Fig. 2, the structured query language localization method specifically includes following steps, according to different requirements,
The sequence of step can change in the flow chart, and certain steps can be omitted.
Step S1, database server is according to SQL_ID, searched in V $ SESSION view with corresponding to the SQL_ID
Computer installation (MACHINE) and port (PORT).Wherein, SQL_ID refers to the mark for the SQL statement being carrying out.
In one embodiment, the database server is Oracle database service device.
In the present embodiment, the v $ session view is used to record the session of all users of oracle database
(session) information.Each session for being connected to oracle database can correspond to one in the v $ session view
Record.Session information recorded in the v $ session view includes the corresponding user of every conversation recording, be carrying out or
The information etc. of SQL statement, connectionist that person has just executed.In one embodiment, the v $ session view is stored in described
In the memory of database server.
In one embodiment, the v $ session view generally include field such as SADDR (address of session),
SID (session ident value), SERIAL# (session sequence number, SID and SERIAL#, which can combine, uniquely determines a session),
(audit session ID can inquire the sid of current session, select sid from v $ to AUDSID by AUDSID
(process address is associated with the addr of v $ process by session where audsid=userenv (' sessionid '), PADDR
Field can inquire the corresponding session of process by this), USER# (be same as the user_id in dba_users,
Oracle internal process user# be 0), USERNAME (session owner's user name, equal to the username in dba_users,
The usemame of Oracle internal process be sky), COMMAND (the SQL statement type being carrying out, such as 1 for create table,
3 be select etc.), (it is invalid to be worth if the train value is 2147483644, and otherwise value is for conversation shift, parallel by OWNERID
Deng), (Address of transaction state object, indicates the address of transaction status object to TADDR, corresponding
In $ TRANSACTION.ADDR arrange), LOCKWAIT (mark current queries whether be in lock wait state, for sky then indicate without etc.
To), (mark session state, Active indicate positive and execute SQL statement STATUS；Inactive indicates to wait operation；
Killed expression be noted as killing), SERVER (type of server, DEDICATED is dedicated, SHARED is shared), MACHINE
(computer installation), PORT (port), SQL_ADDRESS, SQL_HASH_VALUE (are used together mark with SQL_ADDRESS
The SQL statement being carrying out), SQL_ID (the mark ID for the SQL statement being carrying out) etc..
Step S2, the described database server obtains the occupied information of the port.The occupied information of the port includes
The corresponding process number of IP address corresponding to the port and the port.
In one embodiment, the occupied information for obtaining the port includes: database server control institute
Computer installation is stated using the occupied information of port described in netstat instructions query, thus to obtain the occupied information of the port.
In one embodiment, the database server can be stepped on according to the input of user using user account and password
Enter to computer installation corresponding to the SQL_ID.In other embodiments, the database server may not need user
Account and password can login computer installation corresponding to the SQL_ID.
In one embodiment, the netstat instruction refers to for checking current system network state information, including end
Mouthful, connection etc., usual way are as follows: netstat-atunlp, each meaning of parameters are as follows:
- t: display TCP port is indicated
- u: display udp port is indicated
- l: it only shows and monitors socket (socket of LISTEN state)
- p: show process identifier and program name, each socket/port belong to a program
- n: without dns resolution
- a shows the port of all connections
In the preferred embodiment, the occupied information for obtaining the port includes: the database server control
The computer installation by the netstat instruction with grep instruction with the use of (i.e. use netstat-anp | grep port
Instruction) inquire the occupied information of the port, thus to obtain the occupied information of the port.
It should be noted that the state of usually port is divided into: LISTENING (socket is monitoring connection),
(this socket has been switched off, and is waiting the closing of long-range socket by ESTABLISHED (connection has been established), TIME_WAIT
[FIN, ACK, FIN, ACK all finish, this is the last one state of masters, is become after having spent the 2MSL time for transmission
CLOSED state) and CLOSE_WAIT (long-range socket has been switched off: waiting close this socket [passively close
One side receives FIN]).
For example, the database server find and be carrying out in the v $ session view certain
Computer installation corresponding to SQL statement is " CNSZXXXXX8 ", and port includes " 58391 " and " 65053 ".
Assuming that the database server utilizes netstat-anp | grep port instructions query result is as follows:
[serviceop@CNSZXXXXX8~] $ netstat-anp | grep 58391
0 0::ffff:10.33.193.18:58391 of tcp:: ffff:10.33.194.209:20059
ESTABLISHED 464734/java
0 0::ffff:10.33.193.26:58391 of tcp:: ffff:10.33.30.221:1528 ESTABLISHED
292141/java
[serviceop@CNSZXXXXX8~] $ netstat-anp | grep 65053
1 0::ffff:10.33.193.48:65053 of tcp:: ffff:30.16.233.19:80 CLOSE_WAIT
81987/java
0 0::ffff:10.33.192.120:65053 of tcp:: ffff:10.33.30.221:1528
ESTABLISHED 292139/java
[serviceop@CNSZXXXXX8~] $
The database server is according to the inquiry it can be learnt that port " 58391 " corresponding IP address is
" 10.33.193.18 " and " 10.33.193.26 ".The corresponding IP address in port " 65053 " be " 10.33.193.48 " and
“10.33.192.120”。
Step S3, the described database server from IP address corresponding to the port, filter out for the number
IP address used in connection is established according to library server.
It is of the invention to clearly illustrate, still it is illustrated with the citing.Assuming that the IP that the database server uses
Address is " 10.33.30.221 ", and port is " 1528 ", establishes communication connection with the computer installation " CNSZXXXXX8 ".That
It, can IP corresponding to the port " 58391 " from the computer installation " CNSZXXXXX8 " according to the query result
In location, filtering out for establishing IP address used in connection with the database server is " 10.33.193.26 ", Yi Jicong
In IP address corresponding to port " 65053 ", filter out for establishing IP address used in connection with the database server
For " 10.33.192.120 ".
Step S4, the described database server determines destination application according to the IP address filtered out, determine described in
The SQL statement being carrying out comes from the destination application.
In one embodiment, described to determine that destination application includes: according to the IP address filtered out
(1) IP address that the database server is filtered out according to is (i.e. for building with the database server
Vertical connection IP address used) determine a target process, wherein the IP address filtered out be allocated to the target into
Journey；And
(2) database server determines that the destination application is application journey corresponding to the target process
Sequence.
Thus the database server can determine process institute of the SQL statement from the determination being carrying out
Corresponding application program (i.e. destination application).
In the present embodiment, the database server can retrieve configuration management data according to the IP address filtered out
Library (Configuration Management Database, CMDB) determines that the IP address filtered out is specifically to distribute
Which process has been given, has thereby determined that the process for being assigned with the IP address filtered out is the target process.Wherein, described to match
Which IP address set that the process of the pre-recorded each application program of management database is specifically assigned to is.
In other embodiments, the database server can be according to occupied information, that is, port institute of the port
Corresponding IP address and the port corresponding process number determines the destination application.
Specifically, the database server is from the occupied information of the port, get for the database
Server establishes IP address used in connection and process number.Then the database server recycles described in ps order acquisition
The details of process number, according to described for IP address used by establishing connection with the database server, from described
In the details of process number obtain with the process number corresponding to application program, determine the destination application for institute
State application program corresponding to process number.Thus the database server is that can determine that the SQL statement being carrying out comes
From with application program corresponding to the process number (i.e. destination application).
For example, it is assumed that in the step S2, utilize netstat-anp | the query result of grep port instruction
It is as follows:
[serviceop@CNSZXXXXX8~] $ netstat-anp | grep 58391
0 0::ffff:10.33.193.18:58391 of tcp:: ffff:10.33.194.209:20059
ESTABLISHED 464734/java
0 0::ffff:10.33.193.26:58391 of tcp:: ffff:10.33.30.221:1528 ESTABLISHED
292141/java
It is still assumed that the IP address that the database server uses is " 10.33.30.221 ", port is " 1528 ".By
This, can be from the netstat-anp | grep port instruction query result in find the port (i.e. " 58391 ") with it is described
Database server establishes that IP address used by connection is 10.33.193.26 and corresponding process number is
“292141”。
Then the database server recycles the details of the ps order acquisition process number (i.e. " 292141 ").
Ps order is the abbreviation of Process Status.Ps order is used to list currently running process in system.
For example, it is assumed that the database server gets the process number (i.e. " 292141 ") using ps order
Information is as follows:
[serviceop@CNSZXXXXX8~] #ps-ef | grep 292141
292,141 292,093 8 June14 of xx81? 06:48:14
/wls/xx81/bea1036-18/jrockit-jdk1.6.0_37-R28.2.5-4.1.0/bin/java -
Xnoopt -server
- Xms2048m-Xmx2048m-Xgc:gencon-Xns512m-verbosegc
- Dweblogic.threadpool.MinPoolSize=50-XXgcthreads:8-XX:
FlightRecorder=false
- Djrockit.oomdiagnostics=true-Djava.net.preferIPv4Stack=t rue
- Dpafa.log.home=/wls/applogs/rtlog/PSS-XXXX6554
- Dconfigpath=/wls/appsystems/pss-xxxx/config/-Dinstance.n ame=PSS-
XXXX6554
- Djava.security.egd=file:/dev/./urandom
- Djava.library.path=/wls/xx81/bea1036-18/wlserver_10.3/se rver/
native/linux/i686
- Dweblogic.Name=PSS-XXXX6554-DJVM_DEFAULT_BIND_IP=10.33.1 93.26
-classpath
/ wls/appsystems/pss-xxxx/lib/qname.jar:/wls/xx81/bea1036- 18/wlserver_
10.3/server/lib/CR/CR_pingan_localchannel_1036.jar:/wls/ xx81/bea1036-18/
Patch_wls1036/profiles/default/sys_rmanifest_classpath/w eblogic_patch.jar :/
Wls/xx81/bea1036-18/wlserver_10.3/server/lib/CR/CR_ext_l og_form.jar:/wls/
Xx81/bea1036-18/wlserver_10.3/server/lib/CR/CRpingan_cac hecontrol_1036.jar :/
wls/xx81/bea1036-18/wlserver_10.3/server/lib/CR/CR_pingan_localchannel_
1036.jar:/wls/xx81/bea1036-18/wlserver_10.3/server/lib/C R/CR_request_url_
Bug14396863_1036.jar::/wls/xx81/bea1036-18/wlserver_10.3/server:/wls/xx81/
Bea1036-18/jrockit-jdk1.6.0_37-R28.2.5-4.1.0/jre/lib/rt. jar:/wls/xx81/
Bea1036-18/jrockit-jdk1.6.0_37-R28.2.5-4.1.0/lib/tools.j ar:/wls/xx81/bea1036-
18/wlserver_10.3/server/lib/weblogic.jar:/wls/appsystems/pss-xxxx/config :/
Wls/xx81/bea1036-18/jrockit-jdk1.6.0_37-R28.2.5-4.1.0/jr e/lib/rt.jar:/wls/
Xx81/bea1036-18/jrockit-jdk1.6.0_37-R28.2.5-4.1.0/lib/to ols.jar:/wls/
Appsystems/pss-xxxx/lib:/wls/appsystems/pss-xxxx/lib/paf a2_patch070224.jar :/
Wls/appsystems/pss-xxxx/lib/pafa.jar:/wls/appsystems/pss-xxxx/lib/log4j-
1.2.8.jar:/wls/appsystems/pss-xxxx/lib/pafafrontcontroll er.jar:/wls/
Appsystems/pss-xxxx/lib/castor-xml.jar:/wls/appsystems/p ss-xxxx/lib/
Castor.jar:/wls/appsystems/pss-xxxx/lib/jakarta-regexp-1 .1.jar:/wls/
Appsystems/pss-xxxx/lib/javamail.jar:/wls/appsystems/pss-xxxx/lib/jaxp.jar :/
Wls/appsystems/pss-xxxx/lib/jaxrpc-api.jar:/wls/appsyste ms/pss-xxxx/lib/
Jaxrpc-ri.jar:/wls/appsystems/pss-xxxx/lib/saaj-api.jar :/wls/appsystems/pss-
Xxxx/lib/saaj-ri.jar:/wls/appsystems/pss-xxxx/lib/xerces Impl.jar:/wls/
Appsystems/pss-xxxx/lib/xmlParserAPIs.jar:/wls/appsystem s/pss-xxxx/lib/
Xmlrpc.jar-Dweblogic.management.server=http: // 10.33.195.191:47211
- Dweblogic.system.BootIdentityFile=/wls/wldomains/Prd10SF WLDom462/
Boot.properties-Dweblogic.ProductionModeEnabled=true
- Djava.security.policy==/wls/xx81/bea1036-18/wlserver_10. 3/server/
Lib/weblogic.policy-Dinstance.name=PSS-XXXX6554weblogic. Server
The database server can obtain answering for entitled " PSS-XXXX6554 " from the information of the progress number as a result,
It is corresponding with process number " 292141 " with program.Thus the database server can navigate to the SQL language being carrying out
Sentence is originated from the application program of entitled " PSS-XXXX6554 ".
In conclusion structured query language localization method described in the embodiment of the present invention, first according to SQL_ID,
Lookup and computer installation and port numbers corresponding to the SQL_ID, are then instructed using netstat in V $ SESSION view
IP corresponding to the port numbers is found, and is filtered out for establishing IP address used in connection with database server.Finally
According to the filtered out IP address, find out the IP address filtered out is specifically which application be allocated to by CMDB
Program, to navigate to which application program the SQL statement being carrying out specifically comes from.Position fixing process is without relying on exploitation
Personnel's scan code, for maintenance personnel without being familiar with service logic or data bank service table information, method quick and precisely, and can be with shape
At general scheme, position fixing process reduces human input, improves location efficiency, and maintenance personnel can complete independently.
Described Fig. 2 describes structured query language localization method of the invention in detail, below with reference to the 3rd~4 figure, to reality
The functional module and the realization structured query language of the software service of the existing structured query language localization method are fixed
The hardware device framework of position method is introduced.
It should be understood that the embodiment is only purposes of discussion, do not limited by this structure in patent claim.
Embodiment three
As shown in fig.3, being the structure chart for the structured query language positioning device that the embodiment of the present invention three provides.
The structured query language positioning device 30 is run in database server in some embodiments.The number
According to library server by being connected to the network computer installation.The structured query language positioning device 30 may include it is multiple by
Functional module composed by program code segments.The program generation of each program segment in the structured query language positioning device 30
Code can store in the memory of database server, and as performed by least one described processor, (be detailed in figure with realization
2 descriptions) structured query language positioning.
In the present embodiment, function of the structured query language positioning device 30 according to performed by it can be divided
For multiple functional modules.The functional module may include: searching module 301, execution module 302.The so-called module of the present invention
Refer to it is a kind of performed by least one processor and can complete the series of computation machine program segment of fixed function,
Storage is in memory.In the present embodiment, it will be described in detail in subsequent embodiment about the function of each module.
Searching module 301 is searched and the SQL_ID in the V $ SESSION view of database server according to SQL_ID
Corresponding computer installation (MACHINE) and port (PORT).Wherein, SQL_ID refers to the mark for the SQL statement being carrying out
Know.
In one embodiment, the database server is Oracle database service device.
In the present embodiment, the v $ session view is used to record the session of all users of oracle database
(session) information.Each session for being connected to oracle database can correspond to one in the v $ session view
Record.Session information recorded in the v $ session view includes the corresponding user of every conversation recording, be carrying out or
The SQL statement that person has just executed, the information etc. of connectionist.In one embodiment, the v $ session view is stored in described
In the memory of database server.
In one embodiment, the v $ session view generally include field such as SADDR (address of session),
SID (session ident value), SERIAL# (session sequence number, SID and SERIAL#, which can combine, uniquely determines a session),
(audit session ID can inquire the sid of current session, select sid from v $ to AUDSID by AUDSID
(process address is associated with the addr of v $ process by session where audsid=userenv (' sessionid '), PADDR
Field can inquire the corresponding session of process by this), USER# (be same as the user_id in dba_users,
Oracle internal process user# be 0), USERNAME (session owner's user name, equal to the usemame in dba_users,
The username of Oracle internal process be sky), COMMAND (the SQL statement type being carrying out, such as 1 for createtable,
3 be select etc.), (it is invalid to be worth if the train value is 2147483644, and otherwise value is for conversation shift, parallel by OWNERID
Deng), (Address of transaction state object, indicates the address of transaction status object to TADDR, corresponding
In $ TRANSACTION.ADDR arrange), LOCKWAIT (mark current queries whether be in lock wait state, for sky then indicate without etc.
To), (mark session state, Active indicate positive and execute SQL statement STATUS；Inactive indicates to wait operation；
Killed expression be noted as killing), SERVER (type of server, DEDICATED is dedicated, SHARED is shared), MACHINE
(computer installation), PORT (port), SQL_ADDRESS, SQL_HASH_VALUE (are used together mark with SQL_ADDRESS
The SQL statement being carrying out), SQL_ID (the mark ID for the SQL statement being carrying out) etc..
Execution module 302 obtains the occupied information of the port.The occupied information of the port includes that the port institute is right
The corresponding process number of IP address and the port answered.
In one embodiment, the occupied information for obtaining the port includes: database server control institute
Computer installation is stated using the occupied information of port described in netstat instructions query, thus to obtain the occupied information of the port.
In one embodiment, the execution module 302 can be stepped on according to the input of user using user account and password
Enter to computer installation corresponding to the SQL_ID.In other embodiments, the execution module 302 may not need user's account
Number and password can login computer installation corresponding to the SQL_ID.
In one embodiment, the netstat instruction refers to for checking current system network state information, including end
Mouthful, connection etc., usual way are as follows: netstat-atunlp, each meaning of parameters are as follows:
- t: display TCP port is indicated
- u: display udp port is indicated
- 1: only showing and monitor socket (socket of LISTEN state)
- p: show process identifier and program name, each socket/port belong to a program
- n: without dns resolution
- a shows the port of all connections
In the preferred embodiment, the occupied information for obtaining the port includes: that the execution module 302 controls institute
State computer installation by netstat instruction and grep instruction with the use of (i.e. using netstat-anp | grep port refers to
Enable) inquire the occupied information of the port, thus to obtain the occupied information of the port.
It should be noted that the state of usually port is divided into: LISTENING (socket is monitoring connection),
(this socket has been switched off, and is waiting the closing of long-range socket by ESTABLISHED (connection has been established), TIME_WAIT
[FIN, ACK, FIN, ACK all finish, this is the last one state of masters, is become after having spent the 2MSL time for transmission
CLOSED state) and CLOSE_WAIT (long-range socket has been switched off: waiting close this socket [passively close
One side receives FIN]).
For example, the execution module 302 find and be carrying out in the v $ session view certain
Computer installation corresponding to SQL statement is " CNSZXXXXX8 ", and port includes " 58391 " and " 65053 ".
Assuming that the execution module 302 utilizes netstat-anp | the query result of grep port instruction is as follows:
[serviceop@CNSZXXXXX8~] $ netstat-anp | grep 58391
0 0::ffff:10.33.193.18:58391 of tcp:: ffff:10.33.194.209:20059
ESTABLISHED 464734/java
0 0::ffff:10.33.193.26:58391 of tcp:: ffff:10.33.30.221:1528 ESTABLISHED
292141/java
[serviceop@CNSZXXXXX8~] $ netstat-anp | grep 65053
1 0::ffff:10.33.193.48:65053 of tcp:: ffff:30.16.233.19:80 CLOSE_WAIT
81987/java
0 0::ffff:10.33.192.120:65053 of tcp:: ffff:10.33.30.221:1528
ESTABLISHED 292139/java
[serviceop@CNSZXXXXX8~] $
The execution module 302 is according to the query result it can be learnt that port " 58391 " corresponding IP address is
" 10.33.193.18 " and " 10.33.193.26 ".The corresponding IP address in port " 65053 " be " 10.33.193.48 " and
“10.33.192.120”。
The execution module 302 from IP address corresponding to the port, filter out for the database service
Device establishes IP address used in connection.
It is of the invention to clearly illustrate, still it is illustrated with the citing.Assuming that the IP that the database server uses
Address is " 10.33.30.221 ", and port is " 1528 ", establishes communication connection with the computer installation " CNSZXXXXX8 ".That
It, can IP corresponding to the port " 58391 " from the computer installation " CNSZXXXXX8 " according to from the query result
In address, filtering out for establishing IP address used in connection with the database server is " 10.33.193.26 ", and
From IP address corresponding to port " 65053 ", filter out for the database server with establishing IP used in connection
Location is " 10.33.192.120 ".
The execution module 302 determines destination application, the SQL being carrying out according to the IP address filtered out
Sentence comes from the destination application.
In one embodiment, described to determine that destination application includes: according to the IP address filtered out
(1) execution module 302 is according to the IP address filtered out (i.e. for establishing with the database server
Connection IP address used) determine a target process, wherein the IP address filtered out be allocated to the target into
Journey；And
(2) execution module 302 determines that the destination application is application program corresponding to the target process.
Thus the execution module 302 can determine process institute of the SQL statement from the determination being carrying out
Corresponding application program (i.e. destination application).
In one embodiment, the execution module 302 can retrieve configuration management according to the IP address filtered out
Database (Configuration Management Database, CMDB) is specifically to determine the IP address filtered out
It is allocated to which process, thereby determines that the process for being assigned with the IP address filtered out is the target process.Wherein, institute
Which IP address state that the process of the pre-recorded each application program of configuration management database is specifically assigned to is.
In other embodiments, the execution module 302 can be according to occupied information, that is, port institute of the port
Corresponding IP address and the port corresponding process number determines the destination application.
Specifically, the execution module 302 is got from the occupied information of the port for taking with the database
Business device establishes IP address used in connection and process number.The execution module 302 then recycle ps order obtain described in into
The details of journey number, according to described for IP address used by establishing connection with the database server, from it is described into
In the details of journey number obtain with the process number corresponding to application program, determine the destination application be with it is described
Application program corresponding to process number.Thus the execution module 302 be can determine the SQL statement that is carrying out come from
Application program corresponding to the process number (i.e. destination application).
For example, it is assumed that the execution module 302 utilizes netstat-anp | the query result of grep port instruction
It is as follows:
[serviceop@CNSZXXXXX8~] $ netstat-anp | grep 58391
0 0::ffff:10.33.193.18:58391 of tcp:: ffff:10.33.194.209:20059
ESTABLISHED 464734/java
0 0::ffff:10.33.193.26:58391 of tcp:: ffff:10.33.30.221:1528 ESTABLISHED
292141/java
It is still assumed that the IP address that the database server uses is " 10.33.30.221 ", port is " 1528 ".By
This, the execution module 302 can be from the netstat-anp | the port is found in the query result of grep port instruction
It is 10.33.193.26 and corresponding that (i.e. " 58391 ") and the database server, which establish IP address used by connection,
Process number be " 292141 ".
Then the execution module 302 recycles the details of the ps order acquisition process number (i.e. " 292141 ").
Ps order is the abbreviation of Process Status.Ps order is used to list currently running process in system.
For example, it is assumed that the execution module 302 gets the process number (i.e. " 292141 ") using ps order
Information is as follows:
[serviceop@CNSZXXXXX8~] #ps-ef | grep 292141
292,141 292,093 8 June14 of xx81? 06:48:14
/wls/xx81/bea1036-18/jrockit-jdk1.6.0-37-R28.2.5-4.1.0/bin/java -
Xnoopt -server
- Xms2048m-Xmx2048m-Xgc:gencon-Xns512m-verbosegc
- Dweblogic.threadpool.MinPoolSize=50-XXgcthreads:8-XX:
FlightRecorder=false
- Djrockit.oomdiagnostics=true-Djava.net.preferIPv4Stack=true
- Dpafa.log.home=/wls/applogs/rtlog/PSS-XXXX6554
- Dconfigpath=/wls/appsystems/pss-xxxx/config/-Dinstance.n ame=PSS-
XXXX6554
- Djava.security.egd=file:/dev/./urandom
- Djava.library.path=/wls/xx81/bea1036-18/wlserver_10.3/se rver/
native/linux/i686
- Dweblogic.Name=PSS-XXXX6554-DJVM_DEFAULT_BIND_IP=10.33.1 93.26
-classpath
/ wls/appsystems/pss-xxxx/lib/qname.jar:/wls/xx81/bea1036- 18/wlserver_
10.3/server/lib/CR/CR_pingan_localchannel_1036.jar:/wls/ xx81/bea1036-18/
Patch_wls1036/profiles/default/sys_manifest_classpath/we blogic_patch.jar :/
Wls/xx81/bea1036-18/wlserver_10.3/server/lib/CR/CR_ext_l og_form.jar:/wls/
Xx81/bea1036-18/wlserver_10.3/server/lib/CR/CRpingan_cac hecontrol_1036.jar :/
wls/xx81/bea1036-18/wlserver_10.3/server/lib/CR/CR_pingan_localchannel_
1036.jar:/wls/xx81/bea1036-18/wlserver_10.3/server/lib/C R/CR_request_url_
Bug14396863_1036.jar::/wls/xx81/bea1036-18/wlserver_10.3/server:/wls/xx81/
Bea1036-18/jrockit-jdk1.6.0_37-R28.2.5-4.1.0/jre/lib/rt. jar:/wls/xx81/
Bea1036-18/jrockit-jdk1.6.0_37-R28.2.5-4.1.0/lib/tools.j ar:/wls/xx81/bea1036-
18/wlserver_10.3/server/lib/weblogic.jar:/wls/appsystems/pss-xxxx/config :/
Wls/xx81/bea1036-18/jrockit-jdk1.6.0_37-R28.2.5-4.1.0/jr e/lib/rt.jar:/wls/
Xx81/bea1036-18/jrockit-jdk1.6.0_37-R28.2.5-4.1.0/lib/to ols.jar:/wls/
Appsystems/pss-xxxx/lib:/wls/appsystems/pss-xxxx/lib/paf a2_patch070224.jar :/
Wls/appsystems/pss-xxxx/lib/pafa.jar:/wls/appsystems/pss-xxxx/lib/log4j-
1.2.8.jar:/wls/appsystems/pss-xxxx/lib/pafafrontcontroll er.jar:/wls/
Appsystems/pss-xxxx/lib/castor-xml.jar:/wls/appsystems/p ss-xxxx/lib/
Castor.jar:/wls/appsystems/pss-xxxx/lib/jakarta-regexp-1 .1.jar:/wls/
Appsystems/pss-xxxx/lib/javamail.jar:/wls/appsystems/pss-xxxx/lib/jaxp.jar :/
Wls/appsystems/pss-xxxx/lib/jaxrpc-api.jar:/wls/appsyste ms/pss-xxxx/lib/
Jaxrpc-ri.jar:/wls/appsystems/pss-xxxx/lib/saaj-api.jar :/wls/appsystems/pss-
Xxxx/lib/saaj-ri.jar:/wls/appsystems/pss-xxxx/lib/xerces Impl.jar:/wls/
Appsystems/pss-xxxx/lib/xmlParserAPIs.jar:/wls/appsystem s/pss-xxxx/lib/
Xmlrpc.jar-Dweblogic.management.server=http: // 10.33.195.191:47211
- Dweblogic.system.BootIdentityFile=/wls/wldomains/Prd10SF WLDom462/
Boot.properties-Dweblogic.ProductionModeEnabled=true
- Djava.security.policy==/wls/xx81/bea1036-18/wlserver_10. 3/server/
Lib/weblogic.policy-Dinstance.name=PSS-XXXX6554weblogic. Server
The execution module 302 can obtain the application program of entitled " PSS-XXXX6554 " from the information of the progress number
It is corresponding with process number " 292141 ".Thus the execution module 302 can navigate to the SQL statement being carrying out and be originated from name
For the application program of " PSS-XXXX6554 ".
In conclusion structured query language positioning device described in the embodiment of the present invention, first according to SQL_ID,
Lookup and computer installation and port numbers corresponding to the SQL_ID, are then instructed using netstat in V $ SESSION view
IP corresponding to the port numbers is found, and is filtered out for establishing IP address used in connection with database server.Finally
According to the filtered out IP address, find out the IP address filtered out is specifically which application be allocated to by CMDB
Program, to navigate to which application program the SQL statement being carrying out specifically comes from.Position fixing process is without relying on exploitation
Personnel's scan code, for maintenance personnel without being familiar with service logic or data bank service table information, method quick and precisely, and can be with shape
At general scheme, position fixing process reduces human input, improves location efficiency, and maintenance personnel can complete independently.
Example IV
As shown in fig.4, the structural schematic diagram of the database server provided for the embodiment of the present invention four.The present invention compared with
In good embodiment, the database server 3 includes memory 31, at least one processor 32, at least one communication bus 33.
The database server 3 passes through wired or wirelessly establish communication connection with computer installation 4.
Those skilled in the art it should be understood that, the structure of the database server shown in Fig. 4 does not constitute of the invention real
Apply the restriction of example, either bus topology, be also possible to star structure, the database server 3 can also include than
Illustrate other more or fewer hardware perhaps software or different component layouts.
In some embodiments, the database server 3 include it is a kind of can according to the instruction for being previously set or storing,
The automatic terminal for carrying out numerical value calculating and/or information processing, hardware include but is not limited to microprocessor, specific integrated circuit,
Programmable gate array, digital processing unit and embedded device etc..
It should be noted that the database server 3 is only for example, other electronics that are existing or being likely to occur from now on
Product is such as adaptable to the present invention, should also be included within protection scope of the present invention, and is incorporated herein by reference.
In some embodiments, the memory 31 is used to store program code and various data, such as is mounted on described
Structured query language positioning device 30, the v $ session view in database server 3 etc., and in database service
The access realized high speed in the operational process of device 3, be automatically completed program or data.The memory 31 includes read-only memory
(Read-Only Memory, ROM), random access memory (Random Access Memory, RAM), programmable read only memory
(Programmable Read-Only Memory, PROM), Erasable Programmable Read Only Memory EPROM (Erasable
Programmable Read-Only Memory, EPROM), disposable programmable read-only memory (One-time
Programmable Read-Only Memory, OTPROM), electronics erasing type can make carbon copies read-only memory
(Electrically-Erasable Programmable Read-Only Memory, EEPROM), CD-ROM (Compact
Disc Read-Only Memory, CD-ROM) or other disc memories, magnetic disk storage, magnetic tape storage or can
For carrying or any other computer-readable medium of storing data.
In some embodiments, at least one described processor 32 can be made of integrated circuit, such as can be by single
The integrated circuit of encapsulation is formed, and is also possible to be made of the integrated circuit that multiple identical functions or different function encapsulate, be wrapped
Include one or more central processing unit (Central Processing unit, CPU), microprocessor, digital processing chip,
The combination etc. of graphics processor and various control chips.At least one described processor 32 is the control of the database server 3
Core (Control Unit) processed passes through fortune using all parts of various interfaces and the entire database server 3 of connection
Row executes the program or module being stored in the memory 31, and calls the number being stored in the memory 31
According to execute the various functions and processing data of database server 3, such as the function of execution structured query language positioning.
In some embodiments, at least one communication bus 33 is arranged to realize the memory 31 and described
Connection communication between at least one processor 32 etc..
Although being not shown, the database server 3 can also include the power supply (such as battery) powered to all parts,
Preferably, power supply can be logically contiguous by electric power controller and at least one described processor 32, to pass through power supply pipe
It manages device and realizes the functions such as management charging, electric discharge and power managed.Power supply can also include one or more direct current
Or AC power source, recharging device, power failure detection circuit, power adapter or inverter, power supply status indicator etc.
Random component.The database server 3 can also be including multiple sensors, bluetooth module, Wi-Fi module etc., herein no longer
It repeats.
It should be understood that the embodiment is only purposes of discussion, do not limited by this structure in patent claim.
The integrated unit realized in the form of software function module, can store and computer-readable deposit at one
In storage media.The software function module is stored in a storage medium, including some instructions are used so that a database
Server (can be server, PC etc.) or processor (processor) execute side described in each embodiment of the present invention
The part of method.
In a further embodiment, in conjunction with Fig. 3, the database server is can be performed at least one described processor 32
3 operating device and the types of applications program (structured query language positioning device 30 as mentioned) of installation, program code
Deng for example, the modules.
Program code is stored in the memory 31, and at least one described processor 32 can call the memory 31
The program code of middle storage is to execute relevant function.For example, modules described in Fig. 3 are stored in the memory 31
In program code, and as performed by least one described processor 32, to realize the function of the modules to reach
Carry out the purpose of structured query language positioning.
In one embodiment of the invention, the memory 31 stores multiple instruction, the multiple instruction by it is described extremely
A few processor 32 is performed to carry out structured query language positioning to realize.
Specifically, at least one described processor 32 can refer to the corresponding implementation of Fig. 2 to the concrete methods of realizing of described instruction
The description of correlation step in example, this will not be repeated here.
In several embodiments provided by the present invention, it should be understood that arriving, disclosed device, device and method can
To realize by another way.For example, the apparatus embodiments described above are merely exemplary, for example, the module
Division, only a kind of logical function partition, there may be another division manner in actual implementation.
The module as illustrated by the separation member may or may not be physically separated, aobvious as module
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
In network unit.Some or all of the modules therein can be selected to realize the mesh of this embodiment scheme according to the actual needs
's.
It, can also be in addition, each functional module in each embodiment of the present invention can integrate in one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.The integrated list
Member both can take the form of hardware realization, can also realize in the form of hardware adds software function module.
It is obvious to a person skilled in the art that the present invention is not limited to the details of the exemplary embodiment, Er Qie
In the case where without departing substantially from spirit or essential attributes of the invention, the present invention can be realized in other specific forms.Therefore, no matter
From the point of view of which point, the present embodiments are to be considered as illustrative and not restrictive, and the scope of the present invention is by appended power
Benefit require rather than it is described illustrate to limit, it is intended that all by what is fallen within the meaning and scope of the equivalent elements of the claims
Variation is included in the present invention.Any reference signs in the claims should not be construed as limiting the involved claims.This
Outside, it is clear that one word of " comprising " is not excluded for other units or, odd number is not excluded for plural number.The multiple units stated in device claim
Or device can also be implemented through software or hardware by a unit or device.The first, the second equal words are used to indicate name
Claim, and does not indicate any particular order.
Finally it should be noted that the above examples are only used to illustrate the technical scheme of the present invention and are not limiting, although reference
Preferred embodiment describes the invention in detail, those skilled in the art should understand that, it can be to of the invention
Technical solution is modified or equivalent replacement, without departing from the spirit and scope of the technical solution of the present invention.
Claims (10)
1. a kind of structured query language localization method, which is characterized in that the described method includes:
According to SQL_ID, searched in the V $ SESSION view of database server and computer corresponding to the SQL_ID
Device and port, wherein the SQL_ID refers to the mark for the SQL statement being carrying out；
Obtain the occupied information of the port, wherein the occupied information of the port includes: IP corresponding to the port
Location；
From IP address corresponding to the port, filter out for the database server with establishing IP used in connection
Location；And
Determine that destination application, the SQL statement being carrying out are answered from the target according to the IP address filtered out
Use program.
2. structured query language localization method as described in claim 1, which is characterized in that described to obtain accounting for for the port
Include: with information
The computer installation is controlled using the occupied information of port described in netstat instructions query, thus to obtain the port
Occupied information.
3. structured query language localization method as claimed in claim 2, which is characterized in that described to obtain accounting for for the port
Include: with information
Controlling the computer installation and use netstat-anp | grep port instructs to inquire the occupied information of the port,
Thus to obtain the occupied information of the port.
4. structured query language localization method as described in claim 1, which is characterized in that described according to the IP filtered out
Address determines that destination application includes:
A target process is determined according to the IP address filtered out, wherein the IP address filtered out is allocated to institute
State target process；And
Determine that the destination application is application program corresponding to the target process.
5. structured query language localization method as claimed in claim 4, which is characterized in that described to be filtered out according to
IP address determines a target process, wherein the IP address filtered out is allocated to the target process and includes:
The IP address filtered out according to the IP address retrieval configuration management database determination filtered out is specifically to distribute
Which process has been given, has determined that the process for being assigned with the IP address filtered out is the target process, wherein the configuration pipe
Which IP address what the process of the pre-recorded each application program of reason database was specifically assigned to is.
6. structured query language localization method as described in claim 1, which is characterized in that the occupied information of the port is also
Including process number corresponding to the port, wherein described to determine that destination application includes: according to the IP address filtered out
From the occupied information of the port, determine for the database server establish IP address used in connection and
Process number；
Obtain the details of the process number；
According to described for IP address used by establishing connection with the database server, from the detailed letter of the process number
In breath obtain with the process number corresponding to application program, determine the destination application be with corresponding to the process number
Application program.
7. structured query language localization method as claimed in claim 6, which is characterized in that the acquisition process number
Details include:
The details of the process number are obtained using ps order.
8. a kind of database server, which is characterized in that the database server includes processor and memory, the storage
Device is for storing at least one instruction, and the processor is for executing at least one described instruction to realize such as claim 1 to 7
Any one of described in structured query language localization method.
9. a kind of computer readable storage medium, which is characterized in that the computer-readable recording medium storage has at least one
Instruction, at least one described instruction realize that structuring as claimed in any of claims 1 to 7 in one of claims is looked into when being executed by processor
Ask language localization method.
10. a kind of structured query language positioning device, which is characterized in that described device includes:
Searching module, for being searched and the SQL_ID institute in the V $ SESSION view of database server according to SQL_ID
Corresponding computer installation and port, wherein the SQL_ID refers to the mark for the SQL statement being carrying out；
Execution module, for obtaining the occupied information of the port, wherein the occupied information of the port includes: the port
Corresponding IP address；
The execution module is also used to from IP address corresponding to the port, filter out for the database service
Device establishes IP address used in connection；And
The execution module is also used to determine destination application, the SQL being carrying out according to the IP address filtered out
Sentence comes from the destination application.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811537799.2A CN109918392B (en) | 2018-12-15 | 2018-12-15 | Structured query language positioning method, device, server and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811537799.2A CN109918392B (en) | 2018-12-15 | 2018-12-15 | Structured query language positioning method, device, server and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109918392A true CN109918392A (en) | 2019-06-21 |
| CN109918392B CN109918392B (en) | 2023-08-11 |
Family
ID=66959985
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811537799.2A Active CN109918392B (en) | 2018-12-15 | 2018-12-15 | Structured query language positioning method, device, server and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109918392B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110532248A (en) * | 2019-09-02 | 2019-12-03 | 北京首汽智行科技有限公司 | A kind of server application acquisition of information and method of adjustment based on CMDB |
| CN112291385A (en) * | 2020-11-05 | 2021-01-29 | 竞技世界（北京）网络技术有限公司 | Address duplicate checking method and device, electronic equipment and computer readable storage medium |
| CN112988435A (en) * | 2019-12-16 | 2021-06-18 | 中国电信股份有限公司 | Database overload protection processing method and device and storage medium |
| CN116484364A (en) * | 2023-02-03 | 2023-07-25 | 安芯网盾(北京)科技有限公司 | Hidden port detection method and device based on Linux kernel |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5950188A (en) * | 1996-11-14 | 1999-09-07 | Sybase, Inc. | Database system with methods for executing system-created internal SQL command statements |
| CN103577561A (en) * | 2013-10-24 | 2014-02-12 | 华为技术有限公司 | Storage method, storage device and storage system of executive plan |
| CN104008349A (en) * | 2014-04-28 | 2014-08-27 | 国家电网公司 | Database security access control method and system |
| CN108345648A (en) * | 2018-01-18 | 2018-07-31 | 北京奇安信科技有限公司 | A kind of method and device of the acquisition log information based on column storage |
-
2018
- 2018-12-15 CN CN201811537799.2A patent/CN109918392B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5950188A (en) * | 1996-11-14 | 1999-09-07 | Sybase, Inc. | Database system with methods for executing system-created internal SQL command statements |
| CN103577561A (en) * | 2013-10-24 | 2014-02-12 | 华为技术有限公司 | Storage method, storage device and storage system of executive plan |
| CN104008349A (en) * | 2014-04-28 | 2014-08-27 | 国家电网公司 | Database security access control method and system |
| CN108345648A (en) * | 2018-01-18 | 2018-07-31 | 北京奇安信科技有限公司 | A kind of method and device of the acquisition log information based on column storage |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110532248A (en) * | 2019-09-02 | 2019-12-03 | 北京首汽智行科技有限公司 | A kind of server application acquisition of information and method of adjustment based on CMDB |
| CN110532248B (en) * | 2019-09-02 | 2022-12-20 | 北京首汽智行科技有限公司 | CMDB-based server application information acquisition and adjustment method |
| CN112988435A (en) * | 2019-12-16 | 2021-06-18 | 中国电信股份有限公司 | Database overload protection processing method and device and storage medium |
| CN112291385A (en) * | 2020-11-05 | 2021-01-29 | 竞技世界（北京）网络技术有限公司 | Address duplicate checking method and device, electronic equipment and computer readable storage medium |
| CN116484364A (en) * | 2023-02-03 | 2023-07-25 | 安芯网盾(北京)科技有限公司 | Hidden port detection method and device based on Linux kernel |
| CN116484364B (en) * | 2023-02-03 | 2024-01-26 | 安芯网盾(北京)科技有限公司 | Hidden port detection method and device based on Linux kernel |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109918392B (en) | 2023-08-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109918392A (en) | Structured query language localization method, device, server and storage medium | |
| EP3327992B1 (en) | Method of selecting network slice and system utilizing same | |
| US10144304B2 (en) | Power management in electric vehicles | |
| CN105637498B (en) | Management method, eUICC, SM platform and the system of eUICC | |
| EP3720189B1 (en) | Data routing method and terminal | |
| CN104969654B (en) | Synchronize the generation and transmission to keep-alive message | |
| CN109417492B (en) | Network function NF management method and NF management equipment | |
| CN110024478A (en) | Adaptivity network topology structure | |
| JP6067365B2 (en) | MiAN, system and partner discovery method in the system | |
| CN108886678A (en) | A kind of method, apparatus and system of interacting message | |
| US20200236178A1 (en) | Architecture, method and apparatus for realizing network function communication | |
| CN110324403A (en) | Dynamic divides library method for routing, device, server and storage medium | |
| US20140315494A1 (en) | Proxy communication system in ban environment and control method thereof | |
| US8774053B2 (en) | Method, network element device, and network system for associating a terminal device with a network | |
| EP3211907A1 (en) | Device-to-device content providing method | |
| US11038889B2 (en) | System and method for migrating existing access control list policies to intent based policies and vice versa | |
| US20160309317A1 (en) | Accessibility Management Method and Device for M2M Terminal/Terminal Peripheral | |
| EP2991407A1 (en) | Method, device, and system for configuring access technologies | |
| US20140281051A1 (en) | Sensor terminal capable of personalizing external physical device and method thereof | |
| US20130260804A1 (en) | Apparatus and method for wireless network connection | |
| CN104429128A (en) | Wireless access processing method, device and system | |
| CN107770829A (en) | A kind of terminal switching method, device and equipment | |
| CN110209688A (en) | Structured query sentence localization method, device, computer installation and storage medium | |
| US10091718B2 (en) | System and method for wireless network selection | |
| WO2016201734A1 (en) | Operation control method and system for application program, and terminal |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |