HK1118118A1 - Method for controlling a relational database system - Google Patents

Method for controlling a relational database system

Info

Publication number
HK1118118A1
HK1118118A1 HK08109268.8A HK08109268A HK1118118A1 HK 1118118 A1 HK1118118 A1 HK 1118118A1 HK 08109268 A HK08109268 A HK 08109268A HK 1118118 A1 HK1118118 A1 HK 1118118A1
Authority
HK
Hong Kong
Prior art keywords
data tables
database
relations
relational database
controlling
Prior art date
Application number
HK08109268.8A
Inventor
Matthias Moestl
Original Assignee
Mediareif Mostl & Reif Kommuni
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 Mediareif Mostl & Reif Kommuni filed Critical Mediareif Mostl & Reif Kommuni
Publication of HK1118118A1 publication Critical patent/HK1118118A1/en

Links

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/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2433—Query languages
    • G06F16/2448—Query languages for particular applications; for extensibility, e.g. user defined types
    • 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/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2433—Query languages
    • G06F16/2445—Data retrieval commands; View definitions

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Computational Linguistics (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Vehicle Body Suspensions (AREA)
  • Control Of Metal Rolling (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
  • Analysing Materials By The Use Of Radiation (AREA)

Abstract

The invention relates to a method for controlling a relational database system by executing, using a database language, a database inquiry in a relational database which comprises as the assigned data structure a plurality of data tables interlinked by relations, a table of said relations being available. A processable database instruction without relation-specific operations is established by indicating those data tables to which the processing functions should be applied and also indicating the order of the selected data tables which should be used for processing. An access path is determined which concretely specifies an access order to the database. For this purpose, a partial access path is calculated using the table of relations between two successive, selected data tables based on the relations existing between the two successive data tables. The access path is then put together from all the calculated partial access paths.
HK08109268.8A 2005-10-28 2008-08-19 Method for controlling a relational database system HK1118118A1 (en)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/AT2005/000430 WO2007048148A1 (en) 2005-10-28 2005-10-28 Method for controlling a relational database system

Publications (1)

Publication Number Publication Date
HK1118118A1 true HK1118118A1 (en) 2009-01-30

Family

ID=35427226

Family Applications (1)

Application Number Title Priority Date Filing Date
HK08109268.8A HK1118118A1 (en) 2005-10-28 2008-08-19 Method for controlling a relational database system

Country Status (9)

Country Link
EP (1) EP1941395B1 (en)
JP (1) JP5087547B2 (en)
CN (1) CN101297290B (en)
AT (1) ATE476712T1 (en)
CA (1) CA2626048A1 (en)
DE (1) DE502005010057D1 (en)
ES (1) ES2350243T3 (en)
HK (1) HK1118118A1 (en)
WO (1) WO2007048148A1 (en)

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102646111A (en) * 2012-02-16 2012-08-22 中国测绘科学研究院 Knowledge base-based fast construction method of common correlation information query tree
CN105306987B (en) * 2015-10-23 2018-06-22 深圳国微技术有限公司 A kind of device for controlling TS stream interface bit rate outputs
CN106933929B (en) * 2015-12-31 2020-02-07 北京国双科技有限公司 Method and device for adjusting data table connection
CN108205593A (en) * 2017-12-29 2018-06-26 华为技术有限公司 A kind of method and device of inquiry
CN111125155B (en) * 2018-10-31 2023-10-27 北京国双科技有限公司 Access path-based data query method, device, storage medium and processor
CN111831882B (en) * 2019-04-16 2024-07-30 阿里巴巴集团控股有限公司 Query interaction method and device

Family Cites Families (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP3779431B2 (en) * 1997-06-13 2006-05-31 富士通株式会社 Relational database management device, intermediate link table automatic creation processing method, and program storage medium
JP3856978B2 (en) * 1999-03-30 2006-12-13 三菱電機株式会社 Hierarchical distribution diagram display method and computer-readable recording medium recording program
DK173451B1 (en) * 1999-04-16 2000-11-20 Targit As Method, apparatus and data carrier for processing queries to a database
US6834287B1 (en) * 2001-03-14 2004-12-21 Trilogy Development Group, Inc. Classification engine for managing attribute-based data
US20050076045A1 (en) * 2001-03-19 2005-04-07 Pal Stenslet Method and system for handling multiple dimensions in relational databases
US7617179B2 (en) * 2002-06-29 2009-11-10 Ianywhere Solutions, Inc. System and methodology for cost-based subquery optimization using a left-deep tree join enumeration algorithm
CN1560763B (en) * 2004-02-19 2010-05-05 北京大学 Method for translating expandable mark language path inquiry into structure inquiry

Also Published As

Publication number Publication date
DE502005010057D1 (en) 2010-09-16
EP1941395A1 (en) 2008-07-09
EP1941395B1 (en) 2010-08-04
JP2009514071A (en) 2009-04-02
WO2007048148A1 (en) 2007-05-03
CN101297290B (en) 2013-05-08
CA2626048A1 (en) 2007-05-03
ES2350243T3 (en) 2011-01-20
ATE476712T1 (en) 2010-08-15
CN101297290A (en) 2008-10-29
JP5087547B2 (en) 2012-12-05

Similar Documents

Publication Publication Date Title
TW200725320A (en) Itinerary planning system and method
HK1118118A1 (en) Method for controlling a relational database system
WO2003038550A3 (en) Systems and methods for table driven automation testing of software programs
RU2008114301A (en) EXTENDED METADATA
WO2014035879A3 (en) Operating a distributed database with foreign tables
WO2010030392A3 (en) Interpersonal spacetime interaction system
NO20080376L (en) Ranking function that uses a predetermined click-through distance to a document on a network
GB2429554A (en) Method and apparatus to vectorize multiple input instructions
WO2008027765A3 (en) Apparatus and method for processing queries against combinations of data sources
WO2008067357A3 (en) System for overriding bytecode, which should be interpreted, with native code, which can be directly executed
WO2006050615A8 (en) Searching for and providing objects using byte-by-byte comparison
WO2006112969A3 (en) Path expression in structured query language
WO2010062737A3 (en) Retrieval using a generalized sentence collocation
WO2008052132A3 (en) Pattern-based filtering of query input
CA2422161A1 (en) Decoupled object identification for object switching in database systems
ATE551640T1 (en) METHOD FOR DYNAMIC CONFIGURATION OF A USER INTERFACE OF A FUNCTIONAL BLOCK
TW200731133A (en) Firmware filters and patches
DE602004022517D1 (en) A data processing system and method for monitoring database replication
DE502005000908D1 (en) Mechanism for dynamically registering files in a batch-aware environment
WO2007024578A3 (en) Method and apparatus for providing a comparative product information of related products
TW200601808A (en) Integrated dialogue system and method thereof
WO2009044398A3 (en) A method and computer program for evaluating database queries involving relational and hierarchical data
ATE418106T1 (en) GENERIC SEARCH METHOD FOR DIFFERENT OBJECT TYPES
WO2007074469A3 (en) Method and system for compiling a source code
WO2019126797A3 (en) System and method for executing instructions

Legal Events

Date Code Title Description
PC Patent ceased (i.e. patent has lapsed due to the failure to pay the renewal fee)

Effective date: 20151028