CAPITULO SEIS:
6.2. MANEJO DE LOS CRITERIOS DE IMPUTACIÓN EN EL CÓDIGO CIVIL Y LA LEY.
Use of databases has grown in the library software applications whether it is an ILS, cataloguing software, information retrieval tool, reference service tool, current awareness service tool, or simply for a library website. There are a number of Relational Database Management Software (RDBMS) available as open source (like MySQL, PostgreSQL, and SAP DB) which support Structured Query Language (SQL) standards.
2.1 OpenIsis
Description: OpenIsis is the open source member of the CDS/ISIS software family. It is well suited for bibliographic databases with variable length fields and repeatable sub-fields.
Special Features: Some of the special features are
• Highly flexible data structure: potentially unlimited number of data fields in record
• Highly efficient storage: unused data fields consume no space
• Natural Modeling – ultra fast access: logically related data that would be artificially separated in a relational DB is stored in a single record
• Highly flexible index structure: index entries associated with a record are under full application control, can even be derived from associated text documents of any format.
History: Developed since May 2001
Project Sponsors/Administrators: OpenIsis Verein, Berlin Dependency: Unknown
Supported Platforms: Linux, UNIX, Windows, MacOS X License: GNU GPL, LGPL
Availability: http://sourceforge.net/project/showfiles.php?group_id=11257 Further Information: Project Home Page: http://www.openisis.org/
2.2 PostgreSQL
Description: PostgreSQL is claimed to be the most advanced Open Source database system in the world.
• Exceptional performance and speed • World-class security
• Flexibility to be extended as required • Highly scalable design
• Minimal administration requirements
Full feature set is available at: http://advocacy.postgresql.org/advantages/
History: The PostgreSQL software itself had its beginnings in 1986 inside the University of California at Berkeley as a research prototype, and in the 16 years since has moved to its now globally distributed development model, with central servers based in Canada.
Project Sponsors/Administrators: PostgreSQL Global Development Group Dependency: Perl, Python, Tcl/Tk, JDK/Ant, Flex & Bison
Supported Platforms: Linux, UNIX, Windows (under cygwin environment) License: BSD License
Availability: http://www.postgresql.org/mirrors-ftp.html
Further Information: Project Home Page: http://www.postgresql.org/
2.3 MySQL
Description: The MySQL database server is the world’s most popular open source database. Its architecture makes it extremely fast and easy to customize. Extensive reuse of code within the software and a minimalist approach to producing functionality-rich features has resulted in a database management system unmatched in speed, compactness, stability and ease of deployment. The unique separation of the core server from the storage engine makes it possible to run with strict transaction control or with ultra-fast transaction-less disk access, whichever is most appropriate for the situation.
Special Features: Some of the major features are • ANSI SQL syntax support
• Cross-platform support • Independent storage engines • Full-text indexing and searching • Query caching
• Flexible security system, including SSL support
• Replication of database servers for robustness and speed
Full feature set is available at: http://www.mysql.com/products/mysql/index.html
History: The project was started in 1995 and has become quite mature in the last five years. Undoubtedly it is the most popular open source RDBMS primarily because of its speed.
Project Sponsors/Administrators: MySQL AB Dependency: Unknown
Supported Platforms: Linux, UNIX, Windows, MacOS X License: GNU GPL and Commercial non-GNU
Availability: http://www.mysql.com/downloads/index.html
Further Information: Project Home Page: http://www.mysql.com/
2.4 Firebird
Description: Firebird is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names since 1981.
Special Features: Unknown
History: In August 2000, Borland Software Corp. (formerly known as Inprise) released the beta version of InterBase 6.0 as open source. The community of waiting developers and users preferred to establish itself as an independent, self- regulating team rather than submit to the risks, conditions and restrictions that the company proposed for community participation in open source development. A core of developers quickly formed a project and installed its own source tree on SourceForge.
Project Sponsors/Administrators: Ann W. Harrison, Pavel Cisar, John Bellardo, Mark Odonohue, David Jencks, Dmitry Yemanov, Sean Leyne
Dependency: glibc-2.2, ncurses4
Supported Platforms: Linux, UNIX, Windows
License: Mozilla Public License, InterBase Public License
Availability: http://sourceforge.net/project/showfiles.php?group_id=9028 Further Information: Project Home Page: http://www.firebirdsql.org/
2.5 SAP DB
Description: SAP DB is an open, SQL-based, relational database management system for small to very large implementations, supporting object orientation and unstructured data. SAP DB adheres to open standards including SQL, JDBC, and ODBC; access from Perl and Python; and HTTP-based services with HTML or extensible markup language (XML) content.
Special Features: The main features are • Round-the-clock operation • Easy administration
• Free of reorganization tasks • Unlimited number of users
• Unlimited database size • Supports all SAP solutions
History: Project started in October 2000.
Project Sponsors/Administrators: SAP AG, Germany Dependency: Unknown
Supported Platforms: Windows NT, Linux License: GNU GPL, LGPL
Availability: http://www.sapdb.org/7.4/sap_db_software.htm Further Information: Project Home Page: http://www.sapdb.org/