Fermé

TSQL Stored proc / View required for adjacency tree

Overview:

We run an in house created CMS with a flexible tree structure to create URL’s and lists of pages.

It uses the adjacency list model to represent the tree in SQL 2008. It was started this way back on SQL 2005, and uses a simple parent / id relationship.

We currently generate a number of pieces of data to work with the tree after we have gathered the data from SQL. The issue with this is that when the tree gets large, we transfer more data than we need to the application because we need it all to be able to create the required information.

We have the ability to extend this data model in any manner we please using a series of tables to define data types and data saved against the content. We currently change these rows of data into columns in the application.

Because the data set can grow to be large and we are going all this work on the application side, this is now creating an issue, and we see the opportunity to have this data generated in SQL and saved in a View so that it is kept up to date by SQL Server.

Deliverable:

Design and implementation of a SQL 2008 Stored Procedure / Function that can be executed to select the data required with 3 extra fields on the query result for Depth, URL, and ParentList. It should also select the custom data to produce new columns populated with data based on the extension tables. Ideally this could be implemented into producing the data to a view so the data is cached on the SQL side.

Please PM me for a DB diagram and a Full brief.

Compétences : SQL

Voir plus : sql tree adjacency list, work view, view work, view more, uses tree data structure, uses data structure, types tree data structure, types data structure, tree types data structure, tree structure, tree query, tree data structure using, tree house design, tree data structure types, relationship tree, lists data structure, implementation data structure, depth tree data structure, define tree data structure, define structure, define data structure, data structure uses, data structure types, data structure tree types, data structure implementation

Concernant l'employeur :
( 3 commentaires ) Surry Hills, Australia

N° du projet : #1053209

16 freelance ont fait une offre moyenne de 407 $ pour ce travail

eperfections

We have strong grip on databases specially SQL Server. We have written stored procedures for large billing applications. Please provide database diagram with more explanation. We are suitable candidates for this projec Plus

250 $ AUD en 1 jour
(67 Commentaires)
5.9
subratparida

Please see my PM.

400 $ AUD en 5 jours
(2 Commentaires)
3.8
DeoTech

Hi! Kindly see PM! Regards.

400 $ AUD en 7 jours
(4 Commentaires)
3.5
mystic19

Check PM, please

250 $ AUD en 7 jours
(4 Commentaires)
3.3
guevanjr

Ready to start.

250 $ AUD en 0 jours
(3 Commentaires)
2.5
SSystems

Hi, Please check PM. Thanks

250 $ AUD en 1 jour
(0 Commentaires)
0.0
eirikureiriksson

Hi, bid details are in the PM.

700 $ AUD en 5 jours
(0 Commentaires)
0.0
bmircea

Please check PM

550 $ AUD en 5 jours
(0 Commentaires)
0.0
eitguru

I have 12+ year experience with development and optimization of Database object like Stored Procedure, SQL Statements, Views, etc. I have majorly worked on User based menu that generated from SQL Server and consumed Plus

500 $ AUD en 5 jours
(0 Commentaires)
0.0
kishore2903

Having very good experience in writing the queries, if you provide the complete information, will do it. Regards.

700 $ AUD en 10 jours
(0 Commentaires)
0.0
abdullah88

Dear sir After reading your project details,we are interested in this project and would like to bid on this project. we take care of our every client personally and has always long term relationship.Although we are new Plus

400 $ AUD en 40 jours
(0 Commentaires)
0.0
RohitashBansal

Hi i have more than 7 years of experience. I can do this within define timelines. I am new on freelancer.

360 $ AUD en 5 jours
(0 Commentaires)
0.0
GoodDBA

I have 12 + yrs It experience, I am very strong database design and development. I do like you to work with you on long term basis.

250 $ AUD en 1 jour
(0 Commentaires)
0.0
raguvenkat

Being New I am interested in proving myself.I have about 9 + years of experience in DB development

250 $ AUD en 7 jours
(0 Commentaires)
0.0
SlickSystems

Hi, I have sent you a PM regarding my bid for this short piece of work.

500 $ AUD en 4 jours
(0 Commentaires)
0.0
askids

Please see PM for details.

500 $ AUD en 6 jours
(0 Commentaires)
0.0