CN114880394A - SQL script sharing method, equipment and medium - Google Patents
SQL script sharing method, equipment and medium Download PDFInfo
- Publication number
- CN114880394A CN114880394A CN202210440616.5A CN202210440616A CN114880394A CN 114880394 A CN114880394 A CN 114880394A CN 202210440616 A CN202210440616 A CN 202210440616A CN 114880394 A CN114880394 A CN 114880394A
- Authority
- CN
- China
- Prior art keywords
- sharing
- sql
- sql script
- tool
- determining
- 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
- 238000013515 script Methods 0.000 title claims abstract description 100
- 238000000034 method Methods 0.000 title claims abstract description 51
- 238000004806 packaging method and process Methods 0.000 claims abstract description 9
- 230000008859 change Effects 0.000 claims description 3
- 239000000126 substance Substances 0.000 claims 2
- 230000003252 repetitive effect Effects 0.000 abstract description 6
- 238000010586 diagram Methods 0.000 description 9
- 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
- 238000012545 processing Methods 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 238000009434 installation Methods 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000007792 addition Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000006872 improvement Effects 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
Images
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 method, equipment and medium for sharing an SQL script. 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 a delimitation tool, and classifying SQL scripts containing common marks according to business requirements to obtain display information; modularly displaying the display information according to the service requirement through an interfacing tool; and packaging the SQL script through an interfacing tool, and sharing the packaged SQL script. The method for sharing the use of the multiple persons on line is realized by sorting, classifying, displaying in an interfacing manner and executing in an interfacing manner SQL scripts used in daily work. The device can efficiently and conveniently complete related work, effectively avoid repetitive work, greatly improve the work efficiency, realize multi-user online sharing of work results and effectively avoid working errors caused by the operation of the same item by multiple users.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a method, a device, and a medium for sharing an SQL script.
Background
With the development of the internet, an online sharing mechanism has become an inevitable trend. In the prior daily work, each link is struggled separately, the technology is closed, the results 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 online the method and repetitive work used in daily work becomes an important way to improve the work efficiency and reduce the work errors.
On the basis, the online sharing of the SQL script is reasonable and can be realized. 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 urgently.
Disclosure of Invention
The application provides a method for sharing an SQL script, which comprises the following steps: determining the use frequency of an SQL script, and marking the SQL script with a common mark according to the use frequency; determining a delimitation tool, and classifying the SQL script containing the common marks according to business requirements to obtain display information; modularly displaying the display information according to the service requirement through the interfacing tool; and packaging the SQL script through the interfacing tool, and sharing the packaged SQL script.
In one example, 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 so as to connect the SQL script with the database.
In one example, the method further comprises: and editing the database through the interfacing tool so as 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 interface tool, determining the data attribute of the SQL script, and adding new display information or deleting the existing display information in the interface tool according to the data attribute.
In one example, prior to packaging the SQL script by the interfacing tool, the method further comprises: acquiring a sharing request of a user through the interface 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 interface tool, and comparing the sharing frequency with a preset sharing frequency threshold value; and if the sharing frequency exceeds the sharing frequency threshold, canceling the sharing permission of the SQL script.
In one example, determining the use frequency of the SQL script, and marking the SQL script with a common mark according to the use frequency specifically includes: determining all the SQL scripts, recording the SQL scripts to obtain the use parameters of the SQL scripts, determining the use frequency of the SQL scripts according to the use parameters, and comparing the use frequency with a preset use frequency threshold; and if the use frequency exceeds the use frequency threshold, marking the SQL script with a common mark.
In one example, the modularly displaying the display information according to the business requirement through 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 a module attribute corresponding to the display module; 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.
On the other hand, the application also provides a sharing device of the SQL script, which comprises: 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 type of SQL script to perform: a method as in any preceding example.
In another aspect, the present application further provides a non-volatile computer storage medium storing computer-executable instructions, wherein the computer-executable instructions are configured to: a method as in any preceding example.
The method for sharing the use of the multiple persons on line is realized by sorting, classifying, displaying in an interfacing manner and executing in an interfacing manner SQL scripts used in daily work. By connecting the database, the operations of increasing, deleting, modifying, checking and the like of the data on line by a plurality of people are realized. The SQL scripts used in the work are shared online, the situations of data loss, service disorder and the like caused when multiple persons operate the same service are avoided, the work period is effectively shortened, and the occurrence of work errors is reduced. According to the scheme, related work can be efficiently and conveniently completed, repetitive work is effectively avoided, the work efficiency is greatly improved, multi-user online sharing of work results is realized, and work errors caused by operation of the same item by multiple users 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 application, illustrate embodiment(s) of the application and together with the description serve to explain the application and not to limit the application. In the drawings:
FIG. 1 is a schematic flowchart illustrating a method for sharing an SQL script according to an embodiment of the present application;
FIG. 2 is a schematic view of an interfacing tool according to an embodiment of the present disclosure;
fig. 3 is a schematic diagram of a sharing device of an SQL script in 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 described in detail and completely with reference to the following specific embodiments of the present application and the accompanying drawings. It should be apparent that the described embodiments are only some of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The technical solutions provided by the embodiments of the present application are described in detail below with reference to the accompanying drawings.
With the development of the internet, an online sharing mechanism has become an inevitable trend. In daily work, method sharing is very important. How to summarize, classify, arrange and share online the methods used in the work becomes an important way to improve the work efficiency and reduce the work errors. In the previous work, people struggle separately, the technology is closed, the achievements 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 problems have inevitable influence on the daily work. In our daily work, repetitive work happens sometimes, and how to classify, arrange and share the repetitive work on line is important for software developers and users, so that labor is saved, and work efficiency is improved. Therefore, the working rule needs to be summarized, online achievement sharing is achieved, repetitive work is reduced to the greatest extent, and working efficiency is improved.
Based on the background, on the premise that daily work is increasingly heavy, the conventional work is summarized and classified, and online sharing of results is realized, so that the work efficiency of people can be effectively improved, and the daily work of people can be better completed. Structured Query Language (SQL), a special purpose programming Language, is a database Query and programming Language for accessing data and querying, updating, and managing relational database systems. On the basis, the online sharing of the SQL script is reasonable and can be realized. What is important is how to select a safe, convenient and reasonable sharing mode and how to ensure that the SQL shared by the users is efficient and available. The nature of the interfacing presentation, sharing online, and the manner in which interfacing is performed are well suited to such scenarios.
As shown in fig. 1, in order to solve the above problem, an embodiment of the present invention provides a method for sharing an SQL script, where the method includes:
s101, determining the use frequency of the SQL script, and marking the SQL script with common marks according to the use frequency.
The SQL script is a self-defined SQL component, and SQL sentences can be written by an editor through the SQL script. When the SQL script is used in daily work, the SQL script is recorded, sorted and simply classified.
In a specific application scenario, when the method is applied to community basic data management, the personnel identity card number is filtered, the duplication is removed, and the address of the user is divided into information such as a community, a community building number and a house number. In this scenario, the SQL script includes: SQL for filtering error data of the identity card number, SQL for resolving and splitting house address and other script files.
The daily used SQL sentences comprise the use frequency information of the SQL scripts and the use frequency information is obtained. If the use frequency of the SQL script is higher, a common mark is added into the statement of the SQL script.
In one embodiment, the SQL statement of the SQL script is recorded periodically to obtain a parameter (referred to as a usage parameter herein) for recording the usage times of the SQL script in the SQL statement, wherein the usage parameter includes information about the user identity, the usage times, and the usage time. 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 value. If the use frequency exceeds the use frequency 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 business requirements to obtain display information. 234
An interfacing tool refers to a tool that performs SQL script execution through an interface. The common SQL scripts containing the common marks are collected and sorted through an interface tool, and are classified according to business requirements, wherein the business information comprises information such as personnel basic information, personnel extended information and house information. For example, as shown in fig. 2, classification is performed based on user individual privacy information, classification is performed based on house data, and the like.
In one embodiment, an interfacing program is written that determines a database to which the interfacing tool is bound. The database may be a MySQL database. MySQL is a relational database management system that keeps data in different tables instead of putting all the data in one large repository, which increases speed and flexibility. The SQL language used by MySQL is the most common standardized language for accessing databases. The SQL script is connected with the database, so that the interface execution can be realized, and the operations of data addition, deletion, modification, check and the like can be directly completed.
In one embodiment, the presentation attribute of the presentation information is obtained in the database through the interfacing tool, wherein the presentation attribute at least comprises displaying 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 displaying of the SQL script are realized.
In one embodiment, the data attributes of the SQL script are obtained through the interfacing tool. And editing in the database according to the data attributes, so that new display information is added in the interfacing tool according to the data attributes, or the existing display information is deleted according to the data attributes.
S103, modularly displaying the display information according to the service requirement through the interfacing tool. 8
As shown in fig. 2, a plurality of modules are arranged on the interfacing tool according to the service requirement, and a detailed Logo of the current script file operation is shown under each module, including an operation step, an error log, 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 business requirements to obtain a display module of the interfacing tool, and module attributes corresponding to the display module are 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.
And S104, packaging the classified SQL scripts through the interface tool, and sharing the packaged SQL scripts. 56
The classified SQL scripts are packaged and shared to users in need through the developed interface tools, and the users can use the installation packages only by locally installing the installation packages.
In one embodiment, before the interfacing tool packages the SQL script, the interfacing tool obtains a sharing request of a user, determines the SQL script correspondingly required by the user according to the sharing request, and determines the sharing right 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 statements are obtained by the interfacing tool, the sharing frequency of the SQL scripts is obtained from the SQL statements, 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 permission of the SQL script.
As shown in fig. 3, an embodiment of the present application further provides a SQL script sharing device, including:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein, the first and the second end of the pipe are connected with each other,
the memory stores instructions executable by the at least one processor to enable the SQL script sharing device to perform the method according to any of the embodiments.
An embodiment of the present application further provides a non-volatile computer storage medium storing computer-executable instructions, where the computer-executable instructions are configured to: a method as in any one of the embodiments above.
The embodiments in the present application are described in a progressive manner, and the same and similar parts among the embodiments can be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the device and media embodiments, the description is relatively simple as it is substantially similar to the method embodiments, and reference may be made to some descriptions of the method embodiments for relevant points.
The device and the medium provided by the embodiment of the application correspond to the method one to one, so the device and the medium also have the similar beneficial technical effects as the corresponding method, and the beneficial technical effects of the method are explained in detail above, so the beneficial technical effects of the device and the medium are not repeated herein.
As will be appreciated by one skilled in the art, 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 so forth) 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 flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams 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 a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.
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 computer storage media 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 that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
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 an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The above description is only an example of the present application and is not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (10)
1. A method for sharing SQL scripts is characterized by comprising the following steps:
determining the use frequency of an SQL script, and marking the SQL script with a common mark according to the use frequency;
determining a delimitation tool, and classifying the SQL script containing the common marks according to business requirements to obtain display information;
modularly displaying the display information according to the service requirement through the interfacing tool;
and packaging the classified SQL scripts through the interface chemical tool, and sharing the packaged SQL scripts.
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 so as to connect the SQL script with the database.
3. The method of claim 2, further comprising:
and editing the database through the interfacing tool so as to change the display attribute of the display information, wherein the display attribute at least comprises display and hiding.
4. The method of claim 2, further comprising:
and editing the database through the interfacing tool, determining the data attribute of the SQL script, and adding new display information or deleting the existing display information in the interfacing tool according to the data attribute.
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 interface 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, further comprising:
acquiring the sharing frequency of the SQL script through the interface tool, and comparing the sharing frequency with a preset sharing frequency threshold value;
and if the sharing frequency exceeds the sharing frequency threshold, canceling the sharing permission of the SQL script.
7. The method according to claim 1, wherein determining the usage frequency of the SQL script, and marking the SQL script with a common mark according to the usage frequency specifically comprises:
determining all the SQL scripts, recording the SQL scripts to obtain the use parameters of the SQL scripts, determining the use frequency of the SQL scripts according to the use parameters, and comparing the use frequency with a preset use frequency threshold;
and if the use frequency exceeds the use frequency threshold, marking the SQL script with a common mark.
8. The method according to claim 1, wherein the displaying the display information modularly according to the business requirements by the interfacing tool specifically comprises:
editing the interfacing tool according to the service requirement to obtain a display module of the interfacing tool, and determining a module attribute corresponding to the display module;
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.
9. A SQL script sharing device, comprising:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to enable the shared device of one SQL script to perform: the method of any one of claims 1-8.
10. A non-transitory computer storage medium storing computer-executable instructions, the computer-executable instructions configured to: the method of any one of claims 1-8.
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 true CN114880394A (en) | 2022-08-09 |
CN114880394B 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 (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104933190A (en) * | 2015-07-10 | 2015-09-23 | 上海新炬网络信息技术有限公司 | SQL statement execution frequency dynamic regulation method |
US20160299946A1 (en) * | 2015-04-10 | 2016-10-13 | Dell Software, Inc. | Usage and Symptom Oriented SQL Statement Optimization |
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 |
-
2022
- 2022-04-25 CN CN202210440616.5A patent/CN114880394B/en active Active
Patent Citations (5)
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 |
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 |
---|---|
CN114880394B (en) | 2024-05-10 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107644286B (en) | Workflow processing method and device | |
US20230021259A1 (en) | Methods and systems for building search service application | |
CN105630475B (en) | A kind of data label organization system and method for organizing | |
CN113656245B (en) | Data inspection method and device, storage medium and processor | |
US6205576B1 (en) | Method and apparatus for identifying indirect messaging relationships between software entities | |
CN107729330B (en) | Method and apparatus for acquiring data set | |
CN113360676A (en) | Method and device for determining potential relation of enterprise based on knowledge graph | |
CN114297204A (en) | Data storage and retrieval method and device for heterogeneous data source | |
CN110908870A (en) | Resource monitoring method and device for mainframe, storage medium and equipment | |
CN115952160B (en) | Data checking method | |
CN112631763A (en) | Program changing method and device of host program | |
CN112860234A (en) | Front-end page code generation method and system | |
CN111435327B (en) | Log record processing method, device and system | |
CN104123104A (en) | Log control system and method | |
CN114880394B (en) | SQL script sharing method, device and medium | |
CN115757174A (en) | Database difference detection method and device | |
CN108241622B (en) | Query script generation method and device | |
CN114138745A (en) | Data integration method and device, storage medium and processor | |
CN109960497A (en) | Call method and device between a kind of script file | |
CN115827589A (en) | Authority verification method and device, electronic equipment and storage medium | |
CN108897873B (en) | Method and device for generating job file, storage medium and processor | |
CN110554867B (en) | Application processing method and device | |
CN112559331A (en) | Test method and device | |
CN112580915A (en) | Project milestone determination method and device, storage medium and electronic equipment | |
CN112558845A (en) | Form operation method and form operation device |
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 |