Abstract: A computer-implemented method for performing application data consistency management among a plurality of computing devices within a communication network includes retrieving by a first device, application data from a second device. The application data includes an app ID and a first application version number of an app residing on the second device. A first database table is updated using an object type associated with the app ID and the first application version number. The object type identifies a database table schema of a data object used by the app and a plurality of data fields of the data object. Data stored by one or more of the plurality of data fields is synchronized with a third device based on a second application version number of the app residing on the third device and the first database table.

Abstract: A computer-implemented method for performing data synchronization between a plurality of computing devices within a communication network includes detecting, by a first computing device of the plurality of computing devices, a changed data field of a plurality of available data fields within a first database table tuple. A bitmap within a plurality of configuration fields of the first database table tuple is updated to indicate a bit location associated with the changed data field. Synchronization data including the changed one or more data fields, the bitmap, and a version number of the first database table tuple within the plurality of configuration fields is sent to a second computing device. A conflict resolution procedure is performed based on a synchronization response received from the second computing device.

Abstract: A device-cloud collaboration method, platform, and apparatus, where the device-cloud collaboration method includes: obtaining current spatial information of each target terminal; tracking a spatial information change of each target terminal, to obtain a spatial information change status of each target terminal; and determining, based on spatial information-based arbitration conditions preset for different target mobile applications and the spatial information change status of the target terminal corresponding to the different target mobile applications, whether to trigger subsequent operations related to the different target mobile applications. The device-cloud platform blocks a change in which the user is not interested through arbitration of a spatial information change of the user, and provides an appropriate spatial information change to a mobile application, or triggers a subsequent operation of the mobile application.

Abstract: A computer-implemented method for data synchronization in a P2P ad hoc network includes retrieving network configuration information identifying a plurality of devices forming the P2P ad hoc network. A time offset between a local physical time at a first device and a local physical time of a second device is determined. A change in a data object of a plurality of data objects stored at a key-value store within the first device is detected, each of the data objects including a synchronization indicator. The data object change is communicated to at least the second device based on the synchronization indicator. Upon receiving confirmation from the at least the second device of receipt of the data object change, the network configuration information is updated with a timestamp based on the time offset and indicative of the local physical time at the first device when the data object change was communicated.

Abstract: A computer-implemented method for data synchronization in a P2P ad hoc network includes retrieving network configuration information identifying a plurality of devices forming the P2P ad hoc network. A time offset between a local physical time at a first device and a local physical time of a second device is determined. A change in a data object of a plurality of data objects stored at a key-value store within the first device is detected, each of the data objects including a synchronization indicator. The data object change is communicated to at least the second device based on the synchronization indicator. Upon receiving confirmation from the at least the second device of receipt of the data object change, the network configuration information is updated with a. timestamp based on the time offset and indicative of the local physical time at the first device when the data object change was communicated.

Abstract: A device-cloud collaboration method, platform, and apparatus, where the device-cloud collaboration method includes: obtaining current spatial information of each target terminal; tracking a spatial information change of each target terminal, to obtain a spatial information change status of each target terminal; and determining, based on spatial information-based arbitration conditions preset for different target mobile applications and the spatial information change status of the target terminal corresponding to the different target mobile applications, whether to trigger subsequent operations related to the different target mobile applications. The device-cloud platform blocks a change in which the user is not interested through arbitration of a spatial information change of the user, and provides an appropriate spatial information change to a mobile application, or triggers a subsequent operation of the mobile application.

Abstract: A database system comprises a persistent storage device, a log node including a memory and a processor, and a plurality of database nodes. A database node includes a cache memory configured to store a database instance, and a processor configured to initiate a database transaction by sending a snapshot request to the log node, the snapshot request including a list of pages that were either replaced or newly loaded in the cache memory. The log node processor is configured to send a snapshot response to the database node, wherein the snapshot response includes a snapshot of the database and a list of changed pages of the database instances. The database node processor is configured to update the status of the pages in cached memory according to the snapshot response and perform the database transaction.

Abstract: An apparatus, method, and non-transitory computer-readable media are provided for compiling serial and parallel database query execution plans. In use, a processing device parses a database query into a tree structure. Further, the processing device compiles a serial execution plan and a parallel execution plan for the database query, utilizing the tree structure. The processing device also identifies an amount of resources for executing the database query. The processing device selects the serial execution plan and/or the parallel execution plan, based on the identified amount of resources. To this end, the processing device executes the database query, utilizing the selected serial execution plan and/or the parallel execution plan.

Abstract: A database query is partitioned into an initial partition including a plurality of parallel groups, and is executed, via an execution plan, based on the initial partition. A sampling subset of data is identified from the plurality of parallel groups. Substantially in parallel with the executing of the query, the execution plan is executed on the sampling subset of data as a sampling thread. The execution plan is modified based on feedback from the execution of the execution plan on the sampling subset of data.

Abstract: An SQL procedure deployment system deploys a query procedure comprising a procedural logic component and a database request component from a source system to a target system. At generation of the query procedure, the system generates a query procedure source code, a symbol table, and an encapsulated optimization results to regenerate run-time instructions for query statements of the database request component and make the query statements function with a deployed procedural logic component. The system maintains an association between the procedural logic component and the database request component during deployment. The system copies an internal representation of the procedural logic component to the target system without regeneration. The system regenerates the database request component to recreate the query procedure on the target system and to maintain a consistent interface between the procedural logic component and database request component.

Abstract: A database query is partitioned into an initial partition including a plurality of parallel groups, and is executed, via an execution plan, based on the initial partition. A sampling subset of data is identified from the plurality of parallel groups. Substantially in parallel with the executing of the query, the execution plan is executed on the sampling subset of data as a sampling thread. The execution plan is modified based on feedback from the execution of the execution plan on the sampling subset of data.

Abstract: An SQL procedure deployment system deploys a query procedure comprising a procedural logic component and a database request component from a source system to a target system. At generation of the query procedure, the system generates a query procedure source code, a symbol table, and an encapsulated optimization results to regenerate run-time instructions for query statements of the database request component and make the query statements function with a deployed procedural logic component. The system maintains an association between the procedural logic component and the database request component during deployment. The system copies an internal representation of the procedural logic component to the target system without regeneration. The system regenerates the database request component to recreate the query procedure on the target system and to maintain a consistent interface between the procedural logic component and database request component.

Abstract: A method and system for using a procedure residing and executed entirely within a database system is disclosed. The procedure utilizes at least one variable, which has a plurality of attributes. The method and system include defining the at least one variable as at least one global variable prior to calling of the procedure. Defining the global variable(s) includes informing the database system of the plurality of attributes of the variable(s) and allowing the database system access to the at least one variable. The method and system also include tracking the global variable(s).