Delete Redundant Records

Cleaned and error free data; this is the common phrase that we normally listen from most of the data warehouse users. So to make this statement true, SQL Lion team has come up with a tool named “Duplicate Remover”. This tool will search for the presence of duplicate records (redundancy in...

Here comes one more challenging yet interesting topic to tide over. The requirement goes something like this: You have some sources, let it be some sales data or some Call center data coming from different sources. Data can be of different media. But you are able to load it in your staging tables...

A flat file is a file that contains records. Each record is specified in a single line. Fields from each record may either have a fixed width, or may be delimited by commas (CSV), tube (|), whitespace, tabs, or any other character.Flat File Database Manager will allow you to manage...


Platforms: PHP

A flat file is a file that contains records. Each record is specified in a single line. Fields from each record may either have a fixed width, or may be delimited by commas (CSV), tube (|), whitespace, tabs, or any other character.Flat File Database Manager will allow you to manage...


Platforms: PHP

MySQLDataManagement provides you a set of php scripts to manage your data for selected database.All your tables will be shown you for data management on them. MySQLDataManagement is intended to add / edit / delete / list records on selected table - DB .


Platforms: PHP

This PHP script is mainly used to view and edit MySQL database table records. It can retrieve records of MySQL database tables and display the record field values along with links to change the record values or even delete the records.The texts used in the record listings and forms are available...


Platforms: PHP

Progress ODBC ABM can generate a Web based user interface to insert, select, update and delete rows of a given table. The table records in a Progress database can be listed within an HTML table.Progress ODBC ABM can also generate links and forms to insert new records and update or delete existing...


Platforms: PHP

This class can be used to manipulate flat file databases.It uses the DBA extension to perform several types of operations like inserting new records. retrieve all records, retrieve a record with a given key, delete all records, and delete a record with a given key.The code and the comments are in...


Platforms: PHP

The parameters are defined programatically and specify tables, fields, value conditions etc.Currently PDO_DB can execute select queries to retrieve results into arrays, insert or update records into a table from values passed in an associative array, and delete table records that match a given...


Platforms: PHP

Periodic site maintenance can estimate the time, in days, until the hosted files will exceed a defined disk space.Key Features of Periodic site maintenance:- Take backups of database tables to compressed XML files- Rotate backup files deleting files older than a given number of days- Remove files...


Platforms: PHP

Oh!DB Table Data Gateway can perform the following operations:- Execute SQL SELECT queries from list of fields of a table- Retrieve the highest or the lowest value from an integer primary key table field- Get or delete one record of a table with a given primary key value- Delete all records of a...


Platforms: PHP

Table records can be inserted or updated using a list of table field values.Key Features of Flash SQL:- Delete table records that match a given condition- Retrieve a table field values of records that match a given condition- Create a table with a list of fields- Execute an SQL query and return...


Platforms: PHP

phpBB login classes is meant to provide user authentication to sites that have already installed the phpBB forum application database.This class avoids the need to create or install another authentication system if you already have installed or plan to install phpBB.For now, phpBB login classes...


Platforms: PHP

The Tcladdressbook library is a Tcl extension defining a new command called addressbook which lets you manipulate the Mac OS X AddressBook. Under Mac OS X (versions 10.2 or greater) every user has a single addressbook which all applications are allowed to share. Thanks to the AddressBook...


Platforms: Mac

PdbEditor is a Java/Swing application that can create, open, edit, and save Palm Database (PDB) files in a simple but powerful graphical environment. It includes the ability to create and modify the contents of individual database records. Current Features * Can open and parse PDB (Palm...


Platforms: Mac

This command line tool for TonicDNS API. TonicDNS is RESTful API for PowerDNS. Convert readble text record to JSON, and create or delete zone records with TonicDNS.


Platforms: *nix

This project provides a command-line tool for the CORBA Telecom Log Service. It can be used to query, add and delete log records.


Platforms: *nix

Data Workings can be used to access records of an SQL database table as objects. It can access a SQL database table and retrieve its list columns so it can determine which fields need to be retrieved and stored to map record information to object variables and vice-versa.Data Workings can insert...


Platforms: Matlab

MySQL Collection provides you a set of functions to use with your MySQL database.Functions of Log:- log() // Create a log file- addLog() // Append one line in the log file- show() // Show de log content in HTML formatProperties of Connection:- application // Name of application- host // IP or...


Platforms: PHP

PdbEditor is a Java/Swing application that can create, open, edit, and save Palm Database (PDB) files in a simple but powerful graphical environment. It includes the ability to create and modify the contents of individual database records. Current Features Can open and parse PDB (Palm...


Platforms: *nix