Matches in SemOpenAlex for { <https://semopenalex.org/work/W4253431909> ?p ?o ?g. }
Showing items 1 to 56 of
56
with 100 items per page.
- W4253431909 abstract "<p>[Introduction]: SQLite is a database which can be easily embedded inside an application written in the C programming language. One common use is inside the Mozilla Firefox web browser. It supports asubset of the SQL language but was not intended to be a replacement for a multi-user database suchas MySQL, Oracle or Microsoft SQL Server.The entire database is integrated into one *.c file and the command shell for the command lineinterface is inside another file. Thus to embed the database a developer just has to copy and pastethe source code into their database. It also comes in another format with separate files for eachcomponent but is not recommended for use due to slower performance. SQLite's developers indicate there is a 5-10% performance improvement when using the amalgamation due to compileroptimizations for a single file.</p> <p>SQLite supports connections via multiple threads, but it does not support intra-query parallelism.For example commercial databases can divide a large query so that it is run concurrently acrossseparate CPUs. SQLite has a very coarse locking level. Since the database is located inside one file,the entire file is locked for writing. Concurrent reads can still occur on the file. It does not supportfiner levels of locking such as table or row locks.</p>" @default.
- W4253431909 created "2022-05-12" @default.
- W4253431909 creator A5049651001 @default.
- W4253431909 date "2023-01-10" @default.
- W4253431909 modified "2023-10-17" @default.
- W4253431909 title "SQLite Page Caching Algorithm" @default.
- W4253431909 doi "https://doi.org/10.32920/ryerson.14638989" @default.
- W4253431909 hasPublicationYear "2023" @default.
- W4253431909 type Work @default.
- W4253431909 citedByCount "0" @default.
- W4253431909 crossrefType "posted-content" @default.
- W4253431909 hasAuthorship W4253431909A5049651001 @default.
- W4253431909 hasBestOaLocation W42534319091 @default.
- W4253431909 hasConcept C111919701 @default.
- W4253431909 hasConcept C13674803 @default.
- W4253431909 hasConcept C166807848 @default.
- W4253431909 hasConcept C177264268 @default.
- W4253431909 hasConcept C199360897 @default.
- W4253431909 hasConcept C2776760102 @default.
- W4253431909 hasConcept C2984286706 @default.
- W4253431909 hasConcept C41008148 @default.
- W4253431909 hasConcept C45235069 @default.
- W4253431909 hasConcept C510870499 @default.
- W4253431909 hasConcept C55166926 @default.
- W4253431909 hasConcept C77088390 @default.
- W4253431909 hasConcept C95637964 @default.
- W4253431909 hasConceptScore W4253431909C111919701 @default.
- W4253431909 hasConceptScore W4253431909C13674803 @default.
- W4253431909 hasConceptScore W4253431909C166807848 @default.
- W4253431909 hasConceptScore W4253431909C177264268 @default.
- W4253431909 hasConceptScore W4253431909C199360897 @default.
- W4253431909 hasConceptScore W4253431909C2776760102 @default.
- W4253431909 hasConceptScore W4253431909C2984286706 @default.
- W4253431909 hasConceptScore W4253431909C41008148 @default.
- W4253431909 hasConceptScore W4253431909C45235069 @default.
- W4253431909 hasConceptScore W4253431909C510870499 @default.
- W4253431909 hasConceptScore W4253431909C55166926 @default.
- W4253431909 hasConceptScore W4253431909C77088390 @default.
- W4253431909 hasConceptScore W4253431909C95637964 @default.
- W4253431909 hasLocation W42534319091 @default.
- W4253431909 hasLocation W42534319092 @default.
- W4253431909 hasOpenAccess W4253431909 @default.
- W4253431909 hasPrimaryLocation W42534319091 @default.
- W4253431909 hasRelatedWork W2159733058 @default.
- W4253431909 hasRelatedWork W2347320377 @default.
- W4253431909 hasRelatedWork W2358740711 @default.
- W4253431909 hasRelatedWork W2363102854 @default.
- W4253431909 hasRelatedWork W2367232817 @default.
- W4253431909 hasRelatedWork W2390477537 @default.
- W4253431909 hasRelatedWork W2393055492 @default.
- W4253431909 hasRelatedWork W4248943663 @default.
- W4253431909 hasRelatedWork W4253431909 @default.
- W4253431909 hasRelatedWork W4310916671 @default.
- W4253431909 isParatext "false" @default.
- W4253431909 isRetracted "false" @default.
- W4253431909 workType "article" @default.