Abstract: A massively parallel processing shared nothing relational database management system includes a plurality of storages assigned to a plurality of compute nodes. The system comprises a non-transitory memory having instructions and one or more processors in communication with the memory. The one or more processors execute the instructions to store a set of data in a first set of storages in the plurality of storages. The first set of data is hashed into a repartitioned set of data. The first set of storages is reassigned to a second set of compute nodes in the plurality of compute nodes. The repartitioned set of data is distributed to the second set of compute nodes and a database operation is performed on the repartitioned set of data by the second set of compute nodes.

Abstract: Techniques to facilitate creation of security profiles for web application components are disclosed herein. In at least one implementation, a plurality of web resources used to construct web applications is received. The plurality of web resources is analyzed to generate normalized fingerprints for each of the web resources. A plurality of security risk factors is determined for each of the plurality of web resources based on the normalized fingerprints generated for each of the web resources. A reputation score is generated for each of the plurality of web resources based on the security risk factors determined for each of the web resources.

Abstract: Disclosed herein is a process of making a compound of formula I The compound of formula I is an inhibitor of MEK and thus can be used to treat cancer.

Abstract: A system and method for improved online transaction processing (OLTP) in a sharded database is provided. Overhead associated with a global transaction manager is reduced and scalability improved by determining whether incoming queries are single-shard transactions or multi-shard transactions. For multi-shard transactions, a distributed transaction ID (DXID) is requested from the GTM, and then forwarded with the query to one or more data notes. For single-shard transactions, the query is sent to a data node without requesting a DXID from the GTM.

Abstract: A computer-implemented method of relocating data in a distributed database comprises: creating, by one or more processors, a second table in the distributed database, the second table including all columns from a first table; copying, by the one or more processors, a first set of tuples from the first table to the second table; modifying, by the one or more processors, during the copying of the first set of tuples, data of the first table according to a modification; after the copying of the first set of tuples, modifying, by the one or more processors, data of the second table according to the modification; and switching, by the one or more processors, the second table for the first table in a catalog of the distributed database.

Abstract: System and method for hybrid distribution mode in massively parallel processing (MPP) database preventing storage imbalance issues caused by data skew. Key values of the database are identified as outliers if records of those keys cause database skew. In hybrid mode, records having the outlier key values are distributed using a random distribution scheme. Other records are distributed using a hash distribution scheme. A threshold skew amount is configurable for the system. Record lookups, insertions, deletions, and updates are processed according to a query plan optimized for the distribution mode of the records referenced in a database query.

Abstract: The invention provides a solid state lighting device having an adjustable light output direction. In embodiments, an adjustable reflector element is provided, which is transitionable between at least a first and second orientation status, in order thereby to alter through which one or more of the light exit surfaces of the device the generated luminous output is directed.

Abstract: Disclosed herein is a process of making a compound of formula I The compound of formula I is an inhibitor of MEK and thus can be used to treat cancer.

Abstract: An assembly for testing an infrared (IR) ink print quality of an IR ink print area on an optical component includes a light source including an illuminated periphery and a dark interior, an IR camera having a field of view positioned to image the dark interior without imaging at least a portion of the illuminated periphery, and a component holder configured to hold the optical component between the IR camera and the light source such that IR light emitted from the portion of the illuminated periphery that illuminates the IR ink print area on the optical component is deflected into the field of view of the IR camera if the IR ink print area has defects but is not deflected into the field of view of the IR camera if the IR ink print area does not have defects.

Abstract: Devices, systems, and methods of the present disclosure are directed to accurate and non-invasive assessments of anatomic vessels (e.g., the internal jugular vein (IJV)) of vertebrates. For example, a piezoelectric crystal may generate a signal and receive a pulse echo of the signal along an axis extending through the piezoelectric crystal and an anatomic vessel. A force sensor disposed relative to the piezoelectric crystal may measure a force exerted (e.g., along skin of the vertebrate) on the anatomic vessel along the axis. The pulse echo received by the piezoelectric crystal and the force measured by the force sensor may, in combination, non-invasively and accurately determine a force response of the anatomic vessel. In turn, the force response may be probative of any one or more of a variety of different characteristics of the anatomic vessel including, for example, location of the anatomic vessel and pressure of the anatomic vessel.

Abstract: A method includes dividing a dataset into partitions by hashing a specified key, selecting a set of distributed file system nodes as a primary node group for storage of the partitions, and causing a primary copy of the partitions to be stored on the primary node group by a distributed storage system file server such that the location of each partition is known by hashing of the specified key.

Abstract: An assembly for testing an infrared (IR) ink print quality of an IR ink print area on an optical component includes a light source including an illuminated periphery and a dark interior, an IR camera having a field of view positioned to image the dark interior without imaging at least a portion of the illuminated periphery, and a component holder configured to hold the optical component between the IR camera and the light source such that IR light emitted from the portion of the illuminated periphery that illuminates the IR ink print area on the optical component is deflected into the field of view of the IR camera if the IR ink print area has defects but is not deflected into the field of view of the IR camera if the IR ink print area does not have defects.

Abstract: A massively parallel processing shared nothing relational database management system includes a plurality of storages assigned to a plurality of compute nodes. The system comprises a non-transitory memory having instructions and one or more processors in communication with the memory. The one or more processors execute the instructions to store a set of data in a first set of storages in the plurality of storages. The first set of data is hashed into a repartitioned set of data. The first set of storages is reassigned to a second set of compute nodes in the plurality of compute nodes. The repartitioned set of data is distributed to the second set of compute nodes and a database operation is performed on the repartitioned set of data by the second set of compute nodes.

Abstract: The invention provides a solid state lighting device having an adjustable light output direction. In embodiments, an adjustable reflector element is provided, which is transitionable between at least a first and second orientation status, in order thereby to alter through which one or more of the light exit surfaces of the device the generated luminous output is directed.

Abstract: The disclosure relates to technology for query compilation in a database management system. A first execution time of code for at least one database query without applying a code generation method is estimated and in response to receiving the at least one database query, and for one or more code generation methods, a compilation cost and a second execution time of the code as modified by the code generation methods is estimated. A cost savings for each of the one or more code generation methods is calculated, where the cost savings is calculated as the first execution time less the second execution time of the code generation method, less the compilation cost of the code generation method. One of the code generation methods or the no code generation method with the highest cost savings is then selected.

Abstract: Disclosed herein is a process of making a compound of formula I The compound of formula I is an inhibitor of MEK and thus can be used to treat cancer.

Abstract: A physiological detection method includes the following steps. A detection portion of a human body is detected to obtain a detection signal. Then, the detection signal is processed to output a digital physiological signal. The digital physiological signal is received to calculate and obtain first information and second information related to feature points thereof. Then, a ratio of the second information to the first information is calculated to obtain a physiological condition index. The digital physiological signal includes pulse waves generated according to a time sequence. The feature points of the digital physiological signal include a wave pulse peak and a foot point located at a forepart of the rising edge of the wave. In addition, a physiological detection device is also introduced.

Abstract: Exemplary embodiments of methods and systems of incentivized advertising are presented. A content identifier identifying a digital content item, such as a song, is displayed on a user computing device. The digital content item is typically of the type available for a purchase price by the general public. A selection icon is provided in visual association with the content identifier. If the icon is selected by the user, an advertisement media item, such as a video advertisement, is presented on the user computing device. If the advertisement media item is presented for at least a requisite ad impression period, the digital content item is imparted to the user for free. Follow-up ad engagement views are typically presented to the user with a button to redeem the earned digital content item. Administrator and server elements are configured to facilitate performance of the method, and to optimize efficient use of advertiser's budget.

Abstract: Disclosed herein is a process of making a compound of formula I The compound of formula I is an inhibitor of MEK and thus can be used to treat cancer.

Abstract: Exemplary embodiments of methods and systems of incentivized advertising are presented. A content identifier identifying a digital content item, such as a song, is displayed on a user computing device. The digital content item is typically of the type available for a purchase price by the general public. A selection icon is provided in visual association with the content identifier. If the icon is selected by the user, an advertisement media item, such as a video advertisement, is presented on the user computing device. If the advertisement media item is presented for at least a requisite ad impression period, the digital content item is imparted to the user for free. Follow-up ad engagement views are typically presented to the user with a button to redeem the earned digital content item. Administrator and server elements are configured to facilitate performance of the method, and to optimize efficient use of advertiser's budget.