Method, device and use for implementing dblink based on external data wrapper in OpenGauss database
By implementing the dblink function in the OpenGauss database and using external data wrappers to create a dblink for the remote database, the OpenGauss database has solved the problems of cumbersome steps, poor flexibility and high maintenance costs for accessing the remote database table data, and achieved convenient and efficient access to the remote database table data, reducing maintenance costs.
CN114116662BActive Publication Date: 2025-03-25NANJING MAGNANIMOUS SECURITY TECH CO LTD
2 Cites 0 Cited by
Patent Information
- Application Number
- CN202111332968.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-11-11
- Publication Date
- 2025-03-25
- Estimated Expiration
- 2041-11-11
AI Technical Summary
Technical Problem
The OpenGauss database accesses remote database table data through an external data wrapper for cumbersome steps, poor flexibility and high maintenance costs.
Method used
By implementing the dblink function in the OpenGauss database, using external data wrappers to create dblinks for remote databases, OpenGauss can access data in remote database tables at any time like accessing local databases, without creating corresponding external tables in the local database, and without paying attention to the changes in the table structure of remote database tables.
Benefits of technology
It greatly facilitates OpenGauss' access to remote database table data, improves its convenience and flexibility, and reduces database maintenance costs.
✦ Generated by Eureka AI based on patent content.
Abstract
The present invention belongs to the technical field of database operating system and computer software, and in particular, relates to a method, device and use for realizing dblink based on external data wrapper in OpenGauss database. By using this method, OpenGauss database can obtain dblink function similar to Oracle database, and by creating dblink of remote database, OpenGauss can access data in remote database table at any time just like accessing local database, without creating corresponding external table in local database, and without paying attention to the table structure change of remote database table, thereby greatly facilitating OpenGauss's access to remote database table data, improving its convenience and flexibility, and effectively reducing database maintenance cost.
Need to check novelty before this filing date? Find Prior Art