摘要:
Approaches, techniques, and mechanisms are disclosed for maintaining a set of baseline query plans for a database command. Except in rare circumstances, a database server may only execute a command according to a baseline plan, even if the database server predicts that a different plan has a lower cost. The set of baseline plans are plans that, for one reason or another, have been determined to provide acceptable actual performance in at least one execution context. When the database server receives a request to execute a particular command, the database server, if possible, always executes the command according to the lowest predicted cost baseline plan. The database server may evolve the plan baseline to include additional plans by generating and testing new plans in response to new requests to execute the database command, or as part of a query optimization or tuning process.
摘要:
An optoisolator leadframe assembly includes: an emitter leadframe part including a first rail and a plurality of emitter leadframe units, each rail including two rows of emitter leadframes, each having a die-mounting pad; and a receiver leadframe part including a second rail and a plurality of receiver leadframe units, each including two rows of receiver leadframes, each having a die-mounting pad. The die-mounting pads of the emitter leadframes of each row of each of the emitter leadframe units are respectively aligned with and spaced apart from the die-mounting pads of the receiver leadframes of an adjacent row of an adjacent one of the receiver leadframe units. Each of the emitter and receiver leadframe parts is a single piece.
摘要:
A packaging apparatus for optical-semiconductors includes a mold base having a longitudinal receiving space, an encapsulating module attached to the mold base, and a fixing member attached to the encapsulating module. The bottom of the mold base has at least one air-vent and the mold base has a predetermined width. The encapsulating module includes a plate engaged with the mold base, a plurality of molding bodies penetrating the plate and received in the receiving space, and a plurality of supporting members connected to the molding bodies. The fixing member has a plurality of holding slots to hold the supporting members so that the supporting members are more stable. Furthermore, the width of the mold base is optimized with the dimension of a furnace so that the production rate is increased and the stability of the packaging structure is improved.
摘要:
A lead frame module integrally formed from a single thin metal sheet includes: parallel first and second rails extending in a first direction; and first and second lead frame sets connected to the first and second rails, respectively. The first and second lead frame sets respectively include a plurality of lead frames extending in a second direction perpendicular to the first direction. Each of the lead frames of the first and second lead frame sets has a pair of connecting leads and a pair of packaging leads. Each of the packaging leads is connected to a respective one of the connecting leads. The connecting leads of the lead frames of the first lead frame set are interdigitated with and are connected to the connecting leads of the lead frames of the second lead frame set.
摘要:
A packaging apparatus for optical-semiconductors includes a mold base having a longitudinal receiving space, an encapsulating module attached to the mold base, and a fixing member attached to the encapsulating module. The bottom of the mold base has at least one air-vent and the mold base has a predetermined width. The encapsulating module includes a plate engaged with the mold base, a plurality of molding bodies penetrating the plate and received in the receiving space, and a plurality of supporting members connected to the molding bodies. The fixing member has a plurality of holding slots to hold the supporting members so that the supporting members are more stable. Furthermore, the width of the mold base is optimized with the dimension of a furnace so that the production rate is increased and the stability of the packaging structure is improved.
摘要:
A method and apparatus for approximating a database statistic, such as the number of distinct values (NDV) is provided. To approximate the NDV for a portion of a table, a synopsis of distinct values is constructed. Each value in the portion is mapped to a domain of values. The mapping function is implemented with a uniform hash function, in one embodiment. If the resultant domain value does not exist in the synopsis, the domain value is added to the synopsis. If the synopsis reaches its capacity, a portion of the domain values are discarded from the synopsis. The statistic is approximated based on the number (N) of domain values in the synopsis and the portion of the domain that is represented in the synopsis relative to the size of the domain.
摘要:
Under a type of query transformation referred to herein as join factorization, the branches of an UNION/UNION ALL query that join a common table are combined to reduce accesses to the common table. The transformation can be expressed as (T1 join T2) union all (T1 join T3)=T1 join (T2 union all T3), where T1, T2 and T3 are three tables. A given query may be rewritten in many alternate ways using join factorization. Evaluating each alternative can be expensive. Therefore, the alternatives are generated and evaluated in a way that minimizes the cost of evaluating the alternatives.
摘要翻译:在这里称为连接因式分解的一种类型的查询变换中,加入公共表的UNION / UNION ALL查询的分支被组合以减少对公共表的访问。 转换可以表示为(T 1连接T 2)联合全部(T 1连接T 3)= T 1连接(T 2并联全部T 3),其中T 1,T 2和T 3是三个表。 给定的查询可以使用连接因式分解以许多替代方式重写。 评估每个替代品可能是昂贵的。 因此,以最小化评估替代品的成本的方式生成和评估替代方案。
摘要:
A gravity sensor has a photo interrupter and a gravity wheel. The photo interrupter has a housing, a cavity in the housing, a light emitter on one side of the housing and a light detector on the other side of the housing. The gravity wheel points in a direction of gravity and has a pivot at center thereof and pivotally arranged on the housing, a plumb at one edge of the gravity wheel and a plurality of through holes annularly arranged in the gravity wheel. The gravity wheel has a portion present in the cavity. An inclined angle of a test object is determined by calculating relative movement between the photo interrupter and the gravity wheel.
摘要:
The present invention involves the creation of defined chromosomal deficiencies, inversions and duplications using Cre recombinase in ES cells transmitted into the mouse germ line. These chromosomal reconstructions can extend up to 3-4 cM. Chromosomal rearrangements are the major cause of inherited human disease and fetal loss. Additionally, translocations and deletions are recognized as major genetic changes that are causally involved in neoplasia. Chromosomal variants such as deletions and inversions are exploited commonly as genetic tools in organisms such as Drosophila. Mice with defined regions of segmental haploidy are useful for genetic screening and allow accurate models of human chromosomal diseases to be generated.
摘要:
The present invention involves the creation of defined chromosomal deficiencies, inversions and duplications using Cre recombinase in ES cells transmitted into the mouse germ line. These chromosomal reconstructions can extend up to 3-4 cM. Chromosomal rearrangements are the major cause of inherited human disease and fetal loss. Additionally, translocations and deletions are recognized as major genetic changes that are causally involved in neoplasia. Chromosomal variants such as deletions and inversions are exploited commonly as genetic tools in organisms such as Drosophila. Mice with defined regions of segmental haploidy are useful for genetic screening and allow accurate models of human chromosomal diseases to be generated.