会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 94. 发明授权
    • Grouping and duplicate removal method in a database
    • 在数据库中分组和重复删除方法
    • US06381601B1
    • 2002-04-30
    • US09469615
    • 1999-12-22
    • Shinji FujiwaraKazutomo UshijimaItaru Nishizawa
    • Shinji FujiwaraKazutomo UshijimaItaru Nishizawa
    • G06F1730
    • G06F17/30489Y10S707/954Y10S707/99937
    • In order to realize high speed process for grouping the records having the identical values of one or more columns of the input list, the input list is canned, a hash value is generated using a hash function in which a value of the column as the non-vacant partial aggregation of the columns for the grouping is used as the argument, and it is determined whether two or more records having the hash values exist or not. The input list is scanned again and the calculating process of the aggregation columns is immediately executed for the records having the hash value for which it is determined by the first scanning that there is only one record having the identical hash value, the result of such calculating process is output and the records are defined as the input of the ordinary grouping process for the records which are determined to exist as the two or more records.
    • 为了实现用于对具有输入列表的一个或多个列的相同值的记录进行分组的高速处理,输入列表被装入,使用散列函数生成哈希值,其中列的值为非 用于分组的列的消除性部分聚合用作参数,并且确定是否存在具有哈希值的两个或更多个记录。 再次对输入列表进行扫描,并且立即对具有通过第一次扫描确定的散列值的记录执行聚合列的计算处理,即只有一个具有相同散列值的记录,这样计算的结果 处理被输出,并且记录被定义为被确定作为两个或更多个记录存在的记录的普通分组处理的输入。
    • 96. 发明授权
    • Random sampling method for use in a database processing system and a
database processing system based thereon
    • 用于数据库处理系统的随机抽样方法和基于其的数据库处理系统
    • US5890150A
    • 1999-03-30
    • US12207
    • 1998-01-23
    • Kazutomo UshijimaShinji FujiwaraKazuo MasaiYori TakahashiItaru Nishizawa
    • Kazutomo UshijimaShinji FujiwaraKazuo MasaiYori TakahashiItaru Nishizawa
    • G06F17/30
    • G06F17/30536Y10S707/99933Y10S707/99934Y10S707/99935
    • A query issue processing method, a query conversion processing method, and a data control processing method are provided for enhancing the efficiency of random sampling processing for use in a database processing system. In query issue processing 2, a query including random sampling processing is issued. In query conversion processing 8, application sequences of random sampling processing and another query processing are exchanged by considering a sampling unit of the random sampling processing. Further, in record control processing 4, random access to a secondary storage device is reduced, thereby enhancing random sampling processing efficiency. Unlike the conventional query conversion processing not considering the sampling unit, the issuance of the query including random sampling processing and performing query conversion by considering the sampling unit allow random sampling to be applied also to a query including aggregation processing, thereby enhancing the efficiency of queries in a wider range. Reduction in the random access to the secondary storage device further enhances that efficiency.
    • 提供了一种查询问题处理方法,查询转换处理方法和数据控制处理方法,用于提高在数据库处理系统中使用的随机抽样处理的效率。 在查询问题处理2中,发出包括随机抽样处理的查询。 在查询转换处理8中,通过考虑随机抽样处理的抽样单位来交换随机抽样处理和另一查询处理的应用程序。 此外,在记录控制处理4中,减少对二次存储装置的随机访问,从而提高随机抽样处理效率。 与不考虑采样单元的常规查询转换处理不同,通过考虑采样单元来执行随机抽样处理和执行查询转换的查询的发布允许随机抽样也适用于包括聚合处理的查询,从而提高查询的效率 在更广泛的范围。 减少对二次存储设备的随机访问进一步提高了该效率。
    • 97. 发明授权
    • Closed rotary compressor
    • 闭式旋转式压缩机
    • US5518381A
    • 1996-05-21
    • US361031
    • 1994-12-21
    • Hiroshi MatsunagaShinji FujiwaraHirotsugu FukuokaKeisuke MoritaYasuhiko Sano
    • Hiroshi MatsunagaShinji FujiwaraHirotsugu FukuokaKeisuke MoritaYasuhiko Sano
    • F04C18/02F04C23/00F04C29/02F01C21/04
    • F04C29/02F04C23/001F04C2210/26
    • A closed rotary compressor includes a generally cylindrical sealed vessel having an oil sump defined therein for accommodating a quantity of lubricating oil, a drive unit housed within the sealed vessel and having a drive motor and a shaft driven by the drive motor, and a compressor mechanism housed within the sealed vessel. The compressor mechanism is provided with at least one set of compression elements. This set of compression elements is made up of a cylinder having a compression compartment and a refrigerant intake port both defined therein in communication with each other, first and second bearings secured to the lower and upper end surfaces of the cylinder, respectively, for rotatably supporting the shaft, a crank provided on the shaft for rotation together therewith, a ring-shaped roller encircling the crank and capable of undergoing a planetary motion in contact with the crank during rotation of the crank, and a radial vane slidably accommodated in the cylinder for reciprocating movement in a direction radially of the cylinder. The radial vane has a radial inner end held in sliding contact with an outer peripheral surface of the ring-shaped roller, to thereby divide the compression compartment into a suction chamber and a compression chamber. An oil passage is provided in the compressor mechanism to place the oil sump in communication with the refrigerant intake port. The oil passage has a throttled portion at a location adjacent to the refrigerant intake port.
    • 封闭的旋转压缩机包括:大致圆柱形的密封容器,其具有限定在其中的用于容纳一定数量的润滑油的油底壳;容纳在密封容器内的驱动单元,具有驱动马达和由驱动马达驱动的轴;压缩机构 容纳在密封容器内。 压缩机构具有至少一组压缩元件。 这组压缩元件由具有压缩室和两个限定在其中彼此连通的制冷剂吸入口的气缸组成,第一和第二轴承分别固定在气缸的下端面和上端面上,用于可旋转地支撑 所述轴,设置在所述轴上以与之一起旋转的曲柄,环绕所述曲柄的环形辊,并且能够在所述曲柄旋转期间经历与所述曲柄接触的行星运动,以及可滑动地容纳在所述气缸中的径向叶片, 在圆筒的径向的往复运动。 径向叶片具有与环形辊的外周面滑动接触的径向内端,从而将压缩室分成吸入室和压缩室。 在压缩机构中设置油路,将油底壳与制冷剂吸入口连通。 油路在与制冷剂进气口相邻的位置处具有节流部分。
    • 98. 发明授权
    • Parallel database processing system and retrieval method using secondary
key
    • 并行数据库处理系统和使用次级密钥的检索方法
    • US5515531A
    • 1996-05-07
    • US69193
    • 1993-05-28
    • Shinji FujiwaraMitsuru NagasakaYooichi Shintani
    • Shinji FujiwaraMitsuru NagasakaYooichi Shintani
    • G06F12/00G06F17/30
    • G06F17/30321G06F17/30433Y10S707/99933
    • A parallel database processing system a global database processing unit, a plurality of local database processing units, and a network interconnecting the global database processing unit and a plurality of local database processing units, wherein one table containing a number of records is partitioned into local tables, each local table being provided in a corresponding one of the local database processing units, secondary key indexes representing correspondence between the values of secondary keys for all records in the table and access information to the records corresponding to the secondary keys, are partitioned on the basis of the values into local secondary key indexes, each set of the local secondary key indexes being provided in a corresponding one of the local database processing units, and an identifying unit is provided in the global database processing unit, the identifying unit responsive to a retrieval request with the secondary key identifying the local database processing unit having the local secondary key index corresponding to the secondary key. At the global database processing unit, the retrieval request with the secondary key is received, the identifying unit identifies the local database processing unit having the local secondary key index corresponding to the secondary key, and the retrieval request with the secondary key is transferred to the identified local database processing unit. At the identified local database processing unit, its own local secondary key indexes are referred to obtain access information corresponding to the transferred retrieval request with the secondary key, and the retrieval request with the secondary key is processed by using the access information so that the local table corresponding to the retrieval request with the secondary key is accessed.
    • 并行数据库处理系统,全局数据库处理单元,多个本地数据库处理单元,以及互连全球数据库处理单元和多个本地数据库处理单元的网络,其中包含多个记录的一个表被划分为本地表 每个本地表被提供在本地数据库处理单元中的对应的一个中,表示对于表中的所有记录的辅助键的值之间的对应关系的次要密钥索引以及对应于次要密钥的记录的访问信息被划分在 将所述值作为本地二次密钥索引的基础,在本地数据库处理单元中相应的一个本地数据库处理单元中提供每组本地辅助密钥索引,并且在全局数据库处理单元中提供识别单元,所述识别单元响应于 检索请求与辅助键标识本地数据库进程 具有对应于次要密钥的本地次要密钥索引的单元。 在全局数据库处理单元处,接收到具有辅助密钥的检索请求,识别单元识别具有与次密钥对应的本地次要密钥索引的本地数据库处理单元,并且将具有辅助密钥的检索请求传送到 识别本地数据库处理单元。 在所识别的本地数据库处理单元,其自身的本地次要密钥索引被引用以获得与所传送的检索请求相对应的与辅助密钥相关的访问信息,并且通过使用访问信息来处理具有辅助密钥的检索请求,使得本地 访问与辅助密钥的检索请求对应的表。