Then, in the same spirits as abstract typing in programming languages, More generally, dimension equations may give you hints of what makes Sense, and that taking the average makes a lot of sense. Speeds in your database, it is very likely that adding them makes no Still, though speeds can be added in physics, if you have a column of A ratio could beĪdditive in a context where intensive/extensive does not apply. Things may be more complex than that in general. This is why theīut these concepts apply to properties of materials, and I suspect Ratio of two extensive properties is an intensive one. Now such a classification can lead to more knowledge. But, for example, taking the average may have sense, if you do Makes no sense (whether its concerns the same article or different
Unit of a good is clearly an intensive property. I suspect that these concepts exists also for your store managementĭatabase, but may have to be refined (I am not sure). Physicists distinguish them by talking of While others do not, such as temperature or density, though they canīe averaged (some of them). Some dimensions have additive qualities, such as weight or volume, The same goesįor addition quantities with different dimensions. Relation that only the database creator can know about. Testing equality between to quantities that have different physicalĭimension is likely to be meaningless, unless there is some implicit Testing equality of weight and date probably does not. But not all operations between them make sense. You could have these quantities appear to qualify columns in the dataīase of a physicist. Speed, date, duration, temperature, heat. Physics uses a lot of scalar quantities: weight, distance, I will attempt to illustrate a possible type vision with To your generator, if you hope for an answer (which is a variant of You have to say what data, what semantic information, you provide Numbers, and any idea you may have to fold, spindle or mutilate them Kind of semantic information, a column of numbers is just a column of Generator, so that your queries make sense. Though a physicist told me that is not the case.Īlso you should make clear what you intend to provide as input to your There is a possibility that they may have addressed this typing issue, Information can be found on these tools (usually very proprietary), I also know that physicists use "databases" to store theirĮxperimental data before exploiting it with specialized software. Hence, first of all, you should look whether there is something toīe learned from object oriented databases. Oriented languages, and all languages with data abstraction. Programming languages, but of abstract types as found now in object I am not thinking of elementary types as found in most It may not beĮasy or even meaningful to attempt to deal with it in a purelyĪutomated way. See also as a dimensional problem in the physics sense. I suspect that you may have a typing problem, which I tend to It isĪ semantic issue that depends much on the semantics you attach to your But thereĪs remarked by Raphael, generating queries is relatively easy.
Influenced by your example and the queries that go with it. The various types of queries one can make. Would really require more study of how this kind of view may combine with
Since there are no answers yet, I will attempt to Seen it (but I am not in databases), and I would be surprised if no I have no idea whether this has been addressed before. The tables and the relationships that I study are not very complicated.Ĭould anyone tell me which field this problem belongs to? Are there some good results/proposals that are easy to understand? And this conclusion can be more or less inferred from the two given relationships.Ĭertainly, the problem becomes more complexe when there are relationships among several tables. Intuitively, we can say that Query 1 and Query 2 make more sense than Query 3.
#Scientific data table creator how to
The second issue is, how to rank the meaningful queries? For example, Then, the first issue is, how to automatically generate some queries? For instance: 1) Sum of Quantity by ArticleID There are two relationships in this table, which may be given or inferred (the detection of the relationships is not an issue here): a) one ArticleID maps one Price b) Sale = Price * Quantity. Here is an example: ArticleID Price Quantity Sale Are there some algorithms to automatically generate a ranked set of meaningful queries, from the relationships inside the table? But some queries are meaningful, some are meaningless. The main question is: given a table of data, there are lots of possible queries that can be made. But I have some problems to solve, and would like to know which branch this kind of problems belong to, and what are the results. My field of research is not Database or AI.
0 kommentar(er)
