473,659 Members | 3,592 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

to use or not to use a database for an archivable and searchable document

hello mates,

my question is such: should i turn a 80 pages doc file into a database so
that:

- i can make it searchable through an online form
- it can be modified and every modification archives the previous version,
inside an "archive" table.

??

The document could be described like this: it is a series of articles
organised in 2 levels: sections and subsections.
The user should be able to modify/erase/add articles , subsections and
sections and still keep the original article inside an archive.

The search system should cover both the current version and the archives.

I get confused on how to organize the whole database system.
I figured out that maybe it would be better to generate html files out of
the database content (since it is not going to be changed everyday) and then
perform the search on these html files. Same for the archives. Every updates
generates a new set of html files containing the whole document.

what do you think ?

i need experimented advise here. please help !!
Jul 17 '05 #1
6 1707
Alexandre Plennevaux wrote:
hello mates,

my question is such: should i turn a 80 pages doc file into a database

The document could be described like this: it is a series of articles
organised in 2 levels: sections and subsections.
The user should be able to modify/erase/add articles , subsections and
sections and still keep the original article inside an archive.


Sounds like a wiki to me! IIRC there are PHP-based wikis available.
Matthias

Jul 17 '05 #2
I would definitively use a database as it's faster to search for something
in the database than open each html file then search on all the files on a
specific section of the code (strip html tags, etc.). Coding is also easier.
Just think if someone search for "javascript exemple" and you have some JS
also on your page but not in the news, you will have to make lot of
traitments that would be like a piece of cake in a database. This is like
digging a swimming pool with a spoon.

Savut

"Alexandre Plennevaux" <al*******@la b-au.com> wrote in message
news:40******** *************** @news.skynet.be ...
hello mates,

my question is such: should i turn a 80 pages doc file into a database so
that:

- i can make it searchable through an online form
- it can be modified and every modification archives the previous version,
inside an "archive" table.

??

The document could be described like this: it is a series of articles
organised in 2 levels: sections and subsections.
The user should be able to modify/erase/add articles , subsections and
sections and still keep the original article inside an archive.

The search system should cover both the current version and the archives.

I get confused on how to organize the whole database system.
I figured out that maybe it would be better to generate html files out of
the database content (since it is not going to be changed everyday) and then perform the search on these html files. Same for the archives. Every updates generates a new set of html files containing the whole document.

what do you think ?

i need experimented advise here. please help !!


Jul 17 '05 #3
thanks for your reply. I think i'm going for a mixed solution:

i will have a database holding the content. Everytime the admin modifies the
content, i will have the script generate new html files and update the
database with those files, so the search will look in the database and
return the html file(s) as links (much like google).
this will limit database access as it will not be updated everyday so...
my question is now how to implement the archival logic ?

alex
"Savut" <we***@hotmail. com> wrote in message
news:6R******** ************@ne ws20.bellglobal .com...
I would definitively use a database as it's faster to search for something
in the database than open each html file then search on all the files on a
specific section of the code (strip html tags, etc.). Coding is also easier. Just think if someone search for "javascript exemple" and you have some JS
also on your page but not in the news, you will have to make lot of
traitments that would be like a piece of cake in a database. This is like
digging a swimming pool with a spoon.

Savut

"Alexandre Plennevaux" <al*******@la b-au.com> wrote in message
news:40******** *************** @news.skynet.be ...
hello mates,

my question is such: should i turn a 80 pages doc file into a database so that:

- i can make it searchable through an online form
- it can be modified and every modification archives the previous version, inside an "archive" table.

??

The document could be described like this: it is a series of articles
organised in 2 levels: sections and subsections.
The user should be able to modify/erase/add articles , subsections and
sections and still keep the original article inside an archive.

The search system should cover both the current version and the archives.
I get confused on how to organize the whole database system.
I figured out that maybe it would be better to generate html files out of the database content (since it is not going to be changed everyday) and

then
perform the search on these html files. Same for the archives. Every

updates
generates a new set of html files containing the whole document.

what do you think ?

i need experimented advise here. please help !!

Jul 17 '05 #4
why not use your solution, create static html page from the database, but
the search would still be done in the database then return the html page,
just like you said.

Savut

"Alexandre Plennevaux" <al*******@la b-au.com> wrote in message
news:40******** *************@n ews.skynet.be.. .
thanks for your reply. I think i'm going for a mixed solution:

i will have a database holding the content. Everytime the admin modifies the content, i will have the script generate new html files and update the
database with those files, so the search will look in the database and
return the html file(s) as links (much like google).
this will limit database access as it will not be updated everyday so...
my question is now how to implement the archival logic ?

alex
"Savut" <we***@hotmail. com> wrote in message
news:6R******** ************@ne ws20.bellglobal .com...
I would definitively use a database as it's faster to search for something
in the database than open each html file then search on all the files on a specific section of the code (strip html tags, etc.). Coding is also

easier.
Just think if someone search for "javascript exemple" and you have some JS also on your page but not in the news, you will have to make lot of
traitments that would be like a piece of cake in a database. This is like digging a swimming pool with a spoon.

Savut

"Alexandre Plennevaux" <al*******@la b-au.com> wrote in message
news:40******** *************** @news.skynet.be ...
hello mates,

my question is such: should i turn a 80 pages doc file into a database so that:

- i can make it searchable through an online form
- it can be modified and every modification archives the previous version, inside an "archive" table.

??

The document could be described like this: it is a series of articles
organised in 2 levels: sections and subsections.
The user should be able to modify/erase/add articles , subsections and
sections and still keep the original article inside an archive.

The search system should cover both the current version and the archives.
I get confused on how to organize the whole database system.
I figured out that maybe it would be better to generate html files out of the database content (since it is not going to be changed everyday)

and then
perform the search on these html files. Same for the archives. Every

updates
generates a new set of html files containing the whole document.

what do you think ?

i need experimented advise here. please help !!



Jul 17 '05 #5
Based on what you've said, I would say no. It doesn't make sense to use a
database to do the job of a word-processor. Keep the Word file and use it to
generate a HTML version. Use Word's versioning mechanism or simply create a
new copy of the .doc file everytime you make changes.

Uzytkownik "Alexandre Plennevaux" <al*******@la b-au.com> napisal w
wiadomosci news:40******** *************** @news.skynet.be ...
hello mates,

my question is such: should i turn a 80 pages doc file into a database so
that:

- i can make it searchable through an online form
- it can be modified and every modification archives the previous version,
inside an "archive" table.

??

The document could be described like this: it is a series of articles
organised in 2 levels: sections and subsections.
The user should be able to modify/erase/add articles , subsections and
sections and still keep the original article inside an archive.

The search system should cover both the current version and the archives.

I get confused on how to organize the whole database system.
I figured out that maybe it would be better to generate html files out of
the database content (since it is not going to be changed everyday) and then perform the search on these html files. Same for the archives. Every updates generates a new set of html files containing the whole document.

what do you think ?

i need experimented advise here. please help !!

Jul 17 '05 #6
He didn't said it's word format as I know

Savut

"Chung Leong" <ch***********@ hotmail.com> wrote in message
news:fe******** ************@co mcast.com...
Based on what you've said, I would say no. It doesn't make sense to use a
database to do the job of a word-processor. Keep the Word file and use it to generate a HTML version. Use Word's versioning mechanism or simply create a new copy of the .doc file everytime you make changes.

Uzytkownik "Alexandre Plennevaux" <al*******@la b-au.com> napisal w
wiadomosci news:40******** *************** @news.skynet.be ...
hello mates,

my question is such: should i turn a 80 pages doc file into a database so that:

- i can make it searchable through an online form
- it can be modified and every modification archives the previous version, inside an "archive" table.

??

The document could be described like this: it is a series of articles
organised in 2 levels: sections and subsections.
The user should be able to modify/erase/add articles , subsections and
sections and still keep the original article inside an archive.

The search system should cover both the current version and the archives.
I get confused on how to organize the whole database system.
I figured out that maybe it would be better to generate html files out of the database content (since it is not going to be changed everyday) and

then
perform the search on these html files. Same for the archives. Every

updates
generates a new set of html files containing the whole document.

what do you think ?

i need experimented advise here. please help !!



Jul 17 '05 #7

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

Similar topics

1
2186
by: Yasso Picasso | last post by:
Greetings, I have to admit that I'm still a beginner in the database field, but I'm actively studying, and this is why I will be utterly grateful for the proper, accurate, and wise guidance to the right direction or specific paths of database studies. I simply want to make my first major database project a "personal knowledge database" or a "personal encyclopedia", so to speak. By this I mean that I want to gather diverse,...
0
1388
by: Yasso | last post by:
Greetings, I have to admit that I'm still a beginner in the database field, but I'm actively studying, and this is why I will be utterly grateful for the proper, accurate, and wise guidance to the right direction or specific paths of database studies. I simply want to make my first major database project a "personal knowledge database" or a "personal encyclopedia", so to speak. By this I mean that I want to gather diverse,...
5
2068
by: PR | last post by:
Searchable product images + prices database? What system should I use to put a database on the WEB which shows images and allows searches, including searches within given price ranges for products? There will be product images too, thumbnails and larger images? All the data will be on a single server, on the same
3
4317
by: sandrina | last post by:
Hello everyone, My name is Debi and I am an Administrative assistant with a large company in their sourcing department. I was hired one month ago, and walked in to a HUGE filing nightmare. My boss requires a paper copy of everything to be saved and filed. The vendors we purchase from produce hundreds of different products, with enough paper to sometimes fill half a filing cabinet on their own. Anyway, after discussing everything and...
0
8428
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8337
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8851
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8628
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7359
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5650
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4335
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2754
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1739
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.