Eugene I. Chong - Concord MA Souripriya Das - Nashua NH Charles G. Freiwald - Amherst NH Aravind Yalamanchi - Nashua NH Ramkumar Krishnan - Nashua NH Jagannathan Srinivasan - Nashua NH
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 1730
US Classification:
707100
Abstract:
A database system having logical row identifiers (rowids) includes a secondary index which is traversed to locate a secondary index entry that includes a target secondary key value. Each secondary index entry also includes a logical rowid element. Each logical rowid element has both a primary key value element, and a datablock address element identifying a leaf block in an index-organized table that likely includes a row corresponding to the primary key value element. The leaf block is scanned to locate the row in the index-organized table that includes the target secondary key value and corresponds with the located, secondary index entry. A primary key scan is performed on the index-organized table if the row in the index-organized table is not located in the identified datablock.
Mapping Logical Row Identifiers For Primary B+Tree-Like Structures To Physical Row Identifiers
Eugene I. Chong - Concord MA, US Jagannathan Srinivasan - Nashua NH, US Souripriya Das - Nashua NH, US Charles G. Freiwald - Amherst NH, US Aravind Yalamanchi - Nashua NH, US Mahesh Jagannath - Burlington MA, US Anh-Tuan Tran - Vacaville CA, US Ramkumar Krishnan - Nashua NH, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F017/30
US Classification:
707101, 707102, 707 3
Abstract:
A mapping mechanism for a primary B+tree in a database management system. The primary B+tree includes a plurality of rows. The mapping mechanism includes introducing a mapping table that includes a plurality of rows, including a row for each row of the primary B+tree, and that stores the logical identifier of the corresponding primary B+tree row. In addition, reverse mapping is provided by augmenting a primary B+tree to include in each primary B+tree row a physical row identifier of the corresponding mapping table row. An auxiliary structure created on a primary B+tree can make use of the proposed mapping mechanism. Specifically, the auxiliary structures refers to primary B+tree rows indirectly by storing the physical row identifier of the corresponding mapping table row.
Fast Response Dual Stiffened Mode Isolator And Method Thereof
Darren Chao - Norwood MA, US Hamid Shaidani - Randolph MA, US Ramkumar Krishnan - Watertown MA, US
International Classification:
F16F 9/50 B23P 17/04 F16M 11/00
US Classification:
248550, 1882662, 2989009
Abstract:
A fast response, dual stiffness mode isolator including a flexible diaphragm for an isolation piston, a first chamber supporting the flexible diaphragm, a second chamber serving as a reservoir, and a valve connected to a supply, to the first chamber, and to the second chamber and operable to by-pass the second chamber to more quickly direct the supply to the first chamber.
Darren Chao - Norwood MA, US Hamid Shaidani - Randolph MA, US Ramkumar Krishnan - Watertown MA, US
International Classification:
F16M 11/00
US Classification:
248550
Abstract:
An isolation system includes a platform, a plurality of isolators for the platform electronically switchable between a soft mode of isolation resulting in a first natural frequency and a stiff mode of isolation resulting in a second natural frequency, and a controller responsive to a signal representing the frequency of a machine on the platform and configured to switch the isolator to the stiff mode of operation when the frequency of the machine approaches or reaches, the first natural frequency to avoid resonance magnification, and otherwise switch the isolation to the soft mode of operation.
Rajagopalan Govindarajan - Fremont CA Susan Kotsovolos - Belmont CA Ramkumar Krishnan - Nashua NH Joyo Wijaya - Menlo Park CA
Assignee:
Oracle Corporation - Redwood Shores CA
International Classification:
G06F 1730
US Classification:
707103
Abstract:
A method, system and computer-readable medium is provided for grouping database objects into logical groupings in order to simplify administrative and other operations that need to be performed by the database server. Such operations can be performed once at the logical group level for a group of related objects, as opposed to at the individual database object level. For increased flexibility, the logical groupings need not dictate the format, schema or location of their members. A hierarchy may be established between the logical groupings, where child groupings inherit some or all of the properties of the parent groupings. A correspondence may be established between some groupings and operating system directories, allowing identifiers associated with the groupings to be used as aliases for the full operating system paths to the corresponding directories.
Device And Industrial Package For Storing, Measuring And Dispensing Powder And Granular Substances
Yury Sherman - Roslindale MA, US Michael Sherman - Newton MA, US Ilya Alexandrov - Natick MA, US Ramkumar Krishnan - Watertown MA, US
International Classification:
A47G 19/24 G01F 15/00 G01F 13/00
Abstract:
The invention is directed to a hand operated device for storing, measuring and dispensing of powder or granular materials, with effectively simplified structure and reduced number of parts, having a solid housing integrating material storage container with stationer parts of a dispenser, comprising: special compartments and sound damper, made of elastic porous material that makes work of the device quite and thus acceptable for users; a means for one touch assembly and disassembly of an inner space of the device where a dispenser is located; structural elements for dispensing a predetermined volume of the material or its fraction, including stopping means for reduction of length of working stroke of the dispensing mechanism; a means making the device reliable when it is used with materials including sticky particles; a means providing the device configured to delivery more then one material stored in one device, including more then one material transporting mechanisms inside the dispenser; and structural elements providing exact measuring, and sifting or pouring of the materials.