.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Relationship between terms

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :Sql Server

Hello Everyone,

I have multiple TB of documents loaded in a sharepoint site.

I want to find out what are the key terms for each domain (team site) and the relationship between the key terms.

I do run some sort of data mining algorithm to get this?

View Complete Post

More Related Resource Links

An Entity Relationship Diagram Example

An Entity Relationship Diagram conveys a lot of information with a very concise notation. The important part to keep in mind is to limit what you're reading using the following technique:

Choose two entities (e.g. Company and Employee)
Pick one that you're interested in (e.g. how a single Company relates to employees)
Read the notation on the second entity (e.g. the crow's feet with the O above it next to the Employee entity).

Good way to do a Many-to-Many relationship?


I've used the automatic  Many-to-Many generation as described here: http://msdn.microsoft.com/en-us/library/dd742359.aspx

But that doesn't seem to allow a quantity to be attached to orders (in the example it would be courses). I have many customers and many products, I would like a customer to be able to order more than one product. Right now I get a grid of checkboxes. I would like instead a field where I could enter a number. 

Is this possible?

Command Management: Use Design Patterns to Simplify the Relationship Between Menus and Form Elements


In Windows Forms applications, similar commands, such as those in a menu and their counterparts on a toolbar, are not automatically related. They don't fire the same event or run the same handler routine. Yet code that allows the same or similar user commands to fire the same code simplifies development.This article describes the principles of command management and why it's important to have functional commands that are not exclusive to any one UI element. In order to provide an MFC-like command management infrastructure, a design pattern is developed and applied as a series of C# classes.

Michael Foster and Gilberto Araya

MSDN Magazine October 2002

In a style template, express a property in terms of the controls properties it is applied to.

Hello,   In the style template below, which works fine, I'd like to express the "Points" property in terms of the applied to controls "Width" and "Height" properties.  As you see, the "Fill" property is expressed in terms of the "Background" property the template is applied to by means of Fill="{TemplateBinding Background}".  The following does not work:   Points="0,({TemplateBinding Height} / 4)  ({TemplateBinding Width} / 12.5),({TemplateBinding Height} / 4) . . ."   Is what I'm looking for possible, all in XAML, no code/converters? <Style x:Key="FolderButton" TargetType="Button"> <Setter Property="Margin" Value="2.5" /> <Setter Property="Template"> <Setter.Value> <ControlTemplate TargetType="{x:Type Button}"> <Grid> <Polygon Fill="{TemplateBinding Background}" Stroke="{TemplateBinding BorderBrush}" Points="0,5 4,5 6,0 23,0 25,5 50,5 50,20 0,20"/> <ContentPresenter HorizontalAlignment="Center" VerticalAlignment="Center"/> </Grid> </ControlTemplate>

Relationship between a dimension - two fact tables

I have 3 fact tables and about 10 dimensions. I want to relate both "Fact_Pop1" and "Fact_pop2" to Dim_AgeGroup. But Fact_pop1 has single age group and Fact_pop2 has no single age group (5 years age group). I spent about a day on this but I could't solve it.   Fact_Pop1 Age        Race_key            Gender_key      Geography_key              Pop_size 10           White                    M                                            CA                          10000    10           White                    F        

How to return the results of a 1 to Many Relationship

A co-worker of mine just came back from a SQL Server Reporting Services class (we are using SQL Server 2005). In that class they were told that if they had a one to many relationship that they would have to flatten the results into one row of the resultset in order to show the 'many' portion of the relationship.  For example, my company has two tables: Jobs Notes/Memo's For each Job we can have 0 or more Notes/Memo's. According to my co-worker the Report Server must have each of the Notes/Memo's in one row of the resultset.  That we therefore have to flatten the list of Notes into Note1, Note2, Note3...etc fields.  Is this correct?  How would I handle a situation where I didn't know how many Notes there were? Thanks so much.

Parent-Child relationship on a Type 2 (SCD) Dimension

For a Type 2 slowly changing dimension (SCD) such as Employee with a Parent-Child relationship, how do you handle the explosion of new rows when a high ranking employee has an attribute change?   It will require terminating the high ranking employee row and adding a new current row with a new surrogate key. Then every employee row below this employee will also have to be terminated and a new current row added with the new surrogate key of the parent.   This will have to be performed 1 level at a time so the subordinate rows will have the new surrogate key of their immediate parent.   For a large organization such as 20,000 employees, this will result in a dimension with hundreds of thousands rows in a relatively short time.   Is there a better way to model this?

Select random 10 records in sql server 2005 in terms of time

Hello,i have a query that select random records in access database in terms of time : "SELECT TOP 10 * FROM Tbl ORDER BY Rnd(-10000000*TimeValue(Now())*[ID])"now i wish to convert this query for using in sql server 2005 such that return random records in term of time 

Relationship between Search Results and permissions

Is it true that if your account did not have permission to a document library before a crawl occurred, you will not see it in a search result - even after you are given access to the documents? Here's a sequence of events to clarify the scenario: Crawl completed on DocLib1. User1 do not have access to DocLib1. No results when doing a search. User1 is given access to DocLib1. Question : Will User1 see the results when doing a search on DocLib1? Another Crawl completed on DocLib1. User1 will see the search results now on DocLib1. Does this mean a user must have access PRIOR to the crawl to be able to view it in a search? Anyone experience this scenario before? Thanks.

Many-To-Many table relationship and model.edmx

Hello,I'm having a weird problem with the database model as it seems. I have 3 tables (posts, taggedpost, tags) and when I create the model the relationship is correctly identified as a many-to-many but the linking table is gone.Instead, VS2010 creates only 2 tables, and maps 'tags' as a "Navigation Property" of 'content' and vice versa.So problem is, I need to query for posts that have a specific tag. The best I have gone so far is to query for all posts that have at least one tag and fetch them then programatically filter them, but I want the optimal which is to select them all at once.

When adding a colleague, can I add a reciprocal relationship back?

Hi there,   I'm after functionality 'like facebook' (that must be a common phrase) I.e. when User A adds User B as a colleague, A is B's friend and most importantly B is A's friend   When I make a custom web part to show A and B their friends, they should both be on it.   The problem is if A requests B's friendship, B accepts and I forge a colleague link between B and A - that's fine, B can see A as a colleague   But, how can I tell from A that B is a colleague? ColleagueManager.IsColleague() returns true e.g. A.Colleagues.IsColleague(B) == true but B is not in A's Colleagues list (assuming two people only, A.Colleagues.GetItems().Length == 0)   The solution i've come up with is once B has accepted the 'friend request' in my own custom acceptance system, I create a UserProfile object for A and attempt to forge the link back (code below) - this however causes an UnauthorizedAccessException on the penultimate line - what am i doing wrong? Have i missed some vital part of the colleagues system? All help appreciated!   if (not already colleagues):   SPSecurity.RunWithElevatedPrivileges(delegate()                 {                     // Add the colleague relationship &

Relationship to One of Several Tables

I'm building a website that has several areas where comments are allowed (general topics, activities, groups, etc.). I know I can create separate tables for each comment type. But I'm thinking it would be nice to be able to create one comment table that is used for all comment types. That would mean that, for any row in the comment table, it would be linked to one of several different tables. Some possible ways of approaching this include: 1. Include multiple foreign-key columns in my comments table. Only one would be used and the rest would be NULL. (All would be indexed.) 2. Have a single column that contains a foreign-key value and another column that indicates the comment type. In this case, there would be no relationship constraints established in the database. It would simply be enforced by my code. To get comments related to, for example, a specific activity, I would use something like WHERE ComParentID = @ActivityID AND ComType = TypeActivity. I'm not sure if this approach makes much sense. Perhaps someone could comment which of these approaches sound better, or suggest a different approach altogether. Thanks.Jonathan Wood • SoftCircuits • Developer Blog

Insert-Update to SAP from SharePoint - Best Approach in terms of development and deployment

Hi, I am having a requirement where I need to design and develop a workflow solution that interacts with the SAP to insert/update the data. Here are few questions that I am looking for some guidance... 1) If I develop the Insert-update operations using BCS and a web-service (or WCF) in SharePoint designer, how to use it with workflow ? Also , the stuff that is configured using SharePoint designer , how to deploy it on Staging and Production? 2) If the above approach has quite a few limitations, then what should be the best approach for such requirement?   Thanks.  

Is it possible to create attribute relationship across multiple dimensions?

In other data warehouse tools such as Microstrategy, you can create attribute relationship between different dimensions easily. For example, I can define a joint-child relationship(Attr1 from Dim1, Attr2 from Dim2) decide Attr3 from Dim3. In another word, if it is in a natrual hierarchy, it is                                   Attr3                                      |                             (Attr1, Attr2) If we can build such kind of relationship, first Attr3(dim3) is not necessary to appear in fact table. Second, if query without fact data, you can simple pull out Attr1, Attr2 and Attr3 relationship. Is it possible to make such kind of relationship in SSAS? If not, I think put Dim3 in fact table should be an alternative way to relate Attr1, Attr2 and Attr3.    

Many Parents Many Children relationship


OLAP - I have in RDBMS(Data Warehouse) -  ParentId and ChildId are TypeId's

ParentId and ChildId have many to many relationship. One parent can have many children(TypeIds) and same way One ChildId can have multiple parents(TypeIds)

Table A
TypeId (PK)

Table B

TypeId (FK)

How will I design a OLAP solution for these tables - what are my dimension and its hierarchy?

I want to display for All Parents->All Children->Measure(Values), DateTime


Custom Page Template (List.aspx) - one to many relationship


Hi, I have two tables which is Customer and Customer Details table, with one to many details.

Is there possible to show Child table's column in (done in one GridView) Customers/Lisp.aspx?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend