Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Business data multi-language storage and query method and device

A business data and query method technology, applied in the field of business data multilingual storage and query methods and devices, can solve problems such as performance limitations, high design costs, and increased sql development complexity, so as to improve performance, simplify complexity, Avoid the effects of join queries

Active Publication Date: 2017-10-24
ZICT TECH CO LTD
View PDF7 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This method is expensive to design, increases the complexity of sql development, and with the expansion of data scale, performance is limited

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Business data multi-language storage and query method and device
  • Business data multi-language storage and query method and device
  • Business data multi-language storage and query method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] In order to understand the above-mentioned purpose, features and advantages of the present invention more clearly, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. It should be noted that, in the case of no conflict, the embodiments of the present application and the features in the embodiments can be combined with each other.

[0037] In the following description, many specific details are set forth in order to fully understand the present invention, but the present invention can also be implemented in other ways different from those described here, therefore, the protection scope of the present invention is not limited to the specific details disclosed below. EXAMPLE LIMITATIONS.

[0038] The embodiment of the first aspect of the present invention proposes a multilingual storage and query method for business data, Figure 1a It shows a schematic flowchart of a method for multilingua...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a business data multi-language storage and query method and device. The business data multi-language storage and query method comprises expanding the fields of a business data table into multi-language fields; storing the multi-language fields into a database; acquiring a structured query language; analyzing the structured query language, and extracting a target table and target fields of the structured query language; querying whether the target table and the target fields are matched with the business data table and the multi-language fields respectively to obtain a query result; if so, substituting the fields with the multi-language fields to generate a replaced structured query language. The business data multi-language storage and query method simplifies the complexity of table design and avoids join queries of the sql (structured query language), so that developers do not need to compile complex sqls and the use performance can be improved.

Description

technical field [0001] The present invention relates to the technical field of business data, in particular to a method and device for multilingual storage and query of business data. Background technique [0002] Most large enterprises need to support global business, and organize personnel all over the world. The enterprise application software that supports their operations must consider the realization of multilingual capabilities. Multilingual application software is divided into multilingual for interactive interfaces and business data based on the nature of data. multi-language. [0003] Business data is mainly stored in relational databases, such as oracle, mysql, etc. The existing data multilingual implementation method is to design an independent multilingual metadata table for each data table with multilingual requirements, and the data is related through foreign keys. For example, if the product name of the product information table needs to be multilingual, its...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/2433G06F16/284
Inventor 邹凌云肖飞秋邵波李萌
Owner ZICT TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com