ﻃﺮاﺣﯽ ﺷِﻤﺎ ﺧﻮدﮐﺎر nosql: ﯾﮏ روش ﻃﺮاﺣﯽ ﺷِﻤﺎ ﻣﺒﺘﻨﯽ ﺑﺮ ﺑﺎرﮐﺎری ﺑﺮای ﭘﺎﯾﮕﺎه داده ﺳﺘﻮنﮔﺴﺘﺮده nosql

ﺳﯿﺴﺘﻢﻫﺎی ﭘﺎﯾﮕﺎه داده nosql راﻫﮑﺎرﻫﺎی ﻣﻨﺎﺳﺒﯽ ﺑﺮای ﭘﺮوژﻫﺎی ﮐﻼن داده ﻫﺴﺘﻨﺪ و از اﻧﻌﻄﺎفﭘﺬﯾﺮی ﺑﺎﻻﯾﯽ در ﻃﺮاﺣﯽ ﺑﺮﺧﻮردارﻧﺪ. در ﭘﺎﯾﮕﺎه داده ﺳﺘﻮنﮔﺴﺘﺮده nosql، ﻃﺮاﺣﯽ ﯾﮏ ﺷِﻤﺎ ﮐﺎراﻣﺪ و ﻣﻨﺎﺳﺐ ﻧﻪ ﺗﻨﻬﺎ واﺑﺴﺘﻪ ﺑﻪ ﻣﺪل داده ﻣﻔﻬﻮﻣﯽ، ﺑﻠﮑﻪ ﺑﻪ ﭘﺮسوﺟﻮﻫﺎی ﺑﺮﻧﺎﻣﻪ ﻫﻢ واﺑﺴﺘﻪ اﺳﺖ. در اﯾﻦ ﭘﺎﯾﮕﺎه دادهﻫﺎ ، ﻃﺮاﺣﯽ ﺷِﻤﺎ دﺳﺘﯽ واﺑﺴﺘﻪ ﺑﻪ ﻗﻮاﻧﯿﻦ ﺳﺮاﻧﮕﺸﺘﯽ ﺑﺮای اﻧﺘﺨﺎب ﺷِﻤﺎی ﻣﻨﺎﺳﺐ اﺳﺖ. ﺑﮑﺎرﮔﯿﺮی اﯾﻦ ﻗﻮاﻧﯿﻦ ﺑﺪون ﺗﺠﺮﺑﻪﻫﺎی ﻋﻤﻠﯽ ﯾﮏ ﭼﺎﻟﺶ ﺑﺰرگ در اﯾﻦ زﻣﯿﻨﻪ اﺳﺖ. ﭼﺮا ﮐﻪ اﯾﻦ ﻗﻮاﻧﯿﻦ ﻣﺒﻬﻢ و ﻣﺘﻨﺎﻗﺾ ﻫﺴﺘﻨﺪ. ﯾﮑﯽ از راهﻫﺎﯾﯽ ﮐﻪ ﭘﮋوﻫﺸﮕﺮان ﺑﺮای ﻏﻠﺒﻪ ﺑﺮ ﭼﺎﻟﺶ ﻣﺬﮐﻮر ﭘﯿﺶ ﮔﺮﻓﺘﻪاﻧﺪ، اراﺋﻪ روشﻫﺎی ﺧﻮدﮐﺎرﺳﺎزی ﻃﺮاﺣﯽ ﺷِﻤﺎی ﭘﺎﯾﮕﺎه داده اﺳﺖ. ﻫﺪف اﺻﻠﯽ اﯾﻦ ﺗﺤﻘﯿﻖ ﺧﻮدﮐﺎرﺳﺎزی ﻃﺮاﺣﯽ ﺷِﻤﺎی ﭘﺎﯾﮕﺎه داده ﺳﺘﻮن-ﮔﺴﺘﺮده nosql اﺳﺖ ﮐﻪ ﺑﺪﯾﻦ ﻣﻨﻈﻮر ﯾﮏ روش ﻣﺒﺘﻨﯽ ﺑﺮ ﺑﺎرﮐﺎری ﺑﺮای ﻧﮕﺎﺷﺖ ﻣﺪل داده ﻣﻔﻬﻮﻣﯽ ﺑﻪ ﺷِﻤﺎ ﭘﺎﯾﮕﺎه داده ﺳﺘﻮن ﮔﺴﺘﺮده ﺑﺎ ﻫﺪف ﺑﻬﯿﻨﻪ-ﺳﺎزی ﮐﺎراﯾﯽ ﺑﺎرﮐﺎری اراﺋﻪ ﻣﯽﺷﻮد. در اﯾﻦ روش از اﻃﻼﻋﺎت ﺑﺎرﮐﺎری ﺑﺮای رﺳﯿﺪن ﺑﻪ ﮐﺎراﯾﯽ ﺑﻬﺘﺮ ﭘﺮسوﺟﻮﻫﺎ اﺳﺘﻔﺎده ﺷﺪه اﺳﺖ ﮐﻪ ﺑﺎ ﮐﻤﯿﻨﻪ ﮐﺮدن ﺗﻌﺪاد درﺧﻮاﺳﺖﻫﺎ ﺑﻪ ﭘﺎﯾﮕﺎه داده ﻣﻨﺠﺮ ﺑﻪ ﻃﺮاﺣﯽ ﺷِﻤﺎی ﺑﻬﯿﻨﻪﯾﺎﻓﺘﻪ ﻣﯽﺷﻮد. ﻧﺘﺎﯾﺞ ﺣﺎﺻﻞ ﺷﺪه از آزﻣﺎﯾﺶﻫﺎ ﻧﺸﺎن ﻣﯽﻫﺪ ﮐﻪ ﺷِﻤﺎ ﺧﻮدﮐﺎر ﺗﻮﻟﯿﺪ ﺷﺪه از روش ﭘﯿﺸﻨﻬﺎدی ﻣﻨﺠﺮ ﺑﻪ ﮐﺎراﯾﯽ ﺧﻮب ﺑﺎرﮐﺎری ﻣﯽﮔﺮدد.

automatic nosql schema design: a workload-driven schema design approach for nosql wide column stores

nosql systems are suitable solutions for big data projects and offer a high level of flexibility in design. a good and efficient schema design for nosql wide column stores is not only based on the application’s conceptual data model but also on the queries defined in an application’s workload. in these databases, a manual schema design relies on rules of thumb to choose a good schema. utility these rules without practices is a big challenge in this area. because these rules are vague and generic, and must be adapted to each application. one of the ways that researchers use to overcome this challenge is presenting automated schema design. the main contribution of this paper is automated schema design for nosql wide column stores. this research proposes a workload-driven approach for the mapping from the application conceptual data model to a database schema with a goal of optimizing query performance. this approach uses workload information to achieve a good workload performance, which result in an optimized schema by minimizing the number of requests to the wide column stores. the experimental results show that automated schema generated by the proposed approach leads to a good workload performance..