Dana ponedjeljak, 23. prosinca 2019. u 14:50:24 UTC+1 korisnik vldm10 napisao je:
In my approach to database theory, I have built the beginnings of the following 8 new theories listed below that are related to data and databases. These 8 theories are interrelated and
good database design is not possible without any of them. This my solution are available on my following websites:
www.dbdesign.com and
www.dbdesign11.com
These theories are mathematical theories, meaning these are theories of general character, it is not a technical software from some company.
The first of these theories that has been built is the theory of atomic data structures. This means the following: what are the basic building blocks of data and informations.
1. Theory of atomic data structures.
Atomic data structures are actually attributes of entities.
The most famous attempts to construct atomic data structures are 6NF by C. Date & H. Darwen and the Surrogate key by Edgar Codd. These two attempts to obtain atomic data
structures are unsuccessful.
In my database theory, there is only one operation with data, it is „add data to database“.
I have given examples in two well-known user groups , that by using „anchor modeling“ you can make criminal actions.
2. Theory of events that are related to atomic data
There are only two events related to atomic data. It is the event of the beginning of a state from some atomic data structure and the event of the termination of some atomic data
structure. In other terms it is about new states and about „closing“ existing states of atomic data structures.
3. Theory of identification
In existing database theory, it is common to work with keys. I introduced the new theory of identification of attributes, entities, and relationships. Instead of "keys" I use my Theory of
Identification.
4. Theory of states of entities and relationships
States of entities and states of relationships have been introduced. Also identifiers of states of entities and identifiers of states of relationships have been introduced. This theory is
relate to temporal data and some other important data from some important theories. (Here I use the old Latin word „identifier“)
5. Theory of n-temporal data
Date, Darwen and Lorentzos tried to solve bi-temporal data. However, not much of the significant bi-temporal data has been done here.
For example, they did not present a solution for the erroneous data.
6. Theory of changes of entities and changes of relationships
How to formalize the following: that the changed entity is again that entity. This is a difficult problem. Simply put, my solution is usage a single (fixed) identifier of an entity, even though
this entity has changed over time. All changes of entities I treat as other entities but which are special states from the corressponding original entity. Each state of an entity has its own
identifier of the state of the entity. In this way I bind all its changes to the original entity from the database by using identifier of an entity and identifiers of states of the entity.
Authors of „Anchor modeling“ wrote a paper that is plagiarism of my paper. This part of my post in this section 6, they called „anchor modeling“ (as all changes of an object are tied to
one „anchor“) and they plagiarized the very important part of my paper.
I have answered all the questions of the users of this group.
I posted my solutions (that is my papers) on my two websites and on this user group.
I have presented to this user group that this is one of the very important problem.
In philosophy, this problem is called „Ship of Theseus“. This problem consists in the following: how and why people see an object, which has changed many of its attributes, as the
same object. How man perceives it as one and the same object. In my opinion, the importance of my solution is that my solution is in fact a representation of the real mental procedure.
So it is not solved by using a theorems, rather it is solved by using mental procedures.
7. Mental procedures and mental representations.
I built my solution and mathematical approach for mental procedures and mental representation. In my opinion, this is a new kind of mathematics. This mathematical theory is not
about proofs, rather it is about the construction of abstract objects.
I called it a mathematical solution for mental procedures and mental representation. In my opinion this is about specific data organizations in databases in terms of organizing that
data in human memory by applying appropriate mental procedures and represent it in human memory as a mental representations.
So in my previous point 6, in this post, I used data organization for mathematical presentation of changes in objects and changes in relationships.
With help of data organization, I solved the issue of an effective procedure here, which I called „mental procedure“. My name „mental procedure“ refers to a man's „mental procedures“
that are realized using „mental representation“ in the problems of data organization and data representation.
In my opinion, all changes in human memory, regarding entities and relationships we realized through mental procedures and represent it into mental representation.
This mental representation of all the changes of one entity, I present in the database as all the changes that are related to one identifier of the entity. I still need all the identifiers of the
states of this entity. Therefore, I bind the identifier of this entity to all identifiers of the states of this entity and put it in the database.
As I have already written, mental representation and mental procedures - they are at the level of our (human) memory - correspond to my databases. Editing database memory and
representing changes of enties with the help of database memory organization, in my opinion , correspond to mental procedure. This is how I explain the connection between „human
memory“ and databases, for these complex cases. We can notice that mental representation corresponds to the concepts.
8. At this point 8, there is an important and unusual part of database theory, which is perhaps the most significant part of my database theory. Since no one has asked me about these
problems and how they are saved in my db theory, I have not explained this theory in my explanations on this user group.
--------------------------------------------------------------------------------------------------------------
I first presented my database theory at this user group. It was on September 23, 2005. The name of that thread is „Database design, Keys and some other things“. In that thread I wrote
the name of my website where I presented the results of my database theory. The name of this website is
www.dbdesign10.com . In 2008, I created another website in which I
presented my new results. The name of this website is
www.dbdesign11.com where there was also a great user discussion and where I always answered every question. So, users of
this group can see my database theory and can see the discussion on the user group, from 2005 until today. In the first 5 years there was a huge discussion about my database theory
on this user group in which I explained my database solution. My answering on questions posted by various users turned into full time job for me because my knowledge of English was
very poor and I am not talented in languages. Quite by accident, I found out about „Anchor modelling“. You can still see all this discussion today.
The first seven points in this post, which I marked with numbers from 1 to 7, were plagiarized by the authors of „anchor modeling“. What they have not plagiarized in these seven points
is sometimes ignorance and sometimes even misunderstanding of basic things.
For example, in their first paper, which won first prize at the most important Conference on Conceptual Modeling – ER 2009, the following was written as the title:
----------------------------------------------------------------------------------------------------------------
Anchor Modeling
An Agile Modeling Technique using the Sixth Normal Form for Structurally and Temporally Evolving Data
----------------------------------------------------------------------------------------------------------------
There is no man in the world who can „using sixth normal form“. 6NF is just another name for atomic data structures. 6NF does not say how to obtain atomic data structures, which is
the only important thing for this 6NF.
From this title of their paper, which includes 6NF, it is immediately apparent that the authors of „anchor modeling“ do not understand the basic things of databases. I was amazed that
a scientific paper with a title like this won first prize at an international conference. Let us mention that „atomic data structure“ are the most important topic for more than one science.
Another example of a nonsense in „anchor modeling“ is their the most important data structure defined as „Def 1“ in their award-winning paper:
----------------------------------------------------------------------------------------------------
Def 1 (identities) Let ID be an infinite set of symbols, which are used as identities.
----------------------------------------------------------------------------------------------------
It is known that the surrogate key is nonsense in database theory. „Identities“ from this Def1 are „surrogate keys“.
In this post I wrote about these two nonsense because it is proof that the authors of „anchor modeling“ do not understand the basics in database theory.
Regarding their notion of „identities“, the authors of „anchor modeling“ write in section 2.1 that „an anchor represents a set of entities, such as a set of actors or events“. This is
nonsense because we do not put entities, actors or events in sets.
In my points 6 and 7, in this post I wrote the most important part of this plagiarism from the authors of „anchor modeling“.
On my website
www.dbdesign10.com which was set up in 2005, I presented my database solution.
At the very beginning of section 1.1 from this my website, I wrote the following text:
--------------------------------------------------------------------------------------------------------------
„We determine the conceptual model so that every entity and every relationship has only one attribute, all of whose values are distinct. So this attribute doesn't have two of the same
values. We will call this attribute the Identifier of the state of an entity or relationship.........every entity has an attribute which is the Identifier of the entity or can provide identification of
the entity...
-------------------------------------------------------------------------------------------------------------
In the previous few sentences, several fundamental theories of great importance have been initiated and introduced.
1. I do not use „key". „anchor modeling“ uses keys.
2. I introduce identifiers – this is the beginning of my Theory of identification.
3. I linked the identifiers i.e. the operation with the linked identifiers was constructed. For
example, I associated an identifier of an entity and an identifier of a state of that entity.
4. Identifiers are very different from „surrogates“
5. Identifiers are very different from keys.
6. I introduced the Theory of identification. You do not need a spoken language for
identification.
7. I introduced the Theory of states.
8. Atomic data structure are enabled, that is, it is possible to work with only one attribute.
This means it is possible to work with temporal data, metadata,... ,that is, data on the level of atomic data structure.
Note that Codd, Date and Darwen as well as some other groups tried to get decomposition
of data into atomic data structures - unsuccessful.
----------------------------------------------------------------------------------------------------------------
In the first paper from „anchor modeling“ there is not a word about identifiers and not a word about states. Without identifiers there are no atomic structures of data and there is no
„anchor“. Also without states there are no atomic structures and there is no „anchor“.
So the first paper about „anchor modeling“, which won first prize at the most important conference for data and databases , is fundamentally wrong.
-----------------------------------------------------------------------------------------------------------------
In addition to identifiers and states, the first paper of „anchor modeling“ is inaccurate because of other mistakes that I mentioned earlier in this thread.
When I started writing about plagiarism, which I called „anchor modeling“ after a shrt period of several months, the authors of „anchor modeling“ published another paper in the journal
DKE, Editor-in-Chief Peter Chen. He did not respond to my letter
In their second paper, the authors of „ anchor modeling“ introduced identifiers in definition 16 and they introduced „states“ in the section „4.5 Modeling State“.
However, in the first paper, the authors of „anchor modeling“ use the term „key“. Also they did not use states in their first paper !? The authors of „anchor modeling“ very quickly published their second paper in jornal where Peter Chen is the editor. There they tried to correct the mistakes I wrote about in this user group.
So to summarize , the first paper of „anchor modeling“ is brutal plagiarism of my paper. After my critique on this user group, the authors of „anchor modeling“ publish their second
paper in which they continue to plagiarize my papers.
I will now return to my theory of identification. Let „I“ be abbreviation the word „identification“ . I have the following identifications:
1. I(events) - identification of events.
Like I said there are only two events in my database. One event is the entry of new data. The second event is the termination of the existing data in database. These two events are all
events in my theory of database.
2. I(attributes) - identification of attributes
Attributes are atomic elements in my theory of databases. Identification of atomic elements d Users can associate to an attribute times information and anything what is real
information relating to an atomic attributes.
3. I(entities) - identification of entities:
For this type of identification I use the identifier of the entity.
4. I(relationships ) - identification of relationships
For this type of identification I use the identifier of the relationship.
5. I(states) - identification of states of entities(relationships).
For this type of identification I use the identifier of the state.
We can see that truth can be determined by using my theory of identification. That means that logic is based on the identification. For examle, the truth value of the next sentence:
„John Smith has blue eyes“ we can determine on the following procedure: We must identify the entity John Smith and we must identify the color of his eyes. These two identifications,
for the name and for the color of eyes, we must do in the real world. Then we must check it in our database. In fact, the theory of identification enables that a machine can determine
truth values.
----------------------------------------------------------------------------------------------------------------
As far as I know, Apple is the first company to achieve a value of 2 trillion dollars. That happened in mid-2020. The same vallue was achieved by Microsoft around new year 2021. Apple
and Microsoft belong to the software industry. So software is the number one industry. I want to point out the magnitude of this plagiarism.
----------------------------------------------------------------------------------------------------------------
Let me now give examples of atomic identifications.
Example 1. Let a dog remember 3000 smells. This allows him to follow another dog's by „smell“. In this case, „smell“ is an identifier.
Example 2. Molecules are joined using a spatial form. In this case, the „spatial form“ is the atomic identifier.
Note that in the process of identification, there is no language and logic.
Vladimir Odrljin