ATE455332T1 - Verfahren und computersystem zur abfrageverarbeitung - Google Patents

Verfahren und computersystem zur abfrageverarbeitung

Info

Publication number
ATE455332T1
ATE455332T1 AT03015365T AT03015365T ATE455332T1 AT E455332 T1 ATE455332 T1 AT E455332T1 AT 03015365 T AT03015365 T AT 03015365T AT 03015365 T AT03015365 T AT 03015365T AT E455332 T1 ATE455332 T1 AT E455332T1
Authority
AT
Austria
Prior art keywords
result
data storage
storage system
computer system
query processing
Prior art date
Application number
AT03015365T
Other languages
English (en)
Inventor
Bergen Axel Von
Volker Sauermann
Arne Schwarz
Original Assignee
Sap Ag
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 Sap Ag filed Critical Sap Ag
Application granted granted Critical
Publication of ATE455332T1 publication Critical patent/ATE455332T1/de

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/245—Query processing
    • G06F16/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24537—Query rewriting; Transformation of operators
    • 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/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24535—Query rewriting; Transformation of sub-queries or views
    • 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/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24542—Plan optimisation
    • G06F16/24545—Selectivity estimation or determination
    • 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/953—Organization of data
    • Y10S707/955—Object-oriented
    • 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/99933—Query processing, i.e. searching
    • 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/99933—Query processing, i.e. searching
    • Y10S707/99934—Query formulation, input preparation, or translation
    • 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/99933—Query processing, i.e. searching
    • Y10S707/99935—Query augmenting and refining, e.g. inexact 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/99943—Generating database or data structure, e.g. via user interface

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Operations Research (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
AT03015365T 2003-07-08 2003-07-08 Verfahren und computersystem zur abfrageverarbeitung ATE455332T1 (de)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
EP03015365A EP1496449B1 (de) 2003-07-08 2003-07-08 Verfahren und Computersystem zur Abfrageverarbeitung

Publications (1)

Publication Number Publication Date
ATE455332T1 true ATE455332T1 (de) 2010-01-15

Family

ID=33442755

Family Applications (1)

Application Number Title Priority Date Filing Date
AT03015365T ATE455332T1 (de) 2003-07-08 2003-07-08 Verfahren und computersystem zur abfrageverarbeitung

Country Status (5)

Country Link
US (1) US7231387B2 (de)
EP (2) EP1852792B1 (de)
AT (1) ATE455332T1 (de)
DE (1) DE60330955D1 (de)
WO (1) WO2005006213A2 (de)

Families Citing this family (40)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7281008B1 (en) * 2003-12-31 2007-10-09 Google Inc. Systems and methods for constructing a query result set
US7761439B1 (en) 2004-06-30 2010-07-20 Google Inc. Systems and methods for performing a directory search
US7487177B2 (en) * 2004-11-08 2009-02-03 Sap Aktiengesellschaft Set identifiers for objects
US8145642B2 (en) * 2004-11-30 2012-03-27 Oracle International Corporation Method and apparatus to support bitmap filtering in a parallel system
US8364670B2 (en) 2004-12-28 2013-01-29 Dt Labs, Llc System, method and apparatus for electronically searching for an item
US7720843B2 (en) * 2007-03-27 2010-05-18 Andrew Thomas Brunner Real-time end-user aware interactive search utilizing layered approach
US7899841B2 (en) * 2007-08-07 2011-03-01 Sap Ag Reuse of business logic of reports as data sources
US8868831B2 (en) 2009-09-14 2014-10-21 Oracle International Corporation Caching data between a database server and a storage system
EP2350875A1 (de) * 2008-09-19 2011-08-03 Oracle International Corporation Speicherseitige speicheranforderungsverwaltung
US20100169322A1 (en) * 2008-12-26 2010-07-01 Sun Microsystems, Inc. Efficient access of bitmap array with huge usage variance along linear fashion, using pointers
JP4743280B2 (ja) 2009-01-09 2011-08-10 カシオ計算機株式会社 時刻情報受信装置、電波時計およびプログラム
US10540403B1 (en) * 2011-09-22 2020-01-21 Veritas Technologies Llc Method and system to automatically resume linear review of search results
US9576046B2 (en) 2011-11-16 2017-02-21 Ptc Inc. Methods for integrating semantic search, query, and analysis across heterogeneous data types and devices thereof
US9098312B2 (en) 2011-11-16 2015-08-04 Ptc Inc. Methods for dynamically generating an application interface for a modeled entity and devices thereof
US8909641B2 (en) 2011-11-16 2014-12-09 Ptc Inc. Method for analyzing time series activity streams and devices thereof
US9900314B2 (en) 2013-03-15 2018-02-20 Dt Labs, Llc System, method and apparatus for increasing website relevance while protecting privacy
WO2014145084A1 (en) 2013-03-15 2014-09-18 Ptc Inc. Methods for managing applications using semantic modeling and tagging and devices thereof
US10528590B2 (en) 2014-09-26 2020-01-07 Oracle International Corporation Optimizing a query with extrema function using in-memory data summaries on the storage server
US9378233B2 (en) 2013-11-26 2016-06-28 Sap Se For all entries processing
US9467533B2 (en) 2014-03-21 2016-10-11 Ptc Inc. System and method for developing real-time web-service objects
US10025942B2 (en) 2014-03-21 2018-07-17 Ptc Inc. System and method of establishing permission for multi-tenancy storage using organization matrices
US9350812B2 (en) 2014-03-21 2016-05-24 Ptc Inc. System and method of message routing using name-based identifier in a distributed computing environment
US10313410B2 (en) 2014-03-21 2019-06-04 Ptc Inc. Systems and methods using binary dynamic rest messages
US9560170B2 (en) 2014-03-21 2017-01-31 Ptc Inc. System and method of abstracting communication protocol using self-describing messages
US9762637B2 (en) 2014-03-21 2017-09-12 Ptc Inc. System and method of using binary dynamic rest messages
US9462085B2 (en) 2014-03-21 2016-10-04 Ptc Inc. Chunk-based communication of binary dynamic rest messages
US9961058B2 (en) 2014-03-21 2018-05-01 Ptc Inc. System and method of message routing via connection servers in a distributed computing environment
US10338896B2 (en) 2014-03-21 2019-07-02 Ptc Inc. Systems and methods for developing and using real-time data applications
US9350791B2 (en) 2014-03-21 2016-05-24 Ptc Inc. System and method of injecting states into message routing in a distributed computing environment
US10303383B1 (en) * 2015-12-09 2019-05-28 Travelport, Lp System and method for implementing non-blocking, concurrent hash tables
US10387443B2 (en) 2016-05-09 2019-08-20 Sap Se Exporting and importing database containers
US11093443B2 (en) 2017-06-29 2021-08-17 Sap Se Database-level container group management
US10674438B2 (en) 2017-06-29 2020-06-02 Sap Se Restricting access to external schemas from within a database level container by whitelisting allowed schemas
US10776330B2 (en) 2017-06-29 2020-09-15 Sap Se Optimized re-deployment of database artifacts
US10984021B2 (en) 2017-06-29 2021-04-20 Sap Se Deployment of independent database artifact groups
US11086876B2 (en) 2017-09-29 2021-08-10 Oracle International Corporation Storing derived summaries on persistent memory of a storage device
US10657114B2 (en) 2017-11-28 2020-05-19 Sap Se Reserving key specifications
US11030164B2 (en) 2018-01-18 2021-06-08 Sap Se Artifact deployment for application managed service instances
US11157478B2 (en) 2018-12-28 2021-10-26 Oracle International Corporation Technique of comprehensively support autonomous JSON document object (AJD) cloud service
US12079186B2 (en) * 2022-01-19 2024-09-03 Workday, Inc. Using condensed bitmap representation for filtering of datasets

Family Cites Families (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4849905A (en) * 1987-10-28 1989-07-18 International Business Machines Corporation Method for optimized RETE pattern matching in pattern-directed, rule-based artificial intelligence production systems
GB9105367D0 (en) * 1991-03-13 1991-04-24 Univ Strathclyde Computerised information-retrieval database systems
US5355473A (en) * 1991-06-20 1994-10-11 Lawrence Au Indexed record locating and counting mechanism
US5737732A (en) * 1992-07-06 1998-04-07 1St Desk Systems, Inc. Enhanced metatree data structure for storage indexing and retrieval of information
WO1995011487A1 (en) * 1993-10-22 1995-04-27 Fdc, Inc. Database using table rotation and bimapped queries
US5657437A (en) 1993-12-10 1997-08-12 Lucent Technologies Inc. Data processing apparatus and method including proportional updating of data
US5557786A (en) * 1994-01-24 1996-09-17 Advanced Computer Applications, Inc. Threaded, height-balanced binary tree data structure
US5742806A (en) * 1994-01-31 1998-04-21 Sun Microsystems, Inc. Apparatus and method for decomposing database queries for database management system including multiprocessor digital data processing system
US5893088A (en) * 1996-04-10 1999-04-06 Altera Corporation System and method for performing database query using a marker table
US5715413A (en) * 1996-06-25 1998-02-03 International Business Machines Corporation Dragging and dropping with an instantiation object
US6829695B1 (en) * 1999-09-03 2004-12-07 Nexql, L.L.C. Enhanced boolean processor with parallel input
AU7100600A (en) * 1999-09-03 2001-04-10 Whamtech, L.P. Index relational processor
DE10104831A1 (de) * 2001-02-01 2002-08-08 Sap Ag Datenstruktur für Informationssysteme

Also Published As

Publication number Publication date
WO2005006213A2 (en) 2005-01-20
WO2005006213A3 (en) 2005-04-14
EP1496449B1 (de) 2010-01-13
EP1496449A1 (de) 2005-01-12
EP1852792B1 (de) 2013-04-17
US20050021506A1 (en) 2005-01-27
DE60330955D1 (de) 2010-03-04
US7231387B2 (en) 2007-06-12
EP1852792A1 (de) 2007-11-07

Similar Documents

Publication Publication Date Title
DE60330955D1 (de) Verfahren und Computersystem zur Abfrageverarbeitung
DE69811832D1 (de) Verfahren zur Schätzung von Statistiken der Eigenschaften von durch eine Prozessorpipeline bearbeiteten Wechselwirkungen
DE60128201D1 (de) Verfahren und Vorrichtung zur Verwaltung von Information, und Rechnerprogramm
EP1962209A3 (de) Systeme und Verfahren zum Suchen und Speichern von Daten
ATE315256T1 (de) Verfahren zur extraktion eines hash-strings
EP1087306A3 (de) Meta-Dokumente und entsprechendes Verwaltungsverfahren
EP2261820A3 (de) Erstellen von Datenprofilen
DE60321660D1 (de) Verfahren und system zur speicherung und weiterleitung von multimedia-tags
DE60237222D1 (de) Verfahren und vorrichtung zur klassifizierung von datenpaketen mit hilfe eines zweistufigen hash-abgleichverfahrens
DE60001478D1 (de) Verfahren sowie Vorrichtung zur Aktualisierung von Widerrufungsinformation, und Speichermedium
DE602004008776D1 (de) Vorrichtung und verfahren zur konfiguration von sprachlesern unter verwendung semantischer analyse
EP1501029A3 (de) System zum Verwalten und Inspizieren von Anlagen und Verfahren dazu
DE60130430D1 (de) Verfahren und vorrichtung zur informationsverarbeitung
WO2002091117A3 (en) Process control loop analysis system
EP1164505A3 (de) Datenverarbeitungsvorrichtung und -verfahren
WO2008070811A3 (en) Apparatus, system, and method for managing data in a storage device with an empty data token directive
EP1517216A3 (de) Verfahren zum Einräumen von DRM Lizenzen das mehrere Geräte unterstützt
TW200609824A (en) Method and apparatus for dynamic extension of device management tree data model on a mobile device
DE60100090D1 (de) Verfahren zur Verwaltung eines Sprach-Cachespeichers
EP1507246A4 (de) Map-datenprodukt, map-datenverarbeitungsprogrammprodukt, map-datenverarbeitungsverfahren und map-datenverarbeitungseinrichtung
CA2293064A1 (en) Method and apparatus for analyzing data retrieval using index scanning
EP1508864A3 (de) Verfahren und Gerät um Daten in einem strukturierten Dokument zu suchen
DE60320002D1 (de) Vorrichtung und verfahren zum zugriff von kontaktinformationen in einem kommunikationsgerät
ATE344946T1 (de) System und verfahren für eine datentabelle zur verwaltung von einsetzvorgängen bei rekursiven skalierbaren vorlageninstanzen
EP1335305A3 (de) Algorithmus für dynamische Auswahl von der Datenverriegelungsgranularität

Legal Events

Date Code Title Description
RER Ceased as to paragraph 5 lit. 3 law introducing patent treaties