International Business Machines Corporation

Kyle Jeffrey Charlet

Christopher M Holtz

Kevin D Hite

Richard V Tran

Nathan Daniel Church

Douglas Michael Frederick Hembry

Carol M Wiedenmann

Robert Daniel Love

Kiran Challapalli

Shyh-Mei Fang Ho

Kevin Michael McBride

Jack Chiu-Chiu Yuan

Steve T Kuo

William Li

Gerald Dean Hughes

Judith Eleanor Hill

Haley Hoi Lee Fung

Thomas Beavers Sander

Mark Alan Bach

Wai-Yee Doris Ling

Moncrief Rowe-Anderson

Douglas M F Hembrey

Douglas M F Hembry

Thomas Arthur Vogel

Huey Moncrief Rowe-Anderson

Greg S Kim

Embodiments include methods, systems and computer program products method for editing and correcting structural metadata associated a binary large object (BLOB). The computer-implemented method includes obtaining, using a processor, at least a portion of structural metadata associated with the BLOB. The processor converts one or more fields associated with the at least a portion of structural metadata and determines that the one or more fields generated one or more errors or null values. The processor provides an interface, wherein the interface is used to cause a first movement or edit the one or more fields. The processor determines that the first movement or edit of the one or more fields fixes the one or more errors or null values and provides an indication that the first movement or edit of the one or more fields has or has not fixed the one or more errors or null values.

Binary large object platform for interactively analyzing and editing structural metadata

Provided are techniques for interpreting invalid data that is a portion of a data set as valid data. A request is received to convert data from a first format to a second format for an application, wherein the data is a portion of a data set. It is determined that the data is invalid, wherein the invalid data cannot be processed by the application in the first format. It is determined whether the invalid data is to be interpreted as valid based on a flag. In response to determining that the invalid data is to be interpreted as valid, setting the invalid data to a new value in the second format that can be processed by the application.

Interpreting invalid data as valid data

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.

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

The capturing of rich database metadata includes: capturing partitioned column metadata of a database as mappings defined by a plurality of constraint statements; defining non-standard user-defined types of the database according to a schema; defining physical representations of columns of the database according to the schema; and storing the defined mappings, the defined user-defined types, and the defined physical representations of columns to a catalog of the database. Application enumerated data values in the database may also be defined according to the XML schema and stored to the catalog of the database. In this manner, the database management system may manage application constraints, user-defined types, and physical representations of data for applications referencing the same database using the metadata information stored in the catalog of the database.

Rich database metadata model that captures application relationships, mappings, constraints, and complex data structures

Provided are techniques for processing structured content within Large Object (LOB) data that is stored in a column of a database table. Structural metadata describing structures that each define a different format of the structured content is stored. A request for data in the database table is received. The structural metadata is used to create an empty result set with columns defined by at least two of the structures. For each row of data in the database table that includes LOB data, control data is used to identify one of the structures to be applied to the structured content within the LOB data stored in that row of data, and the structured content within the LOB data in that row of data is mapped to the columns in the result set based on the identified one of the structures. The result set is returned.

Structured large object (LOB) data

The present invention relates generally to data retrieval, and more particularly but not exclusively to obtaining referentially converted user data having user-defined data types. In one implementation, the present invention is a method for retrieving user data in a data system using one or more application programs for defining a layout for each user data type, defining one or more conversion routines for non-standard data types, calling a coordination call to map standard and non-standard data types, and retrieve the user data from the data storage device.

Method and system for obtaining user data having user-defined data types

The apparatus and system are provided for defining a metadata schema to facilitate passing data between an XML document and a hierarchical database. The invention includes a database accessor, a document accessor, and an association module. The database accessor accesses a database schema indicative of database field names and a hierarchical structure for a hierarchical database. The document accessor accesses a document schema that defines the hierarchical structure, content data syntax, and semantics of valid, well-formed, XML documents that can be passed into and out of the hierarchical database. The document schema also includes at least one XML element name that maps to a corresponding database field name in the database schema. The association module associates the database schema and the document schema to provide a metadata schema that enables data to be passed between an XML document and the hierarchical database.

Apparatus and system for defining a metadata schema to facilitate passing data between an extensible markup language document and a hierarchical database

An apparatus, system, and method are provided for defining a metadata schema to facilitate passing data between an XML document and a hierarchical database. The invention includes a database accessor, a document accessor, and an association module. The database accessor accesses a database schema indicative of database field names and a hierarchical structure for a hierarchical database. The document accessor accesses a document schema that defines the hierarchical structure, content data syntax, and semantics of valid, well-formed, XML documents that can be passed into and out of the hierarchical database. The document schema also includes at least one XML element name that maps to a corresponding database field name in the database schema. The association module associates the database schema and the document schema to provide a metadata schema that enables data to be passed between an XML document and the hierarchical database.

Apparatus, system, and method for defining a metadata schema to facilitate passing data between an extensible markup language document and a hierarchical database

A method is provided for defining a metadata schema to facilitate passing data between an XML document and a hierarchical database. The invention includes a database accessor, a document accessor, and an association module. The database accessor accesses a database schema indicative of database field names and a hierarchical structure for a hierarchical database. The document accessor accesses a document schema that defines the hierarchical structure, content data syntax, and semantics of valid, well-formed, XML documents that can be passed into and out of the hierarchical database. The document schema also includes at least one XML element name that maps to a corresponding database field name in the database schema. The association module associates the database schema and the document schema to provide a metadata schema that enables data to be passed between an XML document and the hierarchical database.

Method for defining a metadata schema to facilitate passing data between an extensible markup language document and a hierarchical database

An apparatus, system, and method are provided for passing data between an XML document and a hierarchical database. The apparatus, system, and method include a hierarchical database, a metadata schema, and a mapping module. The hierarchical database comprises a conventional hierarchical database, such as IMS. The metadata schema is derived from the hierarchical database. The metadata schema includes a first representation representative of the hierarchical structure of the hierarchical database, a second representation representative of the hierarchical structure of XML documents valid for passing into and out of the hierarchical database, one or more database field names, and one or more XML element names that map to the one or more database field names. The mapping module passes data between the XML document and the hierarchical database using the metadata schema.

Apparatus, system, and method for passing data between an extensible markup language document and a hierarchical database

A system for identifying and utilizing a secondary index to access a database using a management system without an internal catalogue of online metadata. The system receives an application request to access a database from the application program, and parses the application request to determine at least one column name and at least one table name. The system utilizes an online catalogue containing metadata to translate the column name to a field name and the table name to a segment name, wherein the segment name has an associated secondary index. The system utilizes the online catalogue to determine an associated secondary index name, and builds a database request that includes the segment name, the field name, and the associated secondary index name. The system then sends the database request to the database management system, so that the associated secondary index can be used by the database management system in response to the database request.

System and method for identifying and utilizing a secondary index to access a database using a management system without an internal catalogue of online metadata

A database definition, logical database view, extended field definition and control statement information are accessed to build an in-memory representation of selective information contained therein. Utilizing this in-memory representation, a hierarchical database schema report is automatically generated wherein this hierarchical database schema report may be used to write application code to access the hierarchical database without further need to utilize the database definition, the extended field definition, the logical database view or any combination thereof.

Method, computer program product, and system for automatically generating a hierarchial database schema report to facilitate writing application code for accessing hierarchial databases

A method, computer program product, and system for making standard stream data accessible that would otherwise be lost in applications programs. Information placed on a standard stream, such as System.err or System.out in the Java development environment, can be lost during normal operation of the program (e.g., when not started from a system console or within an Integrated Development Environment (IDE)). A new stream is created and the standard stream is redirected to the new stream. Once data placed on the standard stream is available on the new stream it can be manipulated as desired and made available through a console or by placing the information into a file.

Growing community of inventors

Morgan Hill, CA, United States of America

Kyle Jeffrey Charlet