Method and system for converting a schema-based hierarchical data structure into a flat data structure
    2.
    发明授权
    Method and system for converting a schema-based hierarchical data structure into a flat data structure 失效
    用于将基于模式的分层数据结构转换为平面数据结构的方法和系统

    公开(公告)号:US08051373B2

    公开(公告)日:2011-11-01

    申请号:US11326892

    申请日:2006-01-06

    IPC分类号: G06F17/00

    摘要: A method and system are provided for converting a hierarchical data structure into a flat data structure based on a schema. The format of the hierarchical data structure may be XML. A hierarchical data structure conforming to a schema is loaded into an application program. The data structure includes elements and attributes linked together in a parent-child relationship. The schema defines the hierarchical relationships between the elements and attributes in the hierarchical data structure. After the hierarchical data structure conforming to the schema has been loaded, a plurality of layout rules is applied to the hierarchical data based on the schema to create a flat data structure. The layout rules determine how the hierarchical data will be inserted in the flat data structure. The layout rules may be applied by identifying properties in the schema which identify occurrence requirements for elements defined in the schema. After the layout rules have been applied to the hierarchical data, the hierarchical data is rendered into a spreadsheet by inserting the data in rows and columns.

    摘要翻译: 提供了一种基于模式将层次数据结构转换为平面数据结构的方法和系统。 层次数据结构的格式可以是XML。 符合模式的分层数据结构被加载到应用程序中。 数据结构包括在父子关系中链接在一起的元素和属性。 该模式定义了分层数据结构中的元素和属性之间的分层关系。 在已经加载了符合模式的分层数据结构之后,基于模式将多个布局规则应用于分层数据,以创建平面数据结构。 布局规则确定分层数据将如何插入平面数据结构中。 可以通过标识模式中的属性来识别布局规则,以识别模式中定义的元素的出现要求。 在将布局规则应用于层次数据之后,通过以数据行和列的形式插入数据,将分层数据呈现为电子表格。

    Method and system for inferring a schema from a hierarchical data structure for use in a spreadsheet
    7.
    发明授权
    Method and system for inferring a schema from a hierarchical data structure for use in a spreadsheet 有权
    用于从电子表格中使用的分层数据结构推断模式的方法和系统

    公开(公告)号:US08086959B2

    公开(公告)日:2011-12-27

    申请号:US11326853

    申请日:2006-01-06

    IPC分类号: G06F17/00 G06F15/00

    CPC分类号: G06F17/30914

    摘要: A method and system are provided for inferring a schema from an electronic document containing hierarchical data for use in a spreadsheet application program. The electronic document containing the hierarchical data is received into an application program. The application program may be a spreadsheet application program. The format of the hierarchical data structure may be XML. The hierarchical data includes a set of nodes making up the structure of the hierarchical data. The nodes may be XML elements and attributes. The hierarchical data is then parsed to discover one of the nodes in the hierarchical data. Once the node has been discovered, content associated with the discovered node is saved to a memory location in the computer system. The content may include data associated with the discovered node and the type of data associated with the node. The hierarchical data is then parsed again to discover subsequent nodes until the content for all of the nodes has been saved to the memory location. Then a schema generator generates schema elements using complex rules based on the particular qualities of each discovered node for each discovered node until a schema is generated for the hierarchical data.

    摘要翻译: 提供了一种方法和系统,用于从包含用于电子表格应用程序的分层数据的电子文档推断模式。 包含分层数据的电子文档被接收到应用程序中。 应用程序可以是电子表格应用程序。 层次数据结构的格式可以是XML。 分层数据包括组成分层数据结构的一组节点。 节点可以是XML元素和属性。 然后解析分层数据以发现分层数据中的一个节点。 一旦节点被发现,与发现的节点相关联的内容被保存到计算机系统中的存储器位置。 内容可以包括与所发现的节点相关联的数据和与节点相关联的数据的类型。 然后再次分析分层数据以发现后续节点,直到所有节点的内容已经保存到存储器位置。 然后,模式生成器根据每个发现节点的每个发现节点的特定质量,使用复杂规则生成模式元素,直到为分层数据生成模式。

    Method and system for converting a schema-based hierarchical data structure into a flat data structure

    公开(公告)号:US07003722B2

    公开(公告)日:2006-02-21

    申请号:US10376442

    申请日:2003-02-28

    IPC分类号: G06F19/00

    摘要: A method and system are provided for converting a hierarchical data structure into a flat data structure based on a schema. The format of the hierarchical data structure may be XML. A hierarchical data structure conforming to a schema is loaded into an application program. The data structure includes elements and attributes linked together in a parent-child relationship. The schema defines the hierarchical relationships between the elements and attributes in the hierarchical data structure. After the hierarchical data structure conforming to the schema has been loaded, a plurality of layout rules is applied to the hierarchical data based on the schema to create a flat data structure. The layout rules determine how the hierarchical data will be inserted in the flat data structure. The layout rules may be applied by identifying properties in the schema which identify occurrence requirements for elements defined in the schema. After the layout rules have been applied to the hierarchical data, the hierarchical data is rendered into a spreadsheet by inserting the data in rows and columns.

    Database data type creation and reuse
    9.
    发明授权
    Database data type creation and reuse 有权
    数据库数据类型的创建和重用

    公开(公告)号:US09152656B2

    公开(公告)日:2015-10-06

    申请号:US12417429

    申请日:2009-04-02

    IPC分类号: G06F17/30

    摘要: Embodiments are provided for creating and reusing custom data types in a database. A selection of a field or group of fields may be received from a database table in the database by a database software application executing on a computer system. Each selected field may include a set of field properties. The application may further receive a user input to initiate saving the selected field or group of fields as a custom data type. In response to receiving the input, the application may be configured to generate a dialog for receiving custom data type information for the selected field or group of fields and save the selected field or group of fields as a custom data type. The custom data type may then be reused by the application in the database.

    摘要翻译: 提供了用于在数据库中创建和重用自定义数据类型的实施例。 可以通过在计算机系统上执行的数据库软件应用程序从数据库中的数据库表中接收字段或字段组的选择。 每个所选字段可以包括一组字段属性。 应用程序还可以接收用户输入以开始将所选择的字段或字段组保存为自定义数据类型。 响应于接收到输入,应用可以被配置为生成用于接收所选字段或字段组的定制数据类型信息的对话框,并将所选择的字段或字段组保存为自定义数据类型。 自定义数据类型可以由数据库中的应用程序重新使用。

    Cached and Server Views with Automatic Caching and Smooth Scrolling
    10.
    发明申请
    Cached and Server Views with Automatic Caching and Smooth Scrolling 有权
    缓存和服务器视图,具有自动缓存和平滑滚动

    公开(公告)号:US20120221632A1

    公开(公告)日:2012-08-30

    申请号:US13465509

    申请日:2012-05-07

    IPC分类号: G06F15/16

    摘要: On a client computer, customer relationship management software is integrated into a messaging application that includes a user interface. Customer relationship management (CRM) information is received from a server computer. An automatic determination is made as to whether the received CRM information is to be cached on the client computer. When it is determined that the CRM information is to be cached on the client computer, the CRM information is cached in a cache on the client computer. When at least some of the CRM information is cached on the client computer, the cached CRM information is displayed as a view on the client computer. The display of the CRM information is integrated into the user interface of the messaging application program.

    摘要翻译: 在客户端计算机上,将客户关系管理软件集成到包含用户界面的消息应用程序中。 从服务器计算机接收到客户关系管理(CRM)信息。 自动确定接收到的CRM信息是否被缓存在客户端计算机上。 当确定CRM信息被缓存在客户端计算机上时,CRM信息被缓存在客户端计算机上的高速缓存中。 当至少一些CRM信息被缓存在客户端计算机上时,缓存的CRM信息被显示为客户端计算机上的视图。 CRM信息的显示被集成到消息应用程序的用户界面中。