name = pureQuery developer = IBM latest_release_version = 1.2 latest_release_date = July 31, 2008 operating_system = Cross-platform platform = Java genre = Java Data Access platform (computing) website = [http://www.ibm.com/software/data/studio/purequery/ IBM Data Studio] [http://www.ibm.com/developerworks/downloads/im/datastudiodev/?S_TACT=105AGX01&S_CMP=LP pureQuery download]
pureQuery is IBM's new, high-performance Java data access platform focused on simplifying, developing, securing, managing, and optimizing applications that access data. Java data access includes Java persistence and all data CRUD operations.
The benefits of using pureQuery extend throughout the design, development, deployment, management, and governance stages of the application life cycle.
pureQuery provides access to data in databases and in-memory Java objects via its tools, APIs, and runtime environment as delivered in [http://www.ibm.com/software/data/studio/developer/ IBM Data Studio Developer] and [http://www-306.ibm.com/software/data/studio/purequery/ IBM Data Studio pureQuery Runtime] .
Feature summary
pureQuery makes Java data access simple for agile development and improved application performance. pureQuery can be used both in standalone Java SE applications and in Java EE applications using servlets or EJB session beans. pureQuery can also be used to develop your data access for Web 2.0 applications. For example, pureQuery can return XML and JSON from a data source. IBM's Project Zero uses pureQuery for its [http://www.projectzero.org/wiki/bin/view/Documentation/CoreDevelopersGuideDataAccess data access] .
pureQuery includes an integrated Eclipse Java and query(SQL, SQL/XML, XQuery) editor that provides Java data access developers with an interactive software development environment.
pureQuery supports two programming styles: inline and method style.
In an annotated method pureQuery application, the SQL string is defined as an element of a [http://java.sun.com/javaee/technologies/index.jsp Java 5.0] , pureQuery Annotation, such as @Select, @Update and @Call. pureQuery tooling automatically generates an optimized implementation for the annotated method. The annotated method style is capable of supporting both static and dynamic execution of SQL.
In the inline style, SQL statements can be created “inline” within the code as a java String object. This dynamically generated statement is passed as a String parameter to the pureQuery Data interface method. The inline style was based on an early draft enhancement to the [http://java.sun.com/products/jdbc/download.html#corespec40 JDBC 4.0] specification, although it is not in the final JDBC 4.0 spec.
pureQuery Code Sample
Inline Style Example:
Data data = DataFactory.getData (datasource);// Insert an employee of type Employee bean in the databasedata.update("insert into EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDATE, SALARY, BONUS, COMM) values( :employeeNumber, :firstName, :midinit, :lastname, :workdept, :phoneno, :hiredate, :job, :edlevel, :sex, :birthdate, :salary, :bonus, :commision)", employee);
// Query the database for employeesIterator employees = data.queryIterator ("select * from EMPLOYEE", Employee.class);
// Query the database for one employeeIterator employee = data.queryFirst ("select * from EMPLOYEE where EMPNO = :employeeNumber", Employee.class, employees);
Annotated Method Style Example:// Annotate createEmployee method with sql to execute when method is invoked@Update(sql="insert into EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDATE, SALARY, BONUS, COMM) values( :employeeNumber, :firstName, :midinit, :lastname, :workdept, :phoneno, :hiredate, :job, :edlevel, :sex, :birthdate, :salary, :bonus, :commision)")int createEmployee(Employee e);
// Annotate getEmployees method with sql to execute when method is invoked@Select(sql="select EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDATE, SALARY, BONUS, COMM from EMPLOYEE")Employee getEmployees();
// Annotate getEmployee method with sql to execute when method is invoked@Select(sql="select EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDATE, SALARY, BONUS, COMM from EMPLOYEE where EMPNO = :employeeNumber")Employee getEmployee(Employee e);
Resources
Articles [http://www.db2mag.com/story/showArticle.jhtml?articleID=202400140 The Easy Way to Quick Data Access] [http://www.ibm.com/developerworks/db2/library/techarticle/dm-0709surange/ Overview of pureQuery tools, Part 1: Increase productivity in Java database development with new IBM pureQuery tools] [http://www.ibm.com/developerworks/db2/library/techarticle/dm-0709surange2/ Increase productivity in Java database development with new IBM pureQuery tools, Part 2: Detect and fix SQL problems inside Java program] [http://www.ibm.com/developerworks/edu/dm-dw-dm-0711surange-i.html?S_TACT=105AGX02&S_CMP=EDU Increase productivity in Java database development with new IBM pureQuery tools, Part 3: pureQuery rapid application development] [http://www.ibm.com/developerworks/web/library/wa-pz-wiki/?open&ca=dna-flht-01172008&S_TACT=106AH62W&S_CMP=NEWS Use Project Zero's data access APIs to build a simple wiki] [http://www.ibm.com/developerworks/db2/library/techarticle/dm-0804lamb/ Write high performance Java data access applications, Part 1: Introducing pureQuery annotated-method style] [http://www.ibm.com/developerworks/db2/library/techarticle/dm-0804vivek/ Write high performance Java data access applications, Part 2: Introducing pureQuery inline style ] [http://www.ibm.com/developerworks/db2/library/techarticle/dm-0808rodrigues/ Write high performance Java data access applications, Part 3: pureQuery best practices ]
pureQuery was developed by a team of Java software developers from IBM Information Management Software group.
The first pureQuery openBeta ended October 31, 2007. IBM Data Studio v1.1, which contains pureQuery, was released on 10-31-07. IBM Data Studio 1.1.1, including IBM Data Studio Developer and IBM Data Studio pureQuery Runtime were released December 12, 2007.IBM Data Studio 1.1.2 (or fixpack 2) was released March 28, 2008.IBM Data Studio Developer and IBM Data Studio pureQuery Runtime v1.2 were released on July 31, 2008. IBM Data Studio pureQuery Runtime for z/OS is expected to be available on August 29, 2008.
See also
* IBM Project Zero * Java Persistence API * openJPA * Hibernate (Java) * Spring Framework (Java) * iBATIS * Service Data Object * Language Integrated Query
IBM DB2 — Developer(s) IBM Initial release 1983 (1983) … Wikipedia
IBM Lotus Notes — Lotus Notes IBM Lotus Notes 8 default home screen Developer(s) IBM … Wikipedia
IBM — This article is about the technology company sometimes referred to as Big Blue . For other uses of these terms, see IBM (disambiguation) and Big Blue (disambiguation). International Business Machines Corporation Type Public … Wikipedia
IBM DeveloperWorks — developerWorks is a free web based professional network and technical resource center from IBM for software developers, IT professionals, and students worldwide. The site attracts 4 million unique visitors per month in 195 countries[1], and is… … Wikipedia
IBM Deep Thunder — Deep Thunder is a research project by IBM that aims to improve short term local weather forecasting through the use of high performance computing. It is part of IBM s Deep Computing initiative that also produced the Deep Blue chess computer. Deep … Wikipedia
Data access object — This article is about the data access object design pattern in object oriented software design. For the Microsoft library of the same name, see Data Access Objects. In computer software, a data access object (DAO) is an object that provides an… … Wikipedia
Watson (computer) — IBM Watson redirects here. For the laboratory, see Thomas J. Watson Research Center. Watson s avatar, inspired by the IBM smarter planet logo[1] Watson is an artificial intelligence computer system capable of answering questions posed in … Wikipedia
OS/2 — A typical OS/2 Warp 4 desktop Company / developer IBM Microsoft … Wikipedia
SQL — This article is about the database language. For the airport with IATA code SQL, see San Carlos Airport. SQL Paradigm(s) Multi paradigm Appeared in 1974 Designed by Donald D. Chamberlin Raymond F. Boyce Developer … Wikipedia
Develothon — Begins February March Ends April Frequency Annual Location(s) … Wikipedia
