Indexing Bibliographic Database Content Using MariaDB and Sphinx Search Server

Nugraha, Arie
July 2014
Code4Lib Journal;7/21/2014, Issue 25, p8
Academic Journal
Fast retrieval of digital content has become mandatory for library and archive information systems. Many software applications have emerged to handle the indexing of digital content, from low-level ones such Apache Lucene, to more RESTful and web-services-ready ones such Apache Solr and ElasticSearch. Solr's popularity among library software developers makes it the "de-facto" standard software for indexing digital content. For content (full-text content or bibliographic description) already stored inside a relational DBMS such as MariaDB (a fork of MySQL) or PostgreSQL, Sphinx Search Server (Sphinx) is a suitable alternative. This article will cover an introduction on how to use Sphinx with MariaDB databases to index database content as well as some examples of Sphinx API usage.


Related Articles

  • Study of Efficient Utilization of Power using green Computing. Jadhwani, Dheera; Agrawal, Mayur; Mande, Hemant // International Journal of Advanced Computer Research;Dec2012, Vol. 2 Issue 6, p108 

    Green computing or green IT, basically concerns to environmentally sustainable computing or IT. The field of green computing is defined as "the knowledge and practice of designing, manufacturing, using, and disposing of computers, servers, and associated subsystems--which include printers,...

  • How to choose your perfect rack server. Mitchell, Dave // PC Pro;May2015, Issue 247, p98 

    The article reports on the things to consider when buying a rack server for a company. It is said that rack servers have become a top choice for companies wanting to make the most of limited space. The latest rack servers offer the best densities on the market as far as both processing power and...

  • An Efficient Scalable Spatial Data Search for Location-Aware Mobile Services. KWANGJIN PARK // Journal of Information Science & Engineering;Jan2015, Vol. 31 Issue 1, p165 

    Various studies related to spatial indices are currently being conducted. Most of these studies focus on lowering the costs for indexed searches in on-demand environments during spatial query processing. However, on-demand environments often have issues with service delays when there is a...

  • Small Dell Server Offers Big Performance. Hartje, Roger // PC Week;02/08/99, Vol. 16 Issue 6, p53 

    Evaluates the Dell PowerEdge 6350 server from Dell Computer Corp. Processing power and storage that the server offers; Specifications; Pricing; Performance; How the PowerEdge compares to the Compaq ProLiant 7000 from Compaq Computer Corp.; Recommendations; Contact information.

  • BitTorious volunteer: server-side extensions for centrally-managed volunteer storage in BitTorrent swarms. Lee, Preston V.; Dinu, Valentin // BMC Bioinformatics;11/4/2015, Vol. 16, p1 

    Background: Our publication of the BitTorious portal [1] demonstrated the ability to create a privatized distributed data warehouse of sufficient magnitude for real-world bioinformatics studies using minimal changes to the standard BitTorrent tracker protocol. In this second phase, we release a...

  • Practical quantum private query of blocks based on unbalanced-state Bennett-Brassard-1984 quantum-key-distribution protocol. Chun-Yan Wei; Fei Gao; Qiao-Yan Wen; Tian-Yin Wang // Scientific Reports;12/19/2014, p1 

    Until now, the only kind of practical quantum private query (QPQ), quantum-key-distribution (QKD)-based QPQ, focuses on the retrieval of a single bit. In fact, meaningful message is generally composed of multiple adjacent bits (i.e., a multi-bit block). To obtain a message a1a2 .... al from...

  • Chapter 8: Future Directions.  // Foundations & Trends in Theoretical Computer Science;2010, Vol. 6 Issue 3, p244 

    The article offers information related to locally decodable codes and Private Information Retrieval schemes. It states that present two serverschemes are not based on locally decodable codes which was not the case in Private Information Retrieval in which three or more servers were involved. It...

  • Faster IBM DS8870 Storage Systems.  // SAN/LAN;Oct2012, Vol. 30 Issue 10, p3 

    The article offers brief information on several technologies for cloud computing from International Business Machines (IBM) Corp. including Power 770 and Power 780 servers, IBM System Storage DS8870 storage system, and zEnterprise EC12 operational system.

  • IBRIX's Fusion. Hurst, Chuck // Broadcast Engineering;Aug2009, Vol. 51 Issue 8, p56 

    The article discusses the implementation of the IBRIX Fusion software-based file server from IBRIX Inc. at Scripps Networks, a multi-brand media company. The software was needed for various tasks including data storage and graphics and video processing. Scalable file serving has proven...


Read the Article


Sorry, but this item is not currently available from your library.

Try another library?
Sign out of this library

Other Topics