|
HSQLDB
HSQLDB (''Hyper SQL Database'') is a relational database management system written in Java. It has a JDBC driver and supports a large subset of SQL-92, SQL:2008, SQL:2011, and SQL:2016 standards. It offers a fast, small (around 1300 kilobytes in version 2.2) database engine which offers both in-memory and disk-based tables. Both embedded and server modes are available. Additionally, it includes tools such as a minimal Web server, command line and GUI management tools (can be run as applets), and a number of demonstration examples. It can run on Java runtimes from version 1.1 upwards, including free Java implementations such as Kaffe. HSQLDB is available under a BSD license. It is used as a database and persistence engine in many open source software projects, such as descendants of OpenOffice.org Base (i.e., Apache OpenOffice Base, LibreOffice Base, etc.), and the Jitsi VoIP and video-conference client since version 2.6. It is also used in commercial products, such as Mat ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Comparison Of Relational Database Management Systems
The following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs. General information Operating system support The operating systems that the RDBMSes can run on. Fundamental features Information about what fundamental RDBMS features are implemented natively. * Note (1): Currently only supports read uncommitted transaction isolation. Version 1.9 adds serializable isolation and version 2.0 will be fully ACID compliant. * Note (2): MariaDB and MySQL provide ACID compliance through the default InnoDB storage engine. * Note (3): "For other than InnoDB storage engines, MySQL Server parses and ignores the and syntax in statements. The clause is parsed but ignored by all storage engines." * Note (4): Support for Unico ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
LibreOffice Base
LibreOffice Base is a free and open-source database development and administration tool for relational database management systems that is part of the LibreOffice suite. LibreOffice Base was built off of a fork of OpenOffice.org and was first released as version 3.4.0.1 on October 4, 2011. Similarly to the other packages in the LibreOffice suite, Base is supported across multiple platforms including Microsoft Windows, macOS, and Linux. Base is recognized for its cross-platform compatibility relative to Microsoft Access, which is developed exclusively for Windows. Features LibreOffice Base is designed to allow users to easily create, access, modify, and view databases and their data. This is done by providing users with a graphical user interface that allows users to work with four main tools: Tables, queries, forms, and reports. Base includes software wizards to assist users with various aspects of the program. LibreOffice Base requires Java in order to create databases ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
List Of Relational Database Management Systems
This is a list of relational database management systems. List of software Front-end User interfaces Only * Apache OpenOffice Base ** HSQLDB * LibreOffice Base ** Firebird ** HSQLDB *Microsoft Access ** Access Database Engine Discontinued * Britton Lee IDMs * Cornerstone * DM/BasisPlus * Google Fusion Tables * IBM Business System 12 * IBM System R * MICRO Relational Database Management System * Pick * PRTV * QBE * IBM SQL/DS * Sybase SQL Server Front-end User interfaces Only * OpenOffice.org Base ** HSQLDB * StarBase ** Adabas D Relational by the Date–Darwen–Pascal Model Current * Alphora Dataphor (a proprietary virtual, federated DBMS and RAD MS .Net IDE). Obsolete * IBM Business System 12 * IBM IS1 * IBM PRTV (ISBL) * Multics Relational Data Store See also * Comparison of object–relational database management systems * Comparison of relational database management systems * Comparison of database administration tools {{Databases, cat=no * Relat ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
H2 (database)
H2 is a relational database management system written in Java. It can used as an embedded database in Java applications or run in client–server mode. The software is available as open source software Mozilla Public License 2.0 or the original Eclipse Public License. History The development of the H2 database engine started in May 2004, and first published in December 2005. The database engine was written by Thomas Mueller. He also developed the Java database engine Hypersonic SQL. In 2001, the Hypersonic SQL project was stopped, and the HSQLDB Group was formed to continue work on the Hypersonic SQL code. The name H2 stands for Hypersonic 2, however H2 does not share code with Hypersonic SQL or HSQLDB. H2 is built from scratch. Version 2.0.x was released in January 2022. Features A subset of the SQL (Structured Query Language) standard is supported. The main programming APIs are SQL and JDBC, however the database also supports using the PostgreSQL ODBC driver by acting like a Po ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Apache Derby
Apache Derby (previously distributed as IBM Cloudscape) is a relational database management system (RDBMS) developed by the Apache Software Foundation that can be embedded in Java programs and used for online transaction processing. It has a 3.5 MB disk-space footprint. Apache Derby is developed as an open source project under the Apache 2.0 license. For a time, Oracle distributed the same binaries under the name Java DB. In June 2015 they announced that for JDK 9 they would no longer be doing so. History Apache Derby originated at Cloudscape Inc, an Oakland, California, start-up founded in 1996 by Nat Wyatt and Howard Torf to develop Java database technology. The first release of the database engine, then called JBMS, was in 1997. Subsequently, the product was renamed Cloudscape and releases were made about every six months. In 1999, Informix Software, Inc., acquired Cloudscape, Inc. In 2001 IBM acquired the database assets of Informix Software, including Cloudscape. The d ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Java Database Connectivity
Java Database Connectivity (JDBC) is an application programming interface (API) for the Java programming language which defines how a client may access a database. It is a Java-based data access technology used for Java database connectivity. It is part of the Java Standard Edition platform, from Oracle Corporation. It provides methods to query and update data in a database, and is oriented toward relational databases. A JDBC-to-ODBC bridge enables connections to any ODBC-accessible data source in the Java virtual machine (JVM) host environment. History and implementation Sun Microsystems released JDBC as part of Java Development Kit (JDK) 1.1 on February 19, 1997. Since then it has been part of the Java Platform, Standard Edition (Java SE). The JDBC classes are contained in the Java package and . Starting with version 3.1, JDBC has been developed under the Java Community Process. JSR 54 specifies JDBC 3.0 (included in J2SE 1.4), JSR 114 specifies the JDBC Rowset additions, a ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Jitsi
Jitsi (from — "wires") is a collection of free and open-source software, free and open-source multiplatform Voice over IP, voice (VoIP), Video conference, video conferencing and instant messaging applications for the Web platform, Windows, Linux, macOS, iOS, iPadOS, watchOS, and Android. The Jitsi project began with the Jitsi Desktop (previously known as Session Initiation Protocol, SIP Communicator). With the growth of WebRTC, the project team focus shifted to the Jitsi Videobridge for allowing web-based multi-party video calling. Later the team added #Jitsi Meet, Jitsi Meet, a full video conferencing application that includes web, Android, iOS, iPadOS, and watchOS clients. Jitsi also operates meet.jit.si, a version of Jitsi Meet hosted by Jitsi for free community use. Other projects include: Jigasi, lib-jitsi-meet, Jidesha, and Jitsi. Jitsi has received support from various institutions such as the NLnet Foundation, the University of Strasbourg and the Region of Alsace, Data ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Apache OpenOffice Base
The Apache ( ) are several Southern Athabaskan language-speaking peoples of the Southwest, the Southern Plains and Northern Mexico. They are linguistically related to the Navajo. They migrated from the Athabascan homelands in the north into the Southwest between 1000 and 1500 CE. Apache bands include the Chiricahua, Jicarilla, Lipan, Mescalero, Mimbreño, Salinero, Plains, and Western Apache ( Aravaipa, Pinaleño, Coyotero, and Tonto). Today, Apache tribes and reservations are headquartered in Arizona, New Mexico, Texas, and Oklahoma, while in Mexico the Apache are settled in Sonora, Chihuahua, Coahuila and areas of Tamaulipas. Each tribe is politically autonomous. Historically, the Apache homelands have consisted of high mountains, sheltered and watered valleys, deep canyons, deserts, and the southern Great Plains, including areas in what is now Eastern Arizona, Northern Mexico (Sonora and Chihuahua) and New Mexico, West Texas, and Southern Colorado. These areas are ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Two-phase Locking
In databases and transaction processing, two-phase locking (2PL) is a pessimistic concurrency control method that guarantees conflict-serializability. Philip A. Bernstein, Vassos Hadzilacos, Nathan Goodman (1987) ''Concurrency Control and Recovery in Database Systems'' Addison Wesley Publishing Company, Gerhard Weikum, Gottfried Vossen (2001) ''Transactional Information Systems'' Elsevier, It is also the name of the resulting set of database transaction schedules (histories). The protocol uses locks, applied by a transaction to data, which may block (interpreted as signals to stop) other transactions from accessing the same data during the transaction's life. By the 2PL protocol, locks are applied and removed in two phases: # Expanding phase: locks are acquired and no locks are released. # Shrinking phase: locks are released and no locks are acquired. Two types of locks are used by the basic protocol: ''Shared'' and ''Exclusive'' locks. Refinements of the basic protocol may ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Aggregate Function
In database management, an aggregate function or aggregation function is a function where multiple values are processed together to form a single summary statistic. Common aggregate functions include: * Average (i.e., arithmetic mean) * Count * Maximum * Median * Minimum * Mode * Range * Sum Others include: * Nanmean (mean ignoring NaN values, also known as "nil" or "null") * Stddev Formally, an aggregate function takes as input a set, a multiset (bag), or a list from some input domain and outputs an element of an output domain . The input and output domains may be the same, such as for SUM, or may be different, such as for COUNT. Aggregate functions occur commonly in numerous programming languages, in spreadsheets, and in relational algebra. The listagg function, as defined in the SQL:2016 standard aggregates data from multiple rows into a single concatenated string. In the entity relationship diagram, aggregation is represented as seen in Figure 1 with a rectang ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Set Operations (SQL)
Set operations in SQL is a type of operations which allow the results of multiple queries to be combined into a single result set. Set operators in SQL include UNION, INTERSECT, and EXCEPT, which mathematically correspond to the concepts of union, intersection and set difference. UNION operator In SQL the UNION clause combines the results of two SQL queries into a single table of all matching rows. The two queries must result in the same number of columns and compatible data types in order to unite. Any duplicate records are automatically removed unless UNION ALL is used. UNION can be useful in data warehouse applications where tables are not perfectly normalized. A simple example would be a database having tables sales2005 and sales2006 that have identical structures but are separated because of performance considerations. A UNION query could combine results from both tables. Note that UNION ALL does not guarantee the order of rows. Rows from the second operand may appea ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Comma-separated Values
Comma-separated values (CSV) is a text file format that uses commas to separate values, and newlines to separate records. A CSV file stores Table (information), tabular data (numbers and text) in plain text, where each line of the file typically represents one data record (computer science), record. Each record consists of the same number of field (computer science), fields, and these are separated by commas in the CSV file. If the field delimiter itself may appear within a field, fields can be surrounded with quotation marks. The CSV file format is one type of Delimiter-separated values, delimiter-separated file format. Delimiters frequently used include the comma, tab-separated values, tab, space, and semicolon. Delimiter-separated files are often given a ".csv" filename extension, extension even when the field separator is not a comma. Many applications or libraries that consume or produce CSV files have options to specify an alternative delimiter. The lack of adherence to the ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
