Knowledge (XXG)

Apache Derby

Source đź“ť

360: 612: 1502: 27: 260:
Top Level Project at Apache. Prior to Derby's graduation from incubation, Sun joined the Derby project with an intent to use Derby as a component in their own products, and with the release of Java 6 in December 2006, Sun started packaging Derby in the
248:
acquired the database assets of Informix Software, including Cloudscape. The database engine was re-branded to IBM Cloudscape and releases continued, mainly focusing on embedded use with IBM's Java products and middleware.
1814: 307:
The Derby network server increases the reach of the Derby database engine by providing traditional client server functionality. The network server allows clients to connect over TCP/IP using the standard
237:
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.
682: 378: 332:
An embedded database can be configured to act as a hybrid server/embedded RDBMS; to also accept TCP/IP connections from other clients in addition to clients in the same JVM.
268:
In March 2007, IBM announced that they would withdraw marketing and support for the Cloudscape product, but would continue to contribute to the Apache Derby project.
373: 1804: 1824: 1809: 1335: 675: 568: 651: 1671: 179: 131: 365: 1506: 668: 1540: 582: 1768: 256:
project. In July 2005 the Derby project graduated from the Apache incubator and is now being developed as a sub-project of the
444: 691: 252:
In August 2004, IBM contributed the code to the Apache Software Foundation as Derby, an incubator project sponsored by the
1552: 1278: 284:
The core of the technology, Derby's database engine, is a full-functioned relational embedded database-engine, supporting
191: 498: 90: 187: 107: 64: 1593: 1573: 183: 53: 421: 1692: 1283: 632: 1748: 757: 484: 432: 1758: 1753: 1533: 1298: 1819: 1712: 1222: 512: 1763: 1611: 588: 317: 262: 202: 627: 617: 1162: 648: 226: 126: 526: 1783: 1733: 1717: 1661: 1626: 752: 454: 210: 143: 257: 253: 1778: 1526: 1177: 1067: 952: 817: 802: 782: 578: 1386: 1260: 1217: 1207: 907: 867: 852: 807: 138: 114: 1518: 1421: 1416: 1396: 1252: 1232: 1192: 1187: 1182: 1167: 1122: 897: 787: 717: 712: 707: 655: 1743: 1487: 1461: 1456: 1411: 1371: 1314: 1288: 1270: 1087: 1082: 1062: 1057: 1052: 1012: 937: 832: 827: 812: 792: 722: 611: 206: 119: 643: 1798: 1446: 1401: 1376: 1247: 1237: 1212: 1197: 1172: 1117: 1077: 1017: 992: 987: 967: 947: 942: 917: 902: 837: 822: 732: 727: 449: 550: 1738: 1441: 1426: 1381: 1330: 1293: 1242: 1157: 1152: 1142: 1137: 1132: 1127: 1107: 1102: 1047: 1042: 1032: 997: 982: 972: 957: 927: 922: 887: 882: 872: 862: 857: 797: 772: 747: 742: 458: 660: 1631: 1583: 1466: 1406: 1361: 1202: 1147: 1112: 1022: 1002: 977: 962: 932: 912: 877: 777: 767: 762: 312:
protocol. The network server allows the Derby engine to support networked JDBC,
217:. In June 2015 they announced that for JDK 9 they would no longer be doing so. 1773: 1471: 1431: 1391: 1340: 1097: 1092: 1072: 892: 842: 737: 355: 230: 48: 34: 574: 383: 341:
ij: a tool that allows SQL scripts to be executed against any JDBC database.
1646: 1027: 1007: 271:
The Java DB database is Oracle's supported distribution of Apache Derby.
241: 234: 195: 233:, start-up founded in 1996 by Nat Wyatt and Howard Torf to develop Java 1651: 1616: 1578: 618:
Internals of Derby, An Open Source Pure Java Relational Database Engine
293: 26: 1666: 1656: 1641: 567:
Zikopoulos, Paul C.; Baklarz, George; Scott, Dan (November 6, 2005).
470: 388: 1636: 1451: 1366: 1345: 1037: 96: 638: 570:
Apache Derby—Off to the Races: Includes Details of IBM Cloudscape
1588: 1436: 1227: 621: 321: 313: 309: 285: 1522: 664: 605: 408: 154: 1687: 1549: 296: 289: 245: 40: 347:
sysinfo: Utility to display version numbers and class path.
1815:
Free software programmed in Java (programming language)
639:
Apache Derby performance results in the JPA Benchmark
422:
Java DB - FAQs: "Is Java DB a fork of Apache Derby?"
379:
Comparison of relational database management systems
344:
dblook: Schema extraction tool for a Derby database.
1726: 1705: 1680: 1602: 1566: 1559: 1480: 1354: 1323: 1307: 1269: 698: 445:"Informix Completes Acquisition of Cloudscape, Inc" 149: 137: 125: 113: 103: 89: 63: 47: 33: 244:Software, Inc., acquired Cloudscape, Inc. In 2001 551:http://db.apache.org/derby/docs/10.4/adminguide/ 513:"Changes in Cloudscape Availability and Support" 527:"Relationship between Java DB and Apache Derby" 485:"Why IBM is open sourcing Cloudscape as Derby" 374:List of relational database management systems 225:Apache Derby originated at Cloudscape Inc, an 1534: 676: 213:distributed the same binaries under the name 8: 633:Why IBM is open sourcing Cloudscape as Derby 19: 1563: 1541: 1527: 1519: 683: 669: 661: 610: 25: 18: 499:"Apache Derby graduates with Sun onboard" 400: 180:relational database management system 132:Relational Database Management System 70:10.17.1.0 / November 14, 2023 16:Relational database management system 7: 1553:free and open-source software (FOSS) 649:Configure and Install Derby Database 366:Free and open-source software portal 1805:Apache Software Foundation projects 457:. October 11, 1999. Archived from 14: 1825:Software using the Apache license 1810:Free database management systems 1501: 1500: 358: 201:Apache Derby is developed as an 1769:Open Source Security Foundation 644:Compliance matrix with SQL 2003 549:see Embedded Server Example in 692:The Apache Software Foundation 280:Derby embedded database engine 1: 292:as programming APIs. It uses 192:online transaction processing 433:Deferring to Derby in JDK 9 174:(previously distributed as 1841: 620:deployable in an embedded 184:Apache Software Foundation 54:Apache Software Foundation 1496: 635:, IBM developerWorks site 182:(RDBMS) developed by the 85: 59: 24: 1693:Red Hat Enterprise Linux 186:that can be embedded in 1749:Linux Technology Center 328:Embedded Network Server 1759:Open Mainframe Project 1754:Open Invention Network 198:disk-space footprint. 190:programs and used for 72:; 9 months ago 39:Cloudscape Inc (Later 1713:Common Public License 1567:Programming languages 591:on February 15, 2009. 1764:OpenPOWER Foundation 1612:Carbon Design System 303:Derby Network Server 265:branded as Java DB. 628:Oracle Java DB Site 21: 1784:The Fedora Project 1734:Eclipse Foundation 1718:IBM Public License 753:Apache HTTP Server 654:2016-04-17 at the 573:(First ed.). 455:Berkshire Hathaway 336:Database utilities 207:Apache 2.0 license 205:project under the 144:Apache License 2.0 35:Original author(s) 1792: 1791: 1701: 1700: 1681:Operating systems 1605:development tools 1516: 1515: 169: 168: 1832: 1564: 1543: 1536: 1529: 1520: 1504: 1503: 685: 678: 671: 662: 614: 609: 608: 606:Official website 592: 587:. Archived from 553: 547: 541: 540: 538: 537: 523: 517: 516: 509: 503: 502: 501:. CNET news.com. 495: 489: 488: 481: 475: 474: 468: 466: 461:on March 9, 2000 441: 435: 430: 424: 419: 413: 412: 405: 368: 363: 362: 361: 165: 162: 160: 158: 156: 115:Operating system 99: 97:Derby Repository 80: 78: 73: 29: 22: 1840: 1839: 1835: 1834: 1833: 1831: 1830: 1829: 1795: 1794: 1793: 1788: 1722: 1697: 1676: 1604: 1598: 1555: 1547: 1517: 1512: 1492: 1476: 1350: 1319: 1303: 1265: 700: 694: 689: 656:Wayback Machine 604: 603: 600: 595: 585: 577:. p. 600. 566: 562: 557: 556: 548: 544: 535: 533: 531:docs.oracle.com 525: 524: 520: 511: 510: 506: 497: 496: 492: 483: 482: 478: 464: 462: 443: 442: 438: 431: 427: 420: 416: 407: 406: 402: 397: 364: 359: 357: 354: 338: 330: 305: 282: 277: 223: 194:. It has a 3.5 153: 95: 81: 76: 74: 71: 17: 12: 11: 5: 1838: 1836: 1828: 1827: 1822: 1817: 1812: 1807: 1797: 1796: 1790: 1789: 1787: 1786: 1781: 1776: 1771: 1766: 1761: 1756: 1751: 1746: 1744:Linux on IBM Z 1741: 1736: 1730: 1728: 1724: 1723: 1721: 1720: 1715: 1709: 1707: 1703: 1702: 1699: 1698: 1696: 1695: 1690: 1684: 1682: 1678: 1677: 1675: 1674: 1669: 1664: 1659: 1654: 1649: 1644: 1639: 1634: 1629: 1624: 1619: 1614: 1608: 1606: 1603:Frameworks and 1600: 1599: 1597: 1596: 1591: 1586: 1581: 1576: 1570: 1568: 1561: 1557: 1556: 1548: 1546: 1545: 1538: 1531: 1523: 1514: 1513: 1511: 1510: 1497: 1494: 1493: 1491: 1490: 1488:Apache License 1484: 1482: 1478: 1477: 1475: 1474: 1469: 1464: 1459: 1454: 1449: 1444: 1439: 1434: 1429: 1424: 1419: 1414: 1409: 1404: 1399: 1394: 1389: 1384: 1379: 1374: 1369: 1364: 1358: 1356: 1352: 1351: 1349: 1348: 1343: 1338: 1333: 1327: 1325: 1324:Other projects 1321: 1320: 1318: 1317: 1311: 1309: 1305: 1304: 1302: 1301: 1296: 1291: 1286: 1281: 1275: 1273: 1267: 1266: 1264: 1263: 1258: 1255: 1250: 1245: 1240: 1235: 1230: 1225: 1223:Traffic Server 1220: 1215: 1210: 1205: 1200: 1195: 1190: 1185: 1180: 1175: 1170: 1165: 1160: 1155: 1150: 1145: 1140: 1135: 1130: 1125: 1120: 1115: 1110: 1105: 1100: 1095: 1090: 1085: 1080: 1075: 1070: 1065: 1060: 1055: 1050: 1045: 1040: 1035: 1030: 1025: 1020: 1015: 1010: 1005: 1000: 995: 990: 985: 980: 975: 970: 965: 960: 955: 950: 945: 940: 935: 930: 925: 920: 915: 910: 905: 900: 895: 890: 885: 880: 875: 870: 865: 860: 855: 850: 845: 840: 835: 830: 825: 820: 815: 810: 805: 800: 795: 790: 785: 780: 775: 770: 765: 760: 755: 750: 745: 740: 735: 730: 725: 720: 715: 710: 704: 702: 696: 695: 690: 688: 687: 680: 673: 665: 659: 658: 646: 641: 636: 630: 625: 615: 599: 598:External links 596: 594: 593: 583: 563: 561: 558: 555: 554: 542: 518: 504: 490: 476: 436: 425: 414: 409:"Apache Derby" 399: 398: 396: 393: 392: 391: 386: 381: 376: 370: 369: 353: 350: 349: 348: 345: 342: 337: 334: 329: 326: 304: 301: 281: 278: 276: 273: 222: 219: 209:. For a time, 176:IBM Cloudscape 167: 166: 151: 147: 146: 141: 135: 134: 129: 123: 122: 120:Cross-platform 117: 111: 110: 105: 101: 100: 93: 87: 86: 83: 82: 69: 67: 65:Stable release 61: 60: 57: 56: 51: 45: 44: 37: 31: 30: 15: 13: 10: 9: 6: 4: 3: 2: 1837: 1826: 1823: 1821: 1818: 1816: 1813: 1811: 1808: 1806: 1803: 1802: 1800: 1785: 1782: 1780: 1777: 1775: 1772: 1770: 1767: 1765: 1762: 1760: 1757: 1755: 1752: 1750: 1747: 1745: 1742: 1740: 1737: 1735: 1732: 1731: 1729: 1725: 1719: 1716: 1714: 1711: 1710: 1708: 1704: 1694: 1691: 1689: 1686: 1685: 1683: 1679: 1673: 1670: 1668: 1665: 1663: 1660: 1658: 1655: 1653: 1650: 1648: 1645: 1643: 1640: 1638: 1635: 1633: 1630: 1628: 1625: 1623: 1620: 1618: 1615: 1613: 1610: 1609: 1607: 1601: 1595: 1592: 1590: 1587: 1585: 1582: 1580: 1577: 1575: 1572: 1571: 1569: 1565: 1562: 1558: 1554: 1551: 1544: 1539: 1537: 1532: 1530: 1525: 1524: 1521: 1509: 1508: 1499: 1498: 1495: 1489: 1486: 1485: 1483: 1479: 1473: 1470: 1468: 1465: 1463: 1460: 1458: 1455: 1453: 1450: 1448: 1445: 1443: 1440: 1438: 1435: 1433: 1430: 1428: 1425: 1423: 1420: 1418: 1415: 1413: 1410: 1408: 1405: 1403: 1400: 1398: 1395: 1393: 1390: 1388: 1385: 1383: 1380: 1378: 1375: 1373: 1370: 1368: 1365: 1363: 1360: 1359: 1357: 1353: 1347: 1344: 1342: 1339: 1337: 1334: 1332: 1329: 1328: 1326: 1322: 1316: 1313: 1312: 1310: 1306: 1300: 1297: 1295: 1292: 1290: 1287: 1285: 1282: 1280: 1277: 1276: 1274: 1272: 1268: 1262: 1259: 1256: 1254: 1251: 1249: 1246: 1244: 1241: 1239: 1236: 1234: 1231: 1229: 1226: 1224: 1221: 1219: 1216: 1214: 1211: 1209: 1206: 1204: 1201: 1199: 1196: 1194: 1191: 1189: 1186: 1184: 1181: 1179: 1176: 1174: 1171: 1169: 1166: 1164: 1161: 1159: 1156: 1154: 1151: 1149: 1146: 1144: 1141: 1139: 1136: 1134: 1131: 1129: 1126: 1124: 1121: 1119: 1116: 1114: 1111: 1109: 1106: 1104: 1101: 1099: 1096: 1094: 1091: 1089: 1086: 1084: 1081: 1079: 1076: 1074: 1071: 1069: 1066: 1064: 1061: 1059: 1056: 1054: 1051: 1049: 1046: 1044: 1041: 1039: 1036: 1034: 1031: 1029: 1026: 1024: 1021: 1019: 1016: 1014: 1011: 1009: 1006: 1004: 1001: 999: 996: 994: 991: 989: 986: 984: 981: 979: 976: 974: 971: 969: 966: 964: 961: 959: 956: 954: 951: 949: 946: 944: 941: 939: 936: 934: 931: 929: 926: 924: 921: 919: 916: 914: 911: 909: 906: 904: 901: 899: 896: 894: 891: 889: 886: 884: 881: 879: 876: 874: 871: 869: 866: 864: 861: 859: 856: 854: 851: 849: 846: 844: 841: 839: 836: 834: 831: 829: 826: 824: 821: 819: 816: 814: 811: 809: 806: 804: 801: 799: 796: 794: 791: 789: 786: 784: 781: 779: 776: 774: 771: 769: 766: 764: 761: 759: 756: 754: 751: 749: 746: 744: 741: 739: 736: 734: 731: 729: 726: 724: 721: 719: 716: 714: 711: 709: 706: 705: 703: 697: 693: 686: 681: 679: 674: 672: 667: 666: 663: 657: 653: 650: 647: 645: 642: 640: 637: 634: 631: 629: 626: 623: 619: 616: 613: 607: 602: 601: 597: 590: 586: 584:0-13-185525-5 580: 576: 572: 571: 565: 564: 559: 552: 546: 543: 532: 528: 522: 519: 514: 508: 505: 500: 494: 491: 486: 480: 477: 472: 460: 456: 452: 451: 450:Business Wire 446: 440: 437: 434: 429: 426: 423: 418: 415: 411:. Apache.org. 410: 404: 401: 394: 390: 387: 385: 382: 380: 377: 375: 372: 371: 367: 356: 351: 346: 343: 340: 339: 335: 333: 327: 325: 323: 319: 315: 311: 302: 300: 298: 295: 291: 287: 279: 274: 272: 269: 266: 264: 259: 255: 250: 247: 243: 238: 236: 232: 228: 220: 218: 216: 212: 208: 204: 199: 197: 193: 189: 185: 181: 177: 173: 164: 152: 148: 145: 142: 140: 136: 133: 130: 128: 124: 121: 118: 116: 112: 109: 106: 102: 98: 94: 92: 88: 84: 68: 66: 62: 58: 55: 52: 50: 46: 42: 38: 36: 32: 28: 23: 1820:IBM software 1739:Fedora Linux 1621: 1505: 1163:SpamAssassin 847: 589:the original 569: 560:Bibliography 545: 534:. Retrieved 530: 521: 507: 493: 479: 469:– via 463:. Retrieved 459:the original 448: 439: 428: 417: 403: 331: 306: 283: 275:Technologies 270: 267: 251: 239: 224: 214: 200: 175: 172:Apache Derby 171: 170: 49:Developer(s) 20:Apache Derby 1632:Eclipse Che 1584:Object REXX 624:environment 465:October 12, 203:open source 1799:Categories 1774:PowerLinux 1392:Deltacloud 1178:Subversion 1068:OŃ€enOffice 953:Jackrabbit 893:FreeMarker 818:CloudStack 803:CarbonData 783:Bloodhound 536:2023-05-01 395:References 231:California 104:Written in 91:Repository 77:2023-11-14 1387:Continuum 1308:Incubator 1261:ZooKeeper 1218:Trafodion 1208:TinkerPop 908:Guacamole 868:Empire-db 853:Directory 808:Cassandra 699:Top-level 575:IBM Press 471:Yahoo.com 254:Apache DB 240:In 1999, 1706:Licenses 1647:Node-RED 1560:Software 1507:Category 1481:Licenses 1422:Marmotta 1253:XMLBeans 1233:Velocity 1193:Tapestry 1188:SystemDS 1183:Superset 1173:Struts 2 1168:Struts 1 1123:RocketMQ 1028:NetBeans 1008:mod_perl 898:Geronimo 788:Brooklyn 718:Airavata 713:ActiveMQ 708:Accumulo 701:projects 652:Archived 352:See also 299:syntax. 242:Informix 235:database 1727:Related 1662:Postfix 1652:OpenAFS 1627:Eclipse 1617:CGIDEV2 1579:NetRexx 1462:Tuscany 1457:Stanbol 1417:Jakarta 1412:Harmony 1372:Beehive 1315:Taverna 1299:Logging 1271:Commons 1088:Phoenix 1083:Parquet 1063:OpenNLP 1058:OpenJPA 1053:OpenEJB 1013:MyFaces 938:Iceberg 833:CouchDB 828:Cordova 813:Cayenne 793:Calcite 723:Airflow 294:IBM Db2 227:Oakland 221:History 215:Java DB 178:) is a 157:.apache 150:Website 139:License 75: ( 1667:Qiskit 1657:OpenJ9 1642:Kitura 1402:Giraph 1377:iBATIS 1289:Daemon 1248:Xerces 1238:Wicket 1213:Tomcat 1198:Thrift 1118:Roller 1078:PDFBox 1018:Mynewt 993:Mahout 988:Lucene 968:JMeter 948:Impala 943:Ignite 918:Hadoop 903:Groovy 838:cTAKES 823:Cocoon 733:Ambari 728:Allura 581:  515:. IBM. 487:. IBM. 389:HSQLDB 211:Oracle 161:/derby 1779:SHARE 1637:HElib 1622:Derby 1452:Sqoop 1447:Slide 1442:Shale 1437:River 1427:MXNet 1382:Click 1367:AxKit 1355:Attic 1346:Log4j 1331:Batik 1294:Jelly 1257:Yetus 1243:Xalan 1158:Storm 1153:Spark 1143:Sling 1138:SINGA 1133:Shiro 1128:Samza 1108:Pivot 1103:Pinot 1048:Oozie 1043:OFBiz 1038:NuttX 1033:Nutch 998:Maven 983:Kylin 973:Kafka 958:James 928:Helix 923:HBase 888:Flume 883:Flink 873:Felix 863:Druid 858:Drill 848:Derby 798:Camel 773:Axis2 748:Arrow 743:Aries 1672:STAF 1589:Rexx 1467:Wave 1407:Hama 1397:Etch 1362:Apex 1279:BCEL 1228:UIMA 1203:Tika 1148:Solr 1113:Qpid 1023:NiFi 1003:MINA 978:Kudu 963:Jena 933:Hive 913:Gump 878:Flex 778:Beam 768:Axis 763:Avro 622:OSGi 579:ISBN 467:2019 322:Perl 314:ODBC 310:DRDA 288:and 286:JDBC 188:Java 159:.org 127:Type 108:Java 1688:K42 1594:X10 1574:EGL 1550:IBM 1472:XML 1432:ODE 1341:Ivy 1336:FOP 1284:BSF 1098:Pig 1093:POI 1073:ORC 843:CXF 758:APR 738:Ant 318:CLI 297:SQL 290:SQL 263:JDK 246:IBM 41:IBM 1801:: 529:. 453:. 447:. 384:H2 324:. 320:, 258:DB 229:, 196:MB 155:db 1542:e 1535:t 1528:v 684:e 677:t 670:v 539:. 473:. 316:/ 163:/ 79:) 43:)

Index


Original author(s)
IBM
Developer(s)
Apache Software Foundation
Stable release
Repository
Derby Repository
Java
Operating system
Cross-platform
Type
Relational Database Management System
License
Apache License 2.0
db.apache.org/derby/
relational database management system
Apache Software Foundation
Java
online transaction processing
MB
open source
Apache 2.0 license
Oracle
Oakland
California
database
Informix
IBM
Apache DB

Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.

↑