Undergraduate Capstone Open Source Projects

Posts Tagged ‘Ingres’

Ingres/Geotools Lim’s Midway Update

Posted by clgoh on 2010/02/23

The Ingres/Geotools team finally began work on actual implementation of classes and unit tests for the classes in Geotools at this halfway point. I personally feel that we are falling a little bit behind schedule, not beyond managable. We took our time in the initial phase afraid of making mistakes that compromises the quality of the output. The Ingres/Geotools team has have a lot to explore in the geospatial world as a toddler would have the world.

We already defined a very clear goal since the beginning and based on that, we finally setup in our plan, Looking at the size of the project in the beginning it seems reasonable, even at this point when we have detailed action items, I believe we are on the right track and its possible to see the project through its completion. However measuring against that, implies that we need to catch up on the actual implementation as we have got a lot to grind through. I personally do not think the effort spent in the first half of the term is wasteful, it just means we have a limited time left to execute the plan, a plan now much clearer than it would have been should we not have communicated and spent time understanding the concepts.

We are already learning at this point through the challenges and lack of information we have faced, that is how the real industry works, no matter how our courses have been like. We will continue to face these challenges but we learnt to be ready for it, and we could catch up by wasting no time trying and asking.

Posted in Ingres, Status, Uncategorized | Tagged: , | 1 Comment »

Eva’s midway update

Posted by iwawong on 2010/02/21

This is my second semester joining the UCOSP with Ingres. From the lessons that I have learnt last term, I have planned my schedule out at the start from reading off the requirements of this semester and so far I am sticking to it quite well. I have completed half of the required patches.

Not only I found myself matured in how to co-operate with people working oversea, but also in self-monitoring. At this point, I am quite accurate about the estimate that I am making to myself, especially on my speed of work.

Posted in Status | Tagged: , , , , , | 1 Comment »

Geotools Status Report

Posted by clgoh on 2010/02/09

The Geotools team had been working on mostly getting oriented to Geospatial concepts, determining action items, etc.

We are now ready to create a new unsupported jdbc-ingres module into Geotools. In the coming weeks, you will see rapid additions of new code in the Geotools source.

Posted in Ingres, Status | Tagged: , | Leave a Comment »

“What we learnt” + “Where we’ll go”

Posted by clgoh on 2010/01/19

The day before the sprint, I knew of nothing about what I should do and what I can do in this project. I woke up at 5 on Friday morning, took a taxi to the bus terminal, got onto Greyhound to Toronto, got lost on our way to Bahen Centre (we were on University and College, 5 minutes away from Bahen, lol)  To my surprise, I arrived, and joined a team of people as lost as I was. We found out throughout the sprint, many differences between universities, the courses, the cultures, etc. But all of us being in our last year, I believe there’s one thing in common that we’ve learnt before we get there: Well, no one’s going to help us if we don’t start helping ourselves. Before long, the whole team started the sprint ourselves. We asked lots and lots of questions (Thank you very much Andrew for your detailed presentation and all your help even by having to whisper), we read wiki pages, downloaded source code and snorkeled in it. No one sat still waiting for an answer, there was no awkward silent moment as the team of “professionals” blended from the very first day and moved forward as one. The three days went by very quickly.

We learnt the following during the sprint:

– OpenLayers draws map using Web Mapping Service provided by Geoserver, which in turns uses Geotools to obtain GeoSpatial Data from databases. Geotools can currently talk to many databases but not Ingres.

– In Geotools there are connectivity code under modules/plugin/jdbc and modules/plugin that uses various jdbc implementations to connect to various databases. There is also a deprecated version of the framework scheduled to be removed soon. Ingres team needs to make a similar jdbc implementation under Geotools to add support for Ingres.

– Sara and Eva will be working on the Ingres server side to make sure GeoSpatial queries are handled properly, while Anthony, Henry, Xiaoxiao and Lim work on Geotools to add Ingres support.

We decided the following during the sprint:

The project lead will communicate with the team and with the community at large to keep everyone informed about the status of the team, and make sure the team is moving in the right direction. Lim will take on this role.

The high-level view of the project is:

– Study the code and play with Geotools in action

– Design and plan potential changes to Geotools source tree

– Implement the designs and also implement support for GeoSpatial data in Ingres

– Unit test the Ingres connectivity code in Geotools, test GeoSpatial data support in Ingres, and system test Geotools actually using Ingres.

Now everyone’s back to where they are from, but technology is constantly connecting us together. We are all a phone call/email/IM message away from each other, and we are preparing for the next get-together online every Monday with more progress to make.

Posted in Ingres, Sprint | Tagged: , , | Leave a Comment »

Anthony McCallum

Posted by Anthony on 2009/12/28

Hi, I’m Anthony McCallum.  I’m in my final year of a computer science degree at the University of British Columbia. My language of choice is JAVA, but I also have experience with a variety of other languages.  I will be working on the Ingres project this coming term.  This will be my first opportunity to work on an open source project, and I am excited for the challenge!  I’ve previously done internships with RIM in Ottawa as well as a bioninformatics lab in Singapore.  I am also currently working part time for a UBC affiliated lab.  Looking forward to meeting everyone at the code sprint!

Posted in Bios, Ingres | Tagged: , , , | Leave a Comment »

Screencast of showing building of Geospatial with GEOS as non root user on Linux

Posted by iwawong on 2009/12/12

The following tutorial video is done with GEOS 3.2.0, compiled in gcc 4.3 and g++ 4.3 depending on Xerces C headers and libraries 2.8, pam-devel, pax, jam, on a Debian server as a non root user.

For more details, please visit: http://i-wa.blogspot.com

Posted in Ingres, Screencast | Tagged: , , , , , | Leave a Comment »

What went right, wrong this year

Posted by djkelvin on 2009/11/24

Thumbs up: Sponsors, I liked the fact that we were able to get further acquainted with  large businesses in the computer science field such as Ingres, Tucows, Yahoo, and Rogers Communication. I also agree with Greg’s point, and it was a good learning experience to work on projects in a different setting and environment.

Thumbs down: Though this may have  been expensive, I would’ve liked to have a UCOSP meeting like the initial sprint at the end of this experience to wrap up the project. I think this would also be helpful to gauge experiences and follow-up on progress and accomplishments of other teams. Writing about it is good but I think just as in the sprint, face to face communication is essential

Posted in Uncategorized | Tagged: , | 2 Comments »

Eva Wong

Posted by iwawong on 2009/09/04

Eva Wong

Here is a ‘hello’ from Eva Wong for all the UCOSP buddies! I will be working with Ingres under Andrew Ross for this coming fall.

I’m a fourth year computer science undergraduate student at University of Toronto, specializing in information system. I’m also doing a mathematics minor. For the previous summers in between school years, other than biking, I have been working on the GIS that I found with my team, Geokudo(2009), also I have completed a data visualization tool as a GSoC project(2008) for HackyStat.

I’m really looking forward to the start of this class, and I will be treasuring this experience. Hope to see you all at Code Sprint!

Posted in Bios, Ingres | Tagged: , , , , , , , , | Leave a Comment »