me

Hallo allerseits !

Ich heisse Konstantin Eberle (KE), und bin seit 2007 dabei.
Ich bin Physik Dipl. Student im 11 Semester, und nebenbei HiWi hier. Mit dem Ende meines Studiums im November 2010 habe ich meine Arbeit hier beendet.

contact:
icq:	312858703
mail:	konstantin.eberle@…
Raum:	2053
tel 2153	(HiWi-Raum)

---

• Angefangen habe ich mit einfachen Implementierungen:
  • Summe im WHERE-Teil

    SELECT * FROM R WHERE a+b<10 
    

  • Summe im SELECT-Teil

    SELECT a+b FROM S 
    

• dieses erforderte erst das Erlernen von JavaCC, und Einarbeiten in das Preference SQL selbsverständlich. Das Vorgehen war dabei:
  • Parser anpassen.
  • Callback Funktionen erstellen.
  • Zuständige Klassen.

Weitere Implementierungen im Preference SQL code folgten.

• Ausserdem:
  • TRADE OFF Preference mit Sven Döring
  • Flughafen Finder (FA Komponente) - HTML Frontend
  • "Nährwertrechner" [andere Namensvorschläge willkommen] mit Markus.

---

Wiki pages by me:

webservice (100%)
Nutrcalc_Webservice (~99% i will continue working on it)
Preference SQL

Preference Base UML:

• png 3000*2000 1,09mb
• jpg 10500*7000 1,15mb

Preference SQL UML:

• png 3000*2000 1,43mb
• png 5000*3333 3,43mb
• jpg 10500*7000 1,6mb

---

at all: please go to  http://137.250.169.101/nutrcalc , and put some entries into. send me feedback

next week

• "The same thing we do every night, Pinky — try to take over the world!"

  (43)

(42)

---

Wochenweise

Last Week

• migrating webservice to ursaminor

Week 42

• find bug about closed connection -> reassign to someone else
• working on (Ticket 12) -> the level distance classes etc. are there. i get an exception by a not initialized SQLAttributeSelector.
• AUAHAJA --> Tomcat WIki says: "Tomcat is not an EJB server. Tomcat is not a full J2EE server."

Week 41

• created a "config" place in nutrcalc-code, so i need to set connection only once
• praparing php-code (nutrcalc) for working on the oracle connection
  nutrcalc works on both now: mysql & oracle
  • installing oracle instant client for php_oci8 extention

Week 40

• run nutrcalc on server (ursaminor)

Week 39

• Sion

Week 38

• Migrated mySQL database to oracle
• done some tests, still getting exception about closed connection

Week 34 - 37

• holiday

Week 30 - 33

• optimizing nutrcalc

Week 29

• use hexagon, less, bnl, skyline snippets

Week 28

• create a valuation class, to check performance of nutrcalc queries on different optimizer algorithms

Week 27

• Write a short owerview for Preference SQL syntax
  see Preference SQL

Week 18 - 26

• get sum working with optimization

  +-------------+--------------+-------------+--------------+-----------------+------------------+-----------------------------------------------------------------+-----------------------------------------------------------------------+
  | SOUP.NDB_NO | SOUP.EN_DESC | FISH.NDB_NO | FISH.EN_DESC | DESSERTS.NDB_NO | DESSERTS.EN_DESC | ((SOUP.ENERG_KCAL) + (FISH.ENERG_KCAL)) + (DESSERTS.ENERG_KCAL) | ((SOUP.CARBOHYDRT_G) + (FISH.CARBOHYDRT_G)) + (DESSERTS.CARBOHYDRT_G) |
  +-------------+--------------+-------------+--------------+-----------------+------------------+-----------------------------------------------------------------+-----------------------------------------------------------------------+
  | 6077        | beef soup    | 15018       | cod          | 19084           | candies          | 1190.0                                                          | 95.55                                                                 |
  | 6974        | vegetable so | 15018       | cod          | 19084           | candies          | 929.0                                                           | 55.669999999999995                                                    |
  | 6074        | vegetable so | 15047       | mackerel     | 19084           | candies          | 1202.0                                                          | 104.63                                                                |
  | 6074        | vegetable so | 15018       | cod          | 19268           | candies          | 1200.0                                                          | 117.67                                                                |
  | 6074        | vegetable so | 15119       | tuna         | 19084           | candies          | 1138.0                                                          | 104.63                                                                |
  +-------------+--------------+-------------+--------------+-----------------+------------------+-----------------------------------------------------------------+-----------------------------------------------------------------------+
  

• cleaning code, write comments
• create webservice jar

Week 17

• get sum working with optimazation
• Projection.java: toStringOld() needs a null check

  if (m_opChild != null) strProject.append(m_opChild.toString());
  else  strProject.append(" m_opChild is null ");
  

  • working , then you cann see outputs like:

    Nach der Optimierung: 
    Project[T.ID AS 'ID',(T.ID) + (T2.ID) AS '(ID) + (ID)'](PreferenceSelection  : T.ID in ('Second Test with DB') regular
    Sigma[(T.ID) + (T2.ID)<36.0](  CartesianProduct: (JoinExpression: *)
        Relation: TEST as T
        Relation: TEST2 as T2))
    

Week 16

• using cbo
• using MySQLDatabaseConnentor
• without optimization sum in projection works also

Week 15

• check in to my branch

Week 9-14

• check out new code
• bugfixing
• add sum expression Yeah! it's working!!!

Week 8

• 1
  • reduce attributes in nutrcacl database
  • reduce tuples in nutrcalc database --> down to max 2.874.690.000 tuples
• 2
  • add regular expression
  • use d parameter on numeric preferences

Week 7

• work out an overview over supported and unsupported sql 92 standard definitions in preferencesql

Week 6

• SQL92 Standard:
  • INSERT INTO ... SELECT ... PREFERRING
  • MAX/MIN/AVG/SUM
  • ORDER BY/GROUP BY
  • etc.

Week 5

• (working on tickets)

Week 4

• Bitte PSQL-Query am Ende hinzufügen
• Hexagon verwenden
• kleinere Diagramme fürs Wiki
• vegetables -> side dish

Week 3

• testing nutrcalc
• completition/handover "nutrcalc"

Week 2

• Notices/Warnings in php-code
• completion "nutrcalc" availiable at  http://137.250.169.101/nutrcalc

Week 1

• ?

---

Happy New Year

---

Week 51-52

• PreferenceBase & PreferenceSQL Diagrams complete

Week 49-50

• working on ticket #52
• i'm finally up to date. trunk checked out

Week 48

• Cold survived

Week 46-47

• exams successful passed

Week 45

• get familiar with SVN (check out) ---> (also installed Mylyn plugin: pretty useful thing :) )
• got more Notices/Warnings in php-code :( , going to eliminate them
• work out a few ideas to make "nutrient calculator" more usable (still need a new name ;) )
• complete Nutrcalc_Webservice (100% )

Week 44

• webservice - 100%
• cut_off optimizer: integrated a StaticClassLoader?; runs on glassfish

Week 43

• still optimizing optimizer ... *arghgr -> try to use static optimizer classes
• eliminate warnings/notices in my php code, some undefined variables etc.
• Docu / tutorial for Webservice

Week 42

• Wiki page
• have a look at trac
• integrate cut_off optimizer
• "Nährwertrechner" translating

Umzug -> Woche 41

• System aufsetzen
• IDEs, Server, Apps lauffähig
• Code auschecken, simple Fehlerbeseitigung
• Unterbringen sämtlicher Anwendungen unter einer IDE (Eclipse)

---