A01 chaf6542 06 se fm indd

data 

migration

. For an e-commerce system for a bank, for example, this would involve transfer-

ring or exporting data on existing customers and importing them to the new system. This 

is sometimes also referred to as ‘populating the database’. Alternatively, a middleware layer 

may be set up such that the new system accesses customers from the original legacy data-

base. Before migration occurs it is also necessary for a member of the development team 

known as ‘the database administrator’ to create the e-commerce databases. This can be  time- 

 consuming since it involves:

Data migration

Transfer of data from old 

systems to new systems.

M12_CHAF6542_06_SE_C12.indd   610

7/22/14   1:41 AM

---

611

Chapter 12  Digital business service implementation and optimisation

   

● 

  Creating the diff erent tables by entering the fi eld defi nitions arising from the data model-

ling  described  in   Chapter   11   .  

  

● 

  Creating the diff erent roles of users such as their security rights or access privileges. Th ese 

need to be created for internal and external users.  

  

● 

  Creating stored procedures and triggers, which is eff ectively  server-  side coding to imple-

ment business rules.  

  

● 

  Optimising  the  database  for  performance.   

 Supporting search engines is significant where companies migrate their content to a new 

domain name or use a different CMS or commerce server which uses different document 

names. There is a risk that the search engine will lose the history of previous ranking based 

on backlinks to the site and its pages. To manage this a mapping can be provided to redirect 

from the old to the new pages known as a ‘301 redirect’ on Apache servers.