Revision as of 19:32, 22 May 2012 edit Mblumber (talk \| contribs) Extended confirmed users, Pending changes reviewers 8,605 edits Disambiguated: standalone software → Computer software ← Previous edit		Revision as of 08:58, 3 April 2013 edit undo Frap (talk \| contribs) Extended confirmed users, File movers, Pending changes reviewers, Rollbackers 35,592 edits No edit summary Next edit →
Line 13: [http://www.ibm.com/developerworks/downloads/im/datastudiodev/?S_TACT=105AGX01&S_CMP=LP pureQuery download] }} ==History==▼ 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 was released on August 29, 2008. ▼ IBM Data Studio Developer 2.1 and IBM Data Studio pureQuery Runtime 2.1 (for Linux, UNIX, and Windows) were released on December 19, 2008. ▼ IBM Optim Development Studio 2.2 and IBM Optim pureQuery Runtime 2.2 (for Linux, ~~UNIX~~Unix and Windows) were released on June 18, 2009. pureQuery was renamed from Data Studio pureQuery to Optim pureQuery at the 2.2 release. IBM Data Studio Developer was also renamed to IBM Optim Development Studio at the 2.2 release.▼ '''pureQuery''' is [[IBM]]'s, high-performance data access [[platform (computing)\|platform]] focused on simplifying, developing, securing, managing, and optimizing new and existing applications that access data. Data access includes the [[persistence (computer science)\|persistence]] of the data encapsulated in [[Object (computer science)\|objects]] and all data [[Create, read, update and delete\|CRUD]] operations. pureQuery supports both [[Java platform\|Java]] and [[.NET Framework\|.NET]]. The benefits of using pureQuery extend throughout the [[Database design\|design]], [[software development\|development]], [[software deployment\|deployment]], [[management]], and [[Information technology governance\|governance]] stages of the application [[software life cycle\|life cycle]]. Line 24 ⟶ 33: pureQuery makes Java data access simple for [[Agile software development\|agile]] development and improved application performance. pureQuery can be used both in [[Computer software\|standalone]] [[Java Platform, Standard Edition\|Java SE]] applications and in [[Java EE]] applications using [[Java Servlet\|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]. Optim Development Studio provides the development tools for pureQuery. It includes an integrated [[Eclipse (software)\|Eclipse]] Java and query([[SQL]], [[SQL/XML]], [[XQuery]]) editor that provides Java data access developers with an interactive software development environment. This provides query content assist within the Java editor in Eclipse. pureQuery supports two programming styles: inline and method style. Line 72 ⟶ 81: ==pureQuery client optimization == #Capture the SQL #Use pureQuery API, generate from WebSphere JPA, or capture while executing #Use with custom-developed, framework-based, or packaged applications #Bind SQL to DB2 Line 81 ⟶ 90: ==.NET support== .NET support was added in the pureQuery 2.1 release. It currently has support of the pureQuery Client optimization feature which allows dynamic SQL execution .NET programs to be converted to static SQL execution. ==Resources==▼ '''Articles'''<br />▼ [http://www.dbmag.intelligententerprise.com/showArticle.jhtml?articleID=202400140 The Easy Way to Quick Data Access] <br/>▼ [http://www.devx.com/DevX/Article/40240 Smoothly Blending Java and SQL with pureQuery] <br/>▼ [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]<br />▼ [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] <br/>▼ [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] <br/>▼ [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] <br/>▼ [http://www.ibm.com/developerworks/db2/library/techarticle/dm-0804lamb/ Write high performance Java data access applications, Part 1: Introducing pureQuery annotated-method style]<br />▼ [http://www.ibm.com/developerworks/db2/library/techarticle/dm-0804vivek/ Write high performance Java data access applications, Part 2: Introducing pureQuery inline style ]<br />▼ [http://www.ibm.com/developerworks/db2/library/techarticle/dm-0808rodrigues/ Write high performance Java data access applications, Part 3: pureQuery best practices ]<br />▼ [http://www.ibm.com/developerworks/data/tutorials/dm-0903optimizenet/ Optimize your existing .NET applications using IBM Data Studio's pureQuery]<br />▼ [http://www.ibm.com/developerworks/data/library/techarticle/dm-0906optimdeveloper/index.html What's new and cool in Optim Development Studio 2.2]▼ '''Download pureQuery''' <br />▼ http://www.ibm.com/developerworks/downloads/im/datastudiodev/?S_TACT=105AGX01&S_CMP=LP <br />▼ '''pureQuery Forum (aka newsgroup)''' <br />▼ http://www.ibm.com/developerworks/forums/dw_forum.jsp?forum=1086&cat=19 <br />▼ http://www.iiug.org/forums/datastudio/ <br/>▼ '''pureQuery Documentation''' <br />▼ http://publib.boulder.ibm.com/infocenter/idm/v2r2/index.jsp?topic=/com.ibm.datatools.javatool.runtime.overview.doc/topics/helpindex_pq_sdf.html <br/>▼ '''Using the pureQuery API documentation''' <br />▼ http://publib.boulder.ibm.com/infocenter/idm/v2r2/index.jsp?topic=/com.ibm.datatools.javatool.runtime.doc/topics/cpdqrunusepqapi.html <br/>▼ '''pureQuery Javadocs'''<br/>▼ http://publib.boulder.ibm.com/infocenter/idm/v2r2/index.jsp?topic=/com.ibm.datatools.javatool.runtime.doc/topics/javadoc/overview-summary.html<br/>▼ System Requirements <br/>▼ http://www-01.ibm.com/support/docview.wss?rs=4015&uid=swg27015712 <br/>▼ ~~FAQ <br/>~~ http://www-01.ibm.com/software/data/optim/purequery-platform/faq.html ▼ ▲==History== ▲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 was released on August 29, 2008. ▲IBM Data Studio Developer 2.1 and IBM Data Studio pureQuery Runtime 2.1 (for Linux, UNIX, and Windows) were released on December 19, 2008. ▲IBM Optim Development Studio 2.2 and IBM Optim pureQuery Runtime 2.2 (for Linux, UNIX and Windows) were released on June 18, 2009. pureQuery was renamed from Data Studio pureQuery to Optim pureQuery at the 2.2 release. IBM Data Studio Developer was also renamed to IBM Optim Development Studio at the 2.2 release. == See also == {{Portal\|Java}} * IBM [[Project Zero]] * [[Java Persistence API]] Line 135 ⟶ 104: * [[Language Integrated Query]] * [[IBM WebSphere eXtreme Scale]] ▲==Resources== ▲'''Articles'''<br /> ▲* [http://www.dbmag.intelligententerprise.com/showArticle.jhtml?articleID=202400140 The Easy Way to Quick Data Access] ~~<br/>~~ ▲* [http://www.devx.com/DevX/Article/40240 Smoothly Blending Java and SQL with pureQuery] ~~<br/>~~ ▲* [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]~~<br />~~ ▲* [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] ~~<br/>~~ ▲* [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] ~~<br/>~~ ▲* [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] ~~<br/>~~ ▲* [http://www.ibm.com/developerworks/db2/library/techarticle/dm-0804lamb/ Write high performance Java data access applications, Part 1: Introducing pureQuery annotated-method style]~~<br />~~ ▲* [http://www.ibm.com/developerworks/db2/library/techarticle/dm-0804vivek/ Write high performance Java data access applications, Part 2: Introducing pureQuery inline style ]~~<br />~~ ▲* [http://www.ibm.com/developerworks/db2/library/techarticle/dm-0808rodrigues/ Write high performance Java data access applications, Part 3: pureQuery best practices ]~~<br />~~ ▲* [http://www.ibm.com/developerworks/data/tutorials/dm-0903optimizenet/ Optimize your existing .NET applications using IBM Data Studio's pureQuery]~~<br />~~ ▲* [http://www.ibm.com/developerworks/data/library/techarticle/dm-0906optimdeveloper/index.html What's new and cool in Optim Development Studio 2.2] ▲'''Download pureQuery''' ~~<br />~~ ▲* http://www.ibm.com/developerworks/downloads/im/datastudiodev/?S_TACT=105AGX01&S_CMP=LP ~~<br />~~ ▲'''pureQuery Forum (aka newsgroup)''' ~~<br />~~ ▲* http://www.ibm.com/developerworks/forums/dw_forum.jsp?forum=1086&cat=19 ~~<br />~~ ▲* http://www.iiug.org/forums/datastudio/ ~~<br/>~~ ▲'''pureQuery Documentation''' ~~<br />~~ ▲* http://publib.boulder.ibm.com/infocenter/idm/v2r2/index.jsp?topic=/com.ibm.datatools.javatool.runtime.overview.doc/topics/helpindex_pq_sdf.html ~~<br/>~~ ▲'''Using the pureQuery API documentation''' <br /> ▲* http://publib.boulder.ibm.com/infocenter/idm/v2r2/index.jsp?topic=/com.ibm.datatools.javatool.runtime.doc/topics/cpdqrunusepqapi.html ~~<br/>~~ ▲'''pureQuery Javadocs'''~~<br/>~~ ▲* http://publib.boulder.ibm.com/infocenter/idm/v2r2/index.jsp?topic=/com.ibm.datatools.javatool.runtime.doc/topics/javadoc/overview-summary.html~~<br/>~~ ▲System Requirements ~~<br/>~~ ▲* http://www-01.ibm.com/support/docview.wss?rs=4015&uid=swg27015712 ~~<br/>~~ FAQ ▲* http://www-01.ibm.com/software/data/optim/purequery-platform/faq.html {{IBM DB2 product family}}

IBM PureQuery: Difference between revisions