CN106055582A - Method and apparatus for replacing table name of database - Google Patents
Method and apparatus for replacing table name of database Download PDFInfo
- Publication number
- CN106055582A CN106055582A CN201610342150.XA CN201610342150A CN106055582A CN 106055582 A CN106055582 A CN 106055582A CN 201610342150 A CN201610342150 A CN 201610342150A CN 106055582 A CN106055582 A CN 106055582A
- Authority
- CN
- China
- Prior art keywords
- persistence object
- persistence
- complex characters
- characters string
- database table
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Embodiments of the present invention provide a method and apparatus for replacing a table name of a database table. The method comprises obtaining a persistent object; searching a complex character string corresponding to the persistent object according to a preset mapping table; generating an SQL sentence operating the persistent object according to the complex character string, wherein an initial table name of the database table in the SQL sentence is the complex character string; obtaining tenant information, and generating an actual table name of the database table according to the tenant information; and replacing the complex character string of the database table in the SQL sentence by using the actual table name of the database table. The initial table name of the database table in the SQL sentence is replaced by the complex character string, the complex character string cannot be identical with character strings except the initial table name of the database table in the SQL sentence, so that the error occurring when the table name of the database table in the SQL sentence is replaced is prevented, and the table name of the database table of the SQL sentence can be correctly replaced.
Description
Technical field
The present invention relates to field of computer technology, particularly relate to method and the dress of the table name of a kind of replacement data storehouse table
Put.
Background technology
Many tenants technology is a kind of software architecture technology in cloud computing, and this technology can realize multiple user and share identical
System or program assembly, but ensure the isolation of the data between different user simultaneously.Many tenants technology stores in data
The upper main following three pattern that uses:
The first pattern: self contained data base, i.e. one tenant independently uses a data database storing.This pattern count
Best according to isolation, but database maintenance cost is the highest.
The second pattern: shared data bank, independent Schema, the most multiple tenants use same data base, each tenant
The independent Schema used in this data base.The data of each tenant are stored in one group of database table of this Schema
In.This mode data isolation is preferable, however it is necessary that the multiple Schema of maintenance.
The third pattern: shared data bank, shares Schema, and the most multiple tenants use same data base, use same
Individual Schema.In a Schema, setting up the database table that many nested structures are identical, each tenant is used alone a set of data base
Table storage data, give the database table name of this tenant, it is thus achieved that this database table according to the information (such as: the ID of tenant) of tenant
Actual table name, it is achieved the data of many tenants are isolated, reduce maintenance cost.Performing SQL
During (Structured Query Language, SQL) statement, replace the number in this SQL statement with the actual table name of database table
Initial table name according to table.
But, use the third pattern to realize many tenants technology, performing to replace the table name of the tables of data in SQL statement
Time, if in SQL statement, in addition to the initial table name of database table, there is also the initial table name with described database table
Identical character string, the table name that will produce SQL statement is replaced mistake, is caused SQL statement mistake.
Summary of the invention
Present invention solves the technical problem that the method and device being to provide the table name of a kind of replacement data storehouse table, it is thus possible to
The table name enough avoiding database table in SQL statement replaces mistake.
To this end, the technical scheme that the present invention solves technical problem is:
A kind of method of the table name of replacement data storehouse table, described method includes:
Obtain persistence object；
Searching, according to default mapping table, the complex characters string that described persistence object is corresponding, described default mapping table is deposited
Containing the corresponding relation of many group persistence objects and complex characters string, described complex characters string will not be with divisor evidence in SQL statement
Character string beyond the initial table name of storehouse table is identical；
The SQL statement of operation described persistence object is concatenated into, number described in described SQL statement according to described complex characters
According to the entitled described complex characters string of the initial table of storehouse table；
Obtain tenant's information, generate the actual table name of described database table according to described tenant's information；
The actual table name utilizing described database table replaces the complex characters string of database table described in described SQL statement.
Optionally, the method to set up of described default mapping table includes:
The corresponding relation of persistence object and the initial table name of database table is obtained from server；
A complex characters string is generated to each persistence object；
The initial table name of database table corresponding to this persistence object is replaced with the complex characters string of each persistence object,
Set up the corresponding relation described default mapping table of generation of each persistence object and complex characters string.
Optionally, described to each persistence object generate a complex characters string include:
Obtain the random code pre-set to each persistence object, the random code of each persistence object is held as this
The complex characters string of longization object.
Optionally, described to each persistence object generate a complex characters string include:
A random code is generated, using the random code of each persistence object as this persistence pair to each persistence object
The complex characters string of elephant.
Optionally, described to each persistence object generate a complex characters string include:
A random code is generated to each persistence object；
The initial table name of database table corresponding with this persistence object for the random code of each persistence object is combined and makees
Complex characters string for this persistence object.
Optionally, described method also includes:
Utilize described SQL statement that described persistence object is operated.
Optionally, described method also includes:
Described default mapping table is edited.
A kind of device of the table name of replacement data storehouse table, described device includes:
First acquiring unit, is used for obtaining persistence object；
Search unit, for searching, according to the mapping table preset, the complex characters string that described persistence object is corresponding, described
The mapping table storage preset has many group persistence objects and the corresponding relation of complex characters string, and described complex characters string will not be with
In SQL statement, the character string in addition to the initial table name of database table is identical；
First signal generating unit, for concatenating into the SQL statement of operation described persistence object, institute according to described complex characters
State the entitled described complex characters string of initial table of database table described in SQL statement；
Second signal generating unit, is used for obtaining tenant's information, generates the reality of described database table according to described tenant's information
Table name；
Replacement unit, for utilizing the actual table name of described database table to replace database table described in described SQL statement
Complex characters string.
Optionally, described device also includes:
Second acquisition unit, for obtaining from server, persistence object is corresponding with the initial table name of database table to close
System；
3rd signal generating unit, for generating a complex characters string to each persistence object；
Setting up unit, the complex characters string for each persistence object replaces the database table that this persistence object is corresponding
Initial table name, the corresponding relation setting up each persistence object and complex characters string generates described default mapping table.
Optionally,
Described 3rd signal generating unit, for obtaining the random code that pre-sets to each persistence object, by each persistently
Change the random code complex characters string as this persistence object of object.
Optionally,
Described 3rd signal generating unit, for generating a random code to each persistence object, by each persistence object
Random code as the complex characters string of this persistence object.
Optionally, described 3rd signal generating unit includes:
Generate subelement, for generating a random code to each persistence object；
Combination subelement, for by database table corresponding with this persistence object for the random code of each persistence object
Initial table name combination is as the complex characters string of this persistence object.
Optionally, described device also includes:
Operating unit, is used for utilizing described SQL statement to operate described persistence object.
Optionally, described device also includes:
Edit cell, for editing described default mapping table.
By technique scheme, the method have the advantages that:
Embodiments provide the method and device of the table name of a kind of replacement data storehouse table, obtain persistence object；
Searching, according to default mapping table, the complex characters string that described persistence object is corresponding, described default mapping table storage has many groups
Persistence object and the corresponding relation of complex characters string, described complex characters string will not remove at the beginning of database table in SQL statement
Character string beyond beginning table name is identical；The SQL statement of operation described persistence object is concatenated into according to described complex characters, described
The entitled described complex characters string of initial table of database table described in SQL statement；Obtain tenant's information, according to described tenant's information
Generate the actual table name of described database table；The actual table name utilizing described database table replaces number described in described SQL statement
Complex characters string according to storehouse table.In SQL statement, the initial table name of database table is replaced by complex characters string, described complex characters string
Will not be identical with character string in addition to the initial table name of database table in SQL statement, it is to avoid carry out database table in SQL statement
Table name mistake occurs when replacing, it is achieved the table name of the correct database table replacing SQL statement.
Accompanying drawing explanation
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
In having technology to describe, the required accompanying drawing used is briefly described, it should be apparent that, the accompanying drawing in describing below is only this
Some embodiments of invention, for those of ordinary skill in the art, on the premise of not paying creative work, it is also possible to
Other accompanying drawing is obtained according to these accompanying drawings.
The method flow diagram of the table name of the replacement data storehouse table that Fig. 1 provides for the embodiment of the present invention；
The apparatus structure schematic diagram of the table name of the replacement data storehouse table that Fig. 2 provides for the embodiment of the present invention.
Detailed description of the invention
In order to provide the implementation of the table name of database table in correct replacement SQL statement, embodiments provide
The preferred embodiments of the present invention are carried out by the method and device of the table name of a kind of replacement data storehouse table below in conjunction with Figure of description
Explanation.
Embodiment one
The method flow diagram of the table name of the replacement data storehouse table that Fig. 1 provides for the embodiment of the present invention, including:
101: obtain persistence object.
102: search the complex characters string that described persistence object is corresponding, described default mapping according to default mapping table
Table storage has the corresponding relation of many group persistence objects and complex characters string, and described complex characters string will not remove in SQL statement
Character string beyond the initial table name of database table is identical.
In the mapping table preset, storage has the corresponding relation of many group persistence objects and complex characters string, i.e. one persistence
Object corresponds to a complex characters string.The complex characters string that each persistence object is corresponding is the most complicated, than database table
The character string that original table name is used is complicated many.Therefore, the complex characters string that each persistence object is corresponding will not be with SQL language
In Ju, the character string in addition to the initial table name of database table is identical.
In one example, the method to set up of described default mapping table includes:
The corresponding relation of persistence object and the initial table name of database table is obtained from server；
A complex characters string is generated to each persistence object；
The initial table name of database table corresponding to this persistence object is replaced with the complex characters string of each persistence object,
Set up the corresponding relation described default mapping table of generation of each persistence object and complex characters string.
Under original state, server arranges an initial table name to every sets of data storehouse table, and storage has persistently in the server
Change the corresponding relation of object and the initial table name of tables of data, obtain persistence object pass corresponding with the initial table name of database table
System.
Generate a complex characters string to each persistence object, have at least three kinds of possible implementations:
The first possible implementation:
Obtain the random code pre-set to each persistence object, the random code of each persistence object is held as this
The complex characters string of longization object.
Arranging a random code manually in advance each persistence object, the length of random code and type are according to actual need
Specifically to set, it is ensured that the random code arranged to each persistence object will not be removed at the beginning of database table in SQL statement
Character string identical complex characters string beyond beginning table name.
The implementation that the second is possible:
A random code is generated, using the random code of each persistence object as this persistence pair to each persistence object
The complex characters string of elephant.
Automatically generate a random code, the length of random code and type to each persistence object according to default algorithm
The most specifically set, it is ensured that the random code arranged to each persistence object is will not be with divisor in SQL statement
According to the identical complex characters string of the character string beyond the initial table name of storehouse table.
The third possible implementation:
A random code is generated to each persistence object；
The initial table name of database table corresponding with this persistence object for the random code of each persistence object is combined and makees
Complex characters string for this persistence object.
The random code generated to each persistence object, can be manually generated, it is also possible to automatically give birth to according to default algorithm
Becoming, length and the type of random code the most specifically set.By random code and the data base of each persistence object
The initial table name combination of table is as the complex characters string of this persistence object, each random code and the initial table name group of database table
After conjunction, the complex characters string of gained is all will not be identical multiple with character string in addition to the initial table name of database table in SQL statement
Miscellaneous character string.
The complex characters string generated to each persistence object is utilized to replace database table corresponding to this persistence object
Initial table name, complex characters string is more complicated than the initial table name of database table, will not remove the initial table of database table in SQL statement
Character string beyond Ming is identical.Set up each persistence object pass corresponding with the complex characters string generated to this persistence object
It is as the mapping table preset.
103: concatenate into the SQL statement of operation described persistence object according to described complex characters, institute in described SQL statement
State the entitled described complex characters string of initial table of database table.
In the prior art, in the SQL statement of the operation persistence object of generation, including the number that this persistence object is corresponding
Initial table name according to storehouse table.In the present invention, in the SQL statement of the operation persistence object of generation, this persistence object is corresponding
The initial table name of database table is substituted by complex characters string.That is, in the SQL statement of operation persistence object, there is no database table
Initial table name, only complex characters string.
104: obtain tenant's information, the actual table name of described database table is generated according to described tenant's information.
105: utilize the actual table name of described database table to replace the complex characters of database table described in described SQL statement
String.
The complex characters string in SQL statement is replaced, due to multiple with the actual table name of database table corresponding to persistence object
Miscellaneous character string is the character string more complicated than the original table name of database table, will not with SQL statement in except the initial table of database table
Character string beyond Ming is identical, therefore, when replacing the complex characters string in SQL statement with the actual table name of database table, and will not
The table name producing SQL statement replaces mistake, it is achieved the table name of the correct database table replacing SQL statement.
In one example, also include:
Utilize described SQL statement that described persistence object is operated.
After replacing the complex characters string in SQL statement with the actual table name of database table, utilize the SQL generated after replacing
Described persistence object is operated by statement.
In another example, also include:
Described default mapping table is edited.
In actual applications, technical staff can also edit the persistence object in default mapping table according to actual needs
With the corresponding relation of complex characters string, this editor includes amendment, any one or more in deleting and increasing newly.
As shown in the above, the method have the advantages that:
In SQL statement, the initial table name of database table is replaced by complex characters string, and described complex characters string will not be with SQL language
In Ju, the character string in addition to the initial table name of database table is identical, it is to avoid the table name carrying out database table in SQL statement is replaced
Time mistake occurs, it is achieved the table name of the correct database table replacing SQL statement.
Embodiment two
The apparatus structure schematic diagram of the table name of the replacement data storehouse table that Fig. 2 provides for the embodiment of the present invention, including:
First acquiring unit 201, is used for obtaining persistence object.
Search unit 202, for searching the complex characters string that described persistence object is corresponding, institute according to the mapping table preset
Stating default mapping table storage and have the corresponding relation of many group persistence objects and complex characters string, described complex characters string will not be with
In SQL statement, the character string in addition to the initial table name of database table is identical.
First signal generating unit 203, for concatenating into the SQL language of operation described persistence object according to described complex characters
Sentence, the entitled described complex characters string of the initial table of database table described in described SQL statement.
Second signal generating unit 204, is used for obtaining tenant's information, generates the reality of described database table according to described tenant's information
Border table name.
Replacement unit 205, for utilizing the actual table name of described database table to replace data base described in described SQL statement
The complex characters string of table.
Optionally, described device also includes:
Second acquisition unit, for obtaining from server, persistence object is corresponding with the initial table name of database table to close
System；
3rd signal generating unit, for generating a complex characters string to each persistence object；
Setting up unit, the complex characters string for each persistence object replaces the database table that this persistence object is corresponding
Initial table name, the corresponding relation setting up each persistence object and complex characters string generates described default mapping table.
Optionally, described 3rd signal generating unit, for obtaining the random code pre-set to each persistence object, will be every
The random code of individual persistence object is as the complex characters string of this persistence object.
Optionally, described 3rd signal generating unit, for each persistence object generate a random code, by each persistently
Change the random code complex characters string as this persistence object of object.
Optionally, described 3rd signal generating unit includes:
Generate subelement, for generating a random code to each persistence object；
Combination subelement, for by database table corresponding with this persistence object for the random code of each persistence object
Initial table name combination is as the complex characters string of this persistence object.
Optionally, described device also includes:
Operating unit, is used for utilizing described SQL statement to operate described persistence object.
Optionally, described device also includes:
Edit cell, for editing described default mapping table.
The device of the table name of the replacement data storehouse table shown in Fig. 2 is the side of the table name with the replacement data storehouse table shown in Fig. 1
Device corresponding to method, specific implementation is similar with the method shown in Fig. 1, the description in method described in reference diagram 1, here
Repeat no more.
The above is only the preferred embodiment of the present invention, it is noted that for the ordinary skill people of the art
For Yuan, under the premise without departing from the principles of the invention, it is also possible to make some improvements and modifications, these improvements and modifications also should
It is considered as protection scope of the present invention.
Claims (14)
1. the method for the table name of a replacement data storehouse table, it is characterised in that described method includes:
Obtain persistence object；
Searching, according to default mapping table, the complex characters string that described persistence object is corresponding, described default mapping table storage has
Many group persistence objects and the corresponding relation of complex characters string, described complex characters string will not remove database table in SQL statement
Initial table name beyond character string identical；
The SQL statement of operation described persistence object, data base described in described SQL statement is concatenated into according to described complex characters
The entitled described complex characters string of initial table of table；
Obtain tenant's information, generate the actual table name of described database table according to described tenant's information；
The actual table name utilizing described database table replaces the complex characters string of database table described in described SQL statement.
Method the most according to claim 1, it is characterised in that the method to set up of described default mapping table includes:
The corresponding relation of persistence object and the initial table name of database table is obtained from server；
A complex characters string is generated to each persistence object；
Replace the initial table name of database table corresponding to this persistence object with the complex characters string of each persistence object, set up
Each persistence object generates described default mapping table with the corresponding relation of complex characters string.
Method the most according to claim 2, it is characterised in that described to each persistence object one complex characters of generation
String includes:
Obtain the random code pre-set to each persistence object, using the random code of each persistence object as this persistence
The complex characters string of object.
Method the most according to claim 2, it is characterised in that described to each persistence object one complex characters of generation
String includes:
A random code is generated, using the random code of each persistence object as this persistence object to each persistence object
Complex characters string.
Method the most according to claim 2, it is characterised in that described to each persistence object one complex characters of generation
String includes:
A random code is generated to each persistence object；
The initial table name of database table corresponding with this persistence object for the random code of each persistence object is combined as being somebody's turn to do
The complex characters string of persistence object.
6. according to the method described in claim 1-5 any one, it is characterised in that described method also includes:
Utilize described SQL statement that described persistence object is operated.
7. according to the method described in claim 1-5 any one, it is characterised in that described method also includes:
Described default mapping table is edited.
8. the device of the table name of a replacement data storehouse table, it is characterised in that described device includes:
First acquiring unit, is used for obtaining persistence object；
Lookup unit, for searching, according to the mapping table preset, the complex characters string that described persistence object is corresponding, described default
Mapping table storage have the corresponding relation of many group persistence objects and complex characters string, described complex characters string will not be with SQL language
In Ju, the character string in addition to the initial table name of database table is identical；
First signal generating unit, for concatenating into the SQL statement of operation described persistence object according to described complex characters, described
The entitled described complex characters string of initial table of database table described in SQL statement；
Second signal generating unit, is used for obtaining tenant's information, generates the actual table name of described database table according to described tenant's information；
Replacement unit, for utilizing the actual table name of described database table to replace answering of database table described in described SQL statement
Miscellaneous character string.
Device the most according to claim 8, it is characterised in that described device also includes:
Second acquisition unit, for obtaining the corresponding relation of persistence object and the initial table name of database table from server；
3rd signal generating unit, for generating a complex characters string to each persistence object；
Setting up unit, the complex characters string for each persistence object is replaced at the beginning of the database table that this persistence object is corresponding
Beginning table name, sets up the corresponding relation described default mapping table of generation of each persistence object and complex characters string.
Device the most according to claim 9, it is characterised in that
Described 3rd signal generating unit, for obtaining the random code pre-set to each persistence object, by each persistence pair
The random code of elephant is as the complex characters string of this persistence object.
11. devices according to claim 9, it is characterised in that
Described 3rd signal generating unit, for each persistence object generate a random code, by each persistence object with
Machine code is as the complex characters string of this persistence object.
12. devices according to claim 9, it is characterised in that described 3rd signal generating unit includes:
Generate subelement, for generating a random code to each persistence object；
Combination subelement, initial for by database table corresponding with this persistence object for the random code of each persistence object
Table name combination is as the complex characters string of this persistence object.
13. devices described in-12 any one according to Claim 8, it is characterised in that described device also includes:
Operating unit, is used for utilizing described SQL statement to operate described persistence object.
14. methods described in-12 any one according to Claim 8, it is characterised in that described device also includes:
Edit cell, for editing described default mapping table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610342150.XA CN106055582B (en) | 2016-05-20 | 2016-05-20 | A kind of method and device of the table name in replacement data library |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610342150.XA CN106055582B (en) | 2016-05-20 | 2016-05-20 | A kind of method and device of the table name in replacement data library |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106055582A true CN106055582A (en) | 2016-10-26 |
| CN106055582B CN106055582B (en) | 2019-09-24 |
Family
ID=57176489
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610342150.XA Active CN106055582B (en) | 2016-05-20 | 2016-05-20 | A kind of method and device of the table name in replacement data library |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106055582B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107943995A (en) * | 2017-09-22 | 2018-04-20 | 国网重庆市电力公司电力科学研究院 | A kind of SQL query result row name and coding automatic switching method |
| CN108388588A (en) * | 2018-01-30 | 2018-08-10 | 福建星瑞格软件有限公司 | The offline read method of database functions and system of sql sentence Auto-Generation Tools |
| CN110222071A (en) * | 2019-06-06 | 2019-09-10 | 上海达梦数据库有限公司 | A kind of data query method, apparatus, server and storage medium |
| CN110555030A (en) * | 2018-03-28 | 2019-12-10 | 北京京东尚科信息技术有限公司 | SQL statement processing method and device |
| CN112434042A (en) * | 2020-12-03 | 2021-03-02 | 深圳市欢太科技有限公司 | Data relationship construction method and device, electronic equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101021874A (en) * | 2007-03-21 | 2007-08-22 | 金蝶软件（中国）有限公司 | Method and apparatus for optimizing request to poll SQL |
| US20100131518A1 (en) * | 2008-11-25 | 2010-05-27 | Safenet, Inc. | Database Obfuscation System and Method |
| US20110004622A1 (en) * | 2007-10-17 | 2011-01-06 | Blazent, Inc. | Method and apparatus for gathering and organizing information pertaining to an entity |
| CN103414705A (en) * | 2013-07-30 | 2013-11-27 | 电子科技大学 | Method for mobile internet heterogeneous data exchange based on SAAS mode |
-
2016
- 2016-05-20 CN CN201610342150.XA patent/CN106055582B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101021874A (en) * | 2007-03-21 | 2007-08-22 | 金蝶软件（中国）有限公司 | Method and apparatus for optimizing request to poll SQL |
| US20110004622A1 (en) * | 2007-10-17 | 2011-01-06 | Blazent, Inc. | Method and apparatus for gathering and organizing information pertaining to an entity |
| US20100131518A1 (en) * | 2008-11-25 | 2010-05-27 | Safenet, Inc. | Database Obfuscation System and Method |
| CN103414705A (en) * | 2013-07-30 | 2013-11-27 | 电子科技大学 | Method for mobile internet heterogeneous data exchange based on SAAS mode |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107943995A (en) * | 2017-09-22 | 2018-04-20 | 国网重庆市电力公司电力科学研究院 | A kind of SQL query result row name and coding automatic switching method |
| CN107943995B (en) * | 2017-09-22 | 2022-03-08 | 国网重庆市电力公司电力科学研究院 | Method for automatically converting column names and codes of SQL query results |
| CN108388588A (en) * | 2018-01-30 | 2018-08-10 | 福建星瑞格软件有限公司 | The offline read method of database functions and system of sql sentence Auto-Generation Tools |
| CN110555030A (en) * | 2018-03-28 | 2019-12-10 | 北京京东尚科信息技术有限公司 | SQL statement processing method and device |
| CN110222071A (en) * | 2019-06-06 | 2019-09-10 | 上海达梦数据库有限公司 | A kind of data query method, apparatus, server and storage medium |
| CN110222071B (en) * | 2019-06-06 | 2021-11-02 | 上海达梦数据库有限公司 | Data query method, device, server and storage medium |
| CN112434042A (en) * | 2020-12-03 | 2021-03-02 | 深圳市欢太科技有限公司 | Data relationship construction method and device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106055582B (en) | 2019-09-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106055582A (en) | Method and apparatus for replacing table name of database | |
| CN107807982B (en) | Consistency checking method and device for heterogeneous database | |
| JP6262874B2 (en) | Database implementation method | |
| US9619492B2 (en) | Data migration | |
| CN104035754A (en) | XML (Extensible Markup Language)-based custom code generation method and generator | |
| CN110209728A (en) | A kind of Distributed Heterogeneous Database synchronous method, electronic equipment and storage medium | |
| CN104216961B (en) | A kind of data processing method and device | |
| CN104573022A (en) | Data query method and device for HBase | |
| CN102279749A (en) | Method and equipment for merging codes | |
| CN106055528A (en) | Automatic generation method and apparatus of documents | |
| CN101859303A (en) | Metadata management method and management system | |
| CN102737108A (en) | Method and device for processing flow diagram | |
| CN105893482A (en) | Engine test data fully-automatic extracting and Word report generating method | |
| CN105183898A (en) | Data sync method and data sync system | |
| CN113434482A (en) | Data migration method and device, computer equipment and storage medium | |
| CN105279269A (en) | SQL generating method and system for supporting table free association | |
| CN116028653A (en) | Method and system for constructing map by visually configuring multi-source heterogeneous data | |
| CN109558191A (en) | A kind of method, apparatus, storage medium and computer equipment configuring the page | |
| CN104636401A (en) | Method and device for data rollback of SCADA (supervisory control and data acquisition) system | |
| CN105224663A (en) | A kind of data-accessing tasks management method based on multiple data source and device | |
| CN103441988B (en) | Across GIS platform data migration method | |
| CN106127863B (en) | A kind of refrigerator foaming die series design system and its method | |
| CN105930354A (en) | Storage model conversion method and device | |
| JP2016532897A (en) | Method and apparatus for building an intermediate character library | |
| CN105653565A (en) | Data checking method and data checking apparatus |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |