180 likes | 285 Views
Fed : one program for many web sites and databases. Raymond Ripp. Paris Tuebingen …. PHP Apache http server. Web /fed/php /fed/phpRR /fed/phpLP. Classes /classes/php /classes/phpRR /classes/phpLP. Disk access. Internal function call or Web Service. Raw data.
E N D
Fed : one program for many web sites and databases Raymond Ripp
Paris Tuebingen … PHP Apache http server Web /fed/php /fed/phpRR /fed/phpLP Classes /classes/php /classes/phpRR /classes/phpLP Disk access Internal function call or Web Service Raw data http://lbgi.igbmc.fr/gx/phpRR/ShowPeople.php Web services Postgresql databases S Q L • /fedlord • /genoret • /gx • /RetinoBase • /idv • /dbgs GxDb BIRD
People • Each user has a login, password • For the httpd server (Apache require valid-user) • For the Php session • forwarded to php if Apache logged (except admin) • if explicitely required by the user • Each php program has to protect himself • isLogged, isInWp, iAmInGrog, isMember, … • Can be integrated in all Sql access, to all databases, to specific databases, …
Datafiles and Galleries • Each datafile has an owner • belongs to a Grog • is referenced in one or more Galleries • A gallery has a parent Gallery • links to datafiles • can contain sub-galleries • created by the users
Antibodies list Datafile SOPs and protocols Antibodies
Galleries > Database : Upload, Direct Feeding, Querying The website gives access to the raw data and to the relational database Relational Database Most of the data are integrated in the SQL tables Integration Ext Prog Some raw datafiles are referenced in the database Upload form Direct feeding ? You
Fed Website Architecture • a hierarchical 3 levels tree organisation • sections • categories • buds • stored as html file with <ul> and <li> in website/own/desk/MenuBarBora.php. • a page corresponds to the display of a section/categorie/bud. • all buds of the displayed category are clickable • all categories of the displayed section are clickable • all sections are always available. • a page is displayed by a centralized .php program FedHTMLDocument.php (still called GenoretHTMLDocument) according to the CSS stored in website/own/css/bora/Bora.css.php • .php pages called Dazibao can be created or modified by users
The php program of the Dazibao can be edited directly with the web browser by users if authorized. It can be referenced everywhere in the php programs or in the main Menu Dazibao
PipeWork is a web tool allowing the user to create and evaluate his own flowcharts to process, query, filter and display the data First draft of the graphical tool
Genoret Database Raymond Ripp
Database content • 143 genoret members, 54 collaborators • 1428 datafiles • 430 images,162 ppt, , 60 xls, pdf 263, zip 17, CEL 20 • 198 datafile galleries • 50 SOP galleries
Patient databases • Genoret: 5695 patients • 1949 London, 2100 Montpellier, 601 Bonn, 46 Paris • AMD consortium: 3292 patients (1051 already genotyped at CNG) • 972 Baltimore, 601 Bonn, 300 Créteil, 255 Jerusalem 46 Paris, 1300 Southampton
InAnno • 1667 eye • 802 teeth • 2000 ear