Ortholog…Google Toolbar buttons for genomics and bioinformatics

Ortholog…Google Toolbar buttons for genomics and bioinformatics: "Google Toolbar buttons for genomics and bioinformatics"

Zend Core for Oracle and PHP

Zend Core for Oracle: "Zend Core for Oracle, developed in partnership with Zend Technologies, supports businesses using PHP with Oracle Database for mission-critical Web applications. It provides a seamless out-of-the-box experience delivering a stable, high performance, easy-to-install and supported PHP development and production environment fully integrated with the Oracle Database.

This single download gives you a PHP 5 distribution that's ready for development and deployment against your Oracle database—best of all, it's free!

Zend Core for Oracle is now GA and available as a free download from Zend! Support and updates for Zend Core for Oracle will be made available directly from Zend."

Oracle 10g XE and PHP

SitePoint Blogs » Oracle 10g XE and PHP:

"Oracle 10g XE and PHP"
Managed to get the equivalent of a “Hello World” from PHP to Oracle up in under 1.5 hours today (ran into a specific glitch that required a re-install otherwise would have been less time).

Index of /pub/mozilla.org/themes

Index of /pub/mozilla.org/themes:
"Index of /pub/mozilla.org/themes"

Axio Learning

Axio Learning: "Axio Learning is a course management system designed to deliver an interactive web-based classroom to students. Axio Learning extends and enhances course instruction enabling students with time and geographic restrictions to take advantage of the flexibility of learning over the Internet.

Axio Learning is a simple yet powerful set of tools for managing course resources in both the traditional classroom setting and in true Web-based courses."

about Vim : vim online

about Vim : vim online: "What Vim Can Do

Vim is an advanced text editor that seeks to provide the power of the de-facto Unix editor 'Vi', with a more complete feature set. It's useful whether you're already using vi or using a different editor. Users of Vim 5 should consider upgrading to Vim 6, which is greatly enhanced since Vim 5.
A General Overview
What Is Vim?

Vim is a highly configurable text editor built to enable efficient text editing. It is an improved version of the vi editor distributed with most UNIX systems.

Vim is often called a 'programmer's editor,' and so useful for programming that many consider it an entire IDE. It's not just for programmers, though. Vim is perfect for all kinds of text editing, from composing email to editing configuration files."

GIMP - The GNU Image Manipulation Program

GIMP - The GNU Image Manipulation Program: "GIMP is the GNU Image Manipulation Program. It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.

This is the official GIMP web site. It contains information about downloading, installing, using, and enhancing it. This site also serves as a distribution point for the latest releases. We try to provide as much information about the GIMP community and related projects as possible. Hopefully you will find what you need here. Grab a properly chilled beverage and enjoy."

NanoBlogger

NanoBlogger:
"small weblog engine for the UNIX command line"

Introduction

NanoBlogger is a small weblog engine written in Bash for the
command line. It uses common UNIX tools such as cat, grep, and sed
to create static HTML content.

features:

* intuitive commandline interface
* highly configurable and script-able :)
* easy drafting, editing, and management of entries
* archiving by category, year, month, and entry
* pagination
* permanent and navigational links
* templates and CSS style sheets for full control over
layout
* placeholders for easy template manipulation
* support for multiple weblogs
* support for multiple categories
* support for relative and absolute links
* support for date manipulation of entries
* Atom syndication (comes with 1.0 format)
* RSS syndication (comes with RSS 1.0 and 2.0 formats)
* plugins for calendar, recent entries, weblog status, etc.
* plugins for text formatting (e.g. line breaks translate to
HTML)
* global (nb.conf) and per-weblog (blog.conf) configuration
* intelligent build system - only updates relative files
* simple cache system for improved effeciency
* independent of java-script and server-side scripting (e.g.
PHP)
* independent of external database (stores data in
flat-files)
* multi-language support
* multi-platform portability (just bash and the required
commands)

Bio++

Bio++: "Bio++ is a set of C++ libraries for Bioinformatics, including sequence analysis, phylogenetics, molecular evolution and population genetics.

On this website you'll find all information about the Bio++ project: download, installation and usage help.

Bio++ is a Object Oriented and is designed to be both easy to use and computer efficient. Bio++ intends to help programmers to write computer expensive programs, by providing them a set of re-usable tools.

To learn more about this project, see the link 'Project' in the 'article' section."

Oracle Data Miner

Oracle Data Miner: "Oracle Data Miner

Oracle Data Miner is a graphical user interface for Oracle Data Mining (Release 10.1 and above) that helps data analysts mine their Oracle data to find valuable hidden information, patterns, and new insights. Data analysts can mine data with Oracle Data Miner's easy-to-use wizards that guide them through the data preparation, data mining, model evaluation, and model scoring process. As the data analyst transforms the data, builds models, and interprets results, Oracle Data Miner can automatically generate code needed to transform the data mining steps into an integrated data mining/BI application. ODM Code Generator JDeveloper extension generates Java code from Oracle Data Miner models and results.

With Oracle Data Miner and Oracle Data Mining, the data never leaves the database: all data movement is eliminated. In addition, Oracle Data Miner and Oracle Data Mining provide the security of the Oracle database."

Command line reference for Oracle, Windows, Linux and OS X

SS64.com: "Command line reference for Oracle, Windows, Linux and OS X"

	Oracle 9i commands (includes data dictionary views)
	Windows NT/XP commands (including Win2K, 2K3 and Resource Kits)
	Linux BASH commands (Built-in & Shell tools)
	Apple OS X commands (Built-in & Shell tools)

Oracle/PLSQL: Cursor FOR Loop

Oracle/PLSQL: Cursor FOR Loop: "Oracle/PLSQL: CURSOR FOR Loop"

The syntax for the CURSOR FOR Loop is:

FOR record_index in cursor_name (record_index fetch and process every record in a cursor)
LOOP
{.statements.}
END LOOP;

You would use a CURSOR FOR Loop when you want to fetch and process every record in a cursor. The CURSOR FOR Loop will terminate when all of the records in the cursor have been fetched.

Here is an example of a function that uses a CURSOR FOR Loop:

CREATE OR REPLACE Function TotalIncome
( name_in IN varchar2 )
RETURN varchar2
IS
total_val number(6);

cursor c1 is
select monthly_income
from employees
where name = name_in;

BEGIN

total_val := 0;

FOR employee_rec in c1
LOOP
total_val := total_val + employee_rec.monthly_income;
END LOOP;

RETURN total_val;

END;

In this example, we've created a cursor called c1. The CURSOR FOR Loop will terminate after all records have been fetched from the cursor c1.

Technology As If People Mattered : Weblog

Technology As If People Mattered : Weblog: "Ant in Ten Steps

Ant is a tool which attempts to automate the process of building software.

DBAToolZ - Services: Oracle DBA, Oracle Developer, Oracle Server Tuning, Oracle APPS install, PL/SQL, SQL Scripts

DBAToolZ - Services: Oracle DBA, Oracle Developer, Oracle Server Tuning, Oracle APPS install, PL/SQL, SQL Scripts: "DBAToolZ - SQL Scripts"

download SQL Script Archive (617Kb). Every script in this archive is configured with SQLDIR parser.

SQL Script Archive is provided for educational purposes only.

what is database: Best Practices (What is database) Database

"Best Practices (What is database) Database"


Best Practices Database
Searchable database cataloging over 650 good and best practices from more than 90 countries on how people, their communities, the public and private sectors have been able to tackle critical social

Nucleic Acid Database (NDB)
assembles and distributes structural information about nucleic acids.

Search the EDGAR Database
Search the EDGAR Database For detailed descriptions of the different ways you can search EDGAR, please read our Quick EDGAR Tutorial . Some commercial websites also provide useful company information

Household Products Database: Health and Safety Information on
Information in the Household Products Database is taken from a variety of publicly available sources, including brand-specific labels and Material Safety Data Sheets ( MSDS ) prepared by manufacturers.

The Generic Model Organism Database Project | GMOD
Bioinformatics resources, and projects of the Agricultural Research Service, and the National Human Genome Research Institute and the National Institute of General Medical Sciences.

Database Migration. Database Conversion. Convert Database. Migrate
Automatically convert SQL from one Database to another. SQL, T-SQL, PL/SQL and Java code from Oracle, SQL Server and DB2. Migration Tool for DBAs and Developers.

Children's Picture Book Database
A keyword-searchable database of over 4000 picture books; includes abstracts, subject classification, and Web links.

Genome Projects - The Institute for Genomic Research
The TIGR Arabidopsis thaliana Database Provides access to genomic sequence data and annotation generated at TIGR and assemblies of Arabidopsis ESTs from world-wide

Mayday

Mayday: "Mayday - A microarray data analysis framework"

R statistical environment, a connection to Poster-SQL-based databases
Clustering K-means and SOM

.htaccess Tools

.htaccess Tools:
"Howto create a password for a .htpasswd file using PHP"

Welcome to .htaccess Tools

One this site you will find various generators to create .htaccess files for ie hotlink protection, password protection, or blocking of hitbots.

DbWrench: Multi Vendor Database Design and Synchronization Software

DbWrench: Multi Vendor Database Design and Synchronization Software: "Simple to Learn, Easy to Use"

DbWrench is a multi vendor, cross platform database design and round-trip engineering software. It's features include: a graphic entity relation diagram (ERD) designer, ability to forward and reverse engineer databases, a syntax highlighting SQL query editor, and support for some of today's most popular databases. DbWrench is written in pure Java allowing it run on numerous operating systems. DbWrench's multi vendor and multi platform functionality makes it ideal for heterogeneous database environments.

WOJ - World of java website

WOJ - World of java website: "WOJ is a set of services giving access to projects documentations & sources without any settings in your IDE.

WOJ power comes from its integration into IDEs and its ease of use. It can be used transparently even with your existing projects without any effort from your part."

muntjak Software - Home

muntjak Software - Home: "

This site is all about RADi, a professional Java GUI builder and application builder."

The GUI Builder part
Design grids are a common tool in screen design because they simplify aligning screen entities and validate the overall layout. The RADi editor is WYSIWYG and you can interactively control your layout's resizing behaviour. RADi supports antialiased text and panels can have background images. You can define table models and all kinds of renderers, so you can scetch a layout very precisely and in short time. RADi allows for easy internationalization using (RADi-generated) properties files. You can switch between all installed LookandFeels and you can define the FocusTraversalPolicy for frames and dialogs with a few mouse clicks.

The Application Builder part
RADi is a Bean container conforming to the JavaBeans^TM specification. It supports both visible Beans and non-component Beans and provides a BeanContextServices implementation, allowing bean context aware Beans to share services. It is easy to specify event and property handlers which allow for simple inter-Bean communication.

Technology As If People Mattered : Weblog

Technology As If People Mattered : Weblog: "Ten Things Every Java Developer Should Know About Unix

One of the great things about Java is how multi-platform it really is. While cross platform glitches do occur, they are not really all that common. But since the law of unintended consequences is all pervasive, we now have the common sight of teams of developers building Java programs meant to run on Unix boxes on Windows.

Developing code meant for Unix on Windows does work reasonably well. The trouble is, many those coders slaving away in front of XP have a very limited understanding of their target platform. If that describes you, this following list is meant for you."

Launch4j 2.1.2 Cross-platform exe wrapper

Launch4j 2.1.2 Cross-platform exe wrapper: "Launch4j is a cross-platform tool for wrapping Java applications distributed as jars in lightweight Windows native executables. The executable can be configured to search for a certain JRE version or use a bundled one, and it's possible to set runtime options, like the initial/max heap size. The wrapper also provides better user experience through an application icon, a native pre-JRE splash screen, a custom process name, and a Java download page in case the appropriate JRE cannot be found. "

Javolution

Javolution: "Javolution real-time goals are simple: To make your application faster and more time predictable!
That being accomplished through:"

• Safe/transparent object recycling (including threads reuse with concurrent contexts).
• High performance and real-time compliant util / lang / io / xml base classes.
• Struct and Union base classes for direct interfacing with native applications.
• Java fastest xml parsing and marshalling/unmarshalling facility.

JScience

JScience: "# To provide the most comprehensive JavaTM library for the scientific community.

# To create synergy between all sciences (e.g. math, physics, sociology, biology, astronomy, economics, etc.) by integrating them into a single architecture.

# To provide the best on-line services (webstart) for scientific calculations and visualizations."

All about Constraints

Adding a Constraint

Constraint Constraint Type Meaning
CHECK C Specifies the value for a column, or group of columns, must satisfy a certain condition.
NOT NULL C Specifies a column doesn't allow storage of null values. This is actually enforced as a CHECK constraint. You can check NOT NULL columns using the DESCRIBE command.
PRIMARY KEY P Specifies the primary key of a table. A primary key is made up of one or more columns that uniquely identify each row in a table.
FOREIGN KEY R Specifies a foreign key for a table. A foreign key references a column in another table, or a column in the same table in the case of a self-reference.
UNIQUE U Specifies a column, or group of columns, can only store unique values.
CHECK OPTION V Specifies that DML operations on a view must satisfy the subquery.
READ ONLY O Specifies that a view may only be read from.

Adding a CHECK Constraint

ALTER TABLE order_status2
ADD CONSTRAINT order_status2_status_ck
CHECK (status IN ('PLACED', 'PENDING', 'SHIPPED'));

INSERT INTO order_status2 (
id, status, last_modified, modified_by)
VALUES (
1, 'PENDING', '01-JAN-2005', 1
);

INSERT INTO order_status2 (
id, status, last_modified, modified_by
) VALUES (
2, 'CLEARED', '01-JAN-2005', 2
);
INSERT INTO order_status2 (
*
ERROR at line 1:
ORA-02290: check constraint (STORE.ORDER_STATUS2_STATUS_CK) violated

You can use other comparison operators with a CHECK constraint. The next example adds a CHECK constraint that enforces the id value is greater than zero:

ALTER TABLE order_status2
ADD CONSTRAINT order_status2_id_ck CHECK (id > 0);
To add a constraint, any existing rows in the table must satisfy the constraint.

Adding a NOT NULL Constraint

ALTER TABLE order_status2
MODIFY status CONSTRAINT order_status2_status_nn NOT NULL;
Notice you use MODIFY to add a NOT NULL constraint rather than ADD CONSTRAINT. The next example adds a NOT NULL constraint on the modified_by column:

ALTER TABLE order_status2
MODIFY modified_by CONSTRAINT order_status2_modified_by_nn NOT NULL;
The next example adds a NOT NULL constraint on the last_modified column:

ALTER TABLE order_status2
MODIFY last_modified NOT NULL;

Adding a FOREIGN KEY Constraint

ALTER TABLE order_status2
DROP COLUMN modified_by;

ALTER TABLE order_status2
ADD CONSTRAINT order_status2_modified_by_fk
modified_by REFERENCES employees(employee_id);

ALTER TABLE order_status2
DROP COLUMN modified_by;

ALTER TABLE order_status2
ADD CONSTRAINT order_status2_modified_by_fk
modified_by REFERENCES employees(employee_id) ON DELETE CASCADE;

You use the ON DELETE SET NULL clause with a FOREIGN KEY constraint to specify that when a row in the parent table is deleted, the foreign key column for the row (or rows) in the child table is set to null. The following example drops the modified_by column from order_status2 and rewrites the previous example to include the ON DELETE SET NULL clause:

ALTER TABLE order_status2
DROP COLUMN modified_by;

ALTER TABLE order_status2
ADD CONSTRAINT order_status2_modified_by_fk
modified_by REFERENCES employees(employee_id) ON DELETE SET NULL;

ALTER TABLE order_status2
DROP COLUMN modified_by;

Adding a UNIQUE Constraint

ALTER TABLE order_status2
ADD CONSTRAINT order_status2_status_uq UNIQUE (status);

Dropping a Constraint

ALTER TABLE order_status2
DROP CONSTRAINT order_status2_status_uq;

Disabling a Constraint

ALTER TABLE order_status2
ADD CONSTRAINT order_status2_status_uq UNIQUE (status) DISABLE;

ALTER TABLE order_status2
DISABLE CONSTRAINT order_status2_status_nn;

You can add CASCADE to the end of a DISABLE CONSTRAINT clause to disable any constraints that depend on the specified constraint. You must use CASCADE when you disable a primary key or unique constraint that is part of a foreign key constraint.

Enabling a Constraint

ALTER TABLE order_status2
ENABLE CONSTRAINT order_status2_status_uq;
You can also choose to apply a constraint to new data only by specifying ENABLE NOVALIDATE. For example:
ALTER TABLE order_status2
ENABLE NOVALIDATE CONSTRAINT order_status2_status_uq;
The default is ENABLE VALIDATE

Deferred Constraints

A deferred constraint is one that is enforced when a transaction is committed. You specify a constraint is deferrable using the DEFERRABLE clause when you initially add a constraint. Once you’ve added a constraint, you cannot change it to DEFERRABLE ; instead, you must drop and recreate the constraint.

When you add a DEFERRABLE constraint, you can mark it as INITIALLY IMMEDIATE or INITIALLY DEFERRED. INITIALLY IMMEDIATE means that the constraint is checked whenever you add, update, or delete rows from a table (this is the same as the default behavior of a constraint). INITIALLY DEFERRED means that the constraint is only checked when a transaction is committed. Let’s take a look at an example.

The following statement drops the order_status2_status_uq constraint:

ALTER TABLE order_status2
DROP CONSTRAINT order_status2_status_uq;

The next example adds the order_status2_status_uq constraint, setting it to DEFERRABLE INITIALLY DEFERRED:

ALTER TABLE order_status2
ADD CONSTRAINT order_status2_status_uq UNIQUE (status)
DEFERRABLE INITIALLY DEFERRED;

If you add rows to order_status2, the order_status2_status_uq constraint isn’t enforced until you perform a commit.
Getting Information on Constraints

Column Type Description
owner VARCHAR2(30) Owner of the constraint.
constraint_name VARCHAR2(30) Name of the constraint.
constraint_type VARCHAR2(1) Constraint type. Set to P, R, C, U, V, or O
table_name VARCHAR2(30) Name of the table on which the constraint is defined.
status VARCHAR2(8) Constraint status. Set to ENABLED or DISABLED.
deferrable VARCHAR2(14) Whether the constraint is deferrable. Set to DEFERRABLE or NOT DEFERRABLE.
deferred VARCHAR2(9) Whether the deferred. Set to IMMEDIATE or DEFERRED.


You can get information on all the constraints you have access to using all_constraints

SELECT
constraint_name, constraint_type, status, deferrable, deferred
FROM user_constraints
WHERE table_name = 'ORDER_STATUS2';

Getting Information on the Constraints on a Column

Column Type Description
owner VARCHAR2(30) Owner of the constraint.
constraint_name VARCHAR2(30) Name of the constraint.
table_name VARCHAR2(30) Name of the table on which the constraint is defined.
column_name VARCHAR2(4000) Name of the column on which the constraint is defined.

COLUMN column_name FORMAT a15
SELECT constraint_name, column_name
FROM user_cons_columns
WHERE table_name = 'ORDER_STATUS2';

The next example joins user_constraints and user_cons_columns to get the column_name , constraint_name, constraint_type, and status:

SELECT
ucc.column_name, ucc.constraint_name, uc.constraint_type, uc.status
FROM user_constraints uc, user_cons_columns ucc
WHERE uc.table_name = ucc.table_name
AND uc.constraint_name = ucc.constraint_name
AND ucc.table_name = 'ORDER_STATUS2';

Login - PHP

Login:

if (!isset($_SERVER['PHP_AUTH_USER'])) {
header("WWW-Authenticate: Basic realm=\"Private Area\"");
header("HTTP/1.0 401 Unauthorized");
print "Sorry - you need valid credentials!\n";
exit;
} else {
if (($_SERVER['PHP_AUTH_USER'] == 'user') && ($_SERVER['PHP_AUTH_PW'] == 'pass')) {
print "Welcome to the private area!";
} else {
header("WWW-Authenticate: Basic realm=\"Private Area\"");
header("HTTP/1.0 401 Unauthorized");
print "Sorry - you need valid credentials!\n";
exit;
}
}




Utility downloads

Utility downloads: "BAT 2 EXE"

Once copied, to run file, type:

bat2exe

CMDOW Commandline Window Utility for NT4/2000/XP/2003

CMDOW Commandline Window Utility for NT4/2000/XP/2003: "Cmdow is a Win32 commandline utility for NT4/2000/XP/2003 that allows windows to be listed, moved, resized, renamed, hidden/unhidden, disabled/enabled, minimized, maximized, restored, activated/inactivated, closed, killed and more.

Cmdow is 31kb standalone executable. It does not create any temporary files, nor does it write to the registry. There is no installation procedure, just run it. To completely remove all traces of it from your system, delete it.

Cmdow was written with batch file programmers in mind. Particular attention has been paid to Cmdows output making it easy to process with the 'FOR /F' command found in NT4/2000/XP/2003."

XML training wheels

XML training wheels: "XML training wheels

An XSLT and Java-based tool for producing tutorials -- custom-built for developerWorks but ready to adapt to your own use
"

Update Cascade Package

Update Cascade Package:

"Table Of Contents...."

• What is This
• Installing, Using, and Seeing how the demo works
• Technically, How it works
• Download This Software