Hello all,

and apologies if this isnt the correct group for posting this.

I am new to sql, and the thin background I have is MS Access and MS Exel, used in the past.

I have been reading this newsgroup for some time, but looks like everyone that has problems already have database structures :)

The (non commercial) data retrieval system I have in mind would serve to help in
answering system related troubles around MS windows operating systems.

I can splitup the application as follows:

1. A server background program that collect info from a newsgroup

2. Collected header data needs to be 'cooked' as to 'uniformize' the key(s) to search on later
ex: Windows wont boot, Win98 cannot bootup, cant bootup windows, etc need to point to a single cel.
AFAIK the standard wild characters in a query cannot handle this.
This cell should then be able to reference multiple responses.

3. Users would be able to enter a 'search for' sentence (google style) on my site, search the database and return appropriate results.

The far most cripple part in all this is the 'cooking' process, interpreting what people think :)

Im not totally unexperienced with HTML, vbscript, JScript, and asp, but i would appreciate some input how to design
a working construction of interacting databases serving this project.

Thank you for your time and effort.

--
Windows98 links to solutions http://jake98.no-ip.info
Replies in the same thread please

So what benefit will this offer over Google? Since they archive about a
billion NG posts right now you've got quite a bit of work to do to catch up!
Good luck!

--
David Portas
SQL Server MVP
--

David,

Thanks for your reply.

There are a few benefits:
1. I want to experience building that application and update my old programming skills
(I have survived assembler, fortran, and a few more things on different platforms)
2. When the system works, it would offer an option to directly post back to the newsgroup
a link, to access a 90% sure corrective action to the problem posed
3. The gathered data would serve many, including myself :)

Most obliged if you could get me start reading and thinking :)

--
Windows98 links to solutions http://jake98.no-ip.info
Replies in the same thread please

[quoted text, click to view]

That's valid reason.

[quoted text, click to view]

That's an invalid reason, since Google allows that.

[quoted text, click to view]

Unlikely, but hey, have at it.

But your original question/statement isn't going to help you design
the database schema. You want to create an entity relationship
diagram. For that you'll need a decent book on database design, or at
least a few chapters, but more than a newsgroup post. Once you have a
solid grasp on what data you want and how you want to organize it, the
collecting, formatting and delivery become obvious. Then it's just
coding.

[quoted text, click to view]
programming skills (I have survived assembler, fortran, and a few more
things on different platforms) <<

It is sooo nice to find another old fart around here<g>!

However, SQL is not meant for textbases. What you come up with will a
bigger kludge than the old Fortran accounting packages we had on the
early mini-computers. If you just want a good programming exercise, try
doing an inventory system -- you get to do LIFO, FIFO and other assorted
valuation algorithms, you need check digits, orders, stocking, etc. If
you want some "quickies", then get a copy of my SQL PUZZLES & ANSWERS.

--CELKO--
===========================
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
schema are.

*** Sent via Developersdex http://www.developersdex.com ***

[quoted text, click to view]

well thank you :)
[quoted text, click to view]

1. Google can post a message in the thread in the newsgroup indicating what the problem is?
Freeing others from having to post the same solution again over and over?
2. Why is the newsgroup crowed with messages if Google can answer them?
Note: I *am* a big Google fan too :)

[quoted text, click to view]

That's the real point.
In human terms... the 'thing should read a complete message, condense or summarize it, find keywords,
match them against a database, and further correlate till the result is 1 or 2 items.
In programming terms... I have no idea how to even start searching for info.
Thanks for your consideration

[quoted text, click to view]


--
Windows98 links to solutions http://jake98.no-ip.info
Replies in the same thread please

[quoted text, click to view]

hehe, I've been searching a bit around, and indeed you look somewhat my age :)

[quoted text, click to view]

I really would like doing something on text recognition, and fault tolerant query
Appreciate any help
Thanks Joe

--
Windows98 links to solutions http://jake98.no-ip.info
Replies in the same thread please

[quoted text, click to view]

Yes. You can make NG posts via Google.

[quoted text, click to view]

Because people don't bother to search the archive before they post a
question. That's why people who reply in Newsgroups frequently post links to
previous answers in the archives. Do you think they'll be more likely to
search your system than Google?

--
David Portas
SQL Server MVP
--

[quoted text, click to view]

I meant Google can /automatically/ post a message in the thread in the newsgroup indicating
what the problem is?

See my first reply to you point 2

[quoted text, click to view]

I don't think so, and that's not the exact intention.

The 'thing' in a further stadium should be able to keep the most adequate solutions to posted problems,
discard eventually improper information ,
and /automatically/ post one single link back to where the most obvious solution sits

I am truly aware this wont be easy ...
nevertheless thank you for your inputs David

BTW, come have a look, it might give you a better overview of what I want to do
[quoted text, click to view]


--
Windows98 links to solutions http://jake98.no-ip.info
Replies in the same thread please

[quoted text, click to view]

Ouch! You want to post replies automatically? I suspect that has the
potential to generate an amazing quantity of flame mail in your inbox
probably quickly followed by termination of your news server account for
violation of the SP's anti-spam policy. No thanks!

--
David Portas
SQL Server MVP
--

[quoted text, click to view]

Ummm...

Not sure if I read this right...
If I have a system problem, and I post it in a newsgroup,
and I see it answered by a single link that brings me to a 90% sure solution, well I would be helped and happy.
Would that be considered spam?

Secondly, the engine would only post if that 90% sure hit is found in the database,
It would of course not post to every subject, that would indeed be spamming

Anyway, thanks for your input, and pity we seem to disagree in this matter


--
Windows98 links to solutions http://jake98.no-ip.info
Replies in the same thread please