DBSchema::Normalizer 0.08
Sponsored Links
DBSchema::Normalizer 0.08 Ranking & Summary
File size:
0.033 MB
Platform:
Any Platform
License:
Perl Artistic License
Price:
Downloads:
6307
Date added:
2006-11-09
Publisher:
Giuseppe Maxia
Publisher URL:
http://search.cpan.org/~g
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.
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
Sponsored Links
DBSchema::Normalizer 0.08 Keywords
DBSchema
DSN
Normalizer 0.08
DBSchemaNormalizer
table
lookup
fields
database
create
DEST
DBSchema::Normalizer 0.08
Libraries
Programming
Bookmark DBSchema::Normalizer 0.08
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 mirror sites or publisher sites, torrent files or links from rapidshare.com, yousendit.com or megaupload.com are not allowed
DBSchema::Normalizer 0.08 Related Software
Volume Normalizer is an XMMS plugin that will set the volume of any played song to some preset level.
HTML::WikiConverter::Normalizer is a Perl module to convert CSS styles to (roughly) corresponding HTML.
My Software
You have not saved any software. Click "Save" next to each software to save it to your software basket
Related Information
Sponsored Links
TOP POPULAR DOWNLOAD