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.
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.
16 freelance font une offre moyenne de $407 pour ce travail
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
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
Having very good experience in writing the queries, if you provide the complete information, will do it. Regards.
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 [login to view URL] we are new Plus
Hi i have more than 7 years of experience. I can do this within define timelines. I am new on freelancer.
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.
Being New I am interested in proving myself.I have about 9 + years of experience in DB development