MyNotes-Tech

This summary is not available. Please click here to view the post.

Dimension Tables = A table contains information about an object such as customers, products, sellers, date_time. As its nature, each set of data has more than one dimension. Fact Tables = A table contains a measurement data such as orders; thus, an order combines information of customer, product, seller, date_time, branch, etc. The fact data will be used for measurement in that data mart or data warehouse. It can be one or more fact tables in a data warehouse. Multi-dimensional = more than one dimension tables. Thus, Multi-dimensional Schemas have 3 types as follow: Star-Schema = The fact table contains FK of dimension tables while each dimension table contain complete attributes of its dimension (has no join to other tables) Snow-Flake Schema = The fact table contains FK of dimension tables while the dimension tables itself might contain FK of other dimension tables as a hierarchy. Galaxy Schema or Family of star Schema = There're more than one fact tables which s...

In one's life, there might not face a big golden chance that could make up life to the perfect success. Successful needs clear goals, good plans, and devoting himself. I've heard lots of tricks to manage our time, tasks, and mindset to archive goals. Here's where I will share what I've heard from psychiatrists and influencers. ⦿ 3-Seconds of Decision Making  Whenever you're thinking to start/do a valuable thing or not, spend your time only 3 seconds to make the decision, else you'll never start or achieve it due to your fear will create many reasons for not doing. Else, you'll never do it! Credit: Dr. Jing (student of psychiatrist) (Thai)  https://www.youtube.com/watch?v=PHHFlIp2noY ⦿ Morning Miracle - Before 8.00 AM Waking up early before 8.00 AM is capable to transform your life as follows. this behavior increases your energy and productivity by the freshness reduces your strain competitive to all of your challenges get better health and shap...

The following tips came from my personal experience during writing my master thesis report. I hope this could help friends to start your research/thesis on the right track and reduce your time to manage it. Any suggestions are welcome as well. Where should I start? Select your interesting area, it's highly recommended to focus on your future career life.  Think about the situation and problems existing in that area, this will lead to your research/thesis topics. Go to more information on google/youtube/teds any platform that could give you the reality of the current situation of that topic area (spend your time serving for 2-3 days if possible, so you will see a clearer picture of what you're interested in). Focus on only one important problem as your topic, which you will give your contribution to solving. Before start writing? Think about the topics related to your thesis background, problem statements, and potential solutions. List those topics in the hierarchy...

NoSQL databases (aka " not only SQL ") are non-tabular, and store data differently than relational tables. NoSQL databases come in a variety of types based on their data model. The main types are document, key-value, wide-column, and graph. They provide flexible schemas and scale easily with large amounts of data and high user loads. 4 major types of NoSQL databases emerged: Document databases  Store data in documents similar to JSON (JavaScript Object Notation) objects.  Each document contains pairs of fields and values.  The values can typically be a variety of types including things like strings, numbers, booleans, arrays, or objects Their structures typically align with objects developers are working within code.  A powerful query languages Horizontally scale-out to accommodate large data volumes.  MongoDB is consistently ranked as the world’s most popular NoSQL database according to DB-engines and is an example of a document database. Key-...

The difference between Grid Computing and Distributed Computing is that: Grid Computing uses different machines with different resource managers (on each own) running for a same project.  Distributed Computing uses different machines (nodes) running with a centralized resource manager for a project Reference:  The answer from  https://www.researchgate.net/post/What_is_the_difference_between_grid_computing_systems_and_distributed_systems More details see  http://www.jatit.org/distributed-computing/grid-vs-distributed.htm Example of Grid Computing database Oracle 10g Reference: https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-parallel-execution-fundamentals-133639.pdf Learning Oracle Parallel Processing https://www.oreilly.com/library/view/oracle-parallel-processing/156592701X/ch04.html https://docs.oracle.com/en/database/oracle/oracle-database/12.2/vldbg/parallel-exec-intro.html Example of Distributed Database RxDB Re...

In education research/thesis, some institute need the APA style of references and citations. These are examples of how to write it. Free citation go to  https://citation.crosscite.org/ Cite by searching name or manual citation go to  https://www.citationmachine.net/items/new  ** includes details for in-text references Journal Example: Khan, F. A., Ahmad, A., Imran, M., Alharbi, M., Mujeeb-ur-rehman, & Jan, B. (2017). Efficient data access and performance improvement model for virtual data warehouse. Sustainable Cities and Society, 35, 232–240. https://doi.org/10.1016/j.scs.2017.08.003 Book Author, A. (Year). Title of chapter. In Editor (Edition), Title of book (pp. xxx–xxx). Location: Publisher. E-Book  Author, A., and Author, B.(year of publication). Title of e-book: Subtitle . Publisher (Edition). doi:xxx Author, A., and Author, B.(year of publication). Title of e-book: Subtitle . Publisher (Edition). Retrived from http://xxx Example: Dull,...