Unified Database Instance for Dynamic Multi-Language Data Storage

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing solutions for National Language Support (NLS) in databases are limited to static data and require multiple database instances for each locale, leading to increased costs and inconsistencies when handling dynamic textual data in multiple languages.

Innovation Solution

A method and system that enables the storage and retrieval of dynamic textual data in multiple languages within a single database instance by capturing data in one language and translating it into multiple languages, using generalized database tables for NLS Locales and NLS Text Groups, allowing for concurrent multi-language support.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If multiple database instances are used for each locale, then multi-language support is achieved, but system complexity and cost increase

Engineering Contradiction:

Improvemulti-language supportVSAvoidnumber of database instances

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent merges multiple locale-specific database instances into a single unified database instance that stores dynamic data with locale identifiers. Instead of having separate database instances for each locale, the invention combines them by adding locale metadata to data records, allowing a single database to serve multiple locales simultaneously.

Inventive Principle:

Principle #5Merging (Combining)

Solution Approach 2:

The unified database instance is designed to be universal by storing locale identifiers alongside dynamic data. This allows the same database structure to serve multiple locales and languages without requiring locale-specific instances, making the database system multi-functional and adaptable to different regional requirements.

Inventive Principle:

Principle #6Universality (Multi-functionality)

2Adaptability or versatility

If multiple database instances are deployed for each locale, then language-specific data storage is enabled, but maintenance cost and operational complexity increase

Engineering Contradiction:

Improvelocale-specific data storageVSAvoiddeployment and maintenance cost

Core Design Contradiction:

Adaptability or versatilityVSEase of manufacture

Solution Approach 1:

The invention combines the functionality of multiple locale-specific database instances into a single unified instance. By storing locale identifiers with data records, it eliminates the need for separate deployment, operation, and maintenance of multiple instances, thereby reducing costs while preserving locale-specific data storage capabilities.

Inventive Principle:

Principle #5Merging (Combining)

3Adaptability or versatility

If localization strategy is used with multiple database instances, then each locale is supported independently, but data consistency across instances becomes difficult to maintain

Engineering Contradiction:

Improveindependent locale supportVSAvoiddata consistency

Core Design Contradiction:

Adaptability or versatilityVSReliability

Solution Approach 1:

The patent merges multiple independent locale database instances into a single unified database instance. This consolidation ensures that all locale data resides in the same database environment, eliminating synchronization issues and ensuring data consistency across all locales while maintaining the ability to query and process data by locale identifier.

Inventive Principle:

Principle #5Merging (Combining)

4Ease of manufacture

If static data structures are used for NLS, then implementation is simpler, but dynamic data in multiple languages cannot be stored

Engineering Contradiction:

Improveimplementation simplicityVSAvoiddynamic multi-language data storage

Core Design Contradiction:

Ease of manufactureVSAdaptability or versatility

Solution Approach 1:

The invention introduces dynamic capabilities to the database structure by adding locale identifiers and language code fields to data records. This allows the database to dynamically store and retrieve the same data in multiple languages based on the user's locale, transforming a static single-language storage system into a dynamic multi-language system.

Inventive Principle:

Principle #15Dynamics

Data Source

PatentUS7711548B2Method and structures to enable national language support for dynamic data

Publication Date: 2010.05.04 X CORP

AI summary

Disclosed are a method and system for enabling multi-language support for data. A piece of data is captured and translated into a plurality of languages. The original data and all of the translations are stored in the same database instance, for retrieval and presentation in any of a group of languages. The preferred embodiment of the invention provides a design and implementation of generalized database tables to implement the features of NLS Locales and NLS Text Groups, in order to enable the storage and retrieval of dynamic, textual data in multiple languages, concurrently, in a single database instance. The invention enables the scenario wherein a piece of data captured in one language is dynamically translated into all supported languages, and all translations are stored in the same database instance, for retrieval and presentation in any of the supported languages.