Abstract: Embodiments include overflow sensor assemblies for water heaters, HVAC systems, and other devices for which temperature control systems may be used. An example overflow sensor assembly for detecting fluid leaks at a device may include a sensor probe configured to be in electrical communication with a power supply, and a sensor mounting bracket that forms a ground, where the sensor mounting bracket is configured to be adjustably coupled to a mounting surface on the device, such that the sensor mounting bracket can deflect about the mounting surface. The sensor probe is suspended from the sensor mounting bracket.

Abstract: A computer-implemented method for managing access to data stored in a database is provided. The method includes storing in the database a switch parameter having a first value, storing in the database at least two instances of a data object wherein each of the instances includes a unique identifier, receiving a client query from a requestor, determining by the computing device an active instance from the at least two instances based at least in part on comparing the first value of the switch parameter to the unique identifier of each instance, modifying by the computing device the client query at least in part based on the determined active instance to create a resultant query, executing the resultant query against the active instance to generate a resultant data, and providing the resultant data to the requestor.

Abstract: A computer-implemented method for managing access to data stored in a database is provided. The method includes storing in the database a switch parameter having a first value, storing in the database at least two instances of a data object wherein each of the instances includes a unique identifier, receiving a client query from a requestor, determining by the computing device an active instance from the at least two instances based at least in part on comparing the first value of the switch parameter to the unique identifier of each instance, modifying by the computing device the client query at least in part based on the determined active instance to create a resultant query, executing the resultant query against the active instance to generate a resultant data, and providing the resultant data to the requestor.

Abstract: Systems and methods are provided for use in accessing data stored in multiple databases. One exemplary system includes first and second databases. The first database includes a first primary tablespace having first data, a first standby tablespace having first standby data, and a first journal. The first database is configured, in response to a request including a change instruction for the first data, to alter the first data consistent with the change instruction, append a change description indicative of the alteration to the journal, and transmit the journal to the second database. The second database is configured to then receive the journal from the first database and to alter second standby data included in a second standby tablespace of the second database consistent with the change description, thereby maintaining the second standby data in the second standby tablespace as a replicate of the first data in the first primary tablespace.

Abstract: Disclosed are exemplary embodiments of systems and methods for use in assigning locations to network records. One exemplary system includes a processor coupled to a data structure including network records, each record including a network node identifier and a boundary identifier. The processor is configured to, for each boundary identifier, access each of the network records including the boundary identifier. The accessed records include reference and target network records. Each reference network record includes location data indicative of a location of the network node identified in the reference record within the boundary. The processor is configured to determine an aggregate location as a median of the location data for the network nodes identified in the reference network records and assign the aggregate location to each of the target network records as location data indicative of the location of each network node identified in the target records within the boundary.

Abstract: Disclosed are exemplary embodiments of systems and methods for use in assigning locations to network records. One exemplary system includes a processor coupled to a data structure including network records, each record including a network node identifier and a boundary identifier. The processor is configured to, for each boundary identifier, access each of the network records including the boundary identifier. The accessed records include reference and target network records. Each reference network record includes location data indicative of a location of the network node identified in the reference record within the boundary. The processor is configured to determine an aggregate location as a median of the location data for the network nodes identified in the reference network records and assign the aggregate location to each of the target network records as location data indicative of the location of each network node identified in the target records within the boundary.

Abstract: Systems, methods, and apparatus for monitoring flow of data traffic are described. For each of a plurality of transfer units from a data stream (e.g., messages from a message queue), a value of a first field of the transfer unit is mapped to a corresponding counter in random-access memory and the counter is updated. Counter values are periodically copied to a user-accessible region. In one example, message field values are obtained from database log files. In another example, message field values are obtained via an interface called by a database management system.

Abstract: Systems and methods are provided for use in accessing data stored in multiple databases. One exemplary system includes first and second databases. The first database includes a first primary tablespace having first data, a first standby tablespace having first standby data, and a first journal. The first database is configured, in response to a request including a change instruction for the first data, to alter the first data consistent with the change instruction, append a change description indicative of the alteration to the journal, and transmit the journal to the second database. The second database is configured to then receive the journal from the first database and to alter second standby data included in a second standby tablespace of the second database consistent with the change description, thereby maintaining the second standby data in the second standby tablespace as a replicate of the first data in the first primary tablespace.

Abstract: Systems, methods, and apparatus for monitoring flow of data traffic are described. For each of a plurality of transfer units from a data stream (e.g., messages from a message queue), a value of a first field of the transfer unit is mapped to a corresponding counter in random-access memory and the counter is updated. Counter values are periodically copied to a user-accessible region. In one example, message field values are obtained from database log files. In another example, message field values are obtained via an interface called by a database management system.

Abstract: A computer-based method for optimizing database queries is provided. The method uses a server computer device including a processor communicatively coupled to a database. The method includes receiving a main query requesting data from a partitioned database table within the database. The partitioned database table includes a plurality of partitions. The method also includes determining a partition list. The partition list includes two or more partitions of the plurality of partitions and excludes at least one partition of the plurality of partitions. The method further includes generating a plurality of sub-queries where each sub-query is associated with one partition included within the partition list, and processing each sub-query of the plurality of sub-queries on the associated partition included within the partition list.

Abstract: A computer-based method for optimizing database queries is provided. The method uses a server computer device including a processor communicatively coupled to a database. The method includes receiving a main query requesting data from a partitioned database table within the database. The partitioned database table includes a plurality of partitions. The method also includes determining a partition list. The partition list includes two or more partitions of the plurality of partitions and excludes at least one partition of the plurality of partitions. The method further includes generating a plurality of sub-queries where each sub-query is associated with one partition included within the partition list, and processing each sub-query of the plurality of sub-queries on the associated partition included within the partition list.

Abstract: A computer-implemented method for managing access to data stored in a database is provided. The method includes storing in the database a switch parameter having a first value, storing in the database at least two instances of a data object wherein each of the instances includes a unique identifier, receiving a client query from a requestor, determining by the computing device an active instance from the at least two instances based at least in part on comparing the first value of the switch parameter to the unique identifier of each instance, modifying by the computing device the client query at least in part based on the determined active instance to create a resultant query, executing the resultant query against the active instance to generate a resultant data, and providing the resultant data to the requestor.

Abstract: A system and method for database replication having that captures change operations made to an application database, aggregates the change operations performed upon the application database; and applies the aggregated change operations to a replica application database in a single operation.

Abstract: A system and method for database replication having that captures change operations made to an application database, aggregates the change operations performed upon the application database; and applies the aggregated change operations to a replica application database in a single operation.