WO2012083265A3 - Bulk operations - Google Patents

Bulk operations Download PDF

Info

Publication number
WO2012083265A3
WO2012083265A3 PCT/US2011/065660 US2011065660W WO2012083265A3 WO 2012083265 A3 WO2012083265 A3 WO 2012083265A3 US 2011065660 W US2011065660 W US 2011065660W WO 2012083265 A3 WO2012083265 A3 WO 2012083265A3
Authority
WO
WIPO (PCT)
Prior art keywords
operations
bulk
bulk operations
language
update
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
PCT/US2011/065660
Other languages
French (fr)
Other versions
WO2012083265A2 (en
Inventor
Henricus Johannes Maria Meijer
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
Priority to EP11849233.9A priority Critical patent/EP2652593A4/en
Priority to CA2820921A priority patent/CA2820921A1/en
Priority to AU2011343425A priority patent/AU2011343425A1/en
Publication of WO2012083265A2 publication Critical patent/WO2012083265A2/en
Publication of WO2012083265A3 publication Critical patent/WO2012083265A3/en
Anticipated expiration legal-status Critical
Ceased legal-status Critical Current

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/242—Query formulation
    • G06F16/2433—Query languages
    • 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/23—Updating
    • G06F16/2379—Updates performed during online database operations; commit processing
    • G06F16/2386—Bulk updating operations

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Input From Keyboards Or The Like (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

Bulk operations including create, update, and delete operations are supported within the context of language-integrated queries. Such bulk operations can be implemented as distinct operations. Other operations, including query operators defining a collection of data over which the bulk operations can execute, can be restricted as a function of a specific bulk operation.
PCT/US2011/065660 2010-12-17 2011-12-16 Bulk operations Ceased WO2012083265A2 (en)

Priority Applications (3)

Application Number Priority Date Filing Date Title
EP11849233.9A EP2652593A4 (en) 2010-12-17 2011-12-16 Bulk operations
CA2820921A CA2820921A1 (en) 2010-12-17 2011-12-16 Bulk operations
AU2011343425A AU2011343425A1 (en) 2010-12-17 2011-12-16 Bulk operations

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US12/971,864 2010-12-17
US12/971,864 US20120158763A1 (en) 2010-12-17 2010-12-17 Bulk operations

Publications (2)

Publication Number Publication Date
WO2012083265A2 WO2012083265A2 (en) 2012-06-21
WO2012083265A3 true WO2012083265A3 (en) 2012-12-06

Family

ID=46235789

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2011/065660 Ceased WO2012083265A2 (en) 2010-12-17 2011-12-16 Bulk operations

Country Status (6)

Country Link
US (1) US20120158763A1 (en)
EP (1) EP2652593A4 (en)
CN (1) CN102591933A (en)
AU (1) AU2011343425A1 (en)
CA (1) CA2820921A1 (en)
WO (1) WO2012083265A2 (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR101442659B1 (en) * 2013-03-27 2014-09-23 (주)티베로 Psm compiler optimization apparatus and method for bulk-dml processing
CN112738148B (en) * 2019-10-28 2024-05-14 中兴通讯股份有限公司 Batch deletion method, device and equipment of cache content and readable storage medium
US12554756B1 (en) * 2024-11-19 2026-02-17 Cisco Technology, Inc. Auto collection processing

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050262124A1 (en) * 2004-05-19 2005-11-24 Christensen Barabara A Method and apparatus for aggregated update of dataset records in a JavaScript environment
US20070061797A1 (en) * 2005-09-12 2007-03-15 Oracle International Corporation Bulk loading system and method
US20090265583A1 (en) * 2008-04-17 2009-10-22 Csi Technology, Inc. Monitoring Device Having Multiple Data Communication Paths
US20100204963A1 (en) * 2009-02-11 2010-08-12 Livermore Software Technology Corporation Thermal Fluid-Structure Interaction Simulation in Finite Element Analysis

Family Cites Families (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CA2383713A1 (en) * 2002-04-26 2003-10-26 Ibm Canada Limited-Ibm Canada Limitee Managing attribute-tagged index entries
US7480661B2 (en) * 2002-07-22 2009-01-20 Microsoft Corporation Query services for database system
US7464385B1 (en) * 2003-05-09 2008-12-09 Vignette Corporation Method and system for performing bulk operations on transactional items
US20060085243A1 (en) * 2004-09-24 2006-04-20 Workscape, Inc. Business process management method and system
US7440957B1 (en) * 2005-11-30 2008-10-21 At&T Intellectual Property Ii, L.P. Updates through views
US7680767B2 (en) * 2006-03-23 2010-03-16 Microsoft Corporation Mapping architecture with incremental view maintenance
US7908259B2 (en) * 2006-08-25 2011-03-15 Teradata Us, Inc. Hardware accelerated reconfigurable processor for accelerating database operations and queries
US8229966B2 (en) * 2007-09-07 2012-07-24 Teradata Us, Inc. System to generate a structured query language query by using a dimensional hierarchy
CN101436184B (en) * 2007-11-15 2011-08-03 金蝶软件（中国）有限公司 Batch data operating method
US8713048B2 (en) * 2008-06-24 2014-04-29 Microsoft Corporation Query processing with specialized query operators
US8671096B2 (en) * 2008-10-24 2014-03-11 International Business Machines Corporation Methods and apparatus for context-sensitive information retrieval based on interactive user notes

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050262124A1 (en) * 2004-05-19 2005-11-24 Christensen Barabara A Method and apparatus for aggregated update of dataset records in a JavaScript environment
US20070061797A1 (en) * 2005-09-12 2007-03-15 Oracle International Corporation Bulk loading system and method
US20090265583A1 (en) * 2008-04-17 2009-10-22 Csi Technology, Inc. Monitoring Device Having Multiple Data Communication Paths
US20100204963A1 (en) * 2009-02-11 2010-08-12 Livermore Software Technology Corporation Thermal Fluid-Structure Interaction Simulation in Finite Element Analysis

Also Published As

Publication number Publication date
CN102591933A (en) 2012-07-18
AU2011343425A1 (en) 2013-07-18
EP2652593A2 (en) 2013-10-23
US20120158763A1 (en) 2012-06-21
EP2652593A4 (en) 2017-06-07
WO2012083265A2 (en) 2012-06-21
CA2820921A1 (en) 2012-06-21

Similar Documents

Publication Publication Date Title
USD783053S1 (en) Computer screen with icon
USD716784S1 (en) Mobile phone case
USD738452S1 (en) Firearm charging handle
WO2012135210A3 (en) Location-based conversational understanding
MX2016005921A (en) Fungal endophytes for improved crop yields and protection from pests.
EP2545426A4 (en) Multimodal text input system, such as for use with touch screens on mobile phones
WO2013077987A3 (en) Management of privacy settings for a user device
USD813908S1 (en) Cellular phone with graphical user interface
EP3337933A4 (en) Intelligent, data gathering and communicating portable restrooms
WO2014191113A8 (en) Novel antibodies
WO2011108902A3 (en) Compound comprising at least two compounds comprising at least two five-membered hetero rings, an organic electrical element using the same and a terminal thereof
EP3023414A4 (en) Compound, light-emitting material, and organic light-emitting element
WO2012039923A3 (en) Data model dualization
WO2011149283A3 (en) Compound comprising a five-membered hetero ring, an organic electrical element using the same and a terminal thereof
WO2012018416A3 (en) Soil stabilizer containing carbonaceous material and methods for using same
WO2015002790A3 (en) Generating and optimizing protocols
USD768101S1 (en) Cellular phone
WO2011084876A3 (en) Efficient immutable syntax representation with incremental change
USD778307S1 (en) Cellular phone screen with graphical user interface
MX347323B (en) Solid, particulate tanning agent preparations.
WO2013009032A3 (en) Novel organic electroluminescent compound, and organic electroluminescent device including same
WO2011108901A3 (en) Spiro-carbazole compound comprising a spiro skeleton, and an organic electronic element using the same and a terminal thereof
AU2013256443A8 (en) Signal select in underground line location
WO2012010880A3 (en) Cellulosic material such as tobacco comprising one or more smoke diluents
WO2012083265A3 (en) Bulk operations

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 11849233

Country of ref document: EP

Kind code of ref document: A2

ENP Entry into the national phase

Ref document number: 2820921

Country of ref document: CA

WWE Wipo information: entry into national phase

Ref document number: 2011849233

Country of ref document: EP

NENP Non-entry into the national phase

Ref country code: DE

ENP Entry into the national phase

Ref document number: 2011343425

Country of ref document: AU

Date of ref document: 20111216

Kind code of ref document: A