structure

Synthesis, crystal structure and Hirshfeld surface analysis of N-(4-methoxyphenyl)picolinamide

The synthesis, crystal structure, and Hirshfeld surface analysis of N-(4-methoxyphenyl)picolinamide (MPPA), C13H12N2O2, are presented. MPPA crystallizes in the monoclinic space group P21/n, with a single molecule in the asymmetric unit. Structural analysis reveals that all non-hydrogen atoms are nearly coplanar, and the molecule exhibits two intramolecular hydrogen bonds that stabilize its conformation. Supramolecular features include significant intermolecular interactions, primarily C—H...π and various hydrogen bonds, contributing to the overall crystal cohesion, as confirmed by energy framework calculations yielding a total interaction energy of −138.3 kJ mol−1. Hirshfeld surface analysis indicates that H...H interactions dominate, followed by C...H and O...H interactions, highlighting the role of van der Waals forces and hydrogen bonding in crystal packing.




structure

Crystal structure of 1,10-phenanthrolinium violurate violuric acid pentahydrate

The title compound [systematic name: 1,10-phenanthrolinium 6-hydroxy-5-(oxidoimino)-1,3-diazinane-2,4-dione–6-hydroxy-5-(hydroxyimino)-1,3-diazinane-2,4-dione–water (1/1/5)], C12H9N2+·C4H2N3O4−·C4H3N3O4·5H2O, is a co-crystal salt hydrate comprising 1,10-phenanthrolinium cations, violurate anions, free violuric acid as co-former and five water molecules of crystallization per formula unit. The violurate and the violuric acid residues each form distinct N—H...O hydrogen-bonded tapes with a common R22(8) hydrogen-bond motif extending parallel to (103). Solvent water molecules connect the tapes to form a tri-periodic hydrogen-bonded network with channels extending parallel to the a-axis direction, which accommodate the N—H...Owater hydrogen-bonded 1,10-phenanthrolinium cations. Direct N—H...O hydrogen bonds between the 1,10-phenanthrolinium and violurate ions are not encountered.




structure

Researchers identify fundamental properties of cells that affect how tissue structures form




structure

From ?Searching? to ?Finding?: How AI is Unlocking the Power of Unstructured Data

Unstructured data, which comprises almost 80% of any enterprise's data, holds untapped value when it comes to addressing challenges and embracing opportunities.




structure

Updated dates for the west side of the CTA Track Structure approximately 85ft south of W. Grace Street Work Hours:

Updated dates for the west side of the CTA Track Structure approximately 85ft south of W. Grace Street Work Hours for lead abatement and painting.




structure

SDA Taps Kratos For Missile Defense Fire Control Ground Infrastructure

The Space Development Agency (SDA) on Tuesday said it has awarded Kratos Defense & Security Solutions [KTOS] a potential $116.7 contract to create and operate a missile defense fire control […]




structure

Biden funded new factories and infrastructure projects, but Trump might get to cut the ribbons

Trump won in large part because of voters’ frustration with high prices and a sense that the country needs major changes. But when he enters office in January, Trump will inherit an economy primed for growth.




structure

PRC Targeting of Commercial Telecommunications Infrastructure

Comments




structure

Experienced Structures Technician Seasonal Contractor

Aurora, OR United States - Description Performs structural (sheet metal) maintenance and alterations; will also fabricate structural parts as part of the parts manufacturing process and/or performs aircraft maintenance preventive maintenance complete aircraft teardown and assembly to include all air... View




structure

Penguin Solutions End-to-End AI Infrastructure Solutions on Display at SC24

FREMONT, Calif., Nov. 13, 2024 — Penguin Solutions, Inc. today announced its participation at Supercomputing 24 (SC24), which will include product demonstrations, speaking engagements, and presence on the show floor. […]

The post Penguin Solutions End-to-End AI Infrastructure Solutions on Display at SC24 appeared first on HPCwire.




structure

Ayar Labs to Showcase the Future of AI Infrastructure with Fujitsu, Intel, Corning, and Altera at SC24

SAN JOSE, Calif.,  Nov. 13, 2024 — Ayar Labs, a leader in optical interconnect solutions for large-scale AI workloads, will demonstrate a broad range of optical I/O implementations for AI scale-up […]

The post Ayar Labs to Showcase the Future of AI Infrastructure with Fujitsu, Intel, Corning, and Altera at SC24 appeared first on HPCwire.




structure

Makinde presents N678.86bn budget, targets infrastructure, education growth

Oyo State Governor, Seyi Makinde, on Wednesday, presented a proposed budget estimate of N678,086,767,322.18 to the state House of Assembly for legislative consideration and approval. Makinde, while presenting the budget, tagged, “Budget of Economic Stabilisation,” said it was 35 per cent higher compared to the 2024 budget. He said, “Out of the budget, capital expenditure


Read More




structure

From the air and on the ground: IDF soldiers destroy terror infrastructure in Gaza, Lebanon


IDF soldiers operated in both Gaza and southern Lebanon, where they eliminated terrorists and terror infrastructure.




structure

India's infrastructure push to be among largest in 21st century: KPMG

India is likely to see implementation of one of the biggest infrastructure programmes in 21st century, amongst the largest economies and creating fiscal sources of capital would be key to this initiative, according to a KPMG report.





structure

Correction: Superhydrophobic and mechanical properties enhanced the electrospinning film with a multiscale micro-nano structure for high-efficiency radiation cooling

J. Mater. Chem. A, 2024, 12,9241-9241
DOI: 10.1039/D4TA90062F, Correction
Open Access
  This article is licensed under a Creative Commons Attribution 3.0 Unported Licence.
Lijing Kong, Puqing Sun, Jincheng Liu, Yongxing Lin, Chao Xiao, Chao Bao, Kang Zheng, Meng Xue, Xian Zhang, Xianglan Liu, Xingyou Tian
The content of this RSS Feed (c) The Royal Society of Chemistry




structure

Rapid in situ growth of high-entropy oxide nanoparticles with reversible spinel structures for efficient Li storage

J. Mater. Chem. A, 2024, Advance Article
DOI: 10.1039/D3TA08101J, Paper
Open Access
Siyu Zhu, Wei Nong, Lim Jun Ji Nicholas, Xun Cao, Peilin Zhang, Yu Lu, Mingzhen Xiu, Kang Huang, Gang Wu, Shuo-Wang Yang, Junsheng Wu, Zheng Liu, Madhavi Srinivasan, Kedar Hippalgaonkar, Yizhong Huang
Using laser radiation, high-entropy nanoparticles were rapidly fabricated on conductive carbon. The high-entropy nanomaterials with reversible spinel structures exhibit better cycling and rate performances in LIBs.
To cite this article before page numbers are assigned, use the DOI form of citation above.
The content of this RSS Feed (c) The Royal Society of Chemistry




structure

Probing the potential of Al2CO/SiC heterostructures for visible light driven photocatalytic water splitting using first-principles strategies

J. Mater. Chem. A, 2024, Accepted Manuscript
DOI: 10.1039/D4TA00885E, Paper
Amina Shehbaz, Abdul Majid, Hira Batool, Mohammad Alkhedher, Sajjad Haider, Kamran Alam
Photocatalytic water splitting is a sustainable and eco-friendly method for renewable energy production. The fabrication of an efficient photocatalyst based on two-dimensional (2D) interfaces with suitable band offsets is at...
The content of this RSS Feed (c) The Royal Society of Chemistry




structure

Structure/interface synergistic stabilizes high-nickel cathodes for lithium-ion batteries

J. Mater. Chem. A, 2024, Accepted Manuscript
DOI: 10.1039/D4TA01230E, Paper
Guihong Mao, Liming Zeng, Jieyu Yang, Tengyu Yao, Fanming Xiao, Renheng Tang, Xin Shu, Ying Wang, Laifa Shen
Due to with high specific capacity, high nickel layered oxides have been at the forefront of the development of high-energy density lithium-ion batteries. However, high nickel cathodes invariably suffer from...
The content of this RSS Feed (c) The Royal Society of Chemistry




structure

Engineering electronic band structure of ternary thermoelectric nanocatalysts for highly efficient detection of hydrogen sulfide

J. Mater. Chem. A, 2024, Advance Article
DOI: 10.1039/D4TA00438H, Paper
Hongyuan Shang, Xiaofei Zhang, Aiping Zhang, Jinwen Du, Ruiping Zhang
This study rationally designs a ternary thermoelectric nanocatalyst PtTeCu nanorod for the accurate detection of hydrogen sulfide in biomedical applications.
To cite this article before page numbers are assigned, use the DOI form of citation above.
The content of this RSS Feed (c) The Royal Society of Chemistry




structure

Scalable preparation of flexible heterogeneous graphene oxide structures for high performance wet power generation

J. Mater. Chem. A, 2024, Accepted Manuscript
DOI: 10.1039/D4TA01819B, Paper
Yu Gao, Xiaoming Cai, Yuzhou Zhao, Wentian Huang, Jian Lv, Jie Wang, Zhenliang Hao, Huiming Liang, Honglin Tan, Jinming Cai
Moisture-driven energy generation (MEG) has attracted great attention in recent years, and the interaction of functionalized nanomaterials with water offers the possibility of MEG. However, current MEG devices require specific...
The content of this RSS Feed (c) The Royal Society of Chemistry




structure

Structure–property–performance relationship of vanadium- and manganese-based metal–organic frameworks and their derivatives for energy storage and conversion applications

J. Mater. Chem. A, 2024, Advance Article
DOI: 10.1039/D4TA00736K, Review Article
Reza Abazari, Soheila Sanati, Ashok Kumar Nanjundan, Qiyou Wang, Deepak P. Dubal, Min Liu
The current review discusses on vanadium- and manganese-based metal–organic frameworks and their derivatives for energy storage and conversion applications along with the potential future advancements in these fields.
To cite this article before page numbers are assigned, use the DOI form of citation above.
The content of this RSS Feed (c) The Royal Society of Chemistry




structure

A heterostructured WO3–SnO2 nanocomposite for the efficient photocatalytic production of H2O2 under visible light

J. Mater. Chem. A, 2024, Advance Article
DOI: 10.1039/D4TA01223B, Paper
Diya Xie, Chen Chen, Yaru Wang, Cheng Sun, Yiming Xu, Jianguo Huang
A WO3–SnO2 (WSN) nanocomposite was synthesized with unique heterostructures formed in-between the two phases, resulting in the efficient production of H2O2 under visible light due to the synergistic effect.
To cite this article before page numbers are assigned, use the DOI form of citation above.
The content of this RSS Feed (c) The Royal Society of Chemistry




structure

Boosting reaction kinetics of polycrystalline phase Fe7S8/FeS2 heterostructures encapsulated in hollow carbon nanofiber for superior fast sodium storage

J. Mater. Chem. A, 2024, Accepted Manuscript
DOI: 10.1039/D4TA01241K, Paper
Hui Cai, Fei Wang, Huiyan Feng, Zhendong Liu, Chengzhi Zhang, Anbang Lu, Xi Zhao, Qiuhong Lu, Quanbing Liu, Jun Tan
Metal sulfides have been regarded as highly competitive anode materials for fast sodium storage due to the excellent redox reversibility and comparatively great electron properties. Nevertheless, metal sulfides suffer from...
The content of this RSS Feed (c) The Royal Society of Chemistry




structure

In situ construction of a double perovskite heterostructure with exsolved FeNi3 alloy nanoparticles for CO2 electrolysis in solid oxide electrolysis cells

J. Mater. Chem. A, 2024, Advance Article
DOI: 10.1039/D3TA07820E, Paper
Xiaoyu Wang, Haibo Hu, Caiyue Xie, Yifei Wang, Haowei Li, Xifeng Ding
FeNi3 nanoparticles anchored on the (PrBa)0.95Fe1.6Ni0.4O6−δ double perovskite enhance the electrochemical performance and durability in direct CO2 electrolysis.
To cite this article before page numbers are assigned, use the DOI form of citation above.
The content of this RSS Feed (c) The Royal Society of Chemistry




structure

Closed pore structure engineering from ultra-micropores with the assistance of polypropylene for boosted sodium ion storage

J. Mater. Chem. A, 2024, Advance Article
DOI: 10.1039/D4TA01375A, Paper
Xue Li, Ning Sun, Shaohong Zhang, Razium Ali Soomro, Bin Xu
Closed pore architectures with exceptional Na-storage performance have been successfully fabricated from ultra-micropores with the assistance of polypropylene.
To cite this article before page numbers are assigned, use the DOI form of citation above.
The content of this RSS Feed (c) The Royal Society of Chemistry




structure

India IT spending to reach USD 160 billion in 2025 fueled by application and infrastructure software market growth: Gartner




structure

India's infrastructure push to be among largest in 21st century: KPMG




structure

Advances in Detecting Non-Steroidal Anti-Inflammatory Drugs (NSAIDs) Using Molecular Receptors and Nanostructured Assemblies

RSC Med. Chem., 2024, Accepted Manuscript
DOI: 10.1039/D4MD00661E, Review Article
Avijit Kumar Das
The detection and quantification of non-steroidal anti-inflammatory drugs (NSAIDs) are crucial due to their widespread use and potential impact on human health and the environment. This review provides a comprehensive...
The content of this RSS Feed (c) The Royal Society of Chemistry




structure

80% of non-executive directors believe existing practices, structures are inadequate to oversee AI: Gartner




structure

Muscovite dehydration melting; reaction mechanisms, microstructures, and implications for anatexis

Dyck, B; Waters, D J; St-Onge, M R; Searle, M P. Journal of Metamorphic Geology 2019 p. 1-24, https://doi.org/10.1111/jmg.12511
<a href="https://geoscan.nrcan.gc.ca/images/geoscan/20160157.jpg"><img src="https://geoscan.nrcan.gc.ca/images/geoscan/20160157.jpg" title="Journal of Metamorphic Geology 2019 p. 1-24, https://doi.org/10.1111/jmg.12511" height="150" border="1" /></a>




structure

Offshore bedrock geology of Eclipse Sound and Pond Inlet: connecting the structure and stratigraphy of Bylot and northern Baffin islands

Currie, L D; Brent, T A; Turner, E C. Canadian Journal of Earth Sciences vol. 57, no. 10, 2020 p. 1254-1267, https://doi.org/10.1139/cjes-2019-0159
<a href="https://geoscan.nrcan.gc.ca/images/geoscan/20210388.jpg"><img src="https://geoscan.nrcan.gc.ca/images/geoscan/20210388.jpg" title="Canadian Journal of Earth Sciences vol. 57, no. 10, 2020 p. 1254-1267, https://doi.org/10.1139/cjes-2019-0159" height="150" border="1" /></a>




structure

Multidisciplinary modeling of mantle lithosphere structure within the Superior Craton, North America

Snyder, D B; Savard, G; Kjarsgaard, B A; Vaillancourt, A; Thurston, P; Ayer, J A; Roots, E. Geochemistry, Geophysics, Geosystems (G3) vol. 22, issue 4, e2020GC009566, 2021 p. 1-20, https://doi.org/10.1029/2020GC009566
<a href="https://geoscan.nrcan.gc.ca/images/geoscan/20210145.jpg"><img src="https://geoscan.nrcan.gc.ca/images/geoscan/20210145.jpg" title="Geochemistry, Geophysics, Geosystems (G3) vol. 22, issue 4, e2020GC009566, 2021 p. 1-20, https://doi.org/10.1029/2020GC009566" height="150" border="1" /></a>




structure

Magnetic and gravity models, northern half of the Taltson Magmatic Zone, Rae Craton, Northwest Territories: insights into upper crustal structure

Thomas, M D. Geological Survey of Canada, Current Research (Online) 2022-1, 2022, 22 pages, https://doi.org/10.4095/328244
<a href="https://geoscan.nrcan.gc.ca/images/geoscan/gid_328244.jpg"><img src="https://geoscan.nrcan.gc.ca/images/geoscan/gid_328244.jpg" title="Geological Survey of Canada, Current Research (Online) 2022-1, 2022, 22 pages, https://doi.org/10.4095/328244" height="150" border="1" /></a>




structure

The Paleoproterozoic Amer supergroup, Amer Fold Belt, Nunavut: stratigraphy, structure, correlations and uranium metallogeny

Jefferson, C W; Rainbird, R H; Young, G M; White, J C; Tschirhart, V L; Creaser, R A. Canadian Journal of Earth Sciences vol. 60, 2023 p. 1005-1039, https://doi.org/10.1139/cjes-2022-0077
<a href="https://geoscan.nrcan.gc.ca/images/geoscan/20220600.jpg"><img src="https://geoscan.nrcan.gc.ca/images/geoscan/20220600.jpg" title="Canadian Journal of Earth Sciences vol. 60, 2023 p. 1005-1039, https://doi.org/10.1139/cjes-2022-0077" height="150" border="1" /></a>





structure

IDI: Stark disparities in shelters, protective structures for Arab vs. Jewish localities


"The lack of protective structures and the disparity between Arab and Jewish localities...forces Arab residents to live in a state of constant peril," said IDI's Lital Piller




structure

Expert urges Israel to target civilian infrastructure in Lebanon's 'Hezbollah state'


Hezbollah’s drones were “ultimately,” the terrorist organization’s “trump card,” despite rockets being employed as their “main weapons.”




structure

Synthesis of vanillin via oxidation of kenaf stalks in the presence of CeO2: tuning the catalytic behaviour of CeO2 via nanostructure morphology

RSC Adv., 2024, 14,36327-36339
DOI: 10.1039/D4RA05833J, Paper
Open Access
Anita Ramli, Nur Akila Syakida Idayu Khairul Anuar, Normawati Mohamad Yunus, Alina Rahayu Mohamed
A different form of CeO2 nanostructures gives a prevalence of specific crystalline facets which display different reactivity in various catalytic processes. By adapting the shape and size, certain crystal clear facets can be exposed, leading to different structural and redox properties.
The content of this RSS Feed (c) The Royal Society of Chemistry




structure

H.C. Starck Posts Sales Increase with New Structure

H.C. Starck adjusted annual sales increased by 23 percent to 581.7 million euros. The most important external success factor was the positive economic environment in the end industries




structure

An Iconic Coconut Grove Structure Served as Inspiration for the 60th Anniversary Commemorative Poster of the Coconut Grove Arts Festival

The commemorative poster depicting the iconic Monty's Raw Bar was revealed by NBC6 news anchor Roxanne Vargas and the legendary Monty Trainer himself.




structure

Serious Vulnerability in the Internet Infrastructure / Fundamental design flaw in DNSSEC discovered

The National Research Center for Applied Cybersecurity ATHENE has uncovered a critical flaw in the design of DNSSEC, the Security Extensions of DNS (Domain Name System). DNS is one of the fundamental building blocks of the Internet.




structure

Public School Grift Infrastructure Falters


I'm a big supporter of public education -- I went to public school and university for my entire education. Despite my libertarian leanings, I think taxpayer-funded, locally-directed public education can be a very valuable governmental function. However, I'm not a fan of the grift and graft that engulfs public education, for example the money laundering between teachers' unions and the Democrat party. I'm also not fond of the ideological indoctrination that many of the grifters seek to impose on American children, without the consent of the parents.

So I think it's great that the "get woke, go broke" trend is finally hitting the public education grift infrastructure.

Seventeen NSBA affiliates have cut ties with the NSBA over their coordination with the White House and Department of Justice in casting parental complaints over curricula "domestic terrorism." And as Axios reports, they're taking their checkbooks with them -- accounting for a 40% loss in revenue at the NSBA:
The National School Boards Association has since apologized, but the fallout could be seven figures in annual funding. At least 17 state affiliates have severed ties with the group -- and some are even considering establishing a competitor.

The 17 state affiliates accounted for more than 40% of annual dues paid to NSBA by its state association members in 2019, according to Axios' analysis of documents detailing those contributions.

Officials fear upheaval at the organization -- the nation's leading trade group representing U.S. public schools -- will handicap it just as national debates over school curricula and COVID-19 mitigation measures dominate the political conversation.

Good.




structure

5 Things You Need For Your Small Business Infrastructure

When you first start a business, you have your work cut out for you. Not only do you have to figure out if you have a viable product that people will actually pay you for, but you have to also find your customers, manage administrative tasks and deal with your staff, if you have one.

complete article




structure

5 Tips to Consider When Designing (or Redesigning) Your Organizational Structure

It is not a one-time undertaking but an ongoing process that must be revisited throughout the life of any business. In fact, nearly half of all CEOs launch a company reorganization during their first two years on the job.

complete article




structure

Inverted tables: an alternative to relational structures

articles: 

The inverted table format can deliver fast and flexible query capabilities, but is not widely used. ADABAS is probably the most successful implementation, but how often do you see that nowadays? Following is a description of how to implement inverted structures within a relational database. All code run on Oracle Database 12c, release 12.1.0.1.

Consider this table and a few rows, that describe the contents of my larder:

create table food(id number,capacity varchar2(10),container varchar2(10),item varchar2(10));
insert into food values(1,'large','bag','potatoes');
insert into food values(2,'small','box','carrots');
insert into food values(3,'medium','tin','peas');
insert into food values(4,'large','box','potatoes');
insert into food values(5,'small','tin','carrots');
insert into food values(6,'medium','bag','peas');
insert into food values(7,'large','tin','potatoes');
insert into food values(8,'small','bag','carrots');
insert into food values(9,'medium','box','peas');

The queries I run against the table might be "how many large boxes have I?" or "give me all the potatoes, I don't care about how they are packed". The idea is that I do not know in advance what columns I will be using in my predicate: it could be any combination. This is a common issue in a data warehouse.
So how do I index the table to satisfy any possible query? Two obvious possibilities:
First, build an index on each column, and the optimizer can perform an index_combine operation on whatever columns happen to be listed in the predicate. But that means indexing every column - and the table might have hundreds of columns. No way can I do that.
Second, build a concatenated index across all the columns: in effect, use an IOT. That will give me range scan access if any of the predicated columns are in the leading edge of the index key followed by filtering on the rest of the predicate. Or if the predicate does not include the leading column(s), I can get skip scan access and filter. But this is pretty useless, too: there will be wildly divergent performance depending on the predicate.
The answer is to invert the table:
create table inverted(colname varchar2(10),colvalue varchar2(10),id number);
insert into inverted select 'capacity',capacity,id from food;
insert into inverted select 'container',container,id from food;
insert into inverted select 'item',item,id from food;

Now just one index on each table can satisfy all queries:
create index food_i on food(id);
create index inverted_i on inverted(colname,colvalue);

To retrieve all the large boxes:
orclz> set autotrace on explain
orclz> select * from food where id in
  2  (select id from inverted where colname='capacity' and colvalue='large'
  3  intersect
  4  select id from inverted where colname='container' and colvalue='box');

        ID CAPACITY   CONTAINER  ITEM
---------- ---------- ---------- ----------
         4 large      box        potatoes


Execution Plan
----------------------------------------------------------
Plan hash value: 1945359172

---------------------------------------------------------------------------------
| Id  | Operation                                | Name       | Rows  | Bytes | C
---------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                         |            |     3 |   141 |
|   1 |  MERGE JOIN                              |            |     3 |   141 |
|   2 |   TABLE ACCESS BY INDEX ROWID            | FOOD       |     9 |   306 |
|   3 |    INDEX FULL SCAN                       | FOOD_I     |     9 |       |
|*  4 |   SORT JOIN                              |            |     3 |    39 |
|   5 |    VIEW                                  | VW_NSO_1   |     3 |    39 |
|   6 |     INTERSECTION                         |            |       |       |
|   7 |      SORT UNIQUE                         |            |     3 |    81 |
|   8 |       TABLE ACCESS BY INDEX ROWID BATCHED| INVERTED   |     3 |    81 |
|*  9 |        INDEX RANGE SCAN                  | INVERTED_I |     3 |       |
|  10 |      SORT UNIQUE                         |            |     3 |    81 |
|  11 |       TABLE ACCESS BY INDEX ROWID BATCHED| INVERTED   |     3 |    81 |
|* 12 |        INDEX RANGE SCAN                  | INVERTED_I |     3 |       |
---------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   4 - access("ID"="ID")
       filter("ID"="ID")
   9 - access("COLNAME"='capacity' AND "COLVALUE"='large')
  12 - access("COLNAME"='container' AND "COLVALUE"='box')

Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

orclz>

Or all the potatoes:
orclz> select * from food where id in
  2  (select id from inverted where colname='item' and colvalue='potatoes');

        ID CAPACITY   CONTAINER  ITEM
---------- ---------- ---------- ----------
         1 large      bag        potatoes
         4 large      box        potatoes
         7 large      tin        potatoes


Execution Plan
----------------------------------------------------------
Plan hash value: 762525239

---------------------------------------------------------------------------------
| Id  | Operation                              | Name       | Rows  | Bytes | Cos
---------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                       |            |     3 |   183 |
|   1 |  NESTED LOOPS                          |            |       |       |
|   2 |   NESTED LOOPS                         |            |     3 |   183 |
|   3 |    SORT UNIQUE                         |            |     3 |    81 |
|   4 |     TABLE ACCESS BY INDEX ROWID BATCHED| INVERTED   |     3 |    81 |
|*  5 |      INDEX RANGE SCAN                  | INVERTED_I |     3 |       |
|*  6 |    INDEX RANGE SCAN                    | FOOD_I     |     1 |       |
|   7 |   TABLE ACCESS BY INDEX ROWID          | FOOD       |     1 |    34 |
---------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   5 - access("COLNAME"='item' AND "COLVALUE"='potatoes')
   6 - access("ID"="ID")

Note
-----
   - dynamic statistics used: dynamic sampling (level=2)
   - this is an adaptive plan

orclz>

Of course, consideration needs to be given to handling more complex boolean expressions; maintaining the inversion is going to take resources; and a query generator has to construct the inversion code and re-write the queries. But In principle, this structure can deliver indexed access for unpredictable predicates of any number of any columns, with no separate filtering operation. Can you do that with a normalized star schema? I don't think so.
I hope this little thought experiment has stimulated the little grey cells, and made the point that relational structures are not always optimal for all problems.
--
John Watson
Oracle Certified Master DBA
http://skillbuilders.com




structure

Regional Assembly warns against unsustainable growth and calls for Government funding for essential infrastructure

478,000 new homes will be built in the region - which covers the six counties of Bedfordshire, Cambridgeshire, Essex, Hertfordshire, Norfolk and Suffolk - up to 2021...




structure

HafeziCapital Expands International Feasibility Study Services to MENA in Key Sectors: Farming, Ports, Education, Hospitals, Infrastructure, and Oil & Gas

HafeziCapital, a leading international consulting firm renowned for its expertise in structuring and conducting in-depth Feasibility Studies, proudly announces the expansion of its International Feasibility Study services to address critical sectors in the Middle East, Asia Pacific, Latin America, and Africa. This strategic initiative is designed to provide a comprehensive analysis of project viability, enabling [PR.com]




structure

Telekom Slovenije works on EU project to enhance critical infrastructure resilience

(Telecompaper) Telekom Slovenije announced it is actively participating in the Endurance project, a new initiative funded by the European Commission's Horizon...




structure

Forsway obtains ESA funding for Xtend 5G project to combine satellite with ground infrastructure

(Telecompaper) Swedish satellite broadband provider Forsway has announced a development funding contract from the European Space Agency (ESA) with support from the Swedish National Space Agency (SNSA). Under the Xtend 5G project, Forsway will build a next generation 5G non-terrestrial network (NTN) two-way/hybrid...