Stack Overflow
Stack Overflow

Questions tagged [synonym]

Synonym is a word or phrase that means exactly or nearly the same as another word or phrase in the same language.

Synonym is a word or phrase that means exactly or nearly the same as another word or phrase in the same language.

For more information read the Wikipedia page.

508 questions
12
votes
1 answer

Entity Framework Code First with SQL Server Synonyms

I have the situation where I will have multiple companies accessing a single instance of my application, but I need to segregate their data to avoid accidentally loading data for another company, and to ease per-company database backups. Ideally,…
Matt Wilson
  • 8,159
  • 8
  • 33
  • 55
11
votes
3 answers

Best way to store and retrieve synonyms in database mysql

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…
Jerry2
  • 2,955
  • 5
  • 30
  • 39
11
votes
2 answers

Elasticsearch synonym analyzer not working

EDIT: To add on to this, the synonyms seem to be working with basic querystring queries. "query_string" : { "default_field" : "location.region.name.raw", "query" : "nh" } This returns all of the results for New Hampshire, but a "match"…
Erica Stockwell-Alpert
  • 4,624
  • 10
  • 63
  • 130
11
votes
2 answers

Performance effect of Synonyms over a linked server in SQL Server

On localserver (a SQL Server 2008 R2), I have a synonym called syn_view1 pointing to the linked server remoteserver.remotedb.dbo.view1 This SLOW query takes 20 seconds to run. select e.column1, e.column2 from syn_view1 e where e.column3 = 'xxx' …
François-Xavier
  • 111
  • 1
  • 4
11
votes
1 answer

Is there way to boost original term more while using Solr synonyms?

For example I have synonyms laptop,netbook,notebook in index_synonyms.txt When user search for netbook I want to boost original text more then expanded by synonyms? Is there way to specify this in SynonymFilterFactory? For example use original term…
yura
  • 14,489
  • 21
  • 77
  • 126
10
votes
2 answers

Entity Framework and SQL Server Synonyms

Hasty research tells me that even EF4 still doesn't support SQL Server synonyms. What are my options for setting up a synonym based entity set as if it were a table based entity set? The crudest I have come up with is to copy the underlying table…
ProfK
  • 49,207
  • 121
  • 399
  • 775
10
votes
3 answers

Create synonym to all tables in a different database with a script

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…
Haoest
  • 13,610
  • 29
  • 89
  • 105
10
votes
2 answers

Is there a T-SQL command that checks whether the object to which a synonym refers exists and is valid?

I'm trying to test if all synonyms on a database refer to valid objects, using the SQL batch script below, as part of a clean-up effort on our databases. This script just performs a query against the synonym, and printing out any errors it…
JustinP8
  • 1,353
  • 1
  • 14
  • 33
10
votes
4 answers

SQL Server Table Synonyms with Indexes

I have multiple databases on a single instance of SQL Server 2005. I've created a synonym on one database to access a table on another database and when writing my queries, I'd like to utilize a specific index, however, when evaluating the…
Jarred Froman
  • 171
  • 2
  • 8
10
votes
1 answer

shortest synonym for default value

Seeking the shortest synonym for use as a variable name, which means the "default value". There is an option: "want" (from dict.org) But it somehow looks strange. Maybe someone knows a better solution, or would just like to know the opinion of…
user1633548
  • 99
  • 1
  • 5
10
votes
3 answers

Edit synonyms in MS SQL Server 2005

Out of curiousity, is there any way to edit an existing synonym? That is, change which table the synonym is pointing to... Thus far I seem to have had to delete and re-create them, because they're locked from being edited. It's not a big deal,…
Margaret
  • 5,749
  • 20
  • 56
  • 72
9
votes
3 answers

Oracle: is it possible to create a synonym for a schema?

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…
AJ.
  • 13,461
  • 19
  • 51
  • 63
9
votes
1 answer

create synonym ora-01031 insufficient privileges

I need help understanding what grants/privileges a user needs to CREATE a SYNONYM when it points to another (different) schema object. When I try the below, I get ora-01031 insufficient privileges, so obviously I am missing and failing to apply…
BBALEY
  • 183
  • 2
  • 2
  • 7
8
votes
1 answer

elasticsearch multi-word keyword-tokenized synonym analysis

I am trying to get keyword-tokenized multi-word synonyms working with the _analyze API. The API is returning expected results for single-word synonyms, however, not for multi-word ones. Here is my settings and analysis chain: curl -XPOST…
Jeff
  • 228
  • 2
  • 9
8
votes
3 answers

Multi word synonyms in solr

I'm trying to implement multi-word synonyms in solr, specifically of the type msc divina => divina So, if a user enters "msc divina", solr should return results for "divina" only. The definition in schema.xml looks like this:
midnig
  • 183
  • 5
  • 16
1
2
3
…
33 34