MX2019011597A - Sistemas y metodos para optimizacion de consulta e indice para recuperar datos en casos de una estructura de datos de formulacion desde una base de datos. - Google Patents
Sistemas y metodos para optimizacion de consulta e indice para recuperar datos en casos de una estructura de datos de formulacion desde una base de datos.Info
- Publication number
- MX2019011597A MX2019011597A MX2019011597A MX2019011597A MX2019011597A MX 2019011597 A MX2019011597 A MX 2019011597A MX 2019011597 A MX2019011597 A MX 2019011597A MX 2019011597 A MX2019011597 A MX 2019011597A MX 2019011597 A MX2019011597 A MX 2019011597A
- Authority
- MX
- Mexico
- Prior art keywords
- data
- formulation
- data structure
- formulation data
- query
- Prior art date
Links
- 238000009472 formulation Methods 0.000 title abstract 12
- 239000000203 mixture Substances 0.000 title abstract 12
- 238000000034 method Methods 0.000 title abstract 6
- 238000005457 optimization Methods 0.000 title abstract 2
- 238000013507 mapping Methods 0.000 abstract 1
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2272—Management thereof
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2291—User-Defined Types; Storage management thereof
-
- 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/245—Query processing
- G06F16/2453—Query optimisation
-
- 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/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16C—COMPUTATIONAL CHEMISTRY; CHEMOINFORMATICS; COMPUTATIONAL MATERIALS SCIENCE
- G16C20/00—Chemoinformatics, i.e. ICT specially adapted for the handling of physicochemical or structural data of chemical particles, elements, compounds or mixtures
- G16C20/40—Searching chemical structures or physicochemical data
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16C—COMPUTATIONAL CHEMISTRY; CHEMOINFORMATICS; COMPUTATIONAL MATERIALS SCIENCE
- G16C20/00—Chemoinformatics, i.e. ICT specially adapted for the handling of physicochemical or structural data of chemical particles, elements, compounds or mixtures
- G16C20/90—Programming languages; Computing architectures; Database systems; Data warehousing
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)
- Software Systems (AREA)
- Chemical & Material Sciences (AREA)
- Crystallography & Structural Chemistry (AREA)
- Computational Linguistics (AREA)
- Computing Systems (AREA)
- Life Sciences & Earth Sciences (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Bioinformatics & Computational Biology (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Fuzzy Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Se proporcionan sistemas y métodos para optimización de consulta e índice para recuperar datos en casos de una estructura de datos de formulación desde una base de datos. Los métodos incluyen presentar una fuente de información para buscar la presencia de formulaciones y generar datos de formulación a partir de entradas de campo. Los datos de formulación están asociados con formulaciones encontradas. Los métodos incluyen generar un caso de una estructura de datos de formulación. El caso de la estructura de datos de formulación asocia la fuente de información con las formulaciones encontradas. Los métodos incluyen crear datos de índice optimizado a partir de datos recuperados en el caso de la estructura de datos de formulación. Los datos de índice optimizado incluyen un mapeo entre términos de campo de búsqueda potenciales y los datos de formulación, y se agrupan con base en un patrón de acceso predicho. Los métodos incluyen ejecutar una consulta de búsqueda a través de los datos de índice optimizado y proporcionar información asociada con una fuente de información asociada con datos recuperados en un caso de una estructura de datos de formulación.
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| US201762481076P | 2017-04-03 | 2017-04-03 | |
| PCT/US2018/025855 WO2018187306A1 (en) | 2017-04-03 | 2018-04-03 | Systems and methods for query and index optimization for retrieving data in instances of a formulation data structure from a database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| MX2019011597A true MX2019011597A (es) | 2019-11-08 |
Family
ID=62092247
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| MX2019011597A MX2019011597A (es) | 2017-04-03 | 2018-04-03 | Sistemas y metodos para optimizacion de consulta e indice para recuperar datos en casos de una estructura de datos de formulacion desde una base de datos. |
Country Status (13)
| Country | Link |
|---|---|
| US (1) | US20180285399A1 (es) |
| EP (1) | EP3607472A1 (es) |
| JP (1) | JP2020513126A (es) |
| KR (1) | KR20190128245A (es) |
| CN (1) | CN110741360A (es) |
| AU (1) | AU2018250135A1 (es) |
| BR (1) | BR112019017897A2 (es) |
| CA (1) | CA3056257A1 (es) |
| CO (1) | CO2019011941A2 (es) |
| IL (1) | IL269634A (es) |
| MX (1) | MX2019011597A (es) |
| RU (1) | RU2019134186A (es) |
| WO (1) | WO2018187306A1 (es) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP7026973B2 (ja) * | 2018-08-23 | 2022-03-01 | 国立研究開発法人物質・材料研究機構 | 探索システムおよび探索方法 |
| GB2593926A (en) * | 2020-04-09 | 2021-10-13 | Noetica Ltd | Methods and systems for generating logical queries |
| US11822532B2 (en) * | 2020-10-14 | 2023-11-21 | Ocient Holdings LLC | Per-segment secondary indexing in database systems |
| CN113297169B (zh) * | 2021-02-26 | 2022-05-31 | 阿里云计算有限公司 | 数据库实例处理方法、系统、设备及存储介质 |
| CN116312845A (zh) * | 2022-12-14 | 2023-06-23 | 药融云数字科技(成都)有限公司 | 基于特征基团的化学结构预测方法、系统、存储介质及终端 |
Family Cites Families (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5577239A (en) * | 1994-08-10 | 1996-11-19 | Moore; Jeffrey | Chemical structure storage, searching and retrieval system |
| US6421612B1 (en) * | 1996-11-04 | 2002-07-16 | 3-Dimensional Pharmaceuticals Inc. | System, method and computer program product for identifying chemical compounds having desired properties |
| US6654736B1 (en) * | 1998-11-09 | 2003-11-25 | The United States Of America As Represented By The Secretary Of The Army | Chemical information systems |
| US7250950B2 (en) * | 2001-01-29 | 2007-07-31 | Symyx Technologies, Inc. | Systems, methods and computer program products for determining parameters for chemical synthesis |
| US7567953B2 (en) * | 2002-03-01 | 2009-07-28 | Business Objects Americas | System and method for retrieving and organizing information from disparate computer network information sources |
| US7051023B2 (en) * | 2003-04-04 | 2006-05-23 | Yahoo! Inc. | Systems and methods for generating concept units from search queries |
| GB0316806D0 (en) * | 2003-07-17 | 2003-08-20 | Ivis Group Ltd | Improved search engine |
| US7496593B2 (en) * | 2004-09-03 | 2009-02-24 | Biowisdom Limited | Creating a multi-relational ontology having a predetermined structure |
| EP1862916A1 (en) * | 2006-06-01 | 2007-12-05 | Microsoft Corporation | Indexing Documents for Information Retrieval based on additional feedback fields |
| US8583655B2 (en) * | 2011-10-17 | 2013-11-12 | Hewlett-Packard Development Company, L.P. | Using an inverted index to produce an answer to a query |
| US20140372448A1 (en) | 2013-06-14 | 2014-12-18 | American Chemical Society | Systems and methods for searching chemical structures |
| US10769127B2 (en) * | 2015-06-12 | 2020-09-08 | Quest Software Inc. | Dynamically optimizing data access patterns using predictive crowdsourcing |
-
2018
- 2018-04-03 CN CN201880022013.5A patent/CN110741360A/zh active Pending
- 2018-04-03 JP JP2019553872A patent/JP2020513126A/ja active Pending
- 2018-04-03 MX MX2019011597A patent/MX2019011597A/es unknown
- 2018-04-03 RU RU2019134186A patent/RU2019134186A/ru unknown
- 2018-04-03 US US15/944,573 patent/US20180285399A1/en not_active Abandoned
- 2018-04-03 CA CA3056257A patent/CA3056257A1/en active Pending
- 2018-04-03 AU AU2018250135A patent/AU2018250135A1/en not_active Abandoned
- 2018-04-03 KR KR1020197032156A patent/KR20190128245A/ko unknown
- 2018-04-03 BR BR112019017897-0A patent/BR112019017897A2/pt not_active Application Discontinuation
- 2018-04-03 WO PCT/US2018/025855 patent/WO2018187306A1/en unknown
- 2018-04-03 EP EP18721536.3A patent/EP3607472A1/en not_active Withdrawn
-
2019
- 2019-09-25 IL IL26963419A patent/IL269634A/en unknown
- 2019-10-25 CO CONC2019/0011941A patent/CO2019011941A2/es unknown
Also Published As
| Publication number | Publication date |
|---|---|
| EP3607472A1 (en) | 2020-02-12 |
| KR20190128245A (ko) | 2019-11-15 |
| CA3056257A1 (en) | 2018-10-11 |
| BR112019017897A2 (pt) | 2020-05-12 |
| JP2020513126A (ja) | 2020-04-30 |
| RU2019134186A (ru) | 2021-05-05 |
| AU2018250135A1 (en) | 2019-10-10 |
| WO2018187306A1 (en) | 2018-10-11 |
| IL269634A (en) | 2019-11-28 |
| CO2019011941A2 (es) | 2020-04-01 |
| US20180285399A1 (en) | 2018-10-04 |
| CN110741360A (zh) | 2020-01-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| MX2019011597A (es) | Sistemas y metodos para optimizacion de consulta e indice para recuperar datos en casos de una estructura de datos de formulacion desde una base de datos. | |
| MX2018007985A (es) | Coincidencia aproximada de plantillas para consultas en lenguaje natural. | |
| WO2014113772A3 (en) | Methods and systems for mapping repair orders within a database | |
| EP4270286A3 (en) | Intelligent agents for managing data associated with three-dimensional objects | |
| MX2016014986A (es) | Busqueda de imagenes del lenguaje natural. | |
| SG10201900297TA (en) | Clustering and tagging engine for use in product support systems | |
| WO2015103407A3 (en) | Geographic information system for researching, identifying and comparing locations for economic development | |
| GB2545548A (en) | Improved method, system and software for searching, identifying, retrieving and presenting electronic documents | |
| WO2018064011A3 (en) | Method and system for providing domain-specific incremental search results with a customer self-service system for a financial management system | |
| WO2017075362A8 (en) | Restful operations for semantic iot | |
| MY187254A (en) | Systems and methods for ranking potential attended delivery/pickup locations | |
| WO2014168717A3 (en) | System and apparatus for information retrieval | |
| WO2013173826A3 (en) | Populating and searching a drug informatics database | |
| NZ601132A (en) | Systems and methods for ranking documents | |
| WO2012129062A3 (en) | Systems and method for enabling searches of a document corpus and generation of search queries | |
| US20140201240A1 (en) | System and method to retrieve relevant multimedia content for a trending topic | |
| MX2013009473A (es) | Busqueda de voz y respuestas basada en relevancia. | |
| PH12016500758A1 (en) | System and method for implementing multi-faceted search queries | |
| GB2560645A (en) | Systems and methods for multi-dimensional computer-aided searching | |
| WO2013033473A3 (en) | Searching belongings using social graph information | |
| MX2015016834A (es) | Respuesta de busqueda de modos multiples. | |
| GB2565482A (en) | Attribute matching | |
| CL2018003674A1 (es) | Desactivación dinámica de base de datos fría en un servicio de base de datos | |
| SG10201706106QA (en) | Searchable Encryption with Hybrid Index | |
| WO2019033032A3 (en) | EVALUATION OF DIVERSITY IN GENEALOGICAL RESEARCH |