Malloc Corporation - dataMigrationCaseStudy

By: Malloc  09-12-2011
Keywords: Oracle Database, Database Structure, Referential Integrity,

Task #1: Design new Oracle database.

Target database has to be designed however in order to do that source database and data has to be fully understood. It is common misconception that this can be done only by analyzing application. Unless your application is based on a spreadsheet - it simply cannot be done. The only way to understood the database structure and data is to look at the database and data itself. Having data model (ER Diagram) will definitely help understood database structure however it will not do much when it comes to understanding data stored in the database, its format, usage, patterns, spreads, etc. Also, many legacy databases do not implement referential integrity and sometimes are not even properly designed so even rudimentary data rules are implemented and controlled at the application level and not by database engine.

Keywords: Database Structure, Oracle Database, Referential Integrity,

Other products and services from Malloc


Malloc Corporation - productsG DAOframework

Code generation overcomes some deficiencies of inheritance (i.e. Java allows class to be inherited only from one super class, each database object is represented by customized Java class, enables IDE features like ?Code Assist. Integrator with JDBC enabled Data Sources such as all major databases and file formats. G-DAO FRAMEWORK - PRODUCT DESCRIPTION What is G-DAO Framework. Java technologies such as JDBC.


Malloc Corporation - RemoteDataServices

We need a program which will continuously compare data in Sybase and Oracle databases and send us daily report about discrepancies.. Databases can be sent to us as an export files , bcp files or as any other popular file format. Remote access could be provided so we can export data ourselves or just work directly on your database. For complex requirements we provide a proof of concept which ensures success and quality of service.


Malloc Corporation - Database Analyzer

DB Analyzer is designed to help IT personnel such as Business Analysts, Managers, System Architects, Developers and Database Administrators to better understand how and what data is stored in the database. Quality Assurance analysts can check the quality of test bed database and ensure the data is sufficiently diversified and appropriate for user acceptance testing.


Malloc Corporation - productsTestDaedmonDescription

Test Daemon captures transaction events as they occur in a database and presents them in a comprehensive and customizable report so the tester or developer can analyze these events. The tester links the tables to a test case and it is the test case execution that captures and stores the database transaction events once a program that changes data is run.


Malloc Corporation - services

Data migration between wide spectrum of sources and destinations such as databases, files, messaging and remote systems. Design and development of data layers for business applications also known as "back end" applications and middleware. Design and development of OLTP Relational Databases and back end systems. Performance optimization related to massive data volumes manipulation.