Oracle and AIA Advanced Information Access and Advanced Information Access's experience in implementing sophisticated Oracle database solutions was recognised in 1997 when AIA was appointed an Oracle Reseller. The role of Data Base Administrator is key to any successful Oracle implementation. Our DBAs bring together commercial knowledge and technical expertise to be able to fulfill this ever more demanding role. This requires a three-way balancing act between understanding the business objectives, implementing an optimal data structure, and adapting this to the requirements of the application designers.
Databases can take two main forms.
Our DBAs are expert in both these areas. Data Loading Loading data into an Oracle database is one of those requirements that is so obvious that it tends to be forgotten until quite late in the design stage. The initial load into any Oracle database will be from a variety of possible sources, from other relational databases to legacy systems. In all cases data validation and cross indexing procedures are essential to ensure the integrity of the data. Any substantial Oracle system will have an ongoing requirement to capture live data from a number of sources outside the Oracle environment.