CN100504860C - 非关系型查询语言与关系型数据存储的集成 - Google Patents
非关系型查询语言与关系型数据存储的集成 Download PDFInfo
- Publication number
- CN100504860C CN100504860C CNB200510003568XA CN200510003568A CN100504860C CN 100504860 C CN100504860 C CN 100504860C CN B200510003568X A CNB200510003568X A CN B200510003568XA CN 200510003568 A CN200510003568 A CN 200510003568A CN 100504860 C CN100504860 C CN 100504860C
- Authority
- CN
- China
- Prior art keywords
- data
- relational
- storing process
- query language
- parameter
- Prior art date
- Legal status (The legal status 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 status listed.)
- Expired - Fee Related
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/40—Data acquisition and logging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/84—Mapping; Conversion
- G06F16/86—Mapping to a database
-
- 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/2443—Stored procedures
-
- 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/2452—Query translation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
-
- 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/99944—Object-oriented database structure
- Y10S707/99945—Object-oriented database structure processing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Computer Hardware Design (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (17)
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US11/046,693 US7567968B2 (en) | 2005-01-31 | 2005-01-31 | Integration of a non-relational query language with a relational data store |
US11/046,693 | 2005-01-31 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN1815468A CN1815468A (zh) | 2006-08-09 |
CN100504860C true CN100504860C (zh) | 2009-06-24 |
Family
ID=36384427
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNB200510003568XA Expired - Fee Related CN100504860C (zh) | 2005-01-31 | 2005-12-30 | 非关系型查询语言与关系型数据存储的集成 |
Country Status (5)
Country | Link |
---|---|
US (1) | US7567968B2 (zh) |
EP (1) | EP1686498A3 (zh) |
JP (1) | JP2006209756A (zh) |
KR (1) | KR20060088013A (zh) |
CN (1) | CN100504860C (zh) |
Families Citing this family (32)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080162512A1 (en) * | 2006-12-29 | 2008-07-03 | Sanjeet Mall | Efficient storage and distribution system for non-transactional data |
US7805456B2 (en) * | 2007-02-05 | 2010-09-28 | Microsoft Corporation | Query pattern to enable type flow of element types |
US7865533B2 (en) * | 2007-02-05 | 2011-01-04 | Microsoft Corporation | Compositional query comprehensions |
WO2008095209A1 (de) * | 2007-02-06 | 2008-08-14 | Mediareif Möstl & Reif Kommunikations- Und Informationstechnologien Oeg | Verfahren zum steuern eines relationalen datenbanksystems |
CN100458793C (zh) * | 2007-05-10 | 2009-02-04 | 浪潮集团山东通用软件有限公司 | 数据访问层Xml格式数据与关系数据间的映射转换方法 |
US8156149B2 (en) | 2007-07-24 | 2012-04-10 | Microsoft Corporation | Composite nested streams |
KR101501174B1 (ko) | 2007-09-28 | 2015-03-19 | 엑세리온 악티에볼라그 | 네트워크 오퍼레이팅 시스템 |
EP2063364A1 (en) * | 2007-11-19 | 2009-05-27 | Siemens Aktiengesellschaft | Module for building database queries |
US8447754B2 (en) * | 2010-04-19 | 2013-05-21 | Salesforce.Com, Inc. | Methods and systems for optimizing queries in a multi-tenant store |
US9460189B2 (en) * | 2010-09-23 | 2016-10-04 | Microsoft Technology Licensing, Llc | Data model dualization |
FR2967281A1 (fr) * | 2010-11-10 | 2012-05-11 | Brainwave Sarl | Procede de formulation de criteres de recherche et procede d'extraction de donnees d'une base de donnees |
KR101244466B1 (ko) * | 2011-01-03 | 2013-03-18 | 케이티하이텔 주식회사 | NoSQL 기반 데이터 모델링 방법 |
US9177021B2 (en) | 2011-06-09 | 2015-11-03 | International Business Machines Corporation | Relational query planning for non-relational data sources |
WO2012083679A1 (zh) * | 2011-07-13 | 2012-06-28 | 华为技术有限公司 | 一种数据迁移方法、数据迁移装置及数据迁移系统 |
CN102446226B (zh) * | 2012-01-16 | 2015-09-16 | 北大方正集团有限公司 | 一种实现NoSQL的键值存储引擎的方法 |
CN103823815B (zh) * | 2012-11-19 | 2017-05-17 | 中国联合网络通信集团有限公司 | 服务器及数据库访问方法 |
US9111012B2 (en) | 2012-11-26 | 2015-08-18 | Accenture Global Services Limited | Data consistency management |
US10685062B2 (en) | 2012-12-31 | 2020-06-16 | Microsoft Technology Licensing, Llc | Relational database management |
CN103473311B (zh) * | 2013-09-11 | 2016-10-12 | 北京新学堂网络科技有限公司 | 一种在html5应用中引入外部数据库的方法及装置 |
US10489355B1 (en) * | 2013-11-20 | 2019-11-26 | Progress Software Corporation | Schema tool for non-relational databases |
US10049772B1 (en) | 2014-07-09 | 2018-08-14 | Loyola University Of Chicago | System and method for creation, operation and use of a clinical research database |
KR101460950B1 (ko) * | 2014-08-04 | 2014-11-13 | (주)카디날정보기술 | 비정규 테이블 표기법을 기반으로 한 NoSQL 질의 방법 및 장치 |
US10572442B2 (en) * | 2014-11-26 | 2020-02-25 | Microsoft Technology Licensing, Llc | Systems and methods for providing distributed tree traversal using hardware-based processing |
US10102269B2 (en) | 2015-02-27 | 2018-10-16 | Microsoft Technology Licensing, Llc | Object query model for analytics data access |
CN105912665B (zh) * | 2016-04-12 | 2019-05-03 | 清华大学 | 一种Neo4j向关系型数据库的模型转换和数据迁移方法 |
KR102169930B1 (ko) * | 2016-05-05 | 2020-10-26 | 한국전자기술연구원 | M2M/IoT 플랫폼에서의 시맨틱 정보 관리 방법 |
CN108520003B (zh) * | 2018-03-12 | 2019-11-12 | 新华三大数据技术有限公司 | 一种存储过程调度系统和方法 |
CN109389408A (zh) * | 2018-11-05 | 2019-02-26 | 长春玖佰软件技术有限公司 | 一种关于溯源过程信息存储及有效性校验的应用框架 |
CN110032604B (zh) * | 2019-02-02 | 2021-12-07 | 北京奥星贝斯科技有限公司 | 数据存储装置、转译装置及数据库访问方法 |
US11416490B2 (en) | 2020-08-03 | 2022-08-16 | International Business Machines Corporation | Prioritization and optimization of database workloads |
CN112286506B (zh) * | 2020-10-30 | 2024-05-07 | 杭州海康威视数字技术股份有限公司 | 数据关联方法、装置、服务器及存储介质 |
CN112434069A (zh) * | 2020-12-01 | 2021-03-02 | 天津市鑫联兴科技有限公司 | 一种多源异构数据库访问适配方法及适配器 |
Family Cites Families (23)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5124909A (en) | 1988-10-31 | 1992-06-23 | Hewlett-Packard Company | Software program for providing cooperative processing between personal computers and a host computer |
US5701461A (en) * | 1995-01-27 | 1997-12-23 | Microsoft Corporation | Method and system for accessing a remote database using pass-through queries |
US6389414B1 (en) * | 1998-09-21 | 2002-05-14 | Microsoft Corporation | Internal database validation |
US6571232B1 (en) * | 1999-11-01 | 2003-05-27 | Sun Microsystems, Inc. | System and method for browsing database schema information |
US6721727B2 (en) * | 1999-12-02 | 2004-04-13 | International Business Machines Corporation | XML documents stored as column data |
US6708164B1 (en) | 2000-03-17 | 2004-03-16 | Microsoft Corporation | Transforming query results into hierarchical information |
US20020016814A1 (en) * | 2000-08-07 | 2002-02-07 | International Business Machines Corporation | Method, system, and program for invoking stored procedures and accessing stored procedure data |
GB2407417B (en) * | 2000-11-30 | 2005-06-29 | Coppereye Ltd | Database |
US6799184B2 (en) * | 2001-06-21 | 2004-09-28 | Sybase, Inc. | Relational database system providing XML query support |
US8914807B2 (en) * | 2001-09-28 | 2014-12-16 | International Business Machines Corporation | Method, system, and program for generating a program capable of invoking a flow of operations |
US20040015481A1 (en) * | 2002-05-23 | 2004-01-22 | Kenneth Zinda | Patent data mining |
US7275087B2 (en) * | 2002-06-19 | 2007-09-25 | Microsoft Corporation | System and method providing API interface between XML and SQL while interacting with a managed object environment |
US7181456B2 (en) * | 2002-08-20 | 2007-02-20 | Microsoft Corporation | Process description language |
US7322022B2 (en) * | 2002-09-05 | 2008-01-22 | International Business Machines Corporation | Method for creating wrapper XML stored procedure |
JP2004126804A (ja) * | 2002-09-30 | 2004-04-22 | Just Syst Corp | 文書管理方法および装置 |
JP3982578B2 (ja) * | 2003-02-26 | 2007-09-26 | 大日本印刷株式会社 | 硼酸系化合物、組成物および有機エレクトロルミネッセンス素子 |
US20050177557A1 (en) * | 2003-09-06 | 2005-08-11 | Oracle International Corporation | Automatic prevention of run-away query execution |
US7155706B2 (en) * | 2003-10-24 | 2006-12-26 | Microsoft Corporation | Administrative tool environment |
US20050171934A1 (en) * | 2004-01-30 | 2005-08-04 | Paul Yuknewicz | System and method for generating a parameterized query |
US7668806B2 (en) * | 2004-08-05 | 2010-02-23 | Oracle International Corporation | Processing queries against one or more markup language sources |
US7529753B1 (en) * | 2004-09-03 | 2009-05-05 | Crossroads Systems, Inc. | Providing application-layer functionality between one or more database clients and one or more database servers |
US8290977B2 (en) * | 2004-10-21 | 2012-10-16 | Sybase Inc. | Database system providing methodology for execution of functions in XML queries |
US20060136383A1 (en) * | 2004-12-20 | 2006-06-22 | Alcatel | Method and system enabling Web content searching from a remote set-top control interface or device |
-
2005
- 2005-01-31 US US11/046,693 patent/US7567968B2/en not_active Expired - Fee Related
- 2005-12-26 KR KR1020050129701A patent/KR20060088013A/ko not_active Application Discontinuation
- 2005-12-29 EP EP05113074A patent/EP1686498A3/en not_active Withdrawn
- 2005-12-30 CN CNB200510003568XA patent/CN100504860C/zh not_active Expired - Fee Related
-
2006
- 2006-01-18 JP JP2006010229A patent/JP2006209756A/ja active Pending
Non-Patent Citations (4)
Title |
---|
XML与SQL Server双向数据转换接口的设计. 李中凯,魏修亭.计算机与现代化,第12期. 2004 |
XML与SQL Server双向数据转换接口的设计. 李中凯,魏修亭.计算机与现代化,第12期. 2004 * |
基于语义的关系数据到XML数据的转换. 古丽娜孜.Computer Era,No.10. 2004 |
基于语义的关系数据到XML数据的转换. 古丽娜孜.Computer Era,No.10. 2004 * |
Also Published As
Publication number | Publication date |
---|---|
EP1686498A2 (en) | 2006-08-02 |
US7567968B2 (en) | 2009-07-28 |
US20060173804A1 (en) | 2006-08-03 |
KR20060088013A (ko) | 2006-08-03 |
JP2006209756A (ja) | 2006-08-10 |
CN1815468A (zh) | 2006-08-09 |
EP1686498A3 (en) | 2007-04-04 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN100504860C (zh) | 非关系型查询语言与关系型数据存储的集成 | |
CN1713179B (zh) | 在对象模型中的影响分析 | |
CN101283356B (zh) | 注入到客户机应用程序的搜索结果 | |
EP2943859B1 (en) | System, method, and computer-readable medium for managing edge devices | |
CN101713962B (zh) | 模块化对象的公布和发现 | |
CN102110211B (zh) | 用于管理安全事件的方法和装置 | |
CN100437576C (zh) | 用于发现并连接到数据源的方法、系统和装置 | |
CN1797449B (zh) | 用于元数据驱动的商业逻辑进程的方法和装置 | |
US7930215B2 (en) | Contextual computing system | |
CN1836208B (zh) | 计算机系统和分布式应用程序基于模型管理的方法和系统 | |
CN101405735B (zh) | 在企业资源计划系统内的并发控制 | |
US7437703B2 (en) | Enterprise multi-agent software system with services able to call multiple engines and scheduling capability | |
CN101410824B (zh) | 用于终端用户规则逻辑的定义和执行的规则框架 | |
CN101713963B (zh) | 模块化对象动态托管 | |
CN1841379B (zh) | 将文件系统模型映射到数据库对象 | |
CN102165447B (zh) | 用于管理对于实体的组织信息的访问的技术 | |
CN102770849B (zh) | 当应用基于用户的安全性时优化数据高速缓存 | |
CN101606154A (zh) | 允许元素类型的类型流的查询模式 | |
CN101490665B (zh) | 用于为客户设备执行远程数据存储的系统、方法和计算机程序产品 | |
US7010518B1 (en) | System and method for user defined data object hierarchy | |
CN101467144A (zh) | 声明性管理框架 | |
CN103810233A (zh) | 内容管理 | |
CN101013957A (zh) | 智能项目的服务-设备重映射的分级多层映射和监视架构 | |
CN101013956A (zh) | 智能项目的分级的多层映射和监视架构 | |
CN102027486A (zh) | 用于数据访问的基于单元格的安全表示 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
ASS | Succession or assignment of patent right |
Owner name: MICROSOFT TECHNOLOGY LICENSING LLC Free format text: FORMER OWNER: MICROSOFT CORP. Effective date: 20150430 |
|
C41 | Transfer of patent application or patent right or utility model | ||
TR01 | Transfer of patent right |
Effective date of registration: 20150430 Address after: Washington State Patentee after: Micro soft technique license Co., Ltd Address before: Washington State Patentee before: Microsoft Corp. |
|
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20090624 Termination date: 20181230 |
|
CF01 | Termination of patent right due to non-payment of annual fee |