-
1.发明授权Method and computer program product for implementing translatable text in user modifiable SQL scripts 失效用于在用户可修改的SQL脚本中实现可翻译文本的方法和计算机程序产品公开(公告)号：US06374239B1
公开(公告)日：2002-04-16
申请号：US09248526
申请日：1999-02-09
IPC分类号： G06F1730
CPC分类号： G06F17/30528 , G06F9/454 , Y10S707/99934
摘要： A method and computer program product are provided for implementing translatable text in user modifiable standard query language (SQL) scripts. A set of multiple queries are generated including comments and associated delimited names. The comments and associated delimited names are translated into multiple language versions. A user selected national language is identified. The user selected national language version of the translated comments and associated delimited names are utilized for generating a query. In accordance with features of the invention, the user is given the option to view the query and to make any desired modifications.
摘要翻译： 提供了一种用于在用户可修改的标准查询语言（SQL）脚本中实现可翻译文本的方法和计算机程序产品。 生成一组多个查询，包括注释和关联的分隔名称。 注释和关联的分隔名称被翻译成多种语言版本。 识别用户选择的国家语言。 用户选择翻译的注释和相关联的分隔名称的国家语言版本用于生成查询。 根据本发明的特征，向用户提供查看查询并进行任何所需修改的选项。
-
2.发明授权Method to document relations between objects using a graphical interface tree component 失效使用图形界面树组件记录对象之间关系的方法公开(公告)号：US06842878B1
公开(公告)日：2005-01-11
申请号：US09672044
申请日：2000-09-29
CPC分类号： G06F3/0482 , Y10S715/968
摘要： Logical relationships between objects are displayed using a graphical interface tree component. In a data base application, by selecting and expanding a table node, user can see those views and indexes which are directly related to the table, but not contained within the table, i.e., where there is no physical connection, but there are logical connections (relations). With context menus, the user can make changes in place.
摘要翻译： 使用图形界面树组件显示对象之间的逻辑关系。 在数据库应用中，通过选择和扩展表节点，用户可以看到与表直接相关但不包含在表内的那些视图和索引，即没有物理连接的地方，但是有逻辑连接 （关系）。 使用上下文菜单，用户可以进行更改。
-
公开(公告)号：US08452756B2
公开(公告)日：2013-05-28
申请号：US11558104
申请日：2006-11-09
申请人： Mark John Anderson , Robert Joseph Bestgen , Daniel E. Beuch , Curtis Neal Boger , James Michael Flanagan , Scott Forstie , Shantan Kethireddy , Thomas Owen McKinley , Michael Donald Pfeifer
发明人： Mark John Anderson , Robert Joseph Bestgen , Daniel E. Beuch , Curtis Neal Boger , James Michael Flanagan , Scott Forstie , Shantan Kethireddy , Thomas Owen McKinley , Michael Donald Pfeifer
CPC分类号： G06F17/30471 , G06F17/30306
摘要： A database query optimizer includes an access plan storage mechanism that stores execution detail corresponding to a query statement in an access plan cache. By storing execution detail in the access plan cache along with the query statement, the execution detail is available when needed to debug database problems, even after a problem occurs. The execution detail stored in the access plan cache may be mined and analyzed after-the-fact, producing a very powerful tool for debugging database problems. Snapshots of the execution detail may also be created by a user. In addition, the user may setup autonomic snapshots and comparisons so that a user may be alerted from a degradation in database performance between two snapshots.
摘要翻译： 数据库查询优化器包括访问计划存储机制，其存储与访问计划高速缓存中的查询语句相对应的执行细节。 通过将访问计划高速缓存中的执行详细信息与查询语句一起存储，即使在发生问题后仍需要调试数据库问题，执行细节就可用。 存储在访问计划缓存中的执行细节可以在事后进行挖掘和分析，为调试数据库问题提供了非常强大的工具。 执行细节的快照也可以由用户创建。 此外，用户可以设置自主快照和比较，使得可以从两个快照之间的数据库性能的降级中提醒用户。
-
公开(公告)号：US20080114718A1
公开(公告)日：2008-05-15
申请号：US11558104
申请日：2006-11-09
申请人： Mark John Anderson , Robert Joseph Bestgen , Daniel E. Beuch , Curtis Neal Boger , James Michael Flanagan , Scott Forstie , Shantan Kethireddy , Thomas Owen McKinley , Michael Donald Pfeifer
发明人： Mark John Anderson , Robert Joseph Bestgen , Daniel E. Beuch , Curtis Neal Boger , James Michael Flanagan , Scott Forstie , Shantan Kethireddy , Thomas Owen McKinley , Michael Donald Pfeifer
IPC分类号： G06F17/30
CPC分类号： G06F17/30471 , G06F17/30306
摘要： A database query optimizer includes an access plan storage mechanism that stores execution detail corresponding to a query statement in an access plan cache. By storing execution detail in the access plan cache along with the query statement, the execution detail is available when needed to debug database problems, even after a problem occurs. The execution detail stored in the access plan cache may be mined and analyzed after-the-fact, producing a very powerful tool for debugging database problems. Snapshots of the execution detail may also be created by a user. In addition, the user may setup autonomic snapshots and comparisons so that a user may be alerted from a degradation in database performance between two snapshots.
摘要翻译： 数据库查询优化器包括访问计划存储机制，其存储与访问计划高速缓存中的查询语句相对应的执行细节。 通过将访问计划高速缓存中的执行详细信息与查询语句一起存储，即使在发生问题后仍需要调试数据库问题，执行细节就可用。 存储在访问计划缓存中的执行细节可以在事后进行挖掘和分析，为调试数据库问题提供了非常强大的工具。 执行细节的快照也可以由用户创建。 此外，用户可以设置自主快照和比较，使得可以从两个快照之间的数据库性能的降级中提醒用户。
-
5.发明授权公开(公告)号：US06915298B1
公开(公告)日：2005-07-05
申请号：US09500648
申请日：2000-02-09
CPC分类号： G06F17/30604 , Y10S707/99945 , Y10S715/968
摘要： A schema diagrammer aids a database administrator or other user in maintaining and managing a database in a computer system. The schema diagrammer allows the user to define “user-defined relationships” between objects in the database. The schema diagrammer generates a graphical schema diagram or map that indicates the objects and their relationships to one another. The relationships that are displayed include both the formal relationships defined programmatically by the database itself and the user-defined relationships.
摘要翻译： 模式图表帮助数据库管理员或其他用户在计算机系统中维护和管理数据库。 模式图表允许用户在数据库中的对象之间定义“用户定义的关系”。 模式图表生成一个图形模式图或地图，指示对象及其彼此之间的关系。 显示的关系包括由数据库本身以编程方式定义的形式关系和用户定义的关系。
-
6.发明授权Apparatus and method for generating and displaying a schema diagram for a database 有权用于生成和显示数据库的架构图的装置和方法公开(公告)号：US06978269B1
公开(公告)日：2005-12-20
申请号：US09351793
申请日：1999-07-13
CPC分类号： G06F17/30604
摘要： An apparatus and method for generating and displaying a schema diagram of a database includes a schema diagrammer that automatically queries a database to determine its objects and relationships, and generates a graphical representation of the database in the form of a schema diagram that is displayed to the user. The schema diagrammer may optionally include a search filter to potentially constrain which objects and relationships in the database are included in a diagram data file, and a display filter to potentially constrain which objects and relationships stored in the diagram data file are displayed in the schema diagram.
摘要翻译： 用于生成和显示数据库的模式图的装置和方法包括：模式图表，其自动查询数据库以确定其对象和关系，并且以图形图的形式生成数据库的图形表示，所述模式图显示给 用户。 模式图表可以可选地包括搜索过滤器以潜在地约束数据库中的哪些对象和关系被包括在图表数据文件中，以及显示过滤器以潜在地约束存储在图表数据文件中的哪些对象和关系被显示在模式图中 。
-
7.发明授权Method and apparatus for projecting the effect of maintaining an auxiliary database structure for use in executing database queries 有权用于预测维护辅助数据库结构以用于执行数据库查询的效果的方法和装置公开(公告)号：US07743052B2
公开(公告)日：2010-06-22
申请号：US11353515
申请日：2006-02-14
IPC分类号： G06F7/00
CPC分类号： G06F17/30289 , G06F17/30386
摘要： A database management system maintains a record of queries which can be executed against the database. For a given auxiliary database structure, an advisory function automatically reviews the query record and identifies those queries which might execute with greater efficiency using the auxiliary database structure, presenting analytical information to the user. Preferably, the auxiliary database structure is an index, and the information is used for determining whether to include the index in the database definition. Preferably, a query optimizer records potentially useful indexes when considering multiple alternative database optimizations, and this information is later retrieved to identify queries which would benefit from an index.
摘要翻译： 数据库管理系统维护可以针对数据库执行的查询记录。 对于给定的辅助数据库结构，咨询功能自动审查查询记录，并使用辅助数据库结构识别可能以更高效率执行的查询，向用户呈现分析信息。 优选地，辅助数据库结构是索引，并且该信息用于确定是否将数据包括在数据库定义中。 优选地，当考虑多个备选数据库优化时，查询优化器记录潜在有用的索引，并且稍后检索该信息以识别将从索引中受益的查询。
-
8.发明申请REDUCING INSTABILITY OF A JOB WITHIN A HETEROGENEOUS STREAM PROCESSING APPLICATION 有权降低异构流程处理应用中的作业的不稳定性公开(公告)号：US20090320039A1
公开(公告)日：2009-12-24
申请号：US12145021
申请日：2008-06-24
IPC分类号： G06F9/50
CPC分类号： G06F9/5027 , G06F9/4881 , G06F9/5038 , G06F11/3404
摘要： Embodiments of the invention provide a method for reducing instability in a heterogeneous job plan of a stream processing application. In one embodiment, a job manager may be configured to select a job plan with the objective of minimizing the potential instability of the job plan. Each job plan may provide a directed graph connecting processing elements (both native and non-native). That is, each job plan illustrates data flow through the stream application framework. The job plan may be selected from multiple available job plans, or may be generated by replacing processing elements of a given job plan. Further, the job plan may be selected on the basis of other objectives in addition to an objective of minimizing the potential instability of the job plan, such as minimizing cost, minimizing execution time, minimizing resource usage, etc.
摘要翻译： 本发明的实施例提供了一种用于减少流处理应用的异构作业计划中的不稳定性的方法。 在一个实施例中，作业管理器可以被配置为选择作业计划，目的是最小化作业计划的潜在不稳定性。 每个作业计划可以提供连接处理元件（本机和非本机）的有向图。 也就是说，每个作业计划都说明了通过流应用程序框架的数据流。 可以从多个可用作业计划中选择作业计划，或者可以通过替换给定作业计划的处理元素来生成作业计划。 此外，可以基于其他目标选择作业计划，除了最小化作业计划的潜在不稳定性的目标，例如最小化成本，最小化执行时间，最小化资源使用等。
-
公开(公告)号：US20140033173A1
公开(公告)日：2014-01-30
申请号：US13469409
申请日：2012-05-11
申请人： Andrew Lawrence Frenkiel , Henrique Andrade , Bugra Gedik , Michael Donald Pfeifer , Wim De Pauw
发明人： Andrew Lawrence Frenkiel , Henrique Andrade , Bugra Gedik , Michael Donald Pfeifer , Wim De Pauw
IPC分类号： G06F9/44
摘要： An embodiment of the invention provides a method of displaying a data flow, wherein a description of a data flow application to be displayed is received. The data flow application includes nodes and edges connecting the nodes, wherein the nodes represent operators and the edges represent data connections for data flowing between the operations. A reason that a user is to view the data flow and/or a user constraint on a complexity of the data flow application to be displayed is determined with a processor; and, the time required to render a display of the data flow application is estimated. A transformed representation of the data flow application is created with the processor. The transformed representation is created based upon the user reason, the user constraint, the estimated time of rendering, and/or a layout strategy. The transformed representation is displayed on a graphical user interface.
摘要翻译： 本发明的实施例提供一种显示数据流的方法，其中接收要显示的数据流应用的描述。 数据流应用程序包括连接节点的节点和边缘，其中节点表示运算符，边缘表示在运算之间流动的数据的数据连接。 用处理器确定用户要查看要显示的数据流应用的复杂度的数据流和/或用户约束的原因; 并且估计呈现数据流应用的显示所需的时间。 使用处理器创建数据流应用程序的变换表示。 基于用户原因，用户约束，估计的呈现时间和/或布局策略来创建变换表示。 转换的表示形式显示在图形用户界面上。
-
公开(公告)号：US07584200B2
公开(公告)日：2009-09-01
申请号：US11047535
申请日：2005-01-31
CPC分类号： G06F17/30572 , Y10S707/99942
摘要： Graphical maps of databases and related objects within a database have benefits for a database administrator. Instead of displaying all objects related to a node of interest, a user can select what maximum relation level to use to locate related objects. The mapping software starts at the initial node, or objects, and locates only those related objects that are within the maximum relation level as specified by the user. Only these located objects are displayed thereby producing a clearer and more concise map.
摘要翻译： 数据库中的数据库和相关对象的图形图可以为数据库管理员带来好处。 用户可以选择用于定位相关对象的最大关系级别，而不是显示与感兴趣的节点相关的所有对象。 映射软件从初始节点或对象开始，仅定位用户指定的最大关系级别内的相关对象。 只显示这些位置的对象，从而产生更清晰和更简洁的地图。
-
-
-
-
-
-
-
-
-
搜索结果
18 条记录 (耗时 0.023 秒)
