Archive for August, 2009

SQLite Database Management Tool »

SQLite2009 Pro Enterprise Manager is a freeware tool that enables you to manage your SQLite3 databases. Features: Blob/Image viewer Built-in FTS3 Extention Built-in LUA Programming Language Encrypted database support Export recordset into excel, csv, xml and html format Import data from Ms Access / MS SQL server Includes SQLite2009 Pro ODBC Driver Includes Additional sqlite3 [...]

Open Source ADO.NET Provider for SQLite Database Engine »

System.Data.SQLite is the original SQLite database engine and a complete ADO.NET 2.0/3.5 provider all rolled into a single mixed mode assembly.  It is a complete drop-in replacement for the original sqlite3.dll. The provider was written from scratch on VS2005/2008 specifically for ADO.NET 2.0, using all the most recent changes to the ADO.NET framework.  That includes [...]

Oracle: Using ADDM »

The Automatic Database Diagnostic Monitor ( ADDM ) is an advisor which detects problem area’ s in the database and and which gives recommendations. ADDM uses the statistical data from the AWR – Automatic Workload Repository – stored in the sysaux tablespace. By default the statistical data is gathered / written to disk by snapshots [...]

Oracle: Verify PGA and SGA »

For current PGA size of each session, use: SELECT s.sid,, s.value FROM v$sesstat s, v$statname nWHERE s.statistic# = n.statistic#AND = ‘session pga memory’; For maximum PGA size each session has reached so far, use: SELECT s.sid,, s.value FROM v$sesstat s, v$statname nWHERE s.statistic# = n.statistic#AND = ‘session pga memory max’;

Java: Generate RDF from Web Pages »

WebCAT is an extensible tool to extract meta-data and generate RDF descriptions from existing Web documents. Implemented in Java, it provides a set of APIs (Application Programming Interfaces) that allow one to analyse text documents from the Web without having to write complicated parsers. Among other things, WebCAT provides:   – Language and encoding detection.  [...]

N-Gram Analysis with TCatNG »

The TCatNG Toolkit is a Java package that you can use to apply N-Gram analysis techniques to the process of categorizing text files. N-Grams are short sequences of bytes or letters, and their statistics provide valuable informations about byte sequences and strings. N-Gram based approaches are very powerful in text categorization because every string is [...]

Oracle Performance: DFS Lock Handle and Oracle Sequence »

If you are using Oracle sequences very frequently in a RAC environment, most often you will see that one of the most timed events is “DFS Lock Handle”. Commonly you should set the sequence to have a larger cache size and with the NOORDER option, which is the default, for best performance. Performance of combined [...]

Oracle: Detect Server Uptime »

1: SELECT to_char(startup_time,’DD-MON-YYYY HH24:MI:SS’) “DB Startup Time” 2: FROM sys.v_$instance; 1: select 2: ‘Hostname : ‘ || host_name 3: ,’Instance Name : ‘ || instance_name 4: ,’Started At : ‘ || to_char(startup_time,’DD-MON-YYYY HH24:MI:SS’) stime 5: ,’Uptime : ‘ || floor(sysdate – startup_time) || ‘ days(s) ‘ || 6: trunc( 24*((sysdate-startup_time) – 7: trunc(sysdate-startup_time))) || ‘ [...]

Open Source Java x86 PC Emulator »

JPC creates a virtual computer upon which you can install your favorite operating system in a safe, flexible and powerful way. It aims to give you complete control over your favorite PC software’s execution environment, whatever your real hardware or operating system, and JPC’s multi-layered security makes it the safest solution for running the most [...]

Create Bootable USB Drives for Linux »

UNetbootin allows you to create bootable Live USB drives for a variety of Linux distributions from Windows or Linux, without requiring you to burn a CD. You can either let it download one of the many distributions supported out-of-the-box for you, or supply your own Linux .iso file if you’ve already downloaded one or your [...]

Open Source Knowledge Representation System »

PowerLoom® is the successor to the Loom® knowledge representation system. It provides a language and environment for constructing intelligent, knowledge-based applications. PowerLoom uses a fully expressive, logic-based representation language (a variant of KIF). It uses a natural deduction inference engine that combines forward and backward chaining to derive what logically follows from the facts and [...]

Open Source HTTP Accelerator »

Varnish is a state-of-the-art, high-performance HTTP accelerator. It uses the advanced features in Linux 2.6, FreeBSD 6/7 and Solaris 10 to achieve its high performance. Some of the features include A modern design VCL – a very flexible configuration language Load balancing with health checking of backends Partial support for ESI URL rewriting Graceful handling [...]

Open Source Library Resource Portal »

VuFind is a library resource portal designed and developed for libraries by libraries. The goal of VuFind is to enable your users to search and browse through all of your library’s resources by replacing the traditional OPAC to include: Catalog Records Locally Cached Journals Digital Library Items Institutional Repository Institutional Bibliography Other Library Collections and [...]

Open Source Archiving Information System »

Archon is award-winning software for archivists and manuscript curators. It automatically publishes archival descriptive information and digital archival objects in a user-friendly website. With Archon, there is no need to encode a finding aid, input a catalog record, or program a stylesheet. Archon’s powerful scripts will automatically make everything in the system searchable and browsable [...]

Open Source HCI »

mando is a human computer interface using a camera and a projector. The camera is calibrated against a projection area to determine the position of a physical pointer (i.e. pen, LED diode or laser pointer light) which is then used to virtually move and generate events of a X11 pointer.

Open Source Teaching Tool »

iTALC is a use- and powerful didactical tool for teachers. It lets you view and control other computers in your network in several ways. It supports Linux and Windows 2000/XP (Vista support will come) and it even can be used transparently in mixed environments! iTALC has been designed for usage in school. Therefore it offers [...]

Oracle: Tracing ORA Error »

You can set a diagnostic event for the ORA-1652 error in your individual database session with the following statement: ALTER SESSION SET EVENTS ’1652 trace name errorstack’; You can set a diagnostic event for the ORA-1652 error in your individual database session with the following statement: ALTER SYSTEM SET EVENTS ’1652 trace name errorstack’;   [...]

ImageMagick »

ImageMagick is a software suite to create, edit, and compose bitmap images. It can read, convert and write images in a variety of formats (over 100) including DPX, EXR, GIF, JPEG, JPEG-2000, PDF, PhotoCD, PNG, Postscript, SVG, and TIFF. Use ImageMagick to translate, flip, mirror, rotate, scale, shear and transform images, adjust image colors, apply [...]