专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20130073521A1 MECHANISM FOR SYNCHRONIZING OLAP SYSTEM STRUCTURE AND OLTP SYSTEM STRUCTURE 有权
公开(公告)号：US20130073521A1
公开(公告)日：2013-03-21
申请号：US13464899
申请日：2012-05-04
申请人： Rondy Ng , Robert C. Zwiebach , David Haimes , Djiao Mei Siauw , Gregory David Roth , Arunesh Baneriee , Santosh Kumar Matam , Venkata Ramana Murthy Kosuri
发明人： Rondy Ng , Robert C. Zwiebach , David Haimes , Djiao Mei Siauw , Gregory David Roth , Arunesh Baneriee , Santosh Kumar Matam , Venkata Ramana Murthy Kosuri
IPC分类号： G06F17/30
CPC分类号： G06F17/30563 , G06F17/30557 , G06F17/30581 , G06F17/3087 , G06F17/30997
摘要： In an embodiment, for any structural change that is made to a relational database, a corresponding change is also made to the multidimensional database. In an embodiment, the system determines that a particular structure is not implemented on the multidimensional database system. Based on metadata that defines the structure that is supposed to exist in the multidimensional database, the appropriate structure is created.

2. 发明授权

US08959050B2 Mechanism for synchronizing OLAP system structure and OLTP system structure 有权
标题翻译：同步OLAP系统结构和OLTP系统结构的机制
公开(公告)号：US08959050B2
公开(公告)日：2015-02-17
申请号：US13464899
申请日：2012-05-04
申请人： Rondy Ng , Robert C. Zwiebach , David Haimes , Djiao Mei Siauw , Gregory David Roth , Arunesh Banerjee , Santosh Kumar Matam , Venkata Ramana Murthy Kosuri
发明人： Rondy Ng , Robert C. Zwiebach , David Haimes , Djiao Mei Siauw , Gregory David Roth , Arunesh Banerjee , Santosh Kumar Matam , Venkata Ramana Murthy Kosuri
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30563 , G06F17/30557 , G06F17/30581 , G06F17/3087 , G06F17/30997
摘要： In an embodiment, for any structural change that is made to a relational database, a corresponding change is also made to the multidimensional database. In an embodiment, the system determines that a particular structure is not implemented on the multidimensional database system. Based on metadata that defines the structure that is supposed to exist in the multidimensional database, the appropriate structure is created.
摘要翻译：在一个实施例中，对于对关系数据库进行的任何结构改变，还对多维数据库进行相应的改变。在一个实施例中，系统确定在多维数据库系统上未实现特定结构。基于定义多维数据库中存在的结构的元数据，创建适当的结构。

3. 发明申请

US20130073520A1 MECHANISM FOR UPDATING OLAP SYSTEM STRUCTURE AND OLTP SYSTEM STRUCTURE STRUCTURE 有权
标题翻译：用于更新OLAP系统结构和OLTP系统结构结构的机制
公开(公告)号：US20130073520A1
公开(公告)日：2013-03-21
申请号：US13464897
申请日：2012-05-04
申请人： Rondy Ng , Robert C. Zwiebach , David Haimes , Djiao Mei Siauw , Gregory David Roth , Arunesh Banerjee , Santosh Kumar Matam , Venkata Ramana Murthy Kosuri
发明人： Rondy Ng , Robert C. Zwiebach , David Haimes , Djiao Mei Siauw , Gregory David Roth , Arunesh Banerjee , Santosh Kumar Matam , Venkata Ramana Murthy Kosuri
IPC分类号： G06F17/30
CPC分类号： G06F17/30563 , G06F17/30557 , G06F17/30581 , G06F17/3087 , G06F17/30997
摘要： In an embodiment, for any structural change that is made to a relational database, a corresponding change is also made to the multidimensional database. In an embodiment, the system determines that a particular structure is not implemented on the multidimensional database system. Based on metadata that defines the structure that is supposed to exist in the multidimensional database, the appropriate structure is created.
摘要翻译：在一个实施例中，对于对关系数据库进行的任何结构改变，还对多维数据库进行相应的改变。在一个实施例中，系统确定在多维数据库系统上未实现特定结构。基于定义多维数据库中存在的结构的元数据，创建适当的结构。

4. 发明授权

US09959330B2 Mechanism for updating OLAP system structure and OLTP system structure 有权
公开(公告)号：US09959330B2
公开(公告)日：2018-05-01
申请号：US13464897
申请日：2012-05-04
申请人： Rondy Ng , Robert Zwiebach , David Haimes , Djiao Mei Siauw , Gregory David Roth , Arunesh Banerjee , Santosh Kumar Matam , Venkata Ramana Murthy Kosuri
发明人： Rondy Ng , Robert Zwiebach , David Haimes , Djiao Mei Siauw , Gregory David Roth , Arunesh Banerjee , Santosh Kumar Matam , Venkata Ramana Murthy Kosuri
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30563 , G06F17/30557 , G06F17/30581 , G06F17/3087 , G06F17/30997
摘要： In an embodiment, for any structural change that is made to a relational database, a corresponding change is also made to the multidimensional database. In an embodiment, the system determines that a particular structure is not implemented on the multidimensional database system. Based on metadata that defines the structure that is supposed to exist in the multidimensional database, the appropriate structure is created.

5. 发明申请

US20130080301A1 ONE-STEP POSTING FOR APPROVAL-BASED LEDGER TRANSACTIONS 审中-公开
标题翻译：用于基于批准的LEDGER交易的一步位置
公开(公告)号：US20130080301A1
公开(公告)日：2013-03-28
申请号：US13489135
申请日：2012-06-05
申请人： Djiao Mei Siauw , Deborah Ogg , Srini Pala , David Haimes , Robert Zwiebach , Kalpana Vora
发明人： Djiao Mei Siauw , Deborah Ogg , Srini Pala , David Haimes , Robert Zwiebach , Kalpana Vora
IPC分类号： G06Q40/00
CPC分类号： G06Q40/02
摘要： Various arrangements for posting a journal entry to a ledger are presented. The journal entry that comprises financial information related to a credit or debit from an account may be received. A request to post the journal entry to the ledger may be received. The journal entry may be determined to be subject to an approval process at least based on the ledger. At least one entity that is required to approve the journal entry as part of the approval process may be identified. An approval from the at least one entity may be received. After receiving approval, the journal entry may be posted to the ledger such that the ledger indicates the credit or debit of the journal entry. Posting of the journal entry to the ledger may require no input from the user following receiving the request to post the journal entry to the ledger.
摘要翻译：介绍了向分类帐发布日记帐分录的各种安排。可以收到包含与帐户的信用或借记相关的财务信息的日记帐分录。可能会收到将日记账分录到分类帐的请求。至少基于分类帐，可以确定该日记帐分录是否需要经过批准程序。可以识别至少一个在批准过程中批准日记帐分录的实体。可以收到至少一个实体的批准。收到批准后，日记帐分录可能会被发布到分类帐，以便分类帐指示日记帐分录的信用或借方。将日记帐分录发送到分类帐可能不需要用户在收到将日记帐分录发布到分类帐后的请求后输入。

6. 发明授权

US08712880B2 Transfer formulas 有权
标题翻译：转移公式
公开(公告)号：US08712880B2
公开(公告)日：2014-04-29
申请号：US13458421
申请日：2012-04-27
申请人： Abhijit Dhakephalkar , David Haimes , Arunesh C. Banerjee , Zeesha Currimbhoy , Robert Zwiebach , Rondy Ng
发明人： Abhijit Dhakephalkar , David Haimes , Arunesh C. Banerjee , Zeesha Currimbhoy , Robert Zwiebach , Rondy Ng
IPC分类号： G06Q20/22 , G06Q40/02
CPC分类号： G06Q40/12 , G06Q20/204 , G06Q40/02
摘要： A method of using a formula to execute periodic transfers in a hierarchal accounting structure includes receiving a transfer formula that may comprise a source account, a target account, an offset account, an account characteristic, and a formula for determining a first amount of the source account based on the account characteristic. The method may also include accessing a multidimensional data cube with a hierarchal arrangement and aggregated balances for each level. The method may additionally include generating a transfer scenario by transferring the first amount to the aggregated balance for the target account according to the transfer formula, and generating one or more accounting journal entries corresponding to the transfer scenario. The method may further include posting the one or more accounting journal entries to a general ledger associated with a relational database; and updating the multidimensional data cube to reflect the transfer scenario.
摘要翻译：使用公式来执行分级计帐结构中的周期性转移的方法包括接收可以包括源帐户，目标账户，抵消账户，账户特征以及用于确定源的第一数量的公式的转移公式账户基于账户特征。该方法还可以包括以层次排列和每个级别的聚合余额来访问多维数据立方体。该方法可以另外包括通过根据传送公式将目标帐户的第一金额转移到聚合余额并生成与传送方案相对应的一个或多个会计日记账分录来生成转移方案。该方法还可以包括将一个或多个会计日记帐分录发布到与关系数据库相关联的总帐中; 并更新多维数据立方体以反映传输场景。

7. 发明申请

US20130080300A1 TRANSFER FORMULAS 有权
标题翻译：转让公式
公开(公告)号：US20130080300A1
公开(公告)日：2013-03-28
申请号：US13458421
申请日：2012-04-27
申请人： Abhijit Dhakephalkar , David Haimes , Arunesh C. Banerjee , Zeesha Currimbhoy , Robert Zwiebach , Rondy Ng
发明人： Abhijit Dhakephalkar , David Haimes , Arunesh C. Banerjee , Zeesha Currimbhoy , Robert Zwiebach , Rondy Ng
IPC分类号： G06Q40/00 , G06Q20/08
CPC分类号： G06Q40/12 , G06Q20/204 , G06Q40/02
摘要： A method of using a formula to execute periodic transfers in a hierarchal accounting structure includes receiving a transfer formula that may comprise a source account, a target account, an offset account, an account characteristic, and a formula for determining a first amount of the source account based on the account characteristic. The method may also include accessing a multidimensional data cube with a hierarchal arrangement and aggregated balances for each level. The method may additionally include generating a transfer scenario by transferring the first amount to the aggregated balance for the target account according to the transfer formula, and generating one or more accounting journal entries corresponding to the transfer scenario. The method may further include posting the one or more accounting journal entries to a general ledger associated with a relational database; and updating the multidimensional data cube to reflect the transfer scenario.
摘要翻译：使用公式来执行分级计帐结构中的周期性转移的方法包括接收可以包括源帐户，目标账户，抵消账户，账户特征以及用于确定源的第一数量的公式的转移公式账户基于账户特征。该方法还可以包括以层次排列和每个级别的聚合余额来访问多维数据立方体。该方法可以另外包括通过根据传送公式将目标帐户的第一金额转移到聚合余额并生成与传送方案相对应的一个或多个会计日记账分录来生成转移方案。该方法还可以包括将一个或多个会计日记帐分录发布到与关系数据库相关联的总帐中; 并更新多维数据立方体以反映传输场景。

8. 发明申请

US20130080299A1 ALLOCATION MANAGER 有权
标题翻译：分配经理
公开(公告)号：US20130080299A1
公开(公告)日：2013-03-28
申请号：US13458110
申请日：2012-04-27
申请人： ABHIJIT DHAKEPHALKAR , David Haimes , Arunesh C. Banerjee , Zeesha Currimbhoy , Robert Zwiebach , Rondy Ng
发明人： ABHIJIT DHAKEPHALKAR , David Haimes , Arunesh C. Banerjee , Zeesha Currimbhoy , Robert Zwiebach , Rondy Ng
IPC分类号： G06Q40/00 , G06Q20/22
CPC分类号： G06Q40/12 , G06Q20/204 , G06Q40/02
摘要： A method of using rules to execute periodic allocations of funds in a hierarchal accounting structure may include receiving an allocation rule, comprising a source account, a rule for determining a first amount, a parent account, and an allocation basis; accessing a multidimensional data cube comprising a hierarchal arrangement and aggregated balances for each level of the hierarchal arrangement; generating an allocation scenario by allocating the first amount to the aggregated balances for the one or more child accounts according to the allocation rule; generating one or more accounting journal entries corresponding to the allocation scenario; posting the one or more accounting journal entries to a general ledger associated with a relational database; and updating, using the relational database, the multidimensional data cube to reflect the allocation scenario.
摘要翻译：使用规则来执行分层计帐结构中的资金的周期性分配的方法可以包括：接收分配规则，包括源帐户，用于确定第一金额的规则，母帐户和分配基础; 访问包括用于层级布置的每个级别的分级布置和聚合余额的多维数据立方体; 通过根据所述分配规则将所述第一金额分配给所述一个或多个子帐户的所述汇总余额来生成分配情景; 生成与分配情景相对应的一个或多个会计日记帐分录; 将一个或多个会计日记帐分录发布到与关系数据库相关联的总帐中; 并使用关系数据库更新多维数据立方体来反映分配情况。

9. 发明授权

US08768794B2 Allocation manager 有权
标题翻译：分配经理
公开(公告)号：US08768794B2
公开(公告)日：2014-07-01
申请号：US13458110
申请日：2012-04-27
申请人： Abhijit Dhakephalkar , David Haimes , Arunesh C. Banerjee , Zeesha Currimbhoy , Robert Zwiebach , Rondy Ng
发明人： Abhijit Dhakephalkar , David Haimes , Arunesh C. Banerjee , Zeesha Currimbhoy , Robert Zwiebach , Rondy Ng
IPC分类号： G07B17/00 , G06Q30/00 , G06Q40/00 , G06Q20/20
CPC分类号： G06Q40/12 , G06Q20/204 , G06Q40/02
摘要： A method of using rules to execute periodic allocations of funds in a hierarchal accounting structure may include receiving an allocation rule, comprising a source account, a rule for determining a first amount, a parent account, and an allocation basis; accessing a multidimensional data cube comprising a hierarchal arrangement and aggregated balances for each level of the hierarchal arrangement; generating an allocation scenario by allocating the first amount to the aggregated balances for the one or more child accounts according to the allocation rule; generating one or more accounting journal entries corresponding to the allocation scenario; posting the one or more accounting journal entries to a general ledger associated with a relational database; and updating, using the relational database, the multidimensional data cube to reflect the allocation scenario.
摘要翻译：使用规则来执行分层计帐结构中的资金的周期性分配的方法可以包括：接收分配规则，包括源帐户，用于确定第一金额的规则，母帐户和分配基础; 访问包括用于层级布置的每个级别的分级布置和聚合余额的多维数据立方体; 通过根据所述分配规则将所述第一金额分配给所述一个或多个子帐户的所述汇总余额来生成分配情景; 生成与分配情景相对应的一个或多个会计日记帐分录; 将一个或多个会计日记帐分录发布到与关系数据库相关联的总帐中; 并使用关系数据库更新多维数据立方体来反映分配情况。

10. 发明授权

US09477986B2 Efficient detection and analysis of variances 有权
标题翻译：有效检测和分析方差
公开(公告)号：US09477986B2
公开(公告)日：2016-10-25
申请号：US13477862
申请日：2012-05-22
申请人： Imad Jabbour , Mei Siauw , Anil Kumar Desu , David Haimes , Robert C. Zwiebach
发明人： Imad Jabbour , Mei Siauw , Anil Kumar Desu , David Haimes , Robert C. Zwiebach
IPC分类号： G06Q40/02 , G06Q40/00
CPC分类号： G06Q40/00
摘要： A method of detecting variances in a plurality of accounts from different organizations within an Enterprise Financial Accounting system includes receiving a selection of a first account with an account type; receiving a selection of a first time interval and a second time interval; determining a first amount that is associated with the first account during the first time interval; determining a second amount that is associated with the first account during the second time interval; receiving a selection of a comparison operator that relates the first amount to the second amount; receiving a selection of a threshold; determining a comparison value by comparing the first amount to the second amount according to the comparison operator; determining that the comparison value violates the threshold according to the comparison operator; and displaying a first indication in a portal comprised of the first amount, the second amount, and the comparison value.
摘要翻译：一种检测企业财务会计系统内的不同组织的多个账户中的差异的方法包括接收具有账户类型的第一个账户的选择; 接收第一时间间隔和第二时间间隔的选择; 在所述第一时间间隔期间确定与所述第一帐户相关联的第一金额; 在所述第二时间间隔期间确定与所述第一帐户相关联的第二数量; 接收将所述第一量与所述第二量相关联的比较运算符的选择; 接收阈值的选择; 通过根据比较运算符比较第一量与第二量来确定比较值; 确定比较值根据比较运算符违反阈值; 以及在由所述第一量，所述第二量和所述比较值组成的门户中显示第一指示。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式