DocumentCode :
2953816
Title :
SQL-jQuery client a tool managing the DB backend of the CMS software framework through Web Browser
Author :
Pierro, Antonio ; Cavallari, Francesca ; Guida, Salvatore Di ; Innocente, Vincenzo ; Beinaravicius, Algirdas
Author_Institution :
INFN, Sezione di Bari, Bari, Italy
fYear :
2010
fDate :
24-28 May 2010
Firstpage :
1
Lastpage :
4
Abstract :
PJ-SQL-Browser is a free Python-Javascript web based tool. It relies on jQuery and python libraries, and is intended to provide the CMS software framework a real-time handle to the DB backend inside a local web browser. Nowadays, the number of DBs accessing built on Java or .Net is steadingly increasing. However, many of these application have several drawbacks: usually they are not open-source, they provide interface only with a specific kind of database, are platform-dependent and very CPU and memory consuming, so that normal computers can have problems to run them. We developed a template-based free software tool, intended to handle with different DBMS by using a local Web Browser. Such tool makes use of jQuery and python libraries and we hereby prove to be fast, easy to install and to configure. Thanks to JavaScript Interpreter, a powerful Javascript engine implemented in the latest web browsers (Mozilla, Firefox, Safari, Opera, Google Chrome and Internet Explorer), and to the easier JavaScript-HTML interaction enabled by jQuery libraries, such tool performs backend-databases-access and provides all the features embedded in commercial DB clients like DDL statements and allows data exportation to various formats (like XML and JSON), that can be employed eventually exploited by other applications. On top at that the application enables as well updates real time; indeed by using asynchronous Ajax calls to server services, we can keep users updated with the latest information changed on Online Database Condition, ensuring a small latency to retrieve the real-time information. Finally, by using a set of pre-defined functions, users are allowed to create their customized views for a better data visualisation.
Keywords :
Java; SQL; data visualisation; online front-ends; query processing; software libraries; software tools; .Net; CMS software framework; DB backend; DDL statements; Firefox; Google Chrome; Internet Explorer; JSON; Java; JavaScript Interpreter; Javascript engine; Mozilla; Opera; PJ-SQL-browser; Python-Javascript Web based tool; SQL-jQuery; Safari; Web browser; XML; asynchronous Ajax calls; data exportation; data visualisation; database management services; online database condition; python libraries; template-based free software tool; Browsers; Engines; Libraries; Real time systems; Relational databases; Servers;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Real Time Conference (RT), 2010 17th IEEE-NPSS
Conference_Location :
Lisbon
Print_ISBN :
978-1-4244-7108-9
Type :
conf
DOI :
10.1109/RTC.2010.5750372
Filename :
5750372
Link To Document :
بازگشت