Integration of queries to heterogeneous data sources using linq technology

• Autorzy: Rusek M. , Maguza J. , Karwowski W.

Identyfikatory

DOI

10.22630/ISIM.2018.7.3.16

• Języki publikacji: EN

Abstrakty

EN

Nowadays, the data are available in a variety of formats such as relational database tables, xml files, rdf files or simply text files. Database systems have their own query languages and tools for the manipulation of data. On the other hand, most of today's applications are created in languages based on the object-oriented paradigm. From the level of the programming language it is important to use different sources of data in a uniform manner. The paper discusses the elements of the various query languages such as SQL XQuery or SPARQL. And then shows the capabilities of LINQ and its role in the creation of abstract data access layer. Then the possibilities of LINQ extension are discussed. As the example, design and implementation of LINQ provider for Allegro is presented.

Słowa kluczowe

EN

query languages; LINQ; extension methods; .NET

• Wydawca: Wydawnictwo Szkoły Głównej Gospodarstwa Wiejskiego w Warszawie
• Czasopismo: Information Systems in Management
• Rocznik: 2018
• Tom: Vol. 7, No. 3
• Strony: 180--189
• Opis fizyczny: Bibliogr. 21 poz., rys., tab.

Twórcy

autor

Rusek M.

• Department of Informatics, Warsaw University of Life Sciences (SGGW)

autor

Maguza J.

• Department of Informatics, Warsaw University of Life Sciences (SGGW)

autor

Karwowski W.

• Department of Informatics, Warsaw University of Life Sciences (SGGW)

Bibliografia

• [1] ISO/IEC 9075-1:2016 standard: https://www.iso.org/committee/45342/x/catalogue/p/1/u/0/w/0/d/0.
• [2] Zloof, M., (1975), Query by Example, Conference: American Federation of Information Processing Societies: 1975 National Computer Conference proceedings, 19-22 May 1975, Anaheim, CA, USA.
• [3] Introduction to queries: https://support.office.com/en-us/article/Introduction-toqueries-D85E4893-0ED7-4118-8297-785A01357516 (access of 15 November 2017).
• [4] XQUERY specification: http://www.w3.org/XML/Query.
• [5] XPATH specification: http://www.w3.org/TR/xpath.
• [6] SPARQL specification: http://www.w3.org/TR/sparql11-query.
• [7] RDF current status: http://www.w3.org/standards/techs/rdf#w3c_all.
• [8] RDF 1.1 XML Syntax recommendation: http://www.w3.org/TR/rdf-syntax-grammar.
• [9] Cattell R.G.G., Barry D.K. (2000) The Object Data Standard: ODMG 3.0. The Morgan Kaufmann Series in Data Management Systems.
• [10] The JSON Query Language; http://www.jsoniq.org (access of 15 November 2017).
• [11] Apache TinkerPop. The Gremlin Graph Traversal Machine and Language: https://tinkerpop.apache.org/gremlin.html (access of 15 November 2017).
• [12] Google Custom Search Tutorial: https://developers.google.com/customsearch/docs/tutorial/introduction (access of 15 November 2017).
• [13] Bing Query Language: https://msdn.microsoft.com/en-us/library/ff795667.aspx (access of 15 November 2017).
• [14] Language Integrated Query: https://docs.microsoft.com/enus/dotnet/csharp/programming-guide/concepts/linq/index (access of 15 November 2017).
• [15] Marguerie F., Eichert S., Wooley J. (2008) LINQ in Action, Manning.
• [16] Mukherjee S. (2014) Thinking in LINQ: Harnessing the Power of Functional Programming in .NET Applications 1st ed. Edition. Apress.
• [17] Microsoft Reference Source .NET Framework 4.7.1: http://referencesource.microsoft.com/#System.Core/System/Linq/IQueryable.cs,eb17c f64586dbd9b (access of 15 November 2017)
• [18] Allegro RSS Channels Generator: http://allegro.pl/rss.php/generatorSearch (access of 15 November 2017)
• [19] Maguza J. (2017) LINQ implementation for Allegro system, MSc thesis, Warsaw University of Life Sciences (in Polish).
• [20] Walkthrough: Creating an IQueryable LINQ Provider https://msdn.microsoft.com/enus/library/bb546158.aspx (access of 15 November 2017).
• [21] https://github.com/jakubmaguza (access of 15 November 2017).

Uwagi

Opracowanie rekordu w ramach umowy 509/P-DUN/2018 ze środków MNiSW przeznaczonych na działalność upowszechniającą naukę (2019).