bi

Microencapsulation Market worth $24.07 billion by 2029, at a CAGR of 9.4%

(EMAILWIRE.COM, November 06, 2024 ) The microencapsulation market is estimated at USD 15.38 billion in 2024 and is projected to reach USD 24.07 billion by 2029, at a CAGR of 9.4% from 2024 to 2029. The growth of the microencapsulation market is mainly driven by technological advancements and increased...




bi

Medical Foam Market worth $43.3 billion by 2028

(EMAILWIRE.COM, November 06, 2024 ) The report "Medical Foam Market by Form (Flexible, Rigid, Spray), Material (Polymers, Latex, Metals), Application (Bedding & Cushioning, Medical Packaging, Medical Devices & Components, Prosthetics & Wound Care), and Region - Global Forecast to 2028 " The global...




bi

3D Imaging Market to Hit USD 88.4 billion by 2028 with 20.8% CAGR

(EMAILWIRE.COM, November 07, 2024 ) The global 3D Imaging Market is projected to grow from USD 34.3 billion in 2023 to USD 88.4 billion by 2028, at a CAGR of 20.8% during the forecast period. Various business verticals seek 3D imaging due to its capacity to enhance visualization and analysis....




bi

Home Automation System Market Worth $73.49 Billion by 2029 at a CAGR of 5.0%

(EMAILWIRE.COM, November 07, 2024 ) The home automation system market was valued at USD 57.67 billion in 2024 and is projected to reach USD 73.49 billion by 2029; it is expected to register a CAGR of 5.0% during the forecast period. The increasing demand for convenience and comfort in homes, the...




bi

Video Surveillance Market Worth $88.71 Billion by 2030 at a CAGR of 8.5%

(EMAILWIRE.COM, November 07, 2024 ) The global video surveillance market is expected to be valued at 54.42 billion in 2024 and is projected to reach USD 88.71 billion by 2030, at a CAGR of 8.5% from 2024 to 2030. Emerging applications in industries push the market's growth due to the growing demand...




bi

Biosimulation Market worth $9.18 billion by 2029

(EMAILWIRE.COM, November 07, 2024 ) The global Biosimulation Market is projected to reach USD 9.18 billion by 2029 from USD 4.24 billion in 2024, at a CAGR of 16.7% from 2024 to 2029. The major factors driving the growth of the biosimulation market include the high rate of clinical trial failures,...




bi

Edge Computing Market Expected to Surge to $110.6 Billion by 2029

(EMAILWIRE.COM, November 07, 2024 ) According to MarketsandMarkets' latest research, the Edge Computing Market is projected to grow from USD 60.0 billion in 2024 to USD 110.6 billion by 2029, achieving a compound annual growth rate (CAGR) of 13.0%. As the Internet of Things (IoT) continues its rapid...




bi

Quantum Communication Market Projected to Reach $5.54 Billion by 2030

(EMAILWIRE.COM, November 08, 2024 ) The global quantum communication market size is projected to grow from USD 0.74 billion in 2024 to USD 5.54 billion by 2030 at a Compound Annual Growth Rate (CAGR) of 39.6% during the forecast period. Download PDF Brochure@ https://www.marketsandmarkets.com/pdfdownloadNew.asp?id=143942501&utm_source=emailwire.com&utm_medium=paidpr&utm_campaign=quantum-communication-market Increasing...




bi

Orthopedic Devices Industry worth $48.1 billion by 2028, with a CAGR of 4.8%

(EMAILWIRE.COM, November 08, 2024 ) Orthopedic Devices Market in terms of revenue was estimated to be worth $36.3 billion in 2022 and is poised to reach $48.1 billion by 2028, growing at a CAGR of 4.8% from 2022 to 2028 according to a latest report published by MarketsandMarkets™. Increasing cases...




bi

Al in Biotechnology Market worth $7.75 billion by 2029

(EMAILWIRE.COM, November 09, 2024 ) The global Al in Biotechnology Market is projected to reach USD 7.75 billion by 2029 from USD 3.23 billion in 2024, at a high CAGR of 19.1% during the forecast period. Increasing cross-industry collaborations and partnerships that foster innovation and resource...




bi

Agriculture Drones Market worth $8.03 billion by 2029, at a CAGR of 32.0%

(EMAILWIRE.COM, November 11, 2024 ) The agriculture drones market is estimated at USD 2.00 billion in 2024 and is projected to reach USD 8.03 billion by 2029, at a CAGR of 32.0% from 2024 to 2029. The global agriculture drone market is growing substantially due to rapid technological advancements...




bi

Industrial Utility Communication Market worth $4.2 billion by 2028

(EMAILWIRE.COM, November 11, 2024 ) The report "Industrial Utility Communication Market by Technology (Wired, Wireless), Component (Hardware, Software, Services), End-use Industry( Power Generation, , AC Transmission, Oil & Gas, Transportation), and Region - Global Forecast to 2028" The global Industrial...




bi

Food Certification Market worth $7.72 billion by 2029, at a CAGR of 5.7%

(EMAILWIRE.COM, November 12, 2024 ) The food certification market is estimated to be worth USD 5.85 billion in 2024 and is projected to reach USD 7.72 billion by 2029, at a CAGR of 5.7% during the forecast period. The food certification market is experiencing robust growth, driven by increasing consumer...




bi

Simulation Software Market Size to Achieve $36.22 Billion by 2030

(EMAILWIRE.COM, November 12, 2024 ) The global simulation software market is estimated to grow from USD 19.95 billion by 2024 to USD 36.22 billion in 2030, at a CAGR of 10.4% during the forecast period. Download PDF Brochure@ https://www.marketsandmarkets.com/pdfdownloadNew.asp?id=263646018&utm_source=emailwire.com&utm_medium=paidpr&utm_campaign=simulation-software-market Simulation...




bi

Metamaterials Market Set to Reach $1.38 Billion by 2029 at a CAGR of 44.8%

(EMAILWIRE.COM, November 12, 2024 ) The metamaterial market is projected to reach USD 1.38 billion by 2029 from USD 0.22 billion in 2024 at a CAGR of 44.8% during the forecast period. Increasing use of metalens cameras in applications such as smartphones, laptops, and automotive and rising demand...




bi

Synthetic Biology Market worth $31.52 billion in 2029

(EMAILWIRE.COM, November 12, 2024 ) The global Synthetic Biology Market is projected to reach USD 31.52 billion in 2029 from USD 12.33 billion in 2024, with a significant CAGR of 20.6%. Rising demand for bio-based products, growing demand for personalized therapies, especially in gene and cell therapies,...




bi

Electronic Wet Chemicals Market worth $5.4 billion by 2028

(EMAILWIRE.COM, November 12, 2024 ) The report "Electronic Wet Chemicals Market by Type (Acetic Acid, Isopropyl Alcohol, Phosphoric Acid) Form (Liquid Form, Solid Form, Gas Form) Application (Semiconductor, IC Packaging, PCB), End-use Industry, And Region - Global Forecast to 2028" The global Electronic...




bi

Security Service Edge Market Growth Expected to Reach $2.8 Billion by 2028

(EMAILWIRE.COM, November 13, 2024 ) The Security Service Edge Market is expected to reach USD 2.8 billion by 2028 from USD 0.8 billion in 2023, at a CAGR of 25.4 % during 2023–2028. The evolving cybersecurity landscape and the dynamic digital transformation of organizations are driving the adoption...




bi

Antimicrobial Susceptibility Testing Market worth $5.68 Billion by 2029

(EMAILWIRE.COM, November 13, 2024 ) The global Antimicrobial Susceptibility Testing Market is projected to reach USD 5.68 billion by 2029 from USD 4.45 billion in 2024, growing at a CAGR of 5.0% % during the forecast period. Major driving factors for antimicrobial susceptibility market growth come...




bi

***** Durban Aviation Services Ltd | Crowborough | Patricia Jane Wood - BizSeek (rank 23)

Patricia Jane Wood is the primary contact at Durban Aviation Services Ltd. You can contact Durban Aviation Services Ltd by phone using number 01892 610200. Durban Aviation Services Ltd ... Prime Aviation 15.78 km Saint Hill Rd, East Grinstead RH19 4NG, United Kingdom Airlines. Charter A 18.06 km 6 Copthorne Road, Felbridge, EAST GRINSTEAD, RH19 2NS




bi

The Birthday Boys: New Episodes, New Friends

The Birthday Boys: New Episodes, New Friends Interview by Francis Rizzo III Sketch comedy has rarely been hotter on TV than right now, with shows airing on several major networks. One of the more recent additions has been IFC's The...




bi

Geschäftsstelle des Petitionsausschusses bietet Sprechstunde an




bi

Landesbeauftragter für politische Bildung, Aktion Kinder- und Jugendschutz SH und Offene Kirche Sankt Nikolai holen Anne-Frank-Ausstellung 2025 nach Kiel und erinnern mahnend an Novemberpogrome




bi

Landesbeauftragter für politische Bildung: Alle Stolpersteine in Schleswig-Holstein jetzt in der App "Stolpersteine Digital" verfügbar




bi

Serpil Midyatli und Thomas Hölck: FSG-Nobiskrug: Die Werften brauchen einen Neuanfang ohne Windhorst




bi

Birte Glißmann: Großer Dank an die Ermittlungsbehörden!




bi

Sybilla Nitsch: Bei der Cybersicherheit aufrüsten, bevor es zu spät ist




bi

North side of Crystal Pier is my latest habit. I’ve gotten applause for a ride once. Been hooked on my flippers by a fisherman twice. Been told I was thought to be a seal once. That’s so far this year. Different years, different adventures.

from Instagram https://instagr.am/p/DB48I-gSloZ/ via IFTTT




bi

The Bio-Chemical Matrix - The Myths of Matrix Science

by Jon Rappoport www.nomorefakenews.com The medical system kills 225,000 people a year. (Starfield, JAMA, July 26, 2000, "Is US health really the best in the world?") "In principle, gene therapy is a medical miracle waiting to happen ... after 17 years of trying, scientists are still struggling to make gene therapy work. Complications include rejection of DNA carriers ... [and] new genes end up where they shouldn't, or behave unpredictably." ("Gene Therapy: Is Death and Acceptable Risk?", Wired, Brandon Keim, August 30, 2007) MARCH 28, 2012 - In discussing Matrix Science, I'm reminded of Philip Dick's sensational novel, Lies, Inc. It proposes an invention that can teleport humans light-years to a planet where a better way of life exists. The author then spends the rest of the book deconstructing this utopian legend and revealing the truth and the titanic power-grab that sit behind it. Then there is HG Well's 1933 classic novel, The Shape of Things to Come, in which a world exhausted by war and economic collapse turns to a Global State as the only possible solution, after all other solutions have historically failed. This new ruling authority is based on Science. All religions are crushed. Education is designed to teach every child how to become a genius/global citizen. Eventually, the State withers away and is of course replaced by a spontaneous Utopia. Science/technology: the final all-encompassing answer. A significant aspect of Matrix propaganda revolves around myths about how human behavior can be transformed. Transformed through advances in biology and chemistry. Populations are being trained to expect these momentous changes. A major selling point: no effort is required. Just ingest this tablet. Accept this new gene. All will be done for you by experts. Technocrats will design the future so you will fit into it happily. The technocratic wing of Globalism has clout. It promises management of the planet through science, and who can argue with science? Central Planning will ensure proper benefits for all. My late friend and colleague, hypnotherapist Jack True, once told me in an interview:...




bi

Bitwarden 2024.11.0

Bitwarden for Chrome, Firefox, Edge, Opera, and Android is a cross-platform password management solution. Bitwarden is intended to be the easiest and safest way of storing your logins and passwords and keeping them synced between your devices. Your data is fully encrypted before it ever leaves your device, ensuring that you are the only one to have access. The stored data is protected with AES-256 bit encryption, salted hashing, as well as PBKDF2 SHA-256. [License: Open Source / Freemium | Requires: 11|10|8|7|Android|Linux|macOS | Size: Size Varies ]




bi

Robin Williams Comic Genius

DVD Talk Collector Series

The Specials:

The title of this DVD goldmine for fans of Robin Williams' stand-up and improv work can be described with a word that Williams used frequently in his acts over the decades: Redundant. After his singular success in stand-up, film, and TV, everyone should know at this point that the Comic Genius description comes prepackaged with the name. It was for me when I first came to San Francisco for grad school in late 2002, but I mostly knew of Williams' genius through his film roles, a cornucopia of comedic and dramatic work that showcased his immensely versatile talent.

But I didn't know much about his stand-up work, coming from a country where his HBO specials weren't available. A San Francisco native who became a beloved figure of the city as his fame rose; he represented the perfect welcome for me as I bought his 2002 Live on Broadway special on DVD on my first day in th...Read the entire review




bi

The Math Behind Cubic Splines




bi

Helping Others To Freedom Pt10: Revival And Deliverance - The Bigger Picture

In the concluding session of 'Helping Others To Freedom', we look at how the principles of personal healing and deliverance apply to whole regions, and are essentially the same principles that can prepare a region for revival awakening. This is 'Revival And Deliverance - The Bigger Picture' - God sets individuals free in order to heal and deliver the world. This session is available at https://www.preachtheword.com now in MP3 audio format and in HD video on our YouTube Channel (https://youtube.com/PreachTheWord)...



  • Religion & Spirituality

bi

El Gobierno Regional Paga 22,5 Millones de Euros a Agricultores Conquenses por Ayudas de la PAC

El sector agrícola y ganadero de la provincia de Cuenca ha recibido un significativo respaldo económico por parte del Gobierno regional, que ha procedido al pago del anticipo de los ecorregímenes de la Política Agraria Común (PAC) 2024. El delegado provincial de Agricultura, Ganadería y Desarrollo Rural, Rodrigo Fernández Alcalde, ha anunciado que se han […]

Artículo publicado en : El Gobierno Regional Paga 22,5 Millones de Euros a Agricultores Conquenses por Ayudas de la PAC




bi

El Gobierno de Castilla-La Mancha Resalta el Legado de Manuel Marín en la Construcción Democrática de Europa

Ciudad Real, 12 de noviembre de 2024.- El Gobierno de Castilla-La Mancha ha rendido homenaje a Manuel Marín, destacando su papel esencial en la construcción de una Europa democrática y cohesionada. Este reconocimiento fue manifestado por Nazaret Rodrigo, directora general de Asuntos Europeos, durante la presentación del libro ‘Raíz y Rama. Un homenaje a Manuel […]

Artículo publicado en : El Gobierno de Castilla-La Mancha Resalta el Legado de Manuel Marín en la Construcción Democrática de Europa




bi

Where is My Big Toe















The Ghoul is out of the Graveyard and tells a terrifying tale of a missing big toe! Hear this terrifying tale on today's Bedtime Stories My Kids Love.

Enjoy our special October edition of Bedtime Stories My Kids Love.



MP3 File - Click Here to Download Podcast





GREAT DEALS FOR LISTENERS! CLICK BELOW
!




Save 20% on your flower order with FTD Fluerop.com
Save $10 off your next order from PetCareRX.com




bi

Charlotte's Birth Story

Things to know before reading:

1. Charlotte was breech
2. I had a version preformed to flip her
3. She flipped back


When I last left off, I was waiting on our planned c-section. I had a list of things to do and by the Thursday before her Saturday arrival, nearly everything was finished. All of our school work for the semester was complete and all of the laundry in my house was washed, folded, and put away. The only major family thing I had left to do was packing. I never got around to packing.

Thursday afternoon I noticed I was having about 4 contractions an hour. I paid no attention to these because in my previous pregnancies, I had weeks and weeks of contractions prior to actual labor. This pregnancy, I had NO "practice" contractions. I just assumed it was because she was breech and so there was nothing to get ready for. My cervix was also closed at every appointment in the last weeks which is also not normal for me. I normally am between 3-4 cm before I go into labor. So back to the few contractions, I just assumed these where the ones I had been without for the last 6 weeks.

I started cooking dinner on Thursday night and got about halfway through cooking when I felt the first painful and long contraction. It was at 5:15. From that point on, they were coming every 2-3 mins without stopping and lasting over a minute. They went from 0-60 immediately. I couldn't finish making dinner so I really have no idea what the kids ate that night. Rick walked in the door at 6 and I asked him to take Kate to dance and take all of the other kids with him. He asked if it was "time" and I said, "No, I just need to try and make them stop." I had 2 times with Luke where I had similar contractions prior to labor that lasted 2 hours and then stopped. I was assuming that's what was going on here. So from 5:15-9:15, I walked around my house, laid down in my bed, took 2 baths, but nothing was stopping them. It was the same pattern, 2-3 mins apart and lasting from 1-2 mins. I wasn't getting any relief or downtime in between contractions. At some point during this 4 hour period, Rick picked Kate up from dance, printed and folded the bulletins for Sunday, and took them to the church.

I told myself if they were still going at 9:15 that I would call my doctor. My doctor told me to come on in and get checked out and that they would probably keep me overnight to monitor me and decide what to do early Friday morning. I still wasn't sure if I was in labor or not and really didn't want to go and then get sent home so I was relieved that they were going to keep me and that Charlotte would probably be born the next day when my doctor was on call. (He delivered all 7 of our other kids.)

I texted my sister to come stay with the kids and started packing my bags. I always wondered why people packed their hospital bags early. I thought you would have plenty of time in between contractions to get what you needed. Haha! I ended up at the hospital with 6 shirts and 1 pair of shorts. :) I guess I really was in pain.

The ride to the hospital was horrible. Every bump magnified the pain. The contractions didn't slow down and that was when I finally realized that I was actually in labor. It took us about 45 minutes to get to the hospital. I think we arrived around 11:00pm and I was taken to triage to get things checked out. I had never actually been to triage so that was something new. They monitored me for an hour and I had to lay on my back that entire time. That was horrible. I'm pretty sure you are not meant to lay on your back without pain relief during labor. :) They also did an ultrasound to check her position and she was in fact, still breech.

Around 12:20am, Friday morning,  the doctor on call came in said it was time for Charlotte to be born and that we couldn't wait any longer. My contractions were not stopping and my cervix was opening.  From that point on, everything moved quickly and slowly at the same time. The anesthesiologist came in and said I would be getting a spinal because they couldn't wait for an epidural to work. He told me all of the side effects but I'm not really sure what he said. I had to sign about 20 pages of release forms and they I was wheeled off to the operating room while Rick waited in triage to be called back.

I remember the operating room being very, very bright and there were a lot of people in there - I think 10. I'm used to the quiet dark delivery rooms with just one nurse and the doctor so this was a change. I moved from the triage bed to the operating table and was given my spinal. I do remember the anesthesiologist saying that if the spinal didn't take for some reason that they would immediately knock me out and that when I would wake up I'd have a baby. I was hoping that didn't happen. He poked my arm with some kind of sharp object and then would poke on my stomach to make sure I didn't feel anything. The first 2 times he did it I felt it but by the third time, I couldn't feel anything. At that point Rick was let in the room and they began. They had been prepping and draping me during this time as well. Charlotte was born at 12:50 am. She was born toward the beginning of the surgery and it seemed that the bulk of the time was spent getting stitched back together.

She was immediately shown to me over my drape and then taken to get cleaned up a bit. About 2 minutes later she was brought over to me and placed on my chest and I held her for about 5 mins. She was then taken away (in the same room again) to be weighed, etc and Rick went with her. She was then brought back to me all bundled me for a few kisses and then Rick was able to carry her to the recovery room to wait for me. I was in the recovery room for 2 hours and during that time my parents came up to see her. I was able to nurse her which was great. I was also given a pump for my pain medication. The nurse sacred me because she told me to push the button every 8 mins and to stay on top of the pain. She warned me not to fall asleep because if I did and then woke up an hour later, I would not be able to handle the amount of pain I would be in. It was 2:00 in the morning and I was drugged up on morphine and she was telling me not to fall asleep! I guess it worked because I didn't sleep until later that morning, after the pump was turned off. :)

I was in love with her from the moment I saw her. My main concern with having a c-section, prior to having it, was that I would somehow feel like I missed out on the birthing process. I never felt that way. I carried her for 9 months and she arrived in the safest way possible for both of us. It was perfect. The only thing I was sad about was that my doctor missed delivering her by 5 hours. However, that was the Lord's will too. He was on call all weekend so he checked on me everyday while I was in the hospital. C-section recovery is painful. That's all I want to say about that. I just want to remember the hours and minutes before, during, and after her birth. I am thankful for every moment of it.









bi

Arthur Of Albion - Book Review



Arthur of Albion is a beautifully illustrated version of the King Arthur Stories for children, an excellent book for older boys (or girls) interested in Knights. Published by the wonderful Barefoot Books company.

It is set out as a sequence of stories told each night at the round table, as King Arthur requires one of his Knights to tell a tale of valor and adventure every knight before dinner.

It is written by John Matthews illustrated by painter Pavel Tatarnikov and is truly breathtaking, the hardcover edition comes with a map folded up in the back showing the lands of Albion (or the UK as we know it now) in the days these stories were first told.

It would make a fantastic gift for children who are confident readers or to be read aloud to younger children, The way the stories are told makes it an excellent book for reading aloud one story a night for example.

Arthur Of Albion Available on Amazon.


 




bi

High Court rules Work Capability Assessment arguably unlawful

This is a press release from earlier this year about the judicial review that is due to be heard at the Royal Courts Of Justice on the 15th, 16th and 18th of January 2013. Lets pray it goes in our favour as it will open the floodgates for legal action over the WCA if it does. 

Thursday, July 26, 2012

The High Court has today granted permission to two disabled people to bring a claim for
judicial review against the Secretary of State for Work and Pensions to challenge the
operation of the Work Capability Assessment (WCA).
WCAs are face to face interviews carried out by healthcare professionals (HCPs)
employed by Atos Healthcare (a private contractor), to assess disabled people’s
entitlement to Employment and Support Allowance (a sickness benefit that has replaced
the old Incapacity Benefit). Each existing recipient of Incapacity Benefit is now being
assessed for eligibility for ESA, at the rate of some 11,000 people per week. WCAs have
been the subject of serious criticism by all relevant stakeholders in civil society including
doctors and NGOs working on behalf of disabled people.
The present case concerns some of the problems with the system as experienced by
people with mental health problems. Although medically trained, Atos HCPs typically
have very limited knowledge of mental health. The interviews are often hurried, and rely
on applicants to explain the limitations on their ability to work.
This is a serious problem for people with mental health conditions who lack insight into
their conditions, whose conditions fluctuate in seriousness, or who cannot easily talk
about their disability. Such people are placed at a substantial disadvantage in navigating
the system. Even if they appreciate the need to get expert medical evidence for
themselves, they are often less able to navigate the system successfully and to obtain
the medical report that they need. The Equality Act 2010 requires the DWP to make
reasonable adjustments to avoid such disadvantage.
The reasonable adjustment to the process that the claimants seek is for medical
evidence to be sought by the Atos HCP and the DWP at the very outset of the claim.
This would ensure that very sick people for whom having to go through a WCA would be
extremely distressing are exempted from the process, and for those that do attend a
WCA, the assessment of fitness to work takes place in the correct medical context, so
that dangers associated with forcing people back to work are correctly identified.
At present, the DWP do not routinely ask for expert medical report from an applicant’s
community-based doctor. The judge has held that it is arguable that this failure is a
breach of the duty to make reasonable adjustments, and is therefore unlawful.
In granting permission to apply for judicial review, the judge stated:
“I consider that it is reasonably arguable that the reasonable adjustments
required by the [Equality Act 2010] include the early obtaining of independent
medical evidence where the documents submitted with the claim show that the
claimant suffers from mental health problems and that this has not been done, or
at least not done on a sufficiently widespread basis”.
The claimants, known as MM and DM, were granted anonymity by the court. Their
solicitor, Ravi Low-Beer of the Public Law Project said:
“The present system results in many thousands of unnecessary appeals at great
public expense, with a high success rate. What is not counted is the cost in
human misery for those people who should never have had to go through the
appeals process in the first place. This could be avoided if doctors were involved
in the assessments at the outset. The Government’s policy of by-passing doctors
is inefficient, unfair, and inhumane. We gain heart from the court’s finding that as
a matter of law, it is arguable that something has to change.”
For further information contact Ravi Low-Beer on
r.lowbeer@publiclawproject.org.uk/0845 543 5944
or Adrian Lukes on
a.lukes@publiclawproject.org.uk/0845 543 5946.
Public Law Project (PLP)
PLP is an independent, national legal charity which aims to improve access to justice for
those whose access is restricted by poverty, discrimination or other similar barriers. To
fulfil its objectives PLP undertakes research, policy initiatives, casework and training
across the range of public law remedies.
For more information on our work, events and publications: www.publiclawproject.org.uk




bi

Le roi d’Arabie saoudite gracie la jeune femme condamnée après un viol

La jeune femme avait été condamnée à six mois de prison et 200 coups de fouet après avoir été victime d’un viol collectif. Le roi Abdallah d’Arabie saoudite a accordé sa grâce à une jeune femme qui avait été condamnée à six mois de prison et 200 coups...




bi

Sarkozy défenseur des religions en Arabie Saoudite

Le président français a célébré lundi les religions du Livre et félicité le roi Abdallah pour ses efforts d'ouverture. La «politique de civilisation» chère au président français a pris un tour résolument religieux lundi en Arabie Saoudite. Dans ce pays...




bi

La loterie des notes au bac : un réexamen de l'arbitraire de la notation des élèves

La question de la notation à l’école n’est pas récente, les nombreuses études réalisées sur ce thème mettent toutes en évidence l’incertitude de la mesure des performances scolaires des élèves par les notes et les divers biais associés à cette pratique...




bi

La Chine adopte des politiques fiscales pour soutenir le march� de l'immobilier

La Chine a promulgu� mercredi des politiques fiscales pour soutenir le d�veloppement stable et sain du march� de l'immobilier. Le minist�re des Finances a d�clar� que le pays augmenterait les incitations en termes de taxe sur les actes pour...




bi

TORENHOGE AMBITIES IN HET PSG TRAININGSPAK

Het PSG trainingspak opent een boek. De voorsteden en de forensensteden presenteren de stad als één geheel. Een boek met ...... Lees verder: TORENHOGE AMBITIES IN HET PSG TRAININGSPAK




bi

New Release - Land for Sale in Solihull, Birmingham

A rare and desirable opportunity to purchase a block of strategic land just 8 miles from Birmingham City Centre. Totalling over 14 acres the land is available freehold as a whole or lots, with strong investment potential.





bi

Bitemojo self-guided foodtours: een review

BARCELONA – Het is goed uitkijken in het drukke Barcelona. Bitemojo heeft wielrennen.blog.nl een self-guided food tour aangeboden die wij ...... Lees verder: Bitemojo self-guided foodtours: een review





bi

Three impossibilities with partitioned indexes

articles: 

There are three restrictions on indexing and partitioning: a unique index cannot be local non-prefixed; a global non-prefixed index is not possible; a bitmap index cannot be global. Why these limitations? I suspect that they are there to prevent us from doing something idiotic.

This is the table used for all examples that follow:

CREATE TABLE EMP
      (EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,
       ENAME VARCHAR2(10),
       JOB VARCHAR2(9),
       MGR NUMBER(4),
       HIREDATE DATE,
       SAL NUMBER(7,2),
       COMM NUMBER(7,2),
       DEPTNO NUMBER(2) )
PARTITION BY HASH (EMPNO) PARTITIONS 4;

the usual EMP table, with a partitioning clause appended. It is of course a contrived example. Perhaps I am recruiting so many employees concurrently that a non-partitioned table has problems with buffer contention that can be solved only with hash partitioning.

Why can't I have a local non-prefixed unique index?
A local non-unique index is no problem, but unique is not possible:

orclz> create index enamei on emp(ename) local;

Index created.

orclz> drop index enamei;

Index dropped.

orclz> create unique index enamei on emp(ename) local;
create unique index enamei on emp(ename) local
                              *
ERROR at line 1:
ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index

You cannot get a around the problem by separating the index from the constraint (which is always good practice):

orclz> create index enamei on emp(ename) local;

Index created.

orclz> alter table emp add constraint euk unique (ename);
alter table emp add constraint euk unique (ename)
*
ERROR at line 1:
ORA-01408: such column list already indexed


orclz>

So what is the issue? Clearly it is not a technical limitation. But if it were possible, consder the implications for performance. When inserting a row, a unique index (or a non-unique index enforcing a unique constraint) must be searched to see if the key value already exists. For my little four partition table, that would mean four index searches: one of each local index partition. Well, OK. But what if the table were range partitioned into a thousand partitions? Then every insert would have to make a thousand index lookups. This would be unbelievably slow. By restricting unique indexes to global or local prefixed, Uncle Oracle is ensuring that we cannot create such an awful situation.

Why can't I have a global non-prefixed index?
Well, why would you want one? In my example, perhaps you want a global index on deptno, partitioned by mgr. But you can't do it:

orclz> create index deptnoi on emp(deptno) global partition by hash(mgr) partitions 4;
create index deptnoi on emp(deptno) global partition by hash(mgr) partitions 4
                                                                *
ERROR at line 1:
ORA-14038: GLOBAL partitioned index must be prefixed


orclz>
This index, if it were possible, might assist a query with an equality predicate on mgr and a range predicate on deptno: prune off all the non-relevant mgr partitions, then a range scan. But exactly the same effect would be achieved by using global nonpartitioned concatenated index on mgr and deptno. If the query had only deptno in the predicate, it woud have to search each partition of the putative global partitioned index, a process which would be just about identical to a skip scan of the nonpartitioned index. And of course the concatenated index could be globally partitioned - on mgr. So there you have it: a global non-prefixed index would give you nothing that is not available in other ways.

Why can't I have a global partitioned bitmap index?
This came up on the Oracle forums recently, https://forums.oracle.com/thread/2575623
Global indexes must be prefixed. Bearing that in mind, the question needs to be re-phrased: why would anyone ever want a prefixed partitioned bitmap index? Something like this:

orclz>
orclz> create bitmap index bmi on emp(deptno) global partition by hash(deptno) partitions 4;
create bitmap index bmi on emp(deptno) global partition by hash(deptno) partitions 4
                                       *
ERROR at line 1:
ORA-25113: GLOBAL may not be used with a bitmap index

orclz>

If this were possible, what would it give you? Nothing. You would not get the usual benefit of reducing contention for concurrent inserts, because of the need to lock entire blocks of a bitmap index (and therefore ranges of rows) when doing DML. Range partitioning a bitmap index would be ludicrous, because of the need to use equality predicates to get real value from bitmaps. Even with hash partitions, you would not get any benefit from partition pruning, because using equality predicates on a bitmap index in effect prunes the index already: that is what a bitmap index is for. So it seems to me that a globally partitioned bitmap index would deliver no benefit, while adding complexity and problems of index maintenance. So I suspect that, once again, Uncle Oracle is protecting us from ourselves.

Is there a technology limitation?
I am of course open to correction, but I cannot see a technology limitation that enforces any of these three impossibilities. I'm sure they are all technically possible. But Oracle has decided that, for our own good, they will never be implemented.
--
John Watson
Oracle Certified Master DBA
http://skillbuilders.com




bi

Happy Fucking Birthday Time ...

There was a time that I really looked forward to my birthday. When I turned 16, I was ecstatic because I was able to get my drivers license. When I became 18, I was finally considered an adult... for the most part. And on my 21st birthday, I was able to " legally " get into clubs and bars. Alas, those glorious days of positive milestones are gone... long gone!
Now birthdays bring with them more negative than positive connotation's.
This years birthday is a good example. I'm about to become a member of the "Forty Something Crowd"... You know, that group of people who aren't really that old but their not really that young either.
Last year I turned forty. It really wasn't that big of deal. After all, just a year before I had been in my thirties.
Forty Something, on the other hand, has a totally different feel. I'm entering into that obscure age zone where the really crazy shit starts to happen. MILFs start transforming into GILFs. The word cougar takes on a whole new meaning. Hair color goes from fashion choice to necessity. Visions of boob jobs dance in your head. And the term " Her Age" starts being inserted into the most positive statements about you, i.e. "She's fucking hot... for her age".
No, I'm not overly thrilled about my 41st birthday, but I suppose that I'll get used to it. ARGGGGGGGGG ...