Integration of SQL and XQuery in IBM DB2

Özcan, Fatma; Chamberlin, Donald D.; Kulkarni, K.; Michels, Jan

doi:10.1147/sj.452.0245

Cited by 12 publications

(3 citation statements)

References 2 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…They removed a large number of duplicate e-mails, computer generated folders, junk data, invalid e-mail addresses, and blank messages, importing all e-mail messages into a relational database (Nijssen and Halpin, 1989). These measures enable query analysis using SQL, a relational database language that takes advantage of the regular structure of data stored in tables (Özcan et al , 2006). Using SQL, the result of the queries is data extracted and then statistically analyzed.…”

Section: Methodsmentioning

confidence: 99%

The different impact of personal social capital and intra-organizational SC

Ben‐Hador

Eckhaus

2018

IJOTB

View full text Add to dashboard Cite

Purpose This study relates to two levels of organization social capital (SC): personal SC and intra-organizational SC. Personal SC is the utility derived from the person’s relationship, and his positioning in networks, inside and out of the organization. Intra-organizational SC is the benefit derived from interactions within, and between groups in the organization, and is based on trust, reciprocity, common goals, sharing information and knowledge. The purpose of this paper is to examine the difference between the SC levels by their connections to employee energy and success, before and after crisis. Design/methodology/approach In order to test the hypotheses, the authors used the Enron e-mails corpus, the texts were analyzed using SQL. Findings The findings suggest that the impact of personal SC and intra-organizational SC, on employee energy and success is different. Personal SC was found to have a higher impact on those two variables, than intra-organizational SC. After crisis, this gap became larger. Originality/value The importance of the findings is in the distinction between the SC levels, and their different impact on the employees. However, the situation of Enron employees at that time implies that the more important level of SC is the intra-organizational SC.

show abstract

Section: Methodsmentioning

confidence: 99%

The different impact of personal social capital and intra-organizational SC

Ben‐Hador

Eckhaus

2018

IJOTB

View full text Add to dashboard Cite

show abstract

“…Likewise, XML is widely used as a standard to exchange data over the internet, and the Native XML Database tends to be a practical solution for variable data [26] and provides full support for XML query languages such as XPath or XQuery [27]. The system can also access data from a hybrid database, as major relational database management systems (DBMS) are appealing for hybrid engines so that they fit XML into a relational database environment [3], for instance, Oracle [28] [29] [30], IBM [31] and Microsoft. Furthermore, the extension to SQL for XML, SQL/XML, is making good advancements [32] [33].…”

Section: Data Extractionmentioning

confidence: 99%

An Intermediate Representation-based Approach for Query Translation using a Syntax-Directed Method

Nassiri¹,

Machkour²,

Hachimi³

2020

IJACSA

View full text Add to dashboard Cite

We aspire to make one query reasonably sufficient to extract data regardless of the data model used in our research. In such a way, users can freely use any query language they master to interrogate the heterogeneous database, not necessarily the query language associated with the model. Thus, overcoming the needing to deal with multiple query languages, which is, usually, an unwelcome matter for non-expert users and even for the expert ones. To do so, we proposed a new translation approach, relying on an intermediate query language to convert the user query into a suitable query language, according to the nature of data interrogated. Which is more beneficial rather than repeat the whole process for each new query submission. On the other hand, this empowers the system to be modular and divided into multiple, more flexible, and less complicated components. Therefore, it increases possibilities to make independent transformations and to switch between several query languages efficiently. By using our system, querying each data model with the corresponding query language is no longer bothersome. As a start, we are covering the eXtensible Markup Language (XML) and relational data models, whether native or hybrid. Users can retrieve data sources over these models using just one query, expressed with either the XML Path Language (XPath) or the Structured Query Language (SQL).

show abstract

“…From the dataflow specification we see that 55 is the output of f applied to the output of g applied to input.a. We can thus retrieve the two relevant triples as follows: Note the use of the SQL/XML predicate XMLEXISTS [40,41] to retrieve the IDs of the nodes in the syntax tree of the dataflow's NRC expression.…”

Section: Querying the Repositorymentioning

confidence: 99%

Querying an Integrated Complex-Object Dataflow Database

Kwasnikowska

Bussche

2013

In Search of Elegance in the Theory and Practice of Computation

View full text Add to dashboard Cite

Abstract. We consider an integrated complex-object dataflow database in which multiple dataflow specifications can be stored, together with multiple executions of these dataflows, including the complex-object data that are involved, and annotations. We focus on dataflow applications frequently encountered in the scientific community, involving the manipulation of data with a complex-object structure combined with service calls, which can be either internal or external. Internal services are dataflows acting as a subprogram of an other dataflow, whereas external services are modeled as functions with a possibly non-deterministic behavior. Dataflow specifications are expressed in a high-level programming language based on the nested relational calculus, the operators of which provide the right "glue" needed to combine different service calls into a complex-object dataflow. All entities involved, whether complex-objects, dataflow executions or dataflow specifications, are first-class citizens of the integrated database: they are all data. We discuss how such dataflow repositories can be queried in a variety of ways, including provenance queries. We show that a modern SQL platform with support for (external) routines and SQL/XML suffices to support all types of dataflow repository queries.

show abstract

Integration of SQL and XQuery in IBM DB2

Cited by 12 publications

References 2 publications

The different impact of personal social capital and intra-organizational SC

The different impact of personal social capital and intra-organizational SC

An Intermediate Representation-based Approach for Query Translation using a Syntax-Directed Method

Querying an Integrated Complex-Object Dataflow Database

Contact Info

Product

Resources

About