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

media:https://raw.github.com/ydupont/101repo/master/wiki/feature dimensionality/img/src er.png

Relationships

Usage

Requirements

  • MySQL Client >= 5.0
  • MySQL Server >= 5.0
Create the database(s):

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

Metadata


There are no revisions for this page.

User contributions

    This user never has never made submissions.

    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.

    10 most similar pages:

    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.