By admin on Aug 31, 2009 in database, open source | Comments Off on 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 […]
By admin on Aug 31, 2009 in .NET, database, open source | Comments Off on 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 […]
By admin on Aug 31, 2009 in Oracle | Comments Off on 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 […]
By admin on Aug 30, 2009 in Oracle, side note | Comments Off on Oracle: Verify PGA and SGA
For current PGA size of each session, use: SELECT s.sid, n.name, s.value FROM v$sesstat s, v$statname nWHERE s.statistic# = n.statistic#AND n.name = ‘session pga memory’; For maximum PGA size each session has reached so far, use: SELECT s.sid, n.name, s.value FROM v$sesstat s, v$statname nWHERE s.statistic# = n.statistic#AND n.name = ‘session pga memory max’;
By admin on Aug 30, 2009 in Java, open source | 1 Comment
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. […]
By admin on Aug 30, 2009 in Java, open source | Comments Off on 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 […]
By admin on Aug 28, 2009 in open source | Comments Off on 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 […]
By admin on Aug 28, 2009 in Oracle, side note | Comments Off on 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))) || ‘ […]
By admin on Aug 28, 2009 in Java, open source | Comments Off on 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 […]
By admin on Aug 12, 2009 in open source | Comments Off on 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 […]
By admin on Aug 10, 2009 in AI, open source | Comments Off on 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 […]
By admin on Aug 6, 2009 in open source | Comments Off on 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 […]
By admin on Aug 5, 2009 in open source | Comments Off on 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 […]
By admin on Aug 4, 2009 in open source | Comments Off on 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 […]
By admin on Aug 4, 2009 in open source | Comments Off on 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.
By admin on Aug 4, 2009 in open source | Comments Off on 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 […]
By admin on Aug 3, 2009 in Oracle | Comments Off on 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’; […]
By admin on Aug 3, 2009 in open source | Comments Off on 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 […]