会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 2. 发明公开
    • PROCESSING PRECOMPUTED VIEWS
    • VERARBEITUNG VON PRECOMPUTERISIERTER SICHT
    • EP1066574A4
    • 2006-09-13
    • EP99914054
    • 1999-03-25
    • IBM
    • COLBY LATHA SCOLE RICHARD LHASLAM EDWARD PJAZAYERI NASIJOHNSON GALTMCKENNA WILLIAM JWILHITE DAVID G JR
    • G06F17/30
    • G06F17/30489G06F17/30312G06F17/30457Y10S707/99932Y10S707/99933Y10S707/99934Y10S707/99943Y10S707/99952
    • A user database query (90) on precomputation strategy effectivenes is responded to by defining, based upon user database query history, an analysis space consisting of a subset of all possible views for the database (104), and by characterizing the views in the analysis space. A structure is imposed on an analysis space consisting of a subset of all possible views for the database based upon the capabilities of a query rewriting facility (92), and the views in the analysis space is characterized. A cost formula is applied to the analysis space based upon a user-defined subset of the data contained in the database. The analysis space includes a candidate view composed of a combination of two or more constituent views is defined. A user query on the database is analyzed, and a candidate view based upon the user query is generated. A system for answering user queries on a database stored on a server includes a query processing system (18) integrated into the server and configured to respond to user queries, and a query processing system integrated into the server and configured to process precomputed results (38) of user queries on the database.
    • 通过基于用户数据库查询历史定义由数据库(104)的所有可能视图的子集构成的分析空间并且通过表征分析中的视图来响应关于预计算策略有效范围的用户数据库查询(90) 空间。 基于查询重写设施(92)的能力将结构强加在由数据库的所有可能视图的子集组成的分析空间上,并且分析空间中的视图被表征。 根据数据库中包含的用户定义的数据子集,将成本公式应用于分析空间。 分析空间包括由两个或更多构成视图的组合组成的候选视图被定义。 分析数据库上的用户查询,并生成基于用户查询的候选视图。 用于回答对存储在服务器上的数据库的用户查询的系统包括集成到服务器中并被配置为响应用户查询的查询处理系统(18),以及集成到服务器中并被配置为处理预先计算结果的查询处理系统(38 )数据库上的用户查询。