Method and apparatus for storing and retrieving data in multiple languages simultaneously using a fully-populated sub-table
First Claim
1. A computer implemented method for storing and retrieving data values in a database management system (DBMS), said method comprising the steps of:
- generating a Base Table, said Base Table including at least one base row having a primary key, said base row exclusive of translatable data values;
generating a fully-populated Sub-Table, said Sub-Table includes a set of fully-populated sub-table rows corresponding to said base row, each said fully-populated row includes at least one translatable data field, said Sub-Table further includes a set of language values, wherein each set of sub-table rows in said Sub-Table corresponds to a separate language value of said set of language valuesselecting a language value from said set of language values as a default language;
inserting a second base row in said Base Table; and
in response to inserting said second base row in said Base Table, generating a second set of sub-table rows in said Sub-Table, each row of said second set corresponding to a separate language value of said set of language values, wherein at least one of said rows in said second set is generated by copying a translatable data value of said default language.
2 Assignments
0 Petitions
Accused Products
Abstract
The present invention provides a computer implemented method and apparatus for storing and retrieving data in a database management system (DBMS) in multiple languages, simultaneously, using a fully-populated Sub-Table. In one embodiment, the method and apparatus include generating a Base Table and a Translation Sub-Table. The Base Table includes base rows, each having a primary key and zero or more untranslatable values, exclusive of translatable data values. The Translation Sub-Table includes sets of sub-table rows, wherein each set of sub-table rows corresponds to a base row in the Base Table. In each set of sub-table rows, a sub-table row is provided for each operational language having at least one translatable data value corresponding to the primary key of the respective base row.
-
Citations
39 Claims
-
1. A computer implemented method for storing and retrieving data values in a database management system (DBMS), said method comprising the steps of:
-
generating a Base Table, said Base Table including at least one base row having a primary key, said base row exclusive of translatable data values; generating a fully-populated Sub-Table, said Sub-Table includes a set of fully-populated sub-table rows corresponding to said base row, each said fully-populated row includes at least one translatable data field, said Sub-Table further includes a set of language values, wherein each set of sub-table rows in said Sub-Table corresponds to a separate language value of said set of language values selecting a language value from said set of language values as a default language; inserting a second base row in said Base Table; and in response to inserting said second base row in said Base Table, generating a second set of sub-table rows in said Sub-Table, each row of said second set corresponding to a separate language value of said set of language values, wherein at least one of said rows in said second set is generated by copying a translatable data value of said default language. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A machine-readable medium having stored thereon data representing sequences of instructions for storing and retrieving data values in a database management system (DBMS), said sequences of instruction which, when executed by a processor, cause said processor to perform the steps of:
-
generating a Base Table, said Base Table including at least one base row having a primary key, said base row exclusive of translatable data values; generating a fully-populated Sub-Table, said Sub-Table includes a set of fully-populated sub-table rows corresponding to said base row, each said fully-populated row includes at least one translatable data field, said Sub-Table further includes a set of language values, wherein each set of sub-table rows in said SubTable corresponds to a separate language value of said set of language values; selecting a language value from said set of language values as a default language; inserting a second base row in said Base Table; in response to inserting said second base row in said Base Table, generating a second set of sub-table rows in said Sub-Table, each row of said second set corresponding to a separate language value of said set of language values, wherein at least one of said rows in said second set is generated by copying a translatable data value of said default language. - View Dependent Claims (14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24)
-
-
25. A computer system comprising:
-
a processor; a computer readable medium coupled to said processor, said computer readable medium readable medium having stored thereon data representing sequences of instructions for storing and retrieving data values in a database management system (DBMS), said sequences of instruction which, when executed by said processor, cause said processor to perform the steps of; generating a Base Table, said Base Table including at least one base row having a primary key, said base row exclusive of translatable data values; generating a fully-populated Sub-Table, said Sub-Table includes a set of fully-populated sub-table rows corresponding to said base row, each said fully-populated row includes at least one translatable data field, said Sub-Table further includes a set of language values, wherein each set of sub-table rows in said SubTable corresponds to a separate language value of said set of language values; selecting a language value from said set of language values as a default language; inserting a second base row in said Base Table; and in response to inserting said second base row in said Base Table, generating a second set of sub-table rows in said Sub-Table, each row of said second set corresponding to a separate language value of said set of language values, wherein at least one of said rows in said second set is generated by copying a translatable data value of said default language. - View Dependent Claims (26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36)
-
-
37. In a database management system (DBMS) having a Base Table and a Sub-Table, a method for retrieving a translatable data value the method comprising the steps of:
-
accessing the Base Table to obtain a non-translatable value, wherein the Base Table includes at least one base row having a non-translatable primary key and said base row is exclusive of translatable data values; using the non-translatable value to retrieve a translatable data value from the Sub-Table, wherein the Sub-Table includes a set of fully-populated sub-table rows corresponding to the base row, each said fully-populated rows includes at least one translatable data field, said Sub-Table further includes a set of language values, wherein each sub-table row of said set of sub-table rows corresponds to a separate language value of said set of language values. - View Dependent Claims (38, 39)
-
Specification