2 DBMS Systems DBMS is short for DataBase Management System, which serves as the engine behind a database system. 2.1 Oracle How do I logon to an Oracle database with sqlplus? In linux, use command line: sqlplus username/password@servicename How do I show all tables in the current database? select from all_objects where object_type like 'TABLE'; Note that it has to be uppercase TABLE, and for those of you MySQL fans, it's not 'show tables'. More over, all_objects table contains information about all objects in the current database: user@tns> select distinct (object_type) from all_objects; OBJECT_TYPE ------------------ CONSUMER GROUP EVALUATION CONTEXT FUNCTION LIBRARY OPERATOR PACKAGE PROCEDURE SEQUENCE SYNONYM TABLE TYPE VIEW 12 rows selected. How do I output to html files? set markup HTML on...[more] 2.2 MySQLMysql is a free open source database system, similar to PostgreSQL or Postgres as some people call it. History MySQL's ancestor is mSQL. At first the MySQL team tried to use mSQL with their own fast low-level (ISAM) routines. However, after some testing, they came to the conclusion that mSQL was not fast enough or flexible enough for their needs. Then they developed MySQL, which is also why MySQL has almost the same interface as mSQL. The name MySQL could have come from two sources: The base directory and a large number of libraries and tools have had the prefix my for well over 10 years. Also, the co-founder Monty Widenius's daughter is also named My. The name of the MySQL Dolphin (our logo) is Sakila suggested by Ambrose Twebaze, an Open ...[more] 2.3 PostgreSQLPostgreSQL, or Postgres, is an open-source database system licensed under BSD style license. History This all goes back to last century when people at the University of California at Berkeley developed a database system called Ingres (1977-1985). Later, Ingres branched into a few different products: Relational Technologies/Ingres Corporation, extended Ingres and produced one of the first commercially successful relational database servers. On the other branch, still at UC Berkley, Michael Stonebraker led a team and developed an object-relational database server called Postgres (1986-1994). Illustra 6.2 took the Postgres code and developed it into a commercial product. Two Berkeley graduate students, Jolly Chen and Andrew Yu, subsequently added SQL capab...[more] 2.4 HSQL DB Introduction HSQL DB is a 100% pure in memory Java database. Newer versions of HSQL db also supports disk-based tables. ...[more] 2.5 Oracle How do I logon to an Oracle database with sqlplus? In linux, use command line: sqlplus username/password@servicename How do I show all tables in the current database? select from all_objects where object_type like 'TABLE'; Note that it has to be uppercase TABLE, and for those of you MySQL fans, it's not 'show tables'. More over, all_objects table contains information about all objects in the current database: user@tns> select distinct (object_type) from all_objects; OBJECT_TYPE ------------------ CONSUMER GROUP EVALUATION CONTEXT FUNCTION LIBRARY OPERATOR PACKAGE PROCEDURE SEQUENCE SYNONYM TABLE TYPE VIEW 12 rows selected. How do I output to html files? set markup HTML on...[more] 2.6 SQL ServerThere are two SQL Servers: Microsoft SQL Server and Sybase SQL server. Microsoft SQL server was branched off Sybase SQL Server in 1992 and now they are two different products with some compatibility. ...[more] 2.7 Sqlite links ...[more] 3 Object-Relations Mapping Almost all major database systems today are relational database systems: data are organized into two-dimensional tables containing multiple records, with each record composed of multiple properties. The programming paradigm, however, are leaning towards object-oriented programming. Object-Relational mapping tools, or OR Mapping tools, are designed to bridge this gap between the programming paradigm and the database paradigm. 3.1 Hibernate Introduction Hibernate is a Java persistence layer toolset. It maps between Java classes to database tables and from Java data types to SQL data types, bidirectionally. Hibernate also provides data query and retrieval facilities. The whole purpose of Hibernate was to reduce development time otherwise spent with manual data handling in SQL and JDBC. Installation Download a copy of Hibernate from Hibernate website run ant to install hibernate test your hibernate installation update etc/hibernate.properties according to your system configuration make sure your JDBC driver is in $HIBERNATE_HOME/lib run "ant eg" A simple hibernate example Trust me, hibernate has excellent documentations, you'll see after...[more] Comments
DBMS is short for DataBase Management System, which serves as the engine behind a database system. 2.1 Oracle How do I logon to an Oracle database with sqlplus? In linux, use command line: sqlplus username/password@servicename How do I show all tables in the current database? select from all_objects where object_type like 'TABLE'; Note that it has to be uppercase TABLE, and for those of you MySQL fans, it's not 'show tables'. More over, all_objects table contains information about all objects in the current database: user@tns> select distinct (object_type) from all_objects; OBJECT_TYPE ------------------ CONSUMER GROUP EVALUATION CONTEXT FUNCTION LIBRARY OPERATOR PACKAGE PROCEDURE SEQUENCE SYNONYM TABLE TYPE VIEW 12 rows selected. How do I output to html files? set markup HTML on...[more] 2.2 MySQLMysql is a free open source database system, similar to PostgreSQL or Postgres as some people call it. History MySQL's ancestor is mSQL. At first the MySQL team tried to use mSQL with their own fast low-level (ISAM) routines. However, after some testing, they came to the conclusion that mSQL was not fast enough or flexible enough for their needs. Then they developed MySQL, which is also why MySQL has almost the same interface as mSQL. The name MySQL could have come from two sources: The base directory and a large number of libraries and tools have had the prefix my for well over 10 years. Also, the co-founder Monty Widenius's daughter is also named My. The name of the MySQL Dolphin (our logo) is Sakila suggested by Ambrose Twebaze, an Open ...[more] 2.3 PostgreSQLPostgreSQL, or Postgres, is an open-source database system licensed under BSD style license. History This all goes back to last century when people at the University of California at Berkeley developed a database system called Ingres (1977-1985). Later, Ingres branched into a few different products: Relational Technologies/Ingres Corporation, extended Ingres and produced one of the first commercially successful relational database servers. On the other branch, still at UC Berkley, Michael Stonebraker led a team and developed an object-relational database server called Postgres (1986-1994). Illustra 6.2 took the Postgres code and developed it into a commercial product. Two Berkeley graduate students, Jolly Chen and Andrew Yu, subsequently added SQL capab...[more] 2.4 HSQL DB Introduction HSQL DB is a 100% pure in memory Java database. Newer versions of HSQL db also supports disk-based tables. ...[more] 2.5 Oracle How do I logon to an Oracle database with sqlplus? In linux, use command line: sqlplus username/password@servicename How do I show all tables in the current database? select from all_objects where object_type like 'TABLE'; Note that it has to be uppercase TABLE, and for those of you MySQL fans, it's not 'show tables'. More over, all_objects table contains information about all objects in the current database: user@tns> select distinct (object_type) from all_objects; OBJECT_TYPE ------------------ CONSUMER GROUP EVALUATION CONTEXT FUNCTION LIBRARY OPERATOR PACKAGE PROCEDURE SEQUENCE SYNONYM TABLE TYPE VIEW 12 rows selected. How do I output to html files? set markup HTML on...[more] 2.6 SQL ServerThere are two SQL Servers: Microsoft SQL Server and Sybase SQL server. Microsoft SQL server was branched off Sybase SQL Server in 1992 and now they are two different products with some compatibility. ...[more] 2.7 Sqlite links ...[more] 3 Object-Relations Mapping Almost all major database systems today are relational database systems: data are organized into two-dimensional tables containing multiple records, with each record composed of multiple properties. The programming paradigm, however, are leaning towards object-oriented programming. Object-Relational mapping tools, or OR Mapping tools, are designed to bridge this gap between the programming paradigm and the database paradigm. 3.1 Hibernate Introduction Hibernate is a Java persistence layer toolset. It maps between Java classes to database tables and from Java data types to SQL data types, bidirectionally. Hibernate also provides data query and retrieval facilities. The whole purpose of Hibernate was to reduce development time otherwise spent with manual data handling in SQL and JDBC. Installation Download a copy of Hibernate from Hibernate website run ant to install hibernate test your hibernate installation update etc/hibernate.properties according to your system configuration make sure your JDBC driver is in $HIBERNATE_HOME/lib run "ant eg" A simple hibernate example Trust me, hibernate has excellent documentations, you'll see after...[more] Comments
2.2 MySQLMysql is a free open source database system, similar to PostgreSQL or Postgres as some people call it. History MySQL's ancestor is mSQL. At first the MySQL team tried to use mSQL with their own fast low-level (ISAM) routines. However, after some testing, they came to the conclusion that mSQL was not fast enough or flexible enough for their needs. Then they developed MySQL, which is also why MySQL has almost the same interface as mSQL. The name MySQL could have come from two sources: The base directory and a large number of libraries and tools have had the prefix my for well over 10 years. Also, the co-founder Monty Widenius's daughter is also named My. The name of the MySQL Dolphin (our logo) is Sakila suggested by Ambrose Twebaze, an Open ...[more] 2.3 PostgreSQLPostgreSQL, or Postgres, is an open-source database system licensed under BSD style license. History This all goes back to last century when people at the University of California at Berkeley developed a database system called Ingres (1977-1985). Later, Ingres branched into a few different products: Relational Technologies/Ingres Corporation, extended Ingres and produced one of the first commercially successful relational database servers. On the other branch, still at UC Berkley, Michael Stonebraker led a team and developed an object-relational database server called Postgres (1986-1994). Illustra 6.2 took the Postgres code and developed it into a commercial product. Two Berkeley graduate students, Jolly Chen and Andrew Yu, subsequently added SQL capab...[more] 2.4 HSQL DB Introduction HSQL DB is a 100% pure in memory Java database. Newer versions of HSQL db also supports disk-based tables. ...[more] 2.5 Oracle How do I logon to an Oracle database with sqlplus? In linux, use command line: sqlplus username/password@servicename How do I show all tables in the current database? select from all_objects where object_type like 'TABLE'; Note that it has to be uppercase TABLE, and for those of you MySQL fans, it's not 'show tables'. More over, all_objects table contains information about all objects in the current database: user@tns> select distinct (object_type) from all_objects; OBJECT_TYPE ------------------ CONSUMER GROUP EVALUATION CONTEXT FUNCTION LIBRARY OPERATOR PACKAGE PROCEDURE SEQUENCE SYNONYM TABLE TYPE VIEW 12 rows selected. How do I output to html files? set markup HTML on...[more] 2.6 SQL ServerThere are two SQL Servers: Microsoft SQL Server and Sybase SQL server. Microsoft SQL server was branched off Sybase SQL Server in 1992 and now they are two different products with some compatibility. ...[more] 2.7 Sqlite links ...[more] 3 Object-Relations Mapping Almost all major database systems today are relational database systems: data are organized into two-dimensional tables containing multiple records, with each record composed of multiple properties. The programming paradigm, however, are leaning towards object-oriented programming. Object-Relational mapping tools, or OR Mapping tools, are designed to bridge this gap between the programming paradigm and the database paradigm. 3.1 Hibernate Introduction Hibernate is a Java persistence layer toolset. It maps between Java classes to database tables and from Java data types to SQL data types, bidirectionally. Hibernate also provides data query and retrieval facilities. The whole purpose of Hibernate was to reduce development time otherwise spent with manual data handling in SQL and JDBC. Installation Download a copy of Hibernate from Hibernate website run ant to install hibernate test your hibernate installation update etc/hibernate.properties according to your system configuration make sure your JDBC driver is in $HIBERNATE_HOME/lib run "ant eg" A simple hibernate example Trust me, hibernate has excellent documentations, you'll see after...[more] Comments
The name MySQL could have come from two sources: The base directory and a large number of libraries and tools have had the prefix my for well over 10 years. Also, the co-founder Monty Widenius's daughter is also named My.
The name of the MySQL Dolphin (our logo) is Sakila suggested by Ambrose Twebaze, an Open ...[more]
2.3 PostgreSQLPostgreSQL, or Postgres, is an open-source database system licensed under BSD style license. History This all goes back to last century when people at the University of California at Berkeley developed a database system called Ingres (1977-1985). Later, Ingres branched into a few different products: Relational Technologies/Ingres Corporation, extended Ingres and produced one of the first commercially successful relational database servers. On the other branch, still at UC Berkley, Michael Stonebraker led a team and developed an object-relational database server called Postgres (1986-1994). Illustra 6.2 took the Postgres code and developed it into a commercial product. Two Berkeley graduate students, Jolly Chen and Andrew Yu, subsequently added SQL capab...[more] 2.4 HSQL DB Introduction HSQL DB is a 100% pure in memory Java database. Newer versions of HSQL db also supports disk-based tables. ...[more] 2.5 Oracle How do I logon to an Oracle database with sqlplus? In linux, use command line: sqlplus username/password@servicename How do I show all tables in the current database? select from all_objects where object_type like 'TABLE'; Note that it has to be uppercase TABLE, and for those of you MySQL fans, it's not 'show tables'. More over, all_objects table contains information about all objects in the current database: user@tns> select distinct (object_type) from all_objects; OBJECT_TYPE ------------------ CONSUMER GROUP EVALUATION CONTEXT FUNCTION LIBRARY OPERATOR PACKAGE PROCEDURE SEQUENCE SYNONYM TABLE TYPE VIEW 12 rows selected. How do I output to html files? set markup HTML on...[more] 2.6 SQL ServerThere are two SQL Servers: Microsoft SQL Server and Sybase SQL server. Microsoft SQL server was branched off Sybase SQL Server in 1992 and now they are two different products with some compatibility. ...[more] 2.7 Sqlite links ...[more] 3 Object-Relations Mapping Almost all major database systems today are relational database systems: data are organized into two-dimensional tables containing multiple records, with each record composed of multiple properties. The programming paradigm, however, are leaning towards object-oriented programming. Object-Relational mapping tools, or OR Mapping tools, are designed to bridge this gap between the programming paradigm and the database paradigm. 3.1 Hibernate Introduction Hibernate is a Java persistence layer toolset. It maps between Java classes to database tables and from Java data types to SQL data types, bidirectionally. Hibernate also provides data query and retrieval facilities. The whole purpose of Hibernate was to reduce development time otherwise spent with manual data handling in SQL and JDBC. Installation Download a copy of Hibernate from Hibernate website run ant to install hibernate test your hibernate installation update etc/hibernate.properties according to your system configuration make sure your JDBC driver is in $HIBERNATE_HOME/lib run "ant eg" A simple hibernate example Trust me, hibernate has excellent documentations, you'll see after...[more] Comments
2.4 HSQL DB Introduction HSQL DB is a 100% pure in memory Java database. Newer versions of HSQL db also supports disk-based tables. ...[more] 2.5 Oracle How do I logon to an Oracle database with sqlplus? In linux, use command line: sqlplus username/password@servicename How do I show all tables in the current database? select from all_objects where object_type like 'TABLE'; Note that it has to be uppercase TABLE, and for those of you MySQL fans, it's not 'show tables'. More over, all_objects table contains information about all objects in the current database: user@tns> select distinct (object_type) from all_objects; OBJECT_TYPE ------------------ CONSUMER GROUP EVALUATION CONTEXT FUNCTION LIBRARY OPERATOR PACKAGE PROCEDURE SEQUENCE SYNONYM TABLE TYPE VIEW 12 rows selected. How do I output to html files? set markup HTML on...[more] 2.6 SQL ServerThere are two SQL Servers: Microsoft SQL Server and Sybase SQL server. Microsoft SQL server was branched off Sybase SQL Server in 1992 and now they are two different products with some compatibility. ...[more] 2.7 Sqlite links ...[more] 3 Object-Relations Mapping Almost all major database systems today are relational database systems: data are organized into two-dimensional tables containing multiple records, with each record composed of multiple properties. The programming paradigm, however, are leaning towards object-oriented programming. Object-Relational mapping tools, or OR Mapping tools, are designed to bridge this gap between the programming paradigm and the database paradigm. 3.1 Hibernate Introduction Hibernate is a Java persistence layer toolset. It maps between Java classes to database tables and from Java data types to SQL data types, bidirectionally. Hibernate also provides data query and retrieval facilities. The whole purpose of Hibernate was to reduce development time otherwise spent with manual data handling in SQL and JDBC. Installation Download a copy of Hibernate from Hibernate website run ant to install hibernate test your hibernate installation update etc/hibernate.properties according to your system configuration make sure your JDBC driver is in $HIBERNATE_HOME/lib run "ant eg" A simple hibernate example Trust me, hibernate has excellent documentations, you'll see after...[more] Comments
2.5 Oracle How do I logon to an Oracle database with sqlplus? In linux, use command line: sqlplus username/password@servicename How do I show all tables in the current database? select from all_objects where object_type like 'TABLE'; Note that it has to be uppercase TABLE, and for those of you MySQL fans, it's not 'show tables'. More over, all_objects table contains information about all objects in the current database: user@tns> select distinct (object_type) from all_objects; OBJECT_TYPE ------------------ CONSUMER GROUP EVALUATION CONTEXT FUNCTION LIBRARY OPERATOR PACKAGE PROCEDURE SEQUENCE SYNONYM TABLE TYPE VIEW 12 rows selected. How do I output to html files? set markup HTML on...[more] 2.6 SQL ServerThere are two SQL Servers: Microsoft SQL Server and Sybase SQL server. Microsoft SQL server was branched off Sybase SQL Server in 1992 and now they are two different products with some compatibility. ...[more] 2.7 Sqlite links ...[more] 3 Object-Relations Mapping Almost all major database systems today are relational database systems: data are organized into two-dimensional tables containing multiple records, with each record composed of multiple properties. The programming paradigm, however, are leaning towards object-oriented programming. Object-Relational mapping tools, or OR Mapping tools, are designed to bridge this gap between the programming paradigm and the database paradigm. 3.1 Hibernate Introduction Hibernate is a Java persistence layer toolset. It maps between Java classes to database tables and from Java data types to SQL data types, bidirectionally. Hibernate also provides data query and retrieval facilities. The whole purpose of Hibernate was to reduce development time otherwise spent with manual data handling in SQL and JDBC. Installation Download a copy of Hibernate from Hibernate website run ant to install hibernate test your hibernate installation update etc/hibernate.properties according to your system configuration make sure your JDBC driver is in $HIBERNATE_HOME/lib run "ant eg" A simple hibernate example Trust me, hibernate has excellent documentations, you'll see after...[more] Comments
2.6 SQL ServerThere are two SQL Servers: Microsoft SQL Server and Sybase SQL server. Microsoft SQL server was branched off Sybase SQL Server in 1992 and now they are two different products with some compatibility. ...[more] 2.7 Sqlite links ...[more] 3 Object-Relations Mapping Almost all major database systems today are relational database systems: data are organized into two-dimensional tables containing multiple records, with each record composed of multiple properties. The programming paradigm, however, are leaning towards object-oriented programming. Object-Relational mapping tools, or OR Mapping tools, are designed to bridge this gap between the programming paradigm and the database paradigm. 3.1 Hibernate Introduction Hibernate is a Java persistence layer toolset. It maps between Java classes to database tables and from Java data types to SQL data types, bidirectionally. Hibernate also provides data query and retrieval facilities. The whole purpose of Hibernate was to reduce development time otherwise spent with manual data handling in SQL and JDBC. Installation Download a copy of Hibernate from Hibernate website run ant to install hibernate test your hibernate installation update etc/hibernate.properties according to your system configuration make sure your JDBC driver is in $HIBERNATE_HOME/lib run "ant eg" A simple hibernate example Trust me, hibernate has excellent documentations, you'll see after...[more] Comments
2.7 Sqlite links ...[more] 3 Object-Relations Mapping Almost all major database systems today are relational database systems: data are organized into two-dimensional tables containing multiple records, with each record composed of multiple properties. The programming paradigm, however, are leaning towards object-oriented programming. Object-Relational mapping tools, or OR Mapping tools, are designed to bridge this gap between the programming paradigm and the database paradigm. 3.1 Hibernate Introduction Hibernate is a Java persistence layer toolset. It maps between Java classes to database tables and from Java data types to SQL data types, bidirectionally. Hibernate also provides data query and retrieval facilities. The whole purpose of Hibernate was to reduce development time otherwise spent with manual data handling in SQL and JDBC. Installation Download a copy of Hibernate from Hibernate website run ant to install hibernate test your hibernate installation update etc/hibernate.properties according to your system configuration make sure your JDBC driver is in $HIBERNATE_HOME/lib run "ant eg" A simple hibernate example Trust me, hibernate has excellent documentations, you'll see after...[more] Comments
3 Object-Relations Mapping Almost all major database systems today are relational database systems: data are organized into two-dimensional tables containing multiple records, with each record composed of multiple properties. The programming paradigm, however, are leaning towards object-oriented programming. Object-Relational mapping tools, or OR Mapping tools, are designed to bridge this gap between the programming paradigm and the database paradigm. 3.1 Hibernate Introduction Hibernate is a Java persistence layer toolset. It maps between Java classes to database tables and from Java data types to SQL data types, bidirectionally. Hibernate also provides data query and retrieval facilities. The whole purpose of Hibernate was to reduce development time otherwise spent with manual data handling in SQL and JDBC. Installation Download a copy of Hibernate from Hibernate website run ant to install hibernate test your hibernate installation update etc/hibernate.properties according to your system configuration make sure your JDBC driver is in $HIBERNATE_HOME/lib run "ant eg" A simple hibernate example Trust me, hibernate has excellent documentations, you'll see after...[more] Comments
Almost all major database systems today are relational database systems: data are organized into two-dimensional tables containing multiple records, with each record composed of multiple properties. The programming paradigm, however, are leaning towards object-oriented programming. Object-Relational mapping tools, or OR Mapping tools, are designed to bridge this gap between the programming paradigm and the database paradigm. 3.1 Hibernate Introduction Hibernate is a Java persistence layer toolset. It maps between Java classes to database tables and from Java data types to SQL data types, bidirectionally. Hibernate also provides data query and retrieval facilities. The whole purpose of Hibernate was to reduce development time otherwise spent with manual data handling in SQL and JDBC. Installation Download a copy of Hibernate from Hibernate website run ant to install hibernate test your hibernate installation update etc/hibernate.properties according to your system configuration make sure your JDBC driver is in $HIBERNATE_HOME/lib run "ant eg" A simple hibernate example Trust me, hibernate has excellent documentations, you'll see after...[more] Comments
English-Chinese