Abstract: A computer-implemented method includes: receiving, by a computing device, a database-level auto_purge value for a database having a plurality of tables, wherein the database-level auto_purge value represents a value associated with the entire database for when data is set to be purged or deleted from the plurality of tables in the database; setting, by the computing device, the database-level auto_purge value for the database; setting, by the computing device, table-level auto_purge values for the plurality of tables included in the database based on the database-level auto_purge value; and automatically purging data in the plurality of tables based on the table-level auto_purge values.

Abstract: Embodiments describe an approach to monitoring user health data. Determining if the user is having an emergency based on the user health data. Responsive to determining the user is having an emergency the user's location. Identifying one or more available parking spaces based on the user's location, and outputting locations of one or more available parking spaces to the user.

Abstract: An approach for an automatic table cleanup process of use, implemented in relational databases, are provided. A method includes setting up a table cleanup process in a database which is operable to perform an automatic table cleanup on a table within the database using an auto purge value associated with the table. The method further includes altering the table with a virtual column to keep track of dates on the table. The method further includes turning on an automatic table maintenance capability of the database to include and initiate the table cleanup process. The method further includes running the table cleanup process to perform the automatic table cleanup using dates which are automatically filled in during an insert or update operation on the table, the table cleanup process comprising looking through the records and automatically purging the table when the auto purge value has been met.

Abstract: A computer-implemented method includes: receiving, by a computing device, a database-level auto_purge value for a database having a plurality of tables, wherein the database-level auto_purge value represents a value associated with the entire database for when data is set to be purged or deleted from the plurality of tables in the database; setting, by the computing device, the database-level auto_purge value for the database; setting, by the computing device, table-level auto_purge values for the plurality of tables included in the database based on the database-level auto_purge value; and automatically purging data in the plurality of tables based on the table-level auto_purge values.

Abstract: Embodiments describe an approach to monitoring user health data. Determining if the user is having an emergency based on the user health data. Responsive to determining the user is having an emergency the user's location. Identifying one or more available parking spaces based on the user's location, and outputting locations of one or more available parking spaces to the user.

Abstract: An approach for an automatic table cleanup process of use, implemented in relational databases, are provided. A method includes setting up a table cleanup process in a database which is operable to perform an automatic table cleanup on a table within the database using an auto purge value associated with the table. The method further includes altering the table with a virtual column to keep track of dates on the table. The method further includes turning on an automatic table maintenance capability of the database to include and initiate the table cleanup process. The method further includes running the table cleanup process to perform the automatic table cleanup using dates which are automatically filled in during an insert or update operation on the table, the table cleanup process comprising looking through the records and automatically purging the table when the auto purge value has been met.

Abstract: A computer-implemented method includes: receiving, by a computing device, a database-level auto_purge value for a database having a plurality of tables, wherein the database-level auto_purge value represents a value associated with the entire database for when data is set to be purged or deleted from the plurality of tables in the database; setting, by the computing device, the database-level auto_purge value for the database; setting, by the computing device, table-level auto_purge values for the plurality of tables included in the database based on the database-level auto_purge value; and automatically purging data in the plurality of tables based on the table-level auto_purge values.

Abstract: An approach for an automatic table cleanup process of use, implemented in relational databases, are provided. A method includes setting up a table cleanup process in a database which is operable to perform an automatic table cleanup on a table within the database using an auto purge value associated with the table. The method further includes altering the table with a virtual column to keep track of dates on the table. The method further includes turning on an automatic table maintenance capability of the database to include and initiate the table cleanup process. The method further includes running the table cleanup process to perform the automatic table cleanup using dates which are automatically filled in during an insert or update operation on the table, the table cleanup process comprising looking through the records and automatically purging the table when the auto purge value has been met.

Abstract: An approach for an automatic table cleanup process of use, implemented in relational databases, are provided. A method includes setting up a table cleanup process in a database which is operable to perform an automatic table cleanup on a table within the database using an auto purge value associated with the table. The method further includes altering the table with a virtual column to keep track of dates on the table. The method further includes turning on an automatic table maintenance capability of the database to include and initiate the table cleanup process. The method further includes running the table cleanup process to perform the automatic table cleanup using dates which are automatically filled in during an insert or update operation on the table, the table cleanup process comprising looking through the records and automatically purging the table when the auto purge value has been met.

Abstract: An approach for an automatic table cleanup process of use, implemented in relational databases, are provided. A method includes setting up a table cleanup process in a database which is operable to perform an automatic table cleanup on a table within the database using an auto purge value associated with the table. The method further includes altering the table with a virtual column to keep track of dates on the table. The method further includes turning on an automatic table maintenance capability of the database to include and initiate the table cleanup process. The method further includes running the table cleanup process to perform the automatic table cleanup using dates which are automatically filled in during an insert or update operation on the table, the table cleanup process comprising looking through the records and automatically purging the table when the auto purge value has been met.

Abstract: A method, system, and computer program product for efficiently comparing multiple columns of a row of a relational database to an incoming record. A computer creates a cryptographic sum for columns of a row of the relational database. The cryptographic sum is stored as a hidden column in the relational database. Logic may compare the cryptographic sum with an incoming cryptographic sum of entries in an incoming record. Logic may then determine if the incoming cryptographic sums differ from the corresponding cryptographic sums of rows of data of the relational database. When the two cryptographic sums are identical, the data of the incoming record is disregarded as an identical record that already exists. An entry of the incoming record may be added to the target table or updated within an existing record of the relational database when the cryptographic sum and the incoming cryptographic sum of that entry differ.

Abstract: An approach for an automatic table cleanup process of use, implemented in relational databases, are provided. A method includes setting up a table cleanup process in a database which is operable to perform an automatic table cleanup on a table within the database using an auto purge value associated with the table. The method further includes altering the table with a virtual column to keep track of dates on the table. The method further includes turning on an automatic table maintenance capability of the database to include and initiate the table cleanup process. The method further includes running the table cleanup process to perform the automatic table cleanup using dates which are automatically filled in during an insert or update operation on the table, the table cleanup process comprising looking through the records and automatically purging the table when the auto purge value has been met.

Abstract: A method, system, and computer program product for efficiently comparing multiple columns of a row of a relational database to an incoming record. A computer creates a cryptographic sum for columns of a row of the relational database. The cryptographic sum is stored as a hidden column in the relational database. Logic may compare the cryptographic sum with an incoming cryptographic sum of entries in an incoming record. Logic may then determine if the incoming cryptographic sums differ from the corresponding cryptographic sums of rows of data of the relational database. When the two cryptographic sums are identical, the data of the incoming record is disregarded as an identical record that already exists. An entry of the incoming record may be added to the target table or updated within an existing record of the relational database when the cryptographic sum and the incoming cryptographic sum of that entry differ.

Abstract: A system, method and program product for automatically partitioning tables in a database system. A partitioning system is provided that includes: a system for analyzing a plurality of partition settings that predefines partitioning operations that need to occur in the future; and an automatic partition roll-in system that automatically causes tables to be partitioned based on the partition settings.