Abstract: A user-friendly query modeling tool, for representing, creating, modifying and modeling a query language statement for use in retrieving data from a database. In accordance with the present invention, the tool includes a user interface for receiving or building and manipulating a query, a query model definition for use in populating instances of one or more query models, and a model content provider for receiving query elements from the user interface and providing them to the query model, and conversely, for retrieving query elements from the query model and providing them to the user interface. The model content provider has a hierarchical architecture including lower level API specific components for supporting a plurality of GUI API'S, and higher level API-independent, reusable components. This architecture facilitates scalability in terms of adding support for new API's.

Abstract: An apparatus for use within an electrical devices is disclosed. The apparatus comprises a casing having an upper body and a lower body, the casing including a tab disposed on a surface thereof and an adjustable base having a plurality of tab cavities adjacent to the tab. The tab engagingly couples to one of the plurality of tab cavities to secure the adjustable base. The apparatus also includes a connector system coupled to the adjustable base.

Abstract: A method for testing integrated circuits is provided. The method provides for incorporating compression and decompression logic into each sub-component of an integrated circuit, developing test modes that target different sub-components of the integrated circuit, selecting one of the test modes, applying a test pattern to one or more sub-components of the integrated circuit targeted by the one test mode, comparing a response from application of the test pattern to a known good response, and diagnosing the response to determine which part of the one or more sub-components targeted by the one test mode failed when the response does not match the known good response.

Abstract: A system for providing a test environment for database server-side objects persistently stores a profile for a plurality of test runs for database server-side objects, where the profile comprises persistently stored test parameter values, pre-execution scripts, and/or post-execution scripts. Once the profile is created, it can be selected for subsequent test runs for one or more objects. A plurality of profiles for the objects may also be created. The system eliminates the need for a manual set up or destruction of the test environment for each test run, improving efficiency in the development of database server-side objects significantly.

Abstract: A system for synchronizing data on a first device with data at a second device, includes: determining a pre-image of the data on the first device according to a filter after a previous synchronization with the data at the second device; determining a current image of the data at the second device according to the filter; determining a delta of the current image, where the delta comprises data that exists in the current image and has changed since the previous synchronization; instructing the first device to delete data that exists in the pre-image but not in the current image; and instructing the first device to UPSERT a union of the data that exists in the delta and the data that exists in the current image but not the pre-image. This is efficient in time and bandwidth resources while also providing consistent data integrity.

Abstract: A system for executing a query on data that has been partitioned into a plurality of partitions is provided. The system includes providing partitioned data including one or more columns and the plurality of partitions. The partitioned data includes a limit key value associated with each column for a given partition. The system further includes receiving a query including a predicate on one of the one or more columns of the partitioned data; and utilizing the predicate on the one of the one or more columns in a pruning decision on at least one of the one or more partitions based on the limit key values associated with the plurality of partitions.

Abstract: A method and system for improving access concurrency to information stored in at least one table in a relational database system is disclosed. The method comprises providing a data cache, which stores a portion of the at least one table. The data cache includes a plurality of cache entries, wherein each cache entry comprises a first data item, a second data item, and a cache entry state. The method further comprises retrieving from the at least one table and storing in a cache entry's first data item a representation of committed information for a user, and retrieving from the at least one table and storing in the cache entry's second data item a representation of changes applied to the committed information, but not yet committed in the database system.

Abstract: A method for implementing distributed database management system operations on a computer cluster. The method includes defining ownership relationships between a plurality of computers in the computer cluster and a plurality of data nodes in the computer cluster, wherein a distributed database management system operation can be directly carried out by a first computer only on those data nodes owned by the first computer. The method further includes monitoring database usage characteristics. The method further includes carrying out a re-architecture step in response to the database usage characteristics by redefining ownership relationships to improve the efficiency of the distributed database management system operations.

Abstract: A system for use with an information retrieval system, in which system is used for transforming a database statement containing a first subquery and a second subquery joined together, the first subquery including a group by operation over a child subquery, the information retrieval system comprising means for removing the first subquery from the database statement thereby eliminating the join between the first subquery and the second subquery.

Abstract: The present invention relates to a charged particle beam apparatus which employs a scanning electron microscope for sample inspection and defect review. The present invent provides solution of improving imaging resolution by utilizing a field emission cathode tip with a large tip radius, applying a large accelerating voltage across ground potential between the cathode and anode, positioning the beam limit aperture before condenser lens, utilizing condenser lens excitation current to optimize image resolution, applying a high tube bias to shorten electron travel time, adopting and modifying SORIL objective lens to ameliorate aberration at large field of view and under electric drifting and reduce the urgency of water cooling objective lens while operating material analysis. The present invent provides solution of improving throughput by utilizing fast scanning ability of SORIL and providing a large voltage difference between sample and detectors.

Abstract: The disclosed network includes two rings, wherein a first ring transmits data in a clockwise direction, and the other ring transmits data in a counterclockwise direction. The traffic is removed from the ring by the destination node. During normal operations (i.e., all spans operational), data between nodes can flow on either ring. Thus, both rings are fully utilized during normal operations. The nodes periodically test the bit error rate of the links (or the error rate is constantly calculated) to detect a fault in one of the links. The detection of such a fault sends a broadcast signal to all nodes to reconfigure a routing table within the node so as to identify the optimum routing of source traffic to the destination node after the fault.

Abstract: In one implementation, a method for sustaining database processing parallelism of one or more parallelized processes to build one or more index pages using pseudo record identifiers (PRIDs) is disclosed. The method comprises generating one or more PRIDs for one or more respective internal record formats (IRFs), inserting said generated PRIDs into a respective index key, generating a relational index of the PRID and a predetermined record identifier (RID) respectively determined in relation to said IRF, and building one or more index pages in relation to the relational index by comparing said RID and said PRID for their respective IRF in said relational index, and determining which one of said RID or said PRID to insert into said index page.

Abstract: Method for handling requests for data stored in database tables is provided. The method includes receiving a request for data stored in a database table, the database table including non-hash and hash columns, a hash column including hash values computed based on non-hash values in at least one non-hash column, generating database queries that are executable to retrieve data stored in the database table satisfying the request, each database query using a different combination of columns in the database table, ranking the database queries based on desirability, determining whether any of the database queries only uses indexed columns, responsive to one or more of the database queries only using indexed columns, selecting a highest ranked of the one or more database queries that only uses indexed columns for execution.

Abstract: A unified architectural diagram that contains links to different kinds of information (a new map) extends the functionality of current standardized development architectural diagrams by linking information to each component of the solution. The new map offers software development processes without architectural diagrams a new centralized, visual representation of every component and process that comprise a large software solution as well as how those components and processes are connected to each other within the solution, offering an opportunity for understanding at an individual level that otherwise would be impractical.

Abstract: A system within a circuit is disclosed. The system comprises a first shield and a device above the first shield. The system also includes a plurality of conductive walls coupled to and extending from the first shield to block electromagnetic (EM) waves to other parts of the circuit. A system and method in accordance with the present invention adds metal walls on the edge of a sliced shield. The walls block the electromagnetic wave from coupling to other parts of the circuit from a sideways direction.

Abstract: A phase-locked loop charge pump driven by low voltage input is disclosed. In one aspect, a charge pump for a phase-locked loop circuit includes a sourcing current source providing a sourcing current, wherein the sourcing current source is coupled to a high-voltage operating voltage supply. A sourcing control circuit uses low-voltage sourcing control signals to selectively cause the charge pump to source the sourcing current to an output of the charge pump. A sinking control circuit uses low-voltage sinking control signals at a low voltage and utilizes a low-swing current mechanism to sink the sinking current from the output of the charge pump. In another aspect, the sourcing control circuit is cascode and the sinking circuit is non-cascode. In another aspect the sourcing current source and the sinking current source are both cascode. In another aspect, the sourcing current source is non-cascode and the sinking current source is cascode.

Abstract: distributed database management system implemented on a cluster of computers. The cluster including disks organized as data nodes. The data nodes being locally connected to one or more computers in the cluster. The distributed database management system includes a distributed database manager layer having a lock manager, a resource manager, and an architecture manager. The lock manager serializes access to the data nodes in the cluster. The resource manager maintains a data representation of the resources of each computer in the cluster and makes the data available to other computers in the cluster to facilitate access to the resources by the other computers. The architecture manager defines logical ownership relationships between data nodes and computers in the cluster to permit the architecture of the database to be dynamically reconfigured to provide improved performance.

Abstract: Sensors for measuring angular acceleration about three mutually orthogonal axes, X, Y, Z or about the combination of these axes are disclosed. The sensor comprises a sensor subassembly. The sensor subassembly further comprises a base which is substantially parallel to the X-Y sensing plane; a proof mass disposed in the X-Y sensing plane and constrained to rotate substantially about the X, and/or Y, and/or Z, by at least one linkage and is responsive to angular accelerations about the X, and/or Y, and/or Z directions. Finally, the sensor includes at least one electrode at the base plate or perpendicular to the base plate and at least one transducer for each sensing direction of the sensor subassembly responsive to the angular acceleration. Multi-axis detection is enabled by adjusting a configuration of flexures and electrodes.

Abstract: A method for implementing a set of database management components in a distributed database management system, the distributed database management system being implemented on a computer cluster. The method includes managing resources associated with an associated computer, the associated computer being one of a plurality of computers in the computer cluster. The method also includes managing locks on data stored on a plurality of associated data nodes coupled to the associated computer, wherein the associated data nodes are data nodes of a plurality of data nodes in the computer cluster. The method also includes specifying logical connections for the plurality of associated data nodes.

Abstract: Systems and methods are disclosed to form a resistive random access memory (RRAM) by forming a first metal electrode layer; depositing an insulator above the metal electrode layer and etching the insulator to expose one or more metal portions; depositing a Pr1-XCaXMnO3 (PCMO) layer above the insulator and the metal portions, wherein X is between approximately 0.3 and approximately 0.5, to form one or more self-aligned RRAM cells above the first metal electrode; and depositing a second metal electrode layer above the PCMO layer.