Main > Programming > Libraries >

DBSchema::Normalizer 0.08

DBSchema::Normalizer 0.08

Sponsored Links

DBSchema::Normalizer 0.08 Ranking & Summary

RankingClick at the star to rank
Ranking Level
User Review: 0 (0 times)
File size: 0.033 MB
Platform: Any Platform
License: Perl Artistic License
Price:
Downloads: 1083
Date added: 2006-11-09
Publisher: Giuseppe Maxia

DBSchema::Normalizer 0.08 description

DBSchema::Normalizer is a database normalization. It can convert a table from 1st to 2nd normal form.

SYNOPSIS

# the easy way is to give all parameters to the constructor
# and then call do()
#
use DBSchema::Normalizer;
my $norm = DBSchema::Normalizer->new (
{
DSN => $DSN,
username => $username,
password => $password,
src_table => $sourcetable,
index_field => $indexfield,
lookup_fields => $lookupfields, # comma separated list
lookup_table => $lookuptable,
dest_table => $dest_table,
copy_indexes => "yes",
});
$norm->do(); # Just Do It!

# Alternatively, you can have some more control, by
# creating the lookup table and normalized table separately,
# especially useful if one of them is an intermediate step.
#
use DBSchema::Normalizer qw(create_lookup_table create_normalized_table);
my $norm = DBSchema::Normalizer->new(
{
DSN => $DSN,
username => $username,
password => $password
});
$norm->create_lookup_table (
{
src_table => $tablename,
index_field => $indexfield,
lookup_fields => $lookupfields,
lookup_table => $lookuptable
});
$norm->create_normalized_table (
{
src_table => $tablename,
index_field => $indexfield,
lookup_fields => $lookupfields,
lookup_table => $lookuptable,
dest_table => $dest_table,
copy_indexes => "yes",
});

DBSchema::Normalizer is a module to help transforming MySQL database tables from 1st to 2nd normal form. Simply put, it will create a lookup table out of a set of repeating fields from a source table, and replace such fields by a foreign key that points to the corresponding fields in the newly created table.

All information is taken from the database itself. There is no need to specify existing details. The module is capable of re-creating existing indexes, and should deal with complex cases where the replaced fields are part of a primary key.

DBSchema::Normalizer 0.08 Screenshot

Advertisements

DBSchema::Normalizer 0.08 Keywords

Bookmark DBSchema::Normalizer 0.08

Hyperlink code:
Link for forum:

DBSchema::Normalizer 0.08 Copyright

WareSeeker periodically updates pricing and software information of DBSchema::Normalizer 0.08 full version from the publisher, so some information may be slightly out-of-date. You should confirm all information before relying on it. Software piracy is theft, Using crack, password, serial numbers, registration codes, key generators is illegal and prevent future development of DBSchema::Normalizer 0.08 Edition. Download links are directly from our publisher sites, torrent files or links from rapidshare.com, yousendit.com or megaupload.com are not allowed

Allok Video Splitter 2.2.0 Review:

Name (Required)
Email(Required)
Captcha
Featured Software

Want to place your software product here?
Please contact us for consideration.

Contact WareSeeker.com
Related Software
MP3Organizer is designed to organize your MP3-collection. Free Download
cheapskate is a simple Ruby on Rails application for personal budgeting. Free Download
bookmarker is a WWW-based application for managing bookmarks. Free Download
AnyData::Format::XML is a Perl module for tiedhash and DBI access to XML. Free Download
Thesaurus::DBI is a Perl module that can store and query synonyms (Thesaurus) in an SQL database. Free Download
Metadot Portal Server is a leading open source portal system. Free Download
dbmstools module exists mainly for developers who need to support applications on more than one database management system DBMS. Free Download
LiteMan is a simple GUI database manager for the SQLite embeded database engine version 3. Free Download