alternative

Alternatives to LEED

It’s no surprise that there are less expensive, less complicated alternatives to LEED.




alternative

Top 2024 Advances in Alternative Protein

These are the FE editorial picks from the past year that best exemplify advances in the alternative protein space, from facilities to flavor.




alternative

NJ Becomes First State to Have Statewide Law Enforcement & Mental Health Alternative Response Program in Nation

ARRIVE Together of Middlesex County, NJ, run by University Behavioral Health Care (UBHC) at Rutgers Health, has expanded its partnerships to include the East Brunswick, South River and Cranbury police departments, making New Jersey the first state in the nation to have a statewide law enforcement and mental health alternative response program.




alternative

NJ Becomes First State to Have Statewide Law Enforcement & Mental Health Alternative Response Program in Nation

ARRIVE Together of Middlesex County, NJ, run by University Behavioral Health Care (UBHC) at Rutgers Health, has expanded its partnerships to include the East Brunswick, South River and Cranbury police departments, making New Jersey the first state in the nation to have a statewide law enforcement and mental health alternative response program.




alternative

Bluesky has added 1 million users since the US election as people seek alternatives to X

The post-election uptick in users isn’t the first time that Bluesky has benefitted from people leaving X.




alternative

Over a Million People Have Recently Joined Bluesky, the Ad-Free X Alternative and Threads Competitor

Bluesky has been seeing noticeable growth since the election, though its user numbers are nowhere close to Meta's X competitor, Threads.





alternative

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




alternative

LXer: Alternatives to popular CLI tools: rm

Published at LXer: This article spotlights alternative tools to rm, a command that removes files or directories. Read More... (https://linuxlinks.com/alternatives-popular-cli-tools-rm/)



  • Syndicated Linux News

alternative

LXer: Radxa X4 review � An Intel N100 alternative to Raspberry Pi 5 tested with Ubuntu 24.04

Published at LXer: We've already looked at the Radxa X4 kit featuring an Intel N100 SBC with a design similar to the Raspberry Pi 5 and accessories including a Radxa Power PD 30W power adapter, an...



  • Syndicated Linux News

alternative

Surfer SEO Review 2024: Features, Pros And Cons, Pricing and Alternatives

Are you looking to improve your search engine optimization (SEO) performance? In this in-depth review, I'll look at what exactly Surfer SEO is, how it works, and why it's one of the most popular SEO tools today. From key features and benefits to pros and cons, you'll know if Surfer SEO is proper for you by the end of this article!



  • Search Engine Optimization
  • Reviews

alternative

Alternative Medicine and Therapies – What, Why and How of it




alternative

Five More Alternative Accommodations

Forget the hotels and resorts. There are a lot of fun and affordable lodging options. Have a look at five here.




alternative

RNA therapy an effective alternative to lifelong, painful eye injections

An RNA-editing gene therapy has been developed that switches off the key driver of common eye conditions affecting diabetics and the elderly. The researchers behind the innovative treatment say that it’s an alternative to the current treatment: regular injections of medication directly into the eye.

Continue Reading

Category: Body & Mind

Tags: , , ,




alternative

This Trendy Appliance Is a More Economical Alternative to an Oven for Cooking Your Meals

Beyond the benefits of quick, oil free cooking, this device has another big advantage: it uses less electricity than a traditional oven.




alternative

A Better Google Analytics Alternative

Our recent migration to GA4 left a lot to be desired and led us to explore for better google analytics alternatives. We tried just about everything out there, including Plausible, Fathom, and several others, all with their own pros and …




alternative

Signal offers an encrypted alternative to Zoom - see how it works

The ability to share secure links for video calls is just one of the privacy-focused messaging app's new features.




alternative

Communication and Alternative Communication: Interview with Dr. Katya Hill - Part 1

Fr. Adrian Budica interviews Dr. Katya Hill - Associate Professor at the School of Health and Rehabilitation Sciences at the University of Pittsburgh and Executive Director of the AAC Institute and clinic a non-profit organization dedicated to serving individuals who cannot talk. (Part 1 of 2)




alternative

Communication and Alternative Communication: Interview with Dr. Katya Hill - Part 2

Fr. Adrian Budica continues his interview with Dr. Katya Hill - Associate Professor at the School of Health and Rehabilitation Sciences at the University of Pittsburgh and Executive Director of the AAC Institute and clinic a non-profit organization dedicated to serving individuals who cannot talk. (Part 2 of 2)




alternative

An Alternative Eros




alternative

The Best Way to Get Call Transcriptions (+5 Alternatives)

If you’re looking for a robust tool that transcribes your calls in real-time, integrates with the most popular meeting platforms, and can even attend meetings in your place, Otter.ai is for you. In this post, we’ll share exactly how to use Otter, plus we’ll give you some alternative options for […]

The post The Best Way to Get Call Transcriptions (+5 Alternatives) appeared first on .




alternative

List of the best online payment alternatives for entrepreneurs.

There are few segments more exciting right now than alternative payment systems. Earth's collective contempt for the entrenched payment tech industry is ardent. This industry has abused users, built regulatory walls to competition, made things insufferable for customers, and as...




alternative

'Alternative graduation makes us feel seen'

A quiet and less formal ceremony is held for neurodivergent students at Sheffield Hallam University.




alternative

A Critical Analysis of Active Learning and an Alternative Pedagogical Framework for Introductory Information Systems Courses




alternative

Presenting an Alternative Source Code Plagiarism Detection Framework for Improving the Teaching and Learning of Programming




alternative

Design Alternatives for a MediaWiki to Support Collaborative Writing in Higher Education Classes




alternative

Alternatives for Pragmatic Responses to Group Work Problems

Group work can provide a valuable learning experience, one that is especially relevant for those preparing to enter the information system workforce. While much has been discussed about effective means of delivering the benefits of collaborative learning in groups, there are some problems that arise due to pragmatic environmental factors such as the part time work commitments of students. This study has identified a range of problems and reports on a longitudinal Action Research study in two universities (in Australia and the USA). Over three semesters problems were identified and methods trialed using collaborative tools. Several promising solutions are presented to the identified problems. These include the use of Google documents and color to ensure team contributions are more even.




alternative

COOPERATION VS COMPETITION: ALTERNATIVE GOAL STRUCTURES FOR MOTIVATING GROUPS IN A RESOURCE SCARCE ENVIRONMENT

There is a growing consensus that cooperative goal structures are more effective at motivating groups than competitive goal structures. However, such results are based largely on studies conducted in highly-controlled settings where participants were provided with the necessary resources to accomplish their assigned task. In an attempt to extend the boundary conditions of current theoretical predictions, we undertook a field experiment within a base-of-the-pyramid setting where resource scarcity is extremely high. Specifically, we collected data on 44 communities within rural Sri Lanka who were tasked with contributing a portion of their resources to the construction of a school building; 24 were assigned to a competition condition and 20 to a cooperation condition. The results of our field experiment, and subsequent follow-up interviews and focus groups, collectively suggest that competitive goal structures generally lead to higher levels of motivation within a resource scarce environment. However, our results also suggest that cooperative goal structures can be highly motivating when groups are unfamiliar with one another, as cooperating with unfamiliar groups can provide access to valuable and rare knowledge within such settings.




alternative

What Is Alternative Music?

Alternative music is difficult to describe. It isn’t pop; it isn’t rock, and it isn’t in between either… it’s alternative. There are endless possibilities within ... Read more

The post What Is Alternative Music? appeared first on CMUSE.






alternative

Balancing alternative medicine with traditional medicine, Why some people don’t get COVID symptoms, Gluten-free Chicken Stir Fry

This week Zorba and Karl discuss how doctors should balance traditional and alternative medicine, and they examine new research that explains why some people don’t experience COVID symptoms. Plus, they […]




alternative

The Construction Phone Alternative

Key questions to choose the right VoIP provider.




alternative

Glass Mat Gypsum Sheathing in Residential Construction: A High-Performance, Code-Compliant Alternative to Traditional Materials

Glass mat gypsum sheathing is common for commercial uses but rarer in residential construction




alternative

MIOSHA releases compliance alternatives for scissor-lift rules

Lansing, MI – The Michigan Occupational Safety and Health Administration has approved two alternatives for complying with its rules on scissor lifts.




alternative

No changes to training requirements for refuge alternatives in coal mines, MSHA says

Washington — The Mine Safety and Health Administration has determined that the annual training requirements outlined in its Refuge Alternatives for Underground Coal Mines rule supply “an experience sufficient to enable miners to apply their knowledge, other training and available written instruction to effectively use the refuge alternative in an emergency.”




alternative

Redesigning work for health: New toolkit offers alternatives to wellness programs

Boston — Rather than provide worker wellness programs aimed at changing individual behaviors, employers should focus on reshaping work conditions that are the root cause of stress-related health problems, say researchers from a pair of Boston universities.




alternative

DOT proposes oral fluid drug testing as an alternative method

Washington — The Department of Transportation has issued a proposed rule that would revise industry drug testing protocol by adding oral fluid testing as an alternative to urine testing for commercial motor vehicle operators and workers in other safety-sensitive transportation positions.




alternative

DOT to include oral fluid option as alternative drug-testing method

Washington — The Department of Transportation has approved oral fluid drug testing as an alternative to urine testing for truck drivers and workers in other safety-sensitive transportation positions.




alternative

Alternative measures for lockout/tagout

When is it appropriate to use the alternative protection measures outlined in OSHA 29 CFR 1910.147 in place of standard LOTO procedures?




alternative

Paid sick leave for federal contractors: Small Business Administration asks DOL to look at alternatives

Washington – The Department of Labor should consider alternatives to its proposal that would require federal contractors to provide paid sick leave to their workers, the Small Business Administration’s Office of Advocacy wrote in an April 6 letter.




alternative

ATA pushes for hair samples as drug-testing alternative

Arlington, VA – The American Trucking Associations is calling for the federal government to release guidelines and standards regarding the use of hair samples as a drug-testing method for commercial motor vehicle drivers.




alternative

Royal Ingredients: Sugar Alternative

HEYLO is made of only two natural ingredients: water extracted stevia (not chemically extracted) and all-natural dietary fibers from the Acacia tree. HEYLO is a prebiotic that is entirely free from artificial sweeteners. It has no chemicals, no hidden sweeteners, no diuretic effect, zero glycemic index value and zero calories.  




alternative

EPOGEE: Alternative Fat

Epogee LLC said that its revolutionary new alternative fat, EPG, has achieved additional GRAS (Generally Recognized As Safe) status by the United States Food and Drug Administration (FDA). 




alternative

Epogee: Alternative Fat

Titled “Cooking up a fat revolution with EPG,” this new resource discusses consumer dynamics and highlights EPG, an alternative fat technology—labelled as a GMO-free modified plant-based oil—that helps manufacturers dramatically lower calories without compromising the taste, texture or functionality of a wide variety of food and beverage applications. 




alternative

Calyxt Achieves Phase 1 Milestone in Collaboration Agreement to Develop Alternative to Palm Oil

Calyxt has begun the second and final phase of the research collaboration and expects to receive a final milestone payment upon completion. 




alternative

Gardein Meat Alternative Soups

Gardein, a brand of Conagra Brands, Inc. debuted five new Gardein Soups, the first-ever line-up of soups featuring plant-based meat alternatives.




alternative

Free Panel: Accelerating Alternative Proteins

Elementar Americas is partnering with Protein Production Technology International to host a free panel discussion and webinar on “Accelerating Alternative Protein Innovation in the Lab.” It will air on Tuesday, April 30, 2024, at 11:00am EDT/8:00am PDT.




alternative

CP Kelco: Alternative Dairy Drinks

CP Kelco’s new KELCOGEL® DFA Gellan Gum is a single-ingredient, dual-function solution for formulating plant-based, dairy alternative beverages.




alternative

Betterine Butter Alternative

Betterine is an alternative to butter and margarine that’s 100% free of dairy products, chemicals, and additives. It can be used in to achieve results without compromising taste or texture.