Changes

User:Minooz/NexJ

81 bytes removed, 12:50, 10 November 2010

→‎Database / Persistence

==Database / Persistence==

~~: Eclipse Tutorial Videos on [http://eclipsetutorial.sourceforge.net/persistence.html Persistence]~~

: [http://xstream.codehaus.org/persistence-tutorial.html XML/Object Binding] and [http://code.google.com/p/xbird/wiki/XmlObjectBinding Object Persistence] =[http://xstream.codehaus.org/index.html XStream] + [http://code.google.com/p/xbird/ XBird] (XML database system]

~~: data persistence with [http://www.developer.com/xml/article.php/918111/Data-Persistence-and-Java-Data-Objects----JDO.htm JDO]~~

~~: java world [http://www.javaworld.com/javaworld/jw-03-2002/jw-0301-jdo.html jdo]~~

~~: JDBC [http://en.wikipedia.org/wiki/JDBC]~~

: Relational database Management System[http://en.wikipedia.org/wiki/Relational_database_management_system ]

~~: JDBC Driver [http://en.wikipedia.org/wiki/JDBC_driver]~~ * Database: ~~Drivers table[http://devapp.sun.com/product/jdbc/drivers]~~Indexes & Hints: ~~[http~~://xstream.codehaus.org/persistence-tutorial.html XML/Object Binding] and [http://code.google.com/p/xbird/wiki/XmlObjectBinding Object Persistence] = [http://xstream.codehaus.org/index.html XStream] + [http://code.google.com/p/xbird/ XBird]~~: Indexes~~ [http://odetocode.com/Articles/70.aspxIndex]:: Hints - Hints are options or strategies specified for enforcement by the SQL Server query processor on SELECT, INSERT, UPDATE, or DELETE statements. The hints override any execution plan the query optimizer might select for a query.

:: Query Hints - http://msdn.microsoft.com/en-us/library/ms181714.aspx

:: Index vs Index Hint http://www.doens.be/2010/10/index-vs-index-hint/

* : Trigger

:A trigger is a specification that the database should automatically execute a particular function whenever a certain type of operation is performed. Triggers can be defined to execute either before or after any INSERT, UPDATE, orDELETE operation, either once per modified row, or once per SQL statement. If a trigger event occurs, the trigger's function is called at the appropriate time to handle the event.[http://www.postgresql.org/docs/8.1/interactive/triggers.html]

: [http://en.wikipedia.org/wiki/Database_trigger Wiki]

: [http://www.postgresql.org/docs/8.1/interactive/triggers.html PostgreSQL]- Syntax [http://www.postgresql.org/docs/8.1/interactive/sql-createtrigger.html]

* : Stored Procedures

: [http://ovir.icp.ac.ru/oracle/doc/server/doc/scn73/ch14.htm Oracle Server Manual]

* : Transactions

: [http://ovir.icp.ac.ru/oracle/doc/server/doc/scn73/ch12.htm#toc094 Oracle Server Manual]

* Persistence

# Eclipse Tutorial Videos on [http://eclipsetutorial.sourceforge.net/persistence.html Persistence]

# [http://xstream.codehaus.org/persistence-tutorial.html XML/Object Binding] and [http://code.google.com/p/xbird/wiki/XmlObjectBinding Object Persistence] = [http://xstream.codehaus.org/index.html XStream] + [http://code.google.com/p/xbird/ XBird] (XML database system]

# data persistence with [http://www.developer.com/xml/article.php/918111/Data-Persistence-and-Java-Data-Objects----JDO.htm JDO]

# java world [http://www.javaworld.com/javaworld/jw-03-2002/jw-0301-jdo.html jdo]

* JDBC

# JDBC @ http://en.wikipedia.org/wiki/JDBC

# Relational database Management System @ http://en.wikipedia.org/wiki/Relational_database_management_system

# JDBC Driver @ http://en.wikipedia.org/wiki/JDBC_driver

# Drivers table http://devapp.sun.com/product/jdbc/drivers

===PostgreSQL and MySQL===

Minooz

1

edit

CDOT Wiki β

Changes

User:Minooz/NexJ

CDOT Wiki ^β