Database Management

We have in place systems & facilities suitable for hosting large scale databases of up to 10 million records. We can provide the perfect solution for your growing data management needs, giving you the power not only to input and store data, but also to manage it in a useful way and effective way.

Our systems can be customised to suit you, with unique reference numbers, names and addresses, telephone numbers and up to 250 additional fields. Therefore allowing you to update records, do rapid searches, combine lists for easy retrieval, download records and carry out file outputs like mail merge.

Fast counting and selections

We at iSource have campaign management facilities which have been solely built to maximise performance at all times supporting multi-user environments. They can work with dedicated counting engines so that the network load is minimised and users are guaranteed to get the highest performance.

Online applications

We incorporate a fully featured high speed web application that enhances both the functionality and scalability of the system.

Marketers without specialist IT skills can access a server over the intranet or internet to analyse and explore data, make cross tabs, Venn diagrams, RFV analyses, profile reports and response models. A campaign planning module performs rapid hierarchical de-duplication down a matrix of marketing cells, calculating the net and cumulative counts and costs.  

Data Processing

We emphasise great importance on the quality of data. Lists invariably need processing in some way in order to make them clean, current and useable.

Our advanced data processing systems are comprehensive and powerful, ensuring that you deliver the right message to the correct individual without duplication and at an economic cost.

Fast and Accurate Service

iSource uses the DEM database management system, which can output two million records in less than eight minutes and match over a million records within an hour. We can usually complete data counts within two hours and supply data outputs by email on the same day.

Our data processing services include:

• de-duplication across multiple files from multiple sources
• mailsorting
• re-formatting of data
• case normalisation
• file screening against FPS, TPS, MPS and EMPS
• screening against the proprietary 'gone away' files
• credit screening customer and prospect data
• mailsorting

With companies and projects that iSource has under its belt, you can relax knowing your database is in safe hands.

Database Design

Correctly designed and installed database systems can save huge amounts of time, and therefore money, in the workplace. iSource consultants possess a vast amount of experience producing systems which are both powerful and easy to use for the end user. We can develop database applications in a variety of different formats depending upon your requirements:

• Single-user databases installed on individual machines
• Multi-user corporate databases delivered over a local area network
• Web-based applications for anywhere anytime access

A very important part of our service is not only the system itself, but the user support we offer. All of our database projects come with 3 months user support absolutely free. You also have the option of continuing the support after the three months by subscribing to our Support service. We can also provide customised tutor-led or CBT based training for users of the system, as well as a user manual or system help files.

Our Database Management service can be used to help administer the system once it is up and running. The service includes data backup, performance tuning, security management and free advice from your own dedicated Database Manager. Find out more by visiting the Database Management tab on this page.

Our consultants are experienced in working with a variety of technologies - including Microsoft Access, SQL Server, NET and proprietary equivalents MYSQL, postGRES. We'll make sure the technology we use matches your requirements and budget. All our work conforms to recognised standards and best practices.

Unlike many other development companies, iSource provides full source code and technical specifications for all the work carried out. This means that if you should require any updates to the system later on down the road, you have the flexibility to use who you like for the work (i.e. develop it in-house, use iSource, or use another development company). We rely on the fact that you'll come back to us because we've done a good job, not because we have retained the vital technical documents that are needed to make such changes.

For more information and advice on databases, please contact us for a free no-obligation consultation.

Data Analysis

80% of your sales from 20% of your customers! A well known conundrum facing most Marketing Professionals. Do you really understand who your customers are and what they want? Would you like to understand who your customers are? and how to make them buy from you?

There are more answers sitting in your customer database than you might appreciate.  iSource are experts at unlocking the wealth of information buried in your customer database and we really know how to get your data talking to you.  We do not stop there, the good news is once we’ve identified who your best customers are we can give you unlimited access to more of your most profitable customers from our highly developed  Business Knowledge base of nearly 2.2 million actively trading UK companies.

We understand customers; who they are and what makes them choose you.  Allow us to help you unlock the potential of your customer databases.  

Talk to us and we will get your data talking to you!

Our range of data analysis services include:

• Effective data coding to ensure successful analysis
• Transforming, re-structuring, aggregating and managing data
• Descriptive statistics -  when to use them and how to interpret them
• Assessing relationships between variables -means, cross tabs, chi-square and correlation
• Visualising relationships through charts and graphs
• Presenting information clearly and effectively through reports and tables

To do this, we use statistical analysis techniques such as:

• "Multiple Regressions" - building models to predict behaviour
• "Logistic Regression" - developing advanced scoring models
• "Analysis of Variance" - to understand the differences between customer groups
• "Chaid" - segmenting data to improve customer retention and campaign response
• "Clustering and Discriminate Analysis" - classifications to help understand your  markets
• "Time Series Analysis" - to help you forecast demand

Database Services

A good maintenance strategy is vitally important for any database. However, administering a database is a skilled job which requires in-depth knowledge and experience. If you haven't got a member of staff that fits the bill, our Database Management service will help to remove the hassle from keeping your system up and running.

The scheme is particularly recommended for systems built on SQL Server and includes data backup, performance tuning, security management and free advice from your own dedicated Database Manager.

Data Backup

Hopefully, you haven't learnt the hard way, but most people appreciate that backing up your data regularly is a MUST. You cannot afford to loose important business data. Once a backup schedule is agreed (following advice from our consultants), iSource can take care of all backup duties, as well as restoration of data if the worst does happens.

Performance Tuning

"The system's being really slow today..." - a common complaint from many users. This could be for a number of reasons. Through procedures such as index building, examining logs and error reports, and monitoring transaction logs and growth settings, iSource can help keep your database running as efficiently as possible.

Security Management

Security is an important part of any system, but does need regular maintenance. iSource can take care of tasks such as registering new users, deleting redundant users and managing permissions and access rights to keep your system secure and up to date.

Advice from your own Database Manager

If you subscribe to our Database Management scheme you'll be assigned your very own database manager. Your database manager is your sole contact for everything to do with your system. He/she will be able to answer any questions you have and give free advice on the best strategies to get the best out of your system.

The Database Management service does not include end-user support. For this you should also subscribe to a Support scheme.

As an alternative to the scheme you might want to consider training a member of your own staff to act as the database administrator, particularly for some of the more simple tasks. iSource Solutions can provide tutor led training customised to your system to help you achieve this.

Database Solutions

• Oracle database schema modifications
• Database reorganizations and row re-sequencing for performance 
• Migration of database objects
• User and security management
• Oracle data migrations and refreshing test databases
• UNIX support for AIX, HP/UX, Solaris, Linux
• New database set-up and configuration
• Set-up and installation of backup and recovery software
• Oracle disk architecture and disk load balancing
• Oracle SQL Tuning
• Oracle design reviews
• Installation of the Multi-threaded server
• Installation of Oracle Parallel Server
• Creation of Oracle standby database and failover databases
• Installing advanced replication
• Installing the language pre-compilers (Cobol, C)
• Implementing change control procedures 
• Implementing KEEP & RECYCLE pools
• Implementing multiple blocksizes
• Building self-tuning database mechanisms
• Implement automatic segment space management
• Implementing new database features

OS Services

• Migration – Any OS to Linux
• Linux and Unix Consulting
• 24 x 7 Linux and Unix Support
• Linux and Unix Technical Support
• Remote Linux and Unix Administration
• Linux Kernel Configuration and Tuning
• Linux and Unix Performance Tuning
• 24 x 7 Linux and Unix Server Monitoring
• Server Auditing Services
• Server Maintenance
• System Auditing

Network Security Services

• 24 x 7 Network Monitoring Service
• Network Administration Service
• Network Auditing Service
• Deploying Intrusion Detection System (IDS)
• Deploying Network Scanner System

Introduction

Customers must provide Database DBA with full, external, secure remote access to the server via Internet in order to collect information and to perform database support and system support functions. This Database access can be provided through any mechanisms like SSH, PC Anywhere, or VNC, or VPN. If available, we can use a VPN to access the customer's database server infrastructure.

The server must have access to an SMTP mail server to send email messages to the Internet.

DATABASE DBA provides remote services through:

• Secure VPN connection
• Humming Bird
• VNC screen share
• 24 x 7 phone support
• 24 x 7 chatting support
• 24 x 7 video conferencing support

Our Packages

UNIX/LINUX Management

Remote Unix & Linux Monitoring

DATABASE DBA's UNIX & LINUX service provides 100% of the remote UNIX & LINUX needs for your company.

Our UNIX monitor continuously checks the following server metrics:

Remote Unix & Linux Administration

DATABASE DBA provides expert solutions for all your Unix & Linux system administration needs, including:

System Administration:

• Remote server administration
• System troubleshooting & debugging
• Network management (LAN/WAN)
• Disaster recovery
• Security auditing & hardening
• Software installation & configuration
• File & directory services, NFS
• Kernel rebuilds & module management
• Backup planning & implementation
• Perl-Shell-CGI-system scripting
• Performance tuning
• Emergency support (24/7)

Internet Support & Management:

• Apache WWW server, SSL, PHP, CGI
• Sql, MySql, Oracle install & managment
• Sendmail, Qmail, VpopMail, POP, IMAP
• DNS-BIND (Bind8, Bind9, Balancing)
• FTP, Virtual FTP servers (Proftp, WU)
• Load Balancing/Clustering
• OpenSSL-OpenSSH-Stunnel
• Anti-Spam, Anti-Relay SPEWS-ORBS
• IPtables-IPchains configure and tuning
• SAMBA deployment & configuration
• DHCP & TCP/IP Management
• IP Masquerading & NAT
• LPR & Print services

Security & Firewall:

• Security auditing & updating
• Linux router firewall design-configuration
• IPtables-IPchains configure and tuning
• Network security auditing & hardening
• Security alert and upgrade management
• Disaster & compromise recovery
• Data & colocation center auditing
• TCP wrapper & PortSentry
• SSH-OpenSSH-OpenSSL

Infrastructure Management Services

DBA Services

Our database services provide for secure, optional management and increased database productivity...Please contact us

Data Center Services>

We offer complete data center management services that can help you organization capitalize on business Opportunities and result in real improvements in profitability. We specialize in managing data centers for ISP's and Hosting companies

Server Services

We help you manage your server environment and backup effectively to maintain performance at optimum levels. Our servers and backup management offerings ensure that server parameters and operating systems are Administered and tuned well

Network Services

• Network Audits
• Remote Network Outsourcing Services
• Network management and Support Services

Security Services

• Security Audit Service
• Vulnerability Assessment Service
• Managed Security Services

Intrusion Detection System

NET VAULT IDS Appliance is an integrated hardware and software solution. It provides advanced Intrusion Detection and Intrusion Prevention functionality that analyzes your network traffic and automatically stops attacks 24x7

What we do

1. Creates and maintains all databases required for development, testing, education and production usage.
2. Performs the capacity planning required to create and maintain the Sdatabases. The DBA works closely with system administration staff because computers often have applications or tools on them in addition to the Oracle Databases.
3. Performs ongoing tuning of the database instances.
4. Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
5. Plans and implements backup and recovery of the Oracle database.
6. Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
7. Implements and enforces security for all of the Oracle Databases.
8. Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.
9. Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to.
10. Evaluates releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate. Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact.
11. Provides technical support to application development teams. This is usually in the form of a help desk. The DBA is usually the point of contact for Oracle Corporation.
12. Enforces and maintains database constraints to ensure integrity of the database.
13. Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
14. Assists with impact analysis of any changes made to the database objects.
15. Troubleshoots with problems regarding the databases, applications and development tools.
16. Implement and maintain database security (create and maintain users and roles, assign - privileges).
17. Manage sharing of resources amongst applications.
18. Manage physical database design.
19. Perform database tuning and performance monitoring.
20. Work as part of a team and provide 24x7 support .

Why hire Database DBA

Cost Savings & Control:

Less cost than the annual salary of a junior DBA, because you're sharing the resource with other companies. Subscription basis - scope and costs are defined up front.

Get exactly what you need:

Outsource specific DBA functions without giving up control of the IT assets. Provide monitoring, reporting, database restoration, recovery, maintenance and proactive tuning.

Staffing Efficiency:

Manage your business critical systems with fewer people, and at a lower cost by providing remote support for the database environment on a 24 X 365 basis (or less). Avoid the high turnover associated with DBAs. When a DBA leaves, they take your training investment and your peace of mind with them. No need for over-staffing to provide redundancy.

B2B Data Modelling

Interface Modelling is a vital tool for strategic planning and forecasting; enabling us to predict what is likely to happen by studying what has happened in the past.

iSource has modelling processes that are second to none in business marketing Focused at business products and services. iSource additionally has good ties with agencies of demographic information pertaining to lists of demand and market avenues.

Some key segments of Focus

Market segmentation:

• Analysing market segments
• Identifying clusters and hot spots
• Targeting key market segments and individual prime prospects
• Assessing and quantifying the potential of different groups
• Producing lists of qualified prospects

Business planning:

• Network planning: coverage & capacity
• Identifying areas of high revenue potential
• Prioritising network rollout
• Quantifying the potential offered by new and existing products
• Market entry and roll out strategies
• Campaign planning
• Database Enhancement

Where the opportunity presents itself, when there is business intelligence that is critical to an operation, in terms of targeting or reporting on commercial opportunities and hotspots, iSource invests into researching further intelligence on existing customers or new customers.

With many different sources that we call upon, we have evolved our system of enhancing data via various transactional and behavioural channels into the iSource Knowledgebase. This is our own bespoke business intelligence universe, which features up-to-date records supplied by the government, business intelligence data owners, financial credit assessment organisations, public records, our own bespoke research (by industry sector), market research suppliers and business list specialists.

The iSource Knowledgebase over 35 business intelligence sources providing hundreds of variables on over 2 million business customers resulting in one of the most comprehensive business intelligence sources in the UK today.

For more information on our Data Modelling services via our telephone number or contact form.