Earth scientists plan to meld massive databases into a 'geological Google'  Science Magazine

CsCl-type materials have many outstanding characteristics, i.e. simple in structure, ease of synthesis and good stability at room temperature, thus are an excellent choice for designing functional materials. Using high-throughput first-principles calculations, a large number of topological semimetals/metals (TMs) were designed from CsCl-type materials found in crystallographic databases and their crystal and electronic structures have been studied. The CsCl-type TMs in this work show rich topological character, ranging from triple nodal points, type-I nodal lines and critical-type nodal lines, to hybrid nodal lines. The TMs identified show clean topological band structures near the Fermi level, which are suitable for experimental investigations and future applications. This work provides a rich data set of TMs with a CsCl-type structure.

Molecular replacement (MR) is the predominant route to solution of the phase problem in macromolecular crystallography. Where the lack of a suitable homologue precludes conventional MR, one option is to predict the target structure using bioinformatics. Such modelling, in the absence of homologous templates, is called ab initio or de novo modelling. Recently, the accuracy of such models has improved significantly as a result of the availability, in many cases, of residue-contact predictions derived from evolutionary covariance analysis. Covariance-assisted ab initio models representing structurally uncharacterized Pfam families are now available on a large scale in databases, potentially representing a valuable and easily accessible supplement to the PDB as a source of search models. Here, the unconventional MR pipeline AMPLE is employed to explore the value of structure predictions in the GREMLIN and PconsFam databases. It was tested whether these deposited predictions, processed in various ways, could solve the structures of PDB entries that were subsequently deposited. The results were encouraging: nine of 27 GREMLIN cases were solved, covering target lengths of 109–355 residues and a resolution range of 1.4–2.9 Å, and with target–model shared sequence identity as low as 20%. The cluster-and-truncate approach in AMPLE proved to be essential for most successes. For the overall lower quality structure predictions in the PconsFam database, remodelling with Rosetta within the AMPLE pipeline proved to be the best approach, generating ensemble search models from single-structure deposits. Finally, it is shown that the AMPLE-obtained search models deriving from GREMLIN deposits are of sufficiently high quality to be selected by the sequence-independent MR pipeline SIMBAD. Overall, the results help to point the way towards the optimal use of the expanding databases of ab initio structure predictions.

The Inorganic Crystal Structure Database (ICSD) is the world's largest database of fully evaluated and published crystal structure data, mostly obtained from experimental results. However, the purely experimental approach is no longer the only route to discover new compounds and structures. In the past few decades, numerous computational methods for simulating and predicting structures of inorganic solids have emerged, creating large numbers of theoretical crystal data. In order to take account of these new developments the scope of the ICSD was extended in 2017 to include theoretical structures which are published in peer-reviewed journals. Each theoretical structure has been carefully evaluated, and the resulting CIF has been extended and standardized. Furthermore, a first classification of theoretical data in the ICSD is presented, including additional categories used for comparison of experimental and theoretical information.

An online knowledge base on the alternate conformations adopted by main-chain and side-chain atoms in protein structures solved by X-ray crystallography is described.

A detailed study on chiral compound structures found in the Cambridge Structural Database (CSD) is presented. Solvates, salts and co-crystals have intentionally been excluded, in order to focus on the most basic structures of single enantiomers, scalemates and racemates. Similarity between the latter and structures of achiral monomolecular compounds has been established and utilized to arrive at important conclusions about crystallization of chiral compounds. For example, the fundamental phenomenon of conglomerate formation and, in particular, their frequency of occurrence is addressed. In addition, rarely occurring kryptoracemates and scalemic compounds (anomalous racemates) are discussed. Finally, an extended search of enantiomer solid solutions in the CSD is performed to show that there are up to 1800 instances most probably hiding among the deposited crystal structures, while only a couple of dozen have been previously known and studied.

A study on chiral monomolecular compound structures found in the Cambridge Structural Database is presented.

Smothered in tartar sauce and cheese it’s difficult to know just what species of fish lurks beneath the breaded surface of a fast-food fish sandwich. […]

The post Smithsonian scientist creating DNA database to track Caribbean conch and lobster appeared first on Smithsonian Insider.

Now the Global Plants Initiativeis catapulting biodiversity research to a new level by sharing these historic plant collections in a massive online database of high-resolution scans.

The post Online initiative makes massive database of herbarium specimens accessible worldwide appeared first on Smithsonian Insider.

The Smithsonian Environmental Research Center has created NEMESIS--National Estuarine and Marine Exotic Species Information System--an online public database that provides key information about the non-native marine species throughout the United States.

The post New invasive species database allows public to ID marine invaders with a home computer appeared first on Smithsonian Insider.

The damaging effects of sea-level rise on Black Sea beaches have been estimated in a new study. Diminishing river sediment supply caused by river dams is also an erosion threat. These new results suggest that erosion could cause over 90% of these beaches to retreat by at least 20% of their width. A publicly available database created by the researchers could be useful for developing coastal protection schemes.

Identifying emerging research areas and technologies is important for decision makers, but notoriously difficult to do. This study presents a new way of searching the literature to identify emerging topics, which will help policymakers, industry and funding bodies to make better decisions.

Unacademy said that basic information related to 11 million learners had been compromised but no sensitive information such as financial data, location, or passwords had been leaked

The world's most comprehensive digital biodiversity database has been developed, enabling access to over 177 million records. However, over two-thirds of the records are from just three countries: the USA, Sweden and the UK, and focus on certain groups such as birds. Changes in policy and funding could help widen the scope of the data.

Richer countries have more resources for gathering biodiversity information, creating a biased view of the worlds' species and their distribution. However, a new study argues that there are other reasons why some countries are underrepresented in global biodiversity databases, with low numbers of English speakers, large distances from the database host and low security acting as key barriers to data collection.

In response to the rapidly expanding green home building market, the USGBC teams up with Home Depot to launch a database of LEED-qualifying products ranging fro

Product Information

The NJ-series Machine Automation Controller supports the Database Connection function. Machine data can be quickly stored in a database by connecting the Controller directly to the database.(NJ501-1[]20 / NJ101-[][]20)

The Controller can be directly connected to a database. No special Unit, software, nor middleware is required.(NX701-1[]20)

New Portal to Offer International Pin Ups Worldwide Exposure, Social Media, Business Connections and More

Institute of Cancer Research: Scientists bring together world’s coronavirus research in ‘intelligent’ online database. “Scientists have created a dynamic database driven by artificial intelligence which is collecting together the world’s research on coronavirus in a single online space. The new resource will make freely available vast amounts of data on the biology and treatment of … Continue reading Institute of Cancer Research: Scientists bring together world’s coronavirus research in ‘intelligent’ online database

Starting November 1 the University of Michigan Library has access to the new version of chemistry database SciFinder — SciFinder-n. In fact, both will be accessible to our users with the same login and password information.

Understanding the capacity to reduce wildfire risk and restore dry forests on Western national forests is a key part of prioritizing new accelerated restoration programs initiated by the Forest Service.

Do you want to duplicate your WordPress database using phpMyAdmin? WordPress stores all your website data in a MySQL database. Sometimes you may need to quickly clone a WordPress database to transfer a website or to create manual backups.

https://www.smashingmagazine.com/2020/05/vue-survey-app-firebase-authentication-database/

In this tutorial, you’ll be building a Survey App, where we’ll learn to validate our users form data, implement Authentication in Vue, and be able to receive survey data using Vue and Firebase (a BaaS platform). As we build this app, we’ll be learning how to handle form validation for different kinds of data, including reaching out to the backend to check if an email is already taken, even before the user submits the form during sign up.

XSS is a security vulnerability that permits injecting malicious code into the client side of a web application. In the simplest situations, XSS vulnerabilities arise when a web application includes the user input in the web output without due sanitization. Such simple XSS vulnerabilities can be detected fairly reliably with blackbox scanners, which inject malicious payload into sensitive parts of HTTP requests and look for the reflected values in the web output.

Contemporary blackbox scanners are not effective against stored XSS vulnerabilities, where the malicious payload in an HTTP response originates from the database storage of the web application, rather than from the associated HTTP request. Similarly, many blackbox scanners do not systematically handle context-sensitive XSS vulnerabilities, where the user input is included in the web output after a transformation that prevents the scanner from recognizing the original value, but does not sanitize the value sufficiently. Among the combination of two basic data sources (stored vs reflected) and two basic vulnerability patterns (context sensitive vs not so), only one is therefore tested systematically by state-of-the-art blackbox scanners.

Our work focuses on systematic coverage of the three remaining combinations. We present a graybox mechanism that extends a general purpose database to cooperate with our XSS scanner, reporting and injecting the test inputs at the boundary between the database and the web application. Furthermore, we design a mechanism for identifying the injected inputs in the web output even after encoding by the web application, and check whether the encoding sanitizes the injected inputs correctly in the respective browser context. We evaluate our approach on eight mature and technologically diverse web applications, discovering previously unknown and exploitable XSS flaws in each of those applications.

Welcome back! In the first part of this series, we looked at a very "low-level" way to interact with a relational database by sending it raw SQL strings and retrieving the results. We created a very simple Express application that we can use as an example and deployed it on Heroku with a Postgres database.

In this part, we're going to examine a few libraries which build on top of that foundation, adding layers of abstraction that let you read and manipulate database data in a more "JavaScript-like" way.

Methods and arrangements for conducting a search using query logs. A query log is consulted and query rewrite rules are learned automatically based on data in the query log. The learning includes obtaining click-through data present in the query log.

Embodiments are described for a system and method of providing a data miner that decouples the analytic flow solution components from the data source. An analytic-flow solution then couples with the target data source through a simple set of data source connector, table and transformation objects, to perform the requisite analytic flow function. As a result, the analytic-flow solution needs to be designed only once and can be re-used across multiple target data sources. The analytic flow can be modified and updated at one place and then deployed for use on various different target data sources.

Disclosed is a feature for a vehicle that enables taking precautionary actions in response to conditions on the road network around or ahead of the vehicle, in particular, a blind intersection along a section of road. A database that represents the road network is used to determine locations where a blind intersection is located along a section of road. Then, precautionary action data is added to the database to indicate a location at which a precautionary action is to be taken about the blind intersection located along the section of road. A precautionary action system installed in a vehicle uses this database, or a database derived therefrom, in combination with a positioning system to determine when the vehicle is at a location that corresponds to the location of a precautionary action. When the vehicle is at such a location, a precautionary action is taken by a vehicle system as the vehicle is approaching a blind intersection.

An RFID event tracking and management system provides a standardized approach that can be utilized by various industry verticals. Loss of captured event data, such as RFID generated through an RFID event, can be prevented through a series of guarantee semantics. Approaches also provide for role-based data visibility. Queries received from a user or entity can be dynamically modified based on the role of the user/entity using a virtual private database (VPD). The modified query can result in a virtual private database automatically hiding or restricting access to event data at row, column, and/or cell levels, so that an authorized user/entity is only able to access data to which that user/entity should have access.

In accordance with embodiments, there are provided mechanisms and methods for creating, exporting, viewing and testing, and importing custom applications in a multitenant database environment. These mechanisms and methods can enable embodiments to provide a vehicle for sharing applications across organizational boundaries. The ability to share applications across organizational boundaries can enable tenants in a multi-tenant database system, for example, to easily and efficiently import and export, and thus share, applications with other tenants in the multi-tenant environment.

A system and method detects malware on client devices based on partially distributed malware definitions from a central server. A server stores malware definitions for known malware. The server generates one or more filters based on the malware definitions and distributes the filter(s) to client devices. The server also distributes full definitions to the clients for a subset of the most commonly detected malware. The client device scans files for malware by first applying the filter to a file. If the filter outputs a positive detection, the client scans the file using the full definition to determine if the file comprises malware. If the full definition is not stored locally by the client, the client queries the server for the definition and then continues the scanning process.

A database system provides a non-volatile cache memory layer for caching pages for a set of database from the database system. The non-volatile cache memory layer may include a non-volatile cache for caching pages for a database from the set of database on the database system. The non-volatile cache may be configured through invoking a configuring stored procedure persistent on the database system. A request is received at the non-volatile cache memory layer for performing an operation on a page from the database on the database system. Based on the received request and an identification of the page, a caching operation is performed on the non-volatile cache memory layer. The caching operation is associated with the request. Data associated with the requested operation on the page is stored and organized on the NV cache memory layer.

In one embodiment, a method receives a query for data in a database system and calls a plurality of engines to analyze information for the query. A calculation graph is generated from at least a portion of the plurality of engines where each of the at least a portion of the plurality of engines add a node to the calculation graph based on analyzing of the information for the query. Then, the method executes the query by calling the nodes of the calculation graph. Each node uses metadata added to the node from a respective calculation engine to perform a calculation for the node. Then, a result of the query is output based on the respective calculations performed by the nodes.

The present disclosure provides improved systems, methods, and computer program products suited to address the issues with legacy approaches. Specifically, the present disclosure provides a detailed description of techniques used in systems, methods, and in computer program products for interpreting relational database statements using a virtual multidimensional data model. Certain embodiments are directed to technological solutions for receiving a relational database statement comprising relational metadata mapped to a virtual multidimensional representation of a subject database, and generating a subject database statement based at least in part on the relational database statement and the virtual multidimensional representation, and configurable to operate on the subject database to produce a visualization result set, which embodiments advance the technical fields for addressing the problem of projecting a multidimensional data view of a subject database on to a relational data analysis environment to enable real time data analyses, as well as advancing peripheral technical fields.

The present disclosure relates to a method for searching in a database containing at least one set of objects each linked to at least one descriptor, the search being done by a search engine from at least one request by a user in order to return at least one result object. The request includes at least one search parameter having a series of at least one search element obtained by freely adding elements to the series by the user, the addition step being able to be repeated multiple times until a search instruction is given.

A self-monitoring time series database system which enforces usage policies is described. A time series database system receives an alert trigger condition for a system user, wherein the system user is associated with multiple time series data points corresponding to multiple subsystems of the time series database system. The time series database system aggregates the multiple time series data points in an internal time series data point, which is internal to the time series database system, associated with the system user. The time series database system evaluates whether the internal time series data point associated with the system user meets the alert trigger condition. The time series database system reduces a level of access by the system user to the time series database system in response to an evaluation that the internal time series data point associated with the system user meets the alert trigger condition.

A jury finds a former Canberra police officer who improperly used police data to impersonate his neighbour, in order to call authorities about a suburban dispute, acted reasonably and did not commit a crime.

Three new hosting management tools give you direct access to your site’s files and data.

It may be tempting at the start of a new project to create the first database tables manually, or write SQL scripts that you run manually, especially when you first have to spend a significant amount of time on sifting through all the migration libraries and then some more to get it working properly.

Going through this process did slow me down at the start of the project but I was determined to use a migration tool because hunting inexplicable bugs that only happen in production just to find out there is a definition mismatch between the production and development databases is not fun. Using such a tool also motivates you to write both the setup and teardown steps for each table while the current design is still fresh in your mind.

At first I considered a standalone migration tool because I expect them to be very good at that single task. However, learning the idiosyncrasies of a new tool and trying to make it fit seamlessly into my development workflow seemed like more trouble than it is worth.

I decided to stick with a Common Lisp library and found the following seven that work with PostgreSQL and/or Postmodern:

• Postmodern-passenger-pigeon
• database-migrations
• cl-migrations
• Mito
• Crane
• Orizuru-orm
• cl-mgr

I quickly discounted Crane and Mito because they are ORM (Object Relational Mapper) libraries which are way more complex than a dedicated migration library. Development on Crane have stalled some time ago and I don't feel it is mature enough for frictionless use yet. Mito declares itself as being in Alpha state; also not mature enough yet.

I only stumbled onto cl-mgr and Orizuru-orm long after making my decision so I did not investigate them seriously. Orizuru-orm is in any case an ORM which I would have discounted because it is too complex for my needs. CL-mgr looks simple, which is a good thing. It is based on cl-dbi which makes it a good candidate if you foresee switching databases but even if I discovered it sooner I would have discounted it for the same reason as CL-migrations.

CL-migrations looks very promising. It is a simple library focusing only on migrations. It uses clsql to interface with the database which bothered me because I already committed to using Postmodern and I try to avoid adding a lot of unused code to my projects. The positive side is that it interfaces to many different databases so it is a good candidate if you are not committed to using Postmodern. It is also a stable code base with no outstanding bug reports.

The two projects I focused on was Postmodern-passenger-pigeon and Database-migrations because they both use Postmodern for a database interface.

Postmodern-passenger-pigeon was in active development at the time and it seemed safer to use than Database-migrations because it can do dry runs, which is a very nice feature when you are upgrading your production database and face the possibility of losing data when things go awry. Unfortunately I could not get it working within a reasonable amount of time.

I finally settled on Database-migrations. It is a small code base, focused on one task, it is mature and it uses Postmodern so it does not pull in a whole new database interface into my project. There are however some less positive issues.

The first issue is a hindrance during development. Every time the migrations ASDF system (or the file containing it, as ASDF prefers that all systems be defined in a single file) is recompiled it adds all the defined migrations to the migrations list. Though each one will only be applied once to the DB it is still bothersome. One can then clear the list with (setf database-migrations::*migrations* nil) but then only newly modified migration files will be added. The solution then is to touch the .asd file after clearing the migrations list.

The second negative point is quite dangerous. The downgrade function takes a target version as parameter, with a default target of 0. This means that if you execute downgrade without specifying a target version you delete your whole database.

I am currently using Database-migrations and it works well for me. If for some reason I need to switch I will use cl-migrations.

Using Database-migrations

To address the danger of unintentionally deleting my database I created a wrapper function that does both upgrade and downgrade, and it requires a target version number.

Another practical issue I discovered is that upgrades and downgrades happen in the same order as they are defined in the migration file. If you create two tables in a single file where table 2 depends on table 1 then you can not revert / downgrade because Database-migrations will attempt to delete table 1 before table 2. The solution here is to use the def-queries-migration macro (instead of def-query-migration) which defines multiple queries simultaneously . If you get overwhelmed by a single definition that defines multiple tables the other option is to stick with one migration definition per file.

I had to use PHPMyadmin a few days ago to delete old tables in my WordPress Database. They were created by a plugin that I tried but decided not to use. Normally when you uninstall a plugin the developer deletes the tables in your database that they create. In this case this author didn’t. It […]

Our Corporate edition now supports tying your database to a fully customisable template for automatic display of database information.

oscon: RT @OReillyMedia #Video Deal/Week: Data and Databases at #OSCON 2012 - $49.99 (Save 50%) Use code VDWK http://t.co/BnDD750NQv

strataconf: The Future Is Graph Databases http://t.co/BVxOZwtoKS A Conversation with @EmilEifrem, founder of @Neo4J #strataconf

M. Wang
Aug 1, 2012; 11:492-500
Technological Innovation and Resources