Abstract: The invention presents methods, systems and computer program products for optimizing computer system resource utilization during in-game resource farming. The invention comprises (i) detecting a gameplay event that triggers switching from a resource farming mode to a non-resource farming mode, or for switching from a non-resource farming mode to a resource farming mode, in connection with a runtime instance of a gaining application software, (ii) identifying a guest operating system within which the runtime instance of the gaming application software is being executed, (iii) selecting a mode switching protocol implementable within the identified guest operating system, and (iv) switching the runtime instance of the gaming application software from a resource farming mode to a non-resource farming mode, or from a non-resource farming mode to a resource farming mode, by implementing the selected mode switching protocol.

Abstract: In some examples, a system identifies sub-portions of a database query, assigns identifiers to the identified sub-portions, and adds the identifiers to a data structure. The system generates a fingerprint representing the database query based on applying a fingerprint function on the data structure including the identifiers.

Abstract: A process includes accessing a query that is associated with joining a fact table with a plurality of dimension tables. The fact table includes a primary key that includes a set of columns, which are covered by the dimension tables. The process includes determining a query plan for processing the query. The query plan has an associated join order. Determining the query plan includes determining a plurality of sets of the plurality of dimension tables, where each set includes dimension tables, which cover the set of columns of the primary key. Determining the query plan includes evaluating costs that are associated with joining subsets of the plurality of sets with the fact table. Based on the costs, a given subset of the plurality of subsets is selected. Determining the query plan includes constraining the join order based on the given subset so that the dimension tables of the given subset are joined before the fact table.

Abstract: In some examples, a system identifies sub-portions of a database query, assigns identifiers to the identified sub-portions, and adds the identifiers to a data structure. The system generates a fingerprint representing the database query based on applying a fingerprint function on the data structure including the identifiers.

Abstract: In some examples, a system identifies sub-portions of a database query, assigns identifiers to the identified sub-portions, and adds the identifiers to a data structure. The system generates a fingerprint representing the database query based on applying a fingerprint function on the data structure including the identifiers.

Abstract: A process includes accessing a query that is associated with joining a fact table with a plurality of dimension tables. The fact table includes a primary key that includes a set of columns, which are covered by the dimension tables. The process includes determining a query plan for processing the query. The query plan has an associated join order. Determining the query plan includes determining a plurality of sets of the plurality of dimension tables, where each set includes dimension tables, which cover the set of columns of the primary key. Determining the query plan includes evaluating costs that are associated with joining subsets of the plurality of sets with the fact table. Based on the costs, a given subset of the plurality of subsets is selected. Determining the query plan includes constraining the join order based on the given subset so that the dimension tables of the given subset are joined before the fact table.

Abstract: The invention presents methods, systems and computer program products for optimizing computer system resource utilization during in-game resource farming. The invention comprises (i) detecting a gameplay event that triggers switching from a resource farming mode to a non-resource farming mode, or for switching from a non-resource farming mode to a resource farming mode, in connection with a runtime instance of a gaining application software, (ii) identifying a guest operating system within which the runtime instance of the gaming application software is being executed, (iii) selecting a mode switching protocol implementable within the identified guest operating system, and (iv) switching the runtime instance of the gaming application software from a resource farming mode to a non-resource farming mode, or from a non-resource farming mode to a resource farming mode, by implementing the selected mode switching protocol.

Abstract: The present disclosure relates to implementing scrolling controls within a software application. More particularly, the present disclosure relates to methods and systems of mapping and translating inputs received from one or more controllers or user interfaces communicatively coupled to a computing system or device on which a software application is being executed, to one or more instructions or events for implementing a scrolling event that the software application is configured to recognize.

Abstract: The Collateral Management with Blockchain and Smart Contracts Apparatuses, Methods and Systems (“CMBSC”) transforms borrow transaction request inputs via CMBSC components into borrow transaction init notification, borrow transaction sync notification outputs. A borrow transaction request associated with a borrow transaction is obtained. Transaction attributes associated with the borrow transaction are stored in a database. The transaction process optimizer component is notified regarding the borrow transaction. A blockchain sync notification associated with the borrow transaction is obtained from the transaction process optimizer component. The stored transaction attributes associated with the borrow transaction are filtered. A smart contract associated with the borrow transaction is generated. The generated smart contract is sent to a blockchain node of a blockchain network. A smart contract notification associated with the smart contract is received.

Abstract: In one embodiment, a method includes detecting packet congestion in a network device that includes a switch, and a plurality of components operable to transmit and receive data packets from and to the switch. The method includes, in response to detecting packet congestion, transmitting an Ethernet pause frame to at least one of the plurality of components, the at least one component identified as a source of a data packet that caused the packet congestion, and transmitting a backward congestion notification (BCN) packet to the at least one component, the BCN packet including some data payload of the data packet that caused the packet congestion.

Abstract: In one embodiment, a flow control module aggregates indications of queuing resource utilization at devices attached to a switching fabric within a router and broadcasts that information out of band to all devices attached to the same switching fabric. When the flow control module identifies congestion at one of the attached devices according to the indications, the module may also cause a throttling of traffic sent to the congested device in addition to sending the out of band indication of the congestion to all the attached devices. Flow control modules for each of the attached devices provide local interrupts for reducing outbound traffic to a congested device according to the identification of that remote congestion.

Abstract: In one embodiment, a flow control module aggregates indications of queuing resource utilization at devices attached to a switching fabric within a router and broadcasts that information out of band to all devices attached to the same switching fabric. When the flow control module identifies congestion at one of the attached devices according to the indications, the module may also cause a throttling of traffic sent to the congested device in addition to sending the out of band indication of the congestion to all the attached devices. Flow control modules for each of the attached devices provide local interrupts for reducing outbound traffic to a congested device according to the identification of that remote congestion.

Abstract: In one embodiment, a method includes detecting packet congestion in a network device that includes a switch, and a plurality of components operable to transmit and receive data packets from and to the switch. The method includes, in response to detecting packet congestion, transmitting an Ethernet pause frame to at least one of the plurality of components, the at least one component identified as a source of a data packet that caused the packet congestion, and transmitting a backward congestion notification (BCN) packet to the at least one component, the BCN packet including some data payload of the data packet that caused the packet congestion.