Build analytics database based on raw tracking data in MySQL

Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself doing programming so you will directly work with one person and that's me. No mediators. No managers. No subcontractors. see my recent work for the technical expertise along with reviews & feedback on my profile page.

Warm Greetings We have mentioned a place holder bid to initiate a discussion . Do let us know your availability on chat for us to discuss the project in more detail. We will be quoting the final price once we are clear on the deliverables. Look forward to hearing from you soon Thankyou Sam ============== About ESolz: 1. We are into this business for over 10 years 2. We have expertise in web and mobile based application and site development

Greetings, We have been working in our career with large volumes of data in a local country search engine project that kept about 1,5 million web-pages indexed. The provided short description has revealed us only the general aspects of your requirements. To create a final offer, customized to your requirements, we would need some more detailed information about your project. A simple and effective method for the creation of a structured and detailed description of your project would be to imagine that the final result already exists and is in front of you, onscreen. Each interface that came up during this process could be described in several sentences or even sketched. A short description of the functionality of each of these interfaces from the user perspective is also of great value. A life-time Bug-free warranty for this project is included in the offer. Considering the above we would like you to pay attention to our portfolio at: http://www.freelancer.com/u/devexpertsteam.html We would be glad to answer your questions and provide required assistance. Best Regards, Your DevExperts Team

I worked with large database for past 6 years . I am working with a company who is largest affiliate for norton . They recieve around 4-6 million traffic and there are good much interaction with database I have planned designed . I would like to know more . When you say instant update do you want ajax to be implemented ?

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

Hi, The scope of the project is just showing the analytics data or update it? You have wrote this in your specs --------------------------------- I have a MySQL tracking database with around 100,000-500,0000 items being added each day, with relationships across 5-10 tables.

Hi! I've seen your post and I'm interested in it, if u r adding that much data every single day then it would be fairly large db. I can build an adminpanel for it, u need to mentioned what analytics view u want to show. the response time performance depend upon the view requirement if the query for that requirement is easily filtered by mysql engine then it will be fast else it may be slow. so I can't tell u about that without knowing it. I'm expert in PHP and mysql, let me know the details if u r interested in my bid, I'll set my bid cost and time accordingly

Hello, I have familarized with your requirements and decided to place a bid. I am confident we are able to build for you a database structure that will be optimized for high concurency and fast response. We were recently working on a similar problem. The database contained a few milions of rows distributed in different tables and bound by n:m relations. The information from the tables were dynamically grouped and sorted by a few fields - the process was very, very expensive. Our task was to decrease the response time and keep the high concurency. During this work, we learned a lot about database optimization techniques incl. covering indexes, packed keys, static row size, quick sub-queries and many others. What is the most important, our work was very fruitful - in some cases we noted even 50-100x acceleration! Based on the above, I think we have all the required qualifications. Additionally, we always do our work on the highest level (please check our reviews on Freelancer.com) and have good communication skills. We are also interested in building long-term cooperation. Should you have any questions, please do not hesitate to contact me. Thank you! Best regards, Jacek Francuz

I am willing to discuss further details about the project specifications and deliver the same to your needs

Hello, We are team of two experienced Software Engineers and we are interesting in working on your project. We really enjoy working with complex database systems because we see them as a challenge. Mainly we are working on complex systems for business management, and these projects helped us to gain lots of experience in building well optimized databases. We won't say we are better than anyone else we will convince you with our work. We are very enthusiastic and we are always looking for a better solution. We are promising quality work. And yes, we are available for long term collaboration. Please check our feedback and portfolio and get back to with more details about the project. Looking forward to hearing from you. Katerian

I am not getting one point when you said, you have to build a database and also you have a database with millions of records...Please explain

A proposal has not yet been provided

Hello Sir, I well read your description. I need to re-evaluate my bid according to more details about your project. About availability, I am free from today and theses next days. I have a lot of experience with php/mysql + jquery and more, I am freelancer since 10 years and last year I was working for a big company who own a network of adult tubes (youporn network). You can also check my portfolio where you can find few websites I've programmed. If you have any questions, feel free to contact me here or through skype: djflexlive Thanks.

Hi, I'm very interested helping you creating 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, 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

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.

Dear customer, from your description I understand that you already have a MySQL database and you only need a backend interface to interact with it. I can create a web or desktop application, as you prefer, using latest Microsoft technologies. I created and managed database with millions of records for sport scores and trading companies, so I know whish could be the issues related to managing such quantity of data. Please visit my profile I think you will find some interesting thing about me. Best regards Armando. Please send me more details about your database.

A proposal has not yet been provided

Hi, I am Didarul Islam, a Zend Certified Engineer, from Unity Solutions of Bangladesh. We can do the job within 30-35 working days. working days count must be you supply all require document. If you award us the job, you will get the following benefits: 01. We will provide you a minimal working demo within 25 working days without any payment from your side. If you like the demo then you can finalize the job with us/ cancel the award. 02. We will provide you 1 month free service after the job delivery without any payment. Hope to work with you. Thanks. Didarul Islam for Unity Solutions of Bangladesh

Hello, I am IT engineer since 2005 Certified as Technical specialist in SQL SERVER BI , i have more than 7 years in IT projects with 5 years in database and Business intelligence development on several multinational IT companies as BI senior Consultant working on several database types (Microsoft SQL Server ,MYSQL ,Oracle) I will guarantee you satisfaction and professionalism with high quality of project delivery within budget and deadlines as i made in most of my previous projects. Best Regards

Hello, I'm available to complete your project! For more than 6 years I'm part of a tracking team that is dealing with tables similar to yours (50-100M rows per month, each row containing up to 10 properties); using the information from these tables we deliver analytic reports to our clients in a various formats and metrics. So I think I have the expertize to help you on this project. Without seeing your tables structure my plan may be so: - optimize the table structure; optimize each field type to the minimum required - separate as much you can the INSERTS vs SELECT the same entity (db table) - create aggregates with the most requested data in reports and use it instead of doing queries on live tables - archive historical / not used / not neccessary data and keep only relevant info for reporting Best regards,