9. Databases
Abstract:
Databases provide persistence and can be accessed in terms of transactions. Some aspects of interest for our objectives are access to databases from distributed applications, access to databases from the web, and providing persistence to components. Recent PLoP conferences have presented several patterns to map objects into relational databases. Transactions are very important for consistency, individual updates either commit as a whole and are reflected to the database, or it is as if they never existed. A trend now is toward distributed and replicated databases. This corresponds to geographic distribution but also improves reliability (replication) and load balancing [Sut00]. Another important trend is XML, we discuss its impact in Sections 6 and 12. JDBC Currently, the most common database systems are relational databases, accessed using SQL as query language. To access SQL from applications, the SQL Access Group (SAG) developed a standard call-level interface (CLI). The CLI describes how SQL statements are issued from a programming language and how the results are bound to program variables. From CLI Microsoft produced the Open Database Connectivity (ODBC)
Citations
| 24 | Java Distributed Computing – Farley - 1998 |
| 18 | Resistance is futile: The Web will assimilate your database – Malaika - 1998 |
| 7 | JDBC Database Access with Java – Hamilton, Fisher - 1997 |
| 1 | A pattern for building powerful JSPs”, Java Report – Bell, Silva, et al. - 2000 |
| 1 | Introducing Java – Eden, Ludke - 2000 |
| 1 | et al., “W3Objects: Distributed objects and the – Ingham - 1997 |
| 1 | Accessing Existing Business Data from – Peng, Chen, et al. - 1998 |
| 1 | Connecting to JDBC”, Java Pro – Reese - 1998 |
| 1 | Create enterprise applications with JDBC 2.0”, Java Pro – Spell - 2000 |
| 1 | Distributed databases: Overview and current trends, tutorial at Software Development 2000 – Sutter - 2000 |
| 1 | Connecting Java with relational databases”, Object Magazine – Vermeulen - 1997 |
