CN114880394B - SQL script sharing method, device and medium - Google Patents
SQL script sharing method, device and medium Download PDFInfo
- Publication number
- CN114880394B CN114880394B CN202210440616.5A CN202210440616A CN114880394B CN 114880394 B CN114880394 B CN 114880394B CN 202210440616 A CN202210440616 A CN 202210440616A CN 114880394 B CN114880394 B CN 114880394B
- Authority
- CN
- China
- Prior art keywords
- sharing
- sql
- sql script
- determining
- tool
- 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.)
- Active
Links
- 238000013515 script Methods 0.000 title claims abstract description 101
- 238000000034 method Methods 0.000 title claims abstract description 55
- 238000004806 packaging method and process Methods 0.000 claims abstract description 10
- 230000008859 change Effects 0.000 claims description 3
- 230000003252 repetitive effect Effects 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 8
- 238000004590 computer program Methods 0.000 description 7
- 238000005516 engineering process Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000013523 data management Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/17—Details of further file system functions
- G06F16/176—Support for shared access to files; File sharing support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a sharing method, equipment and medium of SQL scripts. The method comprises the following steps: determining the use frequency of the SQL script, and marking the SQL script with a common mark according to the use frequency; determining an interface tool, classifying SQL scripts containing common marks according to service requirements, and obtaining display information; the display information is displayed in a modularized mode according to service requirements through an interface tool; and packaging the SQL script through an interface tool, and sharing the packaged SQL script. According to the method, SQL scripts used in daily work are arranged, classified, displayed in an interface mode and executed in an interface mode, so that the online sharing and using method of multiple people is achieved. Related work can be efficiently and conveniently completed, repetitive work is effectively avoided, work efficiency is greatly improved, online sharing of multiple persons of work results is realized, and work errors caused by same matters of multiple persons operation are effectively avoided.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a method, an apparatus, and a medium for sharing an SQL script.
Background
With the development of the internet, online sharing mechanism has become an unavoidable trend. In the prior daily work, each link is struggled separately, the technology is closed, the achievement cannot be shared in time, so that the problems of low working efficiency, too many repeated works, frequent working errors and the like are caused, and the daily work is inevitably influenced. How to summarize, classify, arrange and share the methods and repeatability used in daily work becomes an important way to improve the working efficiency and reduce the working errors.
On this basis, online sharing of SQL scripts is reasonable and also achievable. Therefore, how to select a safe, convenient and reasonable sharing manner, and how to ensure that the shared SQL is efficient and usable becomes a problem to be solved.
Disclosure of Invention
The application provides a sharing method of SQL scripts, which comprises the following steps: determining the use frequency of the SQL script, and marking the SQL script with a common mark according to the use frequency; determining an interface tool, classifying the SQL script containing the common mark according to service requirements, and obtaining display information; the display information is displayed in a modularized mode according to the service requirement through the interface tool; and packaging the SQL script through the interfacing tool, and sharing the packaged SQL script.
In one example, after determining the interface tool, the method further comprises: and determining a database bound with the interfacing tool, and writing an interfacing program of the interfacing tool to connect the SQL script with the database.
In one example, the method further comprises: editing the database through the interface tool to change the display attribute of the display information, wherein the display attribute at least comprises display and hiding.
In one example, the method further comprises: editing the database through the interfacing tool, determining the data attribute of the SQL script, adding new display information into the interfacing tool according to the data attribute, or deleting the existing display information.
In one example, before packaging the SQL script by the interfacing tool, the method further comprises: acquiring a sharing request of a user through the interfacing tool, determining the SQL script required by the user according to the sharing request, and determining the sharing authority of the SQL script; and determining the user authority of the user according to the sharing request, comparing the user authority with the sharing authority, and if the user authority is within the range of the sharing authority, packaging the SQL script so as to share the packaged SQL script to the user.
In one example, the method further comprises: acquiring the sharing frequency of the SQL script through the interfacing tool, and comparing the sharing frequency with a preset sharing frequency threshold; and if the sharing frequency exceeds the sharing frequency threshold, canceling the sharing authority of the SQL script.
In one example, determining the use frequency of the SQL script, marking the SQL script with a common mark according to the use frequency, and specifically includes: determining all SQL scripts, recording the SQL scripts to obtain using parameters of the SQL scripts, determining using frequency of the SQL scripts according to the using parameters, and comparing the using frequency with a preset using frequency threshold; and if the use frequency exceeds the use frequency threshold, marking the SQL script with a common mark.
In one example, the modular display of the display information according to the service requirement by the interfacing tool specifically includes: editing the interfacing tool according to the service requirement to obtain a display module of the interfacing tool, and determining module attributes corresponding to the display module; and determining the display position of the display information according to the module attribute so as to carry out modularized display on the display information according to the service requirement.
On the other hand, the application also provides sharing equipment of the SQL script, which comprises the following components: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor to enable the sharing device of the one SQL script to execute: a method as in any one of the examples above.
In another aspect, the present application also provides a non-volatile computer storage medium storing computer executable instructions, wherein the computer executable instructions are configured to: a method as in any one of the examples above.
According to the method, SQL scripts used in daily work are arranged, classified, displayed in an interface mode and executed in an interface mode, so that the online sharing and using method of multiple people is achieved. Through the connection of the database, the operations of adding, deleting, modifying and checking the data and the like of multiple persons on line are realized. The SQL scripts used in the work are shared online, so that the situations of data loss, disorder of the service and the like caused by the operation of the same service by multiple persons are avoided, the working period is effectively shortened, and the occurrence of working errors is reduced. According to the scheme, related work can be efficiently and conveniently completed, repetitive work is effectively avoided, work efficiency is greatly improved, online sharing of a plurality of people on work results is realized, and work errors caused by the fact that the plurality of people operate the same item are effectively avoided.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this specification, illustrate embodiments of the application and together with the description serve to explain the application and do not constitute a limitation on the application. In the drawings:
FIG. 1 is a flow chart of a method for sharing SQL scripts according to an embodiment of the application;
FIG. 2 is a schematic diagram of an interface tool according to an embodiment of the present application;
fig. 3 is a schematic diagram of a sharing device of an SQL script according to an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the technical solutions of the present application will be clearly and completely described below with reference to specific embodiments of the present application and corresponding drawings. It will be apparent that the described embodiments are only some, but not all, embodiments of the application. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
The following describes in detail the technical solutions provided by the embodiments of the present application with reference to the accompanying drawings.
With the development of the internet, online sharing mechanism has become an unavoidable trend. In daily work, method sharing is very important. How to summarize, classify and sort the methods used in the work, and share the methods online becomes an important way for improving the work efficiency and reducing the work errors. In the prior work, people struggle with each other, the technology is closed, the achievement cannot be shared in time, so that the problems of low work efficiency, too many repeated works, frequent work errors and the like are caused, and the problems have unavoidable influence on daily work. In our daily work, repeated work happens sometimes, how to classify, sort and share our repeated work online, thus saving manpower, improving work efficiency, and being important for software developers and users. Therefore, we need to summarize the working rules, realize the online sharing of achievements, reduce repetitive work as much as possible, and improve the working efficiency.
Based on the background, on the premise that daily work is increasingly heavy, the usual work is summarized and classified, and on-line sharing of results is realized, so that the work efficiency of people can be effectively improved, and the daily work of people can be completed better. The structured query language (Structured Query Language, SQL), a special purpose programming language, is a database query and programming language used to access data and query, update, and manage relational database systems. On this basis, online sharing of SQL scripts is reasonable and also achievable. What is important is how to choose a safe, convenient, reasonable sharing way, and how to ensure that our shared SQL is efficient and usable. The manner in which the interfacing is presented, shared on-line, and shared is performed is well suited to such scenarios.
As shown in fig. 1, in order to solve the above problem, the method for sharing SQL scripts provided by the embodiment of the present application includes:
S101, determining the use frequency of the SQL script, and marking the SQL script with a common mark according to the use frequency.
The SQL script is a custom SQL component through which an editor can write SQL statements. When the SQL script is used in daily work, the SQL script is recorded, arranged and simply classified.
In a specific application scenario, when the method is applied to community basic data management, the operations such as filtering and duplicate removal are performed on personnel identification card numbers, and the addresses of users are split into information such as communities and community building numbers. In this scenario, the SQL script comprises: SQL for filtering error data of the ID card number, SQL for analyzing and splitting house address, and other script files.
The daily SQL statement comprises the information of the using frequency of the SQL script, and the information of the using frequency is obtained. If the use frequency of the SQL script is higher, adding a common mark into the statement of the SQL script.
In one embodiment, the SQL statement of the SQL script is recorded regularly to obtain parameters (referred to herein as usage parameters) in the SQL statement that record the number of times the SQL script is used, where the usage parameters include information such as user identity, number of times and time of use. And determining the use frequency of the SQL script in unit time according to the use parameters, and comparing the use frequency with a preset use frequency threshold. If the frequency of use exceeds the frequency of use threshold, marking the SQL script with a common mark, namely adding the common mark into the statement of the SQL script.
S102, determining an interface tool, and classifying the SQL script containing the common marks according to service requirements to obtain display information.
The interfacing tool refers to a tool for executing SQL script through an interface. And collecting and sorting the common SQL scripts containing the common marks through an interface tool, classifying the common SQL scripts according to service requirements, wherein the service information comprises personnel basic information, personnel expansion information, house information and the like. For example, as shown in fig. 2, classification is performed based on personal privacy information of the user, classification is performed based on house data, and the like.
In one embodiment, an interfacing program is written to determine a database bound to the interfacing tool. The database may be a MySQL database. MySQL is a relational database management system that keeps data in different tables rather than placing all data in one large warehouse, which increases speed and flexibility. The SQL language used by MySQL is the most commonly used standardized language for accessing databases. The SQL script is connected with the database, so that the SQL script can be executed in an interface manner, and operations such as adding, deleting, modifying and the like on the data can be directly completed.
In one embodiment, the display attribute of the display information is obtained from the database through an interface tool, wherein the display attribute at least comprises display and hiding. The interface tool changes the display attribute of the display information, so that the display state of the display information in the interface tool is changed, and the hiding and the display of the SQL script are realized.
In one embodiment, the data attributes of the SQL script are obtained by an interfacing tool. Editing is performed in the database according to the data attributes, so that new presentation information is added in the interfacing tool according to the data attributes, or existing presentation information is deleted according to the data attributes.
S103, carrying out modularized display on the display information according to the service requirement through the interface tool.
As shown in FIG. 2, a plurality of modules are arranged on the interface tool according to the service requirement, and detailed Logo of the current script file operation is displayed under each module, including operation steps, error logs and the like. And displaying the display information according to the service requirement through the module.
In one embodiment, the interfacing tool is edited according to the service requirement to obtain a display module of the interfacing tool, and a module attribute corresponding to the display module is determined. And determining the display position of the display information according to the module attribute so as to modularly display the display information according to the service requirement.
S104, packaging the classified SQL scripts through the interface tool, and sharing the packaged SQL scripts.
And packaging the classified SQL scripts by the developed interface tool, and sharing the program package to a required user, wherein the user only needs to locally install the installation package for use.
In one embodiment, before the interfacing tool packages the SQL script, the interfacing tool obtains a sharing request of a user, determines an SQL script corresponding to the user according to the sharing request, and determines a sharing authority of the SQL script. And determining the user authority of the user according to the sharing request, comparing the user authority with the sharing authority, and if the user authority is within the range of the sharing authority, packaging the SQL script so as to share the packaged SQL script to the user.
In one embodiment, the SQL statement is obtained by the interface tool, the sharing frequency of the SQL script is obtained from the SQL statement, and the sharing frequency is compared with a preset sharing frequency threshold. And if the sharing frequency exceeds the sharing frequency threshold, canceling the sharing authority of the SQL script.
As shown in fig. 3, the embodiment of the present application further provides a device for sharing SQL scripts, including:
at least one processor; and
A memory communicatively coupled to the at least one processor; wherein,
The memory stores instructions executable by the at least one processor to enable the shared device of the one SQL script to perform the method of any one of the embodiments described above.
The embodiment of the application also provides a nonvolatile computer storage medium, which stores computer executable instructions, wherein the computer executable instructions are configured to: a method as in any above embodiment.
The embodiments of the present application are described in a progressive manner, and the same and similar parts of the embodiments are all referred to each other, and each embodiment is mainly described in the differences from the other embodiments. In particular, for the apparatus and medium embodiments, the description is relatively simple, as it is substantially similar to the method embodiments, with reference to the section of the method embodiments being relevant.
The devices and media provided in the embodiments of the present application are in one-to-one correspondence with the methods, so that the devices and media also have similar beneficial technical effects as the corresponding methods, and since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the devices and media are not repeated here.
It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In one typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of computer-readable media.
Computer readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. Computer-readable media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article or apparatus that comprises the element.
The foregoing is merely exemplary of the present application and is not intended to limit the present application. Various modifications and variations of the present application will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement, etc. which come within the spirit and principles of the application are to be included in the scope of the claims of the present application.
Claims (8)
1. A method for sharing an SQL script, comprising:
determining the use frequency of the SQL script, and marking the SQL script with a common mark according to the use frequency;
determining an interface tool, classifying the SQL script containing the common mark according to service requirements, and obtaining display information;
The display information is displayed in a modularized mode according to the service requirement through the interface tool;
packaging the classified SQL scripts by the interface tool, and sharing the packaged SQL scripts;
Determining the use frequency of the SQL script, marking the SQL script with a common mark according to the use frequency, and specifically comprising the following steps:
Determining all SQL scripts, recording the SQL scripts to obtain using parameters of the SQL scripts, determining using frequency of the SQL scripts according to the using parameters, and comparing the using frequency with a preset using frequency threshold;
if the use frequency exceeds the use frequency threshold, marking the SQL script with a common mark;
the display information is displayed in a modularized mode according to the service requirement through the interface tool, and the method specifically comprises the following steps:
editing the interfacing tool according to the service requirement to obtain a display module of the interfacing tool, and determining module attributes corresponding to the display module;
and determining the display position of the display information according to the module attribute so as to carry out modularized display on the display information according to the service requirement.
2. The method of claim 1, wherein after determining the interfacing tool, the method further comprises:
and determining a database bound with the interfacing tool, and writing an interfacing program of the interfacing tool to connect the SQL script with the database.
3. The method according to claim 2, wherein the method further comprises:
editing the database through the interface tool to change the display attribute of the display information, wherein the display attribute at least comprises display and hiding.
4. The method according to claim 2, wherein the method further comprises:
editing the database through the interfacing tool, determining the data attribute of the SQL script, adding new display information into the interfacing tool according to the data attribute, or deleting the existing display information.
5. The method of claim 1, wherein prior to packaging the categorized SQL script by the interfacing tool, the method further comprises:
Acquiring a sharing request of a user through the interfacing tool, determining the SQL script required by the user according to the sharing request, and determining the sharing authority of the SQL script;
and determining the user authority of the user according to the sharing request, comparing the user authority with the sharing authority, and if the user authority is within the range of the sharing authority, packaging the SQL script so as to share the packaged SQL script to the user.
6. The method of claim 5, wherein the method further comprises:
Acquiring the sharing frequency of the SQL script through the interfacing tool, and comparing the sharing frequency with a preset sharing frequency threshold;
And if the sharing frequency exceeds the sharing frequency threshold, canceling the sharing authority of the SQL script.
7. A sharing device for an SQL script, comprising:
at least one processor; and
A memory communicatively coupled to the at least one processor; wherein,
The memory stores instructions executable by the at least one processor to enable the sharing device of the one SQL script to execute: a method as claimed in any one of claims 1 to 6.
8. A non-transitory computer storage medium storing computer-executable instructions, the computer-executable instructions configured to: a method as claimed in any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210440616.5A CN114880394B (en) | 2022-04-25 | 2022-04-25 | SQL script sharing method, device and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210440616.5A CN114880394B (en) | 2022-04-25 | 2022-04-25 | SQL script sharing method, device and medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114880394A CN114880394A (en) | 2022-08-09 |
| CN114880394B true CN114880394B (en) | 2024-05-10 |
Family
ID=82670777
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210440616.5A Active CN114880394B (en) | 2022-04-25 | 2022-04-25 | SQL script sharing method, device and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114880394B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104933190A (en) * | 2015-07-10 | 2015-09-23 | 上海新炬网络信息技术有限公司 | SQL statement execution frequency dynamic regulation method |
| CN110262999A (en) * | 2019-06-03 | 2019-09-20 | 北京一览群智数据科技有限责任公司 | A kind of circulation of automated data and data processing method, shared file server |
| CN110413673A (en) * | 2019-07-08 | 2019-11-05 | 中国人民银行清算总中心 | The unified acquisition of database data and distribution method and system |
| CN112732828A (en) * | 2020-12-22 | 2021-04-30 | 航天信息股份有限公司 | Cross-platform data sharing method based on data warehouse tool |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160299946A1 (en) * | 2015-04-10 | 2016-10-13 | Dell Software, Inc. | Usage and Symptom Oriented SQL Statement Optimization |
-
2022
- 2022-04-25 CN CN202210440616.5A patent/CN114880394B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104933190A (en) * | 2015-07-10 | 2015-09-23 | 上海新炬网络信息技术有限公司 | SQL statement execution frequency dynamic regulation method |
| CN110262999A (en) * | 2019-06-03 | 2019-09-20 | 北京一览群智数据科技有限责任公司 | A kind of circulation of automated data and data processing method, shared file server |
| CN110413673A (en) * | 2019-07-08 | 2019-11-05 | 中国人民银行清算总中心 | The unified acquisition of database data and distribution method and system |
| CN112732828A (en) * | 2020-12-22 | 2021-04-30 | 航天信息股份有限公司 | Cross-platform data sharing method based on data warehouse tool |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114880394A (en) | 2022-08-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102270225B (en) | Data change daily record method for supervising and data change daily record supervising device | |
| CN106557486A (en) | A kind of storage method and device of data | |
| CN110555035A (en) | Method and device for optimizing query statement | |
| US6205576B1 (en) | Method and apparatus for identifying indirect messaging relationships between software entities | |
| CN106844369B (en) | Objectification SQL sentence construction method and apparatus | |
| CN113360676A (en) | Method and device for determining potential relation of enterprise based on knowledge graph | |
| CN111026080A (en) | Hardware-in-loop test method and device for controller | |
| CN100338605C (en) | Recording method for extendable mark language file repairing trace | |
| CN114297204A (en) | Data storage and retrieval method and device for heterogeneous data source | |
| CN114626092A (en) | Desensitization method, system, device and computer storage medium for multi-field data with incidence relation | |
| CN114880394B (en) | SQL script sharing method, device and medium | |
| CN110019195A (en) | A kind of storage method and device of data | |
| CN112631763A (en) | Program changing method and device of host program | |
| CN104123104A (en) | Log control system and method | |
| CN116610567A (en) | Early warning method and device for abnormal application program, processor and electronic equipment | |
| CN108241622B (en) | Query script generation method and device | |
| CN116028469A (en) | Data security link tracking method and device | |
| CN111078905A (en) | Data processing method, device, medium and equipment | |
| CN111475167B (en) | Shell script dependency relation extraction method based on HQL statement | |
| CN109960497A (en) | Call method and device between a kind of script file | |
| CN114138745A (en) | Data integration method and device, storage medium and processor | |
| CN109299125B (en) | Database updating method and device | |
| CN112860234A (en) | Front-end page code generation method and system | |
| CN110221825B (en) | Method for realizing native language programming on computer | |
| CN113641702A (en) | Method and device for interactive processing with database client after statement audit |
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 |