首页>
外国专利>
Systems, methods, and apparatuses for implementing a BY ORGID command term within a multi-tenant aware structured query language
Systems, methods, and apparatuses for implementing a BY ORGID command term within a multi-tenant aware structured query language
展开▼
机译:用于在多租户感知的结构化查询语言中实现BY ORGID命令术语的系统,方法和装置
展开▼
页面导航
摘要
著录项
相似文献
摘要
In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing a BY ORGID command term within a multi-tenant aware structured query language within a computing environment. For instance, such an exemplary system having a processor and a memory therein includes means for operating a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations; receiving a database query specifying a command term to filter all tables accessed pursuant to execution of the database query by an organization_id parameter corresponding to one of the plurality of distinct customer organizations; parsing the database query to identify the command term specified; parsing the database query to identify any part of the received database query corresponding to one or more tables within the multi-tenant database system; generating a new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received, in which the new structured query language statement filters every reference to the one or more tables by the organization_id parameter; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.
展开▼