US Patent Application No: 2003/0014,394

Number of patents in Portfolio can not be more than 2000

Cell-level data access control using user-defined functions

1 Status Updates

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

Access control at the cell level is provided by the use of mask functions. Original queries are modified to contain mask functions for those cells which controlled access in accordance with an access policy is desired. In addition, filter functions are included to eliminate rows according to the access policy

Loading the Abstract Image... loading....

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

Patent OwnerAddressTotal Patents
HITACHI AMERICA, LTD.TARRYTOWN, NY45

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Fujiwara, Shinji Cupertino, CA 105 1522
Kehrer, Michelle L Plainfield, IL 1 56
Lochowitz, James Palatine, IL 1 56

Cited Art Landscape

Patent Info (Count) # Cites Year
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (2)
* 6,081,801 Shared nothing parallel execution of procedural constructs in SQL 132 1997
* 6,581,060 System and method for RDBMS to protect records in accordance with non-RDBMS access control rules 37 2000
 
WORKDAY, INC. (2)
* 6,199,063 System and method for rewriting relational database queries 97 1998
* 6,493,699 Defining and characterizing an analysis space for precomputed views 46 1999
 
ORACLE INTERNATIONAL CORPORATION (4)
* 6,496,819 Rewriting a query in terms of a summary based on functional dependencies and join backs, and based on join derivability 96 1998
* 6,449,609 Using materialized view to process a related query containing a one to many lossless join 26 1998
* 5,991,754 Rewriting a query in terms of a summary based on aggregate computability and canonical format, and when a dimension table is on the child side of an outer join 130 1998
* 6,477,525 Rewriting a query in terms of a summary based on one-to-one and one-to-many losslessness of joins 45 1998
 
LUCENT TECHNOLOGIES INC. (1)
* 6,519,604 Approximate querying method for databases with multiple grouping attributes 64 2000
 
MICROSOFT TECHNOLOGY LICENSING, LLC (1)
* 6,490,589 System and method for rewriting queries 17 1998
 
Ericsson Enterprise GmbH (1)
* 6,480,550 Method of compressing an analogue signal 8 1998
 
VAN DEN BOSCH, BART (1)
* 6,519,601 Relational database compiled/stored on a memory structure providing improved access through use of redundant representation of data 44 1998
 
Teradata US, Inc. (2)
* 5,761,657 Global optimization of correlated subqueries and exists predicates 42 1995
* 6,275,824 System and method for managing data privacy in a database management system 286 1998
 
ORACLE AMERICA, INC. (1)
* 6,085,191 System and method for providing database access control in a secure distributed network 151 1998
* Cited By Examiner

Patent Citation Ranking

Forward Cite Landscape

Patent Info (Count) # Cites Year
 
Other [Check patent profile for assignment information] (3)
* 2005/0038,783 Database fine-grained access control 5 2004
* 2008/0307,266 TECHNIQUES FOR AUTOMATICALLY TRACKING SOFTWARE ERRORS 13 2008
* 2008/0307,267 TECHNIQUES FOR AUTOMATIC SOFTWARE ERROR DIAGNOSTICS 36 2008
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (10)
* 7,216,125 Methods and apparatus for pre-filtered access control in computing systems 18 2002
* 2004/0054,663 Methods and apparatus for pre-filtered access control in computing systems 1 2002
* 8,234,299 Method and system for using fine-grained access control (FGAC) to control access to data in a database 0 2008
* 2009/0182,747 METHOD AND SYSTEM FOR USING FINE-GRAINED ACCESS CONTROL (FGAC) TO CONTROL ACCESS TO DATA IN A DATABASE 2 2008
* 9,047,485 Integrated masking for viewing of data 0 2008
* 8,655,877 System and program for joining source table rows with target table rows 0 2008
* 2009/0012,990 SYSTEM AND PROGRAM FOR JOINING SOURCE TABLE ROWS WITH TARGET TABLE ROWS 5 2008
8,983,985 Masking sensitive data of table columns retrieved from a database 0 2011
8,538,990 Scalable mechanism for resolving cell-level access from sets of dimensional access rules 0 2011
8,930,410 Query transformation for masking data within database objects 0 2011
 
VMWARE, INC. (2)
9,195,707 Distributed event system for relational models 0 2011
9,058,353 Computer relational database method and system having role based access control 0 2011
 
SUN MICROSYSTEMS (SCHWEIZ) A.G. (2)
7,882,130 Method and apparatus for requestor sensitive role membership lookup 1 2005
* 2006/0173,869 Method and apparatus for requestor sensitive role membership lookup 5 2005
 
FUJIFILM CORPORATION (2)
* 2008/0241,806 MEDICAL STUDY SUPPORT APPARATUS AND STUDY LIST DISPLAY METHOD 0 2008
* 2011/0141,147 MEDICAL STUDY SUPPORT APPARATUS AND STUDY LIST DISPLAY METHOD 0 2011
 
Sophia Co., Ltd. (1)
* 7,962,492 Data management apparatus, data management method, data processing method, and program 0 2006
 
TransReplicator, Inc. (1)
7,555,493 Apparatus, systems and methods for relational database replication and proprietary data transformation 15 2005
 
LINKEDIN CORPORATION (1)
* 7,844,601 Quality of service feedback for technology-neutral data reporting 1 2006
 
CELCORP, INC. (5)
* 2007/0094,594 Redaction system, method and computer program product 22 2006
* 2009/0089,663 Document management workflow for redacted documents 4 2008
8,533,078 Virtual redaction service 2 2008
* 2010/0070,396 Virtual redaction service 6 2008
* 2009/0296,166 Point of scan/copy redaction 8 2009
 
Teradata US, Inc. (1)
* 2008/0162,402 Techniques for establishing and enforcing row level database security 6 2006
 
TRIZETTO CORPORATION (1)
* 2005/0125,254 Key maintenance method and system 38 2003
 
NOKIA TECHNOLOGIES OY (1)
* 2011/0153,644 METHOD AND APPARATUS FOR UTILIZING A SCALABLE DATA STRUCTURE 5 2009
 
TWITTER, INC. (2)
* 7,693,849 Masking object data based on user authorization 0 2005
* 2006/0265,375 Masking object data based on user authorization 6 2005
 
ORACLE INTERNATIONAL CORPORATION (39)
7,127,448 Reforming queries to selectively audit accesses to rows within a relational database 5 2000
7,117,197 Selectively auditing accesses to rows within a relational database at a database server 12 2000
7,693,541 Multimodal session support on distinct multi channel protocol 5 2002
* 2004/0139,043 Attribute relevant access control policies 44 2003
* 7,873,660 Enforcing data privacy aggregations 3 2003
7,228,300 Caching the results of security policy functions 9 2003
* 2004/0255,133 Method and apparatus for encrypting database columns 15 2003
7,606,788 Method and apparatus for protecting private information within a database 7 2003
* 7,346,617 Multi-table access control 10 2004
7,310,647 Column masking of tables 6 2004
* 8,825,702 Sending control information with database statement 0 2004
* 2005/0187,958 Sending control information with database statement 3 2004
* 7,487,149 Method and apparatus for providing query-level security in a database system 7 2004
* 2005/0203,886 Method and apparatus for providing query-level security in a database system 21 2004
7,281,003 Database fine-grained access control 4 2004
7,644,432 Policy inheritance through nested groups 34 2004
7,594,224 Distributed enterprise security system 54 2004
* 2005/0081,062 Distributed enterprise security system 2 2004
7,748,027 System and method for dynamic data redaction 21 2005
* 2006/0259,954 System and method for dynamic data redaction 18 2005
8,086,615 Security data redaction 6 2006
7,778,998 Liquid data services 3 2006
* 2006/0277,220 Security data redaction 22 2006
* 2006/0224,628 Modeling for data services 3 2006
* 2006/0218,117 Liquid data services 1 2006
* 2007/0276,835 Techniques for efficient access control in a database system 13 2006
* 7,711,741 Desensitizing data in cloning 2 2007
* 2008/0288,548 Desensitizing data in cloning 1 2007
* 8,065,329 Query optimization on VPD protected columns 0 2007
* 2008/0313,134 QUERY OPTIMIZATION ON VPD PROTECTED COLUMNS 6 2007
* 2009/0024,570 USER DEFINED QUERY REWRITE MECHANISM 0 2007
* 8,078,595 Secure normal forms 1 2007
* 2009/0094,193 SECURE NORMAL FORMS 6 2007
7,987,390 Techniques for automatically tracking software errors 10 2008
7,975,179 Techniques for automatic software error diagnostics 3 2008
* 9,311,369 Virtual masked database 0 2008
* 2010/0042,643 Virtual masked database 8 2008
8,239,396 View mechanism for data security, privacy and utilization 0 2009
* 2010/0241,641 VIEW MECHANISM FOR DATA SECURITY, PRIVACY AND UTILIZATION 5 2009
 
SAP AG (1)
* 2014/0012,833 PROTECTION OF DATA PRIVACY IN AN ENTERPRISE SYSTEM 0 2013
 
APPLE INC. (1)
* 2010/0030,737 IDENTITY ENABLED DATA LEVEL ACCESS CONTROL 4 2008
 
MITSUBISHI ELECTRIC CORPORATION (1)
* 2008/0229,112 ACCESS CONTROLLER 2 2007
 
MICROSOFT TECHNOLOGY LICENSING, LLC (8)
* 7,661,141 Systems and methods that optimize row level database security 2 2004
* 2005/0177,570 Systems and methods that optimize row level database security 27 2004
* 7,711,750 Systems and methods that specify row level database security 3 2004
* 7,747,597 Security execution context for a database management system 1 2005
* 2007/0005,600 Security execution context for a database management system 3 2005
* 7,941,411 Memory transaction grouping 0 2007
8,806,578 Data driven role based security 0 2010
8,484,175 Memory transaction grouping 0 2011
 
TATA CONSULTANCY SERVICES LIMITED (1)
* 2013/0060,820 Data Masking Setup 0 2012
 
Teradota US, Inc. (1)
* 8,027,993 Techniques for establishing and enforcing row level database security 0 2006
 
SALESFORCE.COM, INC. (18)
7,529,728 Query optimization in a multi-tenant database system 54 2003
* 8,543,566 System and methods of improving a multi-tenant database query using contextual knowledge about non-homogeneously distributed tenant data 1 2006
* 2007/0124,276 METHOD OF IMPROVING A QUERY TO A DATABASE SYSTEM 72 2006
* 8,095,531 Methods and systems for controlling access to custom objects in a database 78 2007
* 2008/0082,540 METHODS AND SYSTEMS FOR CONTROLLING ACCESS TO CUSTOM OBJECTS IN A DATABASE 61 2007
8,229,922 Query optimization in a multi-tenant database system 6 2009
* 2009/0276,395 QUERY OPTIMIZATION IN A MULTI-TENANT DATABASE SYSTEM 42 2009
* 8,478,782 System, method and computer program product for sharing tenant information utilizing a multi-tenant on-demand database service 4 2009
8,732,157 Query optimization in a multi-tenant database system 0 2010
8,423,535 Query optimization in a multi-tenant database system 2 2010
* 2010/0274,779 QUERY OPTIMIZATION IN A MULTI-TENANT DATABASE SYSTEM 34 2010
8,620,954 Query optimization in a multi-tenant database system 1 2010
* 2010/0235,837 QUERY OPTIMIZATION IN A MULTI-TENANT DATABASE SYSTEM 38 2010
* 8,706,715 Methods and systems for joining indexes for query optimization in a multi-tenant database 0 2010
* 2011/0082,854 METHODS AND SYSTEMS FOR JOINING INDEXES FOR QUERY OPTIMIZATION IN A MULTI-TENANT DATABASE 12 2010
8,713,043 System, method and computer program product for sharing a single instance of a database stored using a tenant of a multi-tenant on-demand database system 1 2011
* 2011/0213,797 SYSTEM, METHOD AND COMPUTER PROGRAM PRODUCT FOR SHARING A SINGLE INSTANCE OF A DATABASE STORED USING A TENANT OF A MULTI-TENANT ON-DEMAND DATABASE SYSTEM 1 2011
9,275,105 System and methods of improving a multi-tenant database query using contextual knowledge about non-homogeneously distributed tenant data 0 2012
 
BEA SYSTEMS, INC. (6)
* 2005/0102,535 Distributed security system with security service providers 7 2004
* 2006/0259,614 System and method for distributed data redaction 8 2005
* 2006/0259,977 System and method for data redaction client 9 2005
* 2006/0224,556 SQL interface for services 2 2006
* 2006/0218,149 Data redaction policies 17 2006
* 2006/0218,118 Using query plans for building and performance tuning services 8 2006
* Cited By Examiner