Abstract: Computer-readable media, methods, and systems are disclosed for utilizing partition-based locking mechanisms to improve execution of overlapping data definition language (DDL) and data manipulation language (DML) operations on a partitioned database table. A first node receives a DML statement associated with a first transaction. The first node acquires a intent exclusive lock on table metadata. A second node receives a DDL statement associated with a second transaction and acquires an exclusive metadata lock on the partitioned table metadata. Next, an intent exclusive lock is acquired for the relevant partition table data on the second node and an exclusive lock on table metadata on the second node. The second transaction waits for the DML operation of the first transaction to complete. Then the first transaction is committed. Finally exclusive locks are acquired on table data and metadata and the second transaction is executed and committed.

Abstract: Computer-readable media, methods, and systems are disclosed for database table partition pruning based on statistical information associated with non-partition columns. A tree partition specification is received defining partitions for a plurality of computed column statistics. Respective partitions are created for the plurality of computed column statistics based on the tree partition specification. A request is received to compute statistics for a plurality of columns of the plurality of computed column statistics to result in a plurality of computed column statistics. In response to determining that one or more modifications have been made to the partitioned database, the plurality of computed column statistics is marked as invalid. The computed column statistics are refreshed in response to modifications of the partitioned table. Thereafter, the statistics are marked as valid. Unnecessary table partitions are pruned based on the statistics, and the associated query is executed.

Abstract: A device is described that includes a carrier that has a plurality of light-emitting diode (LED) mounting areas. Each of the LED mounting areas includes a pair of contact pads, which are electrically coupled to the LED mounting area in a first subset of the plurality of LED mounting areas or electrically connected in series with a shunting element in the respective LED mounting area in a second subset of the plurality of LED mounting areas. In some embodiments, LEDs may be placed in the first subset of the plurality of LED mounting areas.

Abstract: The present disclosure provides a light emitting module including: a substrate supporting at least one light emitting component; an enclosing component surrounding the light emitting component and defining an interspace between an inner surface of the enclosing component and the light emitting component; a coating material applied in the interspace between the enclosing component and the light emitting component. The enclosing component is attached as a separate component on the substrate. The light emitting module according to the present disclosure has an improved manufacturing effectiveness and convenience, and less complexity, thus reducing the production cost.