I imagine it's not really that difficult to incorporate data from other databases if you are researcher
I would agree that if you are researching a particular species, then incorporating data from disparate recording systems is not going to thwart you. Saying that it is interesting that I recently read an article about the search for Streaked Reed Warbler, with listed the recent records of this possibly extinct species. As far as I can see, it didn't include 'alleged' records from the Chinese recording system. The top lister in China (who is based in Shenzhen) was surprised when I said there had been no authenticated records in recent years - his view is that it remains a very rare migrant along the east coast of China, which is reported occasionally by the Chinese birdwatching community. Were the authors of the paper missing important data - I would hope not.
If a researcher is looking at the decline of passerine birds in Indonesia and the impact of the cage bird trade, then I think extracting data from disparate recording systems is a bit more complex. And if you are not a researcher, and just want data to plan your next trip, of something less important, collating data from various systems can be difficult. My wife and I find this now when planning trips to China - a bit of data from Ebird, and more from the Chinese system.
I know that we have discussed before how simple it is to combine data and how important a single taxonomy is, and probably have different views. So I will have one last go to try and explain why from a technical/database point of view, multiple versions of taxonomies are bad.
Relational databases, will be behind apps such as EBird, or websites such as the BirdLife datazone. These databases will be comprised of multiple tables linked by primary keys. The actual taxonomic tree fits quite well into a relational database structure - we could have a table for Order, linked to a table for Family and so on for Genus, Species, Subspecies. But the keys linking tables need to be immutable otherwise we will likely throw referential integrity errors when if we try to alter a key. This means that if we want the ability to change the Latin, we cannot use it as a key, but need to have a structure of immutable keys that then reference the Latin. We can now simply change say the genus name in the genus table and any corresponding changes to the species name in the species table. The database is now up to date and we can do this without breaking the key system. In general keys are part of the hidden working of a database, that end user do not see.
If data was recorded in each database to subspecies level, I could export data for Anas crecca carolinensis from a Clements based database and 'convert' and combine this with Anas carolinensis data exported from an IOC based database. However, databases in general do not force submission of records to subspecies level. We therefore get into the more complex territory of having to do regional filters of Anas crecca observations, assuming that they are all Anas crecca carolinensis records in the Americas, but potentially also having to excluding any records reported as Anas crecca crecca. Even the regional filters may be messy to implement, if we consider trying to define geographical limits in the Aleutians and the Pribolof's.
To really make this simple, each database needs to index taxa (and enforce data entry) to a level sufficient to enable taxa to be mapped to other systems. This is where Avibase uses ZooKeys. But to follow my Teal example EBird now has to enforce data entry to 'Common Teal (Green-winged)' & 'Common Teal (Eurasian)', whereas in IOC the two species are already mapable.
The real problem is that the 'level' of identification and data validation, and and code developed to export and import data to databases using different taxonomies has to constantly change. Yes we may be able to predict a new split, not currently recognized in any taxonomy and plan for this, but the export and import functions have to cater for even minor changes such as variations in Genus or species name spelling... to a binary computer a one letter difference in spelling is not a equal, although a human brain can see that the two are probably variations of the same. As you can imagine, with annual or biannual updates to various taxonomies, keeping mapping levels and export and import functions current becomes a large task. And with EBird as they don't force data entry to 'group' level (hopefully of sufficient granularity to allow mapping) we already have problems.
If we want to do what the Scythbill database does, which caters for two different taxonomies, things get more complex still. I have been developing a database catering for three taxonomies, and you basically have to create a core list of mapable taxa, and then create mapable taxa tables in each taxonomy, so that each taxonomy can be linked in - you basically end up with three sets of tables connected via a central mapable tax. Maintaining and updating this structure is proving laborious - it is very difficult to fully automate, and requires a level of input to say that X has changed to Y (it is pretty hard to write code that can spot this automatically). Furthermore, the size of the database, and the code to display the data in different taxonomies becomes larger and more complex. If things were that simple, then I am sure that EBird or BirdTrack would have already catered for users, wishing to use different taxonomies.
In the electronic age, if we could settle of a single taxonomic concept, then all the above problems melt away, and we can export and import information purely on a common Binomial Nomenclature.
I suspect that when Carl Linnaeus created the Binomial Nomenclature, his intent was to have a
unique system to index all species. If he knew that various authorities were developing their own variations, and in a way corrupting the indexing system, I am sure he would be turning in his grave. If we never changed or had variations in Latin Order, Family, Genus, Species and Subspecies names, but merely added and deleted names, then his system would be a good primary key system for any modern database!
I suppose at the end of the day, the debate over having differing taxonomies comes down to whether you are a fan of 'freedom of opinion' or a fan of 'functionality over freedom of opinion'. I am the latter and therefore strongly believe there should only be one indexing system.