Abstract: Computer implemented methods, systems, and computer program products include program code executing on a processor(s) that obtain a query comprising a JOIN statement that references two or more tables in the one or more remote databases. The program code determines, for each table of the two or more tables, whether executing the JOIN statement utilizes system resources above a pre-defined allotment. Based on determining, for at least one table the program code generates a filter for the at least one table based on an intersection between predicates in the query. The program code applies the filer to the at least one table to fetch results for the query and exclude unrelated data from the fetching.

Abstract: A data virtualization layer (DV) receives a join query request related to a plurality of tables respectively stored in a plurality of distributed database servers. A plurality of candidate query plans for the join query request is generated where each of the plurality of candidate query plans indicates an order for transmitting the tables respectively stored in the database servers to the DV. For each of the plurality of candidate query plans, a query cost for the candidate query plan is calculated based on a data amount of the tables to be transmitted according to the candidate query plan. From the plurality of candidate query plans, a query plan is determined for the join query request which has a lowest query cost.

Abstract: A data virtualization layer (DV) receives a join query request related to a plurality of tables respectively stored in a plurality of distributed database servers. A plurality of candidate query plans for the join query request is generated where each of the plurality of candidate query plans indicates an order for transmitting the tables respectively stored in the database servers to the DV. For each of the plurality of candidate query plans, a query cost for the candidate query plan is calculated based on a data amount of the tables to be transmitted according to the candidate query plan. From the plurality of candidate query plans, a query plan is determined for the join query request which has a lowest query cost.

Abstract: A method for regulating color of a hard coating, including the following steps: providing an amorphous alloy layer; forming an amorphous metal oxide layer on a surface of the amorphous alloy layer to stack the amorphous metal oxide layer on the amorphous alloy layer, so that the amorphous metal oxide layer and the amorphous alloy layer together form the hard coating, wherein a band gap of the amorphous metal oxide layer is in a range from 2 eV to 5 eV, and the color of the hard coating is capable of varying within the visible light spectrum depending on thickness of the amorphous metal oxide layer; and controlling the thickness of the amorphous metal oxide layer in the formation of the amorphous metal oxide layer to obtain the amorphous metal oxide layer of a predetermined color. A hard coating and a method for preparing the same are also provided.

Abstract: A video processing method, apparatus, and device and a storage medium are provided. The method includes: monitoring an operation indication inputted by a user through a personal homepage on a social platform, the personal homepage being used for displaying personal information of the user; obtaining, when the operation indication is a shooting indication for shooting a personal status video, the personal status video; uploading the personal status video to a back-end server of the social platform; and displaying indication information of the personal status video in a personal-information display region of the personal homepage.

Abstract: An animated emoticon generation method, a computer-readable storage medium, and a computer device are provided. The method includes: displaying an emoticon input panel on a chat page; detecting whether a video shooting event is triggered in the emoticon input panel; acquiring video data in response to detecting the video shooting event; obtaining an edit operation for the video data; processing video frames in the video data according to the edit operation to synthesize an animated emoticon; and adding an emoticon thumbnail corresponding to the animated emoticon to the emoticon input panel, the emoticon thumbnail displaying the animated emoticon to be used as a message on the chat page based on a user selecting the emoticon thumbnail in the emoticon input panel.

Abstract: Methods, computer program products, and systems are presented. The methods include, for instance: collecting real time system statistics on a system environment in a remote platform running a remote data source amongst a plurality of remote data sources of a virtual database. Real time data source statistics on one or more data source objects from the remote data source of the virtual database is also gathered. A global catalog of the virtual database is updated with the real time system statistics and the real time data source statistics. An access plan to process a query to the virtual database is optimized based on the real time system statistics and the real time data source statistics and a response is produced based on the access plan, with improved performance and reduced cost.

Abstract: The disclosure provides porous membranes capable of removing very small particulates from a liquid composition. In certain embodiments, the porous membranes comprise poly(tetrafluoroethylene), wherein the membrane is at least partially coated with a polymer prepared from the free radical reaction of ethylenically-unsaturated monomers, wherein the monomers are comprised of monomers having an amide moiety. In particular embodiments, the membranes are capable of removing, by filtration, microbial particles such as bacteria, thus rendering the resulting liquid composition essentially sterile.

Abstract: The disclosure provides certain porous polymeric membranes, coated with cross-linked polymerized monomers, comprising monomers having a charge when immersed in an organic liquid. The membranes of the disclosure are useful in removing trace amounts of metallic impurities thereby providing ultra-pure organic liquids.

Abstract: An animated emoticon generation method, a computer-readable storage medium, and a computer device are provided. The method includes: displaying an emoticon input panel on a chat page; detecting whether a video shooting event is triggered in the emoticon input panel; acquiring video data in response to detecting the video shooting event; obtaining an edit operation for the video data; processing video frames in the video data according to the edit operation to synthesize an animated emoticon; and adding an emoticon thumbnail corresponding to the animated emoticon to the emoticon input panel, the emoticon thumbnail displaying the animated emoticon to be used as a message on the chat page based on a user selecting the emoticon thumbnail in the emoticon input panel.

Abstract: Methods, computer program products, and systems are presented. The methods include, for instance: collecting real time system statistics on a system environment in a remote platform running a remote data source amongst a plurality of remote data sources of a virtual database. Real time data source statistics on one or more data source objects from the remote data source of the virtual database is also gathered. A global catalog of the virtual database is updated with the real time system statistics and the real time data source statistics. An access plan to process a query to the virtual database is optimized based on the real time system statistics and the real time data source statistics and a response is produced based on the access plan, with improved performance and reduced cost.

Abstract: An animated emoticon generation method, a computer-readable storage medium, and a computer device are provided. The method includes: displaying an emoticon input panel on a chat page; detecting whether a video shooting event is triggered in the emoticon input panel; acquiring video data in response to detecting the video shooting event; obtaining an edit operation for the video data; processing video frames in the video data according to the edit operation to synthesize an animated emoticon; and adding an emoticon thumbnail corresponding to the animated emoticon to the emoticon input panel, the emoticon thumbnail displaying the animated emoticon to be used as a message on the chat page based on a user selecting the emoticon thumbnail in the emoticon input panel.

Abstract: Disclosed is a display backplane, comprising a backplane, micro light-emitting diodes, a plug-in circuit board, and signal lines; a light-emitting area arranged on front surface of the backplane; a first trace area and a second trace area arranged on both opposite sides of the light-emitting area, and a third trace area arranged on one side of the light-emitting area and between the opposite sides; the third trace area is arranged between the first trace area and the second trace area; first signal lines are routed from the first trace area and the second trace area and are electrically coupled to the plug-in circuit board through the third trace area, second signal lines routed along the back surface from the first trace area and the second trace area are arranged on the third trace area in a winding manner. A display device and a tiled display device are also disclosed.

Abstract: This invention is about a detection device based on the piezoelectric property of geological minerals. The device has a vibration detector for compressing geological minerals to generate charges, so as to detect vibration and a physiotherapy jacket for carrying out quantitative physiotherapy on a human body by detecting the amount of charges. The system has the advantages of: being simple in structure, comprising the vibration detector and the physiotherapy jacket, using the piezoelectric property of geological minerals such as quartz and tourmaline, so as to realize detection of environmental vibration indoors, underground or in the field, and improving the safety factor of geological exploration operations.

Abstract: Disclosed is a computer implemented method and related system to improve the efficiency of querying remote databases. The method includes receiving, from a host, a query, wherein the query is configured to retrieve a set of data from a remote database. The method also includes, generating an access plan, the access plan comprising a plurality of nodes wherein each node of the plurality of nodes includes a command. The method further includes determining capabilities of the remote database. The method includes executing the query and returning the set of data to the host.

Abstract: Processes for upgrading a heavy oil or heavy oil-derived feedstock in presence of an ionic liquid are described, and can improve the heavy oil or heavy oil-derived properties such as viscosity and composition, and reduced contaminant content, such as a reduced Total Acid Number (TAN) and a reduced heavy metal content. Processes for upgrading heavy oil or heavy oil-derived in presence of an ionic liquid can include a catalytic cracking treatment carried out under catalytic cracking conditions, and/or a non-catalytic treatment, as well as various separation steps to separate the ionic liquid or a diluent if present in the feedstock. The ionic liquids that can be used in the context of the processes described herein include ionic liquids that are feed-miscible or feed-immiscible.

Abstract: A video processing method, apparatus, and device and a storage medium are provided. The method includes: monitoring an operation indication inputted by a user through a personal homepage on a social platform, the personal homepage being used for displaying personal information of the user; obtaining, when the operation indication is a shooting indication for shooting a personal status video, the personal status video; uploading the personal status video to a back-end server of the social platform; and displaying indication information of the personal status video in a personal-information display region of the personal homepage.

Abstract: A method for regulating color of a hard coating, including the following steps: providing an amorphous alloy layer; forming an amorphous metal oxide layer on a surface of the amorphous alloy layer to stack the amorphous metal oxide layer on the amorphous alloy layer, so that the amorphous metal oxide layer and the amorphous alloy layer together form the hard coating, wherein a band gap of the amorphous metal oxide layer is in a range from 2 eV to 5 eV, and the color of the hard coating is capable of varying within the visible light spectrum depending on thickness of the amorphous metal oxide layer; and controlling the thickness of the amorphous metal oxide layer in the formation of the amorphous metal oxide layer to obtain the amorphous metal oxide layer of a predetermined color. A hard coating and a method for preparing the same are also provided.

Abstract: Disclosed is a computer implemented method and related system to improve the efficiency of querying remote databases. The method includes receiving, from a host, a query, wherein the query is configured to retrieve a set of data from a remote database. The method also includes, generating an access plan, the access plan comprising a plurality of nodes wherein each node of the plurality of nodes includes a command. The method further includes determining capabilities of the remote database. The method includes executing the query and returning the set of data to the host.

Abstract: This invention is about a detection device based on the piezoelectric property of geological minerals. The device has a vibration detector for compressing geological minerals to generate charges, so as to detect vibration and a physiotherapy jacket for carrying out quantitative physiotherapy on a human body by detecting the amount of charges. The system has the advantages of: being simple in structure, comprising the vibration detector and the physiotherapy jacket, using the piezoelectric property of geological minerals such as quartz and tourmaline, so as to realize detection of environmental vibration indoors, underground or in the field, and improving the safety factor of geological exploration operations.