Managing data conversion for user-defined data types within a database management system

Patent metadata

Field	Value
Publication number	US-10650019-B2
Application number	US-201414199581-A
Country	US
Kind code	B2
Filing date	Mar 6, 2014
Priority date	Mar 6, 2014
Publication date	May 12, 2020
Grant date	May 12, 2020

Abstract

Managing data conversion for user-defined data types within a DBMS. A custom data type definition and one or more converters are stored within a database management system. Each converter can convert instances of the custom data type between a binary format and a programming language format. The database management system receives a request for a custom data type instance in a specified programming language format. A converter among the one or more converters converts the custom data type instance expressed in the binary format into a custom data type instance expressed in the specified programming language format, using a custom data type definition from the database management system. The request is responded to with the converted custom data type instance in the specified programming language format.

First claim

The invention claimed is:

1. A computer program product for managing data conversion for a custom data type in a database system, the computer program product comprising a computer readable storage medium having program code embodied therewith, the program code executable by a processor, to:
store a custom data type definition and one or more converters within a database management system, each converter being configured to convert instances of the custom data type between a binary format and a specific programming language format;
receive, by the database management system, a request from an application for a custom data type instance in a specified programming language format;
respond to the request with:
the custom data type definition,
a converter configured to convert instances of the custom data type between the binary format and the requested programming language format, and
the requested custom data type instance expressed in the binary format; and

convert, by the application, the custom data type instance expressed in the binary format into a custom data type instance expressed in the specified programming language format using a read method of the converter and the custom data type definition.

2. The computer program product of claim 1 , wherein the custom data type definition is a user defined data type definition.

3. The computer program product of claim 2 , wherein the user defined type is a compound user type made up from built-in database types.

4. The computer program product of claim 1 , further comprising:
providing a programming language interface for each of the one or more converters to allow calls to the instances of the custom data type.

5. The computer program product of claim 1 , wherein the custom data type definition and the one or more converters are stored in a catalog of the database management system.

6. The computer program product of claim 5 , further comprising program code executable by the processor to:
determine whether the database management system contains any custom data type definitions by querying the catalog's metadata.

7. The computer program product of claim 1 , further comprising program code executable by the processor to:
store a version for the custom data type definition.

8. A system for managing data conversion for a custom data type in a database system, comprising:
a processor; and
a memory storing instructions that when executed by the processor causes the processor to:
store a custom data type definition and one or more converters within a database management system, each converter being configured to convert instances of the custom data type between a binary format and a specific programming language format;
receive, by the database management system, a request from an application for a custom data type instance in a specified programming language format;
respond to the request with:
the custom data type definition,
a converter configured to convert instances of the custom data type between the binary format and the requested programming language format, and
the requested custom data type instance expressed in the binary format; and

convert, by the application, the custom data type instance expressed in the binary format into a custom data type instance expressed in the specified programming language format using a read method of the converter and the custom data type definition.

9. The system of claim 8 , wherein the custom data type definition is a user defined data type definition.

10. The system of claim 9 , wherein the user defined type is a compound user type made up from built-in database types.

11. The system of claim 8 , wherein the memory further stores instructions that when executed by the processor causes the processor to:
provide a programming language interface for each of the one or more converters to allow calls to the instances of the custom data type.

12. The system of claim 8 , wherein the custom data type definition and the one or more converters are stored in a catalog of the database management system.

13. The system of claim 12 , wherein the memory further stores instructions that when executed by the processor causes the processor to:
determine whether the database management system contains any custom data type definitions by querying the catalog's metadata.

Assignees

• IBM

Inventors

• Charlet Kyle J
• Church Nathan D
• Hite Kevin D
• Tran Richard V

Classifications

• G06F16/245

  Query processing · CPC title

• G06F16/258 Primary

  Data format conversion from or to a database · CPC title