|
Size: 1370
Comment:
|
← Revision 26 as of 2023-10-16 11:35:10 ⇥
Size: 1870
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 5: | Line 5: |
| * If you want to do practical exercises on database design and programming you can obtain an account on our MariaDB (a MySQL open source fork) database server. Get in touch with ISG.EE (e-mail to support@ee.ethz.ch) and let us know what your plans are. The URI of our database server is {{{remi.ee.ethz.ch}}} where MariaDB runs on the default TCP port 3306. Besides the basic MariaDB SQL service, we provide a [[https://mysql.ee.ethz.ch/|phpMyAdmin]] WebUI for database queries and management. [[https://mariadb.org/|MariaDB]] is a true multi-user, multi-threaded (mostly) MySQL-compatible SQL database server. ANSI-SQL for relational databases is the most popular database language in the world. MariaDB is a client/ server implementation that consists of the server daemon {{{mysqld}}} and of a bunch of different client programs and libraries. | |
| Line 7: | Line 6: |
| * We also offer MongoDB, a NoSQL (nonrelational) JSON-based database especially suitable with software written in JavaScript. The service is reachable on mongodb01.ee.ethz.ch, on tcp/27017. | == General == |
| Line 9: | Line 8: |
| * Note: All database services are accessible from the internal ETHZ networks only. The only exception is the [[https://mysql.ee.ethz.ch/|phpMyAdmin]] web interface, which can be used globally after user authentication. | ANSI-SQL, a declarative language, is the core language standard for most relational database implementations and it's the most popular database language in the world. It consists of DML (data manipulation language, e.g. data queries, -updates, -inserts, -deletes), DDL (data definition language, e.g. table creation, -alteration, -removal) and DCL elements (data control language, e.g. granting and revoking permissions). ISG D-ITET offers MariaDB, a relational database based on (and mostly compatible with) the well-known MySQL software, which implements the ANSI-SQL standard, but it also has vendor-specific extensions regarding syntax, data types, transactions, indexes, (foreign) key constraints, stored procedures and so on. == MariaDB/ MySQL == * If you want to perform practical exercises on database design and -programming you can obtain an account on our MariaDB database server. Get in touch with ISG D-ITET (e-mail to support@ee.ethz.ch) and let us know what your plans are. The service runs on `remi.ee.ethz.ch`, on TCP port `3306`. * Besides the basic MariaDB SQL service, we provide [[https://mysql.ee.ethz.ch/|phpMyAdmin]], a WebUI for SQL queries and database management. == MongoDB/ NoSQL == * As an alternative to relational databases, ISG D-ITET offers MongoDB, a NoSQL (nonrelational) JSON-/ object-based database especially suitable with software written in JavaScript. The service is reachable on `mongodb01.ee.ethz.ch`, on TCP port `27017`. == Database service accessibility == * All database services are '''accessible from the internal ETHZ networks only'''. The only exception is the [[https://mysql.ee.ethz.ch/|phpMyAdmin]] web interface, which can be used globally after user authentication. |
Database programming
General
ANSI-SQL, a declarative language, is the core language standard for most relational database implementations and it's the most popular database language in the world. It consists of DML (data manipulation language, e.g. data queries, -updates, -inserts, -deletes), DDL (data definition language, e.g. table creation, -alteration, -removal) and DCL elements (data control language, e.g. granting and revoking permissions). ISG D-ITET offers MariaDB, a relational database based on (and mostly compatible with) the well-known MySQL software, which implements the ANSI-SQL standard, but it also has vendor-specific extensions regarding syntax, data types, transactions, indexes, (foreign) key constraints, stored procedures and so on.
MariaDB/ MySQL
If you want to perform practical exercises on database design and -programming you can obtain an account on our MariaDB database server. Get in touch with ISG D-ITET (e-mail to support@ee.ethz.ch) and let us know what your plans are. The service runs on remi.ee.ethz.ch, on TCP port 3306.
Besides the basic MariaDB SQL service, we provide phpMyAdmin, a WebUI for SQL queries and database management.
MongoDB/ NoSQL
As an alternative to relational databases, ISG D-ITET offers MongoDB, a NoSQL (nonrelational) JSON-/ object-based database especially suitable with software written in JavaScript. The service is reachable on mongodb01.ee.ethz.ch, on TCP port 27017.
Database service accessibility
All database services are accessible from the internal ETHZ networks only. The only exception is the phpMyAdmin web interface, which can be used globally after user authentication.