 |
 |
 |
 |
 |
 |
 |
 |
 |
|||
 |
||||||||||||
|
||||||||||||
 |
||||||||||||
| [Main || Information Portal || Decision Support Systems || Knowledge Management] | |
Database Design / Modeling / Development / Management A database is a collection of data, which is categorized in some way. The data has to be quickly accessible and modifiable for optimal categorization. Relational databases are the most commonly used databases. Data in them is placed in tables and they are accessed usually with SQL (Structured Query Language). The are many different types of databases from proprietary one like Oracle to free ones like MySQL. Databases are the heart of dynamic Web pages and Software Applications. All dynamic Web pages and Application must get their information from a database. Pompus provides a robust database solution that is fully functional.
Our extensive knowledge of relational database systems allows us
to provide creative problem solving solutions.
Database management involves storing, modifying, and extracting
information from a database. This is done by database management
systems (DMBS). A DMBS is a collection of programs that enables
you to store, modify, and extract information from a database. There
are many different types of DBMSs, ranging from small systems that
run on personal computers (MS Access) to huge systems that run on
mainframes that power entire Web sites (MySQL). From a technical
standpoint, DBMSs can differ widely. The terms relational, network,
flat, and hierarchical all refer to the way a DBMS organizes information
internally. The internal organization can affect how quickly and
flexibly you can extract information.
Pompus is an expert providing business solutions that require databases and database management systems. Contact us to find out how we can help you today. Below is a partial list of some of the more popular databases: Oracle ORACLE is a proprietary, robust database, which is the foundation for many database solutions. With the release of Oracle8i the database seems ready to handle the requirements of Web business demands. Oracle 8 and 8.1 database products are now available on Linux. Informix Informix, now a division of IBM, has been offering a variety of its products on the Linux operating system for years. In particular, the SE Standard Engine database, ESQL/C and Connect are available on Linux as supported products. Free evaluation versions are available. Informix-SE is a high-quality, powerful and feature-rich SQL database aimed at folks looking for a low-maintenance, easy-to-administer database. The International Informix User Group Software Repository contains a wide selection of goodies in source form. There is a listing of Informix-on-Linux HOWTO's, which includes installation, configuration, compiling & more. The Informix on Linux page provides general hints and suggestions. MySQL MySQL from MySQL AB is, with Postgres, one of the most popular GPL'ed databases for the GNU/Linux and BSD platforms. Commercial sales, support and training is available from NuSphere. They also do contract programming and infrastructure enhancements and feature additions for MySQL. Includes commercial support from AbriaSoft. Rudimentary support for table locking recently added. Also has complex but powerful user access control mechanism. Multi-threaded for parallel queries Includes ODBC, Perl, C, Java, Tcl, Python API's.
Machine Independent Software offers the CQL++ DBMS. Originally developed originally as a full-featured commercial software product, it is currently available under several licenses, including the GNU GPL. (The free version is under GPL, non-free, non-GPL versions are available at reasonable cost.) The feature list mentions the following: Transaction support, including commit, rollback, nested transactions, logging, failure recovery. ANSI 1989 Level 2 SQL and ODBC Level 1 API support ISAM or B-tree access Unlimited number of cursors BLOB (Binary Large Object) Support Optimistic concurrency control with shared read locks. This database has a preprocessor for embedding SQL in C++. IBM DBase2 IBM has announced availability and support for the DB2 for Linux database. The DB2 Universal Database is the flagship database: it boasts a long track record of large installations and rich & powerful features. Interesting twists include: Free download of trial beta User support via a news forum. Includes the Web Control Center, a graphical database administration tool. Includes net.data multi-database access and web programming API's. Sybase Sybase is now offering Adaptive Server Enterprise (ASE) in the form of a free, unsupported release for Linux, for both development and deployment. Besides a raft of flagship-product capabilities, Sybase currently holds the world TPM/C speed record on a non-clustered SMP box. Sybase also offers the OpenClient/C libraries in free, unsupported form. These libraries allow Linux clients to connect to Sybase server products. They are available in the old a.out binary format, the ELF binary format and the ELF dynamically loadable format. There are various Open Source tools for Sybase:
|
|