WO2005094206A3 - System and method for locking and isolation in a storage platform - Google Patents

System and method for locking and isolation in a storage platform Download PDF

Info

Publication number
WO2005094206A3
WO2005094206A3 PCT/US2004/024435 US2004024435W WO2005094206A3 WO 2005094206 A3 WO2005094206 A3 WO 2005094206A3 US 2004024435 W US2004024435 W US 2004024435W WO 2005094206 A3 WO2005094206 A3 WO 2005094206A3
Authority
WO
WIPO (PCT)
Prior art keywords
file system
statements
transaction
locking
query language
Prior art date
Application number
PCT/US2004/024435
Other languages
French (fr)
Other versions
WO2005094206A2 (en
Inventor
Rajan B Rajeev
Balan Sethu Raman
Original Assignee
Microsoft Corp
Rajan B Rajeev
Balan Sethu Raman
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, Rajan B Rajeev, Balan Sethu Raman filed Critical Microsoft Corp
Priority to EP04779480A priority Critical patent/EP1723552A4/en
Priority to JP2007502784A priority patent/JP2007528555A/en
Publication of WO2005094206A2 publication Critical patent/WO2005094206A2/en
Publication of WO2005094206A3 publication Critical patent/WO2005094206A3/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers

Abstract

The sharing model for file system operations is unified with the transaction and locking model of query language statements to provide an overall framework for locking and isolation in a storage platform (308). Additionally, transactional support is provided for file system operations so that they may be executed in the context of a transaction. Accordingly, a single transaction may include a single file system statement, a single query language statement, multiple file system statements, multiple query language statements, and a combination of file system and query language statements. Furthermore, support is provided for non-transacted file systems statements so that file system statements need not necessarily be executed in the context of a transaction.
PCT/US2004/024435 2004-03-10 2004-07-29 System and method for locking and isolation in a storage platform WO2005094206A2 (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
EP04779480A EP1723552A4 (en) 2004-03-10 2004-07-29 System and method for locking and isolation in a storage platform
JP2007502784A JP2007528555A (en) 2004-03-10 2004-07-29 System and method for locking and isolation in a storage platform

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US10/797,238 US20050203903A1 (en) 2004-03-10 2004-03-10 System and method for locking and isolation in a storage platform
US10/797,238 2004-03-10

Publications (2)

Publication Number Publication Date
WO2005094206A2 WO2005094206A2 (en) 2005-10-13
WO2005094206A3 true WO2005094206A3 (en) 2006-02-23

Family

ID=34920003

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2004/024435 WO2005094206A2 (en) 2004-03-10 2004-07-29 System and method for locking and isolation in a storage platform

Country Status (6)

Country Link
US (1) US20050203903A1 (en)
EP (1) EP1723552A4 (en)
JP (1) JP2007528555A (en)
KR (1) KR20060116140A (en)
CN (2) CN1856784A (en)
WO (1) WO2005094206A2 (en)

Families Citing this family (19)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7548918B2 (en) * 2004-12-16 2009-06-16 Oracle International Corporation Techniques for maintaining consistency for different requestors of files in a database management system
US7627574B2 (en) * 2004-12-16 2009-12-01 Oracle International Corporation Infrastructure for performing file operations by a database server
US20060136508A1 (en) * 2004-12-16 2006-06-22 Sam Idicula Techniques for providing locks for file operations in a database management system
US7716260B2 (en) * 2004-12-16 2010-05-11 Oracle International Corporation Techniques for transaction semantics for a database server performing file operations
CN100437495C (en) * 2004-12-21 2008-11-26 鸿富锦精密工业(深圳)有限公司 System and method for solving conflicts of locking up resources repeatedly
US8224837B2 (en) * 2005-06-29 2012-07-17 Oracle International Corporation Method and mechanism for supporting virtual content in performing file operations at a RDBMS
US7809675B2 (en) * 2005-06-29 2010-10-05 Oracle International Corporation Sharing state information among a plurality of file operation servers
CA2512385C (en) * 2005-07-08 2008-11-04 Marathon Marine Manufacturing (1996) Ltd. Cargo deck for a truck box
US8166059B2 (en) * 2005-07-08 2012-04-24 Oracle International Corporation Optimization of queries on a repository based on constraints on how the data is stored in the repository
US20070118559A1 (en) * 2005-11-18 2007-05-24 Microsoft Corporation File system filters and transactions
US7610304B2 (en) * 2005-12-05 2009-10-27 Oracle International Corporation Techniques for performing file operations involving a link at a database management system
US8250094B2 (en) * 2006-07-19 2012-08-21 Microsoft Corporation Relational lockdown for an item store
CN102006179B (en) * 2009-08-28 2014-08-13 中兴通讯股份有限公司 Methods and devices for data backup and data backspacing
CN102214247B (en) * 2011-07-21 2013-06-12 山东地纬计算机软件有限公司 File transaction method capable of supporting concurrency
CN104933196B (en) * 2015-07-13 2019-06-21 上海斐讯数据通信技术有限公司 Data base management method and system in a kind of embedded system
CN105550270B (en) * 2015-12-09 2019-07-12 百度在线网络技术(北京)有限公司 Data base query method and device
CN105653610A (en) * 2015-12-25 2016-06-08 数源科技股份有限公司 Method for rapidly displaying large-volume data information
CN105550366B (en) * 2016-01-20 2019-10-18 百度在线网络技术(北京)有限公司 Inventory information treating method and apparatus
CN109598077A (en) * 2018-12-11 2019-04-09 中国航空工业集团公司西安航空计算技术研究所 A kind of graphics pipeline device and modeling method based on GPU chip

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6067542A (en) * 1995-10-20 2000-05-23 Ncr Corporation Pragma facility and SQL3 extension for optimal parallel UDF execution
US6606626B1 (en) * 1998-10-20 2003-08-12 Sybase, Inc. Database system with lock manager enhancement for improving concurrency

Family Cites Families (22)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5369757A (en) * 1991-06-18 1994-11-29 Digital Equipment Corporation Recovery logging in the presence of snapshot files by ordering of buffer pool flushing
US5452445A (en) * 1992-04-30 1995-09-19 Oracle Corporation Two-pass multi-version read consistency
US6029160A (en) * 1995-05-24 2000-02-22 International Business Machines Corporation Method and means for linking a database system with a system for filing data
US6128771A (en) * 1996-02-09 2000-10-03 Sun Microsystems, Inc. System and method for automatically modifying database access methods to insert database object handling instructions
US5870758A (en) * 1996-03-11 1999-02-09 Oracle Corporation Method and apparatus for providing isolation levels in a database system
FR2762418B1 (en) * 1997-04-17 1999-06-11 Alsthom Cge Alcatel METHOD FOR MANAGING A SHARED MEMORY
US5983225A (en) * 1998-01-26 1999-11-09 Telenor As Parameterized lock management system and method for conditional conflict serializability of transactions
GB9827415D0 (en) * 1998-12-11 1999-02-03 Wild Andrew M Surgical apparatus and method for occluding a body passageway
US6922708B1 (en) * 1999-02-18 2005-07-26 Oracle International Corporation File system that supports transactions
US6453313B1 (en) * 1999-07-06 2002-09-17 Compaq Information Technologies Group, L.P. Database management system and method for dequeuing rows published to a database table
US6339772B1 (en) * 1999-07-06 2002-01-15 Compaq Computer Corporation System and method for performing database operations on a continuous stream of tuples
EP1330727A2 (en) * 1999-08-05 2003-07-30 Oracle Corporation Internet file system
US6393435B1 (en) * 1999-09-22 2002-05-21 International Business Machines, Corporation Method and means for evaluating the performance of a database system referencing files external to the database system
US6564215B1 (en) * 1999-12-16 2003-05-13 International Business Machines Corporation Update support in database content management
JP3992263B2 (en) * 2000-03-30 2007-10-17 株式会社日立製作所 Database-file linkage method
US6571252B1 (en) * 2000-04-12 2003-05-27 International Business Machines Corporation System and method for managing persistent objects using a database system
US6772155B1 (en) * 2001-04-04 2004-08-03 Ncr Corporation Looking data in a database system
US6874001B2 (en) * 2001-10-05 2005-03-29 International Business Machines Corporation Method of maintaining data consistency in a loose transaction model
US7035874B1 (en) * 2002-03-29 2006-04-25 Ncr Corp. Media streaming in a database
US7146366B2 (en) * 2002-09-13 2006-12-05 Netezza Corporation Distributed concurrency control using serialization ordering
US20040117372A1 (en) * 2002-12-17 2004-06-17 Bulent Kasman System and method for controlling access to system resources
CA2425033A1 (en) * 2003-04-08 2004-10-08 Ibm Canada Limited - Ibm Canada Limitee Multi-level locking hierarchy in a database with multi-dimensional clustering

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6067542A (en) * 1995-10-20 2000-05-23 Ncr Corporation Pragma facility and SQL3 extension for optimal parallel UDF execution
US6606626B1 (en) * 1998-10-20 2003-08-12 Sybase, Inc. Database system with lock manager enhancement for improving concurrency

Also Published As

Publication number Publication date
KR20060116140A (en) 2006-11-14
CN101266617A (en) 2008-09-17
JP2007528555A (en) 2007-10-11
EP1723552A2 (en) 2006-11-22
CN1856784A (en) 2006-11-01
US20050203903A1 (en) 2005-09-15
EP1723552A4 (en) 2009-04-29
WO2005094206A2 (en) 2005-10-13

Similar Documents

Publication Publication Date Title
WO2005094206A3 (en) System and method for locking and isolation in a storage platform
WO2005028627A3 (en) Performing sequence analysis as a relational join
WO2005074630A3 (en) Multilingual text-to-speech system with limited resources
WO2005029364A8 (en) System and method for managing dynamic content assembly
WO2006001924A3 (en) Method and apparatus for implementing a file system
WO2007021386A3 (en) Analysis and transformation tools for strctured and unstructured data
WO2008070362A3 (en) System and method for converting a natural language query into a logical query
WO2007070743A3 (en) Method for constructing and repurposing rhetorical content
WO2007076352A3 (en) System and method for accessing and managing mobile device metadata
WO2008045981A3 (en) Virtual network of real-world entities
WO2007067921A3 (en) Techniques for co-existence of multiple stored value applications on a single payment device managing a shared balance
TW200708943A (en) Intelligent auto-archiving
WO2008060860A3 (en) A method of improving a query to a database system
WO2009006023A3 (en) Memory transaction grouping
WO2006036955A3 (en) Gift registry system
WO2007134242A3 (en) Method for generating decision trees integrated with petro-technical workflows
WO2007078538A3 (en) Coordinating access to memory locations for hardware transactional memory transactions and software transactional memory transactions
WO2007132233A3 (en) Method and system for user equipment configuration
WO2007001635A3 (en) Active content trust model
WO2008139936A1 (en) Database structuring support system
WO2007002282A3 (en) Managing memory pages
WO2005060684A3 (en) Method and system for obtaining solutions to contradictional problems from a semantically indexed database
WO2007020094A8 (en) Framework wing box for a wing
WO2006010023A3 (en) System and method for enabling the establishment and use of a personal network
WO2006015924A3 (en) Managing paths to an input/output (i/o) device

Legal Events

Date Code Title Description
WWE Wipo information: entry into national phase

Ref document number: 1020057011224

Country of ref document: KR

WWE Wipo information: entry into national phase

Ref document number: 2707/DELNP/2005

Country of ref document: IN

WWE Wipo information: entry into national phase

Ref document number: 2004779480

Country of ref document: EP

WWE Wipo information: entry into national phase

Ref document number: 2007502784

Country of ref document: JP

WWE Wipo information: entry into national phase

Ref document number: 20048016964

Country of ref document: CN

AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BW BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE EG ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NA NI NO NZ OM PG PH PL PT RO RU SC SD SE SG SK SL SY TJ TM TN TR TT TZ UA UG US UZ VC VN YU ZA ZM ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): GM KE LS MW MZ NA SD SL SZ TZ UG ZM ZW AM AZ BY KG KZ MD RU TJ TM AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IT LU MC NL PL PT RO SE SI SK TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

NENP Non-entry into the national phase

Ref country code: DE

WWW Wipo information: withdrawn in national office

Ref document number: DE

WWP Wipo information: published in national office

Ref document number: 2004779480

Country of ref document: EP