Thread: searchable database

Dear Friends,

I need help from you.

We have more than thousand electronic journals. I want to make a searchable database for easy access. Is there any light wight database available for that. Please provide me the details for the same.

If you have any questions please mail me.

Looking forward to your help,

Thanks&Regards
Srinath

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, Apr 09, 2011 at 12:10:46PM +0530, quickinfo wrote:
> Dear Friends,
>
> I need help from you.
>
> We have more than thousand electronic journals. I want to make a searchable
> database for easy access. Is there any light wight database available for
> that. Please provide me the details for the same.

Your question is just too general to make a meaningful answer possible.
The only answer I might offer is -- "yes, you might use a data base for
that", and "yes, PostgreSQL might be useful for that", but I know that's
just too general to be helpful.

Maybe try to target your question  a bit more?

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFNoT8FBcgs9XrR2kYRAuzWAJ4pB4cjQXNdtVHvxU+dyJeQCUQogACfXs4u
GRMyRyllE5eIMH/l4qMaHUM=
=hdaL
-----END PGP SIGNATURE-----

On 04/09/11 10:24 PM, tomas@tuxteam.de wrote:
>> We have more than thousand electronic journals. I want to make a searchable
>> >  database for easy access. Is there any light wight database available for
>> >  that. Please provide me the details for the same.
> Your question is just too general to make a meaningful answer possible.
> The only answer I might offer is -- "yes, you might use a data base for
> that", and "yes, PostgreSQL might be useful for that", but I know that's
> just too general to be helpful.

I believe what the OP wants is a "document management system"...
http://en.wikipedia.org/wiki/Document_management_system

postgres is a general purpose database engine, and has many features
which could be very useful for a document management system,.  such an
application likely would use a database like postgres as its back end,
but you need an application.   It didn't sound like the OP is prepared
to write such a thing.

google lists quite a few open source packages like this.
http://www.google.com/search?q=open-source+document-management-system+postgresql
(ig

of course, open source projects like these vary widely in quality and
usability.   I'd suggest to the OP they review the available packages,
pick a few possible candidates, and setup trial installs, adding a few
dozen documents to them to see how well they work for them..     Seems
like a lot of them are Java/Tomcat Web applications that use Postgres,
MySQL, and other database servers.  Without having tried any of them and
just glancing at google results, I see OpenKM, Xinco DMS, and Alfresco

What are 'electronic journals', anyways?   are these basically document
files?  do they have some internal structure, like a collection of
articles,  or is each journal a single entity?   one really simple
approach is to convert your journals to blog entries with a blogging
package like s9y or wordpress, or a more sophisticated web CMS like
Plone or Drupal, and use a combination of tags and search to find content.

You might want to check out these free open source library system solutions:

Evergreen:
http://www.open-ils.org/

Koha:
http://koha.org/

I am just not sure if these are "light weight" enough for what you need, but they will provide a powerful search mechanism, a built-in front end  and other features. The are free and built on open source tools.

You may need to do some conversion to marc:
http://en.wikipedia.org/wiki/MARC_standards

One easy to use free tool for that is Marc Edit:
http://people.oregonstate.edu/~reeset/marcedit/html/index.php

These tools might seem too heavy for what you need, but will give you versatility and flexibility for expanding your resources to other materials if you ever need to do so. Moreover, they will provide all kinds of built in search options such as searching by subject, author, etc..

Regards,
Robert

I completely agree with Thomas.
If the world journal has the same meaning I give to it I suggest the OP
to give a look to Open Journal System:

http://pkp.sfu.ca/?q=ojs

Maybe it goes further than the OP wants.
I never used it wiht Postgres , because my customers wanted to use
MySQL  :-(
But it supports postgres.



Il 10/04/2011 7.37, John R Pierce ha scritto:
> On 04/09/11 10:24 PM, tomas@tuxteam.de wrote:
>>> We have more than thousand electronic journals. I want to make a
>>> searchable
>>> >  database for easy access. Is there any light wight database
>>> available for
>>> >  that. Please provide me the details for the same.
>> Your question is just too general to make a meaningful answer possible.
>> The only answer I might offer is -- "yes, you might use a data base for
>> that", and "yes, PostgreSQL might be useful for that", but I know that's
>> just too general to be helpful.
>
> I believe what the OP wants is a "document management system"...
> http://en.wikipedia.org/wiki/Document_management_system
>
> postgres is a general purpose database engine, and has many features
> which could be very useful for a document management system,.  such an
> application likely would use a database like postgres as its back end,
> but you need an application.   It didn't sound like the OP is prepared
> to write such a thing.
>
> google lists quite a few open source packages like this.
> http://www.google.com/search?q=open-source+document-management-system+postgresql
>
> (ig
>
> of course, open source projects like these vary widely in quality and
> usability.   I'd suggest to the OP they review the available packages,
> pick a few possible candidates, and setup trial installs, adding a few
> dozen documents to them to see how well they work for them..     Seems
> like a lot of them are Java/Tomcat Web applications that use Postgres,
> MySQL, and other database servers.  Without having tried any of them
> and just glancing at google results, I see OpenKM, Xinco DMS, and
> Alfresco
>
> What are 'electronic journals', anyways?   are these basically
> document files?  do they have some internal structure, like a
> collection of articles,  or is each journal a single entity?   one
> really simple approach is to convert your journals to blog entries
> with a blogging package like s9y or wordpress, or a more sophisticated
> web CMS like Plone or Drupal, and use a combination of tags and search
> to find content.
>
>

--
==================================================
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
web: www.archicoop.it
==================================================