DBMS Archive

BaseX : Tutorial for using an XML Native Database Management System

XML is defined as a textual structured format for storing, representing and communicating data. The XML format is based on opening and closing tags for enclosing data content. As opposed to traditional databases, XML documents are portable and can be opened on any platform using any programming language. BaseX is a native ...Read More

Java & HSQLDB : Connecting to a DBMS (HSQLDB) from Java Program

1) Create a simple file and call it Simple.java. Here is a simple code written in Java to connect to a DBMS : import java.io.*; import java.sql.*; import java.util.*; public class Simple { public static void main(String args) { Connection con=null;; try { Class.forName("org.hsqldb.jdbc.JDBCDriver"); con=DriverManager.getConnection("jdbc:hsqldb:mydbb","SA",""); con.createStatement().executeUpdate("SET DATABASE SQL SYNTAX MYS TRUE"); con.createStatement().executeUpdate("create ...Read More

SQL Hello World: A simple guide to database systems using HSQLDB

In this tutorial, we will learn how to create a simple database and play with its content. The example we will consider is a simple phone book to store names, last names and phone numbers for people. 1) We need to download the DBMS  ( HSQLDB ): [a software that eases and ...Read More