Contribution:
mySqlOneReporting
Headline
Language:SQL-based implementation tailored to Technology:MySQL
Motivation
To extend the data base structure of Contribution:mySqlOne by implementing Feature:Dimensionality.
A relational schema is used as the data model of the system:Company. Some functional requirements of the system are modelled as Language:SQL statements.
Illustration
ERM of source database schema
Relationships
- See Contribution:mySqlOne which implements the base structure used in Contribution:mySqlOneReporting
- See Contribution:mySqlMany for a variation of the base structure which supports many companies instead a single company. The two variants are used for illustrating Feature:Singleton and Feature:Many companies.
Usage
Requirements
- MySQL Client >= 5.0
- MySQL Server >= 5.0
Installation
$ mysql> CREATE DATABASE onereporting;NOTE: Grant privileges in case you don´t want to use the root user. You can use "n" source databases.
Load database schema:
$ mysql -u <USERNAME> -p -h <HOSTNAME> onereporting < sql/schema.sql
OPTIONAL: Populate the databases using sample data:
$ mysql -u <USERNAME> -p -h <HOSTNAME> onereporting < sql/sample.sql
(C) 2012-2024 softlang.org and contributors
There are no revisions for this page.
User contributions
User edits
Syntax for editing wiki
For you are available next options:will make text bold.
will make text italic.
will make text underlined.
will make text striked.
will allow you to paste code headline into the page.
will allow you to link into the page.
will allow you to paste code with syntax highlight into the page. You will need to define used programming language.
will allow you to paste image into the page.
is list with bullets.
is list with numbers.
will allow your to insert slideshare presentation into the page. You need to copy link to presentation and insert it as parameter in this tag.
will allow your to insert youtube video into the page. You need to copy link to youtube page with video and insert it as parameter in this tag.
will allow your to insert code snippets from @worker.
Syntax for editing wiki
For you are available next options:will make text bold.
will make text italic.
will make text underlined.
will make text striked.
will allow you to paste code headline into the page.
will allow you to link into the page.
will allow you to paste code with syntax highlight into the page. You will need to define used programming language.
will allow you to paste image into the page.
is list with bullets.
is list with numbers.
will allow your to insert slideshare presentation into the page. You need to copy link to presentation and insert it as parameter in this tag.
will allow your to insert youtube video into the page. You need to copy link to youtube page with video and insert it as parameter in this tag.
will allow your to insert code snippets from @worker.