CN104769607B - 利用预定义的查询来过滤视图 - Google Patents

利用预定义的查询来过滤视图 Download PDF

Info

Publication number
CN104769607B
CN104769607B CN201380058859.1A CN201380058859A CN104769607B CN 104769607 B CN104769607 B CN 104769607B CN 201380058859 A CN201380058859 A CN 201380058859A CN 104769607 B CN104769607 B CN 104769607B
Authority
CN
China
Prior art keywords
view
filter query
query
views
filter
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201380058859.1A
Other languages
English (en)
Chinese (zh)
Other versions
CN104769607A (zh
Inventor
C·雅各布森
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Microsoft Technology Licensing LLC
Original Assignee
Microsoft Corp
Microsoft Technology Licensing LLC
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Microsoft Corp, Microsoft Technology Licensing LLC filed Critical Microsoft Corp
Publication of CN104769607A publication Critical patent/CN104769607A/zh
Application granted granted Critical
Publication of CN104769607B publication Critical patent/CN104769607B/zh
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24564—Applying rules; Deductive queries
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2457—Query processing with adaptation to user needs
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60—Protecting data
    • G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
    • G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
    • G06F21/6227—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database where protection concerns the structure of data, e.g. records, types, queries

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Health & Medical Sciences (AREA)
  • Bioethics (AREA)
  • General Health & Medical Sciences (AREA)
  • Computer Hardware Design (AREA)
  • Computer Security & Cryptography (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Storage Device Security (AREA)
  • Magnetic Resonance Imaging Apparatus (AREA)
CN201380058859.1A 2012-11-09 2013-11-09 利用预定义的查询来过滤视图 Active CN104769607B (zh)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US13/673,775 US9275112B2 (en) 2012-11-09 2012-11-09 Filtering views with predefined query
US13/673,775 2012-11-09
PCT/US2013/069358 WO2014074961A2 (en) 2012-11-09 2013-11-09 Filtering views with predefined query

Publications (2)

Publication Number Publication Date
CN104769607A CN104769607A (zh) 2015-07-08
CN104769607B true CN104769607B (zh) 2018-09-21

Family

ID=49679627

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201380058859.1A Active CN104769607B (zh) 2012-11-09 2013-11-09 利用预定义的查询来过滤视图

Country Status (6)

Country Link
US (1) US9275112B2 (enExample)
EP (1) EP2917872A2 (enExample)
JP (1) JP2015535622A (enExample)
KR (1) KR20150084006A (enExample)
CN (1) CN104769607B (enExample)
WO (1) WO2014074961A2 (enExample)

Families Citing this family (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9720972B2 (en) * 2013-06-17 2017-08-01 Microsoft Technology Licensing, Llc Cross-model filtering
US20170316052A1 (en) * 2016-05-01 2017-11-02 Microsoft Technology Licensing, Llc Analytics interface for a transactional data store
US10831784B2 (en) * 2016-05-09 2020-11-10 Sap Se Integration of relational calculation views into a relational engine
US10545945B2 (en) * 2016-10-28 2020-01-28 Microsoft Technology Licensing, Llc Change monitoring spanning graph queries
US10242223B2 (en) 2017-02-27 2019-03-26 Microsoft Technology Licensing, Llc Access controlled graph query spanning
US11106427B2 (en) * 2017-09-29 2021-08-31 Intel Corporation Memory filtering for disaggregate memory architectures
US10430606B1 (en) * 2018-04-30 2019-10-01 Aras Corporation System and method for implementing domain based access control on queries of a self-describing data system
US11048815B2 (en) 2018-08-06 2021-06-29 Snowflake Inc. Secure data sharing in a multi-tenant database system
US12380170B2 (en) * 2021-12-01 2025-08-05 Google Llc Performance optimizations for row-level security filters
US11941074B2 (en) * 2022-03-18 2024-03-26 International Business Machines Corporation Fetching a query result using a query filter

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2000112796A (ja) * 1998-10-02 2000-04-21 Ncr Internatl Inc デ―タベ―ス管理システムにおけるデ―タプライバシ―管理の方法およびシステム
US20040015783A1 (en) * 2002-06-20 2004-01-22 Canon Kabushiki Kaisha Methods for interactively defining transforms and for generating queries by manipulating existing query data
US20050060647A1 (en) * 2002-12-23 2005-03-17 Canon Kabushiki Kaisha Method for presenting hierarchical data
CN1760791A (zh) * 2004-10-14 2006-04-19 微软公司 用于合并安全策略的方法和系统
US20060212470A1 (en) * 2005-03-21 2006-09-21 Case Western Reserve University Information organization using formal concept analysis
CN102314449A (zh) * 2010-07-05 2012-01-11 日电（中国）有限公司 后置数据访问过滤器和过滤方法

Family Cites Families (23)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6947903B1 (en) * 1999-08-06 2005-09-20 Elcommerce.Com.Inc. Method and system for monitoring a supply-chain
US7774220B2 (en) * 1999-11-29 2010-08-10 The Strategic Coach Inc. Project management system for aiding users in attaining goals
US6499029B1 (en) * 2000-03-29 2002-12-24 Koninklijke Philips Electronics N.V. User interface providing automatic organization and filtering of search criteria
US6850944B1 (en) * 2000-11-20 2005-02-01 The University Of Alabama System, method, and computer program product for managing access to and navigation through large-scale information spaces
JP2002175217A (ja) * 2000-12-07 2002-06-21 Toppan Printing Co Ltd データベースシステム及びデータベースのアクセス制御方法並びにデータベースのアクセス制御プログラムを記録した記録媒体
US20020095405A1 (en) * 2001-01-18 2002-07-18 Hitachi America, Ltd. View definition with mask for cell-level data access control
JP2002312220A (ja) * 2001-01-18 2002-10-25 Hitachi Ltd ユーザ定義機能を使用したセルレベルのデータアクセス制御
US7356840B1 (en) 2001-06-19 2008-04-08 Microstrategy Incorporated Method and system for implementing security filters for reporting systems
JP2003006194A (ja) * 2001-06-22 2003-01-10 Mitsubishi Electric Corp データベースアクセス制御システム
US7240046B2 (en) * 2002-09-04 2007-07-03 International Business Machines Corporation Row-level security in a relational database management system
US7661141B2 (en) * 2004-02-11 2010-02-09 Microsoft Corporation Systems and methods that optimize row level database security
US7562092B2 (en) * 2004-12-22 2009-07-14 Microsoft Corporation Secured views for a CRM database
US20060224692A1 (en) * 2005-03-29 2006-10-05 Bea Systems, Inc. Adhoc queries for services
US7720863B2 (en) * 2006-03-17 2010-05-18 Microsoft Corporation Security view-based, external enforcement of business application security rules
US7584178B2 (en) 2006-04-20 2009-09-01 International Business Machines Corporation Query condition building using predefined query objects
US7912875B2 (en) * 2006-10-31 2011-03-22 Business Objects Software Ltd. Apparatus and method for filtering data using nested panels
US8996542B2 (en) * 2006-12-13 2015-03-31 Adobe Systems Incorporated Navigation of hierarchical data sets
US8306999B2 (en) * 2007-03-23 2012-11-06 Sas Institute Inc. Computer-implemented systems, methods, and computer program product for providing row-level security in a database network
US8099446B2 (en) * 2007-12-12 2012-01-17 International Business Machines Corporation Digital content searching tool
JP2010282304A (ja) * 2009-06-03 2010-12-16 Mitsubishi Electric Corp データ管理検索システム
US9471648B2 (en) * 2010-03-01 2016-10-18 Salesforce.Com, Inc. System, method and computer program product for displaying one or more data sets to a user
EP2453368B1 (en) 2010-11-12 2017-05-31 Accenture Global Services Limited Custom web services data link layer
US9298764B2 (en) * 2012-05-23 2016-03-29 Oracle International Corporation Partial source verification of EDC data

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2000112796A (ja) * 1998-10-02 2000-04-21 Ncr Internatl Inc デ―タベ―ス管理システムにおけるデ―タプライバシ―管理の方法およびシステム
US20040015783A1 (en) * 2002-06-20 2004-01-22 Canon Kabushiki Kaisha Methods for interactively defining transforms and for generating queries by manipulating existing query data
US20050060647A1 (en) * 2002-12-23 2005-03-17 Canon Kabushiki Kaisha Method for presenting hierarchical data
CN1760791A (zh) * 2004-10-14 2006-04-19 微软公司 用于合并安全策略的方法和系统
US20060212470A1 (en) * 2005-03-21 2006-09-21 Case Western Reserve University Information organization using formal concept analysis
CN102314449A (zh) * 2010-07-05 2012-01-11 日电（中国）有限公司 后置数据访问过滤器和过滤方法

Also Published As

Publication number Publication date
EP2917872A2 (en) 2015-09-16
US20140136552A1 (en) 2014-05-15
US9275112B2 (en) 2016-03-01
WO2014074961A3 (en) 2014-10-16
CN104769607A (zh) 2015-07-08
JP2015535622A (ja) 2015-12-14
WO2014074961A2 (en) 2014-05-15
KR20150084006A (ko) 2015-07-21

Similar Documents

Publication Publication Date Title
CN104769607B (zh) 利用预定义的查询来过滤视图
US11941017B2 (en) Event driven extract, transform, load (ETL) processing
US10979438B2 (en) Policy management, enforcement, and audit for data security
US10061788B2 (en) Transformation of document flow to contributors network
US8577842B1 (en) Distributed computer system snapshots and instantiation thereof
US9361330B2 (en) System and method for consistent embedded search across enterprise applications with an enterprise crawl and search framework
US8146099B2 (en) Service-oriented pipeline based architecture
CN110036382B (zh) 多租户非关系型平台对象
US11514186B2 (en) Integrated database user privilege management
US10410304B2 (en) Provisioning in digital asset management
US11169997B1 (en) Centralized data access tool implementing resource governance
US9495282B2 (en) Method and systems for a dashboard testing framework in an online demand service environment
US8838547B2 (en) Web-enabled database access tools
US11860832B2 (en) Custom columns for static logical models
US20210272129A1 (en) Systems, methods, and apparatuses for implementing cross cloud engagement activity visualization without requiring database merge or data replication
US20250103740A1 (en) Fine granularity control of data access and usage across multi-tenant systems
US10140667B2 (en) Social customer relationship management opportunity templating
US20180349269A1 (en) Event triggered data retention
US20120216240A1 (en) Providing data security through declarative modeling of queries
US20160261707A1 (en) Sign-up and provisioning in online reputation management with reputation shaping
CN120165942A (zh) 页面展示方法、装置、设备及存储介质
US20250265013A1 (en) Systems and methods for executing operations across data exchanges that comprise non-standardized data descriptions using dynamically generated validation rules
US20240281429A1 (en) Systems and methods for validating non-homogenous assets that comprise non-standardized data descriptions using dynamically generated validation rules

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
EXSB Decision made by sipo to initiate substantive examination
SE01 Entry into force of request for substantive examination
TA01 Transfer of patent application right
TA01 Transfer of patent application right

Effective date of registration: 20171023

Address after: Washington State

Applicant after: Micro soft technique license Co., Ltd

Address before: Washington State

Applicant before: Microsoft Corp.

GR01 Patent grant
GR01 Patent grant