This book constitutes the thoroughly refereed post-proceedings of the 9th International Workshop on Database Programming Languages, DBPL 2003, held in Potsdam, Germany in September 2003. The 14 revised full papers presented together with an invited paper were carefully selected during two round of reviewing and revision from 22 submissions. The papers are organized in topical sections on static analysis, transactions, modeling data and services, novel applications of XML and XQuery, and XML processing and validation.
Covers fundamental and advanced Java database programming techniques for beginning and experienced readers This book covers the practical considerations and applications in database programming using Java NetBeans IDE, JavaServer Pages, JavaServer Faces, and Java Beans, and comes complete with authentic examples and detailed explanations. Two data-action methods are developed and presented in this important resource. With Java Persistence API and plug-in Tools, readers are directed step by step through the entire database programming development process and will be able to design and build professional data-action projects with a few lines of code in mere minutes. The second method, runtime object, allows readers to design and build more sophisticated and practical Java database applications. Advanced and updated Java database programming techniques such as Java Enterprise Edition development kits, Enterprise Java Beans, JavaServer Pages, JavaServer Faces, Java RowSet Object, and Java Updatable ResultSet are also discussed and implemented with numerous example projects. Ideal for classroom and professional training use, this text also features: A detailed introduction to NetBeans Integrated Development Environment Java web-based database programming techniques (web applications and web services) More than thirty detailed, real-life sample projects analyzed via line-by-line illustrations Problems and solutions for each chapter A wealth of supplemental material available for download from the book's ftp site, including PowerPoint slides, solution manual, JSP pages, sample image files, and sample databases Coverage of two popular database systems: SQL Server 2008 and Oracle This book provides undergraduate and graduate students as well as database programmers and software engineers with the necessary tools to handle the database programming issues in the Java NetBeans environment. To obtain instructor materials please send an email to: [email protected]
The Fourth International Workshop on Database Programming Languages - Object Models and Languages (DBPL-4) took place in Manhattan, New York City, 30 August-1 September 1993. The areas of interest and the format of DBPL-4 focused on the integration of programming languages, object models, type systems and database systems. As in the previous DBPL workshops, the setting was informal, allowing the participants to actively discuss and argue about the ideas presented in the talks. The comments and remarks made by the participants during and after the presentations were taken into account in the preparation of the final versions of the papers. The result, we believe, is a set of excellent papers. The DBPL sequence is closely related to the sequence of International Workshops on Persistent Object Systems (POS), first started in 1985. While the DBPL workshops focus on language and model issues, the POS workshops have focused on implementation issues; thus the two sequences complement each other. Many researchers participate in both workshop series. The eight sessions of the technical program of DBPL-4 were as follows: 1. Bulk types and their query languages (two sessions). 2. Object models and languages. 3. Data types with order. 4. Mechanisms to support persistence, reflection, and extensibility. 5. Query optimization and integrity constraints. 6. Logic-based models. 7. Implementation and performance issues.
This book constitutes the thoroughly refereed post-workshop proceedings of the 6th International Workshop on Database Programming Languages, DBPL-6, held in Estes Park, Colorado, USA, in August 1997. The 20 revised full papers presented have gone through two rounds of reviewing and selection. Also included are two invited talks, the transcription of a panel discussion and an introductory survey by the volume editors. The papers address all current aspects of database programming languages, in particular spatial databases, typing, query languages for new applications, views, expressive power, aggregate queries, cooperative work, and transactions.
Languages may come and go, but the relational database endures. Learn how to use Ecto, the premier database library for Elixir, to connect your Elixir and Phoenix apps to databases. Get a firm handle on Ecto fundamentals with a module-by-module tour of the critical parts of Ecto. Then move on to more advanced topics and advice on best practices with a series of recipes that provide clear, step-by-step instructions on scenarios commonly encountered by app developers. Co-authored by the creator of Ecto, this title provides all the essentials you need to use Ecto effectively. Elixir and Phoenix are taking the application development world by storm, and Ecto, the database library that ships with Phoenix, is going right along with them. There are plenty of examples that show you the basics, but to use Ecto to its full potential, you need to learn the library from the ground up. This definitive guide starts with a tour of the core features of Ecto - repos, queries, schemas, changesets, transactions - gradually building your knowledge with tasks of ever-increasing complexity. Along the way, you'll be learning by doing - a sample application handles all the boilerplate so you can focus on getting Ecto into your fingers. Build on that core knowledge with a series of recipes featuring more advanced topics. Change your pooling strategy to maximize your database's efficiency. Use nested associations to handle complex table relationships. Add streams to handle large result sets with ease. Based on questions from Ecto users, these recipes cover the most common situations developers run into. Whether you're new to Ecto, or already have an app in production, this title will give you a deeper understanding of how Ecto works, and help make your database code cleaner and more efficient. What You Need: To follow along with the book, you should have Erlang/OTP 19+ and Elixir 1.4+ installed. The book will guide you through setting up a sample application that integrates Ecto.
Proceedings of the meeting held in Jerusalem, Israel, June, 1988. Thirty papers represent a cross ssection of the many facets of contemporary database research and provide an up-to-date account of activities of some of the leading companies in the database field. Covers: knowledge-based application
A complete guide to mastering the next generation of database programming technologies Java Database Programming teaches you the critical new Java database technologies and tools, including Sun Microsystems' Java Database Connectivity (JDBC) standard. You'll learn practical, step-by-step techniques with which you can harness the Java programming language. You will also learn how to create dynamic database applications and applets in both Internet and Intranet environments. Java Database Programming explains: How Java programs access online databases Integrating Java with networked database technologies Programming with JDBC How to develop JDBC drivers Java database tools and code libraries Java Database Programming is the innovative and hands-on book that will enable you to apply Java to real-world Internet and Intranet development. On the Java Database Programming supporting Web site, you'll find: tinySQL, a generic and extendable SQL engine written in Java The tinySQL JDBC driver Customizable Java database code Visit our Web site at: http://www.wiley.com/compbooks/
This publication focuses on two main aspects; the seamless integration of XML and persistency concepts into the object-oriented programming language Java. XML is the de facto standard data exchange format between arbitrary applications. There have been many efforts to integrate XML into programming languages reaching from the simple document object model (DOM) to whole XML class generators. These approaches are available in most popular programming languages. The integration of persistency into programming languages has been done by database programming languages as well as by certain new popular frameworks like Hibernate or approaches like EJB. Nevertheless, these approaches suffer from certain limitations concerning in particular transparency and object-orientation. While existing database programming languages integrate the relational model, Hibernate and EJB 3.x does not support polymorphism in general. EJB 2.x does not even support inheritance. In addition, although they try to, the approaches except by some database programming languages are not transparent. In this work, transparency means that arbitrary types may become persistent. Moreover, algorithms remain unchanged whether they are executed on transient or persistent objects. Finally, users can work with persistency on a very high level. Since there are so many currently developed frameworks trying to solve the integration problem of XML and persistency into object-oriented programming languages, the need for a holistic and transparent object-oriented database programming language seems to be there. The starting point of XOBEDBPL, which stands for XML OBjEcts Database Programming Language, is the predecessor project XOBE. XOBE concentrates on the integration of XML objects and XPath as the query language for these objects. The most important feature of XOBE is that each XML operation is statically type checked against the declared XML schema. In XOBEDBPL the XML integration is extended regarding the manipulation of XML objects. Before, XML objects could only be queried but not updated. The static type checking idea is kept and enhanced to include updates. While XOBE's intentions lie on the development of web applications, all objects can remain transient. XOBEDBPL is supposed to deal with persistent objects as well.
Use and development of database and expert systems can be found in all fields of computer science. The aim of this book is to present a large spectrum of already implemented or just being developed database and expert systems. Contributions cover new requirements, concepts for implementations (e.g. languages, models, storage structures), management of meta data, system architectures, and experiences gained by using traditional databases in as many areas of applications as possibble (at least in the fields listed). The aim of the book is to inspire a fruitful dialogue between developement in practice, users of database and expert systems, and scientists working in the field.
