Abstract: 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.

Abstract: 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.

Abstract: 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.

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.

Abstract: Methods, systems, and computer products for identifying improper online game usage are provided. Aspects include receiving, by a processor, online gaming data associated with an online gaming environment, the online gaming environment having a plurality of users, analyzing the online gaming data to identify a user from the plurality of users improperly interacting with the online gaming environment, accessing a user profile for the user responsive to identifying the user, determining a rating for the improper interaction of the user based on the online gaming data and the user profile, comparing the rating for the improper interaction of the user to one or more threshold ratings, and enacting a penalty for the user based at least in part the rating of the improper interaction exceeding at least one of the one or more threshold ratings.

Abstract: Examples of techniques for rating and notifying volunteer responders are disclosed. Aspects include receiving a notification of a medical emergency at a first location and obtaining a plurality of candidate volunteer responders from a volunteer responder database. Aspects also include ranking the plurality of candidate volunteer responders based on a location of each of the plurality of candidate volunteer responders, a type of the medical emergency, and a characteristic of each of the plurality of candidate volunteer responders. Aspects further include notifying a highest ranked candidate volunteer from the plurality of candidate volunteer responders of the medical emergency, wherein the notification includes the type of the medical emergency and the first location.

Abstract: 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.

Abstract: A method, computer system, and a computer program product for generating an instructional variant is provided. The present invention may include identifying an instructional guide. The present invention may also include analyzing a user comments feed associated with the identified instructional guide. The present invention may further include, in response to determining that the analyzed user comments feed includes a modification to the identified instructional guide, generating a variant instructional guide including the modification to the identified instructional guide.

Abstract: A computer-implemented method includes receiving, via original Data Definition Language (DDL) syntax of a Database Management System (DBMS), a definition of custom DDL syntax. Metadata describing the custom DDL syntax is stored in a global catalog of the DBMS. A first DDL statement that utilizes the custom DDL syntax is received. The metadata describing the custom DDL syntax is read from the global catalog. The first DDL statement is processed, using a computer processor, according to the metadata.

Abstract: A computer-implemented method includes receiving, via original Data Definition Language (DDL) syntax of a Database Management System (DBMS), a definition of custom DDL syntax. Metadata describing the custom DDL syntax is stored in a global catalog of the DBMS. A first DDL statement that utilizes the custom DDL syntax is received. The metadata describing the custom DDL syntax is read from the global catalog. The first DDL statement is processed, using a computer processor, according to the metadata.

Abstract: 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.

Abstract: 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.

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.

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.

Abstract: A computer determines that the type of one or more of a relational operator and operands of a relational expression originated in a first type system, and determines the sign of at least one of the operands. The computer rewrites the relational expression based on the sign of at least one of the operands, sends the rewritten relational expression for evaluation in a second type system, and receives the evaluated rewritten relational expression after evaluation in the second type system. The computer can rewrite the relational expression by generating a group of terms joined disjunctively, as well as by generating a group of conjunctive terms joined disjunctively.

Abstract: 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.

Abstract: A computer determines that the type of one or more of a relational operator and operands of a relational expression originated in a first type system, and determines the sign of at least one of the operands. The computer rewrites the relational expression based on the sign of at least one of the operands, sends the rewritten relational expression for evaluation in a second type system, and receives the evaluated rewritten relational expression after evaluation in the second type system. The computer can rewrite the relational expression by generating a group of terms joined disjunctively, as well as by generating a group of conjunctive terms joined disjunctively.

Abstract: 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.

Abstract: A computer determines that the type of one or more of a relational operator and operands of a relational expression originated in a first type system, and determines the sign of at least one of the operands. The computer rewrites the relational expression based on the sign of at least one of the operands, sends the rewritten relational expression for evaluation in a second type system, and receives the evaluated rewritten relational expression after evaluation in the second type system. The computer can rewrite the relational expression by generating a group of terms joined disjunctively, as well as by generating a group of conjunctive terms joined disjunctively.

Abstract: 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.