tanszek:oktatas:techcomm:information_-_basics:sciences
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
tanszek:oktatas:techcomm:information_-_basics:sciences [2024/09/09 20:33] – [What is science?] knehez | tanszek:oktatas:techcomm:information_-_basics:sciences [2024/09/12 17:53] (current) – [Deductive Sciences] knehez | ||
---|---|---|---|
Line 9: | Line 9: | ||
//Science// has been highlighted because of the following criteria from our historically established social forms of consciousness: | //Science// has been highlighted because of the following criteria from our historically established social forms of consciousness: | ||
- | * they possess high-reaching concepts or logical tools to formulate or express broad, general or universal **principles** or **laws**. | + | * they possess high-reaching concepts or logical tools to formulate or express broad, general or universal **principles** or **laws** |
+ | |||
+ | * they can describe the objective **conditions** under which these principles or laws will prevail. | ||
- | * they possess the required logical tools or methods that can help us to calculate or predict **results** in given circumstances | + | * they possess the required logical tools or methods that can help us to calculate or predict **results** in given circumstances, |
- | | + | According to **principles**, |
====== Inductive Sciences ====== | ====== Inductive Sciences ====== | ||
- | |||
- | According to **principles**, | ||
**Induction**: | **Induction**: | ||
Line 56: | Line 56: | ||
- **Inductive Hypothesis**: | - **Inductive Hypothesis**: | ||
- **Inductive Step**: We must prove that if the statement holds for a binary tree with \(k\) nodes, then it also holds for a binary tree with \(k+1\) nodes. \\ Suppose we add one more node to the binary tree, bringing the total number of nodes to \(k+1\). When we add this node, we also add exactly one edge connecting the new node to an existing node in the tree (either as a left or right child of a parent node). \\ \\ By the inductive hypothesis, the tree with \(k\) nodes has \((k - 1)\) edges. Adding one more node introduces one additional edge, so the number of edges in the tree with \((k + 1)\) nodes is: $$ (k-1) + 1 = k $$ This matches the formula for the number of edges in a tree with \((k + 1)\) nodes, which should be \((k-1) + 1 = k\). | - **Inductive Step**: We must prove that if the statement holds for a binary tree with \(k\) nodes, then it also holds for a binary tree with \(k+1\) nodes. \\ Suppose we add one more node to the binary tree, bringing the total number of nodes to \(k+1\). When we add this node, we also add exactly one edge connecting the new node to an existing node in the tree (either as a left or right child of a parent node). \\ \\ By the inductive hypothesis, the tree with \(k\) nodes has \((k - 1)\) edges. Adding one more node introduces one additional edge, so the number of edges in the tree with \((k + 1)\) nodes is: $$ (k-1) + 1 = k $$ This matches the formula for the number of edges in a tree with \((k + 1)\) nodes, which should be \((k-1) + 1 = k\). | ||
+ | |||
+ | https:// | ||
====== Deductive Sciences ====== | ====== Deductive Sciences ====== | ||
Line 86: | Line 88: | ||
Logic can only state that the results will be true if the premises are true (and consistent) and the arguments are logically correct. | Logic can only state that the results will be true if the premises are true (and consistent) and the arguments are logically correct. | ||
- | //Bonus Content//: | + | **Example**: |
János Bólyai – a famous Hungarian mathematician – wrote this famous sentence to his father: | János Bólyai – a famous Hungarian mathematician – wrote this famous sentence to his father: | ||
Line 97: | Line 99: | ||
{{: | {{: | ||
+ | |||
+ | The quote from [[https:// | ||
====== Reductive Sciences ====== | ====== Reductive Sciences ====== | ||
Line 103: | Line 107: | ||
- | **Explanation**: | + | **Explanation**: |
- | We can face another interpretation of reduction in the classification of elementary scientific problems (the so-called ’Trinity’ of sciences). | + | We can face another interpretation of reduction in classifying |
Line 129: | Line 133: | ||
- The performance depends on factors like indexing, table size, query structure, and features of database engine. | - The performance depends on factors like indexing, table size, query structure, and features of database engine. | ||
- The result of the query must remain the same regardless of the optimization. | - The result of the query must remain the same regardless of the optimization. | ||
- | - **Seeking Appropriate Conditions: | + | - **Seeking Appropriate Conditions: |
- | - The task is to optimize the query by structuring it in a way that minimizes | + | |
- **There’s no single “perfect” solution** | - **There’s no single “perfect” solution** | ||
- Additionally, | - Additionally, | ||
- | - **Reducing the Number of Solutions:** | + | - **Reducing the Number of Conditions:**: The database administrator (DBA) or developer uses **heuristic methods** like: |
- | - The database administrator (DBA) or developer uses heuristic methods like: | + | - Query profiling tools (e.g., EXPLAIN in SQL) to examine how different query structures perform. |
- | - Query profiling tools (e.g., EXPLAIN in SQL) to examine how different query structures perform. | + | - Applying **best practices** like indexing the right columns, minimizing nested queries, and using joins effectively. |
- | - Applying **best practices** like indexing the right columns, minimizing nested queries, and using joins effectively. | + | |
- By profiling and tweaking different versions of the query, the developer reduces the number of possible query structures to a few that perform optimally in the given context. | - By profiling and tweaking different versions of the query, the developer reduces the number of possible query structures to a few that perform optimally in the given context. | ||
- | | + | |
The //reductive approach// in database query optimization involves narrowing down many possible solutions (query structures) to a few practical ones. The solution can’t simply be inverted from the final result (i.e., retrieving the data); instead, developers use heuristics, profiling, and experience to eliminate inefficient options and find the most effective query structure for their specific environment. | The //reductive approach// in database query optimization involves narrowing down many possible solutions (query structures) to a few practical ones. The solution can’t simply be inverted from the final result (i.e., retrieving the data); instead, developers use heuristics, profiling, and experience to eliminate inefficient options and find the most effective query structure for their specific environment. |
tanszek/oktatas/techcomm/information_-_basics/sciences.1725914003.txt.gz · Last modified: 2024/09/09 20:33 by knehez