A Preliminary design of BEPCII database system

1
A Preliminary design of BEPCII database system

• Database Group
• Computing Center of IHEP
• Aug/20/2002

2
Contents

• Designing Goals
• About Database
• Data Stored
• System Functions
• Hardware Solution Choice
• Software Solution Choice
• Testbed

3
Designing Goals(1)

• Database system plays an important role in the
  control system of BEPCII accelerator.
• The real-time data, history data and other
  relevant information of the control system will
  be stored in the database.
• Through network and the friendly man-machine
  interface
• users can share the data and information of the
  control system.

4
Designing Goals(2)

• keep a good knowledge of the running status of
  BEPCII.
• process various kinds of data and information and
  do online and offline analysis

5
About Database

• EPICS database
• a distributed real-time database resident in
  VME/IOC memory. Its used to store raw data of
  devices channel signals.
• Oracle database
• a commercial RDBMS, which is used to manage
  all static ,dynamic data and project management
  information.

6
Data Stored (1)

• Static parameters
• machine parameters
• parameters of lattice, twiss and magnet,
  mechanical and alignment parameters
• Equipment information
• device name, signal name, physical I/O
  address, scientific unit, calibration factors and
  alarm conditions.
• Configuration parameters

7
Data Stored (2)

• Dynamic parameters
• Device data
• device status, readings and settings
• Alarm data
• records of device alarm
• Beam parameters
• BPM data, closed orbit parameters, DCCT.
• beam current and so on.
• All the real-time data are recorded with time
  stamp.
• They are stored in binary and floating point
  numbers.

8
Data Stored (3)

• Management information
• Project management information
• the documents of accelerator design, budget,
  CPM plan, etc
• Technical files
• the documents for the accelerator
• commissioning, HELP manuals, device
  maintaining files and other technical files.
• Personal information

9
System Functions (1)

• Robustness
• running on 24x7 heavy-duty system
• fault-tolerance procedure
• Concurrency
• Data consistency in the case of multiple
  queries (Select/Update/Insert)
• Friendly User Interface
• Graphical user interface
• Client/Server and WWW as two manners to access
  the BEPCII database.

10
System Functions (2)

• Graphic display
• some parameters in the database can be plotted
  with 2D or 3D graphic tools
• Database access control
• only authorized users can add, delete or
  modify records in the various tables, or change
  the configuration parameters.
• API (Application Programming Interface)
• Allow access of a user application to oracle
  database by providing API tools

11
System Functions (3)

• Quering
• records can be searched in specific condition
  and displayed in both form of tables and graphics
  
• Loading
• datum can be imported into Oracle database
  from an ASCII file or a MS Excel file.
• Exporting
• datum can be exported into MS Excel
• allowing datum transported from the database
  to a remote site in special form.
• Display alarm records in a table

12
Hardware Solution Choice (1)

• According to performance/cost ratio,
• choose Sun server as mainstream platform.
• Database Server
• Type Sun Fire V880 Server
• CPU2 x 900MHz UltraSPARCIII processor
• Memory4GByte
• I/O FC-AL disk controller
• Disk6 x 73GByte 10KRPM internal FC-AL Disk
  Driver
• NetworkGigabit Ethernet and 10/100-BaseT
  Ethernet
• Internal tape Optional 12 GB DDS-3 or 20 GB
  DDS-4 single drive(s)
• Power3(N1 random)Power Supplies and fans

13
Hardware Solution Choice (2)

•  
• Application Server and WEB Server
• TypeSun Fire280R Server
• CPU1 x 900MHz UltraSPARC III CPU,
• 8MByte UltraCache per Processor
• Memory1GByte Memory
• Disk2x36.4GB 10K RPM Internal FC-AL Disk Driver
• Network10/100-BaseT Ethernet
• PowerTwo Power Supplies

14
Software Solution Choice(1)

• Database Management System
• Oracle 9i is the preferred platform for the
  reasons as follows
• Oracle database is widely used in control system
  of HEP institutes throughout the world , such as
  KEK, BESSY, SLAC and so on. It will make our
  collaboration with these lab more easier.
• Oracle 9i is the first ORDBMS (Object Relational
  Database Management System) providing a nearly
  complete set of object-oriented features, which
  makes ORDBMS become a interesting candidate for
  HEP data storage.
• The database application of BESIII and ARGO
  experiment should be taken into consideration.

15
Software Solution Choice(2)

• Development tools choice
• There are many software development tools in IT
  market, which in general are classified into IDE
  (Integrated Development Environment) tools and
  command-line-based tools.
• IDE tools have high efficiency in the development
  of software, but may need more system resource.
• Considering persistency environment, selecting a
  suitable development tool is a key in our system
  building.

16
Software Solution Choice(3)

• IDE Tools Oracle 9i Designer, Oracle 9i
  JDeveloper
• Non IDE Tools C/C, Java, Perl, PHP
• We intend to use IDE tools  
• such as Oracle 9i Designer or Oracle 9i
  JDeveloper

17
Software Solution Choice(4)

• Software Engineering Tools
• It is crucial to adopt Software Engineering
  Methodology to develop a large software project .
  
• UML(Unified Modeling Language) is the
  industry-standard language . It simplifies the
  complex process of software design, making a
  "blueprint" for construction. It can be applied
  to the various phases of software life cycle.
• UML will be used as tools to develop database
  system for control system in whole software life
  cycle.

18
Project Schedule(1)

• The database management system developing in our
  schedule should keep up with BEPCII project.
• We will obey the Software Engineering
  Methodology based on software life cycle
  reference model to develop this software.
• Details for phase and schedule go as follows

19
Project schedule (2)
 
20
Testbed (1)

• Last year we built an Oracle database testbed
  environment on Linux for the SAN(Storage Area
  Network) project.
• We have gained some knowledge of data processing
  .
• A small database system of real-time data of
  beam diagnostic system have been completed using
  PHP language and Oracle development tools.

21
Testbed (2)

• Three Layers System Architecture

22
Testbed (3)

• Database Server
• ORACLE 8i R2 Enterprise Edition for Linux
• Client
• Any computer that supports HTTP protocol browser
• Application Server
• Web Server Apache Web Server
• Development tools
• PROC , Oracle OCI (Oracle Call Interface) ,
  PL/SQL , PHP ,Java

23
Testbed (4)

• PROCC/C An Oracle Precompiler is a
  programming tool that enables SQL statements
  embedded in context of c/c coding.
• Oracle OCIproviding the head files and function
  libraries as a set of oracle API for C/C
  calling.
• PL/SQL Oracle provides a Procedural Language. It
  supports SQL and Oracle object-oriented
  programming, allowing one to create software
  components that are modular, maintainable, and
  reusable.
• PHP the abbreviation " Hypertext Preprocessor.
  It is an HTML-embedded scripting language. which
  looks similar to C, Java and Perl in syntax . It
  runs on server end. The language is aiming to
  allow web developers to write dynamically
  generated pages quickly.
• Java Which is a complete object-oriented program
  language. It has a powerful ability of platform
  migrating.

24
Testbed (5)

• System Function modules
• Data acquirement
• Real-time data display
• History data query
• History data graphic handling
• User authentication

25
Testbed (6)

• Figure 1 the quering results of history data

26
Testbed (7)

• Figure 2 the running status of BEPC

27

• Thanks !