data repository optimization | Forum

Topic location: Forum home » Reporting » DR Reporting
Mar 2 '17
2017-03-02 19:26:22
We have Meditech's Data Repository, and are wondering what other facilities are doing in terms of how many tables are being populated. When we originally went LIVE, Meditech had a recommendation of turning on 20% of the tables, but the general attitude here is to turn them all on in case we need it.
We are interested in optimizing our system performance, and wonder if there is a better way to do it.
* How do we know what tables are actually being used by any reports?
* How did you decide what tables to turn on?
* Have you tried to turn off any?
o How did that work out?
* Is there any tool to use to run analyses on the tables and alert us to any issues?
* Any other suggestions for optimizing processing speed?
Thanks in advance for any info you can share!
Stephanie Alford
MIS Project Coordinator
Information Systems
[http://www.petersonrmc.com/images/logo3.png]<http://www.petersonrmc.com>;
Peterson Regional Medical Center
551 Hill Country Drive, Kerrville, Texas 78028
o: 830-258-7572
f: 830-258-7321
salford@petersonrmc.com

Mar 2 '17
2017-03-02 20:21:01
Hi Stephanie,
In our experience, enabling every single DR table for data transfer (between 8 and 12k + total, depending on which platform you use) is not advisable. This requires a tremendous amount of network bandwidth not to mention more disk space on the DR server for total data storage.
Both Acmeware and MEDITECH can provide you with a list of core tables, somewhere between 350-500 total, that will provide you with almost all of the information you might ever report out of DR, including for Meaningful Use/IQR or other quality reporting programs (in addition to you own internal reporting needs). By enabling the core tables list first, then selectively adding others as your reporting needs dictate, you can ensure optimal transfer reliability and performance, while also getting all the information you need from your system.
I’m happy to talk with you more offline if you like, or come see us at this year’s International MUSE<http://www.museweb.org/...l-MUSE-Conference>; Conference in Dallas (not too far from Kerrville). We’re presenting a number of DR-focused sessions, including a hands-on learning lab on Tuesday.
Cordially,
-- Ian
Ian Proffer
Vice President, Consulting Services
781.329.4300 x202
[Acmeware_logo_email_signature]<http://www.acmeware.com/>;
Data Repository Experts Since 1998

Mar 2 '17
2017-03-02 20:26:39


chenjinyan
chenjinyan May 14 '18

mont blanc pens wedding shoes cheap nba jerseys air force 1 coach handbags snapbacks wholesale under armour outlet nike air force wholesale nfl jerseys polo ralph lauren balance shoes kobe 11 air max michael kors outlet coach outlet online birkenstock outlet jordan 8 oakley sunglasses polo ralph lauren tag heuer watches barcelona jersey ralph lauren uk louis vuitton jordan 4 beats by dre fingerlings monkey flops jordans dansko shoes tory burch outlet coach factory outlet air jordan 14 adidas ultra boost nike mercurial vapor true religion jeans jordan shoes polo ralph lauren jordan 5 air max 270 louboutin nike uk adidas outlet baseball bats air jordan 11 jordan shoes asics running shoes air huarache louis vuitton jordan xx9 nike shoes converse shoes juicy couture outlet adidas jeremy scott scarpe mbt air max timberland boots adidas stan smith jordans michael kors outlet flip-flops coach outlet nike outlet supreme outlet nike outlet flip flops michael kors outlet off-white clothing nike free kate spade handbags coach outlet stuart weitzman shoes air jordan oakley sunglasses wholesale burberry outlet online cheap mlb jerseys jordan retro pandora jewelry canada nike tennis oakley sunglasses true religion jeans red bottoms pandora jewelry converse herve leger dresses cheap nfl jerseys adidas yeezy 350 cheap jerseys stussy hoodie oakley sunglasses nike free run louis vuitton outlet online cartier jewelry replica watches oakley vault fitflops outlet undefeated shoes nike air max coach outlet michael kors outlet pandora jewelry off-white clothing supreme uk rolex watches longchamp outlet coach factory outlet oakley sunglasses air max 90 ray ban sunglasses nike shoes for men coach outlet online van cleef & arpels jewelry superdry clothing nike lunarglide new balance sandals adidas outlet store jordan 3 louis vuitton outlet toms outlet michael kors outlet adidas flip flops ralph lauren uk michael kors outlet light up shoes burberry outlet michael kors outlet nike uk coach factory outlet nike outlet online burberry outlet salvatore ferragamo air max 95 polo shirts jordan kate spade coach roshe run belstaff jackets audemars piguet ralph lauren nike huarache shoes nfl jerseys wholesale ray ban sunglasses wholesale coach outlet online flip-flops birkenstock sandals burberry outlet canada christian louboutin longchamp coach outlet cheap mlb jerseys nike presto coach outlet online michael kors outlet online red bottom shoes nike cortez converse shoes polo ralph nike blazer ray ban kate spade adidas slides links of london mulberry handbags lebron 15 celine outlet coach outlet online puma fenty sandals true religion jeans louis vuitton outlet ralph lauren bcbg birkenstock shoes james harden shoes ray ban sunglasses nike outlet nike air max louboutin timberland pro basketball shoes nike sb air max 2017 curry shoes ferragamo shoes louis vuitton handbags nike dunks louis vuitton outlet giuseppe zanotti shoes swarovski new balance ray ban longchamp outlet jordan 12 coach outlet oakley sunglasses louboutin pandora jewelry canada air max jordan polo ralph air max hermes outlet prada prada louis vuitton nike free run manolo blahnik shoes hermes kelly bag ray ban sunglasses louis vuitton outlet marc jacobs cheap nfl jerseys suicoke sandals louis vuitton nike epic react mont blanc birkenstock sandals malone souliers mules yeezy 500 blush givenchy handbags louis vuitton handbags cheap rolex watches puma slides michael kors hermes birkin bags jordan 6 nike revolution air jordan adidas wings pandora jewelry air jordan shoes ray ban air max plus supra shoes nike outlet valentino shoes oakley sunglasses bottega veneta hollister outlet nfl jerseys mont blanc pens nike shox nike free swarovski jewelry polo outlet cheap oakley sunglasses longchamp handbags mac cosmetics supreme coach outlet online cheap nfl jerseys adidas football boots asics timberland boots yeezy shoes hermes uk timberland boots louis vuitton dior handbags air jordan nike shoes bvlgari rings birkenstock cheap nhl jerseys michael kors handbags air max 2018 ray ban sunglasses michael kors handbags ray ban nike outlet store tod's shoes flip flops ralph lauren nhl jerseys tory burch outlet nike tn toms outlet online mishka clothing alexander mcqueen shoes breitling watches coach handbags jordans balenciaga shoes ralph lauren balenciaga sandals coach factory outlet online rolex watches michael kors ferragamo outlet ray ban louboutin michael kors handbags outlet louis vuitton mbt shoes adidas uk pandora uk louis vuitton handbags true religion jeans gucci slides jordan 1 nike air max coach factory online vibram five fingers breguet watches michael kors outlet clearance air max 97 nike roshe prada handbags baseball jerseys adidas superstar hermes balenciaga shoes vans shoes oakley sunglasses polo outlet louis vuitton adidas shoes jimmy choo shoes vans shoes ray ban nike blazer flops cheap ray bans true religion jeans true religion tory burch adidas nmd supreme polo outlet miu miu shoes air jordan cheap replica watches pandora outlet gucci outlet michael kors taschen dolce and gabbana nike kyrie 3 beats by dre mizuno running shoes michael kors uk mlb jerseys longchamp soccer jerseys adidas yeezy nike air huarache louis vuitton outlet michael kors handbags jordan shoes nike air pandora charms coach outlet online polo ralph lauren timberland outlet kate spade cheap rolex watches adidas nmd carnival shoes michael kors outlet adidas outlet swarovski crystal adidas outlet store burberry scarf kate spade outlet pandora charms louis vuitton outlet jordans manchester united jersey harden vol 1 fitflops coach kate spade y3 shoes asics running shoes coach factory outlet online polo ralph lauren outlet mcm bags longchamp nike flip-flops kevin durant shoes adidas stan smith shoes oakley canada fila sneakers louis vuitton jordan pas cher air max 1 michael kors outlet blackhawks jersey ralph lauren uk louboutin christian louboutin outlet christian louboutin christian louboutin shoes christian louboutin outlet coach outlet coach outlet online michael kors outlet store kobe 12 nfl jerseys wholesale tory burch tory burch bags prada bags prada handbags columbia sportswear 20185.15chenjinyan