Method and system for translating an ad-hoc query language using common
table expressions
    2.
    发明授权
    Method and system for translating an ad-hoc query language using common table expressions 失效
    使用常用表格表达式翻译即席查询语言的方法和系统

    公开(公告)号:US6128612A

    公开(公告)日:2000-10-03

    申请号:US106968

    申请日:1998-06-30

    IPC分类号: G06F17/30

    摘要: A method and data processing system are disclosed for translating an ad-hoc user input string into Structured Query Language. A user input string is parsed placing joiner objects and left parentheses into a temporary pushdown stack and placing query clause objects into a postfix queue. After encountering a query clause object or a right parenthesis, the next item in the pushdown stack is placed in the postfix queue if it is a joiner object. Once the input string is parsed, objects in the postfix queue are placed into a second temporary pushdown stack and also used to form common table expressions using adjacent items in the second pushdown stack. Finally, an SQL SELECT statement is formed using a JOIN on the ids returned by the common table expressions.

    摘要翻译: 公开了用于将自组织用户输入字符串转换成结构化查询语言的方法和数据处理系统。 解析用户输入字符串,将joiner对象和左括号放入临时下推栈中,并将查询子句对象放入后缀队列中。 在遇到查询子句对象或右括号后,如果它是一个连接器对象,则下推栈中的下一个项目将被放置在后缀队列中。 一旦解析了输入字符串,后缀队列中的对象将被放置到第二个临时下推栈中,并且还用于使用第二个下推栈中的相邻项形成公用表表达式。 最后,使用公共表表达式返回的ids上的JOIN形成SQL SELECT语句。

    Method and system for remapping an existing database to a new database
system
    3.
    发明授权
    Method and system for remapping an existing database to a new database system 失效
    将现有数据库重新映射到新数据库系统的方法和系统

    公开(公告)号:US5787433A

    公开(公告)日:1998-07-28

    申请号:US818407

    申请日:1997-03-17

    IPC分类号: G06F17/30

    摘要: When migrating legacy database systems to a new database system the relationships between tables need to be preserved. Also, base tables and their children have to maintain their relationship. A database system which creates a system generated unique key is stored with the data which is loaded. To enable load, search, and retrieval to be efficient a data remapping function is defined which uses the system generated key to maintain the relationships which were maintained by a unique key in the legacy systems.

    摘要翻译: 将旧数据库系统迁移到新的数据库系统时,需要保留表之间的关系。 此外,基桌和他们的孩子必须保持他们的关系。 创建系统生成的唯一密钥的数据库系统与加载的数据一起存储。 为了使加载,搜索和检索更有效,定义了使用系统生成的密钥来维护遗留系统中由唯一密钥维护的关系的数据重映射功能。

    Method and system for facilitating the selection of icons
    7.
    发明授权
    Method and system for facilitating the selection of icons 失效
    促进图标选择的方法和系统

    公开(公告)号:US5740390A

    公开(公告)日:1998-04-14

    申请号:US715158

    申请日:1996-09-17

    摘要: A method and system for facilitating the selection of one or more of a plurality of icons located on a computer display. A selection is made, from a plurality of icons, of one or more icons to announce itself, such that one or more selected icons is provided. Each of the one or more selected icons makes an announcement. In one example, the announcement includes a designation of the icon making the announcement. Further, the announcement may include sound or a display on the computer display. In one embodiment, in order to select the one or more icons to announce itself, a location of a cursor positioned on the computer display is determined and a further determination is made as to which of the plurality of icons are within a predetermined distance from the location. Those icons within the predetermined distance are the selected icons.

    摘要翻译: 一种用于便于选择位于计算机显示器上的多个图标中的一个或多个的方法和系统。 从多个图标中选择一个或多个图标来宣布自己,使得提供一个或多个所选择的图标。 一个或多个所选择的图标中的每一个发出通知。 在一个示例中,该公告包括作出公告的图标的指定。 此外,该通知可以包括计算机显示器上的声音或显示。 在一个实施例中,为了选择一个或多个图标来宣布自己,确定位于计算机显示器上的光标的位置,并进一步确定多个图标中的哪一个在距离 位置。 预定距离内的图标是所选择的图标。

    Application-aware system that dynamically partitions and allocates resources on demand
    9.
    发明授权
    Application-aware system that dynamically partitions and allocates resources on demand 有权
    根据需要动态分区和分配资源的应用感知系统

    公开(公告)号:US07430741B2

    公开(公告)日:2008-09-30

    申请号:US10761184

    申请日:2004-01-20

    IPC分类号: G06F9/46 G06F15/173

    CPC分类号: G06F9/50 G06F9/5016

    摘要: The present invention is an application-aware method for allocating resources to applications based on a set of predefined policies comprising a Resource Allocation Program (RAP). The RAP is application-aware in that the RAP does not arbitrarily allocate resources to requesting applications. Instead, the RAP allocates resources to requesting applications based on predefined policies. The RAP allows a user to define the resource allocation for each policy in a Resource Allocation Table and associate the applications with the policies in a Policy Application Table. When an application requests resources, the RAP looks to the Policy Allocation Table to determine the policy associated with the application and looks to the Resource Allocation Table to determine the permissible amount of resources to allocate to the application associated with the policy. The RAP then allocates the resources to the requesting application.

    摘要翻译: 本发明是一种用于基于包括资源分配程序(RAP)的一组预定义策略向应用分配资源的应用感知方法。 RAP是应用程序感知的,因为RAP不会将资源任意分配给请求的应用程序。 相反,RAP会根据预定义的策略为请求的应用程序分配资源。 RAP允许用户为资源分配表中的每个策略定义资源分配,并将应用程序与策略应用程序表中的策略相关联。 当应用程序请求资源时,RAP查找策略分配表以确定与应用程序相关联的策略,并查看资源分配表,以确定分配给与策略关联的应用程序的资源的允许量。 RAP然后将资源分配给请求的应用程序。

    Method and system for automatically consolidating icons into a master
icon
    10.
    发明授权
    Method and system for automatically consolidating icons into a master icon 失效
    自动将图标整合为主图标的方法和系统

    公开(公告)号:US5760774A

    公开(公告)日:1998-06-02

    申请号:US951868

    申请日:1997-10-16

    摘要: A method and system for facilitating the selection of icons. Those icons which are next likely to be used are selected and automatically moved towards a cursor thereby facilitating selection of the icons. Additionally, those icons likely to be used or other icons selected by a user may track the cursor such that those icons are always close to the cursor and capable of being easily selected. Further, in order to facilitate selection of icons, icons are provided with the capability of announcing themselves when a cursor comes close to the icon. In addition, it is possible to reduce the amount of clutter on a computer display so that icons may be easily selected. In order to clean up a computer display, icons which are least likely to be used are faded, eliminated or shrunk to a smaller size. In another embodiment, icons that are not used very often may disappear into a master icon and further, icons which have a conceptual relationship between them may be linked by a visual graphical representation.

    摘要翻译: 一种便于选择图标的方法和系统。 接下来可能使用的那些图标被选择并且自动地朝向光标移动,从而便于图标的选择。 此外,可能使用的图标或用户选择的其他图标可以跟踪光标,使得这些图标总是靠近光标并且能够被容易地选择。 此外,为了便于图标的选择,图标具有当光标靠近图标时宣布自己的能力。 此外,可以减少计算机显示器上的杂波量,从而可以容易地选择图标。 为了清理计算机显示器,最不可能使用的图标褪色,消除或缩小到较小的尺寸。 在另一个实施例中,经常不被使用的图标可能消失在主图标中,并且进一步地,它们之间具有概念关系的图标可以通过视觉图形表示来链接。