2010
Java development 2.0: Sharding with Hibernate Shards
Among various sharding implementations, Hibernate Shards is possibly the most popular in the world of Java technology. For some shops, sharding means being able to keep a trusted RDBMS in place without sacrificing data scalability or system performance. In this installment of the Java development 2.0 series, find out when sharding works, and when it doesn't, and then get your hands busy sharding a simple application capable of handling terabytes of data.
5 things you didn't know about Java Database Connectivity
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.
CouchDB basics for PHP developers
Take a look at CouchDB from a PHP developer's point of view, and learn how CouchDB gives you a document-based, schema-free, ad-hoc database with a flat address space. Learn how you can add CouchDB to your technical toolboxes to create and delete databases, work with CouchDB views, and more.
2009
Leverage Semantic SPARQL endpoints and DBpedia cotent
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.
Exploring JSON and CouchDB
CouchDB is an open source document-oriented database-management system, accessible using a RESTful JavaScript Object Notation (JSON) API. CouchDB never claimed to be a replacement for relational databases, but it has become increasingly popular in Web applications, iPhone applications, and Facebook applications. See how CouchDB stores data in a semi-structured fashion, using a JavaScript-based view model
Building faster Web apps using PHP and in-memory solidDB
solidDB is an in-memory database that can perform at speeds up to 10 times faster than conventional databases. Learn how to use PHP with solidDB to build faster dynamic Web page applications. This article shows you how to use PHP to connect to a solidDB database and perform basic operations such as retrieve, update, and delete. You can use these steps as a foundation for building rich Web applications that harness the power of solidDB.
2008
Apache allows data access even if a server is unavailable
Learn how to use Apache Derby as a local data store that can be used to take your Ajax web application offline. See how easy it is to use Derby as an embedded database, and how to provide persistent data to the client with a Java applet. Thus, Derby can be a key part of "offline" strategy, making data available even when the server is unavailable.
The DB2 SQL-based Admin Task Scheduler for Linux and UNIX
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.
2007
Writing Java code that interfaces with DB2
Learn about writing Java code that interfaces with DB2 databases. You will acquire the fundamental skills required to develop Java applications for DB2. You will see how easy it is to connect to a DB2 database from a Java application, use JDBC to read and update data in a DB2 database, Use SQL for Java (SQLJ) to read and update data in a DB2 database, and how to troubleshoot a DB2 Java application. If you dont have DB2 installed, you can download ( http://www.ibm.com/developerworks/downloads/im/udbexp/?S_TACT=105AGX59&S_CMP=GR&ca=dgr-lnxw01DB2-EC ) DB2 Express-C here at no-cost.
1
(9 marks)