公开(公告)号：EP2095218A2

公开(公告)日：2009-09-02

申请号：EP07863710.5

申请日：2007-10-31

申请人： Salesforce.Com, Inc.

发明人： WEISSMAN, Craig ,  MOELLENHOFF, Dave ,  WONG, Simon

IPC分类号： G06F7/00

CPC分类号： G06F17/30442 ,  G06F17/30528 ,  G06F17/30536

摘要： In embodiments, methods and systems for improving a query in a database system are provided. These method and system embodiments can enable greater contextual knowledge about the types and use of data in tables underlying a relational database to be employed. By employing contextual information, embodiments can make recommendations to a query optimizer of a database system based upon knowledge of the data and/or application gathered. Embodiments can be useful in improving query performance in multi- tenant database systems.

公开(公告)号：EP2071478A3

公开(公告)日：2009-07-01

申请号：EP08169659.3

申请日：2008-11-21

申请人： Aisin AW Co., Ltd.

发明人： Kawauchi, Hiroshi ,  Sakai, Takamitsu

IPC分类号： G06F17/30

CPC分类号： G06F17/30241 ,  G06F17/30536

摘要： In a navigation device, three categories, Name, Address, and Genre, can be designated one at a time by using category tabs. Keywords can be input after the category is designated. Logical multiplication is set as a search condition when the keywords belong to different categories. When the keywords belong to the same category, the search condition is set to logical multiplication if the keywords are in a hierarchical relationship and is set to logical addition if the keywords are not in a hierarchical relationship. Where the search condition is logical multiplication, the maximum number of search results is the number of search objects for the keyword that has the fewest search objects, so that number is displayed. Where the search condition is logical addition, the maximum number of search results is the sum of the numbers of the search obj ects for each of the keywords, so that number is displayed.

摘要翻译： 在导航设备中，可以使用分类选项卡一次指定三个类别，名称，地址和流派。 关键字可以在指定类别后输入。 当关键字属于不同的类别时，逻辑乘法被设置为搜索条件。 当关键字属于同一类别时，如果关键字处于分层关系，则搜索条件设置为逻辑乘法，并且如果关键字不处于分层关系，则设置为逻辑相加。 在搜索条件是逻辑乘法的情况下，搜索结果的最大数量是具有最少搜索对象的关键字的搜索对象的数量，以便显示该数字。 在搜索条件是逻辑加法的情况下，搜索结果的最大数量是每个关键字的搜索对象数量的总和，因此显示数量。

公开(公告)号：EP1476826A4

公开(公告)日：2007-11-21

申请号：EP03716051

申请日：2003-02-14

申请人： INFOGLIDE SOFTWARE CORP

发明人： RIPLEY JOHN R

IPC分类号： G06F17/30

CPC分类号： G06F17/30477 ,  G06F17/30536 ,  G06F17/30542 ,  Y10S707/99933 ,  Y10S707/99935 ,  Y10S707/99936 ,  Y10S707/99945

摘要： The invention provides a system and method for defining a schema and sending a query to a Similarity Search Engine to determine a quantitative assessment of the similarity of attributes between an anchor record and one or more target records (Figure 1). The Similarity Search Engine makes a similarity assessment in a single pass through the target records having multiple relationship characteristics. The Similarity Search Engine is a server (190) configuration that comprises a Gateway for command and response routing (110), a Virtual Document Manager (120) for document generation, a Search Manager (130) for document scoring, and an Relational Database Management System (140) for providing data persistence, data retrieval and access to User Defined Functions (145). The Similarity Search Engine uses a unique command syntax based on the Extensible Markup Language to implement functions necessary for similarity searching and scoring.

公开(公告)号：EP1116125A4

公开(公告)日：2007-05-02

申请号：EP99950121

申请日：1999-10-01

申请人： NCR CORP

发明人： MILLER TIMOTHY EDWARD ,  TATE BRIAN DON ,  HILDRETH JAMES DEAN ,  BRYE TODD MICHAEL ,  ROLLINS ANTHONY LOWELL ,  PRICER JAMES EDWARD ,  ANAND TEJ

IPC分类号： G06F17/30 ,  G06F3/14 ,  G06F7/00

CPC分类号： G06F17/30536 ,  G06F17/30445 ,  G06F17/30539 ,  G06F17/30687 ,  G06F2216/03 ,  Y10S707/954 ,  Y10S707/961 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99936 ,  Y10S707/99942 ,  Y10S707/99943

摘要： A method, apparatus, and article of manufacture for performing data mining applications in a relational database management system. At least one analytic algorithm (110) is performed by a computer directly against a relational database (116), wherein the analytic algorithm includes SQL statements performed by the relational database management system (114) and optional programmatic iteration, and the analytic algorithm creates at least one analytic model within an analytic logical data model from data residing in the relational database.

公开(公告)号：EP1665102A2

公开(公告)日：2006-06-07

申请号：EP04784752.0

申请日：2004-09-20

申请人： Salesforce.Com, Inc.

发明人： WEISSMAN, Craig ,  MOELLENHOFF, Dave ,  WONG, Simon ,  NAKADA, Paul

IPC分类号： G06F17/30

CPC分类号： G06F21/6218 ,  G06F17/30442 ,  G06F17/30536 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99938 ,  Y10S707/99939

摘要： More efficient querying of a multi-tenant database using dynamic tuning of database indices. A layer of meta-data associates data items with tenants, e.g., via tags, and the meta-data is used to optimize searches by channeling processing resources during a query to only those pieces of data bearing the relevant tenant's unique tag.

公开(公告)号：EP1548612A1

公开(公告)日：2005-06-29

申请号：EP03029542.2

申请日：2003-12-22

申请人： Software Engineering GmbH

发明人： The designation of the inventor has not yet been filed

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30433 ,  G06F17/30536

摘要： The invention relates to a method, a computer program and a device for providing column statistics for data within a relational database, in particular a DB2 database, for selecting an access path to said data. To aid the DB2 OPTIMIZER in selecting an optimal access path based on actual frequency statistics, the collection of column statistics may be carried out automatically with the steps of collecting database queries to be executed on the database, parse the database queries to create at least one usage matrix comprising at least usage information of certain statements within the database queries, determining from said usage matrix columns within said database for which said columns statistics are useful, and collect said column statistics for said determined columns.

摘要翻译： 本发明涉及一种方法，一种计算机程序和用于提供列统计数据的关系数据库内，特别是DB2数据库，用于选择访问所述数据路径的装置。 为了帮助DB2优化器基于实际频率的统计数据选择最佳的访问路径，列统计信息的收集，可以自动收集数据库查询数据库上执行的步骤进行，解析数据库查询，以创建至少一个 使用矩阵包括在数据库查询中的某些语句至少使用信息，所述数据库内所说的使用矩阵列确定性开采其中所说的列的统计信息是有用的，并收集上述列的统计数据说确定性开采列。

公开(公告)号：EP0868699B1

公开(公告)日：2000-09-27

申请号：EP96944107.0

申请日：1996-12-16

申请人： BRITISH TELECOMMUNICATIONS public limited company

发明人： LENZIE, Robert, S.

IPC分类号： G06F17/30

CPC分类号： G06F17/30536 ,  G06F17/30336 ,  Y10S707/99942 ,  Y10S707/99945

摘要： An index set for a database is specified by analysing a sample (718) of SQL statements applied to the database (701). Indexes (707) are identified that could assist in the execution of the analysed statements and levels of improved operation are evaluated for each of said indexes. The evaluated levels are then processed (708) to specify an index set for inclusion on the database. The database may not include sufficient storage (702) for all of the specified indexes to be included, therefore the available storage space is allocated and indexes are selected on a prioritized basis.

公开(公告)号：EP0877325A1

公开(公告)日：1998-11-11

申请号：EP98302669.1

申请日：1998-04-06

申请人： AT&T Corp.

发明人： Faloutsos, Christos N. ,  Jagadish, Hosagrahar Visvesvaraya ,  Korm, Philip Russell

IPC分类号： G06F17/30

CPC分类号： G06F17/30536 ,  G06F17/30592 ,  G06K9/6247 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99942

摘要： A method and system for compressing a data base (12) that permits queries on the compressed representation (14) of the data base. Another feature is that an approximation of the values of the data base are derivable directly from the compressed representation (14) of the data base. Yet another feature is correction of poor approximations of the reconstructed data. Still another feature is the capability of performing aggregate queries of the compressed representation (14) of the data base.

摘要翻译： 一种用于压缩允许对数据库的压缩表示（14）进行查询的数据库（12）的方法和系统。 另一个特征是可以直接从数据库的压缩表示（14）导出数据库的值的近似。 另一个特征是校正重建​​数据的差的近似。 另一个特征是执行数据库的压缩表示（14）的聚合查询的能力。

公开(公告)号：EP0856802A2

公开(公告)日：1998-08-05

申请号：EP98200178.6

申请日：1998-01-23

申请人： Informix Software, Inc.

发明人： Friedman, Paul ,  Smedberg, Michael

IPC分类号： G06F17/30

CPC分类号： G06F17/30536 ,  Y10S707/99933 ,  Y10S707/99935

摘要： In a computer-implemented method for generating a response to an aggregate query request on a source database, a random sample of records is extracted from the source database to generate a sample database. Then an aggregate query is performed on the sample database to generate a sample result, and an estimate of the aggregate query request on the source database is derived from the sample result.

摘要翻译： 在用于生成对源数据库上的聚合查询请求的响应的计算机实现的方法中，从源数据库中提取随机的记录样本以生成样本数据库。 然后在样本数据库上执行聚合查询以生成样本结果，并从样本结果导出源数据库上的聚合查询请求的估计。

公开(公告)号：EP3231484A4

公开(公告)日：2018-07-11

申请号：EP15866649

申请日：2015-08-28

申请人： SONY CORP

发明人： KOSHIDA OSAMU ,  ISHII TAMOTSU ,  SUKI YASUYUKI

IPC分类号： A63B69/00 ,  A63B24/00 ,  A63B71/06 ,  G06F17/30 ,  G16H20/30

CPC分类号： A63B24/0006 ,  A63B24/0062 ,  A63B69/00 ,  A63B71/06 ,  A63B2024/0068 ,  G06F17/30536 ,  G06F19/00 ,  G16H20/30

摘要： [Object] To propose a novel and improved program and information processing system that can perform feedback in accordance with a history of exercise of the user. [Solution] Provided is a program causing a computer to function as an acquirer configured to acquire information indicating an exercise state of a user, a storage controller configured to allow the information indicating the exercise state acquired by the acquirer to be stored, and an output controller configured to allow provision information that is to be provided to the user to be output, the provision information being generated on the basis of a history of the information indicating the exercise state stored by the storage controller.