More Related Content
What's hot (20)
Similar to Web Database integration (20)
Recently uploaded (20)
Web Database integration
- 2. What is Database Integration ?
- 3. Database integration means that multiple different applications have their data stored in a specific database the integration database so that data is available across all of these different applications. In other words, the data is available between two different parties and therefore, can be easily accessed and implemented into a different application without having to transfer to a different database. For the database integration to work successfully, it needs to have a plan that allows for all of the client applications to be taken into account.
- 4. Database Integration Database integration or data integration refers to combining a database with your web site so that web visitors can add, remove and update information in your database using a web browser. Most database integrated sites also allow users to search the database too. Drawing on our expertise in various platforms and software applications, we will work with you to develop and implement a strategy that ensures your data is accurate and timely and enables communication among your donor database, software applications and other databases
- 5. Advantages of integrating your systems include the ability to Access information from across your organization with a quick, single search Use all the information your organization collects on donors, prospects and others to help manage your relationships with them Efficiently maintain your information and mine data.
- 6. Requirements Analysis The most important step n implementing a database system is to find out what is needed — What type of a database is required for the business organization, daily volume of the data, how much data needs to be stored in the master files etc. In order to collect all this required information.
- 7. Database Design In this stage the database designers will make a decision on the database model that is perfectly suited for the organization’s requirements. The database designers will study the documents prepared by the analysts in the requirements analysis stage and then start developing a system that fulfills the needs.
- 8. Evaluation and Selection Once the data model is designed, tested and demonstrated, the next phase is to evaluate the diverse database management systems and choose the one that is perfectly suited for the requirements of the organization. In order to identify best performing database for the organization, end user should be involved in this phase.
- 9. Logical Database Design Once the evaluation and selection phase is completed successfully, the next step n the database development life cycle is logical database design. The conceptual design is translated into internal model in the logical design phase. This includes the mapping of all objects i.e. tables design, indexes, views, transactions, access privileges etc.
- 10. Physical Database Design Physical database design is the procedure of selecting and characterizing the data storage and data access of the database. The data storage depends on the type of devices supported by the hardware, the data access methods and the DBMS. Physical design is mainly significant for older database models like hierarchical and network models.
- 11. Implementation In most databases a new database implementation needs the formation of special storage related constructs to house the end user tables. These constructs typically comprise storage group, table spaces, data files, tables etc.
- 12. Data Loading Once the database has been created, the data must be loaded into the database. The data required to be converting and migrating to the new database, if the loaded data is currently stored n a different system or in a different format.
- 13. Testing and Performance Tuning The next phase is testing and performance tuning, this phase starts soon the data is loaded into the database. In this phase, database is tested and fine-tuned for performance, integrity, access and security constraints. It is very important that the database administrators and application programmers work together during this phase, because testing and performance tuning happens in parallel.
- 14. Maintenance Database maintenance phase is very important and it is one of the ongoing phases in DDLC. Factors such as new business needs, new information requirements, acquisition of new data etc will make it essential to formulate ongoing changes and improvements to the existing design. The major tasks in this phase include: database backup and recovery, performance tuning, design modifications, access management and audits, usage monitoring, hardware maintenance, upgradation etc.