Re: [CODE4LIB] Good Database Software for a Digital Project?
Hi Matt, You may wish to give a try to J-ISIS https://kenai.com/projects/j-isis/downloads With J-ISIS, you can create a searchable database with a couple of clicks. It uses Berkeley Database as persistence manager and Lucene for indexing and searching. The user can concentrate on the domain and to what he want to achieve. No need to be an expert in relational dabases and SQL. Furthermore, you get suggestions of term indexed when making a particular query. Web-JISIS is a web application prototype that allows to browse and search J-ISIS databases. I can help if you need. Best wishes, Jean-Claude On Sat, Apr 16, 2016 at 2:07 AM, Matt Sherman wrote: > Well, we've got one volume done, with about 1,250 bibliographies, but there > are 3 other volumes to convert. So at the end of the day probably about > 5,000 entries. Though the how is to make it intractable via the web and > hopefully letting scholars in the field continue to add to the database > once it is online. > > On Fri, Apr 15, 2016 at 7:38 PM, Kyle Banerjee > wrote: > > > On Fri, Apr 15, 2016 at 11:53 AM, Roy Tennant > > wrote: > > > > > In my experience, for a number of use cases, including possibly this > one, > > > a database is overkill. Often, flat files in a directory system indexed > > by > > > something like Solr is plenty and you avoid the inevitable headaches of > > > being a database administrator. Backup, for example, is a snap and > easily > > > automated. > > > > > > > I'm with Roy -- no need to use a chain saw to cut butter. > > > > Out of curiosity, since the use case is an annotated bibliography, how > much > > stuff do you have? If you have only a few thousand entries in delimited > > text, flat files could be easier and more effective than other options. > > > > kyle > > > -- Jean-Claude Dauphin jc.daup...@gmail.com http://kenai.com/projects/j-isis/ http://www.unesco.org/isis/ http://www.unesco.org/idams/ http://www.greenstone.org
Re: [CODE4LIB] Good Database Software for a Digital Project?
Thanks for all the advice folks, this gives me a lot to look into. You all have certainly made me table MySQL, so now to look into PostgreSQL, Solr, XTF, and some of these other technologies to see what would be the best fit. It is always so helpful pinging this group as you all have so many helpful suggestions. On Sat, Apr 16, 2016 at 6:09 AM, Jean-Claude Dauphin wrote: > Hi Matt, > > You may wish to give a try to J-ISIS > > https://kenai.com/projects/j-isis/downloads > > With J-ISIS, you can create a searchable database with a couple of clicks. > It uses Berkeley Database as persistence manager and Lucene for indexing > and searching. > The user can concentrate on the domain and to what he want to achieve. No > need to be an expert in relational dabases and SQL. Furthermore, you get > suggestions of term indexed when making a particular query. > > Web-JISIS is a web application prototype that allows to browse and search > J-ISIS databases. > > I can help if you need. > > Best wishes, > > Jean-Claude > > > On Sat, Apr 16, 2016 at 2:07 AM, Matt Sherman > wrote: > > > Well, we've got one volume done, with about 1,250 bibliographies, but > there > > are 3 other volumes to convert. So at the end of the day probably about > > 5,000 entries. Though the how is to make it intractable via the web and > > hopefully letting scholars in the field continue to add to the database > > once it is online. > > > > On Fri, Apr 15, 2016 at 7:38 PM, Kyle Banerjee > > wrote: > > > > > On Fri, Apr 15, 2016 at 11:53 AM, Roy Tennant > > > wrote: > > > > > > > In my experience, for a number of use cases, including possibly this > > one, > > > > a database is overkill. Often, flat files in a directory system > indexed > > > by > > > > something like Solr is plenty and you avoid the inevitable headaches > of > > > > being a database administrator. Backup, for example, is a snap and > > easily > > > > automated. > > > > > > > > > > I'm with Roy -- no need to use a chain saw to cut butter. > > > > > > Out of curiosity, since the use case is an annotated bibliography, how > > much > > > stuff do you have? If you have only a few thousand entries in delimited > > > text, flat files could be easier and more effective than other options. > > > > > > kyle > > > > > > > > > -- > Jean-Claude Dauphin > > jc.daup...@gmail.com > > > http://kenai.com/projects/j-isis/ > http://www.unesco.org/isis/ > http://www.unesco.org/idams/ > http://www.greenstone.org >
Re: [CODE4LIB] Good Database Software for a Digital Project?
Since you mention the requirement to publish and maintain it on the web, another (NoSQL) option for your data storage would be a SPARQL graph store (such as Apache Fuseki). Loading the data would involve transforming each citation into an RDF graph and storing it as a named graph with an HTTP PUT, or transforming each volume to a SPARQL update query to insert your 1250 graphs in one query. Maintenance of data can be achieved simply with GET and PUT to read and write individual graphs (records) which is dead easy to connect to an HTML form, and you can use the SPARQL query language for all your search needs. Because the SPARQL family of protocols are already web protocols it can be a very simple architecture. It would also be trivially easy to publish the RDF as linked data by installing Pubby or similar in front of the SPARQL query service. Of course it may be that the RDF skillset is a step too far (it's not as widely known as RDBMS), but if you do have someone in your team with basic RDF skills it's worth considering as it could be a very simple solution if so. On 17 Apr 2016 00:15, "Matt Sherman" wrote: > Thanks for all the advice folks, this gives me a lot to look into. You all > have certainly made me table MySQL, so now to look into PostgreSQL, Solr, > XTF, and some of these other technologies to see what would be the best > fit. It is always so helpful pinging this group as you all have so many > helpful suggestions. > > On Sat, Apr 16, 2016 at 6:09 AM, Jean-Claude Dauphin > > wrote: > > > Hi Matt, > > > > You may wish to give a try to J-ISIS > > > > https://kenai.com/projects/j-isis/downloads > > > > With J-ISIS, you can create a searchable database with a couple of > clicks. > > It uses Berkeley Database as persistence manager and Lucene for indexing > > and searching. > > The user can concentrate on the domain and to what he want to achieve. No > > need to be an expert in relational dabases and SQL. Furthermore, you get > > suggestions of term indexed when making a particular query. > > > > Web-JISIS is a web application prototype that allows to browse and search > > J-ISIS databases. > > > > I can help if you need. > > > > Best wishes, > > > > Jean-Claude > > > > > > On Sat, Apr 16, 2016 at 2:07 AM, Matt Sherman > > wrote: > > > > > Well, we've got one volume done, with about 1,250 bibliographies, but > > there > > > are 3 other volumes to convert. So at the end of the day probably about > > > 5,000 entries. Though the how is to make it intractable via the web > and > > > hopefully letting scholars in the field continue to add to the database > > > once it is online. > > > > > > On Fri, Apr 15, 2016 at 7:38 PM, Kyle Banerjee < > kyle.baner...@gmail.com> > > > wrote: > > > > > > > On Fri, Apr 15, 2016 at 11:53 AM, Roy Tennant > > > > wrote: > > > > > > > > > In my experience, for a number of use cases, including possibly > this > > > one, > > > > > a database is overkill. Often, flat files in a directory system > > indexed > > > > by > > > > > something like Solr is plenty and you avoid the inevitable > headaches > > of > > > > > being a database administrator. Backup, for example, is a snap and > > > easily > > > > > automated. > > > > > > > > > > > > > I'm with Roy -- no need to use a chain saw to cut butter. > > > > > > > > Out of curiosity, since the use case is an annotated bibliography, > how > > > much > > > > stuff do you have? If you have only a few thousand entries in > delimited > > > > text, flat files could be easier and more effective than other > options. > > > > > > > > kyle > > > > > > > > > > > > > > > -- > > Jean-Claude Dauphin > > > > jc.daup...@gmail.com > > > > > > http://kenai.com/projects/j-isis/ > > http://www.unesco.org/isis/ > > http://www.unesco.org/idams/ > > http://www.greenstone.org > > >
[CODE4LIB] Job: Director of Library Technology & Data Management at University of Central Oklahoma
Director of Library Technology & Data Management University of Central Oklahoma Edmond The University of Central Oklahoma's Chambers Library has an opening for a creative, collaborative, knowledgeable, and highly motivated individual to serve as the Director of Technology and Data Management. This position participates as a member of the Library leadership team. This unique opportunity comes at a significant time as the Library embarks on several bold initiatives, including redefining the Library's use of technology as part of our initiative to transform user services. UCO is the state Metropolitan university. The campus of approximately 17,000 students is nestled in the Oklahoma City suburb of Edmond, OK. Brought to you by code4lib jobs: http://jobs.code4lib.org/job/25265/ To post a new job please visit http://jobs.code4lib.org/
Re: [CODE4LIB] Good Database Software for a Digital Project?
On Sat, Apr 16, 2016 at 7:15 AM, Matt Sherman wrote: > Thanks for all the advice folks, this gives me a lot to look into. You all > have certainly made me table MySQL, so now to look into PostgreSQL, Solr, > XTF, and some of these other technologies to see what would be the best > fit. > For a project like this, you can make just about any solution work. Maintaining apps that depend on technologies you don't use for anything else is a pain, so I'd be inclined to avoid the overhead of learning something new for this project unless is a part of your long term objectives. For example, solr or postgres are both viable here, but those two applications are good for very different types of purposes. So if you use one of those, pick the one that will be the most useful down the road. kyle