User contributions for Carli
Jump to navigation
Jump to search
17 May 2024
- 14:5714:57, 17 May 2024 diff hist +4,408 N Columnar Storage Created page with "The advantages for columnar storages over row based storages are the ability for good in-memory compression '''(low memory usage)''' and cache locality when accessing only few columns '''(performance)'''. == How we designed the Interface == When designing an interface for a storage engine for an in-memory database, a lot of considerations have to be made. Here are the design goals: * The interface must be simple so that using it does not require implementing all kinds..." current Tag: Visual edit
- 14:5314:53, 17 May 2024 diff hist +4 Main Page No edit summary Tag: Visual edit
- 14:5314:53, 17 May 2024 diff hist +20 Main Page No edit summary Tag: Visual edit
- 14:5214:52, 17 May 2024 diff hist +432 N Hardware Requirements Created page with "MemCP can run on any hardware that is supported by the <code>go</code> compiler. To find the right hardware dimensions, you need to consider the following: * The process itself needs at least 8 MiB of RAM * The size of a 5 GiB MySQL database fits into ~1 GiB of RAM * To have a decent working set, take the RAM requirements x3, so a 5 GiB MySQL database should run on 3 GiB RAM * MemCP needs at least 1 CPU core, more is better ;)" Tag: Visual edit
- 13:5113:51, 17 May 2024 diff hist +3,769 N Parallel Computing Created page with "Almost 99% of all newly invented are imperative programming languages. But imperative languages have one drawback: their parallelization is hard. == Drawbacks of Imperative Programming Languages == Imperative programming languages do have one mayor drawback: state. The concept of an imperative language is that commands are executed which change the content of variables or complex objects in the memory. When trying to create an optimizing compiler that from itself finds..." current Tag: Visual edit
- 13:3613:36, 17 May 2024 diff hist +16 History of the MemCP project No edit summary Tag: Visual edit
- 09:2409:24, 17 May 2024 diff hist +439 N History of the MemCP project Created page with "* On the beforehand, a lot of research was done at the HAEC project * MemCPs predecessor is the [https://wwwdb.inf.tu-dresden.de/research-projects/eris/ Eris] project at TU Dresden * The first commit on MemCP was done on 24th of December 2022 at 12:13:37 * MemCP was originally written in go * The first SQL query on MemCP was successfuly executed on 12.02.2023 source: https://launix.de/launix/memcp-first-sql-query-is-correctly-executed/" Tag: Visual edit
- 09:2009:20, 17 May 2024 diff hist +222 N Databases, Tables and Columns Created page with "* MemCP has a data folder which defaults to "./data". Every subdirectory of that folder is a database. * Databases consist of tables * Tables consist of columns and shards" Tag: Visual edit
- 09:1909:19, 17 May 2024 diff hist +57 Main Page →Navigation Tag: Visual edit
- 09:1809:18, 17 May 2024 diff hist +340 N Shards, RecordIDs, Main Storage, Delta Storage Created page with "* Datasets of a table are organized in shards of roughly 60,000 items * Inside a shard with n items, the datasets are numbered from 0..n-1 * The first few datasets of each shard are organized in a column store * The rest of the datasets are organized in a row store * The delta store consists of the insert list as well as the deletion mask" current Tag: Visual edit
- 09:1409:14, 17 May 2024 diff hist +2,475 N What is OLTP and OLAP Created page with "There are basically two types database workloads leading to different database designs: {| class="wikitable" |+ ! !OLTP !OLAP |- |abbr. |Online Transaction Processing |Online ''Analytical'' Processing |- |Example applications |ERP, Ticket System |BI suite, Statistical programs |- |Typical SQL Queries |large amounts of small UPDATE, INSERT |few SELECT with big computation demand |- |Best Storage Format |Row Store |Columnar store |- |Database Engines |MySQL, Postgres |Mone..." Tag: Visual edit
- 09:0209:02, 17 May 2024 diff hist +77 Main Page No edit summary Tag: Visual edit
- 08:5008:50, 17 May 2024 diff hist +476 Main Page No edit summary Tag: Visual edit
15 May 2024
- 13:4613:46, 15 May 2024 diff hist +76 MediaWiki:Common.css No edit summary current
- 12:5012:50, 15 May 2024 diff hist +12 Main Page No edit summary Tag: Visual edit
- 12:4912:49, 15 May 2024 diff hist 0 N File:Screenshot from htop.png No edit summary current
14 May 2024
- 22:3822:38, 14 May 2024 diff hist −24 Main Page No edit summary Tag: Visual edit
- 19:3019:30, 14 May 2024 diff hist +57 MediaWiki:Common.css No edit summary
- 18:4818:48, 14 May 2024 diff hist +91 N MediaWiki:Common.css Created page with "→CSS placed here will be applied to all skins: #p-logo a { background-size: contain; }"
- 18:4218:42, 14 May 2024 diff hist −7 Main Page No edit summary Tag: Visual edit: Switched
- 18:4118:41, 14 May 2024 diff hist +83 Main Page No edit summary Tag: Visual edit: Switched
- 18:3118:31, 14 May 2024 diff hist +53 Main Page No edit summary Tag: Visual edit
- 18:2718:27, 14 May 2024 diff hist +142 Main Page No edit summary Tag: Visual edit
- 18:2418:24, 14 May 2024 diff hist −10 Main Page No edit summary Tag: Visual edit: Switched
- 18:2418:24, 14 May 2024 diff hist +2,182 Main Page No edit summary Tag: Visual edit: Switched
- 18:1718:17, 14 May 2024 diff hist +1,833 N Main Page Created page with " === What is memcp? === memcp is an open-source, high-performance, columnar in-memory database that can handle both OLAP and OLTP workloads. It provides an alternative to proprietary analytical databases and aims to bring the benefits of columnar storage to the open-source world. memcp is written in Golang and is designed to be portable and extensible, allowing developers to embed the database into their applications with ease. It is also designed with a focus on scalab..." Tag: Visual edit