Kapalı

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.

Beceriler: Veri Tabanı Yönetimi, Java, PostgreSQL, Yazılım Geliştirme

Daha fazlasını görün: 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

İşveren Hakkında:
( 0 değerlendirme ) mumbai, India

Proje NO: #14827028

13 freelancer bu iş için ortalamada 41037₹ teklif veriyor

in 35 gün içinde7368₹ INR
(74 Değerlendirme)
6.7
in 3 gün içinde7777₹ INR
(46 Değerlendirme)
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 Daha fazlası

in 45 gün içinde396842₹ INR
(4 Değerlendirme)
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 Daha fazlası

in 3 gün içinde10000₹ INR
(70 Değerlendirme)
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 Daha fazlası

in 5 gün içinde9900₹ INR
(39 Değerlendirme)
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 Daha fazlası

in 3 gün içinde11111₹ INR
(17 Değerlendirme)
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 Daha fazlası

in 3 gün içinde7777₹ INR
(1 Değerlendirme)
0.9
in 3 gün içinde7777₹ INR
(0 Değerlendirme)
0.0
poojamathur0802

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

in 3 gün içinde8888₹ INR
(0 Değerlendirme)
0.0
in 3 gün içinde7777₹ INR
(0 Değerlendirme)
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 Daha fazlası

in 20 gün içinde39382₹ INR
(0 Değerlendirme)
0.0
in 30 gün içinde7777₹ INR
(0 Değerlendirme)
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 Daha fazlası

in 3 gün içinde11111₹ INR
(0 Değerlendirme)
0.0