National Informatics Centre Centralizes 250 Million Vehicle and Driver Records, Improves Service Quality, and Increases Revenue by up to 50%
 
 

National Informatics Centre Centralizes 250 Million Vehicle and Driver Records, Improves Service Quality, and Increases Revenue by up to 50%

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%.

 
 

 
 

Challenges

A word from National Informatics Centre

  • “Oracle Data Integrator offered the most cost-effective method of centralizing millions of vehicle and driver records stored in different databases across the country. We have significantly improved the quality of services delivered to citizens and agencies by enabling real-time data sharing, rather than waiting days for hard-copy documents, and we have increased revenue by up to 50%.” – Dr. Mahesh Chandra, Deputy Director General, National Informatics Centre

  • Consolidate vehicle and driver information held in more than 1,000 regional databases into state registers and a single, national register
  • Enhance data quality to ensure the accuracy and consistency of reports used for decision-making
  • Provide 24x7 data services without shutting down the system and disrupting business operations
  • Ensure data integrity in the event of a disaster at RTOs
  • Allow faster and more effective access to driver and vehicle records for law enforcement authorities
  • Eliminate citizen dissatisfaction with long registration lines and license issuance times
  • Relieve staff burden to check driver and vehicle information when preparing reports and interdepartmental communications
  • Improve the ability to track vehicles as they move from region to region across India
  • Reduce the risk of illegal acts, such as bogus registrations and nonpayment of fines

Solutions

Oracle Product and Services

  • Centralized more than 250 million vehicle and licensing records from more than 1,000 databases across the country into 35 state registers and 1 national register
  • Increased revenue by up to 50%, by enabling staff to use state and national registers to track drivers with outstanding payments, even if they have moved to another state
  • Improved citizen satisfaction by reducing processing time for tasks, such as renewing driving licenses and certifying vehicle registrations from three days to one day
  • Shortened the waiting time for services, such as paying permit fees and road taxes, from up to four hours to 20 minutes, by introducing online applications and payments
  • Reduced the error rate for processing driver’s licenses and vehicle registrations from 10% to less than 1%, as citizens can complete applications themselves rather than involving a third party
  • Enabled real-time sharing of vehicle and driver data with law enforcement authorities, rather than waiting days for paper records to be sent by post
  • Cut staff administration costs by enabling transport offices to quickly search for vehicle and driver data in a single register, which will eventually contain the details of 120 million drivers across the country
  • Lowered total cost of ownership by introducing new, information services for enforcement staff and citizens, and by easily replicating data at regular intervals, rather than investing in dedicated hardware and software
  • Ensured departmental data is available 24x7 and can be easily viewed using dashboards and scoreboards, enabling efficient query and analysis, with information to be shared with police or insurance companies
  • Shortened recovery times and ensured 100% data replication in the event of a disaster, by using Oracle Data Integrator’s scheduler agents to regularly feed updates in RTO databases to state registers and vice versa
  • Increased the accuracy and reliability of vehicle and driver data through rigorous data cleansing and deduplication techniques, ensuring the accuracy of reports generated to support decision-making
  • Improved services by introducing online fee payments, license applications, RTO appointments, and status tracking, minimizing the need for citizens to physically visit RTOs
  • Enhanced productivity and staff satisfaction by automating report generation and interdepartment communications, freeing more employees to provide face-to-face citizen services
  • Minimized illegal activities by enabling enforcement officers to access both state and national registers to instantly authenticate driver and vehicle details

Why Oracle

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.”

Implementation Process

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.”