Find Jobs
Hire Freelancers

Convert multiple Oracle tables (same structure) into one - repost 2

$30-250 USD

Closed
Posted about 10 years ago

$30-250 USD

Paid on delivery
I have a database schema which has many redundant tables for the same data, with the same columns (fields) in each one. Each table represents measurements for a particular location at one time, e.g. hourly. The columns (fields of measurement) are the same and most are just numbers. Currently each "Site" (location) has own table, with the same columns as the other sites. I would like these combined into one table with a 'site' column that is a foreign key to the list of (about 30) sites. The SITE table exists already. It would be good if this is a script (bash, PL/SQL etc) that can be run at any time on a Linux box. To bid on this, I would like to know roughly which technique you are thinking of using and which language. I will show you the schema. Please include the word 'schmozza' in your bid so I know you have read this. I can also send you a database dump (about 700mb) or a VMware image which contains Oracle (about 12GB). I would like you to understand how to transfer and sync large files using UNIX and SSH.
Project ID: 5551569

About the project

10 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average $247 USD for this job
User Avatar
Hi, I'm very interested helping you converting your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database assignments. I've checked your requirement I can do this job in the deadline without a problem using SQL/PLSQL, because I've done many projects like this. Please send me all other details if you have about your project, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$200 USD in 3 days
4.5 (26 reviews)
5.2
5.2
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, As mentioned in your description here is the word 'schmozza'. Before taking this project I would like to know to few details about the database side. 1. How many duplicate tables are there. 2. It requires to add an additional column(as per my assumption with out seeing the data). So if we change are there any impacts in other linked areas? 3. Currently how the data is inserting into these tables(shell script)? Thanks, Kumar
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Having 8+ Years of Experience in Datawarehouse, SQL and PL/Sql Programming with Unix Shell Scripting. Delivered Critical Deliverable to the Clients like GE, Knape & Vogt,Deautsch Bank,BAe Systems,PGI etc.,
$120 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
schmozza. Hi Please let me know in which language do you want reun the script either Perl or Shell and let me know your expections. Thanks &Regards Subhash Tetarwal
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm an expert in Database like Oracle, Sybase, MySQL. I've performed all functions from Administration and Modeling to actual SQL coding including stored procedures, triggers, functions etc. I have participated in many kinds of project and all them require loading external data files into appropriate table By modeling of Database I mean creating truly relational and normalized design to create the entire database for any entity. I'm very much experienced Data Entry person. I always find the way to automate the process of the External Data Files to extract required information and load it into the Database. My skills include but not limited to Data Processing, Data Entry, Microsoft Word, Excel, Unix, Grep, Data Bases etc. It is apparent that your Database is not normalized i.e. not really relational. I can correct it but it is not that simple. After correcting your Database Model we have to think about implementation. You can't just remove fields from the table without loosing data so we need to save this data in let say a temporary table and then insert it in a new ones . I do not want to install Oracle on my computer but I can work remotely by lo-gin into your instance of Oracle. That said the amount of work to be done does not fit your budget! The bottom line is that I would be more than happy to work on your project. Of course I will need detailed information to complete your project properly and on a timely basis. Your project will be in good hand! Israel Khavinson
$1,055 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
schmozza , i would use PLSQL script for this , I need database dump for this. Please share all requirement in details with me.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
As your information, If you have one site can connect to all site. we can get data directly by PL/SQL or SQL Loader to import data to target table or using Materialized View. I have experiences about migration and integration data with PL/SQL from many source to one target as your project. If not, we need to discuss How to load data from source to target site? before design and develop as your request later. If you have any questions, please let me know and I hope we will work together.
$166 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$150 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
India
0.0
0
Member since Mar 13, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.