Elements: Face Recognition, missing link between sqlite database "metadata_string_table and "tag_table"

  • 1
  • Question
  • Updated 6 months ago
  • (Edited)
Hi all,
In order to understand the face recognition database I understood, the face recognition data of a catalog is stored in C:\ProgramData\Adobe\Elements Organizer\Catalogs\...\FaceAnalysis\json in json-files. Each file matches one foto found in the catalog and consists of a json structure containing"faces" :

"faces" : [{"id" : "0","asset_id" : "709077", # <- this is the file-id in media_table"person_id" : "57c869cf-eb65-4dba-9150-6bc3914d0240", # <<<<-- link to tag_table ??????&nbsp;
"confirmed" : false, ... and so on ...
I also opened the catalog file in sqlite3 and found a couple of tables, of which  the table "metadata_string_table"  stores the  json person_id: in this case e. g. "57c869cf-eb65-4dba-9150-6bc3914d0240" 

1. What is the missing link between "metadata_string_table" and the face-tags in "tag_table"? There seems to be no FOREIGN KEY Chain between the 2 tables. The metadata-tables seem to form an island not connected to the rest of the tables. 

2. What is the meaning o a hex-string like "57c869cf-eb65-4dba-9150-6bc3914d0240"? It seems to be no UTFxy-encoding or numbers. 

Could anybody answer my question or handover this question to the appropriate developper?Regards, thank-you
Photo of Dr. Andreas Alef

Dr. Andreas Alef

  • 3 Posts
  • 0 Reply Likes

Posted 7 months ago

  • 1
Photo of Dr. Andreas Alef

Dr. Andreas Alef

  • 3 Posts
  • 0 Reply Likes
Nobody to answer my question?

Photo of Michel BRETECHER

Michel BRETECHER, Champion

  • 1315 Posts
  • 277 Reply Likes
I have never seen any answer in this forum about how Elements (or any other Adobe software) works internally.
Did you really expect an answer?
Yes, I know that you have been sent here from the Elements user to user forum by a member of the help desk in India. Your question has been read, no doubt about it. That's all.