-
公开(公告)号:US08433692B2
公开(公告)日:2013-04-30
申请号:US12848372
申请日:2010-08-02
申请人: Lalit Jain , Lovelesh Gupta , Ganesh Shivaprakash , Rabicmeeran Kathermytheen , Bowen Wang , Peter Tung , Anil Billapati
发明人: Lalit Jain , Lovelesh Gupta , Ganesh Shivaprakash , Rabicmeeran Kathermytheen , Bowen Wang , Peter Tung , Anil Billapati
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语句的日期之后的日期,或者输入到 字段的用户界面。
-
公开(公告)号:US20100198654A1
公开(公告)日:2010-08-05
申请号:US12363411
申请日:2009-01-30
CPC分类号: G06Q30/02 , G06Q10/0631 , G06Q10/10
摘要: 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.
摘要翻译: 提供了系统和方法,用于记录关于销售电话演示的细节和分析。 演示材料以数字内容的形式存储在存储器中。 提供第一用户界面以允许演示者选择演示,并且提供第二用户界面以允许演示者输入关于销售呼叫的细节。 演示的分析数据是实时记录的,分析数据存储在存储器中,其中分析数据部分用于评估演示成功。
-
公开(公告)号:US08452640B2
公开(公告)日:2013-05-28
申请号:US12363411
申请日:2009-01-30
IPC分类号: G06Q10/00
CPC分类号: G06Q30/02 , G06Q10/0631 , G06Q10/10
摘要: 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.
摘要翻译: 提供了系统和方法,用于记录关于销售电话演示的细节和分析。 演示材料以数字内容的形式存储在存储器中。 提供第一用户界面以允许演示者选择演示,并且提供第二用户界面以允许演示者输入关于销售呼叫的细节。 演示的分析数据是实时记录的,分析数据存储在存储器中,其中分析数据部分用于评估演示成功。
-
公开(公告)号:US20120030258A1
公开(公告)日:2012-02-02
申请号:US12848372
申请日:2010-08-02
申请人: Lalit Jain , Lovelesh Gupta , Ganesh Shivaprakash , Rabicmeeran Kathermytheen , Bowen Wang , Peter Tung , Anil Billapati
发明人: Lalit Jain , Lovelesh Gupta , Ganesh Shivaprakash , Rabicmeeran Kathermytheen , Bowen Wang , Peter Tung , Anil Billapati
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语句的日期之后的日期,或者输入到 字段的用户界面。
-
-
-