会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 3. 发明授权
    • Effective dating for entity attributes and relationships
    • 实体属性和关系的有效约会
    • US08433692B2
    • 2013-04-30
    • US12848372
    • 2010-08-02
    • Lalit JainLovelesh GuptaGanesh ShivaprakashRabicmeeran KathermytheenBowen WangPeter TungAnil Billapati
    • Lalit JainLovelesh GuptaGanesh ShivaprakashRabicmeeran KathermytheenBowen WangPeter TungAnil Billapati
    • G06F17/30
    • 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语句的日期之后的日期,或者输入到 字段的用户界面。