D7net Mini Sh3LL v1
| Current File : /var/www/html/hpsclab/download/sqlhandler/index.html |
<!DOCTYPE html>
<html lang="en-us">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="generator" content="Source Themes Academic 4.6.0">
<meta name="description" content="SQLH and Hyrax
Pre requirements: LIBPQ .
The software developed is a Hyrax plugin, useful to add SQL Query capabilities to the BES server. It consists in a fully functional SQL handler that you can customize and expand. In this ALPHA release you can:
Use OLFS to set constraints Set complex SQL query into the dataset file (Join, union) Set constraints into the dataset Set database password access into the dataset file OR using constraints BES Software">
<link rel="alternate" hreflang="en-us" href="/download/sqlhandler/">
<meta name="theme-color" content="#2962ff">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/academicons/1.8.6/css/academicons.min.css" integrity="sha256-uFVgMKfistnJAfoCUQigIl+JfUaP47GrRKjf6CTPVmw=" crossorigin="anonymous">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.11.2/css/all.min.css" integrity="sha256-+N4/V/SbAFiW1MPBCXnfnP9QSN3+Keu+NlB+0ev/YKQ=" crossorigin="anonymous">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/fancybox/3.5.7/jquery.fancybox.min.css" integrity="sha256-Vzbj7sDDS/woiFS3uNKo8eIuni59rjyNGtXfstRzStA=" crossorigin="anonymous">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/9.15.10/styles/github.min.css" crossorigin="anonymous" title="hl-light">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/9.15.10/styles/dracula.min.css" crossorigin="anonymous" title="hl-dark" disabled>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/leaflet/1.5.1/leaflet.css" integrity="sha256-SHMGCYmST46SoyGgo4YR/9AlK1vf3ff84Aq9yK4hdqM=" crossorigin="anonymous">
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Montserrat:400,700%7CRoboto:400,400italic,700%7CRoboto+Mono&display=swap">
<link rel="stylesheet" href="/css/academic.css">
<link rel="manifest" href="/index.webmanifest">
<link rel="icon" type="image/png" href="/img/icon-32.png">
<link rel="apple-touch-icon" type="image/png" href="/img/icon-192.png">
<link rel="canonical" href="/download/sqlhandler/">
<meta property="twitter:card" content="summary">
<meta property="og:site_name" content="HPSC Smart Lab">
<meta property="og:url" content="/download/sqlhandler/">
<meta property="og:title" content="SQL Handler | HPSC Smart Lab">
<meta property="og:description" content="SQLH and Hyrax
Pre requirements: LIBPQ .
The software developed is a Hyrax plugin, useful to add SQL Query capabilities to the BES server. It consists in a fully functional SQL handler that you can customize and expand. In this ALPHA release you can:
Use OLFS to set constraints Set complex SQL query into the dataset file (Join, union) Set constraints into the dataset Set database password access into the dataset file OR using constraints BES Software"><meta property="og:image" content="/img/logohpsclab.png">
<meta property="twitter:image" content="/img/logohpsclab.png"><meta property="og:locale" content="en-us">
<title>SQL Handler</title>
</head>
<body id="top" data-spy="scroll" data-offset="70" data-target="#TableOfContents" >
<aside class="search-results" id="search">
<div class="container">
<section class="search-header">
<div class="row no-gutters justify-content-between mb-3">
<div class="col-6">
<h1>Search</h1>
</div>
<div class="col-6 col-search-close">
<a class="js-search" href="#"><i class="fas fa-times-circle text-muted" aria-hidden="true"></i></a>
</div>
</div>
<div id="search-box">
<input name="q" id="search-query" placeholder="Search..." autocapitalize="off"
autocomplete="off" autocorrect="off" spellcheck="false" type="search">
</div>
</section>
<section class="section-search-results">
<div id="search-hits">
</div>
</section>
</div>
</aside>
<nav class="navbar navbar-expand-lg navbar-light compensate-for-scrollbar" id="navbar-main">
<div class="container">
<a class="navbar-brand" href="/"><img src="/img/logohpsclab.png" alt="HPSC Smart Lab"></a>
<button type="button" class="navbar-toggler" data-toggle="collapse"
data-target="#navbar-content" aria-controls="navbar" aria-expanded="false" aria-label="Toggle navigation">
<span><i class="fas fa-bars"></i></span>
</button>
<div class="navbar-collapse main-menu-item collapse justify-content-start" id="navbar-content">
<ul class="navbar-nav d-md-inline-flex">
<li class="nav-item">
<a class="nav-link " href="/#demo"><span>Home</span></a>
</li>
<li class="nav-item">
<a class="nav-link " href="/#research"><span>Research</span></a>
</li>
<li class="nav-item">
<a class="nav-link " href="/#staff"><span>Staff</span></a>
</li>
<li class="nav-item">
<a class="nav-link " href="/#projects"><span>Projects</span></a>
</li>
<li class="nav-item">
<a class="nav-link " href="/#links"><span>Links</span></a>
</li>
<li class="nav-item">
<a class="nav-link " href="/#download"><span>Download</span></a>
</li>
<li class="nav-item">
<a class="nav-link " href="/#contact"><span>Contacts</span></a>
</li>
</ul>
</div>
<ul class="nav-icons navbar-nav flex-row ml-auto d-flex pl-md-2">
<li class="nav-item">
<a class="nav-link js-search" href="#"><i class="fas fa-search" aria-hidden="true"></i></a>
</li>
<li class="nav-item">
<a class="nav-link js-dark-toggle" href="#"><i class="fas fa-moon" aria-hidden="true"></i></a>
</li>
</ul>
</div>
</nav>
<article class="article">
<div class="article-container pt-3">
<h1>SQL Handler</h1>
<div class="article-metadata">
<span class="article-date">
</span>
</div>
</div>
<div class="article-container">
<div class="article-style">
<p><span style="color: blue;">SQLH and Hyrax</span></p>
<p>Pre requirements: LIBPQ .</p>
<p>The software developed is a Hyrax plugin, useful to add SQL Query capabilities to the BES server. It consists in a fully functional SQL handler that you can customize and expand.
In this ALPHA release you can:</p>
<ul>
<li>Use OLFS to set constraints</li>
<li>Set complex SQL query into the dataset file (Join, union)</li>
<li>Set constraints into the dataset</li>
<li>Set database password access into the dataset file OR using constraints</li>
</ul>
<p><span style="color: blue;">BES Software</span></p>
<p>BES is a high-performance back-end server software framework that allows data providers more flexibility in providing end users views of their data. The current OPeNDAP data objects (DAS, DDS, and DataDDS) are still supported, but now data providers can add new data views, provide new functionality, and new features to their end users through the BES modular design. Providers can add new data handlers, new data objects/views, the ability to define views with constraints and aggregation, the ability to add reporting mechanisms, initialization hooks, and more.</p>
<p>OPeNDAP provides the tools to build these new modules that can then be dynamically loaded into the BES.</p>
<p><span style="color: blue;">Hyrax</span></p>
<p>Hyrax is the next generation server from OPeNDAP. It utilizes a modular design that employs a light weight Java servlet (aka OLFS) to provide the public-accessible client interface, and a back-end daemon, the BES to handle the heavy lifting. The BES uses the same handlers that are used with Server3 (also know as the CGI Server) but loads those at run time.</p>
<p>Benefits:</p>
<ul>
<li>The servlet architecture is faster, more robust, and secure than CGI invoked Perl scripts.</li>
<li>A single installation can handle multiple data representations (hdf4, hdf5, netcdf, et c.)</li>
<li>THREDDS catalog functionality.</li>
<li>A prototype SOAP interface for OPeNDAP data services.</li>
</ul>
<p><span style="color: blue;">OLFS: The Hyrax Front End</span></p>
<p>The OPeNDAP Lightweight Frontend Servlet (OLFS) provides the public-accessible client interface for Hyrax. The OLFS communicates with the Back End Server (BES) to provide data and catalog services to clients. The OLFS implements the DAP2 protocol and supports some of the new DAP4 features. We hope that other groups will develop new front end modules that will implement other protocols.</p>
<p>New Features:</p>
<ul>
<li>Provides THREDDS Catalogs responses</li>
<li>Prototype SOAP interface.</li>
</ul>
<p><span style="color: blue;">SQLH: SQL Handler</span></p>
<p>It’s an SQL handler used to connect databases to an OpeNDAP Hyrax (bes) server. Written in C++, it uses libpq to query DB. It implements many interfaces useful to give you an easy way to modify and to use it with other ODBC libraries.
It is composed by tree Basic component:</p>
<p>The <span style="color: blue;">SQLTable</span> class used to load the requested file.
Alternatively:</p>
<ul>
<li>A DAS object</li>
<li>A DDS object</li>
<li>A DataDDS object (a flat SQLSequence of strings)</li>
</ul>
<p><span style="color: blue;">The SQLFilterC(onstraint)E(xpression):</span><br />
Used to parse the selected dataset and (or) the contraint expressions specified by the user (using the OLFS).
It actually remove ALL the constraint expression from the URL and use it to build a filtered SQL query.
So the filter operation is done by the SQL server and no constraints will be passed to the BES.
You can easely change this behaviour.</p>
<p><span style="color: blue;">The SQLConnector</span><br />
It’s a component used to manage data transfer from the database (read-only). It’s composed by the following two components:</p>
<ul>
<li><p>The SQLResultSet
Specifies a common interface used to get values from the accessed database.
Its methods are used in the SQLTable and SQLFilterCE.</p></li>
<li><p>The SQLConnection
Specifies a common interface used to open and close a connection to the accessed database.
Its methods are used in the SQLTable and SQLFilterCE using SQLConnector.</p></li>
</ul>
<p>Enjoy!</p>
<p><div style="text-align: center"><a href="/zip/SQLHandler.tar.gz">SQLHandler.tar.gz</a>
<div style="text-align: center">[SQLH-UMLs.zip(/zip/SQLH-UMLs.zip)</p>
</div>
</div>
</article>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.4.1/jquery.min.js" integrity="sha256-CSXorXvZcTkaix6Yvo6HppcZGetbYMGWSFlBw8HfCJo=" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.imagesloaded/4.1.4/imagesloaded.pkgd.min.js" integrity="sha256-lqvxZrPLtfffUl2G/e7szqSvPBILGbwmsGE1MKlOi0Q=" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.isotope/3.0.6/isotope.pkgd.min.js" integrity="sha256-CBrpuqrMhXwcLLUd5tvQ4euBHCdh7wGlDfNz8vbu/iI=" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/fancybox/3.5.7/jquery.fancybox.min.js" integrity="sha256-yt2kYMy0w8AbtF89WXb2P1rfjcP/HTHLT7097U8Y5b8=" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/9.15.10/highlight.min.js" integrity="sha256-1zu+3BnLYV9LdiY85uXMzii3bdrkelyp37e0ZyTAQh0=" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/9.15.10/languages/r.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/leaflet/1.5.1/leaflet.js" integrity="sha256-EErZamuLefUnbMBQbsEqu1USa+btR2oIlCpBJbyD4/g=" crossorigin="anonymous"></script>
<script>hljs.initHighlightingOnLoad();</script>
<script>
const search_config = {"indexURI":"/index.json","minLength":1,"threshold":0.3};
const i18n = {"no_results":"No results found","placeholder":"Search...","results":"results found"};
const content_type = {
'post': "Posts",
'project': "Projects",
'publication' : "Publications",
'talk' : "Talks"
};
</script>
<script id="search-hit-fuse-template" type="text/x-template">
<div class="search-hit" id="summary-{{key}}">
<div class="search-hit-content">
<div class="search-hit-name">
<a href="{{relpermalink}}">{{title}}</a>
<div class="article-metadata search-hit-type">{{type}}</div>
<p class="search-hit-description">{{snippet}}</p>
</div>
</div>
</div>
</script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/fuse.js/3.2.1/fuse.min.js" integrity="sha256-VzgmKYmhsGNNN4Ph1kMW+BjoYJM2jV5i4IlFoeZA9XI=" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/mark.js/8.11.1/jquery.mark.min.js" integrity="sha256-4HLtjeVgH0eIB3aZ9mLYF6E8oU5chNdjU6p6rrXpl9U=" crossorigin="anonymous"></script>
<script src="/js/academic.min.96cf4c3dc37ea60dbbd03c13a455f1f7.js"></script>
<div class="container">
<footer class="site-footer">
<p class="powered-by">
Powered by the
<a href="https://sourcethemes.com/academic/" target="_blank" rel="noopener">Academic theme</a> for
<a href="https://gohugo.io" target="_blank" rel="noopener">Hugo</a>.
<span class="float-right" aria-hidden="true">
<a href="#" class="back-to-top">
<span class="button_icon">
<i class="fas fa-chevron-up fa-2x"></i>
</span>
</a>
</span>
</p>
</footer>
</div>
<div id="modal" class="modal fade" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title">Cite</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<pre><code class="tex hljs"></code></pre>
</div>
<div class="modal-footer">
<a class="btn btn-outline-primary my-1 js-copy-cite" href="#" target="_blank">
<i class="fas fa-copy"></i> Copy
</a>
<a class="btn btn-outline-primary my-1 js-download-cite" href="#" target="_blank">
<i class="fas fa-download"></i> Download
</a>
<div id="modal-error"></div>
</div>
</div>
</div>
</div>
</body>
</html>
AnonSec - 2021 | Recode By D7net