会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 77. 发明授权
    • SQL-based database system with improved indexing methodology
    • 基于SQL的数据库系统具有改进的索引方法
    • US5918225A
    • 1999-06-29
    • US820864
    • 1997-03-20
    • Peter W. WhiteClark D. FrenchYong Min ChenDavid Yach
    • Peter W. WhiteClark D. FrenchYong Min ChenDavid Yach
    • G06F17/30
    • G06F17/3061G06F17/30324Y10S707/99931Y10S707/99933Y10S707/99934Y10S707/99942
    • A Client/Server Database System with improved methods for performing database queries, particularly DSS-type queries, is described. The system includes one or more Clients (e.g., Terminals or PCs) connected via a Network to a Server. In general operation, Clients store data in and retrieve data from one or more database tables resident on the Server by submitting SQL commands, some of which specify "queries"--criteria for selecting particular records of a table. The system implements methods for storing data vertically (i.e., by column), instead of horizontally (i.e., by row) as is traditionally done. Each column comprises a plurality of "cells" (i.e., column value for a record), which are arranged on a data page in a contiguous fashion. The system builds the value lookup table for tracking unique values in the cells. As additional unique values are inserted into the column of the user's table (i.e., maintained as the row-ordered cell array), the system assigns a small unique integer value to each unique user value. Instead of storing the original (wide) data value into the row-ordered array, the system instead stores the new (narrow) integer number into the row-ordered array. In response to a user request to retrieve a value for a given row number, the system fetches the appropriate chunk of the row-ordered array and retrieves the small integer value. This small integer value is then used to index into the value lookup table, for reconstituting the actual user data.
    • 描述了具有用于执行数据库查询,特别是DSS类型查询的改进方法的客户机/服务器数据库系统。 该系统包括经由网络连接到服务器的一个或多个客户端(例如,终端或PC)。 在一般操作中,客户端通过提交SQL命令将一些或多个数据库表中的数据存储在数据库表中,其中一些指定“查询” - 用于选择表的特定记录的标准。 该系统实现了用于垂直地(即,通过列)来存储数据的方法,而不是如传统地完成的水平(即,按行)。 每列包括以连续方式布置在数据页上的多个“单元”(即,记录的列值)。 系统构建了用于跟踪单元格中唯一值的值查找表。 由于额外的唯一值被插入用户表的列(即,作为行排序的单元阵列维护),系统会为每个唯一用户值分配一个小的唯一整数值​​。 将原始(宽)数据值存储到行排列数组中,而不是将新(窄)整数存储到行排序数组中。 响应于用户请求检索给定行号的值,系统将获取行有序数组的适当块,并检索小整数值。 然后将该小整数值用于索引到值查找表中,以重构实际的用户数据。
    • 78. 发明授权
    • Displaying messages on handheld devices
    • 在手持设备上显示消息
    • US09542073B2
    • 2017-01-10
    • US12969722
    • 2010-12-16
    • Scotte ZinnDavid Yach
    • Scotte ZinnDavid Yach
    • G06F3/14G06F3/0482G06F3/0485H04M1/725
    • G06F3/0485G06F3/0482H04M1/72547
    • A method of displaying messages on handheld devices. The device displays messages in a scrollable viewport of vertically arranged fields. Date separators inserted into the vertically arranged list of messages to enable the user to associate the messages with a date. The date separators have “sticky” operation, meaning that the device ensures a date separator always appears within the viewport, even when the viewport has been scrolled to the middle of a long list of messages all associated with the same date. The device may ensure that the top field of the viewport always contains a date separator associated with the message immediately below.
    • 在手持设备上显示消息的方法。 设备在垂直排列的字段的可滚动视口中显示消息。 日期分隔符插入到垂直排列的消息列表中,以使用户能够将消息与日期相关联。 日期分隔符具有“粘性”操作,这意味着设备确保日期分隔符始终显示在视口中,即使视口已经滚动到与同一日期相关联的长消息列表的中间。 设备可以确保视口的顶部字段始终包含与紧接在下面的消息相关联的日期分隔符。