WO2004063941A1 - Method and device for accessing a database - Google Patents
Method and device for accessing a database Download PDFInfo
- Publication number
- WO2004063941A1 WO2004063941A1 PCT/EP2003/013440 EP0313440W WO2004063941A1 WO 2004063941 A1 WO2004063941 A1 WO 2004063941A1 EP 0313440 W EP0313440 W EP 0313440W WO 2004063941 A1 WO2004063941 A1 WO 2004063941A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- database
- category
- interface
- searchtext
- search
- 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/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/332—Query formulation
- G06F16/3322—Query formulation using system suggestions
- G06F16/3323—Query formulation using system suggestions using document space presentation or visualization, e.g. category, hierarchy or range presentation and selection
Definitions
- the present invention relates to a method for accessing a database including the steps of presenting at least one category item defining a search criterion for the database, selecting one or more of the at least one category item and searching in the database according to the selected one or more category items. Furthermore, the present invention re- lates to a corresponding device for accessing a database.
- the advantage of method 1 is that one can browse all data in the database. Its disadvantage is that it is an inefficient method in case of a large database.
- the advantage of method 2 is that one can query the database quickly by a keyword. Its disadvantage is that there is no guarantee to find the desired results, if the wrong keywords are used.
- the method 3 makes use of the advantages of method 1 and 2. It uses pre-defined categories (keywords) to sort and access all data in the database. By using method 3, the user may search for desired data efficiently among all database data.
- the disadvantage of method 3 is that the defined categories and associated database access implementation must be pre-built in the database-interface-machine. If users want to update categories and/or database access methods in their interface machine, they must update the related software or hardware.
- WO 02/15047 discloses an interface system for accessing data stored in a database.
- the interface comprises a data dictionary structurally defining the database and a dictionary of interface defining descriptors.
- the interface descriptors can be modified or new descriptors can be added.
- the interface descriptor has to be combined with the dictionary de- fined in the database.
- the database itself is also modified.
- a further document US 6026333 discloses a data management system comprising a database and a category definition dictionary.
- the category definition dictionary defines catego- ries for different time periods. These definitions are used when data has to be searched from the database .
- the category definitions are used for tracking re-classifications of products from a first category to a second category. An addition of categories is not disclosed.
- a method for accessing a database including the steps of presenting at least one category item defining a search criterion for said database, selecting one or more of said at least one category item, and searching in said database according to said selected one or more category items, wherein said at least one category item is provided within interface descriptor means being commonly available for da- tabase accesses.
- a device for accessing a database including display means for presenting at least one category item defining a search criterion for said database, selecting means connected to said display means for selecting one or more of said at least one category item, and searching means connected to said selecting means for searching in said database according to said selected one or more category items, wherein said display means being connectable to external interface descriptor means providing said at least one category item.
- the interface descriptor may be a XML file or a file in another standard programming language, which describes interface categories and database access strategies .
- a so formed database interface machine contains a standard category display method and a standard database access method, which, however, can use the definition of an interface descriptor to set up a categorized interface to the database and complete database search.
- the advantage of using such interface descriptor is, that, when users want to update the interface category and database access method, they do not need to change the software or hardware of the interface machine. They only have to update the interface descriptor, based on the XML schema.
- the interface descriptor can define complicated database access strategies by providing subcategory items and combined search criteria within a single category item. Thus, large databases, for example metadata databases, can be searched comfortably.
- Figure 1 a schematic diagram of a database access by pre-defined categories according to the prior art
- Figure 2 a schematic diagram of a database access by pre-defined categories based on an interface descriptor according to the present invention
- Figure 3 a scheme design view of an interface descriptor
- Figure 4 pictures of a graphical user interface for presenting the interface descriptor
- Figure 5 pictures of the graphical user interface for a search strategy
- Figure 6 a picture of the graphical user interface for a combined search.
- a database 1 can be accessed by an interface machine 2.
- Pre-defined category items 5 are shown by an associated presentation method 4 via a graphic user interface (GUI) 3.
- GUI graphic user interface
- These category items 5 are defined in category classes in the interface machine 2.
- the category items are a fixed part of the interface machine 2.
- Under each category item an associated individual database access method 6 is defined, or all category items can share a general database access method 6.
- the access method according to the prior art thus includes the following steps.
- the user may browse a category of database 1, choose a category item and search the database 1 through an access method 6 defined under the current category item.
- the disadvantage of this traditional database categorized access application (Fig.l) is that the defined categories and the associated database access imple- mentation must be pre-built in the database-interface- machine 2. If users want to update the categories and the database access method in their interface machine 2, they must update the related software or hardware .
- the database 1 can be accessed by the in- terface machine 2.
- the interface machine 2 consists of GUI
- GUI 3 utilizes a standard category presentation method 4 to import a category message from the interface descriptor 8.
- GUI 3 utilizes a standard category presentation method 4 to import a category message from the interface descriptor 8.
- the interface machine 2 must import associated access strategy messages from the interface descriptor 8.
- the interface machine 2 uses a standard database access method 6 or any special ac- cess method 7 to search the database 1.
- the interface descriptor is a XML file*, which is defined by its XML schema.
- Fig.3 is a schema design view of the current interface descriptor. As shown in Fig.3 (a), the root element is "InterfaceDescrip- tor" . It has two attributes: “version” (required) and "author” (optional) . Attribute “version” includes the version message of the current interface descriptor. The version message directs the GUI to use its associated application to show category and search database . Attribute "author” shows the developer of the current interface descriptor.
- the root element "InterfaceDescriptor” contains one or more sub-elements "AccessMethod” (min. 1 ⁇ max. unbounded) . This is indicated by the symbol between “InterfaceDescriptor” and "AccessMethod” . Each "AccessMethod” includes an attribute "name” (required) , which gives the name of a database access method. See Fig.3 (a).
- Each "AccessMethod” has one or more sub-elements "Category” (min. 1 ⁇ max. unbounded) .
- Each "Category” contains the attributes "name” (required) and "counter” (optional) .
- Attribute "name” contains the shown name of category.
- Attribute "counter” contains the number of the last search result. See Fig.3 (a) .
- element “Category” is a global element, which contains one or more sub-elements “SearchText” (min. 1 ⁇ max. unbounded) and optionally one or more sub- elements “Category” (min. 0 ⁇ max. unbounded) .
- Element “SearchText” has the attributes "type” (required) , "text” (required) and "mode” (optional) .
- Attribute "type” defines the type of search text, for example a page of a teletext. Currently, its value can be chosen from “element”, “attribute”, “value” or "no".
- Attribute "text” includes the keyword for search, for example a specific number of a page of the teletext.
- Each "Category” can have unbounded “SearchText”, which means each "Category” can have more than one keyword for search.
- Attribute "mode” represents the name of a specific database access method 7. When it is default, a stan- dard general access method is used. Otherwise, the specific access method 7 will be used.
- Each "Category” can have own sub-elements “Category” .
- element “SearchText” is a global element, which may contain zero, one or more sub-elements “SearchText” (min. 0 ⁇ max. unbounded) .
- Sub-element “SearchText” has the .same schema as its parent element “SearchText” . This structure makes it possible to refine search results.
- the database categorized accessing based on the interface descriptor may be applied to a metadata database interface machine .
- the user may import InterfaceDescrip- tor.xml by clicking the ComboBox 41. All current category access methods included in the InterfaceDescriptor.xml are shown in 42. When opening the "Developer Access" method, all its categories are presented in a tree view pane as shown in 43. Here, a standard category input method in the* interface machine is utilized for the category presentation. Each category may contain sub category items, as further shown in 43. All these category messages are defined in InterfaceDescriptor .xml . The user may browse all pre-defined categories in the tree view pane.
- Fig.5 the user may select category "Teletext Metadata"
- the search machine will search for keyword "100" as type "value” under attribute "PageNo” among all teletext metadata. A found result is shown in a view pane 57.
- the respective XML command is:
- the user may search under category "Page 100-109" 61.
- a group of "SearchText” is defined so that a com- bined search corresponding to ten single searches will be started.
- the search machine will search for teletext pages from number 100 to 109. All found results are shown in a view pane 62.
- the respective XML command is:
- the interface descriptor for database categorized accessing allows to develop more complicated data access strategies.
- the interface descriptor according to the present invention can work independently, since all relevant dictionary elements such as search key words are included in the interface descriptor. Furthermore, the interface descriptor can access the database directly and does not need any additional cate- gory definition dictionary.
Abstract
Description
Claims
Priority Applications (4)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
JP2004565952A JP2006513470A (en) | 2003-01-10 | 2003-11-28 | Database access method and apparatus |
EP03780084A EP1581889A1 (en) | 2003-01-10 | 2003-11-28 | Method and device for accessing a database |
US10/541,859 US20060129527A1 (en) | 2003-01-10 | 2003-11-28 | Method and device for accessing a database |
AU2003288196A AU2003288196A1 (en) | 2003-01-10 | 2003-11-28 | Method and device for accessing a database |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
EP03000395A EP1437662A1 (en) | 2003-01-10 | 2003-01-10 | Method and device for accessing a database |
EP03000395.8 | 2003-01-10 |
Publications (1)
Publication Number | Publication Date |
---|---|
WO2004063941A1 true WO2004063941A1 (en) | 2004-07-29 |
Family
ID=32479902
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/EP2003/013440 WO2004063941A1 (en) | 2003-01-10 | 2003-11-28 | Method and device for accessing a database |
Country Status (9)
Country | Link |
---|---|
US (1) | US20060129527A1 (en) |
EP (2) | EP1437662A1 (en) |
JP (1) | JP2006513470A (en) |
KR (1) | KR20050100606A (en) |
CN (1) | CN100456285C (en) |
AU (1) | AU2003288196A1 (en) |
MY (1) | MY144762A (en) |
TW (1) | TW200415483A (en) |
WO (1) | WO2004063941A1 (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP2072610A1 (en) | 2007-12-11 | 2009-06-24 | Shell Internationale Research Maatschappij B.V. | Carrier oil composition |
Families Citing this family (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN100573516C (en) * | 2006-01-12 | 2009-12-23 | 鸿富锦精密工业(深圳)有限公司 | Dummy machine system and the method for utilizing this system to execute instruction |
US8156144B2 (en) * | 2008-01-23 | 2012-04-10 | Microsoft Corporation | Metadata search interface |
US10732837B2 (en) * | 2010-02-08 | 2020-08-04 | International Business Machines Corporation | Pseudo-volume for control and statistics of a storage controller |
US20120215763A1 (en) * | 2011-02-18 | 2012-08-23 | Microsoft Corporation | Dynamic distributed query execution over heterogeneous sources |
CN104732160B (en) * | 2015-02-03 | 2018-04-13 | 武汉风奥软件技术有限公司 | A kind of control method for preventing from divulging a secret inside database information |
CN105306579A (en) * | 2015-11-11 | 2016-02-03 | 盛趣信息技术(上海)有限公司 | Server interface configuration method and server |
CN114721529B (en) * | 2022-03-30 | 2022-11-29 | 四川交子纪元数字信息技术有限公司 | Software compatibility control method and system based on artificial intelligence and cloud platform |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6026333A (en) * | 1997-06-10 | 2000-02-15 | Fujitsu Limited | Data utilizing system |
WO2002015047A1 (en) * | 2000-08-16 | 2002-02-21 | Marc Vogel | Interface system for accessing data in a database |
US20020184397A1 (en) * | 2001-02-15 | 2002-12-05 | Raymond Cooper | Method and apparatus for providing a custom cataloging procedure |
Family Cites Families (16)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5550971A (en) * | 1993-06-30 | 1996-08-27 | U S West Technologies, Inc. | Method and system for generating a user interface adaptable to various database management systems |
US5649190A (en) * | 1994-06-14 | 1997-07-15 | Harris Corporation | Multi-model database system for dynamic creation and maintenance of complex objects in a real time environment |
US7133846B1 (en) * | 1995-02-13 | 2006-11-07 | Intertrust Technologies Corp. | Digital certificate support system, methods and techniques for secure electronic commerce transaction and rights management |
US5950190A (en) * | 1997-05-13 | 1999-09-07 | Aptek, Inc. | Dynamic, self-modifying graphical user interface for relational database applications |
US6016394A (en) * | 1997-09-17 | 2000-01-18 | Tenfold Corporation | Method and system for database application software creation requiring minimal programming |
CN1292901A (en) * | 1998-01-22 | 2001-04-25 | Ori软件开发有限公司 | Database apparatus |
US6366917B1 (en) * | 1998-04-01 | 2002-04-02 | Webputty, Inc. | Method of modifying a populated database structure by modifying metadata describing the database structure |
EP1041499A1 (en) * | 1999-03-31 | 2000-10-04 | International Business Machines Corporation | File or database manager and systems based thereon |
US6618727B1 (en) * | 1999-09-22 | 2003-09-09 | Infoglide Corporation | System and method for performing similarity searching |
US7613695B1 (en) * | 1999-12-06 | 2009-11-03 | Reed Elsevier Inc. | Relationship management system that provides an indication of users having a relationship with a specified contact |
US7213024B2 (en) * | 2000-03-09 | 2007-05-01 | The Web Access, Inc. | Method and apparatus for accessing information within an electronic system |
US6560604B1 (en) * | 2000-03-10 | 2003-05-06 | Aether Systems, Inc. | System, method, and apparatus for automatically and dynamically updating options, features, and/or services available to a client device |
JP2002269128A (en) * | 2001-03-12 | 2002-09-20 | Toshiba Corp | Program and system for generating screen data and screen data generating method by computer system |
JP2002312383A (en) * | 2001-04-10 | 2002-10-25 | Sharp Corp | Device, system, and method for document retrieval and program |
EP1271342A1 (en) * | 2001-04-30 | 2003-01-02 | Sun Microsystems, Inc. | Method for accessing database table columns |
US20030187850A1 (en) * | 2002-03-29 | 2003-10-02 | Reed Michael L. | Remote database access through a table entry |
-
2003
- 2003-01-10 EP EP03000395A patent/EP1437662A1/en not_active Withdrawn
- 2003-11-28 AU AU2003288196A patent/AU2003288196A1/en not_active Abandoned
- 2003-11-28 US US10/541,859 patent/US20060129527A1/en not_active Abandoned
- 2003-11-28 JP JP2004565952A patent/JP2006513470A/en active Pending
- 2003-11-28 WO PCT/EP2003/013440 patent/WO2004063941A1/en active Application Filing
- 2003-11-28 CN CNB2003801084856A patent/CN100456285C/en not_active Expired - Fee Related
- 2003-11-28 EP EP03780084A patent/EP1581889A1/en not_active Withdrawn
- 2003-11-28 KR KR1020057012720A patent/KR20050100606A/en not_active Application Discontinuation
- 2003-12-26 TW TW092136942A patent/TW200415483A/en unknown
-
2004
- 2004-01-09 MY MYPI20040053A patent/MY144762A/en unknown
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6026333A (en) * | 1997-06-10 | 2000-02-15 | Fujitsu Limited | Data utilizing system |
WO2002015047A1 (en) * | 2000-08-16 | 2002-02-21 | Marc Vogel | Interface system for accessing data in a database |
US20020184397A1 (en) * | 2001-02-15 | 2002-12-05 | Raymond Cooper | Method and apparatus for providing a custom cataloging procedure |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP2072610A1 (en) | 2007-12-11 | 2009-06-24 | Shell Internationale Research Maatschappij B.V. | Carrier oil composition |
Also Published As
Publication number | Publication date |
---|---|
US20060129527A1 (en) | 2006-06-15 |
CN1735888A (en) | 2006-02-15 |
CN100456285C (en) | 2009-01-28 |
JP2006513470A (en) | 2006-04-20 |
KR20050100606A (en) | 2005-10-19 |
EP1581889A1 (en) | 2005-10-05 |
AU2003288196A1 (en) | 2004-08-10 |
EP1437662A1 (en) | 2004-07-14 |
MY144762A (en) | 2011-10-31 |
TW200415483A (en) | 2004-08-16 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US8676837B2 (en) | Systems and methods for personalizing aggregated news content | |
US8527499B2 (en) | Computer implemented method and system for a user search interface | |
US7836077B2 (en) | Document searching tool and method | |
US7216298B1 (en) | System and method for automatic generation of HTML based interfaces including alternative layout modes | |
JP4634715B2 (en) | Search for matching documents by querying in any national language | |
US20050086204A1 (en) | System and method for searching date sources | |
US7711742B2 (en) | Intelligent data query builder | |
US8739061B1 (en) | Method and apparatus for output of search results | |
US20040002959A1 (en) | Method and system for providing context sensitive support for data processing device user search requests | |
US20040064447A1 (en) | System and method for management of synonymic searching | |
US7801876B1 (en) | Systems and methods for customizing behavior of multiple search engines | |
US20070214126A1 (en) | Enhanced System and Method for Search | |
WO2006031307A2 (en) | Method and system for search engine enhancement | |
WO2004063941A1 (en) | Method and device for accessing a database | |
US20100121832A1 (en) | System for retrieving information units | |
US20020078020A1 (en) | Method and system of entering search criteria using multiple entry fields per data element | |
MXPA05007369A (en) | Method and device for accessing a database | |
Ferré | Agile browsing of a document collection with dynamic taxonomies | |
JP2001273299A (en) | Retrieving device | |
AU2002339257A1 (en) | A system and method for searching data sources | |
Sadeh et al. | To Google or not to Google: Metasearch design in the quest for the ideal user experience | |
AU2008202352A1 (en) | A system and method for searching data sources | |
Ellerin | Electronic Gutenbergs: Folio Views 4.0 | |
Prine | Visualization Browsing Strategies |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AK | Designated states |
Kind code of ref document: A1 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 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: A1 Designated state(s): BW GH GM KE LS MW MZ 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 PT RO SE SI SK TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG |
|
DFPE | Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101) | ||
121 | Ep: the epo has been informed by wipo that ep was designated in this application | ||
REEP | Request for entry into the european phase |
Ref document number: 2003780084 Country of ref document: EP |
|
WWE | Wipo information: entry into national phase |
Ref document number: 2003780084 Country of ref document: EP |
|
WWE | Wipo information: entry into national phase |
Ref document number: PA/a/2005/007369 Country of ref document: MX Ref document number: 1020057012720 Country of ref document: KR |
|
WWE | Wipo information: entry into national phase |
Ref document number: 20038A84856 Country of ref document: CN Ref document number: 2004565952 Country of ref document: JP |
|
ENP | Entry into the national phase |
Ref document number: 2006129527 Country of ref document: US Kind code of ref document: A1 |
|
WWE | Wipo information: entry into national phase |
Ref document number: 10541859 Country of ref document: US |
|
WWP | Wipo information: published in national office |
Ref document number: 2003780084 Country of ref document: EP |
|
WWP | Wipo information: published in national office |
Ref document number: 1020057012720 Country of ref document: KR |
|
WWP | Wipo information: published in national office |
Ref document number: 10541859 Country of ref document: US |