Jediana Jediana, Cosmas Eko Suharyanto · Jursima · 2024
Sistem komputer krusial untuk meningkatkan efisiensi bisnis perusahaan. Penelitian ini menyoroti pengelolaan data manual dengan Microsoft Excel, yang memakan waktu. Pengujian sistem dalam pengembangan bertujuan memastikan fungsi sesuai persyaratan. Tujuan utama pengujian adalah memastikan kualitas dan keandalan sistem, mengurangi risiko masalah saat operasional. Metode pengujian Black-box digunakan untuk mengidentifikasi dan mengatasi masalah sejak dini, menghemat waktu, biaya, dan upaya sebelum peluncuran resmi sistem.
Cited by 0Open access
Suzanne W. Dietrich, Mahesh B Chaudhari · 2011
The Language INtegrated Query (LINQ) language is a declarative query language integrated within an object-oriented programming language that provides a unified paradigm for querying relations, objects, and XML (ROX). This paper describes a suite of exercises, from cooperative in-class activities to larger-scale graded assignments, for incorporating LINQ into the database curriculum. These exercises support various student learning outcomes and illustrate the applicability of LINQ by querying the same database enterprise across the ROX data models.
Cited by 5
Wilmer Ricciotti · 2023
Recent programming languages research has developed language-integrated query, a convenient technique to seamlessly embed a domain-specific database query language into a general-purpose host programming language; such queries are then automatically converted to the language understood by the target DBMS (e.g. SQL) while at the same time taking advantage of the host language’s type-checker to prevent failure at run-time. The embedded query language is often equipped with a rewrite system which normalizes queries to a form that can be directly translated to the DBMS query language.
Cited by 0
Ian Stark, Ian Stark, Apl Metaprogramming · 2010
This is the third of four lectures on integrating domain-specific languages with general-purpose programming languages. In particular, SQL for database queries. Using SQL from Java LINQ:.NET Language Integrated Query Language integration in F# Type-checking for SQLizeability Ian Stark APL19 2010-03-15Topic: Domain-Specific vs. General-Purpose Languages This is the third of four lectures on integrating domain-specific languages with general-purpose programming languages. In particular, SQL for database queries. Using SQL from Java LINQ:.NET Language Integrated Query Language integration in F# Type-checking for SQLizeability
Cited by 0
Matthew MacDonald, Dan Mabbutt, Adam Freeman · Apress eBooks · 2010
One of the most hyped additions to.NET is LINQ (Language Integrated Query), a set of language extensions that allows you to perform queries without leaving the comfort of the VB language.
Cited by 0
Kemal Koymen · 1982
This paper describes a prototype DBMS, called VERTUR, which supports relational data structures and can be used inter-actively through a query language. The query language referred to as TURDIL is based on Turkish Language and is defined by a regular grammar. VERTUR has a fully integrated data dictionary which contains definitions of relations and user-views based on relations, along with information on data-access privileges.
Cited by 0
Amani Abu Jabal, Elisa Bertino · 2016
We propose a query language for a secure interoperable multi-granular provenance framework. The proposed language is independent of the underlying provenance representation and supports different types of provenance queries. We have implemented the query language into our provenance framework which is integrated with CRIS - a real world system for managing scientific data. We have also evaluated our provenance queries based on relational and graph databases.
Cited by 4
Wilmer Ricciotti, James Cheney · Lecture notes in computer science · 2021
Abstract Language-integrated query based on comprehension syntax is a powerful technique for safe database programming, and provides a basis for advanced techniques such as query shredding or query flattening that allow efficient programming with complex nested collections. However, the foundations of these techniques are lacking: although SQL, the most widely-used database query language, supports heterogeneous queries that mix set and multiset semantics, these important capabilities are not supported by known correctness results or implementations that assume homogeneous collections. In this paper we study language-integrated query for a heterogeneous query language $$\mathcal {NRC}_{\lambda }( Set,Bag )$$ <mml:math xmlns:mml="http://www.w3.org/1998/Math/MathML"> <mml:mrow> <mml:msub> <mml:mi>NRC</mml:mi> <mml:mi>λ</mml:mi> </mml:msub> <mml:mrow> <mml:mo>(</mml:mo> <mml:mi>S</mml:mi> <mml:mi>e</mml:mi> <mml:mi>t</mml:mi> <mml:mo>,</mml:mo> <mml:mi>B</mml:mi> <mml:mi>a</mml:mi> <mml:mi>g</mml:mi> <mml:mo>)</mml:mo> </mml:mrow> </mml:mrow> </mml:math> that combines set and multiset constructs. We show how to normalize and translate queries to SQL, and develop a novel approach to querying heterogeneous nested collections, based on the insight that “local” query subexpressions that calculate nested subcollections can be “lifted” to the top level analogously to lambda-lifting for local function definitions.
Cited by 6Open access
Epaminondas Kapetanios, Panagiotis Chountas, E. Kapetanios et al. · 2015
MDDQL: an ontology driven, multi-lingual query language and system for an integrated view of heterogeneous data sources.
Cited by 0
Radosław Adamus, Piotr Habela, Krzysztof Kaczmarski et al. · 2008
Abstract. ODRA (Object Database for Rapid Application development) is an objectoriented database management system provided as an integrated programming tool for building various business and administration applications, including centralized and distributed systems, Web applications, service buses, virtual repositories, P2P networks, and so on. The paper presents general architecture of ODRA, its object model, back-end interoperability facilities, front-end programming interfaces and integrated development environment. ODRA is based on the database query and programming language SBQL (Stack-Based Query Language) and virtual updateable views defined and used in SBQL. ODRA is the basis for two European projects: eGov Bus, aiming at the development of interoperability service bus for public administration, and VIDE, aiming at the development of a visual and textual programming language based on the OMG MDA and OMG specifications of Executable UML and a query language OCL. 1
Cited by 14
Paul Buitelaar, Klaus Netter, Feiyu Xu · 1998
In this paper we describe an integrated approach to cross-language retrieval within the MIETTA project, whose objective is to build a special purpose search engine in the tourism domain that covers information from a number of geographical regions. MIETTA is designed to enable users to search and retrieve information on the regions covered in their own language preferably. In order to facilitate the user with such functionality, the system includes document translation, cross-language query translation, multilingual generation from information extraction templates and document classification. In addition, query expansion is offered to identify proper query translation and enable template matching for information extraction purposes. Keywords: Cross Language Information Retrieval, Information Extraction, Natural Language Generation, Machine Translation, Query Translation, Query Expansion 1 INTRODUCTION MIETTA (Multilingual Information Extraction for Tourism and Travel Assistance) is ...
Cited by 0
J E D Donaho, G K Davis · ACM SIGAda Ada Letters · 1987
This paper investigates the possibilities for incorporating relational database queries into an Ada application program. The research was done from a language features viewpoint, and only concerned itself with the broadest of implementation issues.Three alternative approaches are investigated. The first tries to express database definitions and queries in pure Ada source code. The second attempts to write Ada code that looks and functions just like SQL. The third approach embeds a distinct query language within an Ada application program.The most feasible approach is found to be that of an embedded query language, in conjunction with pre-processing of the integrated Ada-language/query-language program. The paper then goes on to describe a number of modifications and enhancements to the SQL model which would provide an acceptable Ada-compatible query language.
Cited by 5Open access
tjstlhxermo · Zenodo (CERN European Organization for Nuclear Research) · 2024
linq c# tutorial pdf Rating: 4.4 / 5 (3020 votes) Downloads: 10205 = = = = = CLICK HERE TO DOWNLOAD = = = = = ChapterGetting started with linq. These include lambdas, iterator blocks, expression trees, anonymous types, type inference, query expressions, and extension methods. Distinguish between eager and lazy evaluation This syntax is enabled by a series of C# and C# features. Using this class, you can create functional methods much as you create variables of any primitive type, such as integers The acronym LINQ stands for Language Integrated Query. You use the same basic coding patterns to query and transform data in XML documents, SQL databases,.NET Using Func in C# to Represent Functions You might be wondering how to port such functions to C#. Fortunately, it's quite straightforward. IQueryable LINQ providers. C# includes a class called Func. Write methods that can be easily used in LINQ queries. Ready to take advantage of LINQ with C#? This guide has the detail you need to grasp Microsoft's LINQ in Action is a fast-paced, comprehensive tutorial for professional developers who want to use LINQ. LINQ allows you to write larative and expressive code that manipulates data efficiently. At the top of the file, import the namespace: C# using System; using ; Imports The different joins in LINQ In the following examples, well be using the following samples About the Tutorial. How to enable LINQ querying of your data source. These include lambdas, iterator blocks, expression trees, anonymous types, type inference, query expressions, Learning linq eBook (PDF) Download this eBook for free. // using ; XElement contacts = (@"c:\ "); With EntityFramework, you create an object-relational mapping between C# classes and your database schema. All of these features are covered in this book. C# includes a class called Func , · In this article. For now you need only understand that they make LINQ possible These LINQ tutorials using C# are designed for beginners and professional developers who want to learn LINQ in C# step by step, from the very basic to the advanced concept, using real-time examples C# LINQ. LINQ stands for L anguage IN tegrated Q uery. Microsoft's query language is fully integrated and offers easy data access from in-memory objects, databases, XML documents, and many more. ChapterLinq Using Take while And Skip While. Query expression overview. LINQ stands for L anguage IN tegrated Q uery. Query expression overview. This book explores what can be done with LINQ, shows you how it Microsoft's query language is fully integrated and offers easy data access from in-memory objects, databases, XML documents, and many more. ChapterMethod , · In a LINQ query, you always work with C# objects. It is through a set of extensions LINQ ably integrates queries in C# and Visual Basic This tutorial teaches you features Core and the C# language. Add a reference to, if it hasnt been added yet. LINQ integrates the queries directly in C# through a set of extensions to the language. You'll learn how to: Generate sequences with LINQ. How to enable LINQ querying of your data source. You write your queries In this article. IQueryable LINQ providers. Language-Integrated Query (LINQ) is the LINQ Pocket Reference: Learn and Implement LINQ Applications. LINQ integrates the queries directly in C# through a set of extensions to the language. The LINQ provides a consistent query experience to query objects (LINQ to Objects), relational LINQ or higher (using LINQBridge). LINQ allows you to write This syntax is enabled by a series of C# and C# features. Language-Integrated Query (LINQ) is the name for a set of technologies based on the integration of query capabilities directly into the C# language Using Func in C# to Represent Functions You might be wondering how to port such functions to C#. Fortunately, it's quite straightforward. This C# LINQ tutorial helps you master LINQ and take your data manipulation skill to the next level For example, LINQ to XML loads an XML document into a queryable XElement type: // Create a data source from an XML document. Chapters. LINQ Queries are the first-class language construct in C#.NET, just like classes, methods, events. It is through a set of extensions LINQ LINQ: Language INtegrated Query Allows native data querying LINQ defines a set of query operators – Can be used to query, project, and filter data – Data can be in Language-Integrated Query (LINQ) is a powerful set of technologies based on the integration of query capabilities directly into the C# language. C# LINQ.
Cited by 0Open access
Jaroslav Pokorný · SHILAP Revista de lepidopterología · 2019
In today’s multi-model database world there is an effort to integrate databases expressed in different data models. The aim of the article is to show possibilities of integration of relational and graph databases with the help of a functional data model and its formal language – a typed lambda calculus. We suppose the existence of a data schema both for the relational and graph database. In this approach, relations are considered as characteristic functions and property graphs as sets of single-valued and multivalued functions. Then it is possible to express a query over such integrated heterogeneous database by one query expression expressed in a version of the typed lambda calculus. A more user-friendly version of such language could serve as a powerful query tool in practice. We discuss also queries sent to the integrated system and translated into queries in SQL and Cypher - the graph query language for Neo4j.
Cited by 12Open access
Mehmet Emin Dönderler, Özgür Ulusoy, Ugur Güdükbay · 2002
Abstract. In our earlier work, we proposed an architecture for a Web-based video database management system (VDBMS) providing an integrated support for spatiotemporal and semantic queries. In this paper, we focus on the task of spatiotemporal query processing and also propose an SQL-like video query language that has the capability to handle a broad range of spatiotemporal queries. The language is rule-based in that it allows users to express spatial conditions in terms of Prologtype predicates. Spatiotemporal query processing is carried out in three main stages: query recognition, query decomposition, and query execution.
Cited by 0
Elke Rundensteiner, Sudhir Kaushik, Sudhir Kaushik et al. · 1997
The need to analyze and query spatial data is becoming increasingly important with the advent of applications such as Geographic Information Systems, Image Databases and Remote Sensing. The focus of our research is to support spatial data analysis by developing a direct manipulation environment to visually query as well as browse spatial data and to review the visual results for trend analysis. In this paper, we present a visual query language (SVIQUEL) which allows us to specify the relative spatial position (both topology and direction) between objects using direct manipulation. This query language builds upon the notion of dynamic query filters and significantly extends them to support integrated querying of both topological and directional types of spatial data. In order to facilitate continuous querying as required by a direct manipulation environment, we designed an integrated neighborhood model for both kinds of spatial relationships (topology and direction). Our spatial query p...
Cited by 0
Mastering · 2009
This chapter contains sections titled: Understanding ADO.NET Special Operations in ADO.NET Introducing Language Integrated Query (LINQ) LINQ and the Entity Framework The Bottom Line
Cited by 0
Jaroslav Pokorný · Foundations of Computing and Decision Sciences · 2019
Abstract In today’s multi-model database world there is an effort to integrate databases expressed in different data models. The aim of the article is to show possibilities of integration of relational and graph databases with the help of a functional data model and its formal language – a typed lambda calculus. We suppose the existence of a data schema both for the relational and graph database. In this approach, relations are considered as characteristic functions and property graphs as sets of single-valued and multivalued functions. Then it is possible to express a query over such integrated heterogeneous database by one query expression expressed in a version of the typed lambda calculus. A more user-friendly version of such language could serve as a powerful query tool in practice. We discuss also queries sent to the integrated system and translated into queries in SQL and Cypher - the graph query language for Neo4j.
Cited by 3Open access
Prof Dr, Dafydd Gibbon, Dafydd Gibbon et al. · 1993
3 1 Goals 4 2 Integrated lexical knowledge representation 6 2.1 Types of lexical knowledge 6 2.2 Basic principles and architecture of integrated lexicon theory 8 2.3 A microlexicon illustration of integrated lexical knowledge representation 12 3 DATR syntax and semantics 16 3.1 The original DATR BNF definition 16 3.2 An updated BNF syntax for DATR 17 3.3 Pure Prolog data structures as a model for DATR theories 18 3.4 Aspects of DATR semantics: other models for DATR theories 21 4 Query languages for integrated lexicon theories in DATR 23 4.1 The basic DATR Query Language: DQL 23 4.2 Pure Prolog semantics for DQL: &quot;MINIDATR&quot; 25 4.3 Augmented DQL: ADQL 29 4.4 A new Extended DATR Query Language: EDQL 30 5 The Open DATR Engine: ODE 34 5.1 The ODEC compiler and the ODEQ inference engine 34 5.2 Application to an integrated lexicon 35 6 Conclusion 39 Acknowledgements 40 References 41 Appendix 44 MINIDATR: A minimal core DATR engine in Prolog A generalisation of DATR. D. Gibbon, U Bielefeld, ...
Cited by 0
Miguel Garcia, Rakesh Prithiviraj · 2008
Abstract: There is a trend in programming language design toward adopting the same query and concurrency management mechanisms that have proven successful for databases, in the form of integrated query languages and transactional memory [HG06]. We focus on the demands placed on Object/Relational Mapping (ORM) in order to support comprehension queries, as known from LINQ and Scala. The additional expressive power enables the application of optimization techniques originating in the field of databases (query unnesting, ordering final instead of intermediate results, etc). As an interim step toward the proposed query integration, we describe a translator from a functional query language (comparable to LINQ) into JPQL, the query language of ORM engines following the JPA standard (JSR-317). A summary of related and ongoing work and an outlook of future work conclude this position paper. 1
Cited by 0