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.

Færdigheder: Database Administration, Java, PostgreSQL, Software Udvikling

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) mumbai, India

Projekt-ID: #14827028

13 freelancere byder i gennemsnit ₹41037 for dette job

₹7368 INR in 35 dage
(74 bedømmelser)
₹7777 INR in 3 dage
(46 bedømmelser)

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 Mere

₹396842 INR in 45 dage
(4 bedømmelser)

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 Mere

₹10000 INR in 3 dage
(70 bedømmelser)

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 Mere

₹9900 INR in 5 dage
(39 bedømmelser)

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 Mere

₹11111 INR in 3 dage
(17 bedømmelser)
sandstromlx Relevant Skills and Experience Proposed Milestones ₹7777 INR - Mere

₹7777 INR in 3 dage
(1 bedømmelse)
₹7777 INR in 3 dage
(0 bedømmelser)

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

₹8888 INR in 3 dage
(0 bedømmelser)
₹7777 INR in 3 dage
(0 bedømmelser)

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 Mere

₹39382 INR in 20 dage
(0 bedømmelser)
₹7777 INR in 30 dage
(0 bedømmelser)

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 Mere

₹11111 INR in 3 dage
(0 bedømmelser)