Kexi users can choose from various database engines that can be utilized for data and design storage. By default built-in SQLite 3 database engine is used that eliminates a need for installation and maintenance of a database server. For more advanced use Kexi can use database servers such as MySQL/MariaDB, PostgreSQL and Microsoft SQL Server/Sybase. Database servers have to be accessible to user on the same or any other computer. All database objects – tables, queries, forms, etc. – are stored in tables of a single database (either file or server), making it easy to share data and design. Resulting database can be to certain extent manipulated using dedicated database tools.
active tier-styleapplication-program-generatorcode generation tool
The data in a table does not have to be physically stored in the database. Views also function as relational tables, but their data are calculated at query time. External tables (in Informix or Oracle, for example) can also be thought of as views. In terms of the relational model of databases, a table can be considered a convenient representation of a relation, but the two are not strictly equivalent. For instance, a SQL table can potentially contain duplicate rows, whereas a true relation cannot contain duplicate rows that we call as tuples. Similarly, representation as a table implies a particular ordering to the rows and columns, whereas a relation is explicitly unordered.
GIS softwareList of GIS softwarefree, open-source GIS packages
MySQL – Allows spatial querying and storing of most spatial data types. Microsoft SQL Server (2008 and later) – The latest player in the market of storing and querying spatial data. GIS products such as MapInfo and Cadcorp SIS can read and edit this data while ESRI and others are expected to be able to read and edit this data at some point in the future. Oracle Spatial – Product allows users to perform complex geographic operations and store common spatial data types in a native Oracle environment. Most commercial GIS packages can read and edit spatial data stored in this way.
SQuirreL SQLSQuirreL SQL Client Plugin API
Hypersonic SQL. H2 (DBMS). IBM DB2 for Linux, OS/400 and Windows. Informix. Ingres (and OpenIngres). InstantDB. InterBase. Mckoi SQL Database. Microsoft Access with the JDBC/ODBC bridge. Microsoft SQL Server. Mimer SQL. MonetDB. MySQL. Netezza. Oracle Database 8i, 9i, 10g, 11g. Pointbase. PostgreSQL 7.1.3 and higher. SAPDB. Sybase. Sunopsis XML Driver (JDBC Edition). Teradata Warehouse. Vertica Analytic Database. SQL. Comparison of database tools.
Structured storagenon-relationalNoSQL Database
Oracle Database. CAP theorem. Comparison of object database management systems. Comparison of structured storage software. Correlation database. Database scalability. Distributed cache. Faceted search. MultiValue database. Multi-model database. Triplestore. Schema-agnostic databases.
Data is stored in a relational database management system by means of the ADOdb database abstraction library. MantisBT supports MySQL. Support for other databases ( PostgreSQL, Microsoft SQL, Oracle ) is known to be problematic. The development team are looking to fix this for the 2.0 release. MantisBT maintains a database upgrade path between versions by modifying the database schema incrementally. During the installation of MantisBT, database schema modifications are replayed all the way back from early versions of MantisBT to reach the latest state.
nested modelsNested sets
Queries using nested sets can be expected to be faster than queries using a stored procedure to traverse an adjacency list, and so are the faster option for databases which lack native recursive query constructs, such as MySQL. However, recursive SQL queries can be expected to perform comparably for 'find immediate descendants' queries, and much faster for other depth search queries, and so are the faster option for databases which provide them, such as PostgreSQL, Oracle, and Microsoft SQL Server. The use case for a dynamic endless database tree hierarchy is rare.
This structure is largely arbitrary but can follow good database table design. TACTIC can also access multiple databases simultaneously, regardless of platform. TACTIC projects can view databases from multiple disparate locations, including Oracle, MySQL, SQLite, PostgreSQL and Microsoft SQLServer, and unify the user experience. TACTIC's built-in expression language simplifies the process of extracting data from the database, making the overall system much easier to navigate. It provides an interface that removes the complexity of reiterating relationships on every query inherent in SQL.
its own programming-language interpreterTransport Layer Security
Seed7 provides a library with a database independent API. Programs can connect to MySQL, MariaDB, SQLite, PostgreSQL, Oracle, Open Database Connectivity (ODBC), Firebird and InterBase databases. Independent from the database prepared statements can be created, bind variables can be used, the statements can be executed and result sets can be fetched. Seed7 is based on MASTER, an extensible programming language described in the diploma and doctoral theses of Thomas Mertes. Most of the original ideas of MASTER, such as user defined statements and operators, can be found in Seed7. A precompiler, to translate MASTER to Pascal, was proposed, but unimplemented, in the original project.
AlfrescoAlfresco Software, Inc.
Multiple database support: MySQL, PostgreSQL, Oracle Database (Enterprise Edition), IBM DB2, Microsoft SQL Server (Enterprise Edition), MariaDB, Amazon Relational Database Service|Amazon RDS -MySQL]], Amazon Aurora. List of content management systems. List of collaborative software. List of applications with iCalendar support. Cloud collaboration. Document collaboration. Document-centric collaboration. Alfresco Community Site. Alfresco Content Services on AWS (Amazon Quickstart). Activiti Software Website. Alfresco Software External Project Repositories on GitHub.
XQJJava API for XQuery
Oracle XDB. Tamino. TigerLogic. Oracle DB (Not XDB). IBM DB2. Microsoft SQL Server. Sybase ASE. Informix. MySQL. PostgreSQL. Saxon XSLT and XQuery processor. Zorba. MXQuery. Oracle XQuery Processor. Javadoc for XQJ. XQJ Tutorial. Building Bridges from Java to XQuery, Charles Foster. XML Prague 2012 ( Prezi Presentation). Java Integration of XQuery, Hans-Jürgen Rennau. Balisage 2010. Orbeon Forms using XQJ. Spring Integration XQuery Support. XQS: XQuery for Scala (Sits on top of XQJ). IntelliJ XQuery Support plugin.
object-oriented databaseobject-oriented databasesobject persistence
An object database is a database management system in which information is represented in the form of objects as used in object-oriented programming. Object databases are different from relational databases which are table-oriented. Object-relational databases are a hybrid of both approaches. Object databases have been considered since the early 1980s. Object-oriented database management systems (OODBMSs) also called ODBMS (Object Database Management System) combine database capabilities with object-oriented programming language capabilities.
PL/pgSQL (Procedural Language/PostgreSQL) is a procedural programming language supported by the PostgreSQL ORDBMS. It closely resembles Oracle's PL/SQL language. Implemented by Jan Wieck, PL/pgSQL first appeared with PostgreSQL 6.4, released on October 30, 1998. Version 9 also implements some ISO SQL/PSM features, like overloading of SQL-invoked functions and procedures. PL/pgSQL, as a fully featured programming language, allows much more procedural control than SQL, including the ability to use loops and other control structures. SQL statements and triggers can call functions created in the PL/pgSQL language.
Microsoft's release of SQL Server 2012 (internal code: 'Denali') is the last to include an OLE DB provider for SQL Server, but support will continue for 7 years. According to a related Microsoft FAQ, "Providers like ADO.NET which can run on top of OLE DB will not support OLE DB once the latter is deprecated", but the same answer in the FAQ states that the original post relates only to the OLE DB provider for SQL Server, so the position of OLE DB itself remains unclear. The same FAQ states that ODBC performs better than OLE DB in most cases. On Oct 6, 2017 Microsoft announced that OLE DB was undeprecated. OLE DB provider. OLE DB consumer.
In practice, if the main database is being frequently searched, the aux-aux index and much of the aux index may reside in a disk cache, so they would not incur a disk read. If the database does not change, then compiling the index is simple to do, and the index need never be changed. If there are changes, then managing the database and its index becomes more complicated. Deleting records from a database is relatively easy. The index can stay the same, and the record can just be marked as deleted. The database remains in sorted order. If there are a large number of deletions, then searching and storage become less efficient.
Melanie CraftExecutive Chairman of the Board and CTO, Larry EllisonLarry
With the defeat of Informix and of Sybase, Oracle enjoyed years of industry dominance until the rise of Microsoft SQL Server in the late 1990s and IBM's acquisition of Informix Software in 2001 to complement their DB2 database. Oracle's main competition for new database licenses on UNIX, Linux, and Windows operating systems comes from IBM's DB2 and from Microsoft SQL Server. IBM's DB2 still dominates the mainframe database market. In 2005, Oracle Corporation paid Ellison a $975,000 salary, a $6,500,000 bonus, and other compensation of $955,100.
Microsoft CorporationMicrosoft Corp.MS
Microsoft Corporation is an American multinational technology company with headquarters in Redmond, Washington. It develops, manufactures, licenses, supports, and sells computer software, consumer electronics, personal computers, and related services. Its best known software products are the Microsoft Windows line of operating systems, the Microsoft Office suite, and the Internet Explorer and Edge web browsers. Its flagship hardware products are the Xbox video game consoles and the Microsoft Surface lineup of touchscreen personal computers. In 2016, it was the world's largest software maker by revenue (currently Alphabet/Google has more revenue).
GNU/LinuxLinux on the desktopLin
Major corporations that provide contributions include Dell, IBM, HP, Oracle, Sun Microsystems (now part of Oracle) and Nokia. A number of corporations, notably Red Hat, Canonical and SUSE, have built a significant business around Linux distributions. The free software licenses, on which the various software packages of a distribution built on the Linux kernel are based, explicitly accommodate and encourage commercialization; the relationship between a Linux distribution as a whole and individual vendors may be seen as symbiotic. One common business model of commercial suppliers is charging for support, especially for business users.
Teradata CorporationTeradata version 14Teradata Aster
object-orientedobject orientedobject-oriented programming language
The book describes the following patterns: Both object-oriented programming and relational database management systems (RDBMSs) are extremely common in software. Since relational databases don't store objects directly (though some RDBMSs have object-oriented features to approximate this), there is a general need to bridge the two worlds. The problem of bridging object-oriented programming accesses and data patterns with relational databases is known as object-relational impedance mismatch. There are a number of approaches to cope with this problem, but no general solution without downsides.
concurrencyGlobal concurrency controlconcurrent access
Comments: Concurrency control in Database management systems (DBMS; e.g., Bernstein et al. 1987, Weikum and Vossen 2001), other transactional objects, and related distributed applications (e.g., Grid computing and Cloud computing) ensures that database transactions are performed concurrently without violating the data integrity of the respective databases. Thus concurrency control is an essential element for correctness in any system where two database transactions or more, executed with time overlap, can access the same data, e.g., virtually in any general-purpose database system.
queriedXML query language
Querying XML: XQuery, XPath, and SQL/XML in context. Jim Melton and Stephen Buxton. Morgan Kaufmann, 2006. ISBN: 1-55860-711-0. XQuery: The XML Query Language. Michael Brundage. Addison-Wesley Professional, 2004. ISBN: 0-321-16581-0. XQuery from the Experts: A Guide to the W3C XML Query Language. Howard Katz (ed). Addison-Wesley, 2004. ISBN: 0-321-18060-7. An Introduction to the XQuery FLWOR Expression. Dr. Michael Kay (W3C XQuery Committee), 2005. XQuery from the Experts: A Guide to the W3C XML Query Language. Howard Katz (ed). Addison-Wesley, 2004. ISBN: 0-321-18060-7. An Introduction to the XQuery FLWOR Expression. Dr. Michael Kay (W3C XQuery Committee), 2005. Oracle: XQuery for Hadoop.
The customer's login credentials may be stored in a database, and the web server accesses the database server as a client. An application server interprets the returned data by applying the bank's business logic, and provides the output to the web server. Finally, the web server returns the result to the client web browser for display. In each step of this sequence of client–server message exchanges, a computer processes a request and returns data. This is the request-response messaging pattern. When all the requests are met, the sequence is complete and the web browser presents the data to the customer.
InformixInformix Dynamic ServerIBM Informix Dynamic Server
The IIUG (International Informix Users Group) acts as a federation of those user groups and provides numerous services to its members. * List of relational database management systems. Comparison of relational database management systems.