CN112506965A - Database management device and method - Google Patents
Database management device and method Download PDFInfo
- Publication number
- CN112506965A CN112506965A CN202011405070.7A CN202011405070A CN112506965A CN 112506965 A CN112506965 A CN 112506965A CN 202011405070 A CN202011405070 A CN 202011405070A CN 112506965 A CN112506965 A CN 112506965A
- Authority
- CN
- China
- Prior art keywords
- target
- database
- user
- module
- target data
- 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.)
- Pending
Links
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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Abstract
The invention provides a database management device and a method, wherein the device comprises: the system comprises a connecting module, a judging module and a judging module, wherein the connecting module is connected with a plurality of databases and is used for establishing communication connection between a target user passing identity authentication and at least one target database in the databases and receiving target data input by the target user; the analysis module is connected with the connection module and is used for analyzing the target data so as to at least determine the actual intention represented by the target data; the optimization module is connected with the analysis module and used for determining an execution scheme according to the actual intention; and the execution module is connected with the optimization module and used for executing tasks according to the execution scheme. The database management device can simultaneously carry out unified management on a plurality of databases, and is convenient for users to use.
Description
Technical Field
The embodiment of the invention relates to the technical field of computers, in particular to a database management device and a database management method.
Background
With the development of the internet, the software in various shapes and colors is in endless, and many software needs to use one or more databases to store data. There are great difficulties for developers in database management. In the prior art, each database needs a separate management tool, when the device is used for software development, at least two databases are usually used, and in order to realize flexible use of the at least two databases, a user needs to open two asynchronous database management tools and frequently switch the management tools to use different data, which is a tedious process.
Disclosure of Invention
The invention provides a database management device and a database management method which can simultaneously carry out unified management on a plurality of databases.
In order to solve the above technical problem, an embodiment of the present invention provides a database management apparatus, including:
the system comprises a connecting module, a judging module and a judging module, wherein the connecting module is connected with a plurality of databases and is used for establishing communication connection between a target user passing identity authentication and at least one target database in the databases and receiving target data input by the target user;
the analysis module is connected with the connection module and is used for analyzing the target data so as to at least determine the actual intention represented by the target data;
the optimization module is connected with the analysis module and used for determining an execution scheme according to the actual intention; and
and the execution module is connected with the optimization module and used for executing tasks according to the execution scheme.
Preferably, the connection module includes at least two database connection pools, each database connection pool has at least one link, the at least one link is connected to a corresponding database, and the target user establishes a communication connection with the at least one target database through the at least one link in the corresponding database connection pool.
Preferably, the target data includes data for identifying and determining the at least one target database, and the connection module determines the corresponding database connection pool based on the target data, where the corresponding database connection pool includes a link correspondingly connected to the at least one target database.
Preferably, the analysis module analyzes the target data to extract at least one or more information of a query field and a keyword, and determines at least the actual intention based on the extracted information, and whether data corresponding to the information is stored in the plurality of databases.
Preferably, the optimization module updates a query condition according to the actual intention and the extracted information, so as to determine the execution scheme based on the updated query condition.
Preferably, the method further comprises the following steps:
and the importing module is used for importing the target data according to a target file specified by a user through a corresponding file path, verifying the target data and transmitting the verified target data to the analysis module.
Another embodiment of the present invention provides a database management method, including:
verifying the identity of the user;
under the condition that the user is determined to be a target user, establishing communication connection between the target user and at least one target database in a plurality of databases, and receiving target data;
analyzing the target data to determine at least an actual intent characterized by the target data;
determining an execution scheme according to the actual intention;
and executing the task according to the execution scheme.
Preferably, the target data includes data for identifying and determining the at least one target database, and in the case that the user is determined to be a target user, establishing a communication connection with the target user includes:
determining that the user is a target user under the condition that the identity authentication of the user passes;
determining a database connection pool corresponding to the target data according to the target data, and defining the database connection pool corresponding to the target data as a database connection pool corresponding to the target user;
and establishing communication connection between the target user and at least one target database based on at least one link in the corresponding database connection pool, wherein the at least one link is connected with the corresponding database.
Preferably, the analyzing the target data to determine at least an actual intent characterized by the target data includes:
analyzing the target data and extracting at least one or more information of query fields and keywords;
determining, based on the information, at least the actual intent and whether data corresponding to the information is stored in the plurality of databases;
the determining an execution scheme according to the actual intention includes:
and under the condition that the data corresponding to the information are stored in the plurality of databases, updating query conditions according to the actual intention and the extracted information so as to determine the execution scheme based on the updated query conditions.
Preferably, the method further comprises the following steps:
determining a target file and a file path based on a user instruction;
and acquiring the target data from the target file based on the file path, and defining the target data as the data input by the target user.
Based on the disclosure of the above embodiments, the embodiments of the present invention have the advantages that a database management device can simultaneously and uniformly manage a plurality of different databases by setting a plurality of different functional modules, and frequent switching of management programs for use of different databases is not required, thereby reducing user operations. In addition, the database management device of the invention can provide a plurality of links for connecting different databases, thereby greatly facilitating the establishment of communication connection between different users and the required database so as to obtain the required data or store the input data.
Drawings
Fig. 1 is a structural relationship diagram of a database management apparatus according to an embodiment of the present invention.
FIG. 2 is a logic flow diagram of a method in accordance with an embodiment of the present invention.
Fig. 3 is a structural relationship diagram of a database management apparatus according to another embodiment of the present invention.
FIG. 4 is a logic flow diagram of a method in accordance with another embodiment of the present invention.
FIG. 5 is a flowchart of a database management method in an embodiment of the invention.
Detailed Description
The following detailed description of specific embodiments of the present invention is provided in connection with the accompanying drawings, which are not intended to limit the invention.
It will be understood that various modifications may be made to the embodiments disclosed herein. The following description is, therefore, not to be taken in a limiting sense, but is made merely as an exemplification of embodiments. Other modifications will occur to those skilled in the art within the scope and spirit of the disclosure.
The accompanying drawings, which are incorporated in and constitute a part of the specification, illustrate embodiments of the disclosure and, together with a general description of the disclosure given above, and the detailed description of the embodiments given below, serve to explain the principles of the disclosure.
These and other characteristics of the invention will become apparent from the following description of a preferred form of embodiment, given as a non-limiting example, with reference to the accompanying drawings.
It should also be understood that, although the invention has been described with reference to some specific examples, a person of skill in the art shall certainly be able to achieve many other equivalent forms of the invention, having the characteristics as set forth in the claims and hence all coming within the field of protection defined thereby.
The above and other aspects, features and advantages of the present disclosure will become more apparent in view of the following detailed description when taken in conjunction with the accompanying drawings.
Specific embodiments of the present disclosure are described hereinafter with reference to the accompanying drawings; however, it is to be understood that the disclosed embodiments are merely examples of the disclosure that may be embodied in various forms. Well-known and/or repeated functions and structures have not been described in detail so as not to obscure the present disclosure with unnecessary or unnecessary detail. Therefore, specific structural and functional details disclosed herein are not to be interpreted as limiting, but merely as a basis for the claims and as a representative basis for teaching one skilled in the art to variously employ the present disclosure in virtually any appropriately detailed structure.
The specification may use the phrases "in one embodiment," "in another embodiment," "in yet another embodiment," or "in other embodiments," which may each refer to one or more of the same or different embodiments in accordance with the disclosure.
Hereinafter, embodiments of the present invention will be described in detail with reference to the accompanying drawings.
As shown in fig. 1, an embodiment of the present invention provides a database management apparatus, including:
the connection module is connected with the plurality of databases and is used for establishing communication connection between the target user passing the identity authentication and at least one target database in the plurality of databases and receiving target data input by the target user;
the analysis module is connected with the connection module and is used for analyzing the target data so as to at least determine the actual intention represented by the target data;
the optimization module is connected with the analysis module and used for determining an execution scheme according to the actual intention; and
and the execution module is connected with the optimization module and used for executing the tasks according to the execution scheme.
For example, when a user wants to call data in a certain database, the user may perform authentication through the connection module, or perform authentication through other modules dedicated to authentication, and when the user passes authentication, the user is deemed as a target user, and the connection module may allow the target user to establish a communication connection with the database management apparatus, so as to establish a communication connection with a plurality of databases managed by the database management apparatus through the connection module of the database management apparatus, and receive target data for search call input by the target user based on the communication connection. When the communication connection is established and the target data is received, the connection module transmits the received target data to the analysis module, the analysis module analyzes the target data, the actual intention of the representation of the target data is determined, the analysis result and the target data are transmitted to the optimization module together, the optimization module works out a specific execution scheme for enabling a user to quickly search and call the required data based on the received data, and finally the optimization module transmits the execution scheme to the execution module, so that the execution module executes the execution scheme, the equipment makes a correct response, and quickly outputs a correct response result.
Based on the disclosure of the above embodiments, the embodiments of the present invention have the advantages that a database management device can simultaneously and uniformly manage a plurality of different databases by setting a plurality of different functional modules, and frequent switching of management programs for use of different databases is not required, thereby reducing user operations.
Specifically, the databases described in this embodiment may specifically include, but are not limited to, MySQL, maridb, SQL Server, SQLite, Oracle, manchurian, DB2, china, damming, SYBASE, and 3 kinds of NoSQL databases: as a matter of course, along with the generation of a new database, the database management apparatus in the present embodiment may also manage the newly generated database by using the same management mechanism.
Further, the connection module in this embodiment is used for taking charge of the successful login of the user to the database, and may specifically include authenticating the identity of the user, for example, checking an account and a password of the user, determining a specific right of use of the database by the user, and the like.
Specifically, in order to speed up the simultaneous connection of multiple users to the same or different databases, improve the utilization rate of the multiple databases, and reduce the memory throughput of the databases, as shown in fig. 2, the connection module in this embodiment includes at least two database connection pools, each database connection pool has at least one link, each link is connected to a corresponding database, and a target user establishes a communication connection with at least one target database through at least one link in the corresponding database connection pool. For example, each link in the plurality of links is connected to a database, the connected databases may be the same database or different databases, and based on the different links, the target user may directly establish a communication connection with the corresponding database.
In practical applications, the data connection pool in this embodiment is equivalent to a "buffer pool" established for a plurality of links provided for a plurality of databases. The management device can put a certain number of links in the buffer pool in advance, when a target user needs to establish connection with the target database through one of the links, the management device can provide a link for the target user, when the user establishes communication connection with the target database based on the link, searches and retrieves the required data, the target user can disconnect the connection, and at the moment, the management device can put the link in the buffer pool again for other target users to continue using.
Preferably, in order to avoid that the database is used in a large amount at the same time, which causes an excessive memory throughput and affects the normal operation of the database, in this embodiment, the number of links in the buffer pool may be limited to fix the number of connections that can be established with the database at a time point or within a time period. For example, a buffer pool, upon initialization, will create a certain number of database links into the pool, which may be set by the minimum number of database links. Whether or not these database links are used, it will always be guaranteed to have at least this limited number of data links in the buffer pool. And the number also defines the maximum connection number which can be accommodated by the buffer pool, when the number of requests of the target user for connection from the buffer pool based on different application programs exceeds the maximum connection number which can be provided or accommodated by the buffer pool, the requests exceeding the maximum connection number are added into a waiting queue, and only after the target user which has previously completed connection exits the connection, the next request meeting the time sequence in the waiting queue is responded by the buffer pool.
Further, the number of data connection pools (i.e., the above-mentioned buffer pools) is not unique, and the links contained in each data connection pool (i.e., the above-mentioned data links) may be the same or different, for example, MySQL, MariaDB, SQL Server, SQLite, Oracle, Renjin, DB2, State, Dameng, SYBASE, MongoDB, Hbase use JDBC connection pools. Redis uses Jedis to connect pools. The target data in this embodiment includes data for identifying and determining at least one target database, for example, data including database IP, port, user name, password, data type of the target data (e.g., MySql, Oracle, etc.), and the like. The connection module may determine, based on the target data, a database connection pool corresponding to the target data and the target user, where the corresponding database connection pool includes a link correspondingly connected to at least one target database, that is, the corresponding database connection pool includes a plurality of data links, and the plurality of data links includes a data link connected to a target database that includes the target data and is intended to be connected by the target user. When the connection module determines the corresponding data connection pool, the target user can be allowed to call a certain link in the corresponding data connection pool through the application program to complete the communication connection between the target user and the target database.
Further, the database management apparatus may have a user interface/management interface through which the target user may input the target data. After receiving the target data, the analysis module analyzes the target data to extract at least one or more information of the query field and the keywords, and determines at least an actual intention based on the extracted information, and whether data corresponding to the information is stored in a plurality of databases. For example, the user inputs an SQL statement based on the interface, which is composed of a plurality of strings and is used for querying a user table, the analysis module extracts keywords, such as select, based on the SQL statement, extracts a table to be queried, such as extracting a field name corresponding to the table, extracting more query conditions, and the like. Then, the analysis module will inquire whether the user table exists or not and whether the field of the added inquiry condition exists or not, that is, whether the user table is stored in each database or not and whether the data corresponding to the inquiry condition exists or not, if the data does not exist through inquiry, the management interface is controlled to output abnormal prompt information, and a specific error reason is returned, and if the data does exist, the optimization module is directly called.
Further, after receiving the data transmitted by the analysis module, the optimization module in this embodiment updates the query condition according to the actual intention and the extracted information, so as to determine the execution scheme based on the updated query condition. Specifically, the optimization module in this embodiment may be an optimizer, and the optimizer may determine the optimal execution scheme to be the final execution scheme, for example, when the optimization module determines a plurality of index schemes based on the data transmitted by the analysis module, the optimization module may select the optimal scheme based on the determined plurality of index schemes, and the reference factor may include how to select the association sequence in the multi-table query, for example. Specifically, assuming that a target user wants to query a user table (i.e., the user table), the extracted query field is id, name, and age, the query condition or the actual intention is to query all field data in the table, and the corresponding SQL statement is SELECT FROM user, at this time, the optimization module will automatically convert the SQL statement corresponding to the query condition into a SELECT id, name, and age FROM user, that is, combine the query condition with the extracted query field to update the query statement, thereby achieving the effect of accelerating the query speed. The method can be applied to various databases, such as an Oracle database, and the effect of accelerating the query is obvious.
When the optimization module selects the optimal scheme, namely the execution scheme, the execution scheme is transmitted to the execution module and executed by the execution module, and finally the response result is transmitted to the user. And in order to further determine whether the corresponding target user has the authority to call the data in the target database, the execution module checks the authority of the target user again before the scheme is executed, if the target user does not have the corresponding authority, the execution module returns error information, and if the target user is determined to have the corresponding authority, the execution module directly calls an engine interface, executes the execution scheme, and returns an execution result based on a sister interface.
Further, as shown in fig. 3, the database management apparatus in the present embodiment further includes
And the import module is respectively connected with the connection module and the analysis module, and is used for importing target data according to a target file specified by a user through a corresponding file path, verifying the target data and transmitting the verified target data to the analysis module.
For example, as shown in fig. 4, the target user selects the target file and the file path through the management interface, then the target user reads the SQL file content in the target file based on the application program usage, and then writes the SQL file content into the management interface, and the target user determines to execute the writing/storing of the file after viewing the modification by itself. The specific execution process during storage comprises the following steps: the method comprises the steps of firstly analyzing an SQL statement, detecting whether the statement has errors or not, optimizing the SQL statement if the statement has no errors, determining an optimal execution scheme, finally executing the SQL statement based on the execution scheme, saving data, and ending the whole process, wherein the process is the same as the execution sequence of the event manually input into the SQL statement by a target user at a window of a management interface or a window of an application program.
Through the management of the database management device on the databases, the databases can provide remote test database connection (connection module execution), SQL beautification (analysis module, optimization module execution), SQL script operation (execution module execution), SQL script backup (optimization module, execution module execution), NoSQL data query (execution module execution), NoSQL data modification (execution module execution), NoSQL data addition (execution module execution), paging display of data content and abnormal information prompt, the management mode of the databases is greatly optimized, the use steps of the databases by a user are simplified, and the user experience is improved.
Further, as shown in fig. 5, the present invention also provides a database management method applied in the above database management apparatus, the database management method comprising:
verifying the identity of the user;
under the condition that the user is determined to be the target user, establishing communication connection between the target user and at least one target database in the plurality of databases, and receiving target data;
analyzing the target data to determine at least an actual intent of the target data representation;
determining an execution scheme according to the actual intention;
the tasks are executed according to an execution scheme.
For example, when a user wants to call data in a certain database, the user may perform authentication through a connection module in the database management device, or perform authentication through other modules dedicated to authentication, and when the user passes the authentication, the user is regarded as a target user, and the connection module may allow the target user to establish a communication connection with the database management device, so as to establish a communication connection with a plurality of databases managed by the database management device in a unified manner through the connection module of the database management device, and receive target data for search call input by the target user based on the communication connection. When the communication connection is established and the target data is received, the connection module transmits the received target data to an analysis module in the database management device, the analysis module analyzes the target data, the actual intention of the representation of the target data is determined, the analysis result and the target data are transmitted to an optimization module in the database management device together, the optimization module makes a specific execution scheme for enabling a user to quickly search and call the required data based on the received data, and finally the optimization module transmits the execution scheme to an execution module in the database management device, so that the execution module executes the execution scheme, the equipment makes a correct response, and the correct response result is quickly output.
Based on the disclosure of the above embodiments, the embodiments of the present invention have the advantages that the database management device can simultaneously and uniformly manage a plurality of different databases, frequent switching of management programs for use of different databases is not required, user operations are reduced, and user experience is improved.
Preferably, the target data in this embodiment includes data for identifying and determining at least one target database. When the user establishes communication connection with the target user under the condition that the user is determined to be the target user, the method comprises the following steps:
determining that the user is a target user under the condition that the identity authentication of the user passes;
determining a database connection pool corresponding to the target data according to the target data, and defining the database connection pool corresponding to the target data as a database connection pool corresponding to a target user;
and establishing communication connection between the target user and at least one target database based on at least one link in the corresponding database connection pool, wherein the at least one link is connected with a corresponding database.
Preferably, when analyzing the target data to determine at least an actual intention of the target data representation, the embodiment includes:
analyzing the target data and extracting at least one or more information of query fields and keywords;
determining at least an actual intention based on the information, and whether data corresponding to the information is stored in a plurality of databases;
determining an execution scheme according to the actual intention, comprising:
and in the case of determining that the data of the corresponding information is stored in the plurality of databases, updating the query condition according to the actual intention and the extracted information so as to determine the execution scheme based on the updated query condition.
Preferably, the method in this embodiment further includes:
determining a target file and a file path based on a user instruction;
and acquiring target data from the target file based on the file path, and defining the target data as data input by a target user.
The above embodiments are only exemplary embodiments of the present invention, and are not intended to limit the present invention, and the scope of the present invention is defined by the claims. Various modifications and equivalents may be made by those skilled in the art within the spirit and scope of the present invention, and such modifications and equivalents should also be considered as falling within the scope of the present invention.
Claims (10)
1. A database management apparatus comprising:
the system comprises a connecting module, a judging module and a judging module, wherein the connecting module is connected with a plurality of databases and is used for establishing communication connection between a target user passing identity authentication and at least one target database in the databases and receiving target data input by the target user;
the analysis module is connected with the connection module and is used for analyzing the target data so as to at least determine the actual intention represented by the target data;
the optimization module is connected with the analysis module and used for determining an execution scheme according to the actual intention; and
and the execution module is connected with the optimization module and used for executing tasks according to the execution scheme.
2. The database management apparatus of claim 1, wherein the connection module comprises at least two database connection pools, each of the database connection pools having at least one link, the at least one link being connected to a corresponding database, the target user establishing a communication connection with the at least one target database through the at least one link in the corresponding database connection pool.
3. The database management apparatus of claim 2, wherein the target data comprises data identifying and identifying the at least one target database, and the connection module determines the corresponding database connection pool based on the target data, wherein the corresponding database connection pool contains links corresponding to the at least one target database.
4. The database management apparatus according to claim 1, wherein the analysis module analyzes the target data to extract at least one or more of information of a query field, a keyword, and determines at least the actual intention based on the extracted information, and whether data corresponding to the information is stored in the plurality of databases.
5. The database management apparatus according to claim 1, wherein the optimization module updates a query condition according to the actual intention and the extracted information to determine the execution plan based on the updated query condition.
6. The database management apparatus according to claim 1, further comprising:
and the importing module is used for importing the target data according to a target file specified by a user through a corresponding file path, verifying the target data and transmitting the verified target data to the analysis module.
7. A database management method, comprising:
verifying the identity of the user;
under the condition that the user is determined to be a target user, establishing communication connection between the target user and at least one target database in a plurality of databases, and receiving target data;
analyzing the target data to determine at least an actual intent characterized by the target data;
determining an execution scheme according to the actual intention;
and executing the task according to the execution scheme.
8. The method of claim 7, wherein the target data comprises data identifying and identifying the at least one target database, and wherein establishing a communication connection with the target user if the user is identified as the target user comprises:
determining that the user is a target user under the condition that the identity authentication of the user passes;
determining a database connection pool corresponding to the target data according to the target data, and defining the database connection pool corresponding to the target data as a database connection pool corresponding to the target user;
and establishing communication connection between the target user and at least one target database based on at least one link in the corresponding database connection pool, wherein the at least one link is connected with the corresponding database.
9. The method of claim 7, wherein said analyzing said target data to determine at least an actual intent characterized by said target data comprises:
analyzing the target data and extracting at least one or more information of query fields and keywords;
determining, based on the information, at least the actual intent and whether data corresponding to the information is stored in the plurality of databases;
the determining an execution scheme according to the actual intention includes:
and under the condition that the data corresponding to the information are stored in the plurality of databases, updating query conditions according to the actual intention and the extracted information so as to determine the execution scheme based on the updated query conditions.
10. The method of claim 7, further comprising:
determining a target file and a file path based on a user instruction;
and acquiring the target data from the target file based on the file path, and defining the target data as the data input by the target user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011405070.7A CN112506965A (en) | 2020-12-03 | 2020-12-03 | Database management device and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011405070.7A CN112506965A (en) | 2020-12-03 | 2020-12-03 | Database management device and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112506965A true CN112506965A (en) | 2021-03-16 |
Family
ID=74968429
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011405070.7A Pending CN112506965A (en) | 2020-12-03 | 2020-12-03 | Database management device and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112506965A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105677693A (en) * | 2015-09-18 | 2016-06-15 | 联动优势科技有限公司 | Method and device for accessing databases |
| CN106407432A (en) * | 2016-09-28 | 2017-02-15 | 郑州云海信息技术有限公司 | Oracle data warehouse query method and device |
| CN107291747A (en) * | 2016-03-31 | 2017-10-24 | 北京优朋普乐科技有限公司 | A kind of management method of database connection pool, apparatus and system |
| CN107741937A (en) * | 2016-09-13 | 2018-02-27 | 腾讯科技（深圳）有限公司 | A kind of data query method and device |
| CN110837515A (en) * | 2019-11-06 | 2020-02-25 | 北京天融信网络安全技术有限公司 | Database-based data processing method and electronic equipment |
| CN111522816A (en) * | 2020-04-16 | 2020-08-11 | 云和恩墨(北京)信息技术有限公司 | Data processing method, device, terminal and medium based on database engine |
| CN111563131A (en) * | 2020-04-03 | 2020-08-21 | 苏宁云计算有限公司 | Database entity relation generation method and device, computer equipment and storage medium |
-
2020
- 2020-12-03 CN CN202011405070.7A patent/CN112506965A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105677693A (en) * | 2015-09-18 | 2016-06-15 | 联动优势科技有限公司 | Method and device for accessing databases |
| CN107291747A (en) * | 2016-03-31 | 2017-10-24 | 北京优朋普乐科技有限公司 | A kind of management method of database connection pool, apparatus and system |
| CN107741937A (en) * | 2016-09-13 | 2018-02-27 | 腾讯科技（深圳）有限公司 | A kind of data query method and device |
| CN106407432A (en) * | 2016-09-28 | 2017-02-15 | 郑州云海信息技术有限公司 | Oracle data warehouse query method and device |
| CN110837515A (en) * | 2019-11-06 | 2020-02-25 | 北京天融信网络安全技术有限公司 | Database-based data processing method and electronic equipment |
| CN111563131A (en) * | 2020-04-03 | 2020-08-21 | 苏宁云计算有限公司 | Database entity relation generation method and device, computer equipment and storage medium |
| CN111522816A (en) * | 2020-04-16 | 2020-08-11 | 云和恩墨(北京)信息技术有限公司 | Data processing method, device, terminal and medium based on database engine |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9953639B2 (en) | Voice recognition system and construction method thereof | |
| US20200379963A1 (en) | System and method for cardinality estimation feedback loops in query processing | |
| US9256642B2 (en) | Techniques for recommending parallel execution of SQL statements | |
| EP0756725B1 (en) | Interface device and method | |
| US20140359362A1 (en) | Information interaction test device and method based on automatic generation of associated test cases | |
| US20140250103A1 (en) | Obtaining partial results from a database query | |
| WO2021197432A1 (en) | Routing method and apparatus for database cluster | |
| KR100945282B1 (en) | Verifying method for implementing management software | |
| US8914390B2 (en) | Repetitive query recognition and processing | |
| US11334474B2 (en) | Fast change impact analysis tool for large-scale software systems | |
| CN110597891B (en) | Device, system, method and storage medium for aggregating MySQL into PostgreSQL database | |
| US11263542B2 (en) | Technologies for auto discover and connect to a rest interface | |
| CN114039792B (en) | Data access authority control method, device, equipment and readable storage medium | |
| WO2018076971A1 (en) | Xml data manipulation method and apparatus | |
| CN110851514B (en) | ETL (extract transform load) processing method based on FLINK (Linear rotation injection) | |
| CN111930489A (en) | Task scheduling method, device, equipment and storage medium | |
| CN115794874A (en) | Method for accelerating GPU operator execution in heterogeneous database system and application | |
| CN113254519B (en) | Access method, device, equipment and storage medium of multi-source heterogeneous database | |
| CN111221918A (en) | Data updating method, device, product and medium based on relational database | |
| CN109948332A (en) | A kind of physical machine login password remapping method and device | |
| US11567957B2 (en) | Incremental addition of data to partitions in database tables | |
| CN112506965A (en) | Database management device and method | |
| US10838947B2 (en) | Consistency check for foreign key definition | |
| CN108959952B (en) | Data platform authority control method, device and equipment | |
| CN114020446A (en) | Cross-multi-engine routing processing method, device, equipment and storage medium |
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 |