Effective dating for entity attributes and relationships
    1.
    发明授权
    Effective dating for entity attributes and relationships 有权
    实体属性和关系的有效约会

    公开(公告)号:US08433692B2

    公开(公告)日:2013-04-30

    申请号:US12848372

    申请日:2010-08-02

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30309

    摘要: A method for tracking modifications to tables or relationships. In one embodiment, the method includes updating a first value stored in a first field of a record in a table in response to a database system receiving a first structured query language (SQL) statement from a customer relationship management (CRM) application. A first record is inserted into a history table in response to the first SQL statement, wherein the first record comprises a foreign key field that stores a copy of the primary key of the record, a field that stores a copy of the first value after it is updated, a field that stores a name of the first field, and a first date field. The first date field stores either the date when the first SQL statement was received by the database system, the date of the day that immediately follows the date when the first SQL statement was received by the database system, or a date that was entered into a field of a user interface.

    摘要翻译: 跟踪对表或关系的修改的方法。 在一个实施例中,响应于从客户关系管理(CRM)应用接收到第一结构化查询语言(SQL)语句的数据库系统,该方法包括更新存储在表中记录的第一字段中的第一值。 响应于第一个SQL语句将第一记录插入到历史表中,其中第一记录包括存储记录的主键的副本的外键字段,存储其后的第一个值的副本的字段 被更新,存储第一字段的名称的字段和第一日期字段。 第一个日期字段存储数据库系统接收到第一个SQL语句的日期,数据库系统接收到第一个SQL语句的日期之后的日期,或者输入到 字段的用户界面。

    Personalized Content Delivery and Analytics
    2.
    发明申请
    Personalized Content Delivery and Analytics 有权
    个性化内容交付和分析

    公开(公告)号:US20100198654A1

    公开(公告)日:2010-08-05

    申请号:US12363411

    申请日:2009-01-30

    IPC分类号: G06Q10/00 H04M11/00 G06F3/048

    摘要: Systems and methods are provided that record details and analytics about a sales call presentation. Presentation materials are stored in the form of digital content in a memory. A first user interface is provided to allow a presenter to select a presentation, and a second user interface is provided to allow a presenter to enter details about the sales call. Analytical data of the presentation is recorded in real-time and the analytical data is stored in a memory, wherein the analytical data is used in part to assess the success of the presentation.

    摘要翻译: 提供了系统和方法,用于记录关于销售电话演示的细节和分析。 演示材料以数字内容的形式存储在存储器中。 提供第一用户界面以允许演示者选择演示,并且提供第二用户界面以允许演示者输入关于销售呼叫的细节。 演示的分析数据是实时记录的,分析数据存储在存储器中,其中分析数据部分用于评估演示成功。

    Personalized content delivery and analytics
    3.
    发明授权
    Personalized content delivery and analytics 有权
    个性化内容传送和分析

    公开(公告)号:US08452640B2

    公开(公告)日:2013-05-28

    申请号:US12363411

    申请日:2009-01-30

    IPC分类号: G06Q10/00

    摘要: Systems and methods are provided that record details and analytics about a sales call presentation. Presentation materials are stored in the form of digital content in a memory. A first user interface is provided to allow a presenter to select a presentation, and a second user interface is provided to allow a presenter to enter details about the sales call. Analytical data of the presentation is recorded in real-time and the analytical data is stored in a memory, wherein the analytical data is used in part to assess the success of the presentation.

    摘要翻译: 提供了系统和方法,用于记录关于销售电话演示的细节和分析。 演示材料以数字内容的形式存储在存储器中。 提供第一用户界面以允许演示者选择演示,并且提供第二用户界面以允许演示者输入关于销售呼叫的细节。 演示的分析数据是实时记录的,分析数据存储在存储器中,其中分析数据部分用于评估演示成功。

    Effective Dating for Entity Attributes and Relationships
    4.
    发明申请
    Effective Dating for Entity Attributes and Relationships 有权
    实体属性和关系的有效约会

    公开(公告)号:US20120030258A1

    公开(公告)日:2012-02-02

    申请号:US12848372

    申请日:2010-08-02

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30309

    摘要: A method for tracking modifications to tables or relationships. In one embodiment, the method includes updating a first value stored in a first field of a record in a table in response to a database system receiving a first structured query language (SQL) statement from a customer relationship management (CRM) application. A first record is inserted into a history table in response to the first SQL statement, wherein the first record comprises a foreign key field that stores a copy of the primary key of the record, a field that stores a copy of the first value after it is updated, a field that stores a name of the first field, and a first date field. The first date field stores either the date when the first SQL statement was received by the database system, the date of the day that immediately follows the date when the first SQL statement was received by the database system, or a date that was entered into a field of a user interface.

    摘要翻译: 跟踪对表或关系的修改的方法。 在一个实施例中,响应于从客户关系管理(CRM)应用接收到第一结构化查询语言(SQL)语句的数据库系统,该方法包括更新存储在表中记录的第一字段中的第一值。 响应于第一个SQL语句将第一记录插入到历史表中,其中第一记录包括存储记录的主键的副本的外键字段,存储其后的第一个值的副本的字段 被更新,存储第一字段的名称的字段和第一日期字段。 第一个日期字段存储数据库系统接收到第一个SQL语句的日期,数据库系统接收到第一个SQL语句的日期之后的日期,或者输入到 字段的用户界面。