JP2015535622A - 予め定義されたクエリーによる表示のフィルタリング - Google Patents

予め定義されたクエリーによる表示のフィルタリング Download PDF

Info

Publication number
JP2015535622A
JP2015535622A JP2015541970A JP2015541970A JP2015535622A JP 2015535622 A JP2015535622 A JP 2015535622A JP 2015541970 A JP2015541970 A JP 2015541970A JP 2015541970 A JP2015541970 A JP 2015541970A JP 2015535622 A JP2015535622 A JP 2015535622A
Authority
JP
Japan
Prior art keywords
display
query
filter query
application
user
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.)
Ceased
Application number
JP2015541970A
Other languages
English (en)
Japanese (ja)
Other versions
JP2015535622A5 (enExample
Inventor
ジェイコブセン，クラウス
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 Corp
Original Assignee
Microsoft Corp
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 filed Critical Microsoft Corp
Publication of JP2015535622A publication Critical patent/JP2015535622A/ja
Publication of JP2015535622A5 publication Critical patent/JP2015535622A5/ja
Ceased legal-status Critical Current

Links

Images

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)
JP2015541970A 2012-11-09 2013-11-09 予め定義されたクエリーによる表示のフィルタリング Ceased JP2015535622A (ja)

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
JP2015535622A true JP2015535622A (ja) 2015-12-14
JP2015535622A5 JP2015535622A5 (enExample) 2016-11-24

Family

ID=49679627

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2015541970A Ceased JP2015535622A (ja) 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 (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2002175217A (ja) * 2000-12-07 2002-06-21 Toppan Printing Co Ltd データベースシステム及びデータベースのアクセス制御方法並びにデータベースのアクセス制御プログラムを記録した記録媒体
JP2002215440A (ja) * 2001-01-18 2002-08-02 Hitachi Ltd セルレベルのデータアクセス制御のためのマスク付きビューの定義方法及びそのプログラム記録媒体
JP2002312220A (ja) * 2001-01-18 2002-10-25 Hitachi Ltd ユーザ定義機能を使用したセルレベルのデータアクセス制御
US6499029B1 (en) * 2000-03-29 2002-12-24 Koninklijke Philips Electronics N.V. User interface providing automatic organization and filtering of search criteria
JP2003006194A (ja) * 2001-06-22 2003-01-10 Mitsubishi Electric Corp データベースアクセス制御システム
JP2005228312A (ja) * 2004-02-11 2005-08-25 Microsoft Corp 行レベルのデータベースセキュリティを最適化するシステムおよび方法
JP2006502472A (ja) * 2002-09-04 2006-01-19 インターナショナル・ビジネス・マシーンズ・コーポレーション リレーショナル・データベースへのアクセスを制御する方法
JP2010282304A (ja) * 2009-06-03 2010-12-16 Mitsubishi Electric Corp データ管理検索システム
JP2011507083A (ja) * 2007-12-12 2011-03-03 インターナショナル・ビジネス・マシーンズ・コーポレーション サンプル要素のメタデータに基づいてデジタル・コンテンツを検索する方法、システムおよびコンピュータ・プログラム

Family Cites Families (20)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6275824B1 (en) * 1998-10-02 2001-08-14 Ncr Corporation System and method for managing data privacy in a database management system
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
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
US7356840B1 (en) 2001-06-19 2008-04-08 Microstrategy Incorporated Method and system for implementing security filters for reporting systems
US7574652B2 (en) * 2002-06-20 2009-08-11 Canon Kabushiki Kaisha Methods for interactively defining transforms and for generating queries by manipulating existing query data
AU2002953555A0 (en) * 2002-12-23 2003-01-16 Canon Kabushiki Kaisha Method for presenting hierarchical data
US7739720B2 (en) * 2004-10-14 2010-06-15 Microsoft Corporation Method and system for merging security policies
US7562092B2 (en) * 2004-12-22 2009-07-14 Microsoft Corporation Secured views for a CRM database
US20060212470A1 (en) * 2005-03-21 2006-09-21 Case Western Reserve University Information organization using formal concept analysis
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
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
CN102314449B (zh) * 2010-07-05 2013-11-06 日电（中国）有限公司 后置数据访问过滤器和过滤方法
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 (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6499029B1 (en) * 2000-03-29 2002-12-24 Koninklijke Philips Electronics N.V. User interface providing automatic organization and filtering of search criteria
JP2002175217A (ja) * 2000-12-07 2002-06-21 Toppan Printing Co Ltd データベースシステム及びデータベースのアクセス制御方法並びにデータベースのアクセス制御プログラムを記録した記録媒体
JP2002215440A (ja) * 2001-01-18 2002-08-02 Hitachi Ltd セルレベルのデータアクセス制御のためのマスク付きビューの定義方法及びそのプログラム記録媒体
JP2002312220A (ja) * 2001-01-18 2002-10-25 Hitachi Ltd ユーザ定義機能を使用したセルレベルのデータアクセス制御
JP2003006194A (ja) * 2001-06-22 2003-01-10 Mitsubishi Electric Corp データベースアクセス制御システム
JP2006502472A (ja) * 2002-09-04 2006-01-19 インターナショナル・ビジネス・マシーンズ・コーポレーション リレーショナル・データベースへのアクセスを制御する方法
JP2005228312A (ja) * 2004-02-11 2005-08-25 Microsoft Corp 行レベルのデータベースセキュリティを最適化するシステムおよび方法
JP2011507083A (ja) * 2007-12-12 2011-03-03 インターナショナル・ビジネス・マシーンズ・コーポレーション サンプル要素のメタデータに基づいてデジタル・コンテンツを検索する方法、システムおよびコンピュータ・プログラム
JP2010282304A (ja) * 2009-06-03 2010-12-16 Mitsubishi Electric Corp データ管理検索システム

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
倉賀野 哲宏: "ＳＱＬを理解して"危ないＤＢ設計"を避ける", 日経オープンシステム, vol. 第２０号, JPN6017038427, 10 November 1994 (1994-11-10), JP, pages 249 - 260, ISSN: 0003657521 *

Also Published As

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

Similar Documents

Publication Publication Date Title
US11941017B2 (en) Event driven extract, transform, load (ETL) processing
CN104769607B (zh) 利用预定义的查询来过滤视图
US10685071B2 (en) Methods, systems, and computer program products for storing graph-oriented data on a column-oriented database
RU2546322C2 (ru) Расширение возможностей сотрудничества при использовании внешних данных
US8146099B2 (en) Service-oriented pipeline based architecture
US8577842B1 (en) Distributed computer system snapshots and instantiation thereof
US10091212B2 (en) Policy management, enforcement, and audit for data security
US10410304B2 (en) Provisioning in digital asset management
US20170012984A1 (en) Access control for a document management and collaboration system
US20110252463A1 (en) Method and system for providing enterprise procurement network
US11971909B2 (en) Data processing system with manipulation of logical dataset groups
US8799177B1 (en) Method and apparatus for building small business graph from electronic business data
US20180349269A1 (en) Event triggered data retention
US20150332287A1 (en) Social customer relationship management opportunity templating
US20250217348A1 (en) Systems and methods for validating non-homogeneous assets that comprise non-standardized data descriptions using dynamically generated validation rules
US20160261707A1 (en) Sign-up and provisioning in online reputation management with reputation shaping
US20250265013A1 (en) Systems and methods for executing operations across data exchanges that comprise non-standardized data descriptions using dynamically generated validation rules
US20240004527A1 (en) Systems and methods for providing custom filters
CN108898027B (zh) 一种权限控制方法、装置及服务器集群
US12306836B2 (en) Systems and methods for executing operations across sensitive data in data change repositories for shared data resources
US12265643B2 (en) Systems and methods for validating sensitive data in data change repositories for shared data resources
US12306860B1 (en) Intelligently expanding search results ahead-of-time
US20250379867A1 (en) Cloud architecture for enforcing multi-dimensional data security using security assignments beyond role-based access controls
WO2024173883A1 (en) Systems and methods for validating non-homogenous assets and executing operations across data exchanges that comprise non-standardized data descriptions using dynamically generated validation rules
Cancescu Enabling multitenant software solutions for online business software.

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20161006

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20161006

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20170927

A711 Notification of change in applicant

Free format text: JAPANESE INTERMEDIATE CODE: A711

Effective date: 20171004

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20171005

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20171218

A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20180104

A045 Written measure of dismissal of application [lapsed due to lack of payment]

Free format text: JAPANESE INTERMEDIATE CODE: A045

Effective date: 20180524