- Jun 2021
-
www.economist.com www.economist.com
-
See how age and illnesses change the risk of dying from covid-19 | The Economist. (n.d.). Retrieved June 29, 2021, from https://www.economist.com/graphic-detail/covid-pandemic-mortality-risk-estimator
-
-
www.bmj.com www.bmj.com
-
Li, X., Ostropolets, A., Makadia, R., Shoaibi, A., Rao, G., Sena, A. G., Martinez-Hernandez, E., Delmestri, A., Verhamme, K., Rijnbeek, P. R., Duarte-Salles, T., Suchard, M. A., Ryan, P. B., Hripcsak, G., & Prieto-Alhambra, D. (2021). Characterising the background incidence rates of adverse events of special interest for covid-19 vaccines in eight countries: Multinational network cohort study. BMJ, 373, n1435. https://doi.org/10.1136/bmj.n1435
-
-
evilmartians.com evilmartians.com
-
For example, Database Cleaner for a long time was a must-have add-on: we couldn’t use transactions to automatically rollback the database state, because each thread used its own connection; we had to use TRUNCATE ... or DELETE FROM ... for each table instead, which is much slower. We solved this problem by using a shared connection in all threads (via the TestProf extension). Rails 5.1 was released with a similar functionality out-of-the-box.
-
-
naildrivin5.com naildrivin5.com
-
It’s easy to create bugs because the environment is a somewhat degenerate settings database.
-
-
dba.stackexchange.com dba.stackexchange.com
-
I suggest to make it UNIQUE because it seems like the column should be unique
-
- May 2021
-
www.sciencemag.org www.sciencemag.org
-
Wadman, M. (2021). Antivaccine activists use a government database on side effects to scare the public. Science. https://doi.org/10.1126/science.abj6981
Tags
- bad science
- vaccine
- blood clots
- anti-vaxxer
- science
- VAERS
- Fox News
- lang:en
- Vaccine Adverse Events Reporting System
- database
- is:article
- government
- data
- USA
- CDC
- antivaccine
- misinterpretation
- misleading
- Centers for Disease Control and Prevention
- misinformation
- vaccine-safety
- false
- activism
- public
- COVID-19
- side-effects
Annotators
URL
-
-
blog.frontiersin.org blog.frontiersin.org
-
Early government intervention is key to reducing the spread of COVID-19. (2020, May 6). Science & Research News | Frontiers. https://blog.frontiersin.org/2020/05/06/early-government-intervention-is-key-to-reducing-the-spread-of-covid-19/
-
-
opportunityinsights.org opportunityinsights.org
-
The Economic Impacts of COVID-19: Evidence from a New Public Database Built Using Private Sector Data. (2020, May 7). Opportunity Insights. https://opportunityinsights.org/paper/tracker/
-
-
twitter.com twitter.com
-
Robert Colvile. (2021, February 16). The vaccine passports debate is a perfect illustration of my new working theory: That the most important part of modern government, and its most important limitation, is database management. Please stick with me on this—It’s much more interesting than it sounds. (1/?) [Tweet]. @rcolvile. https://twitter.com/rcolvile/status/1361673425140543490
-
-
www.nature.com www.nature.com
-
Chawla, D. S. (2021). Hundreds of ‘predatory’ journals indexed on leading scholarly database. Nature. https://doi.org/10.1038/d41586-021-00239-0
-
- Mar 2021
-
twitter.com twitter.com
-
COVID-19 Living Evidence. (2020, October 23). Weekly update of COAP As of 23.10.2020, we have indexed 80588 publications: 8902 pre-prints 71686 peer-reviewed publications Pre-prints: BioRxiv, MedRxiv Peer-reviewed: PubMed, EMBASE https://t.co/RaDy1Wm4Hq https://t.co/FYRaYPe8oG [Tweet]. @evidencelive. https://twitter.com/evidencelive/status/1319578431848353793
-
- Feb 2021
-
www.nature.com www.nature.com
-
Else, H. (2020). How a torrent of COVID science changed research publishing—In seven charts. Nature, 588(7839), 553–553. https://doi.org/10.1038/d41586-020-03564-y
-
-
philosophyideas.com philosophyideas.com
-
-
However, sometimes actions can't be rolled back and it is unfortunately unavoidable. For example, consider when we send emails during the call to process. If we send before saving a record and that record fails to save what do we do? We can't unsend that email.
-
-
stackoverflow.com stackoverflow.com
-
I prefer not to duplicate the name of the table in any of the columns (So I prefer option 1 above).
So do I.
-
-
www.youtube.com www.youtube.com
-
Gen3 Data Commons overview/explained.
-
-
www.youtube.com www.youtube.com
-
GDC purpose/summary: https://youtu.be/LY5SkHJplxc?t=118
Tags
Annotators
URL
-
- Jan 2021
-
momentjs.com momentjs.com
-
IANA Time Zone Database Main time zone database. This is where Moment TimeZone sources its data from.
every place has a history of different Time Zones because of the geographical, economical, political, religious reasons .These rules are present in IANA Time Zone database. Also it contains rules for Daylight Saving Time (DST) . Checkout the map on this page: https://en.wikipedia.org/wiki/Daylight_saving_time
Tags
Annotators
URL
-
- Dec 2020
-
saveriomiroddi.github.io saveriomiroddi.github.io
-
Databases If databases data is stored on a ZFS filesystem, it’s better to create a separate dataset with several tweaks: zfs create -o recordsize=8K -o primarycache=metadata -o logbias=throughput -o mountpoint=/path/to/db_data rpool/db_data recordsize: match the typical RDBMSs page size (8 KiB) primarycache: disable ZFS data caching, as RDBMSs have their own logbias: essentially, disabled log-based writes, relying on the RDBMSs’ integrity measures (see detailed Oracle post)
-
-
www.inkandswitch.com www.inkandswitch.com
- Nov 2020
-
www.usenix.org www.usenix.org
-
Interaction with stable storage in the modern world isgenerally mediated by systems that fall roughly into oneof two categories: a filesystem or a database. Databasesassume as much as they can about the structure of thedata they store. The type of any given piece of datais known (e.g., an integer, an identifier, text, etc.), andthe relationships between data are well defined. Thedatabase is the all-knowing and exclusive arbiter of ac-cess to data.Unfortunately, if the user of the data wants more di-rect control over the data, a database is ill-suited. At thesame time, it is unwieldy to interact directly with stablestorage, so something light-weight in between a databaseand raw storage is needed. Filesystems have traditionallyplayed this role. They present a simple container abstrac-tion for data (a file) that is opaque to the system, and theyallow a simple organizational structure for those contain-ers (a hierarchical directory structure)
Databases and filesystems are both systems which mediate the interaction between user and stable storage.
Often, the implicit aim of a database is to capture as much as they can about the structure of the data they store. The database is the all-knowing and exclusive arbiter of access to data.
If a user wants direct access to the data, a database isn't the right choice, but interacting directly with stable storage is too involved.
A Filesystem is a lightweight (container) abstraction in between a database and raw storage. Filesystems are opaque to the system (i.e. visible only to the user) and allow for a simple, hierarchical organizational structure of directories.
-
-
news.ycombinator.com news.ycombinator.com
-
I've spent the last 3.5 years building a platform for "information applications". The key observation which prompted this was that hierarchical file systems didn't work well for organising information within an organisation.However, hierarchy itself is still incredibly valuable. People think in terms of hierarchies - it's just that they think in terms of multiple hierarchies and an item will almost always belong in more than one place in those hierarchies.If you allow users to describe items in the way which makes sense to them, and then search and browse by any of the terms they've used, then you've eliminated almost all the frustrations of a file system. In my experience of working with people building complex information applications, you need: * deep hierarchy for classifying things * shallow hierarchy for noting relationships (eg "parent company") * multi-values for every single field * controlled values (in our case by linking to other items wherever possible) Unfortunately, none of this stuff is done well by existing database systems. Which was annoying, because I had to write an object store.
Impressed by this comment. It foreshadows what Roam would become:
- People think in terms of items belonging to multiple hierarchies
- If you allow users to describe items in a way that makes sense to them and allow them to search and browse by any of the terms they've used, you've solved many of the problems of existing file systems
What you need to build a complex information system is:
- Deep hierarchies for classifying things (overlapping hierarchies should be possible)
- Shallow hierarchies for noting relationships (Roam does this with a flat structure)
- Multi-values for every single field
- Controlled values (e.g. linking to other items when possible)
-
- Oct 2020
-
-
Image a situation wherein you have just launched your app. But the data of your app is not being properly displayed or you are not able to fetch the data that is being entered by the users. What will be the impression of your app in the user’s mind?
Many businesses get confused when it comes to choosing the right database for their application. In fact, it is quite crucial to choose the one between SQLite and Realm.
-
-
github.com github.com
-
I too have been confused by behavior like this. Perhaps a clearly defined way to isolate atomic units with synchronous reactivity would help those of us still working through the idiosyncrasies of reactivity.
-
- Sep 2020
-
www.thelancet.com www.thelancet.com
-
Wilkinson, Jack, Kellyn F. Arnold, Eleanor J. Murray, Maarten van Smeden, Kareem Carr, Rachel Sippy, Marc de Kamps, et al. ‘Time to Reality Check the Promises of Machine Learning-Powered Precision Medicine’. The Lancet Digital Health 0, no. 0 (16 September 2020). https://doi.org/10.1016/S2589-7500(20)30200-4.
Tags
- improved diagnosis
- clinical science
- collaboration
- electronic health database
- machine learning
- algorithmic complexity
- revolution
- prediction of individual responses
- lang:en
- clinical practice
- personalised medical approach
- challenges
- is:report
- machine learning powered precision medicine
Annotators
URL
-
-
medium.com medium.com
-
The Realm is a new database module that is improving the way databases are used and also supports relationships between objects. If you are part of the SQL development world, then you must be familiar with the Realm.
-
-
www.imperial.ac.uk www.imperial.ac.uk
-
COVID-19 reports. (n.d.). Imperial College London. Retrieved September 17, 2020, from http://www.imperial.ac.uk/medicine/departments/school-public-health/infectious-disease-epidemiology/mrc-global-infectious-disease-analysis/covid-19/covid-19-reports/
-
-
digitalhumanities.org digitalhumanities.org
-
So Memex was first and foremost an extension of human memory and the associative movements that the mind makes through information: a mechanical analogue to an already mechanical model of memory. Bush transferred this idea into information management; Memex was distinct from traditional forms of indexing not so much in its mechanism or content, but in the way it organised information based on association. The design did not spring from the ether, however; the first Memex design incorporates the technical architecture of the Rapid Selector and the methodology of the Analyzer — the machines Bush was assembling at the time.
How much further would Bush have gone if he had known about graph theory? He is describing a graph database with nodes and edges and a graphical model itself is the key to the memex.
-
-
outbreaksci.prereview.org outbreaksci.prereview.org
-
Outbreak Science Rapid PREreview • Dashboard. (n.d.). Retrieved September 11, 2020, from https://outbreaksci.prereview.org/dashboard?q=COVID-19&q=Coronavirus&q=SARS-CoV-2
-
-
www.excellentwebworld.com www.excellentwebworld.com
-
In this writeup, we will be discussing one such important prerequisite that is React Native database. We can call it the backbone of React Native applications.
-
- Aug 2020
-
www.nature.com www.nature.com
-
Zheng, Q., Jones, F. K., Leavitt, S. V., Ung, L., Labrique, A. B., Peters, D. H., Lee, E. C., & Azman, A. S. (2020). HIT-COVID, a global database tracking public health interventions to COVID-19. Scientific Data, 7(1), 286. https://doi.org/10.1038/s41597-020-00610-2
-
-
riskhomeostasis.org riskhomeostasis.orgHome1
-
Home. (n.d.). Retrieved June 14, 2020, from http://riskhomeostasis.org/
-
-
final-form.org final-form.org
-
Allows batch updates by silencing notifications while the fn is running. Example: form.batch(() => { form.change('firstName', 'Erik') // listeners not notified form.change('lastName', 'Rasmussen') // listeners not notified }) // NOW all listeners notified
-
-
www.edsurge.com www.edsurge.com
-
Preprint Servers Have Changed Research Culture in Many Fields. Will a New One for Education Catch On? - EdSurge News. (2020, August 20). EdSurge. https://www.edsurge.com/news/2020-08-20-preprint-servers-have-changed-research-culture-in-many-fields-will-a-new-one-for-education-catch-on
-
-
zika.ispm.unibe.ch zika.ispm.unibe.ch
-
Living Evidence on COVID-19. (n.d.). Retrieved August 24, 2020, from https://zika.ispm.unibe.ch/assets/data/pub/search_beta/
-
-
www.tandfonline.com www.tandfonline.com
-
Arqoub, O. A., Elega, A. A., Özad, B. E., Dwikat, H., & Oloyede, F. A. (2020). Mapping the Scholarship of Fake News Research: A Systematic Review. Journalism Practice, 0(0), 1–31. https://doi.org/10.1080/17512786.2020.1805791
-
-
public.tableau.com public.tableau.com
-
Roll over each school to find out more information on their respective plans. (n.d.). Tableau Software. Retrieved August 2, 2020, from https://public.tableau.com/views/NESCACFallPlansMap/Dashboard1
-
- Jul 2020
-
dl.acm.org dl.acm.org
-
Panda, A., Gonawela, A., Acharyya, S., Mishra, D., Mohapatra, M., Chandrasekaran, R., & Pal, J. (2020). NivaDuck—A Scalable Pipeline to Build a Database of Political Twitter Handles for India and the United States. International Conference on Social Media and Society, 200–209. https://doi.org/10.1145/3400806.3400830
-
-
marketplace.digitalocean.com marketplace.digitalocean.com
-
-
Follow the money: See where $380B in Paycheck Protection Program money went. (n.d.). Retrieved July 27, 2020, from https://www.cnn.com/projects/ppp-business-loans/
-
-
-
Stathoulopoulos, K. (2020, March 17). Orion: An open-source tool for the science of science. Medium. https://medium.com/@kstathou/orion-an-open-source-tool-for-the-science-of-science-4259935f91d4
-
-
lucy.shinyapps.io lucy.shinyapps.io
-
Submit a COVID 19 Dashboard. (n.d.). Google Docs. Retrieved July 19, 2020, from https://docs.google.com/forms/d/e/1FAIpQLSdcq-I98VZeA7NjUxBvqMGmdg5ahRucDVwxo057E-x9BmeM-Q/viewform?embedded=true&usp=embed_facebook
-
-
www.nationalgeographic.com www.nationalgeographic.com
-
Coronavirus News and Coverage. (n.d.). Science. Retrieved July 18, 2020, from https://www.nationalgeographic.com/science/coronavirus-coverage/
-
-
covid-19.iza.org covid-19.iza.org
-
COVID-19 and the Labor Market. (n.d.). IZA – Institute of Labor Economics. Retrieved July 18, 2020, from https://covid-19.iza.org/publications/dp13500/
-
-
admin.nber.org admin.nber.org
-
Research Search Results for “Covid.” (n.d.). Retrieved July 18, 2020, from https://admin.nber.org/custom?q=Covid&restrict_papers=yes&client=test3_fe&proxystylesheet=test3_fe&site=default_collection&entqr=0&ud=1&output=xml_no_dtd&oe=UTF-8&ie=UTF-8&btnG=Search
-
-
vimeo.com vimeo.com
-
SciBeh’s Hypothes.is Tool. (n.d.). Vimeo. Retrieved July 15, 2020, from https://vimeo.com/436845680
-
-
psyarxiv.com psyarxiv.com
-
Nieto, I., Navas, J. F., & Vazquez, C. (2020). The quality of research on mental health effects of the COVID-19 pandemic: A note of caution after a systematic review. https://doi.org/10.31234/osf.io/ndgkj
-
-
-
Uchikoshi, F. (2020). COVerAGE-JP: COVID-19 Deaths by Age and Sex in Japan [Preprint]. SocArXiv. https://doi.org/10.31235/osf.io/cpqrt
-
-
nlihc.org nlihc.org
-
Federal Moratoriums. (n.d.). National Low Income Housing Coalition. Retrieved July 2, 2020, from https://nlihc.org/federal-moratoriums
-
- Jun 2020
-
proandroiddev.com proandroiddev.com
-
Normalize the database for this case if your data is going to be modified multiple times
-
normalizing our dabatase will help us. What means normalize? Well, it simply means to separate our information as much as we can
directly contradicts firebase's official advice: denormalize the structure by duplicating some of the data: https://youtu.be/lW7DWV2jST0?t=378
-
-
www.geeksforgeeks.org www.geeksforgeeks.org
-
Denormalization is a database optimization technique in which we add redundant data to one or more tables
-
-
github.com github.com
-
No need for DatabaseCleaner (rolling back transactions are usually faster than truncate).
-
-
exts.ggplot2.tidyverse.org exts.ggplot2.tidyverse.org
-
Ggplot2 extensions. (n.d.). Retrieved June 14, 2020, from https://exts.ggplot2.tidyverse.org/
-
-
yalantis.com yalantis.com
-
Consider the following when picking technologies
-
-
-
Guardian, C. J., Melissa Bailey, Danielle Renwick, The. (2020, June 6). Exclusive: Nearly 600 — And Counting — US Health Workers Have Died Of COVID-19. Kaiser Health News. https://khn.org/news/exclusive-investigation-nearly-600-and-counting-us-health-workers-have-died-of-covid-19/
-
-
surgisphere.com surgisphere.com
-
Desai, S. (2020, May 29). Response to Widespread Reaction to Recent Lancet Article on Hydroxychloroquine. Surgisphere Corporation. https://surgisphere.com/2020/05/29/response-to-widespread-reaction-to-recent-lancet-article-on-hydroxychloroquine/
-
-
www.thelancet.com www.thelancet.com
-
McDonald, E. S. (2020). COVID-19 and essential pregnant worker policies. The Lancet Infectious Diseases, 0(0). https://doi.org/10.1016/S1473-3099(20)30446-1
-
-
dev.mysql.com dev.mysql.com
-
Deadlocks are a classic problem in transactional databases, but they are not dangerous unless they are so frequent that you cannot run certain transactions at all. Normally, you must write your applications so that they are always prepared to re-issue a transaction if it gets rolled back because of a deadlock.
-
-
api.rubyonrails.org api.rubyonrails.org
-
transaction calls can be nested. By default, this makes all database statements in the nested transaction block become part of the parent transaction. For example, the following behavior may be surprising: User.transaction do User.create(username: 'Kotori') User.transaction do User.create(username: 'Nemu') raise ActiveRecord::Rollback end end creates both “Kotori” and “Nemu”. Reason is the ActiveRecord::Rollback exception in the nested block does not issue a ROLLBACK. Since these exceptions are captured in transaction blocks, the parent block does not see it and the real transaction is committed.
How is this okay??
When would it ever be the desired/intended behavior for a
raise ActiveRecord::Rollbackto have absolutely no effect? What good is the transaction then??What happened to the principle of least surprise?
Is there any reason we shouldn't just always use
requires_new: true?If, like they say, the inner transaction "become[s] part of the parent transaction", then if anything, it should roll back the parent transaction too — not roll back nothing.
-
One workaround is to begin a transaction on each class whose models you alter:
-
- May 2020
-
github.com github.com
-
Deepset-ai/haystack. (2020). [Python]. deepset. https://github.com/deepset-ai/haystack (Original work published 2019)
-
-
covid.deepset.ai covid.deepset.ai
-
Corona Scholar: Scientific COVID-19 Knowledge
-
-
www.ukcdr.org.uk www.ukcdr.org.uk
-
UKCDR - COVID-19 Research Project Tracker
-
-
featuredcontent.psychonomic.org featuredcontent.psychonomic.org
-
Herzog, S. (2020, May 21). Boosting COVID-19 related behavioral science by feeding and consulting an eclectic knowledge base. Psychonomic Society Featured Content. https://featuredcontent.psychonomic.org/boosting-covid-19-related-behavioral-science-by-feeding-and-consulting-an-eclectic-knowledge-base/
-
-
ncs-tf.ch ncs-tf.ch
-
Swiss national COVID-19 science task force. Policy Briefs. https://ncs-tf.ch/en/policy-briefs
-
-
-
Database of public health guidance on COVID-19. (2020 May 14). HIQA. https://www.hiqa.ie/reports-and-publications/health-technology-assessment/covid-19-public-health-guidance-database
-
-
www.essentialsql.com www.essentialsql.com
-
I think you should normalize if you feel that introducing update or insert anomalies can severely impact the accuracy or performance of your database application. If not, then determine whether you can rely on the user to recognize and update the fields together. There are times when you’ll intentionally denormalize data. If you need to present summarized or complied data to a user, and that data is very time consuming or resource intensive to create, it may make sense to maintain this data separately.
When to normalize and when to denormalize. The key is to think about UX, in this case the factors are db integrity (don't create errors that annoy users) and speed (don't make users wait for what they want)
-
Can database normalization be taken too far? You bet! There are times when it isn’t worth the time and effort to fully normalize a database. In our example you could argue to keep the database in second normal form, that the CustomerCity to CustomerPostalCode dependency isn’t a deal breaker.
Normalization has diminishing returns
-
Now each column in the customer table is dependent on the primary key. Also, the columns don’t rely on one another for values. Their only dependency is on the primary key.
Columns dependency on the primary key and no dependency on other columns is how you get 2NF and 3NF
-
A table is in third normal form if: A table is in 2nd normal form. It contains only columns that are non-transitively dependent on the primary key
3NF Definition
-
- Apr 2020
-
stackoverflow.com stackoverflow.com
-
web.archive.org web.archive.org
-
From a narratological perspective, it would probably be fair to say that most databases are tragic. In their design, the configuration of their user interfaces, the selection of their contents, and the indexes that manage their workings, most databases are limited when set against the full scope of the field of information they seek to map and the knowledge of the people who created them. In creating a database, we fight against the constraints of the universe – the categories we use to sort out the world; the limitations of time and money and technology – and succumb to them.
databases are tragic!
-
-
psyarxiv.com psyarxiv.com
-
De Brier, N., Stroobants, S., Vandekerckhove, P., & De Buck, E. (2020, April 23). Factors affecting mental health of health care workers during coronavirus disease outbreaks: a rapid systematic review. https://doi.org/10.31234/osf.io/w9uxs
-
-
en.wikipedia.org en.wikipedia.org
-
columnar databases are well-suited for OLAP-like workloads (e.g., data warehouses) which typically involve highly complex queries over all data (possibly petabytes). However, some work must be done to write data into a columnar database. Transactions (INSERTs) must be separated into columns and compressed as they are stored, making it less suited for OLTP workloads. Row-oriented databases are well-suited for OLTP-like workloads which are more heavily loaded with interactive transactions. For example, retrieving all data from a single row is more efficient when that data is located in a single location (minimizing disk seeks), as in row-oriented architectures. However, column-oriented systems have been developed as hybrids capable of both OLTP and OLAP operations, with some of the OLTP constraints column-oriented systems face mediated using (amongst other qualities) in-memory data storage.[6] Column-oriented systems suitable for both OLAP and OLTP roles effectively reduce the total data footprint by removing the need for separate systems
typical applications (adding new users data, or even retrieving user data) are better done in (standard) row-oriented DB. Typical analytics application, such as even simple AVG(whole column) are much slower because the elements of the same column are stored far away from each other in a traditional row-oriented DB, hence increasing disk-access time.
-
seek time is incredibly long compared to the other bottlenecks in computers
-
Operations that retrieve all the data for a given object (the entire row) are slower. A row-based system can retrieve the row in a single disk read, whereas numerous disk operations to collect data from multiple columns are required from a columnar database.
Tags
Annotators
URL
-
-
covid19.scops.ai covid19.scops.ai
-
Scops. Topic Stream Graph. Covid19.scops.ai. https://covid19.scops.ai/superset/dashboard/streamgraph/.
-
-
www.mpg.de www.mpg.de
-
Interview: Calovi, D. by Herrmann Tobias. (2020 April 03). "We don't just want to sit on the couch". Max-Planck-Gesellschaft. https://www.mpg.de/14648916/daniel-calovi-crowdfight-covid19.
-
-
www.thelancet.com www.thelancet.com
-
Viner, R. M., et al. (2020 April 06). School closure and management practices during coronavirus outbreaks including COVID-19: a rapid systematic review. The Lancet. DOI: https://doi.org/10.1016/S2352-4642(20)30095-X.
-
-
www.parliament.uk www.parliament.uk
-
Parliament. COVID-19 outbreak expert database. Parliament.uk. https://www.parliament.uk/covid19-expert-database
-
-
twitter.com twitter.com
-
ReconfigBehSci en Twitter: “‘Proper science without the drag’ – Move to the medical model of journal review: ‘Yes/No’ decision. We suggest the temporary adoption of this model for crisis-relevant material by journals. [happening already, but potentially even better models: @Meta_psy and @F1000Research?]” / Twitter. (n.d.). Twitter. Retrieved April 15, 2020, from https://twitter.com/scibeh/status/1242094075312046082
-
-
sciencebusiness.net sciencebusiness.net
-
Science|Business Database: Coronavirus Funding Opportunities. (n.d.). Science|Business. Retrieved April 20, 2020, from https://sciencebusiness.net/sciencebusiness-database-coronavirus-funding-opportunities
-
-
dba.stackexchange.com dba.stackexchange.com
-
Relational databases are designed around joins, and optimized to do them well. Unless you have a good reason not to use a normalized design, use a normalised design. jsonb and things like hstore are good for when you can't use a normalized data model, such as when the data model changes rapidly and is user defined. If you can model it relationally, model it relationally. If you can't, consider json etc.
-
Joins are not expensive. Who said it to you? As basically the whole concept of relational databases revolve around joins (from a practical point of view), these product are very good at joining. The normal way of thinking is starting with properly normalized structures and going into fancy denormalizations and similar stuff when the performance really needs it on the reading side. JSON(B) and hstore (and EAV) are good for data with unknown structure.
-
- Mar 2020
-
clickhouse.tech clickhouse.tech
-
github.com github.com
-
docs.google.com docs.google.com
-
I chose all my scholarly journals, I put them together. I chose some YouTube videos; they were –IF: Mm-hmm.CF: – like, a bunch of TED talks.
Compiling research materials.
Is there room for us to think about the iterative process; can we work with instructors to "reward" (or assign) students to alternate the searching, reading and writing.
-
And – And I seen how – I saw how many, um, scholarly journals or how many sources came up for it, right? Um, number of sources. Right. And then, if I – if I felt like it wasn’t enough for me to thoroughly talk about the topic, I would move on. Right? So, when I did segregation, there – like, I guess, like, my specific topic was modern-day, so there wasn’t really much about it. Right? So, not much info. Right? And then, when I did gentrification, there were a lot, right?
This part of the process is interesting to me. Links topic selection to search (seemingly a single search).
It also seems a little misguided. What can we do in our lessons that could make tiny changes to this attitude?
-
-
-
unidad_COVID2019,pais
-
- Oct 2019
- Sep 2019
-
web.archive.org web.archive.org
-
The problem with the annotation notion is that it's the first time that we consider a piece of data which is not merely a projection of data already present in the message store: it is out-of-band data that needs to be stored somewhere.
could be same, schemaless datastore?
-
many of the searches we want to do could be accomplished with a database that was nothing but a glorified set of hash tables
Hello sql and cloure.set ns! ;P
-
There are objects, sets of objects, and presentation tools. There is a presentation tool for each kind of object; and one for each kind of object set.
very clojure-y mood, makes me think of clojure REBL (browser) which in turn is inspired by the smalltalk browser and was taken out of datomic (which is inspired by RDF, mentioned above!)
-
- May 2019
-
about.jstor.org about.jstor.org
Tags
Annotators
URL
-
- Oct 2018
-
www.nature.com www.nature.com
-
Massive mining of publicly available RNA-seq data from human and mouse
-
- Sep 2018
-
www.ncbi.nlm.nih.gov www.ncbi.nlm.nih.gov
-
ATtRACT-a database of RNA-binding proteins and associated motifs
Tags
Annotators
URL
-
- Apr 2018
-
www.sarahmei.com www.sarahmei.com
-
The takeaway from the article: Choose document-oriented database only when the data can be treated as a self-contained document
-
- Dec 2017
-
openspeakers.org openspeakers.org
-
Find Open Speakers
Tags
Annotators
URL
-
-
alleledb.gersteinlab.org alleledb.gersteinlab.orgAlleleDB1
-
AlleleDB is a repository, providing genomic annotation of cis-regulatory single nucleotide variants (SNVs) associated with allele-specific binding (ASB) and expression (ASE).
Tags
Annotators
URL
-
- Nov 2017
-
stackoverflow.com stackoverflow.com
-
select top 1 * from newsletters where IsActive = 1 order by PublishDate desc
This doesn't require a full table scan or a join operation. That's just COOL
-
-
www.datavisor.com www.datavisor.com
-
They have a very simplistic view of the activity being monitored by only distilling it down into only a few dimensions for the rule to interrogate
Number of dimensions need to be large. In normal database systems these dimensions are small.
-
- Aug 2017
-
niemanreports.org niemanreports.org
-
Football Leaks, which consists of 1.9 terabytes of information and some 18.6 million documents, ranging from player contracts to emails revealing secret transfer fees and wages, is the largest leak in the history of sport.
"Football Leaks, which consists of 1.9 terabytes of information and some 18.6 million documents, ranging from player contracts to emails revealing secret transfer fees and wages, is the largest leak in the history of sport."
A pity this information is not available to the public.
Given the limited release of documents, is it really the largest leak in the history of sport?
The ICIJ offshore database may not be complete, but there is at least something, and it is searchable.
Hopefully EIC will also follow this example.
-
- Jun 2017
-
wiki.opencog.org wiki.opencog.org
-
The vertices and edges of a graph, known as Atoms, are used to represent not only "data", but also "procedures"; thus, many graphs are executable programs as well as data structures.
Rohan indicated that procedures are also part of the graph. let us find out why.
Tags
Annotators
URL
-
- May 2017
-
static1.squarespace.com static1.squarespace.com
-
Databases tend toward inclusivity, narratives toward selectivity
This is a helpful little encapsulation of the central problem in the debate.
-
- Mar 2017
-
med.stanford.edu med.stanford.edu
-
Genome Sequence Archive (GSA)
Database URL is here: http://gsa.big.ac.cn/
Note: metadata is INSDC format, but this database isn't part of the INSDC, so you'll still need to submit your data to one of those databases to meet internationally recognised mandates
-