Difference between revisions of "My Applied Research Log"
(→January - March 2012) |
(→January - March 2012) |
||
Line 8: | Line 8: | ||
* contributions to the PostgreSQL open source community (NexJ PostgreSQL Adapter) | * contributions to the PostgreSQL open source community (NexJ PostgreSQL Adapter) | ||
*February | *February | ||
− | ** identification of '''research problems''' solved | + | ** identification of '''research problems''' being solved |
*** NexJ extension of SQLite to supprot full text search [http://www.sqlite.org/fts3.html#appendix_a] | *** NexJ extension of SQLite to supprot full text search [http://www.sqlite.org/fts3.html#appendix_a] | ||
− | ** identification of '''inter-related''' | + | *** the full text search problem |
+ | **** Search with InnoDB By Bertrand Matthelié (Oracle's MySQL Blog, Nov 09, 2011) [https://blogs.oracle.com/MySQL/entry/full_text_search_with_innodbFull-Text] | ||
+ | **** Natural Language Full-Text Searches (MySQL) [http://dev.mysql.com/doc/refman/5.0/en/fulltext-natural-language.html] | ||
+ | **** Is Full Text search the answer? (stackoverflow 2009) [http://stackoverflow.com/questions/614358/is-full-text-search-the-answer] | ||
+ | ** identification of '''inter-related issues''' (code repository) | ||
*** 75, 76, 79, 78 (open issues) | *** 75, 76, 79, 78 (open issues) | ||
*** 65, 64, 61, 60, 59, 49 (resolved issues) | *** 65, 64, 61, 60, 59, 49 (resolved issues) |
Revision as of 10:05, 25 February 2012
Contents
Common Problems and Solutions
NexJ-CDOT Knowledge Base
January - March 2012
- continuous construction of the NEXJ-CDOT knowledge base
- contributions to the SQLite open source community (NexJ SQLite Adapter)
- contributions to the PostgreSQL open source community (NexJ PostgreSQL Adapter)
- February
- identification of research problems being solved
- identification of inter-related issues (code repository)
- 75, 76, 79, 78 (open issues)
- 65, 64, 61, 60, 59, 49 (resolved issues)
- NexJ extension of SQLite to suppport the analytical function rank?
- 1
- code inspection
- installation of NexJ Studio Express 8.0 with Eclipse SDK 3.7.1
- problems encountered
- solution: Use Eclipse SDK 3.7 (instead of 3.7.1) [5] [6] [7] [8]
- January
- code inspection (reverse engineering)
- 20 Dec. 2011, 21 Dec. 2011, 4 January, 5 January, 10 January, 12 January
- code inspection (reverse engineering)
September - December 2011
- November
- team meetings on Mondays
- WebEx meetings with NexJ (11/11, 11/18, 11/25)
- continuous construction of the NexJ-CDOT knowledge base
- October
- team meetings on Mondays
- Quality Assurance
- checked out the source code of the SQLite Adapter
- upgrade problems encountered
- Search for an application to demonstrate the usefulness of the CDOT projects related to the NexJ Express server [9]
- Research Reading
- Scrum in Action: Agile Software Project Management and Development by Andrew Pham and Phuong-Van Pham (Cengage Learning, 2012).
- A practical guide to distributed Scrum by Elizabeth Woodward, Steffan Surdek, Matthew Ganis (IBM Press, 2010).
- September
- team meetings at CDOT
- MTOM project meeting at NexJ Systems scheduled on 9/23
- Read the MTOM (SOAP Message Transmission Optimization Mechanism) specification. [10]
- Project Change: MTOM to SQLite Adapter (9/16).
- SQLite Adapter project meeting at NexJ Systems (9/23)
- Research Reading
- Continue with the Knowledge Base project (initiated in July 2011).
- data analysis of the interview with Brian Lim
July - August 2011
- Applied Research Notes (July-August 2011)
- Research Tasks
- Inspect the code base of NexJ Express
- the Persistence engine
- the Integration engine
- the tree optimization problem (JSON Integration Adapter)
- Inspect the code base of NexJ Express
- Events
- 7/10/2011 I checked out the code base (revision 540) of NexJ Express from OHT with MercurialEclipse. JAVA_HOME must be set to JDK 1.5, not 1.6. The revised version "Working with NexJ Express Source Code" (2011-3-15) must be used.
- 7/25/2011 Regarding the JSON Integration Adapter project, I checked out the code base from Brian Lim's mercurial code repository. I ran two JUnit tests and one of them had caused some errors. Later the problem was fixed by Brian.
- team meetings
June 9, 2011
- The 1st NexJ Academic Research User Group Meeting [13]
January - April 2011
Week 1/January 2011
1/12/2011 (Wed)
- NexJ project team meeting
1/15/2011 (Sat)
Week 2
1/18/2011 (Tue)
1/19/2011 (Wed)
- NexJ project team meeting
- The PostgreSQLAdapter project must be completed by March 31, 2011.
- New projects will be proposed to NexJ for approval.
- Research Notes on the SQLSchemaManager class
1/20/2011 (TH)
- NexJ Coding Standards received from Grace
- Checkd out the code base of the PostgreSQLAdapter project from the mercurial repository
- build errors encountered
Week 3
1/24/2011 (Mon)
- ran the JUnit test PostgreSQLSchemaManagerTest on my laptop (vs the CDOT desktop)
- errors encountered
1/25/2011 (Tue)
1/26/2011 (Wed)
- NexJ team meeting
- error encounterd in running PostgreSQLSchemaManagerTest
- system path error encountered
- solution was offered by Grace
1/27/2011 (Friday)
- met with Grace to understand how he has used JUnit tests to guide his research and coding process
Week 4
2/09/2011 (Mon)
- met with Jordan and Dawn to discuss about two projects that have been approved by NexJ
2/11/2011 (Wed)
- checked out Revision 28 from the code repository, ran PostgreSQLSchemaMangerTest and PostgreSQLAdapterTest
- uploaded the JUnit testing results (the current status of the project)
- reviewed NexJ Developer's Guide (coding standard)
Week 5/February
2/07/2011 (Mon)
- posted the summary of JUnit errors on PostgreSQLAdatperTest
2/09/2011 (Wed)
- posted Grouping of methods to be implemented 2/09/2011
- team meeting
- look into jQuery, Scheme (Racket?), Goolge Web Toolkit (GWT)
- work with Tung
Week 6
2/16/2011 (Wed)
- code review of PostgreSQLSchemaManager: 1st iteration
- team meeting
- work with Tung: his timeline
- investigate testRead in PostgreSQLAdapterTest
at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455) at $Proxy2.setString(Unknown Source) at nexj.core.rpc.sql.ra.SQLManagedConnection$SQLPreparedStatement.setString(SQLManagedConnection.java:1689) at nexj.core.persistence.sql.SQLAdapter$1.setValue(SQLAdapter.java:105) at nexj.core.persistence.sql.SQLCursor.query(SQLCursor.java:159) ... 26 more
- action: postgresql source code received from Grace
2/17/2011 (Th)
- revision 39 was pulled
- testRead has a different failure trace (problem with serialized representation of readCollectionWhere.xml)
Test object does not match the serialized representation at "file:/C:/workspace3.5/jan222011/core/bin/nexj/core/persistence/sql/data/readCollectionWhere.xml" at junit.framework.Assert.fail(Assert.java:47)
- Vogella's tutorial on GWT [14]
Week 7
2/23/2011 (Wed)
- code review of PostgreSQLSchemaManager (revision 45) : 2nd iteration
- team meeting
- work with Tung: a list of problems encountered
Week 9/March
3/08/2011 (Tue)
- 2 JUnit errors encountered on running revision 76 on my laptop
3/09/2011 (Wed)
- team meeting
- meet with Tung to understand his deployment problems
- draft Applied Research Summary on the PostgreSQLAdapter project
Week 10
3/16/2011 (Wed)
- team meeting
3/18/2011
- downloaded NexJ Studio Express (v 7.1) from Open Health Tools and tried to install it on my laptop
Week 11
3/23/2011 (Wed)
- team meeting
- solving the problems of installing NexJ Studio Express (v 7.1) on my laptop
- mentoring Tung on creating a GWT application, based on Grace's sample application
3/26/2011 (Sat)
- released Applied Research Findings [15]
Week 12/April
- April 13 - student presentations for OCE Connections
- April 20 - project-end meeting with NexJ and Ontario Centres of Excellence (OCE)
- Tung delivered visual guides and videos.[16]
- Tung delivered the GWT application.