Qiao Han

Phone: +49 (821) 598 2153

Room: 2053 (Building N)

Email: timhanq @ hotmail.com

My Documents

weekly plan

==Week(44)

  • scrum meeting with Markus about the following theme:
    • integrate relative path of default PSQL Configure fileTicket 174
    • specification about Set Optimizer System Command
    • support for schema declaration in PSQL Statement
    • extend BNL2d about arbitrarily combination of LOWEST and HIGHEST
  • modification PSQL to integrate relative path of default config-file into PSQL

==Week(43)

  • implement reading default configure file with relative path
  • test implementation locally with successful result

==Week(42)

==Week(42)

  • find out the reason of empty ResultSet by Join(Ticket 197)
  • supports Konstantin by the Level-Function

==Week(41)

Week(40)

  • working on (Ticket 197)
  • find out following phanomenon with activated CostBasedOptimizer:
    • the first execution of query with join returns correct results
    • the next one returns just empty results

Week(39)

  • tracing the following SQL statement under Debug module with activated Optimizer and try to find out the reason for empty resultset:
    select * from info i, nodes_lite_plain n where n.id=i.node_id preferring lat, lon geoaround 48.333031, 10.897650

Week(38)

  • generates the tables Info and Nodes_Lite_Plain by Oracle and insert geodaten.( )
  • test the query with Oracle( )
  • fixes the bugs of "No Column Exception"( )

Week(37)

Week(36)

Week(33)

Week(32)

  • implements the score function for Between Preference(Ticket 165)

Week(31)

  • fixing the bug in PSQL-JDBC Driver(Ticket 166)(in Progress)
  • fixes the bug of HELP Command while Optimizer activated ist(Ticket 168)( )

Week(30)

  • fixes the bug caused by Token FILE_PATH while using SUM and Arithmetic operations in where clause
  • execute test cases to verify the new fix( )

Week(28 - 29)

Week(27)

  • implement PSQL independent interface for reading configure file :
  • implements interface for reading PSQL specific configure file:
    • PSQLConfigureReadaer( )
  • integrates the new implementation into PreferenceBase and PreferenceSQL( )

Week(26)

  • implement search of psqlConfigure.properties in project PreferenceSQL( )
  • integrates all the old configure files into psqlConfigure.properties( )
  • wiki-page for ConfigureReaderFactory?

Week(25)

  • implement Costbase Algorithm Selection and PARETO_ALGORITHM(Ticket 70)( )
  • implement ConfigureReaderFactory?( )
  • define configue file psqlConfigure.properties( )

Week(24)

  • implement an interface to set the configure file of optimizer in runtime(Ticket 174).

Week(22 -23)

  • implement a generic function to compute SCORE for all the Preferences

Week(21)

Week(20)

  • integrate the algorithm HexagonMultiLevelBMO and SemiParetoIntersection into PSQL( )

Week(19)

  • test GeoAround and fix some bugs that cause exception with some algorithms( )
  • write wiki page GeoAround( )

Week(17-18)

  • implementation of GeoAround
    • integrate GeoAround into Parser, TreeBuilder and SQLEngine( )
    • implementation of GeoAroundPreference and GeoAttributeSelector( )
    • port the Mercator Projection of [ proj4] into PSQL( )

Week (16)

  • prepare the implementation of Preference GeoAround
    • familiarize WGS84 coordinate and Mercator Projection( )
    • familiarize [ proj4]( )
    • design the implementation of GeoAround ( )

Week (15)

  • implementation the preference Quality( )

Week(14)

  • test algorithm Hexagon(Ticket 122) because of Exception NegativeArraySizeException( )
  • add JavaDoc(Ticket 133) for all the Classes in the following both packages:
    • PreferenceBase, preference.command()
    • PreferenceSQL, preference.sql.command()
  • Wiki Page for set optimizer ()

Week(13)

  • Wiki Page for set optimizer(in progress)
  • Find Bugs in PSQL(queuing)
  • Java Document for PSQLCmd (queuing)
  • Wiki for Set Command (queing)
  • set optimizer()
    • basic implementation () .
    • define configure files ()

Week(12)

  • set optimizer(in progress)
  • Find Bugs in PSQL(queuing)
  • Java Document for PSQLCmd (queuing)

Week(11)

  • erase Warnings of Timmi()
  • set optimizer(in progress)
  • Find Bugs in PSQL(queuing)
  • Java Document for PSQLCmd (queuing)

Week(10)

  • set algorithm()
  • set optimizer(queuing)
  • erase Warnings of Timmi(queuing)
  • Find Bugs in PSQL(queuing)
  • Java Document for PSQLCmd (queuing)

Week(9)

  • set algorithm(in progress)
  • set optimizer(queuing)
  • erase Warnings of Timmi(queuing)
  • Find Bugs in PSQL(queuing)
  • Java Document for PSQLCmd (queuing)

Week(8)

  • check correctness of new HELP Schema()
  • set display order of HELP Info to lexical order()

Week(4 -- 7)

  • in Vacation

Week(3)

  • fix all warnings of Timmi
  • implements help commands for debug,optimizer,if the time allows

Week(2)

  • add new help schema into preference help:
    • MoreThan Preference
    • LessThan Preference
    • Extremal Preference:
    • MAX
    • MIN
    • !OntoPOS Preference
    • !ContainsPOS Preference
    • ontoContains Preference
    • AntiChain Preference
    • DisjointUnion Preference
    • CutoffSV Preference

Week(51 -- 52)

  • add some new informations into the preference help

Week(47 --50)

  • familiarize the following themen:
    • java plugin javaCC
    • PreferenceParser
  • erase the semicolon around help schema

Week(45 -- 46)

  • merge zero-warning-version into Head-version()
  • test pareto-preference for zero-warning-version()

Week(44)

  • testing PSQL without Warnings--(in progress)
  • Merge new Version with HEAD-version--(queuing)

Week(43)

  • Erasing Warnings of the Projects--()
    • RecommenderFramework
    • PreferenceRepository
    • PreferenceMiner
    • testing PSQL without Warnings--(queuing)
  • Merge new Version with HEAD-version--(queuing)

Week(42)

  • Handeling the following Warnings in PSQL for Java 1.6,
    • Class is a raw type. References to generic type Class<T> should be parameterized

Woche(41)

  • Eliminating Warnings about Generic Type in PSQL für Java 1.6

Attachments