Đã Đóng

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.

Kỹ năng: Quản trị cơ sở dữ liệu, Java, PostgreSQL, Phát triển phần mềm

Xem thêm: 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

Về Bên Thuê:
( 0 nhận xét ) mumbai, India

Mã Dự Án: #14827028

13 freelancer đang chào giá trung bình ₹41037 cho công việc này

₹7368 INR trong 35 ngày
(74 Đánh Giá)
₹7777 INR trong 3 ngày
(46 Đánh Giá)

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 Thêm

₹396842 INR trong 45 ngày
(4 Đánh Giá)

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 Thêm

₹10000 INR trong 3 ngày
(70 Đánh Giá)

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 Thêm

₹9900 INR trong 5 ngày
(39 Đánh Giá)

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 Thêm

₹11111 INR trong 3 ngày
(17 Đánh Giá)

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 Thêm

₹7777 INR trong 3 ngày
(1 Đánh Giá)
₹7777 INR trong 3 ngày
(0 Đánh Giá)

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

₹8888 INR trong 3 ngày
(0 Đánh Giá)
₹7777 INR trong 3 ngày
(0 Đánh Giá)

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 Thêm

₹39382 INR trong 20 ngày
(0 Đánh Giá)
₹7777 INR trong 30 ngày
(0 Đánh Giá)

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 Thêm

₹11111 INR trong 3 ngày
(0 Đánh Giá)