ZhangZhihuiAAA - 博客园

摘要： bitemporal delta lake ODPi, OMAG, OMRS, Egeria 阅读全文

posted @ 2024-12-11 20:12 ZhangZhihuiAAA 阅读(1) 评论(0) 推荐(0) 编辑

摘要： Vendor and open source tools Data fabric solutions: IBM Cloud Pak NetApp TIBCO HPE Denodo Informatica Talend K2view Cinchy Stardog 阅读全文

posted @ 2024-12-11 00:48 ZhangZhihuiAAA 阅读(2) 评论(0) 推荐(0) 编辑

Data Fabric - Study Notes 2

摘要：阅读全文

posted @ 2024-12-10 21:53 ZhangZhihuiAAA 阅读(2) 评论(0) 推荐(0) 编辑

Data Fabric - Study Notes 1

摘要： TOGAF, or The Open Group Architecture Framework, is a framework and methodology for designing, planning, and implementing an enterprise's IT architect 阅读全文

posted @ 2024-12-10 16:41 ZhangZhihuiAAA 阅读(2) 评论(0) 推荐(0) 编辑

PostgreSQL - Study Notes 7

摘要： Full text search Searching with LIKE: LIKE is case-sensitive. iLIKE is case-insensitive. TSVECTOR, TSQUERY, ts_rank(): Websearch: select plainto_tsque 阅读全文

posted @ 2024-12-10 08:52 ZhangZhihuiAAA 阅读(1) 评论(0) 推荐(0) 编辑

PostgreSQL - Study Notes 6

摘要： CTEs (Common Table Expressions): Not materialized, because it is used only once. Explicitly creating the CTE as not materialized looks having better p 阅读全文

posted @ 2024-12-09 08:07 ZhangZhihuiAAA 阅读(1) 评论(0) 推荐(0) 编辑

PostgreSQL - Study Notes 5

摘要： Cross join: Cross join is the default for an unqualified join. Grouping: count(*) counts the number of rows in the result set. count() of a column nam 阅读全文

posted @ 2024-12-08 18:57 ZhangZhihuiAAA 阅读(2) 评论(0) 推荐(0) 编辑

PostgreSQL - Study Notes 4

摘要： Inner join is the default join. Outter join has three categories: left join, right join and full join. Lateral join: Lateral join can be (NOT must be) 阅读全文

posted @ 2024-12-08 10:13 ZhangZhihuiAAA 阅读(4) 评论(0) 推荐(0) 编辑

PostgreSQL - Index Selectivity

摘要： Introduction In this article, we are going to see how Index Selectivity works in relational database systems and why the database Optimizer might choo 阅读全文

posted @ 2024-12-06 10:06 ZhangZhihuiAAA 阅读(8) 评论(0) 推荐(0) 编辑

PostgreSQL - Study Notes 3

摘要： What data type should you use for your primary keys? Integers or UUIDs? In 98% of use cases, you should favor integer types. When we are over integer 阅读全文

posted @ 2024-12-05 22:33 ZhangZhihuiAAA 阅读(2) 评论(0) 推荐(0) 编辑

导航

2024年12月11日

2024年12月10日

2024年12月9日

2024年12月8日

2024年12月6日

2024年12月5日


Copyright © 2024 ZhangZhihuiAAA Powered by .NET 9.0 on Kubernetes 博客园