会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 2. 发明申请
    • MAINTAINING DATE AND TIME WITH TIME ZONE RULE CHANGES
    • 保持日期和时间与时区规则更改
    • US20090193048A1
    • 2009-07-30
    • US12020742
    • 2008-01-28
    • Amar NallaSrikanth R. AvadhanamEdvardas V. BudrysGandhinath SwaminathanVijay B. Kurup
    • Amar NallaSrikanth R. AvadhanamEdvardas V. BudrysGandhinath SwaminathanVijay B. Kurup
    • G06F7/00
    • G06Q10/1091
    • A method and system for maintaining date and time information correctly across rule changes for time zones is provided. A time maintenance system provides rules for converting dates and times between various time zones and a common time zone. When the time maintenance system receives a date and time in a designated time zone, it converts the date and time to a date and time in the common time zone based on a provided rule. The time maintenance system then stores the converted date and time along with an identification of the rule used to convert the date and time to the common time zone. The time maintenance system may then receive an indication of an overriding rule that overrides an existing rule for converting a date and time between the designated time zone and the current time zone. The time maintenance system then updates the stored date and time when the rule has been overridden in such a way as to indicate that the original date and time is no longer correct and to indicate the new rule.
    • 提供了一种用于在时区的规则更改中正确保持日期和时间信息的方法和系统。 时间维护系统提供用于转换不同时区与公共时区之间的日期和时间的规则。 当时间维护系统在指定的时区收到日期和时间时,会根据提供的规则将日期和时间转换为公共时区的日期和时间。 时间维护系统然后存储转换的日期和时间以及用于将日期和时间转换为公共时区的规则的标识。 时间维护系统然后可以接收覆盖用于转换指定时区和当前时区之间的日期和时间的现有规则的优先规则的指示。 时间维护系统然后更新存储的日期和时间,当规则被覆盖时,以指示原始日期和时间不再正确并指示新规则的方式。
    • 6. 发明授权
    • Query planning using a maxdiff histogram
    • 使用maxdiff直方图进行查询计划
    • US06714938B1
    • 2004-03-30
    • US09652942
    • 2000-08-31
    • Srikanth R. AvadhanamNigel R. Ellis
    • Srikanth R. AvadhanamNigel R. Ellis
    • G06F1730
    • G06F17/30463G06F17/30536Y10S707/99931Y10S707/99932Y10S707/99933Y10S707/99943
    • Systems and methods create and maintain a maxdiff histogram for use in determining query costs. One aspect of the system is a data structure that provides fields that can be used to accurately represent a distribution of data regardless of the uniformity or lack thereof of the data. The fields of the data structure represent buckets in the histogram. The fields include a range_Hi_Key field indicating the upper bound for values represented by the bucket. The range_Hi_Key field is also the most frequently occurring value in the bucket. In addition, the fields include a cardEQ field representing the count of the most frequently occurring value, a cardLT field, which is the count of the values in the bucket that are less than the range_Hi_Key field, a LTDistinct field, which is a count of the number of distinct values represented by the bucket, and an LTDensity field, which is an average count for each of the attribute values in the bucket that are not the range_Hi_Key value. A further aspect is a method that creates and maintains the maxdiff histogram data structure. The method starts by creating a list of unused buckets. An input stream of attribute values is sorted and the following acts are performed for each value. If the new value is the same as the previous value, the cardEQ field is incremented. If not, the method checks to see if the histogram is full. If a bucket is available, it is allocated and the bucket fields are initialized. If a bucket is not available, the two buckets that have the least variance between them are merged into one bucket, and the freed bucket is made available for the newly read input value. Whenever a new bucket is created or altered, the variance between the bucket and its neighbors is recalculated.
    • 系统和方法创建和维护maxdiff直方图,用于确定查询成本。 该系统的一个方面是提供可用于精确地表示数据分布的字段的数据结构,而不管数据的均匀性或缺乏。 数据结构的字段表示直方图中的桶。 这些字段包括一个range_Hi_Key字段,指示由桶表示的值的上限。 range_Hi_Key字段也是存储桶中最常出现的值。 另外,这些字段包括表示最常出现的值的计数的cardEQ字段,作为小于range_Hi_Key字段的桶中的值的计数的cardLT字段,该字段是 由桶表示的不同值的数量和LTDensity字段,它是桶中每个属性值不是range_Hi_Key值的平均值。 另一方面是创建并维护maxdiff直方图数据结构的方法。 该方法从创建未使用的桶的列表开始。 排序属性值的输入流,并对每个值执行以下动作。 如果新值与上一个值相同,则cardEQ字段递增。 如果没有,该方法将检查直方图是否已满。 如果桶可用,则分配桶,并对桶区进行初始化。 如果一个存储桶不可用,那么它们之间差异最小的两个存储区将被合并到一个存储区中,并且释放的存储桶可用于新读取的输入值。 每当创建或更改新的桶时,重新计算桶与其邻居之间的差异。