US7257580B2 - Method, system, and program for restricting modifications to allocations of computational resources - Google Patents
Method, system, and program for restricting modifications to allocations of computational resources Download PDFInfo
- Publication number
- US7257580B2 US7257580B2 US10/786,347 US78634704A US7257580B2 US 7257580 B2 US7257580 B2 US 7257580B2 US 78634704 A US78634704 A US 78634704A US 7257580 B2 US7257580 B2 US 7257580B2
- Authority
- US
- United States
- Prior art keywords
- modification
- resource allocation
- permitted
- restriction
- requested
- 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, expires
Links
- 230000004048 modification Effects 0.000 title claims abstract description 99
- 238000012986 modification Methods 0.000 title claims abstract description 99
- 238000000034 method Methods 0.000 title claims abstract description 31
- 238000013468 resource allocation Methods 0.000 claims abstract description 49
- 238000004519 manufacturing process Methods 0.000 claims description 15
- 238000012545 processing Methods 0.000 claims description 4
- 230000004044 response Effects 0.000 claims 6
- 230000008859 change Effects 0.000 description 14
- 230000008569 process Effects 0.000 description 5
- 230000005540 biological transmission Effects 0.000 description 4
- 230000003287 optical effect Effects 0.000 description 3
- 101100521334 Mus musculus Prom1 gene Proteins 0.000 description 1
- 230000009471 action Effects 0.000 description 1
- 230000004913 activation Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000001902 propagating effect Effects 0.000 description 1
- 238000009877 rendering Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99939—Privileged access
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99942—Manipulating data structure, e.g. compression, compaction, compilation
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99943—Generating database or data structure, e.g. via user interface
Abstract
Description
-
- Restricted Database 52: identifies the database to which the request is submitted to which the resource modification restriction applies. Restrictions may also apply to users.
- Restricted Resource 54: identifies the
server 4 computational resource that is subject to the modification restriction, such as memory, processors used, threads allowed, type of table that may be created, location in which a table or other data structure may be created, etc. - Permitted Usage 56: indicates the maximum allowed amount of the resource that may be allocated to one user/database or some other restriction on the resource subject to the limitation. If there is no specific value set by the administrator or user, then the permitted usage will comprise a default value provided by the system.
- Immutability flag 58: flag indicating whether the user may change the permitted usage for the restricted resource, e.g., “on” indicates the user may not change the permitted
usage 56 and “off” means the user may change the permittedusage 56. This flag provides the administrator control over whether users may alter the limitations the administrator sets on modifications of resource allocations to insure quality of service among different users.
-
- Relative Memory Usage: specifies the relative amount or a value of memory resources that may be allocated to a query request. A query can request a percentage of memory or a minimum and maximum range of memory. The administrator may indicate through the relative memory usage the maximum percentage of memory resources, e.g., bytes, pages, etc., that can be allocated to a query to determine the amount of memory that the query actually is allocated. The relative memory comprises an amount of the absolute resources available for allocation at the
server 4. - Computational Quota: indicates the number of processors or threads that may be allocated to process a query. Allowing the allocation of multiple processors or threads to a query may allow parallelization and faster execution of the query.
- Max Scan: indicates the number of threads that may be used to scan a table or index. This determines the amount of parallelism imparted on scanning the table, i.e., fewer allocated scan threads, lesser the parallelism.
- Tablespace Location: if specified, may provide a default storage location, i.e., logical volume, area in storage, etc., in which tablespaces may be created. This restricts the user to creating tablespaces in the specified location only, unless this restriction is specified to be mutable.
- Table Types: may restrict the types of tables a user may create within the database. For instance, the table type value may indicate that the user may only create non-logging tables.
- Relative Memory Usage: specifies the relative amount or a value of memory resources that may be allocated to a query request. A query can request a percentage of memory or a minimum and maximum range of memory. The administrator may indicate through the relative memory usage the maximum percentage of memory resources, e.g., bytes, pages, etc., that can be allocated to a query to determine the amount of memory that the query actually is allocated. The relative memory comprises an amount of the absolute resources available for allocation at the
Claims (24)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/786,347 US7257580B2 (en) | 2004-02-24 | 2004-02-24 | Method, system, and program for restricting modifications to allocations of computational resources |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/786,347 US7257580B2 (en) | 2004-02-24 | 2004-02-24 | Method, system, and program for restricting modifications to allocations of computational resources |
Publications (2)
Publication Number | Publication Date |
---|---|
US20050187935A1 US20050187935A1 (en) | 2005-08-25 |
US7257580B2 true US7257580B2 (en) | 2007-08-14 |
Family
ID=34861757
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/786,347 Active 2025-06-01 US7257580B2 (en) | 2004-02-24 | 2004-02-24 | Method, system, and program for restricting modifications to allocations of computational resources |
Country Status (1)
Country | Link |
---|---|
US (1) | US7257580B2 (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20130332936A1 (en) * | 2012-06-08 | 2013-12-12 | James M. Magee | Resource Management with Dynamic Resource Budgeting |
US20210373538A1 (en) * | 2018-10-12 | 2021-12-02 | Hitachi Industrial Equipment Systems Co., Ltd. | Control Apparatus |
Families Citing this family (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050192937A1 (en) * | 2004-02-26 | 2005-09-01 | International Business Machines Corporation | Dynamic query optimization |
US7516291B2 (en) * | 2005-11-21 | 2009-04-07 | Red Hat, Inc. | Cooperative mechanism for efficient application memory allocation |
US8763113B2 (en) | 2005-11-28 | 2014-06-24 | Threatmetrix Pty Ltd | Method and system for processing a stream of information from a computer network using node based reputation characteristics |
US8141148B2 (en) | 2005-11-28 | 2012-03-20 | Threatmetrix Pty Ltd | Method and system for tracking machines on a network using fuzzy GUID technology |
US20070162480A1 (en) * | 2006-01-10 | 2007-07-12 | Kabushiki Kaisha Toshiba | System and method for monitoring consumables in a document processing environment |
US9727604B2 (en) | 2006-03-10 | 2017-08-08 | International Business Machines Corporation | Generating code for an integrated data system |
US9361137B2 (en) * | 2006-03-10 | 2016-06-07 | International Business Machines Corporation | Managing application parameters based on parameter types |
US8601467B2 (en) * | 2006-10-03 | 2013-12-03 | Salesforce.Com, Inc. | Methods and systems for upgrading and installing application packages to an application platform |
US8176178B2 (en) | 2007-01-29 | 2012-05-08 | Threatmetrix Pty Ltd | Method for tracking machines on a network using multivariable fingerprinting of passively available information |
US9444839B1 (en) | 2006-10-17 | 2016-09-13 | Threatmetrix Pty Ltd | Method and system for uniquely identifying a user computer in real time for security violations using a plurality of processing parameters and servers |
US7885976B2 (en) * | 2007-02-23 | 2011-02-08 | International Business Machines Corporation | Identification, notification, and control of data access quantity and patterns |
US20150242531A1 (en) * | 2014-02-25 | 2015-08-27 | International Business Machines Corporation | Database access control for multi-tier processing |
US20170285975A1 (en) * | 2016-04-01 | 2017-10-05 | Sanjeev N. Trika | Technologies for managing immutable data on a data storage device |
Citations (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH04321143A (en) | 1991-03-28 | 1992-11-11 | Internatl Business Mach Corp <Ibm> | General-purpose method and product for judging user access privilidge for database object and computer system for performing this method |
US6202066B1 (en) * | 1997-11-19 | 2001-03-13 | The United States Of America As Represented By The Secretary Of Commerce | Implementation of role/group permission association using object access type |
US6212511B1 (en) | 1997-10-31 | 2001-04-03 | Sun Microsystems, Inc. | Distributed system and method for providing SQL access to management information in a secure distributed network |
US20020169781A1 (en) * | 2001-05-14 | 2002-11-14 | International Business Machines Corporation | Method, system, and program product for permission to access software |
US20030005418A1 (en) * | 2001-03-19 | 2003-01-02 | C. Sridhar | Method for allocation, initialization and access of aggregate data types for architectures with differing memory granularity |
US20030037263A1 (en) | 2001-08-08 | 2003-02-20 | Trivium Systems Inc. | Dynamic rules-based secure data access system for business computer platforms |
WO2003021467A1 (en) * | 2001-08-13 | 2003-03-13 | Qualcomm, Incorporated | Using permissions to allocate device resources to an application |
US20030061504A1 (en) * | 2001-08-13 | 2003-03-27 | Sprigg Stephen A. | Application level access privilege to a storage area on a computer device |
US6611834B1 (en) | 2000-01-12 | 2003-08-26 | International Business Machines Corporation | Customization of information retrieval through user-supplied code |
US20050132379A1 (en) * | 2003-12-11 | 2005-06-16 | Dell Products L.P. | Method, system and software for allocating information handling system resources in response to high availability cluster fail-over events |
US7185192B1 (en) * | 2000-07-07 | 2007-02-27 | Emc Corporation | Methods and apparatus for controlling access to a resource |
-
2004
- 2004-02-24 US US10/786,347 patent/US7257580B2/en active Active
Patent Citations (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH04321143A (en) | 1991-03-28 | 1992-11-11 | Internatl Business Mach Corp <Ibm> | General-purpose method and product for judging user access privilidge for database object and computer system for performing this method |
US5261102A (en) | 1991-03-28 | 1993-11-09 | International Business Machines Corporation | System for determining direct and indirect user access privileges to data base objects |
US6212511B1 (en) | 1997-10-31 | 2001-04-03 | Sun Microsystems, Inc. | Distributed system and method for providing SQL access to management information in a secure distributed network |
US6202066B1 (en) * | 1997-11-19 | 2001-03-13 | The United States Of America As Represented By The Secretary Of Commerce | Implementation of role/group permission association using object access type |
US6611834B1 (en) | 2000-01-12 | 2003-08-26 | International Business Machines Corporation | Customization of information retrieval through user-supplied code |
US7185192B1 (en) * | 2000-07-07 | 2007-02-27 | Emc Corporation | Methods and apparatus for controlling access to a resource |
US20030005418A1 (en) * | 2001-03-19 | 2003-01-02 | C. Sridhar | Method for allocation, initialization and access of aggregate data types for architectures with differing memory granularity |
US20020169781A1 (en) * | 2001-05-14 | 2002-11-14 | International Business Machines Corporation | Method, system, and program product for permission to access software |
US20030037263A1 (en) | 2001-08-08 | 2003-02-20 | Trivium Systems Inc. | Dynamic rules-based secure data access system for business computer platforms |
WO2003021467A1 (en) * | 2001-08-13 | 2003-03-13 | Qualcomm, Incorporated | Using permissions to allocate device resources to an application |
US20030061504A1 (en) * | 2001-08-13 | 2003-03-27 | Sprigg Stephen A. | Application level access privilege to a storage area on a computer device |
US20050132379A1 (en) * | 2003-12-11 | 2005-06-16 | Dell Products L.P. | Method, system and software for allocating information handling system resources in response to high availability cluster fail-over events |
Non-Patent Citations (6)
Title |
---|
IBM Informix Guide to SQL: Syntax. IBM Informix Extended Parallel Server, Version 8.4; IBM Informix Dynamic Server, Version 9.3. Aug. 2002., Part No. 000-9100, Title and Copyright (pp. i-ii)), Table of Contents (pp. iii-viii), and pp. 2-647-2-648; 2-649; and 2-662-2-666. Available from http://publibfi.boulder.ibm.com/epubs/pdf/9100.pdf. |
Informix Online Documentation. Document Notes for Informix Guide to SQL: Syntax, Jan. 9, 2001, Version 8.31 [online] Available from http://www-306.ibm.com/software/data/informix/pubs/library/83eds/83docnotes/SQLSDOC.html. |
Oracle9i SQL Reference, Release 2 (9.2), Part No. A96540-01. "Listing of System and Object Privileges," Mar. 2002. Title and Copyright (pp. i-ii)), Table of Contents (iii-xvi); and pp. 17-36 to 17-50. |
Oracle9i SQL Reference, Release 2 (9.2), Part No. A96540-02. "Listing of System and Object Privileges," Mar. 2002. Title and Copyright (pp. i-ii)), Table of Contents (iii-xvi); Preface (xvii-xxxvi); Introduction (1-1 to 1-6); and pp. 17-29 to 17-52. |
Privleges Proved by MySQL. My SQL Reference Manual, Section 4.2.7, 2 pages. Retrieved on Feb. 24, 2004 [online]. Available from http://my.sql.progen.com.tr/doc/en/Privileges<SUB>-</SUB>provided.html. |
Ranjith Purush, Using Windows System Resource Manager for Server Consolidation, Dell, May 2003, pp. 1-14. * |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20130332936A1 (en) * | 2012-06-08 | 2013-12-12 | James M. Magee | Resource Management with Dynamic Resource Budgeting |
US9286120B2 (en) * | 2012-06-08 | 2016-03-15 | Apple Inc. | Resource management with dynamic resource budgeting |
US20210373538A1 (en) * | 2018-10-12 | 2021-12-02 | Hitachi Industrial Equipment Systems Co., Ltd. | Control Apparatus |
Also Published As
Publication number | Publication date |
---|---|
US20050187935A1 (en) | 2005-08-25 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
EP3433737B1 (en) | Memory sharing for working data using rdma | |
US11100103B2 (en) | Data sharing in multi-tenant database systems | |
US9984002B2 (en) | Visibility parameters for an in-memory cache | |
US9990400B2 (en) | Builder program code for in-memory cache | |
US7257580B2 (en) | Method, system, and program for restricting modifications to allocations of computational resources | |
US9858187B2 (en) | Buffering request data for in-memory cache | |
US11914591B2 (en) | Sharing materialized views in multiple tenant database systems | |
US10789384B2 (en) | Differentially private database permissions system | |
US20060101019A1 (en) | Systems and methods of access control enabling ownership of access control lists to users or groups | |
MXPA05005857A (en) | Method, system, and apparatus for discovering and connecting to data sources. | |
US20120203797A1 (en) | Enhanced control to users to populate a cache in a database system | |
US10783243B2 (en) | Dynamic, non-invasive taint tracking using auto-generated datatypes | |
US6021410A (en) | Extensible digital library | |
US20220215107A1 (en) | System and methods to perform row level field masking leveraging attribute based access control in a multi tenant environment | |
US11372859B2 (en) | Efficiently supporting value style access of MOBs stored in SQL LOB column by providing value based semantics for LOBs in RDBMS | |
CA2447458A1 (en) | System and method for managing query access to information | |
US20020188774A1 (en) | Virtualizing external data as native data | |
US10642756B2 (en) | Database variable size entry container free space handling based on use patterns | |
US20180336126A1 (en) | Database Variable Size Entry Container Page Reorganization Handling Based on Use Patterns | |
US20020188727A1 (en) | Method for processing external data for access and manipulation through a host operating environment | |
Cebollero et al. | Catalog Views and Dynamic aent Views |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AS | Assignment |
Owner name: INTERNATIONAL BUSINESS MACHINES CORPORATION, NEW Y Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:KUMAR, SAJI C.;REEL/FRAME:014727/0723 Effective date: 20040512 |
|
FEPP | Fee payment procedure |
Free format text: PAYOR NUMBER ASSIGNED (ORIGINAL EVENT CODE: ASPN); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY |
|
STCF | Information on status: patent grant |
Free format text: PATENTED CASE |
|
REMI | Maintenance fee reminder mailed | ||
FPAY | Fee payment |
Year of fee payment: 4 |
|
SULP | Surcharge for late payment | ||
AS | Assignment |
Owner name: GOOGLE INC., CALIFORNIA Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:INTERNATIONAL BUSINESS MACHINES CORPORATION;REEL/FRAME:026664/0866 Effective date: 20110503 |
|
FPAY | Fee payment |
Year of fee payment: 8 |
|
AS | Assignment |
Owner name: GOOGLE LLC, CALIFORNIA Free format text: CHANGE OF NAME;ASSIGNOR:GOOGLE INC.;REEL/FRAME:044127/0735 Effective date: 20170929 |
|
MAFP | Maintenance fee payment |
Free format text: PAYMENT OF MAINTENANCE FEE, 12TH YEAR, LARGE ENTITY (ORIGINAL EVENT CODE: M1553); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY Year of fee payment: 12 |