Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 30.071.015 Times

DBSchema::Normalizer 0.08

  Date Added: July 18, 2010  |  Visits: 820

DBSchema::Normalizer

Report Broken Link
Printer Friendly Version


Product Homepage
Download (76 downloads)

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..

Requirements: No special requirements
Platforms: Linux
Keyword: Create Database Dbschema Dbschemanormalizer Dest Dsn Fields Libraries Lookup Programming Table
Users rating: 0/10

License: Freeware Size: 33.79 KB
DBSCHEMA::NORMALIZER RELATED
Business  -  SSuite Office - MonoBase 2.0.0.3
Features Available: - Create unlimited databases with unlimited tables, fields, and rows - Access any ODBC compatible database of any size, from 1 Kilobyte to 1 Terabyte - Filter tables instantly - Run SQL statements with the SQL query engine -...
9.32 MB  
Database Tools  -  MySQL File System 1.0
MySQL File System can be used to create a virtual filesystem using BLOB fields of a MySQL database table to store the file contents.MySQL File System is particularly useful when disk space is scarce on a server that cannot go down in a production...
10 KB  
Libraries  -  Blocks (formerly Database Objects) 2.2.2
Database Objects it's a Java library containing visual (SWING) and non visual components to easily create database RAD applications. The focus traversal between components is entirely controlled by a special component. PDF reports and Excel...
 
Database Tools  -  FreeTDS 0.64
FreeTDS is an open-source implementation of the TDS (Tabular DataStream) database client access protocol and related libraries used by Sybase and Microsoft. FreeTDS supports all versions of the protocol from both vendors, and includes DB-Lib,...
1.3 MB  
Code Management Tools  -  tangible architect professional edition 4.0
Create Database Applications in record time! tangible architect generates a full business object implementation - including data access code - from C# interface definitions or UML ! Generated business objects realize the data access with...
14.46 MB  
Database Tools  -  Database Test Suite 5.0.1.0
This Database Test Suite aims to create database workload test kits used to simulate heavy user loads for OLTP, Decision Support, and e-commerce database transactions. These test kits can also be used to gather performance results for Linux and other
1.85 MB  
Database Tools  -  PHPLens 1.0
PHPLens allows PHP developers to quickly create database-driven web applications. With PHPLens, web pages can be quickly created to present data as html tables with facilities to create, edit, paginate, search and delete records.
 
Database Tools  -  PHP Booosta! 1.0
PHP Booosta provides you with easy-to-use components to create database driven web applications in PHP without having any clue about what "SQL" is. It also allows you to create quick HTML-Forms and offers several other things.
 
Database Tools  -  PHPLens for Scripts 1.0
PHPLens allows PHP developers to quickly create database-driven web applications. With PHPLens, web pages can be quickly created to present data as html tables with facilities to create, edit, paginate, search and delete records.
2.66 MB  
Books  -  Christchurch City Libraries 1.6
Access Christchurch City Libraries from your iPhone! The Christchurch City Libraries mobile app makes it easy to find and discover titles, place holds, rate titles, create lists and get information about our libraries. Features: ...
6.2 MB  
NEW DOWNLOADS IN PROGRAMMING, LIBRARIES
Programming  -  FLEX-db Digital Asset Manager 3.0.9
FLEX-db - an enterprise Digital Asset Manager (DAM). It ingests and links metadata with files, creates thumbnails, and processes files using business rules. FLEX-db has a JSP client, Java app server for file input and output and an EJB metadata...
21.57 MB  
Programming  -  Libicom 0.9.0
The libicom library is a character based dynamicly linked library for Linux. It is used to remotely control the Icom IC-R8500 wide band receiver via an RS232 link. All call and return parameters to the control functions are character string based....
20.48 KB  
Programming  -  dotdesktop 0.3
Dotdesktop library provides ability to parse desktop entry file and access the information in a convenient way. Desktop entry file format is defined by freedesktop.org, it is used to describe information about an application such as the name and...
327.68 KB  
Programming  -  Cedalion for Linux 0.2.6
Cedalion is a programming language that allows its users to add new abstractions and define (and use) internal DSLs. Its innovation is in the fact that it uses projectional editing to allow the new abstractions to have no syntactic limitations.
471.04 KB  
Programming  -  libyasl 0.2
Libyasl is a C++ class library to easily realize TCP/UDP/Multicast clientsand servers in IPv4 and IPv6 environments under GNU/Linux systems.
143.36 KB  
Libraries  -  wolfSSL 3.12.0
The wolfSSL embedded SSL/TLS library is a lightweight SSL library written in ANSI standard C and targeted for embedded and RTOS environments - primarily because of its small size, speed, and feature set. It is commonly used in standard operating...
2.73 MB  
Libraries  -  EuGTK 4.8.9
Makes it easy to develop good- looking, fast, cross-platform programs that run on Linux, OS X, and Windows. Euphoria is a very fast interpreted/compiled language with straight-forward syntax. EuGTK allows programming in a clean, object-oriented...
10.68 MB  
Libraries  -  Linux User Group Library Manager 1.0
The LUG Library Manager is a project to help Linux User Groups start their own library. A LUG library is helpful to the community at large because it increases access to information, and gives everyone the opportunity to become more knowledgeable.
5.35 KB  
Libraries  -  Module::MakefilePL::Parse 0.12
Module::MakefilePL::Parse is a Perl module to parse required modules from Makefile.PL. SYNOPSIS use Module::MakefilePL::Parse; open $fh, Makefile.PL; $parser = Module::MakefilePL::Parse->new( join("", ) ); $info = $parser->required;...
8.19 KB  
Libraries  -  sqlpp 0.06
sqlpp Perl package is a SQL preprocessor. sqlpp is a conventional cpp-alike preprocessor taught to understand SQL ( PgSQL, in particular) syntax specificities. In addition to the standard #define/#ifdef/#else/#endif cohort, provides also...
10.24 KB