DB programming seminar
BARS organized recently a DB programming seminar, which I was glad to attend. So let's get a brief summary of the event:
The first lecture was about MS SQL. My last project used MS SQL Server 2000 so the topic was pretty interesting to me. I learned quite a few things and got some good tips about file groups, indexes, application roles, temp tables and so on. The lecturer was very entertaining and included many good real-world examples to illustrate common shortcomings in developer's and admin's viewpoints.
The next lecture was about ontologies and natural language search. There you don't deal just with substrings, but with words. This area is very interesting and it has to do with ranking, inverted indexing and so on. It was interesting to get acquainted with what MySQL, MS SQL and Oracle offered and to hear about Lucene .NET API.
The Business Intelligence lecture was also pretty good. If you don't know abbreviations like BI, DW, DM, OLAP that was a chance to catch up. The cool demo with Excel pivot table revealed why MS Excel is the most popular (but probably not the best) BI tool on the market.
The final lecture was about Oracle Transaction Model and I was stunned about how little I knew about its details. There was talk about DML, DDL, DCL transaction, savepoints, locking, isolation levels, autonomous transaction and other cool stuff. And I was again reminded that, of course, each DBMS has its own understanding about a lot of semi-standardized stuff.