The SQL script is over 15MB in size, so attaching and using rather the SQL Server database could be more practical. You can download either the SQL script files for MySQL or PostgreSQL, or a detached Microsoft SQL Server MDF database file. SportsDBis an open-source database with real statistical data for different sports (baseball, American football, ice hockey, tennis, basketball etc), licensed under Creative Commons GNU GPL. The table below shows a large enough number of records in Invoice and InvoiceLine (for billing), and Tracks (for inventory) with many of them saved in Playlists: Store’s Employees sell Tracks to Customers all over the world. Invoice is the main billing table, with order details kept in InvoiceLine. Tracks can be also grouped within Playlists. Inventory keeps the catalog of Tracks for each Album, with albums produced by Artists. There are two main areas: inventory and billing. Most data was collected by the author from iTunes. But while Sakila keeps DVDs with movies, Chinook is a back-end database of a fictional music DVD store. With SQL scripts for all our supported databases.Ĭhinook is inspired from the classic Sakila sample database from MySQL. Chinook is the second sample database we also include as SQLite, SQL CE, SQL Anywhere, Firebird and Microsoft Access database files in all our Xtractor applications. You can download from GitHub the latest SQL scripts for Microsoft SQL Server and SQL Server Compact, SQLite, PostgreSQL and MySQL, Oracle and DB2. Chinook Test DatabaseĬhinookis another generic test database, created a while ago by Luis Rocha. Select all the list items, right-click and call the contextual Update Row Count menu command. To do so, show all table names, under the Tables node, in the Objects viewer. If your database changes, they must be re-calculated (for many tables, this may take a while). The table row count and the eventual size per table are estimated calculated values. One single entry in datatypes is enough to test each specific data type. Remark the estimated Size and the number of columns in datatypes is database-specific. Here is a list with the number of rows per table, for an Oracle database. And datatypes table has database-specific data types. Managers is a simple test view, with all manager-subordinate name pairs. Some employees work on projects ( proj) between a start and end date. Model Xtractor handles just database models, and Query Xtractor just designed queries, through a visual SQL query builder. Both model and data are available only in Data Xtractor. With emp shape selected, the previous Data Xtractor model diagram shows a lookup of all emp records below. IBM Db2’s sample database (called indeed sample) is another similar example.Įach department ( dept) links to all the employees ( emp) from that department. Oracle’s scott/tiger ( scott schema/user name and tiger password) was such an early sample. The database has been inspired from early versions of some Oracle or Db2 samples. More about our Employee database used as a sample here. Published now as free open-source database on GitHub, it offers SQL scripts for many other relational database systems, such as Oracle and IBM Db2, Microsoft SQL Server and Azure, PostgreSQL, MySQL and MariaDB, Amazon Redshift and Aurora, SAP/Sybase ASE. And as ready-to-use SQLite, SQL CE, SQL Anywhere, Firebird and Microsoft Access binary database files. It is also included in the setup files with db-specific SQL create/insert scripts. This is a very simple database, with just a few tables, one database view, around a dozen entries per table and basic relationships: one self-join and two one-to-many relationships.ĮmployeesQX (from the “ Employees for Query Xtractor” initial test database) is our own small generic test database.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |