PUBLIC MARKS from solrac with tag sql

JDBC, or Java Database Connectivity, is one of the most frequently used packages in the entire JDK, and yet few Java developers use it to its fullest — or most up-to-date — capacity. This article offers an introduction to newer JDBC features.

Tap into vast amounts of fielded information stored in a publicly accessible collection called DBpedia. With a little CGI scripting, build forms that drive a SPARQL query under the covers, with access to the semantic Web's largest database for people who've never heard of the semantic Web.

Like Structured Query Language (SQL), XQuery is a lookup specification tied to the XML standard. Using XML as the model and XQuery as the view is a powerful way to provide a language-agnostic solution while still retaining the benefits of using the MVC pattern. In this article, explore the advantages of XQuery over other view technologies (PHP, JSP), how XQuery is implemented in the presentation layer, and a realistic example of such an implementation.

ATS (admin task scheduler) enables administrators to automate tasks by scheduling execution of stored procedures. Many Linux and Unix database administration tasks, such as online backup, can be performed by calling the built-in ADMIN_CMD procedure. ATS uses a straightforward SQL interface and operates without the DAS.