DB2 goes hybrid: Integrating native XML and XQuery with relational data and SQL

Beyer, Kevin; Cochrane, Roberta; Hvizdos, M.; Josifovski, Vanja; Kleewein, Jim; Lapis, George; Lohman, Guy M.; Lyle, R.; Nicola, Matthias; Özcan, Fatma; Pirahesh, Hamid; Seemann, Normen; Singh, Ashutosh; Truong, T. V.; Linden, R. C. Van der; Vickery, Brian; Zhang, C.; Zhang, G.

doi:10.1147/sj.452.0271

Cited by 20 publications

(12 citation statements)

References 26 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…At current, IBM DB2 Express-C is the most suitable database management system for our purpose to implement and manage databases of ISO/IEC 27000 series and ISMS documents. IBM DB2 Express-C is a free hybrid type database management system that can provide management of both relational and XML data model effectively [22]. It provides a function called "pureXML" which supports storing XML documents natively, validating documents against schemas, and querying documents [23].…”

Section: Current Implementationmentioning

confidence: 99%

“…SQL is used for querying the metadata of the standards and documents that are represented in relational data model, and XQuery is used for querying the data of the standards as well as the documents that are represented in XML data model. DB2 also allows the combination of the usage of SQL and XQuery [22]. In order to retrieve data of various standards from multiple databases, first we generate an SQL query to retrieve a list of databases from Criteria Meta DB.…”

Section: Current Implementationmentioning

confidence: 99%

See 1 more Smart Citation

An Information Security Management Database System (ISMDS) for Engineering Environment Supporting Organizations with ISMSs

Suhaimi

Goto

Cheng

2014

IEICE Trans. Inf. & Syst.

View full text Add to dashboard Cite

SUMMARYInformation Security Management Systems (ISMSs) play important roles in helping organizations to manage their information securely. However, establishing, managing, and maintaining ISMSs is not an easy task for most organizations because an ISMS has many participants and tasks, and requires many kinds of documents. Therefore, organizations with ISMSs demand tools that can support them to perform all tasks in ISMS lifecycle processes consistently and continuously. To realize such support tools, a database system that manages ISO/IEC 27000 series, which are international standards for ISMSs, and ISMS documents, which are the products of tasks in ISMS lifecycle processes, is indispensable. The database system should manage data of the standards and documents for all available versions and translations, relationship among the standards and documents, authorization to access the standards and documents, and metadata of the standards and documents. No such database system has existed until now. This paper presents an information security management database system (ISMDS) that manages ISO/IEC 27000 series and ISMS documents. ISMDS is a meta-database system that manages several databases of standards and documents. ISMDS is used by participants in ISMS as well as tools supporting the participants to perform tasks in ISMS lifecycle processes. The users or tools can retrieve data from all versions and translations of the standards and documents. The paper also presents some use cases to show the effectiveness of ISMDS.

show abstract

Section: Current Implementationmentioning

confidence: 99%

Section: Current Implementationmentioning

confidence: 99%

An Information Security Management Database System (ISMDS) for Engineering Environment Supporting Organizations with ISMSs

Suhaimi

Goto

Cheng

2014

IEICE Trans. Inf. & Syst.

View full text Add to dashboard Cite

show abstract

“…In IBM's DB2 the XML data type was added which can contain an entire XML document. Instead of a CLOB, a tree representation is used with XML tags being assigned an internal integer ID [3]. These solutions aim to provide a general solution to managing and querying XML data -including XML that is wellformed but schema-less.…”

Section: Related Workmentioning

confidence: 99%

Schema-Independent and Schema-Friendly Scientific Metadata Management

Jensen

Plale

2008

2008 IEEE Fourth International Conference on eScience

View full text Add to dashboard Cite

Computational science is creating a deluge of data, and being able to reuse this data requires detailed descriptive metadata. Scientific communities have developed detailed metadata schemas to describe data products, but this metadata must be captured as workflows execute.Our research has found characteristics of scientific schemas that can be exploited to efficiently capture and search this metadata based on the schemas specific to each community, but using an easily adaptable framework.

show abstract

“…Instead of being targeted at managing metadata, these databases are aimed at handling a wide spectrum of XML including schema-less documents and allowing queries based on XPath or XQuery. In DB2, XML documents are updated as whole documents [5], so metadata attributes added during a workflow would require the entire document to be updated.…”

Section: Related Workmentioning

confidence: 99%

Using Characteristics of Computational Science Schemas for Workflow Metadata Management

Jensen

Plale

2008

2008 IEEE Congress on Services - Part I

View full text Add to dashboard Cite

Computational science workflows are generating an ever-increasing volume of data products. Metadata for these workflows is communicated using one or more discipline-specific schemas and is not static but instead is subject to frequent updates and additions. In contrast to general XML data, the unique uses for scientific metadata allow further optimization.We propose a general metadata catalog for storing scientific metadata that is optimized for community science use and communicates metadata as XML using the schemas of scientific domains. In this paper we show that our hybrid approach outperforms the well-known inlining approach to storing XML when applied to scientific metadata.

show abstract

DB2 goes hybrid: Integrating native XML and XQuery with relational data and SQL

Cited by 20 publications

References 26 publications

An Information Security Management Database System (ISMDS) for Engineering Environment Supporting Organizations with ISMSs

An Information Security Management Database System (ISMDS) for Engineering Environment Supporting Organizations with ISMSs

Schema-Independent and Schema-Friendly Scientific Metadata Management

Using Characteristics of Computational Science Schemas for Workflow Metadata Management

Contact Info

Product

Resources

About