Writing a Neo4j query

£10-20 GBP

Đã đóng

Đã đăng vào

khoảng 5 năm trước

£10-20 GBP

Thanh toán khi bàn giao

You will be provided with a UML diagram (see attached) as well as SQL query. The goal is to write the Neo4j equivalent of the given SQL query, that aims to answer the following question: Which Drugs are in a relationship with a Gene that is in a relationship with a Protein which has a relationship with another Protein where minimum positivity is 0.8 and minimum identicality is 0.85, and that other Protein is in a relationship with a Gene that has a relationship with the Disease "Asthma"? Although not a deliverable, in order to come up with the Neo4j query, you'd need to remodel the UML diagram to follow the property-graph model. The only deliverable of this task is a functional and tested Neo4j query that achieves the same result as the provided SQL query.

Database Development

SQL

Mã dự án: 18872985

Về dự án

5 đề xuất

Dự án từ xa

Hoạt động 5 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

5 freelancer chào giá trung bình £20 GBP cho công việc này

@jayantavkumar

Before migrating query into SQL, yes definitely you should change the diagram. As I can see there are few entities which has many to many relationship. For those case we should create association table to resolve the normalization issue. Let me know if you wanted to continue to discuss further. Meanwhile please go through my technical background: • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, Javascript, ASP.Net with C# language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;

£23 GBP trong 1 ngày

5,0

(17 nhận xét)

4,6

@akshayatm

Hi Sir, I am an experienced software developer expert in java ,j2ee , spring, hibernate orm, webservices,xml xslt, db like technolgies.I am an expert in spring boot, REST API, Soap.I am experienced in openapi , swagger implementation.I am experienced in neo4j , cypher query . pls visit my profile for similar past works and feedback. I can do this. pls contact for further progress.

£20 GBP trong 2 ngày