CN107291907A - A kind of multilingual storage of business datum and querying method and device - Google Patents
A kind of multilingual storage of business datum and querying method and device Download PDFInfo
- Publication number
- CN107291907A CN107291907A CN201710493407.6A CN201710493407A CN107291907A CN 107291907 A CN107291907 A CN 107291907A CN 201710493407 A CN201710493407 A CN 201710493407A CN 107291907 A CN107291907 A CN 107291907A
- Authority
- CN
- China
- Prior art keywords
- multilingual
- field
- business datum
- storage
- unit
- 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
- 238000000034 method Methods 0.000 title claims abstract description 32
- 239000000284 extract Substances 0.000 claims abstract description 8
- 238000012545 processing Methods 0.000 claims description 29
- 238000013461 design Methods 0.000 abstract description 12
- 230000006870 function Effects 0.000 description 10
- 238000012423 maintenance Methods 0.000 description 6
- 230000008569 process Effects 0.000 description 4
- 230000008901 benefit Effects 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 238000006243 chemical reaction Methods 0.000 description 1
- 235000013399 edible fruits Nutrition 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000000877 morphologic effect Effects 0.000 description 1
- 238000012797 qualification Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/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/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
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 present invention proposes a kind of multilingual storage of business datum and querying method and device, and the multilingual storage of business datum and querying method include：The literary name section of business datum table is expanded into multilingual field；Multilingual field is stored to database；Obtain structured query sentence；Analytical structure query statement, extracts the object table and field of structured query sentence；Whether inquiry object table matches with business datum table and field with multilingual field, draws Query Result；When Query Result is object table and business datum table and field and multilingual fields match, field is replaced with into multilingual field, structured query sentence after generation replacement, this invention simplifies the complexity of table design, avoid the Connection inquiring of sql sentences, so that developer need not write the sql sentences of complexity, performance is lifted.
Description
Technical field
The present invention relates to business datum technical field, in particular to a kind of multilingual storage of business datum and inquiry
Method and device.
Background technology
Needing to support world business, establishment officer various regions all over the world, the enterprise's application for supporting it to run large enterprise more
Software must take into consideration the realization of multilingual ability, and application software is multilingual to divide from data character, is divided into the multi-lingual of interactive interface
Business datum of making peace it is multilingual.
Business datum is mainly stored in relevant database, such as oracle, mysql.Available data is multilingual to be realized
Mode is the multilingual metadata table to each Data Sheet Design independence for having a multilingual requirements, and data are associated by external key, than
Name of product such as product information table is multilingual if desired, and its multilingual metadata table is typically designed as { major key ID, product volume
Code, multilingual mark, name of product }, " product coding " is external key.The Connection inquiring mode by sql is needed during inquiry, with
" multilingual mark " is the multi-language data that qualifications inquire client.This mode design cost is high, increase sql exploitations
Complexity, and as data scale expands, performance is restricted.
The content of the invention
It is contemplated that at least solving one of technical problem present in prior art or correlation technique.
Therefore, it is an object of the present invention to propose a kind of multilingual storage of business datum and querying method.
It is another object of the present invention to propose a kind of multilingual storage of business datum and inquiry unit.
In view of this, according to one object of the present invention, it is proposed that a kind of multilingual storage of business datum and querying method,
Including：The literary name section of business datum table is expanded into multilingual field；Multilingual field is stored to database；Obtain structuring
Query statement；Analytical structure query statement, extracts the object table and field of structured query sentence；Inquire about object table and business
Whether tables of data and field match with multilingual field, draw Query Result；When Query Result is object table and business datum
When table and field are with multilingual fields match, field is replaced with into multilingual field, the structuralized query language after generation replacement
Sentence.
The multilingual storage of business datum and querying method that the present invention is provided, the literary name section of business datum table are expanded to many
Language field is simultaneously stored, for example, product information table extension Chinese and English name of product field name of product _ zh,
Name of product _ en }, the sql sentences of inquiry are parsed, the object table and field of its inquiry is analyzed, business datum table is compareed, inquiry is needed
The field of multilingual processing is carried out, this field is replaced with into multilingual field, the structured query sentence after generation replacement, letter
The complexity of table design is changed, it is to avoid the Connection inquiring of sql sentences so that developer need not write the sql sentences of complexity, carry
Rise performance.Specifically, the maintenance function of multi-language data is also provided.
According to the multilingual storage of above-mentioned business datum of the present invention and querying method, there can also be following technical characteristic：
In the above-mentioned technical solutions, it is preferable that the step of literary name section of business datum table is expanded into multilingual field, wrap
Include：Need to carry out the literary name section of multilingual processing in identification service tables of data；Literary name section is expanded into multilingual field.
In the technical scheme, the step of literary name section of business datum table is expanded into multilingual field specifically includes：Mark
Knowledge needs to carry out the specific literary name section of the business datum table of multilingual processing, such as " product information table-name of product ", by literary name
Section expands to multilingual field, without designing independent multilingual metadata table for business datum table, reduces design complexities.
In any of the above-described technical scheme, it is preferable that also include：Structured query sentence after replacement is sent to data
Storehouse is performed.
In the technical scheme, the structured query sentence after replacement is sent to database and performed, using agent skill group
Sql sentences are rewritten, when developer writes query function, without doing extra process.
In any of the above-described technical scheme, it is preferable that also include：Return to Query Result.
In the technical scheme, Query Result is back at application call, without inquiry in a program to return
As a result the aiming field in does secondary inquiry and replacement.
In any of the above-described technical scheme, it is preferable that the structure of business datum table includes following a kind of or its combination：Table
Name, field name.
In the technical scheme, the structure of business datum table includes following a kind of or its combination：Table name, field name, business
Such as tables of data can be the table of relational database, multilingual mark table, and table structure should comprise at least { table name, field name }.
According to another object of the present invention, it is proposed that a kind of multilingual storage of business datum and inquiry unit, including：Mark
Processing unit is known, for the literary name section of business datum table to be expanded into multilingual field；Memory cell, for by multilingual field
Store to database；Acquiring unit, for obtaining structured query sentence；Analytic unit, for analytical structure query statement,
Extract the object table and field of structured query sentence；Query unit, for inquiring about object table and business datum table and field
Whether matched with multilingual field, draw Query Result；Replacement unit, for being object table and business datum table when Query Result
And when field and multilingual fields match, field is replaced with into multilingual field, the structured query sentence after generation replacement.
The multilingual storage of business datum and inquiry unit that the present invention is provided, identify processing unit by the table of business datum table
Field extension is multilingual field and stored by memory cell that for example, product information table extends the product of Chinese and English
Name field { name of product _ zh, name of product _ en }, acquiring unit obtains sql sentences, the sql languages of analytic unit parsing inquiry
Sentence, analyzes the object table and field of its inquiry, and query unit control business datum table, inquiry needs to carry out the word of multilingual processing
This field is replaced with multilingual field by section, replacement unit, and the structured query sentence after generation replacement simplifies table design
Complexity, it is to avoid the Connection inquiring of sql sentences so that developer need not write the sql sentences of complexity, lifts performance.
Specifically, the maintenance function of multi-language data is also provided.
According to the multilingual storage of above-mentioned business datum of the present invention and inquiry unit, there can also be following technical characteristic：
In the above-mentioned technical solutions, it is preferable that mark processing unit, specifically for：Needed in identification service tables of data into
The literary name section of the multilingual processing of row；And literary name section is expanded into multilingual field.
In the technical scheme, mark processing unit mark needs to carry out the specific table of the business datum table of multilingual processing
Field, such as " product information table-name of product ", multilingual field is expanded to by literary name section, without being designed for business datum table
Independent multilingual metadata table, reduces design complexities.
In any of the above-described technical scheme, it is preferable that also include：Execution unit, for by the structuralized query after replacement
Sentence sends to database and performed.
In the technical scheme, the structured query sentence after replacement is sent to database and performed by execution unit, is used
Agent skill group rewrites sql sentences, when developer writes query function, without doing extra process.
In any of the above-described technical scheme, it is preferable that also include：Returning unit, for returning to Query Result.
In the technical scheme, Query Result is back at application call by returning unit, without right in a program
Aiming field in the Query Result of return does secondary inquiry and replacement.
In any of the above-described technical scheme, it is preferable that the structure of business datum table includes following a kind of or its combination：Table
Name, field name.
In the technical scheme, the structure of business datum table includes following a kind of or its combination：Table name, field name, business
Such as tables of data can be the table of relational database, multilingual mark table, and table structure should comprise at least { table name, field name }.
The additional aspect and advantage of the present invention will become obvious in following description section, or pass through the practice of the present invention
Recognize.
Brief description of the drawings
The above-mentioned and/or additional aspect and advantage of the present invention will become from description of the accompanying drawings below to embodiment is combined
Substantially and be readily appreciated that, wherein：
Fig. 1 a show that the flow of the multilingual storage of the business datum of one embodiment of the present of invention and querying method is illustrated
Figure；
Fig. 1 b show that the flow of the multilingual storage of the business datum of an alternative embodiment of the invention and querying method is shown
It is intended to；
Fig. 2 shows the schematic block diagram of the multilingual storage of the business datum of one embodiment of the present of invention and inquiry unit；
Fig. 3 shows that the flow of the multilingual storage of the business datum of the specific embodiment of the present invention and querying method is shown
It is intended to；
Fig. 4 shows the schematic block of the multilingual storage of the business datum of the specific embodiment of the present invention and inquiry unit
Figure.
Embodiment
It is below in conjunction with the accompanying drawings and specific real in order to be more clearly understood that the above objects, features and advantages of the present invention
Mode is applied the present invention is further described in detail.It should be noted that in the case where not conflicting, the implementation of the application
Feature in example and embodiment can be mutually combined.
Many details are elaborated in the following description to facilitate a thorough understanding of the present invention, still, the present invention may be used also
Implemented with being different from other modes described here using other, therefore, protection scope of the present invention is not limited to following public affairs
The limitation for the specific embodiment opened.
The embodiment of first aspect present invention, proposes a kind of multilingual storage of business datum and querying method, and Fig. 1 a are shown
The multilingual storage of business datum of one embodiment of the present of invention and the schematic flow sheet of querying method.Wherein, this method bag
Include：
Step 102, the literary name section of business datum table is expanded into multilingual field；
Step 104, multilingual field is stored to database；
Step 106, structured query sentence is obtained；
Step 108, analytical structure query statement, extracts the object table and field of structured query sentence；
Step 110, whether inquiry object table matches with business datum table and field with multilingual field, draws inquiry knot
Really；
Step 112, when Query Result is object table and business datum table and field and multilingual fields match, by word
Section replaces with multilingual field, the structured query sentence after generation replacement.
The multilingual storage of business datum and querying method that the present invention is provided, the literary name section of business datum table are expanded to many
Language field is simultaneously stored, for example, product information table extension Chinese and English name of product field name of product _ zh,
Name of product _ en }, the sql sentences of inquiry are parsed, the object table and field of its inquiry is analyzed, business datum table is compareed, inquiry is needed
The field of multilingual processing is carried out, this field is replaced with into multilingual field, the structured query sentence after generation replacement, letter
The complexity of table design is changed, it is to avoid the Connection inquiring of sql sentences so that developer need not write the sql sentences of complexity, carry
Rise performance.Specifically, the maintenance function of multi-language data is also provided.
Fig. 1 b show that the flow of the multilingual storage of the business datum of an alternative embodiment of the invention and querying method is shown
It is intended to.Wherein, this method includes：
Step 122, need to carry out the literary name section of multilingual processing in identification service tables of data；
Step 124, literary name section is expanded into multilingual field；
Step 104, multilingual field is stored to database；
Step 106, structured query sentence is obtained；
Step 108, analytical structure query statement, extracts the object table and field of structured query sentence；
Step 110, whether inquiry object table matches with business datum table and field with multilingual field, draws inquiry knot
Really；
Step 112, when Query Result is object table and business datum table and field and multilingual fields match, by word
Section replaces with multilingual field, the structured query sentence after generation replacement.
In this embodiment, the step of literary name section of business datum table being expanded into multilingual field specifically includes：Mark
Need to carry out the specific literary name section of the business datum table of multilingual processing, such as " product information table-name of product ", by literary name section
Multilingual field is expanded to, without designing independent multilingual metadata table for business datum table, design complexities are reduced.
In one embodiment of the invention, as shown in Figure 1 b, it is preferable that this method includes：
Step 122, need to carry out the literary name section of multilingual processing in identification service tables of data；
Step 124, literary name section is expanded into multilingual field；
Step 104, multilingual field is stored to database；
Step 106, structured query sentence is obtained；
Step 108, analytical structure query statement, extracts the object table and field of structured query sentence；
Step 110, whether inquiry object table matches with business datum table and field with multilingual field, draws inquiry knot
Really；
Step 112, when Query Result is object table and business datum table and field and multilingual fields match, by word
Section replaces with multilingual field, the structured query sentence after generation replacement；
Also include simultaneously：
Step 114, the structured query sentence after replacement is sent to database and performed.
In this embodiment, the structured query sentence after replacement is sent to database and performed, changed using agent skill group
Sql sentences are write, when developer writes query function, without doing extra process.
In one embodiment of the invention, it is preferable that also include：Return to Query Result.
In this embodiment, Query Result is back at application call, without in a program to the inquiry knot of return
Aiming field in fruit does secondary inquiry and replacement.
In one embodiment of the invention, it is preferable that the structure of business datum table includes following a kind of or its combination：Table
Name, field name.
In this embodiment, the structure of business datum table includes following a kind of or its combination：Table name, field name, business number
Can be the table of relational database according to table, such as multilingual mark table, table structure should comprise at least { table name, field name }.
The embodiment of second aspect of the present invention, proposes a kind of multilingual storage of business datum and inquiry unit 200, Fig. 2 shows
The multilingual storage of business datum and the schematic block diagram of inquiry unit 200 of one embodiment of the present of invention are gone out.Wherein, the device
Including：
Processing unit 202 is identified, for the literary name section of business datum table to be expanded into multilingual field；
Memory cell 204, for multilingual field to be stored to database；
Acquiring unit 206, for obtaining structured query sentence；
Analytic unit 208, for analytical structure query statement, extracts the object table and field of structured query sentence；
Query unit 210, for inquiring about whether object table matches with business datum table and field with multilingual field, is obtained
Go out Query Result；
Replacement unit 212, for being object table and business datum table and field and multilingual field when Query Result
Timing, multilingual field, the structured query sentence after generation replacement are replaced with by field.
The multilingual storage of business datum and inquiry unit 200 that the present invention is provided, identify processing unit 202 by business datum
The literary name section of table expands to multilingual field and stored by memory cell 204, for example, product information table extension Chinese and
The name of product field { name of product _ zh, name of product _ en } of English, acquiring unit 206 obtains sql sentences, analytic unit
The sql sentences of 208 parsing inquiries, analyze the object table and field of its inquiry, the control business datum table of query unit 210, inquiry
Need to carry out the field of multilingual processing, this field is replaced with multilingual field by replacement unit 212, generation replace after structure
Change query statement, simplify the complexity of table design, it is to avoid the Connection inquiring of sql sentences so that developer need not write multiple
Miscellaneous sql sentences, lift performance.Specifically, the maintenance function of multi-language data is also provided.
In one embodiment of the invention, it is preferable that mark processing unit 202, specifically for：Identification service tables of data
The middle literary name section for needing to carry out multilingual processing；And literary name section is expanded into multilingual field.
In this embodiment, mark processing unit mark needs to carry out the specific literary name of the business datum table of multilingual processing
Section, literary name section is expanded to multilingual field by such as " product information table-name of product ", without designing only for business datum table
Vertical multilingual metadata table, reduces design complexities.
In one embodiment of the invention, as shown in Figure 2, it is preferable that also include：
Execution unit 214, is performed for the structured query sentence after replacement to be sent to database.
In this embodiment, the structured query sentence after replacement is sent to database and performed by execution unit 214, is used
Agent skill group rewrites sql sentences, when developer writes query function, without doing extra process.
In one embodiment of the invention, as shown in Figure 2, it is preferable that also include：
Returning unit 216, for returning to Query Result.
In this embodiment, Query Result is back at application call by returning unit 216, without right in a program
Aiming field in the Query Result of return does secondary inquiry and replacement.
In one embodiment of the invention, it is preferable that the structure of business datum table includes following a kind of or its combination：Table
Name, field name.
In this embodiment, the structure of business datum table includes following a kind of or its combination：Table name, field name, business number
Can be the table of relational database according to table, such as multilingual mark table, table structure should comprise at least { table name, field name }.
In a specific embodiment, the multilingual storage of business datum and querying method include：
(1) the multilingual identification information of configuration data table, i.e. definition need to carry out the specific field of the table of multilingual processing, example
Such as " product information table-name of product ", the information is storable in database；
(2) it is business datum table extension multilingual information storage field, for example, product information table extension Chinese and English
Name of product field { name of product _ zh, name of product _ en }, application system provide multi-language data maintenance function；
(3) identification list defined in operation system loading (1)；
(4) the sql sentences of operation system parsing inquiry, analyze the object table and field of its inquiry, compare multilingual mark
Table, identification needs to carry out the field of multilingual processing；
(5) field that sql is inquired about is converted into correct multilingual field, such as by select name of product from products
Information table is converted to select names of product _ zh as name of product from product information tables；
(6) Query Result is returned, Query Result is with being expected unanimously, and developer need not do especially to be multilingual to sql
Processing.
In another specific embodiment, the multilingual storage of business datum and inquiry unit include：
Multilingual mark dispensing unit, the multilingual field information for safeguarding tables of data；
Sql grammer morphology resolution units, can recognize inquiry sql, and analyze inquiry field and table；
Sql conversion units, based on the analysis result of sql grammer morphology resolution units, in multilingual mark dispensing unit dimension
Multilingual mark is matched in the configuration information of shield, if matched, the corresponding field in sql sentences is replaced.
Wherein, for the realization of sql grammer morphology resolution units, the druid increased income can be used to connect under java platforms
The sql resolvers of pond offer are provided.
In another specific embodiment, as shown in figure 3, the multilingual storage of business datum and querying method include：
Step 302, mark needs to carry out the literary name section of multilingual processing, is stored in the storage device that can be inquired about, can be with
It is the table (multilingual mark table) of relational database, table structure should comprise at least { table name, field name }；
Step 304, a sql blocker is provided in the application, section technology can be used in java platforms, or
Using the druid database connection pools increased income, the blocker can be intercepted using the sql sentences sent to database, and does language
Method morphological analysis, can recognize inquiry sql sentences, and analyze inquiry field and table；
Step 306, the field come and table will be analyzed in step 304 as querying condition, that safeguards in step 302 is more
Whether have value, if field then is replaced with into multilingual field if being inquired about in language identification table；
Step 308, the sql sentences after being changed in step 306 are sent to database, and Query Result is back to application
At routine call.
In another specific embodiment, as shown in figure 4, the multilingual storage of business datum and inquiry unit 400 include：
There is provided the maintenance functions such as the storage of multilingual mark, inquiry for the multilingual mark unit 402 of tables of data；
Sql grammer morphology analytic unit 404, is embedded in operation system, the sql sentences that interception service program is sent, point
Morphology grammer is analysed, analysis result, which is sent to sql sentences, replaces execution unit；
Sql sentences replace execution unit 406, and the field come will be analyzed in sql grammer morphology analytic unit 404 and table is made
For querying condition, inquire about whether have value in the multilingual mark table safeguarded in the multilingual mark unit 402 of tables of data, if
Field is then replaced with into multilingual field.
One aspect of the present invention, multilingual information is stored in a tables of data with main information, and that supports on demand is multilingual
Species, is preserved in the form of fields, without designing independent multilingual metadata table for business datum table, reduces design complicated
Degree；On the other hand, without using sql sentence Connection inquirings, query performance is improved；Another further aspect, developer writes sql languages
During sentence, the inquiry without paying close attention to multilingual information reduces system development complexity.
In the description of this specification, the description of term " one embodiment ", " some embodiments ", " specific embodiment " etc.
Mean that combining the embodiment or specific features, structure, material or the feature of example description is contained at least one reality of the invention
Apply in example or example.In this manual, identical embodiment or reality are not necessarily referring to the schematic representation of above-mentioned term
Example.Moreover, description specific features, structure, material or feature can in any one or more embodiments or example with
Suitable mode is combined.
The preferred embodiments of the present invention are the foregoing is only, are not intended to limit the invention, for the skill of this area
For art personnel, the present invention can have various modifications and variations.Within the spirit and principles of the invention, that is made any repaiies
Change, equivalent substitution, improvement etc., should be included in the scope of the protection.
Claims (10)
1. a kind of multilingual storage of business datum and querying method, it is characterised in that including：
The literary name section of business datum table is expanded into multilingual field；
The multilingual field is stored to database；
Obtain structured query sentence；
The structured query sentence is analyzed, the object table and field of the structured query sentence is extracted；
Inquire about whether the object table matches with the business datum table and the field with the multilingual field, draw and look into
Ask result；
When the Query Result is the object table and the business datum table and the field and the multilingual field
Timing, the multilingual field, the structured query sentence after generation replacement are replaced with by the field.
2. the multilingual storage of business datum according to claim 1 and querying method, it is characterised in that described by the industry
The step of literary name section of business tables of data expands to the multilingual field, including：
Identify needs to carry out the literary name section of multilingual processing in the business datum table；
The literary name section is expanded into the multilingual field.
3. the multilingual storage of business datum according to claim 1 and querying method, it is characterised in that also include：
Structured query sentence after the replacement is sent to the database and performed.
4. the multilingual storage of business datum according to claim 1 and querying method, it is characterised in that also include：
Return to the Query Result.
5. the multilingual storage of business datum according to any one of claim 1 to 4 and querying method, it is characterised in that
The structure of the business datum table includes following a kind of or its combination：Table name, field name.
6. a kind of multilingual storage of business datum and inquiry unit, it is characterised in that including：
Processing unit is identified, for the literary name section of business datum table to be expanded into multilingual field；
Memory cell, for the multilingual field to be stored to database；
Acquiring unit, for obtaining structured query sentence；
Analytic unit, for analyzing the structured query sentence, extracts the object table and field of the structured query sentence；
Query unit, be with the multilingual field for inquiring about the object table with the business datum table and the field
No matching, draws Query Result；
Replacement unit, for when the Query Result be the object table and the business datum table and the field with it is described
During multilingual fields match, the field is replaced with into the multilingual field, the structured query sentence after generation replacement.
7. the multilingual storage of business datum according to claim 6 and inquiry unit, it is characterised in that the mark processing
Unit, specifically for：
Identify needs to carry out the literary name section of multilingual processing in the business datum table；And expand to the literary name section described
Multilingual field.
8. the multilingual storage of business datum according to claim 6 and inquiry unit, it is characterised in that also include：
Execution unit, is performed for the structured query sentence after the replacement to be sent to the database.
9. the multilingual storage of business datum according to claim 6 and inquiry unit, it is characterised in that also include：
Returning unit, for returning to the Query Result.
10. the multilingual storage of business datum and inquiry unit according to any one of claim 6 to 9, it is characterised in that
The structure of the business datum table includes following a kind of or its combination：Table name, field name.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710493407.6A CN107291907B (en) | 2017-06-20 | 2017-06-20 | Business data multi-language storage and query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710493407.6A CN107291907B (en) | 2017-06-20 | 2017-06-20 | Business data multi-language storage and query method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107291907A true CN107291907A (en) | 2017-10-24 |
| CN107291907B CN107291907B (en) | 2020-11-20 |
Family
ID=60098463
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710493407.6A Expired - Fee Related CN107291907B (en) | 2017-06-20 | 2017-06-20 | Business data multi-language storage and query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107291907B (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108073707A (en) * | 2017-12-19 | 2018-05-25 | 银联商务股份有限公司 | Financial transaction data update method, device and computer read/write memory medium |
| CN109189799A (en) * | 2018-08-14 | 2019-01-11 | 中国平安人寿保险股份有限公司 | Business datum querying method, device, computer equipment and storage medium |
| CN109472034A (en) * | 2018-11-02 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Languages conversion method, device, equipment and storage medium based on data subregion |
| CN109828775A (en) * | 2018-12-06 | 2019-05-31 | 中国电子进出口有限公司 | A kind of WEB management system and method for multilingual translation content of text |
| CN110209695A (en) * | 2018-02-06 | 2019-09-06 | 北京京东尚科信息技术有限公司 | Method and apparatus towards multilingual data buffer storage |
| CN111414377A (en) * | 2020-03-05 | 2020-07-14 | 微民保险代理有限公司 | Method and device for processing structured query statement and storage medium |
| CN111752927A (en) * | 2020-06-30 | 2020-10-09 | 深圳前海微众银行股份有限公司 | Clone-based data form generation method, device, terminal equipment and medium |
| CN114168590A (en) * | 2021-11-08 | 2022-03-11 | 北京快乐茄信息技术有限公司 | Data processing method, data processing apparatus, server, and storage medium |
| CN116756175A (en) * | 2023-07-06 | 2023-09-15 | 上海爱湃斯科技有限公司 | Mongodb data updating method based on sql language |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040172601A1 (en) * | 2003-02-28 | 2004-09-02 | Microsoft Corporation | Language-based character set conversions per-application program |
| US20050198573A1 (en) * | 2004-02-24 | 2005-09-08 | Ncr Corporation | System and method for translating web pages into selected languages |
| CN101727624A (en) * | 2009-12-17 | 2010-06-09 | 中国电力科学研究院 | Method for showing task list and system thereof |
| CN103020196A (en) * | 2012-12-03 | 2013-04-03 | 北京奇虎科技有限公司 | System for processing database operation request |
| CN103092998A (en) * | 2013-02-21 | 2013-05-08 | 用友软件股份有限公司 | Data query system and data query method |
| CN105786843A (en) * | 2014-12-22 | 2016-07-20 | 华为软件技术有限公司 | Multi-language implementation method for applications and multi-language information query method and device |
| US20170124185A1 (en) * | 2015-10-29 | 2017-05-04 | International Business Machines Corporation | Foreign organization name matching |
-
2017
- 2017-06-20 CN CN201710493407.6A patent/CN107291907B/en not_active Expired - Fee Related
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040172601A1 (en) * | 2003-02-28 | 2004-09-02 | Microsoft Corporation | Language-based character set conversions per-application program |
| US20050198573A1 (en) * | 2004-02-24 | 2005-09-08 | Ncr Corporation | System and method for translating web pages into selected languages |
| CN101727624A (en) * | 2009-12-17 | 2010-06-09 | 中国电力科学研究院 | Method for showing task list and system thereof |
| CN103020196A (en) * | 2012-12-03 | 2013-04-03 | 北京奇虎科技有限公司 | System for processing database operation request |
| CN103092998A (en) * | 2013-02-21 | 2013-05-08 | 用友软件股份有限公司 | Data query system and data query method |
| CN105786843A (en) * | 2014-12-22 | 2016-07-20 | 华为软件技术有限公司 | Multi-language implementation method for applications and multi-language information query method and device |
| US20170124185A1 (en) * | 2015-10-29 | 2017-05-04 | International Business Machines Corporation | Foreign organization name matching |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108073707A (en) * | 2017-12-19 | 2018-05-25 | 银联商务股份有限公司 | Financial transaction data update method, device and computer read/write memory medium |
| CN110209695A (en) * | 2018-02-06 | 2019-09-06 | 北京京东尚科信息技术有限公司 | Method and apparatus towards multilingual data buffer storage |
| CN109189799A (en) * | 2018-08-14 | 2019-01-11 | 中国平安人寿保险股份有限公司 | Business datum querying method, device, computer equipment and storage medium |
| CN109189799B (en) * | 2018-08-14 | 2024-04-26 | 中国平安人寿保险股份有限公司 | Service data query method, device, computer equipment and storage medium |
| CN109472034B (en) * | 2018-11-02 | 2022-04-15 | 深圳壹账通智能科技有限公司 | Language conversion method, device, equipment and storage medium based on data partition |
| CN109472034A (en) * | 2018-11-02 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Languages conversion method, device, equipment and storage medium based on data subregion |
| CN109828775A (en) * | 2018-12-06 | 2019-05-31 | 中国电子进出口有限公司 | A kind of WEB management system and method for multilingual translation content of text |
| CN109828775B (en) * | 2018-12-06 | 2021-12-07 | 中国电子进出口有限公司 | WEB management system and method for multilingual translation text content |
| CN111414377B (en) * | 2020-03-05 | 2023-10-24 | 微民保险代理有限公司 | Method, device and storage medium for processing structured query statement |
| CN111414377A (en) * | 2020-03-05 | 2020-07-14 | 微民保险代理有限公司 | Method and device for processing structured query statement and storage medium |
| CN111752927A (en) * | 2020-06-30 | 2020-10-09 | 深圳前海微众银行股份有限公司 | Clone-based data form generation method, device, terminal equipment and medium |
| CN111752927B (en) * | 2020-06-30 | 2024-05-17 | 深圳前海微众银行股份有限公司 | Clone-based data form generation method, device, terminal equipment and medium |
| CN114168590A (en) * | 2021-11-08 | 2022-03-11 | 北京快乐茄信息技术有限公司 | Data processing method, data processing apparatus, server, and storage medium |
| CN116756175A (en) * | 2023-07-06 | 2023-09-15 | 上海爱湃斯科技有限公司 | Mongodb data updating method based on sql language |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107291907B (en) | 2020-11-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107291907A (en) | A kind of multilingual storage of business datum and querying method and device | |
| US8489388B2 (en) | Data detection | |
| US7110939B2 (en) | Process of automatically generating translation-example dictionary, program product, computer-readable recording medium and apparatus for performing thereof | |
| US9256798B2 (en) | Document alteration based on native text analysis and OCR | |
| US20030041058A1 (en) | Queries-and-responses processing method, queries-and-responses processing program, queries-and-responses processing program recording medium, and queries-and-responses processing apparatus | |
| US20230087421A1 (en) | Systems and methods for generalized structured data discovery utilizing contextual metadata disambiguation via machine learning techniques | |
| US7231600B2 (en) | File translation | |
| US20120136647A1 (en) | Machine translation apparatus and non-transitory computer readable medium | |
| CN111259652A (en) | Bilingual corpus sentence alignment method and device, readable storage medium and computer equipment | |
| CN112380848B (en) | Text generation method, device, equipment and storage medium | |
| GB2487600A (en) | System for extracting data from an electronic document | |
| CN113297251A (en) | Multi-source data retrieval method, device, equipment and storage medium | |
| CN103678288A (en) | Automatic proper noun translation method | |
| US8290950B2 (en) | Identifying locale-specific data based on a total ordering of supported locales | |
| CN110941957A (en) | Traffic science and technology data indexing method and system | |
| CN113052544A (en) | Method and device for intelligently adapting workflow according to user behavior and storage medium | |
| CN111291074B (en) | Database query method, system, medium and device | |
| US20070282804A1 (en) | Apparatus and method for extracting database information from a report | |
| CN111046636A (en) | Method and device for screening PDF file information, computer equipment and storage medium | |
| CN109344393B (en) | Method and system for extracting main statement | |
| US7945529B2 (en) | Apparatus and method for performing table comparisons | |
| US8438007B1 (en) | Software user interface human language translation | |
| US20070038617A1 (en) | Cultural property independent programming | |
| US20050216495A1 (en) | Conversion method for multi-language multi-code databases | |
| CN112818005A (en) | Structured data searching 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20201120 |