The Government of India’s National Informatics Centre (NIC) is the primary supplier of technology services to government agencies across the country. Established in 1976, the organization provides a national network that serves as the backbone and support for e-governance projects that touch virtually every citizen in the country.
To provide vehicle registration and driver’s licensing services, India has more than 1,000 regional transport offices (RTOs) across the country. The offices undertake vehicle inspections, issue plate numbers and registration tags, provide driver’s licenses, and collect vehicle taxes and traffic fines. Until two years ago, each RTO maintained its own database, containing details of all vehicles and registered drivers in its area. In 2011, the Government of India decided to centralize these records and asked NIC to oversee the project.
NIC selected Oracle Data Integrator to feed all driver and vehicle records in RTO databases into state-based databases (state registers), then into a single, national database (national register). These records can now be accessed in real time, compared to taking days previously, improving the quality of service to citizens, law enforcement agencies, businesses, and other government agencies. NIC has also reduced the total cost of database ownership by improving data back up and introducing new information services for enforcement staff and citizens, which has increased revenue by up to 50%.
NIC had used Oracle products, including Oracle Database, in a range of areas for more than 10 years. The organization’s experience with the software gave it the confidence that Oracle Data Integrator could deliver a single, centralized database using information drawn from more than 1,000 RTOs across the country.
“Maintaining information in small databases held by each RTO was simply not an efficient way of operating,” said Dr. Mahesh Chandra, deputy director general, National Informatics Centre. “After reviewing a range of options, we decided to use Oracle Data Integrator as the solution had the robustness and scalability to support the large-scale nature of the project.”
NIC took advantage of Oracle Data Integrator’s built-in knowledge modules to help streamline the task of centralizing data from a range of smaller databases, including Oracle Database and Microsoft SQL.
“Oracle Data Integrator enabled us to pull vehicle, driver, and license details from many different places into state-based registers,” said Chandra. “From there the data was fed into a single national database. The result is a much more effective system that can better support government, law enforcement, and citizens.”
NIC worked with Oracle Consulting during the Oracle rollout. The knowledge module was customized before the data was transferred into state registers and the national PostgreSQL database. The transfer process will be completed in 12 months.
“We realized we had a complex task on our hands, with a very large number of records stored in multiple types of databases across more than 1,000 locations,” said Chandra. “However, through the use of Oracle Data Integrator, we were able to centralize this data and provide faster, more efficient access to driver and vehicle information. The solution has made a significant, positive difference to government and law enforcement processes.”