会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 54. 发明申请
    • SYSTEMS AND METHODS FOR OPTIMIZING DATABASE QUERIES
    • 优化数据库查询的系统和方法
    • WO2015039072A1
    • 2015-03-19
    • PCT/US2014/055780
    • 2014-09-16
    • MASTERCARD INTERNATIONAL INCORPORATED
    • LONG, Kenneth L.
    • G06F17/30
    • G06F17/30442G06F17/30451G06F17/30584
    • A computer-based method for optimizing database queries is provided. The method uses a server computer device including a processor communicatively coupled to a database. The method includes receiving a main query requesting data from a partitioned database table within the database. The partitioned database table includes a plurality of partitions. The method also includes determining a partition list. The partition list includes two or more partitions of the plurality of partitions and excludes at least one partition of the plurality of partitions. The method further includes generating a plurality of sub-queries where each sub-query is associated with one partition included within the partition list, and processing each sub-query of the plurality of sub-queries on the associated partition included within the partition list.
    • 提供了一种用于优化数据库查询的基于计算机的方法。 该方法使用包括通信地耦合到数据库的处理器的服务器计算机设备。 该方法包括从数据库中的分区数据库表接收请求数据的主查询。 分区数据库表包括多个分区。 该方法还包括确定分区列表。 分区列表包括多个分区中的两个或多个分区,并且排除多个分区中的至少一个分区。 该方法还包括生成多个子查询,其中每个子查询与分区列表中包括的一个分区相关联,以及处理分区列表中包括的关联分区上的多个子查询的每个子查询。
    • 58. 发明申请
    • METHOD AND APPARATUS FOR QUERYING RELATIONAL DATABASES
    • 查询关系数据库的方法和设备
    • WO2003083713A1
    • 2003-10-09
    • PCT/EP2003/003280
    • 2003-03-28
    • LION BIOSCIENCE AGETZOLD, ThureKLEIN, CaroleLUO, JieSEERS, John
    • ETZOLD, ThureKLEIN, CaroleLUO, JieSEERS, John
    • G06F17/30
    • G06F17/30451G06F17/30474
    • The invention provides a method of evaluating a query involving one or more relational databases, each comprising a relational database management system (RDBMS), said query relating to at least two tables of said relational database, said method comprising determining a set of tables, including the tables referred to in the query, wherein each of the tables in said set is linked to at least one other table, such that, in a graphical representation of the database wherein the tables are represented as nodes and links between the tables are represented as lines between the nodes, they form a connected graph connecting nodes corresponding to the tables referred to in the query, performing a query on said set equivalent to the initial query, wherein said step of performing said query on said set comprises performing consecutive partial queries, wherein a result of a previous query is used as input for a later query, combining the results of said partial queries to obtain a result to the initial query. The invention further provides a related data processing system and program.
    • 本发明提供了一种评估涉及一个或多个关系数据库的查询的方法,每个关系数据库包括关系数据库管理系统(RDBMS),所述查询涉及所述关系数据库的至少两个表,所述方法包括确定一组表,包括 在查询中引用的表,其中所述集合中的每个表链接到至少一个其他表,使得在数据库的图形表示中,其中表被表示为节点,并且表之间的链接被表示为 在节点之间,它们形成连接对应于查询中引用的表的节点的连接图,对与初始查询等效的所述集合执行查询,其中在所述集合上执行所述查询的所述步骤包括执行连续的部分查询, 其中将先前查询的结果用作稍后查询的输入,将所述部分查询的结果组合以获得结果给i nitial查询。 本发明还提供了一种相关的数据处理系统和程序。
    • 59. 发明申请
    • A FLEXIBLE VIRTUAL DATABASE SYSTEM INCLUDING A HIERARCHICAL APPLICATION PARAMETER REPOSITORY
    • 灵活的虚拟数据库系统,包括分层应用参数报告
    • WO2002103573A1
    • 2002-12-27
    • PCT/US2002/018910
    • 2002-06-13
    • UBS AGTERVIN, Robert, J.SANTOS, Robert, J.MEI, Shuen
    • TERVIN, Robert, J.SANTOS, Robert, J.MEI, Shuen
    • G06F17/30
    • G06F17/30451
    • A virtual database system is disclosed that provides a flexible number and structure of database tables while using a fixed structure database system as its core. A table set (20), a column set (22), and an association set (24) are defined in an underlying fixed database environment. The data and relationships between these tables are used to define a virtual table (26) with a structure that can be varied as needed by application developers (and users) while the structure of the underlying fixed database remains unchanged. In a particular application, a hierarchical application parameter repository is implemented wherein parameters used by specific applications can be defined at various levels, such as for the application as a whole, for the application as used by a particular group, or as used by a particular user.
    • 公开了一种使用固定结构数据库系统作为核心的数据库表的灵活数量和结构的虚拟数据库系统。 在基础固定数据库环境中定义表集合(20),列集合(22)和关联集合(24)。 这些表之间的数据和关系用于定义一个虚拟表(26),其结构可以由应用程序开发人员(和用户)根据需要进行变化,而底层固定数据库的结构保持不变。 在特定应用中,实现了分级应用参数存储库,其中特定应用所使用的参数可以在各个层次上定义,例如对于整个应用而言,对于特定组所使用的应用或由特定应用使用的特定应用 用户。