Data Warehouse Design

Our company has a large data warehouse with 10 tables each over 15 Gb in size. We have the database implemented in MySQL. However, we are not able to create the proper indexes and keys due to missing data in some tables and very long run times that we are experiencing with our queries.

We require an expert in database design and implementation to review the current structure of the database and to provide an alternative design and instructions for implementation based on the queries and reports that the database is used to support.

The database is used to support a small number of queries and reports that are run repeatedly by our company with slightly different parameters each time. In addition to providing advice on database design improvement and instructions for implementation, we would like the expert to review the queries that we use to generate our reports and help us to optimize them if necessary.

Keahlian: Penyimpanan Data, Pengembangan Database, MySQL, SQL

Lihat lebih lanjut: use of data structure, tables in data structure, implementation of data structure, design warehouse , design a data structure, data warehouse design, data structure with c, data structure implementation, data structure design, warehouse, large data, design improvement, mysql indexes keys, database warehouse, expert database design mysql, warehouse design, design review tables, mysql data tables, data tables design, optimize database mysql, design templates data entry web form, web design massive data entry, large data database mysql, graphic design product data sheets, website design adding data multiple data associated

Tentang Pemberi kerja:
( 3 ulasan ) Vancouver, Canada

ID Proyek: #7254410

29 freelancer menawar dengan rata-rata $1287 untuk pekerjaan ini


1. Tours Site + Booking Module We already designed and developed a complete portal for online tours listing with complete online bookings of tours with departures and much more other things in a complete cms based sol Lebih banyak

$1457 USD dalam 22 hari
(35 Ulasan)

Hello Thanks for posting the [login to view URL] a project manager I worked on projects from core php to technologies like wordpress, joomla, drupal, quikc, magento, opencart, shopify, woocommerce, html5, responsive designining Lebih banyak

$1315 USD dalam 20 hari
(35 Ulasan)

Hello there, i'm expert on designing database also implementation, i've done many complex report. Pls let me know how can we go to the database to see the structure. Waiting for your feedback. Thank you

$1500 USD dalam 20 hari
(145 Ulasan)

Hi We have read your Requirements and would like to discuss further as we have done complex database design, processing as well as administration in over 150 projects in last 5 years. We have 5 database experts with Lebih banyak

$1184 USD dalam 18 hari
(16 Ulasan)

Hello, im very good with databases of any kind. If you are interested take a look at my feedbacks and let me know. I would like to help you.

$800 USD dalam 7 hari
(25 Ulasan)

Hi, I am 12+ years experienced Database Programmer at CMMI-5 level company. I am working on : RDBMS: Oracle,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards. Data Base Tools : Database Configuration Assistant Lebih banyak

$1500 USD dalam 15 hari
(37 Ulasan)

Hi Employer, I have read your description and been interested in your project. Please give me more details of your MySQL database and queries. I'm ready to discuss and start to work on it now ======================= Lebih banyak

$1052 USD dalam 20 hari
(12 Ulasan)

I'm a Java expert, familiar with DB, and have done SQL optimizations before .

$1250 USD dalam 20 hari
(6 Ulasan)

Hi. I am database/datawarehouse developer. Currently working for one american company. I am also report developer so I can make your sql work faster. Thanks

$777 USD dalam 10 hari
(12 Ulasan)

Hello. I am a web developer with 15+-year experience . I work remotely on DigitalRay company - [login to view URL] - LA (USA). Technical knowledges: 1PHP JavaScript Ruby RoR ASP.Net C#, Java, Python, Zend, CakePHP, Symph Lebih banyak

$1250 USD dalam 20 hari
(4 Ulasan)

Hi, I am a database modeler and have been working with mysql data for a long time and in lots of projects. I have read your problem statement and am interested in resolving them. The database needs to be normalized an Lebih banyak

$1250 USD dalam 30 hari
(4 Ulasan)

A proposal has not yet been provided

$1250 USD dalam 20 hari
(9 Ulasan)

Hi,I can do your project very easily. I have seven years programming experience of MS-Access/Database system Design and Implementation/Oracl 10g/SQL Server 2014/C#/VB. I will provide you quality work with 100% accurac Lebih banyak

$1000 USD dalam 15 hari
(3 Ulasan)

I have 8+ Years of Database development experience and working as Technical Architect , Database Expert in Software Industry.

$1000 USD dalam 25 hari
(0 Ulasan)

I will review your existing design and identify the relational issues. I need table list including column, Row volumes of each table. I need information about use case (business operating systems), which data entry mos Lebih banyak

$1111 USD dalam 10 hari
(0 Ulasan)

I was database professor at university. i have very strong experience on database. i can help you to improve your database, i can do some extra work like database partitioned, i will be full time dedicated to this task Lebih banyak

$750 USD dalam 12 hari
(0 Ulasan)

Hi, I'm a Sr Mysql DBA with more than 8 years experience. I have also more than 12 years experience with Data warehouse and query optimization. I also have experience with column base database for fast reporting (u Lebih banyak

$833 USD dalam 10 hari
(0 Ulasan)

A proposal has not yet been provided

$1250 USD dalam 30 hari
(0 Ulasan)

Hi recently I optimize a system of bank profitability with 1500000 customers and achieve excellent response times

$750 USD dalam 20 hari
(0 Ulasan)

I am a private freelancer thats why I have no reviews because I usually got my clients from other freelancers company such as craigslist, easyoutsource, onlinejobs, warrior forum.. Somebody told me to try my luck here Lebih banyak

$750 USD dalam 20 hari
(0 Ulasan)