27 February 2003
Any comments can be sent to:
Philippe
Demierre, Didier Ferrere
27 February 2003
New implememntation of web access module and java for redundancy test (for Hybrid & Module)
The web access modules were implemented and are available under 'TESTS' and 'Hybrid/Module access modules' of the navigation panel
The java upload application has been upgraded allowing the data upload of these new type of data. The version that people must used is SCTTEST_3_17_P.jar
27 February 2003
New implememntation and extension of the Data Structure for Barrel module survey
The DB structure has been extended to 3 new entities for SCT_TSTbmSurveyXY, SCT_TSTbmSurveyZ, SCT_TSTbmZprofile.
The web access modules were implemented and are available under 'TESTS' and 'Hybrid/Module access modules' of the navigation panel
The java upload application has been upgraded allowing the data upload of these new type of data. The version that people must used is SCTTEST_3_17_P.jar
13 February 2003
Drop of the rule for the chip to gelpack assembly
It has been agreed into the chip logistic rule not to use anymore the chip to gelpack assembly but to ship the chips and the gelpacks to the institutes who are going to mount the chips onto the hybrids. No disassembly is needed then!
In addition the assembly data and the item data relative to the previous assembly to gelpack made only by Ral, Birmingham and ChipDicingUK has been modified to allow working with the UploaAssmData utility. Please contact Didier and Dave/Bill for detail information...
01 November 2002
A new tool under JavaSpecialDev has been implemented to get the corresponding Hybrid/Module serial number
It allows from the fhFlexK5 or bmHPC SerNo to get the corresponding Hybrid or Module serial number. Be carefull this feature won't work if the assembly is not entered into the DB! For accesing to that feature please download SCTspecialDev.zip. Then unzip it in your usual directory where your placed the DB tools. It is then not necessary to correct the classpath in that case.
01 November 2002
The extension and implementation relative to the SCTDAQ readout test
The DB structure has been extended for 12 new entities that are related to SCT DAQ data.
The web access modules for each of the SCTDAQ mandatory test were implemented. Only consultation and deletion is possible on those data.
The Java UploadTesData application has been updated to allow the upload relative to the new tables (please now download the last version SCTTEST_3_16_P.zip. Unzip it and correct your CLASSPATH to the new jar file)
The new related test, defect, test_list description were inserted for allowing to insert the SCTDAQ test data.
25 October 2002
Update on shipment web access
An update was made on the SHIP web access module. If the « Sender Location » or initials are different from the user location a warning is put in the header of the page.
23 October 2002
Update on the bar code printing web access
An update was made allowing the user to see the serial number of the Module and the Hybrid if the Flex (or Hybrid passive component for Barrel) serial number is entered. To allow that feature working the user must not put a range of serial number and just fill the frame « Item serial number from: ».
25 July 2002
Update of the java application SCTABCDCHIPS
An update was made to allow the insertion of the receipt date field when recording a new wafer and chips. The bew version is distributed with the name: SCTABCDCHIPS_3_02_P.jar
18 April 2002
Update of the java application SCTTEST_3_15_P.zip
An update was made to improve the upload features of Upload_ItemImage and Upload_TestImage (option -T [Title] and -U [Url] are working better when the character '-' is used into the url)
08 April 2002
New web tool dedicated for the chip assembly (It is possible to access the module directly by clicking here)
The user need to enter the Hybrid/Module serial number, the gelpack serial number from where the chips are taken plus the original chip positions in the gelpack relative to where it assemble on the hybrid. The assembly can be done in several operation and specially when the chips are originating from several gelpacks.
Then whem submitting the specific form it will indicate and remind to the user if what the tool is going to be done correspond to what it is desired
By submitting the request (and after some security validation) it will proceed for deleting the gelpack assembly records, put them into assembly hystory log and insert the new chip to hybrid assembly
28 March 2002
The extension and implementation relative to the Opto-components test are made and available on the production DB. The DB implementation consisted of:
Extending of the data structure with the entities: OCDC, OCBER1 and OCBER2
Inserting the new definitions for item and test. If new definition is needed please ask Didier
Implementing the new web access modules which are available in the navigation panel for OCDC1, OCDC2, OCBER1, OCBER2
Implementing the java application for the following tests: OCDC1, OCDC2, OCBER1, OCBER2 (please download the new application SCTTEST_3_14_P.zip).
13 February 2002
A new chip tool has been implemented to get the corresponding chip position on the wafer relative to serial number.
31 January 2002
All the chip tools have been implemented for the production. The DB implementation consisted of:
Extending of the data structure for TSTABCD, TSTABCDCHANNELS, TEST_WAFER_E_PARAM.
Inserting the new definitions for item, test and test list .
Implementing the new web access modules which are available in the navigation panel for "ABCD Chip tests" and for "Wafer Tests".
Implementing the java application for uploading the ABCD test (ABCDScreen).
Implementing the java application for uploading the Wafer test parameters (ABCDWafer).
Implementing the java application for the registration of a wafer and the chips on it.
7 January 2002
Update of the web access module "All Tests Report"
In the last version the Query allows in the Test part to make a query in addition on "Test problem" attribute.
28 November 2001
New report access module for shipped items
In addition to the shipment access module for entering new shipment boxes and items, there is the possibility now to access the shipment information for a particular item thanks to a new report access module. In a second query level it allows also to see the items that were shipped together in the same shipment box. This module is accessible on the navigation panel under "Items" and is located in the "Reports" section. It is possible to access to it directly by clicking here.
D. Ferrere
12 November 2001
Improvement of the manufacturer shipment access module
Since the manufacturers could not see and receive the rejected detectors from Si-detector QC centers, we updated the manufacturer access module allowing them to see any shipment that are shipped to them.
P Demierre, D. Ferrere
02 November 2001
New java application for uploading assembly
A new java application for uploading assembly is now available. Both the jar file and the instruction are described in the java standard application page. This application must be used properly and any assembly upload must follow the assembly description with the correct assembly item, the component and its position.
D. Ferrere
28 September 2001
New Attribute in ASSM_ITEMS table
A new attribute has been added into the assembly item table to allow the record of an assembly date. This new field is mandatory and all previous records (before this implementation) were updated with their own Last_Mod.
Ph. Demierre, D. Ferrere
5 September 2001
Item Event table
A new entity has been implemented for defining any events that happened at a certain place and date. The access module is accessible under Item of the navigation panel. The Event definition and description will have to be enriched time to time when there are needs identified.
Ph. Demierre, D. Ferrere
4 September 2001
Multiple bar code generation
A single bar code generation was existing in the past, but in the spirit of printing a set of bar codes on a single sticky page a new application has been developed and is under "Item" of the navigation panel (replacing the old bar code generation link). This allows to print a range of bar codes (limited to 200 bar codes to avoid a too large output results transferred on the network). If you want to print a single item serial number the user just need to fill "Item serial Number from". In that case (if only one item is requested) if your item is a module then the information of the hybrid and the flex will also be generated (as on the previous application). The users can plays with 3 options: the bar code height, the cell width (100% is A4 printing) , and the number of columns. All the 3 parameters should help the users to optimize the bar code area formatted as they want.
D. Ferrere
4 September 2001
Special Java development for getting the last raw data of an item
A new java tool has been put available for accessing the DB by using a standard Read ONLY access. The username/Password for it can be obtained by asking to Didier or Philippe. This new application is dedicated for extracting the LAST raw data of an item for a particular test. The difference with the "DowloadRawData" is that here the user does not have to know the test number and the original file path. If some SCT people are interested in the java source they can mail to Didier.
D. Ferrere
3 September 2001
Optimization of the test web access modules
After having loaded heavily the development DB with several hundred thousand records (that we will certainly reach at some point of the SCT production), the DB reactivity is obviously not the same. In order to limit a large output resulting from the query, the access modules have been simplified. Also we modified the query such way that the user inform the DB of the particular item they want to consult/insert/modify.
Ph. Demierre
10 July 2001
New Read Only channel
Ph. Demierre
20 June 2001
New web and java access for Low Mass Tapes tests
The functionality to insert Low Mass Tapes tests is now accessible via a web module (under TEST link of the navigation panel). With the new java application SCTTEST_3_12_P.jar the user can also upload the test, raw data, test comments, web links and images.
Ph. Demierre, D. Ferrère
20 June 2001
Item data insertion using Java
The only way the users could register an item up to now was using the web application. Now a new java application allow the user to upload the information via a standard format file. The advantage of it is the automatisation of the item insertion that are issued from a mass production. The difference with the web is that the user impose the serial number to the DB based on the dedicated location number. This feature is valid if you download the new application SCTTEST_3_12_P.jar and you update your CLASSPATH.
Ph. Demierre, D. Ferrère
10 May 2001
Automatic mail generation from the DB when confirming a shipment
When an user confirm a shipment to an institute, the DB generates an automatic message that is distribute via email to the receiver and all its colleagues from the institute. This new feature is aiming to inform user about a future reception and help them to recall to receive the items in the ship item list.
Ph. Demierre, D. Ferrère
7 May 2001
Shipment of items can be done using java application
For important number of item to be put into a shipment package (SHIP_ITEMS table), a java application allow to do that by reading a standard file to be uploaded by the DB. Then the confirmation of the shipment must be done as usual via the web interface.
Ph. Demierre, D. Ferrère
2 May 2001
Download of raw data into a desired file name
Download possibility was already existing but the choice of file name is now possible in an optional input parameter.
Ph. Demierre, D. Ferrère
6 April 2001
Item type and Mfr Ser No visible into the ship item list
Update of ship item access module where now we have in addition to the serial number the item type and the manufacturer serial number into the display list (left page).
Ph. Demierre, D. Ferrère
30 March 2001
Detector module current (4 detector current)
A new access module for entering the current of the 4 detectors once the module has been assembled is available for web in the TEST group of the navigation panel and for java it also available on the java stuff link.
Ph. Demierre, D. Ferrère
21 March 2001
Detector delivery report
A new report for detector delivery status has been implemented to allow to see the numbers of detectors from a manufacturer shipped to an institute. It is available under Items of the navigation panel.
D. Ferrère
05 March 2001
Bar code generation using web interface
Bar code generation using the web inteface for item serial number is available under Items in the navigation panel. It allows to print bar code plus the manufacturer serial number and the item type. In case of the barrel module it will print hybrid serial number in addition. In case of forward module it will print the hybrid serial number plus the kapton flex serial number.
D. Ferrère
26 January 2001
A new access module for Kapton flex item registration
Kapton flex item registration will be done through the a new access module which is reserved to Freiburg. According to Freiburg demand of a range of sequence number for Kapton flex, we agreed to set a special range of number (2022095xxxxxxx) for such request. For the item type (ctype) fhFlexK4 we assigned a range: 20220950000001 to 20220950009999.
P. Demierre & D. Ferrère and agreed with J. Foster
14 December 2000
SCT database, New web module for electronic chips
A new web module has been implemented to give to the users the possibility to insert the chips items via the Web.
Ph. Demierre
13 December 2000
SCT database, New date acquisition in web report forms
A javascript function has been implemented in the web reports to help the users to input the date in the query form.
Ph. Demierre
31 October 2000
SCT database, New Web site
The navigation pannel site has been moved to a new location.
Ph. Demierre
18 October 2000
SCT database, New derived test passed attribut
A new attribut derived from the testlist and tests has been
implemented into items, detector, all tests modules, and also in the
all test report.
That calculated (ie not attached to a table)
attribut indicates the status of the required tests attached to an
item and the status of the corresponding tests performed.
Ph. Demierre
16 October 2000
SCT database, New item's attribut : TRASHED
A new attribut ITEMS.trashed has been implemented (production)
Ph. Demierre
21 August 2000
SCT database : Quality Control in Applet plots
The Items Detectors IV report has been enhanced with QA plots.
Ph. Demierre
27 June 2000
SCT database, new test report.
A new test report have been implemented (production): "All
Tests Report".
That report
allow the user to see all the tests performed on one or many
items. (batch)
Ph. Demierre
26 June 2000
SCT database, two new tests.
Two new tests have been implemented (production): Test Module
Survey XY and Test Module Survery Z.
New SCTTEST_3_08_P.jar
application.
Ph. Demierre
15 June 2000
Upload of images (gif and jpg) to the SCT database
You can reach the documentation at Doc
Ph. Demierre
25 May 2000
SCT DB Backup online
The SCT production database backup is performed online. It means that the SCT DB is available all days and nights
Ph. Demierre
8 May 2000
SCT Atlas serial number barcode generation
The Web SCT database application is able to generate on the fly and display into the web browser, the corresponding serial number barcode image. Then, the barcode can be printed from many reports or web modules, by clicking on the browser's print button.
Ph. Demierre
28 March 2000
SCT Atlas New Java application
A new java application has been written to allow the users to upload multiple date file in one step. And also to enter new kind of tests.
Ph. Demierre
14 February 2000
Raw data display(Production DB)
Now the web application has been improved to display the test raw data when it exists. This goal has been reached by developping a Java applet that is downloaded from the database server (via a web page) to the browser. That applet make another connection to the DB to get the raw data and display it into a text area.
Ph. Demierre
26 January 2000
SCT Atlas sub system, and new serial number size (Prod DB)
The data structure has been modified to keep 14 digits as item serial numbers. The data have been updated to hold the new 14 digits serial number. Web SCT database
Ph. Demierre
17 January 2000
SCT Atlas sub system, and new serial number size (dev DB)
The data structure has been modified to keep 14 digits as item serial numbers. When validated, the new structure will be applied to the production DB. V5.4
Ph. Demierre
13 January 2000
Pixel Atlas sub system, and new serial number size
The Pixel subsystem production DB is up ! The data structure has been modified to keep 14 digits as item serial numbers. See.
Ph. Demierre
14 December 1999
Pixel Atlas sub system integration :
The Pixel integration strategy has been modified. The SCT
data structure has been used to create separate tables to welcome
the Pixel's data.
When the data structure and the Web modules
will be validated by the reponsible person of Pixel group, the data
will be migrated to the production database. See.
The SCT production database has been migrated to data structure V5.3
Ph. Demierre
8 November 1999
Pixel Atlas sub system integration :
The Pixel Atlas group decide to use the facilities offered
by the Web SCT application. The data structure has been modified to
welcome the Pixel's data into the same data structure used by
SCT.
First, the pixel administrator group will define their
definition data against the development database. See.
Ph. Demierre
2 July 1999
Java application :
The SCT ABCD automatic chips insertion application is available. See
Ph. Demierre
23th June 1999
Java application :
The SCT Test modules are completed. An email has been sent to the whole SCT collaboration, announcing the availability of the applications. See
Ph. Demierre
16th June 1999
SCT Production database : New data structure and Web modules.
Add new entities Test_ABCD and TSTABCDCHANNELS for ABCD chip tests.
Add a new entity called ASSM_HIST and its Web application module for items disassemblies loggin
New java applications and new Uploading Datafile datastructure
Ph. Demierre
25th May 1999
SCT Production database : New Java applications.
Upload Test data.
Download for raw data
Download for Det IV raw data
See the Documentation.
Ph. Demierre
7th May 1999
Chip test and chip identification discussion
Round table discussion took place at CERN with ABCD chip
experts. Minutes.
D. ferrere, Ph.
Demierre
5th May 1999
SCT Production database : Upgrade of SCT database and Web application DB-1.03
The production DB has been upgraded to DB-1.03.
The
users can insert real data into the SCT DB from the Web
application.
Ph. Demierre
28th April 1999
SCT Production database : Upgrade of Webserver 3.0 to Oracle Application Server 4.0
The Web page "request failed bug...", that
appeared into some frames from the Web application, has been fixed
with this new release.
Ph. Demierre
23th April 1999
Definition of detector test name list.
Approved by Joe and Didier.
DetIVscan
DetMfrSheet
DetVDep
DetILeak
DetInterStripC
DetBiasR
DetAluStripR
DetCouplingC
DetImplantR
DetFlatV
DetDefect
DetRawData
Ph. Demierre
22th April 1999
SCT development database -1.01
upgraded to database -1.02. (Datastructure
4.0)
All validation tests on this new structure must be done
by all the developpers before the 20th of May.
The migration to
the production database is forseen at the 20th of May.
SCT development database : OAS 4.0 Oracle Web Application
Server upgraded from version 3.0 to version 4.0.
The bug "Request
Failed" on browser frame is now fixed.
The upgrade of OAS
3.0 to 4.0 is forseen at the end of April for the production
database.
Ph. Demierre
1st April 1999
SCT production database -2 upgraded to database -1.01.
Ph. Demierre
10th February 1999
Access from java application to SCT production database -2 opened to SCT users.
Ph. Demierre
8th February 1999
SCT production database -2 opened to SCT users.
Reference data migrated from development to production database.
Ph. Demierre
3rd February 1999
Oracle production database is up on melb.unige.ch -> new URL
Geneva WEB application migration complete
New web server for production database set on polux0.unige.ch (html command part)
Reference data still to be migrated from dev to prod database
For password exchange, the secure Web set on scsun29. Still need to be configured.
Ph. Demierre
27 th January 1999
Due to Omnis client boolean representation
problems, all the basic table constraints had to be changed, and all
the WWW modules and triggers had also to be modified and checked.
Ph. Demierre
18 th January 1999
Upload data file into the DB. Test datafile structure example
Ph. Demierre
15th January 1999
Generation of all read only modules
Ph. Demierre
13th January 1999
Ph. Demierre
6th January 1999
Additional modules constraints : Table
Trigger Modules Definition and PL/SQL code Trigger Definition
Ph. Demierre
15th December 1998
Roles Security scheme tested with a Client Oracle FORMS. Security statement sent to Joe Foster in order to test with an Omnis client (forseen 1-1999).
Modules class 2 done
Ph. Demierre
1st December 1998
Modules class 1 done:
Ph. Demierre
27th November 1998 Oracle Roles implementation for OMNIS clients,
submitted to Didier and Joe for agreement.
The Oracle table
trigger mechanism is well understood and will be used to resolve some
data dependancy problem across different tables.
Ph.
Demierre
26th November 1998 The security concept (3 levels) for the WEB is set
and is working well.
level 1 : objects owner
level 2 : packages
owner
level 3 : institut user
The two first modules MFR and LOCN are generated from D2000 and
installed in a secure Oracle user (level 2).
The end user (level 3
: institut user) can execute the modules stored in the user level 2.
These two PL/SQL modules are working well against the owner of the
tables (level 1).
Ph. Demierre
20th November 1998 Outcome of the discussion for defining some
additional TEST entities.
13th November 1998 Outcome of the discussion during SCT week (J.
Foster, P. Demierre, D. Ferrere).
1) LOCNS: LOCN.LOCN number of main server in Geneva will be set to 99. Higher number is not allow. The implication of this is that serial number of item entered on the main server will not be limited.
2) URL length: Set URL length to 200 instead 100.
3) REQUIRED attribute: It moves from TEST_DESCR to TEST_LIST.
4) INSTITUTE list: Need to be checked with M. Tyndel if it should be shortened.
5) USERNAME in LOCN: We proposed Geneva --> GVA, MANCHESTER --> MAN. Joe will propose something for every Institue and will send to us by email.
6) RECV_DATE from SHIP: One decided to remove it since this table belong to the sender.
7) TEST_RAWDATA: FILENAME should be add as a new attribute.
8) TEST_RAWDATA: RAW_DATA we propose that the type is defined as Varchar2 instead Longrow. The point is VARCHAR2 is limited to a size of 2000octets and an alternative is to use LONG limite to 32760octets. Then we can ourself limit the size of RAW_DATA.
9) SHIP_SENT entity: We proposed a new entity with 3 atributes: CONFIRMDATE; LAST_MOD; OWNER. This is required to inititing the trigger1 actions. This linked, on E_R diagram, is 1 to 1 to SHIP (mandatory to mandatory) and SHIP_SENT inherites SHIP_NO as primary key.
Another alternative, proposed by Joe, is not to create SHIP_SENT and place CONFIRMDATE into SHIP. CONFIRMDATE will be null at first, when insert, and when the person is ready to send the box he just updates the valid date into CONFIRMDATE.
10) ONCE in ITEM_DECR: The label ONCE will change to UNIQUE.
11) STOCK: Only the onwer of the item can add stock. But STOCK entity is under responsbility of the owner. No automatism (or trigger) will be set on this entity.
12) Rules: ITEM.ASSEMBLED Should not be updatable and is set to "No" on insertion. In addition, on insertion, LOCN in ITEM table is set automatically to user institute and TEST.PASS is set to "No". To enter an ASSM_ITEM the user should possess all the subitem of the assembly. ITEMS.LOCN_NAME and ITEMS.PASSED should not be updatable. ITEMS.LOCN_NAME is set to the user institute and ITEMS.PASSED is set to 'No' on insert.
13) Rules still to define: Do we allow an user to insert a new TEST entry concerning an ITEM that he does not possess? Same question for ITEM_CMNT.
14) Policy and trigger: Policy: all class2 policy are defined (need to be updated as soon as we have modification in E_R). Trigger: actions are defined for SHIP, ASSEMBLY and DISASSEMBLY.
26 October 1998, database communication test from a java client
application to the new academic database server succesfull.
21 October 1998, the Designer tool Designer2000 (used to design and
build the database objects and the application modules) has been
upgraded from version 1.x to 2.1 .
Old design objects have been
upgraded to the new Designer 2000 tool. The application modules must
be generated again before use.
11 October 1998, The database used to hold the WEB Atlas SCT
application at the university of Geneva has been moved from the old
Sun sparc 2 workstation to the new Sun Enterprise 450 Academic
server.
The SCT Oracle DB of Geneva will be upgraded in mid of October on a
new SUN Server. This machine will be more powerful and the last
versions Oracle 8 and Oracle Application Server 4.0 will be
installed.
When this new DB server of the computing support of the University of
Geneva will be available, 2 versions of the DB will be set. One for
the developpers (Manchester and Geneva) and the other one to put to
the test and accessible to all the collaborators.
A Java application have been developped to allow the upload of the
data from any external file to the DB (See navigation panel).
According to this data upload facility, Labview can directly run this
application to fill a data sheet in the DB thanks to a vi named
Exec.vi. At least it works on platform like PC, HP unix and Sun. This
is not possible on Macintosh but it could be done anyway externally
from a working directory.
On the web DB concept an user account will be set per institute. This
will allow the person who add a new entry into DB to be the only one
who can update or delete it.
Any comments:
Philippe
Demierre, Didier Ferrere