Techniques for managing what-if analysis of data managed by a relational database system
    1.
    发明授权
    Techniques for managing what-if analysis of data managed by a relational database system 有权
    用于管理由关系数据库系统管理的数据的假设分析的技术

    公开(公告)号:US06898608B2

    公开(公告)日:2005-05-24

    申请号:US10417732

    申请日:2003-04-16

    IPC分类号: G06F12/00 G06F17/30

    摘要: An analytical workspace includes a set of data on which what-if analysis is performed, which is stored persistently and managed in a relational database system. The data may be stored as a binary large object in relational tables, and may comprise a portion of a multidimensional cube. A series of commands on the analytical workspace is received by a database server. In response to the commands, changes are made to the data in temporary storage. Redo information is not generated at this time in association with such changes. Hence, these changes are not made permanent at this time. At some point, the server may receive an update command to make the changes permanent. In response to the update command, redo information is generated for the changes reflected in the temporary storage and the changes are made permanent, in accordance with relational database properties.

    摘要翻译: 分析工作区包括一组在其上执行假设分析的数据,这些数据在关系数据库系统中持续存储并进行管理。 数据可以作为二进制大对象存储在关系表中,并且可以包括多维立方体的一部分。 数据库服务器接收到分析工作区上的一系列命令。 响应命令,对临时存储中的数据进行更改。 此时不再生成重做信息与此类更改相关联。 因此,这些变化并不是永久性的。 在某些时候,服务器可能会收到一个更新命令,使更改永久。 响应于update命令,根据关系数据库属性,为临时存储中反映的更改生成重做信息,并将更改永久化。

    Multiple writer support in an OLAP environment
    2.
    发明申请
    Multiple writer support in an OLAP environment 审中-公开
    在OLAP环境中支持多个作者

    公开(公告)号:US20060004885A1

    公开(公告)日:2006-01-05

    申请号:US10881174

    申请日:2004-06-30

    IPC分类号: G06F17/30

    CPC分类号: G06F16/2465

    摘要: Multiple writers can make permanent changes to data objects, while the performance is improved and data consistency is ensured. A database management system comprises a database containing a plurality of objects, and, possibly, a plurality of analytic workspaces, each analytic workspace containing at least some of the plurality of objects in the database, wherein changes made to a an object in a database private view are not written to a corresponding object in the database unless write access on the object has been given to the database private view, and wherein the database management system is operable to give write access on each of the plurality of objects in the database to database private views individually.

    摘要翻译: 多个作者可以对数据对象进行永久性更改,同时提高性能并确保数据一致性。 数据库管理系统包括包含多个对象的数据库,以及可能的多个分析工作空间,每个分析工作空间包含数据库中的多个对象中的至少一些,其中对数据库中的对象进行的更改为私有 视图不被写入数据库中的对应对象,除非对该对象的写入访问已经被提供给数据库私有视图,并且其中数据库管理系统可操作地向数据库中的多个对象中的每一个提供对数据库的写访问 个人观点。

    Efficient SQL access to multidimensional data
    3.
    发明授权
    Efficient SQL access to multidimensional data 有权
    对多维数据的高效SQL访问

    公开(公告)号:US08200612B2

    公开(公告)日:2012-06-12

    申请号:US10841941

    申请日:2004-05-06

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30592

    摘要: In processing a query on multidimensional data in a multidimensional schema, a multidimensional database server performs various processes to limit the amount of data that is extracted from the database and presented to a relational database server in response to the request. A subset of data is identified to extract from the multidimensional data, based on the query. In various embodiments, cell-filtering, measure-filtering, and column-filtering criteria identified from the query are used to filter the subset of data, in order to return a minimized set of multidimensional data values from the subset of data. Therefore, computational resources are conserved with respect to further processing by the relational database server in response to the query.

    摘要翻译: 在处理多维模式中关于多维数据的查询时,多维数据库服务器执行各种过程以限制从数据库提取的数据量,并响应于请求呈现给关系数据库服务器。 基于查询,识别数据的子集从多维数据中提取。 在各种实施例中,从查询中识别的单元过滤,测量过滤和列过滤标准被用于过滤数据子集,以便从数据子集返回最小化的多维数据值集合。 因此,关于关系数据库服务器响应于查询的进一步处理,计算资源是保守的。

    ENTERTAINMENT DEVICE SAFETY SYSTEM AND RELATED METHODS OF USE

    公开(公告)号:US20230058439A1

    公开(公告)日:2023-02-23

    申请号:US17973728

    申请日:2022-10-26

    申请人: James Carey

    发明人: James Carey

    IPC分类号: G06V40/10 H04N7/18

    摘要: An entertainment device safety system includes a video camera configured to capture video of an entertainment device and a user of the entertainment device and a video analytic module to perform real-time video processing of the captured video to generate non-video data from video. A computer receives the video and the non-video data from the video camera analyzes the video or the non-video data to determine a user position in relation to the entertainment device. The user position is compared to a user position rule to determine whether the user position violates the user position rule. A notification is transmitted in response to a determination that the user position violates the user position rule.

    Theft prediction and tracking system

    公开(公告)号:US11113937B2

    公开(公告)日:2021-09-07

    申请号:US15445355

    申请日:2017-02-28

    申请人: James Carey

    发明人: James Carey

    摘要: Systems and methods for detecting potential theft and identifying individuals having a history of committing theft are presented. An electromagnetic emission associated with a personal electronic device associated with an individual is received. One or more signal properties of the electromagnetic emission are analyzed to determine an emission signature. Video data and video analytics are utilized to determine whether an individual has taken possession of an item. The video analytics are correlated with the emission signature in an attempt to identify the individual having possession of the item. The emission signature and video data are stored for later use during a checkout procedure. If an emission signature detected at a checkout station matches that of the individual having possession of the item, and the item is not processed through the checkout station, an alert is issued and the individual is flagged as a potential shoplifter.

    PROTECTION OF PERSONAL DATA CONTAINED ON AN RFID-ENABLED DEVICE

    公开(公告)号:US20210004546A1

    公开(公告)日:2021-01-07

    申请号:US17028299

    申请日:2020-09-22

    申请人: James Carey

    发明人: James Carey

    IPC分类号: G06K7/10 G06K19/073

    摘要: A system for protecting personal data contained on an RFID-enabled device, suitable for use with an RFID system including an RFID reader configured to extract information from an RFID chip associated with the RFID-enabled device, includes a personal data protection system including a personal data protection device configured to prevent reading of the RFID chip associated with an RFID-enabled personal item.

    INVESTIGATION GENERATION IN AN OBSERVATION AND SURVEILLANCE SYSTEM

    公开(公告)号:US20200242876A1

    公开(公告)日:2020-07-30

    申请号:US16846568

    申请日:2020-04-13

    申请人: James Carey

    发明人: James Carey

    摘要: The present disclosure is directed to systems and methods for generating investigations of user behavior. In an example embodiment, the system includes a video camera configured to capture video of user activity, a video analytic module to perform real-time video processing of the captured video to generate non-video data from video, and a computer configured to receive the video and the non-video data from the video camera. In some embodiments, the video camera is at least one of a traffic camera or an aerial drone camera. The computer includes a video analytics module configured to analyze one of video and non-video data to identify occurrences of particular user behavior, and an investigation generation module configured to generate an investigation containing at least one video sequence of the particular user behavior. In some embodiments, the investigation is generated in near real time. The particular user behavior may be defined as an action, an inaction, a movement, a plurality of event occurrences, a temporal event and/or an externally-generated event.

    PROTECTION OF PERSONAL DATA CONTAINED ON AN RFID-ENABLED DEVICE

    公开(公告)号:US20190325175A1

    公开(公告)日:2019-10-24

    申请号:US16460264

    申请日:2019-07-02

    申请人: James Carey

    发明人: James Carey

    IPC分类号: G06K7/10 G06K19/073

    摘要: A system for protecting personal data contained on an RFID-enabled device, suitable for use with an RFID system including an RFID reader configured to extract information from an RFID chip associated with the RFID-enabled device, includes a personal data protection system including a personal data protection device configured to prevent reading of the RFID chip associated with an RFID-enabled personal item.