Fermé

Develop software

The following system which I want to be developed should not be copied from other existing system. After development, it should not be sold to anyone else.

Index Advisor System:

• Create the GUI interface system using Java language with following functionalities.

o Inputs :

 The system will allow user to select postgreSQL database name (database should be big with huge data like database of any e-commerce application) from drop down list boxOn the basis of selected database, it will display all tables within this database  User will select all/some tables from displayed tables.

 Now, system should automatically take following as inputs to analyze the existing indexes and suggest new indexes which will improve the transaction performance.

• Current and previous workload related to these tables from the log files

• Constraints and indexes created on these tables.

• Generate standard queries for these tables using TPC-H or any other TPC benchmark. Frequency (how many times they are going to be executed) of these queries.

• Read and write operations (DML statements) executed for these tables with frequency.

• Required statistics from data dictionary.

o Process :

 Develop an algorithm (develop new algorithm or modify existing algorithm) which will analyze the existing indexes and give suggestions for revised indexes which will improve performance of concurrent transactions.

o Outputs :

 Analyze and suggest improved indexes for selected tables.

 Show comparison of performance before and after applying the suggested indexes. It should be represented graphically.

 Suggest improved table design(if any)

 Suggest improved DML or select statements.

Note : For the selected database, the concurrent transaction execution should be improved after applying suggestions from this system. The system should be generalized. i.e., it should give suggestions for any postgreSQL database.

Compétences : Administration de Bases de données, Java, PostgreSQL, Développement de logiciel

Voir plus : emv software write read, develop software paypal, develop software drink list, develop software caf, develop software welding transformer, needed develop software iphone, optical develop software, develop software users guide, write read xml php, kosice develop software, cms write read xml, write read file program

Concernant l'employeur :
( 0 commentaires ) mumbai, India

N° du projet : #14827028

13 freelance ont fait une offre moyenne de 41037 ₹ pour ce travail

7368 ₹ INR en 35 jours
(74 Commentaires)
6.7
7777 ₹ INR en 3 jours
(46 Commentaires)
6.3
esalem

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. Relevant Skills and Experienc Plus

396842 ₹ INR en 45 jours
(4 Commentaires)
6.0
liangjongai

Hi! I'm interesting your project very well. I am mastering Java and I'm a good Mathematician. And also I have many experience and good skill about SQL. Let's go ahead with me Proposed Milestones ₹10000 INR - I am mas Plus

10000 ₹ INR en 3 jours
(70 Commentaires)
5.4
neerajagrawal201

Hi, We are serving in the field of Website & Software Design, HTML, CSS, Java, PHP, C#, javascript, bootstrap, angular.js, .NET, SQL, Biometrics, Android native/hybrid, since 2015. We also started providing service in Plus

9900 ₹ INR en 5 jours
(39 Commentaires)
5.0
anuragiitk

I am an IITK graduate and I have 9 years of experience in software development. I have 100% completion rate and I have finished all the projects with the highest level of customer satisfaction. Relevant Skills and Exp Plus

11111 ₹ INR en 3 jours
(17 Commentaires)
5.1
sandstromlx

https://www.freelancer.com/hireme/sandstromlx Relevant Skills and Experience https://www.freelancer.com/hireme/sandstromlx Proposed Milestones ₹7777 INR - https://www.freelancer.com/hireme/sandstromlx https://www.fr Plus

7777 ₹ INR en 3 jours
(1 Commentaire)
0.9
7777 ₹ INR en 3 jours
(0 Commentaires)
0.0
poojamathur0802

a Relevant Skills and Experience a Proposed Milestones ₹8888 INR - a a

8888 ₹ INR en 3 jours
(0 Commentaires)
0.0
7777 ₹ INR en 3 jours
(0 Commentaires)
0.0
brillbrains4

Hello there, Greetings of the day, Hope you doing great! I completely understood your requirement. I'm ready to work with you. Can we discuss further in brief? I would like to discuss this project with you. It will b Plus

39382 ₹ INR en 20 jours
(0 Commentaires)
0.0
7777 ₹ INR en 30 jours
(0 Commentaires)
1.9
SDgyansolution

I can do your project. I have done many similar projects and I can give you exactly what you desire. I have the capability of doing your project within your budget and within the given time frame. Relevant Skills and Plus

11111 ₹ INR en 3 jours
(0 Commentaires)
0.0