HK1118118A1 - Method for controlling a relational database system - Google Patents
Method for controlling a relational database systemInfo
- 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
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.
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)
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)
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 |
-
2005
- 2005-10-28 CA CA002626048A patent/CA2626048A1/en not_active Abandoned
- 2005-10-28 JP JP2008536874A patent/JP5087547B2/en not_active Expired - Fee Related
- 2005-10-28 WO PCT/AT2005/000430 patent/WO2007048148A1/en active Application Filing
- 2005-10-28 ES ES05799132T patent/ES2350243T3/en active Active
- 2005-10-28 AT AT05799132T patent/ATE476712T1/en active
- 2005-10-28 CN CN2005800519436A patent/CN101297290B/en not_active Expired - Fee Related
- 2005-10-28 EP EP05799132A patent/EP1941395B1/en not_active Not-in-force
- 2005-10-28 DE DE502005010057T patent/DE502005010057D1/en active Active
-
2008
- 2008-08-19 HK HK08109268.8A patent/HK1118118A1/en not_active IP Right Cessation
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 |