会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 7. 发明授权
    • Sorted-paged retrieval of hierarchical data from relational databases
    • 从关系数据库对分级数据进行排序分页检索
    • US06898593B1
    • 2005-05-24
    • US10072399
    • 2002-02-05
    • Ramkartik MulukutlaHaiying Wang
    • Ramkartik MulukutlaHaiying Wang
    • G06F17/30
    • G06F17/30607G06F17/30466G06F17/30498Y10S707/99933Y10S707/99943
    • A method for sorted-paged retrieval of hierarchical data from a relational database is disclosed, which includes the use of one or more relational table equi-join terms in a query to increase the retrieval efficiency, suitable restrictions imposed on the join terms to further increase the retrieval efficiency, partial de-normalization or replication of information to improve the efficiency of the join operation(s) and thus further increase the retrieval efficiency, and proper cursor management to keep track of the current location of the cursor(s) involved. As a result, specific pages of objects can be efficiently retrieved from a database, while the specified sort orders and restrictions imposed by the original retrieval requests can be maintained.
    • 公开了一种从关系数据库对分级数据进行分层分页检索的方法,其中包括在查询中使用一个或多个关系表等连接项来提高检索效率,对连接项施加的适当限制进一步增加 检索效率,部分解除规范化或复制信息,以提高联合操作的效率,从而进一步提高检索效率,以及适当的光标管理来跟踪所涉及的光标的当前位置。 因此,可以从数据库中有效地检索对象的特定页面,同时可以保持由原始检索请求强加的指定排序顺序和限制。