473,466 Members | 1,376 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

The best DB strategy in my case

Hello,

I would like to ask some opinions on the best DB strategy for the
following problem:
I have a table containing information about artists (names, dates,
descriptions in three languages etc). The full-text index is put on 16
fields.
A user can select records to have access to (like favorite artists).
There are two possible full-text searches: through the whole table and
only within user's records.

The queries are like:

[1] SELECT some_fields, MATCH(index_fields) AGAINST (search_phrase) as
score FROM artists ORDER BY score LIMIT 1000

and

[2] SELECT some_fields, MATCH(index_fields) AGAINST (search_phrase) as
score FROM artists WHERE artist_id IN (users_artists_ids) ORDER BY
score LIMIT 1000

Now I would like to have a versioning capability in my system - that
is every record may have different versions.
The main search (first query [1]) should be done only through the
versions marked as current.
User's favorite records may be ones of current version and some that
are outdated.
The user search (second query [2]) should go trough user's favorite
records.

Here are my questions (about the DB strategy):
1) Should I keep all records (current and outdated ones) in one table.
Doesn't it have influence one the indices and therefore the score
(MATCH AGAINST)?
2) If I keep current versions in one table and other ones in a second
table I assume the main search [1] will work as it works now and I
would have to modify the second query [2] to use the JOIN statement,
right?
What is the best solution?

Thank you for hints. I hope I'm clear enough.

best regards, cyprian

Feb 21 '06 #1
0 1141

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Binoy | last post by:
Hello, I am new to .NET, so if my questions is dumb, please excuse me. We are moving our ASP model site to ASP.NET and I would like to know the best deployment strategy that we can use (we...
3
by: syncman | last post by:
I think there are 2 options for how to implement the Strategy pattern. One is to use polymorphism; derived classes have the same interface and can be plugged in. The other is to use templates:...
4
by: Claudio Jolowicz | last post by:
I am trying to find a solution to the following design problem (code at the bottom): We are implementing a trader agent that can trade with other traders on an electronical trading platform. To...
136
by: Matt Kruse | last post by:
http://www.JavascriptToolbox.com/bestpractices/ I started writing this up as a guide for some people who were looking for general tips on how to do things the 'right way' with Javascript. Their...
4
by: Steve Jorgensen | last post by:
I'm restarting this thread with a different focus. The project I'm working on now id coming along and will be made to work, and it's too late to start over with a new strategy. Still, I'm not...
6
by: Daniel Santa Cruz | last post by:
Hello all, I've been trying to go over my OO Patterns book, and I decided to try to implement them in Python this time around. I figured this would help me learn the language better. Well,...
2
by: Petr Jakes | last post by:
I am a little bit confused by all possibilities for exceptions handling in Python (probably because I am not skilled enough??) I did try to search trough this list and reading Python tutorial about...
52
by: burgermeister01 | last post by:
First, let me say that this question is a rather general programming question, but the context is PHP, so I figured this group would have the most relevant insight. Anyways, this is also more of...
2
by: Gabriel | last post by:
Hello, I'm looking for documentation with "Best Practice" for ASP.NET application In which case use Connected or Disconnected mode Typed dataset or not ? I didn'd find anything pertinent...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.