Hi, I have a situation where by i have a catalog on Server A, and a same named Catalog on Server B. I'm using synonyms on Server B so that some tables are actually just going through to server A. Such that, calling select * from ServerB.Table, is actually returning Data from ServerA.Table transparently. This seems to work fine when ...
Hi all, Can someone shed some light on how searching is done on web-sites like del.icio.us? If I enter "js"(1), "javascript"(2) or "java script"(3) as my query on delicious, I'm pointed to resources about Java Script. However, depending on the query the returned result sets are different(del.icio.us system returns different set of boo...
If I have two databases and create a linked table (synonym) in one of them to the other one and then wrap that synonym in a view, will there be a performance issue? The reason I want to do this is to have SQLMetal see the synonym and generate a linq entity for it. The database are on the same server. Also if I did this 100+ times, all...
I tried exec sp_depends @objname = 'sfel.elpc' but I did not get any results, but I know the synonym is referenced in at least one stored procedure. ...
I am trying to convert a package from 2005 to 2008 and am running into some rpblems that seem to be related to synonym lookups. This worked fine in 2005 but for some reason is breaking in 2008, thanks for any assistance. Here is the error text: =================================== Error at Update Existing Assets [Lookup Asset to Make ...
I've got the syntax down but I'm wondering if somebody can provide an illustrative use case where database synonyms are very useful. ...
Im writing a php script to compare the similarity of 2 strings. This works pretty good at the moment, but what I would like to do is match words when one is a synonym of the first. Any thoughts? ...
Is there any api/lib for python that will get me the synonyms of a word? For example if i have the word "house" it will return "building, domicile, mansion, etc..." ...
Hi Guys, This is probably incredibly simple, but I just cant see the wood for the trees at the moment. For brevity, I would like to model a word object, that has related words to it (synonyms), In doing so I could have the following mappings: <class name="Word" table="bs_word"> <id name="Id" column="WordId" type="Int32" unsaved-value=...
Hi! Can anyone say Materialized view and Synonyms PROS and CONS? Best regards, Kristaps ...
I'm developing a Java web application that uses Hibernate (annotations-based) for persisting entities to an Oracle 11g database. The DBA created synonyms for the tables and requested that I use these synonyms instead of the physical tables. (Eg: Table "Foo" has synonym "S_Foo") If I have "hibernate.hbm2ddl.auto=validate" enabled, then ...
We've just switched to synonyms for linked server stuff, and noticed that our FOR XML output is no longer correct. When returning XML results from a view, we could alias the view and that would be assigned as the element name. With synonyms, however, it seems to ignore the alias? We're still mostly on SQL 2005 - this bug doesn't seem ...
That way if I search for the term "mens" the term "gentlemen" will match. I tried this: SELECT * FROM cart_product WHERE MATCH ( product_name, product_description, product_brand, metal_type, primary_stone, product_type, product_type_sub, product_series, primary_stone_sub ) AGAINST ( 'THESAURUS "english" EXPAND SYNONYM TERM OF "gentlem...
Hello, Would anyone know of a way to extract Google Synonyms, either through their API or other (TOS-approved) methods? Specifically, Google have a function that allows you to type a tilde sign "~" in front of a word to conduct a search with synonyms. As opposed to the search results, I'd like to extract the actual synonym data - so f...
Hello, I would like to be able to show in my UI what the query terms were that solr used to run the final query. For example, I might type the query "run" but behind the scenes solr will use stemming to also query "ran" and "running", I may also have a synonym defined which has "run = sprint". I would like to show the user that although...
Hi SQL Server gurus, Is there an easy way to create synonyms to all tables in a different database? thanks EDIT: I have a number of stored procedures that hardcoded some table schemas into the select queries. When I copy the schemas to a new server, the SPs fail because the schema doesn't exist. There is little control I have over the...
Is there a source where I can download a text file that has a large collection of synonyms and correct spellings? ...
Firstly I am an oracle newbie, and I don't have a local oracle guru to help me. Here is my problem / question I have some SQL scripts which have to be released to a number of Oracle instances. The scripts create stored procedures. The schema in which the stored procedures are created is different from the schema which contains the ...
As part of a contact management system I have a large database of names. People frequently edit this and as a result we run into issues of the same person existing in different forms (John Smith and Jonathan Smith). I looked into word similarity but it's easy to think of name variations which are not similar at all (Richard vs Dick). I w...
I am making a synonyms list that I will store it in database and retrieve it before doing full text search. When users enters like: word1 I need to lookup for this word in my synonyms table. So if the word is found, I would SELECT all the synonyms of this word and use it in the fulltext search on the next query where I contruct the que...