CN105930516A - Method for performing comprehensive analysis on tax payment data in multiple databases - Google Patents

Method for performing comprehensive analysis on tax payment data in multiple databases Download PDF

Info

Publication number
CN105930516A
CN105930516A CN201610333383.3A CN201610333383A CN105930516A CN 105930516 A CN105930516 A CN 105930516A CN 201610333383 A CN201610333383 A CN 201610333383A CN 105930516 A CN105930516 A CN 105930516A
Authority
CN
China
Prior art keywords
sql
crashes
data source
result
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201610333383.3A
Other languages
Chinese (zh)
Inventor
程君
邱礼豪
唐平
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
GUANGDONG YUANHENG SOFTWARE TECHNOLOGY Co Ltd
Original Assignee
GUANGDONG YUANHENG SOFTWARE TECHNOLOGY Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by GUANGDONG YUANHENG SOFTWARE TECHNOLOGY Co Ltd filed Critical GUANGDONG YUANHENG SOFTWARE TECHNOLOGY Co Ltd
Priority to CN201610333383.3A priority Critical patent/CN105930516A/en
Publication of CN105930516A publication Critical patent/CN105930516A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/33Querying
    • G06F16/335Filtering based on additional data, e.g. user or group profiles
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/33Querying
    • G06F16/332Query formulation

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a method for performing comprehensive analysis on tax payment data in multiple databases. The method comprises the following steps of (1) selecting a plurality of data sources; (2) setting an associative relationship among the data sources; (3) setting a self-defined index, wherein the index is a combination of fields and formulae of the data sources; (4) setting a filtering condition of the fields in the data sources, wherein the filtering condition is defined based on the formulae of the index in the step (3); (5) setting a result object required to be output and display, wherein the result object is defined based on the formulae of the index in the step (3); (6) selecting a data source as a combination data source, selecting a combination field corresponding to the result object, forming a combination SQL by the combination data source and the combination field corresponding to the result object, combining an executive SQL with the combination SQL to form a combined SQL; and (7) executing the SQL formed in the step (6) and outputting and displaying an executive result. According to the method, business data of different databases can be combined together for querying a cross-database result.

Description

A kind of method that data of paying taxes in multiple data bases are comprehensively analyzed
Technical field
The present invention relates to tax data processing technology field, more particularly it relates to an to many numbers The method comprehensively analyzed according to the data of paying taxes in storehouse.
Background technology
The tax authority uses affairs type operation system to record the business information of item of paying taxes usually, these information It is successively to produce, and be distributed in different system;Transactional database can inquire about certain simply A little transaction records, but it is slow often to there is inquiry velocity, and querying condition is few, and content is single and cannot be carried out data Comprehensive statistics analysis.
For prior art etc. problem, the method needing to set up multiple data combinative analysis of paying taxes.
Summary of the invention
It is an object of the invention to as solving that current transactional database inquiry velocity is slow, inquiry content is single and looks into The technical problem that inquiry condition is few.
In order to realize foregoing invention purpose, the invention provides and a kind of data of paying taxes in multiple data bases are entered The comprehensive method analyzed of row, comprises the steps:
(1) multiple data source is selected;
(2) incidence relation between described data source is set;
(3) arranging user-defined counter, described index is field and the combination of formula of described data source;
(4) arranging the filtercondition of field in described data source, described filtercondition is based in step (3) The formula of described index is defined;
(5) arranging and need the result object of output display, described result object is based on described in step (3) The formula of index is defined;
(6) select described data source as data splitting source, the group that result object described in reselection is corresponding Close field, combined field composition combination S QL that the most described data splitting source is corresponding with described result object, then SQL will be performed merge with described combination S QL, and be formed and merge SQL;
(7) perform the SQL that described step (6) is formed, and output display performs result.
Further, described step (6) replaces with following steps:
Select a described data source as the data source that crashes, the knot that crashes that result object described in reselection is corresponding Really field and the condition that crashes, then described in crash data source and the described result field that crashes based on the described condition that crashes Constitute the SQL that crashes, then execution SQL is merged with the described SQL of crashing, form the SQL that crashes.
Further, described step (3) replaces with following steps:
Aggregate function is set;
The most correspondingly, described in step (4), filtercondition replaces with and is defined based on described aggregate function, Described in step (5), result object also replaces with and is defined based on described aggregate function.
Further, in described step (6), replace with selecting the combined field that described result object is corresponding Typing fixed value, the most correspondingly, described data splitting source constitutes combination S QL with described fixed value.
Further, described step (6) also includes:
Select a described data source as the data source that crashes, the knot that crashes that result object described in reselection is corresponding Really field and the condition that crashes, then described in crash data source and the described result field that crashes based on the described condition that crashes Constitute the SQL that crashes, then execution SQL is merged with the described SQL of crashing, form the SQL that crashes.
Further, described data source is business datum or Query Result.
Further, incidence relation described in step (2) is inline or left association or right association.
Further, described in step (4), filtercondition includes:
Be equal to, be not equal to, be more than, be less than, include, belong to, between with for aerial any one;
Condition value is set to text, field, option list, text list and any one in the date.
Further, described step (7) is the most further comprising the steps of:
Arranging scheduling, described scheduling specifies the execution time of the SQL formed in step (6).
Further, described step (7) is the most further comprising the steps of:
Advanced inquiry is carried out to performing result described in step (7);
Or, export as EXCEL file by performing result described in step (7).
The beneficial effects of the present invention is:
1) after the multiple business datums being likely to be in disparate databases by selection, can be disparate databases Business datum combine, inquire the result data of integration across database;
2), after by selecting multiple queries result, the data of inquiry can be circulated use, use difference The comprehensive inquiry of the data of level;
3) by Correlation Criteria realize between data set and data set inline, left association, the relation of right association;
4) list option of filtercondition, the text option, it is possible to achieve in high volume, the fast quick checking of many data values Ask;
5) the formula function of index, makes result object or filtercondition can add up by the definition rule of formula, This definition rule is extendible, applied widely;
6) aggregate function can realize the fast automatic statistical summaries of preset field;
7) combine and crash merging and peek between functional realiey data and data.
Accompanying drawing explanation
The present invention is further described with embodiment below in conjunction with the accompanying drawings.
Fig. 1 is the flow chart of the embodiment of the present invention 1;
Fig. 2 is the flow chart of the embodiment of the present invention 2;
Fig. 3 is the flow chart of the embodiment of the present invention 3;
Fig. 4 is the flow chart of the embodiment of the present invention 4;
Fig. 5 is the flow chart of the embodiment of the present invention 5;
Fig. 6 is the flow chart of the embodiment of the present invention 6;
Fig. 7 is the flow chart of the embodiment of the present invention 7;
Fig. 8 is the flow chart of the embodiment of the present invention 8.
Detailed description of the invention
In conjunction with the accompanying drawings, the present invention is further detailed explanation.These accompanying drawings are the schematic diagram of simplification, The basic structure of the present invention is described the most in a schematic way, and therefore it only shows the composition relevant with the present invention.
Embodiment 1
As it is shown in figure 1, the method that the data of paying taxes in multiple data bases are comprehensively analyzed of the present invention, Comprise the steps:
S100: select multiple data source, each data source can derive from different data bases;Data source is business Data or Query Result;
S110: the incidence relation between data source is set;Incidence relation is inline or left association or right association;
S120: arrange user-defined counter, index is field and the combination of formula of data source;
S130: arrange the filtercondition of field in data source, filtercondition is public based on step S120 middle finger target Formula is defined;Filtercondition includes:
Be equal to, be not equal to, be more than, be less than, include, belong to, between with for aerial any one;
Condition value is set to text, field, option list, text list and any one in the date;
S140: arrange the result object needing output display, result object is public based on step S120 middle finger target Formula is defined;
S150: select a data source as data splitting source, the combined field that reselection result object is corresponding, The combined field that then data splitting source is corresponding with result object constitutes combination S QL, then will perform SQL and combination SQL merges, and is formed and merges SQL;Also the combined field selecting result object corresponding can be replaced with typing to fix Value, the most correspondingly, data splitting source constitutes combination S QL with fixed value;
S160: perform the SQL that step S150 is formed, and output display performs result.
Embodiment 2
As in figure 2 it is shown, the method that the data of paying taxes in multiple data bases are comprehensively analyzed of the present invention, Comprise the steps:
S200: select multiple data source, each data source can derive from different data bases;Data source is business Data or Query Result;
S210: the incidence relation between data source is set;Incidence relation is inline or left association or right association;
S220: arrange user-defined counter, index is field and the combination of formula of data source;
S230: arrange the filtercondition of field in data source, filtercondition is public based on step S220 middle finger target Formula is defined;Filtercondition includes:
Be equal to, be not equal to, be more than, be less than, include, belong to, between with for aerial any one;
Condition value is set to text, field, option list, text list and any one in the date;
S240: arrange the result object needing output display, result object is public based on step S220 middle finger target Formula is defined;
S250: select a data source as the data source that crashes, result that what reselection result object was corresponding crash Field and the condition that crashes, then the data source that crashes constitutes, based on the condition that crashes, the SQL that crashes, so with the result field that crashes After execution SQL is merged with the SQL that crashes, formed and crash SQL;
S260: perform the SQL that step S250 is formed, and output display performs result.
Embodiment 3
As it is shown on figure 3, the method that the data of paying taxes in multiple data bases are comprehensively analyzed of the present invention, Comprise the steps:
S300: select multiple data source, each data source can derive from different data bases;Data source is business Data or Query Result;
S310: the incidence relation between data source is set;Incidence relation is inline or left association or right association;
S320: arrange user-defined counter, index is field and the combination of formula of data source;
S330: arrange the filtercondition of field in data source, filtercondition is public based on step S320 middle finger target Formula is defined;Filtercondition includes:
Be equal to, be not equal to, be more than, be less than, include, belong to, between with for aerial any one;
Condition value is set to text, field, option list, text list and any one in the date;
S340: arrange the result object needing output display, result object is public based on step S320 middle finger target Formula is defined;
S350: select a data source as data splitting source, the combined field that reselection result object is corresponding, The combined field that then data splitting source is corresponding with result object constitutes combination S QL, then will perform SQL and combination SQL merges, and is formed and merges SQL;Also the combined field selecting result object corresponding can be replaced with typing to fix Value, the most correspondingly, data splitting source constitutes combination S QL with fixed value;
S360: select a data source as the data source that crashes, result that what reselection result object was corresponding crash Field and the condition that crashes, then the data source that crashes constitutes, based on the condition that crashes, the SQL that crashes, so with the result field that crashes After execution SQL is merged with the SQL that crashes, formed and crash SQL;
S370: perform step S350 and the SQL of S360 formation, and output display performs result.
Embodiment 4
As shown in Figure 4, the method that the data of paying taxes in multiple data bases are comprehensively analyzed of the present invention, Comprise the steps:
S400: select multiple data source, each data source can derive from different data bases;Data source is business Data or Query Result;
S410: the incidence relation between data source is set;Incidence relation is inline or left association or right association;
S420: aggregate function is set;
S430: arranging the filtercondition of field in data source, filtercondition is based on aggregate function in step S420 It is defined;Filtercondition includes:
Be equal to, be not equal to, be more than, be less than, include, belong to, between with for aerial any one;
Condition value is set to text, field, option list, text list and any one in the date;
S440: arrange the result object needing output display, result object is based on aggregate function in step S420 It is defined;
S450: select a data source as data splitting source, the combined field that reselection result object is corresponding, The combined field that then data splitting source is corresponding with result object constitutes combination S QL, then will perform SQL and combination SQL merges, and is formed and merges SQL;Also the combined field selecting result object corresponding can be replaced with typing to fix Value, the most correspondingly, data splitting source constitutes combination S QL with fixed value;
S460: perform the SQL that step S450 is formed, and output display performs result.
Embodiment 5
As it is shown in figure 5, the method that the data of paying taxes in multiple data bases are comprehensively analyzed of the present invention, Comprise the steps:
S500: select multiple data source, each data source can derive from different data bases;Data source is business Data or Query Result;
S510: the incidence relation between data source is set;Incidence relation is inline or left association or right association;
S520: aggregate function is set;
S530: arranging the filtercondition of field in data source, filtercondition is based on aggregate function in step S520 It is defined;Filtercondition includes:
Be equal to, be not equal to, be more than, be less than, include, belong to, between with for aerial any one;
Condition value is set to text, field, option list, text list and any one in the date;
S540: arrange the result object needing output display, result object is based on aggregate function in step S520 It is defined;
S550: select a data source as the data source that crashes, result that what reselection result object was corresponding crash Field and the condition that crashes, then the data source that crashes constitutes, based on the condition that crashes, the SQL that crashes, so with the result field that crashes After execution SQL is merged with the SQL that crashes, formed and crash SQL;
S560: perform the SQL that step S550 is formed, and output display performs result.
Embodiment 6
As shown in Figure 6, the method that the data of paying taxes in multiple data bases are comprehensively analyzed of the present invention, Comprise the steps:
S600: select multiple data source, each data source can derive from different data bases;Data source is business Data or Query Result;
S610: the incidence relation between data source is set;Incidence relation is inline or left association or right association;
S620: aggregate function is set;
S630: arranging the filtercondition of field in data source, filtercondition is based on aggregate function in step S620 It is defined;Filtercondition includes:
Be equal to, be not equal to, be more than, be less than, include, belong to, between with for aerial any one;
Condition value is set to text, field, option list, text list and any one in the date;
S640: arrange the result object needing output display, result object is based on aggregate function in step S620 It is defined;
S650: select a data source as data splitting source, the combined field that reselection result object is corresponding, The combined field that then data splitting source is corresponding with result object constitutes combination S QL, then will perform SQL and combination SQL merges, and is formed and merges SQL;Also the combined field selecting result object corresponding can be replaced with typing to fix Value, the most correspondingly, data splitting source constitutes combination S QL with fixed value;
S660: select a data source as the data source that crashes, result that what reselection result object was corresponding crash Field and the condition that crashes, then the data source that crashes constitutes, based on the condition that crashes, the SQL that crashes, so with the result field that crashes After execution SQL is merged with the SQL that crashes, formed and crash SQL;
S670: perform step S650 and the SQL of S660 formation, and output display performs result.
Embodiment 7
As it is shown in fig. 7, the method that the data of paying taxes in multiple data bases are comprehensively analyzed of the present invention, Comprise the steps:
S700: select multiple data source, each data source can derive from different data bases;Data source is business Data or Query Result;
S710: the incidence relation between data source is set;Incidence relation is inline or left association or right association;
S720: arrange user-defined counter, index is field and the combination of formula of data source;
S730: arrange the filtercondition of field in data source, filtercondition is public based on step S720 middle finger target Formula is defined;Filtercondition includes:
Be equal to, be not equal to, be more than, be less than, include, belong to, between with for aerial any one;
Condition value is set to text, field, option list, text list and any one in the date;
S740: arrange the result object needing output display, result object is public based on step S720 middle finger target Formula is defined;
S750: select a data source as data splitting source, the combined field that reselection result object is corresponding, The combined field that then data splitting source is corresponding with result object constitutes combination S QL, then will perform SQL and combination SQL merges, and is formed and merges SQL;Also the combined field selecting result object corresponding can be replaced with typing to fix Value, the most correspondingly, data splitting source constitutes combination S QL with fixed value;
S760: select a data source as the data source that crashes, result that what reselection result object was corresponding crash Field and the condition that crashes, then the data source that crashes constitutes, based on the condition that crashes, the SQL that crashes, so with the result field that crashes After execution SQL is merged with the SQL that crashes, formed and crash SQL;
S770: arrange scheduling, scheduling specifies the execution time of the SQL formed in step S750 and S760;
S780: perform step S750 and the SQL of S760 formation, and output display performs result, and cache execution As a result, for cyclic query;
S790: carry out advanced inquiry to performing result in S780;Or, lead step S780 performs result Go out for EXCEL file.
Embodiment 8
As shown in Figure 8, the method that the data of paying taxes in multiple data bases are comprehensively analyzed of the present invention, Comprise the steps:
S800: select multiple data source, each data source can derive from different data bases;Data source is business Data or Query Result;
S810: the incidence relation between data source is set;Incidence relation is inline or left association or right association;
S820: aggregate function is set;
S830: arranging the filtercondition of field in data source, filtercondition is based on aggregate function in step S820 It is defined;Filtercondition includes:
Be equal to, be not equal to, be more than, be less than, include, belong to, between with for aerial any one;
Condition value is set to text, field, option list, text list and any one in the date;
S840: arrange the result object needing output display, result object is based on aggregate function in step S820 It is defined;
S850: select a data source as data splitting source, the combined field that reselection result object is corresponding, The combined field that then data splitting source is corresponding with result object constitutes combination S QL, then will perform SQL and combination SQL merges, and is formed and merges SQL;Also the combined field selecting result object corresponding can be replaced with typing to fix Value, the most correspondingly, data splitting source constitutes combination S QL with fixed value;
S860: select a data source as the data source that crashes, result that what reselection result object was corresponding crash Field and the condition that crashes, then the data source that crashes constitutes, based on the condition that crashes, the SQL that crashes, so with the result field that crashes After execution SQL is merged with the SQL that crashes, formed and crash SQL;
S870: arrange scheduling, scheduling specifies the execution time of the SQL formed in step S850 and S860;
S880: perform step S850 and the SQL of S860 formation, and output display performs result, and cache execution As a result, for cyclic query;
S890: carry out advanced inquiry to performing result in S880;Or, lead step S880 performs result Go out for EXCEL file.
With the above-mentioned desirable embodiment according to the present invention for enlightenment, by above-mentioned description, related work Personnel can carry out various change and amendment completely in the range of without departing from this invention technological thought. The content that the technical scope of this invention is not limited in description, it is necessary to according to right Determine its technical scope.

Claims (10)

1. the method that the data of paying taxes in multiple data bases are comprehensively analyzed, it is characterised in that bag Include following steps:
(1) multiple data source is selected;
(2) incidence relation between described data source is set;
(3) arranging user-defined counter, described index is field and the combination of formula of described data source;
(4) arranging the filtercondition of field in described data source, described filtercondition is based in step (3) The formula of described index is defined;
(5) arranging and need the result object of output display, described result object is based on described in step (3) The formula of index is defined;
(6) select described data source as data splitting source, the group that result object described in reselection is corresponding Close field, combined field composition combination S QL that the most described data splitting source is corresponding with described result object, then SQL will be performed merge with described combination S QL, and be formed and merge SQL;
(7) perform the SQL that described step (6) is formed, and output display performs result.
Method the most according to claim 1, it is characterised in that described step (6) is replaced with Lower step:
Select a described data source as the data source that crashes, the knot that crashes that result object described in reselection is corresponding Really field and the condition that crashes, then described in crash data source and the described result field that crashes based on the described condition that crashes Constitute the SQL that crashes, then execution SQL is merged with the described SQL of crashing, form the SQL that crashes.
Method the most according to claim 1 and 2, it is characterised in that described step (3) is replaced For following steps:
Aggregate function is set;
The most correspondingly, described in step (4), filtercondition replaces with and is defined based on described aggregate function, Described in step (5), result object also replaces with and is defined based on described aggregate function.
Method the most according to claim 1, it is characterised in that in described step (6), will select The combined field that described result object is corresponding replaces with typing fixed value, the most correspondingly, described data splitting source Combination S QL is constituted with described fixed value.
Method the most according to claim 1, it is characterised in that described step (6) also includes:
Select a described data source as the data source that crashes, the knot that crashes that result object described in reselection is corresponding Really field and the condition that crashes, then described in crash data source and the described result field that crashes based on the described condition that crashes Constitute the SQL that crashes, then execution SQL is merged with the described SQL of crashing, form the SQL that crashes.
6. according to the method described in claim 1 or 2 or 4 or 5, it is characterised in that described data source is Business datum or Query Result.
7. according to the method described in claim 1 or 2 or 4 or 5, it is characterised in that in step (2) Described incidence relation is inline or left association or right association.
8. according to the method described in claim 1 or 2 or 4 or 5, it is characterised in that in step (4) Described filtercondition includes:
Be equal to, be not equal to, be more than, be less than, include, belong to, between with for aerial any one;
Condition value is set to text, field, option list, text list and any one in the date.
9. according to the method described in claim 1 or 2 or 4 or 5, it is characterised in that described step (7) The most further comprising the steps of:
Arranging scheduling, described scheduling specifies the execution time of the SQL formed in step (6).
10. according to the method described in claim 1 or 2 or 4 or 5, it is characterised in that described step (7) The most further comprising the steps of:
Advanced inquiry is carried out to performing result described in step (7);
Or, export as EXCEL file by performing result described in step (7).
CN201610333383.3A 2016-05-18 2016-05-18 Method for performing comprehensive analysis on tax payment data in multiple databases Pending CN105930516A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610333383.3A CN105930516A (en) 2016-05-18 2016-05-18 Method for performing comprehensive analysis on tax payment data in multiple databases

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610333383.3A CN105930516A (en) 2016-05-18 2016-05-18 Method for performing comprehensive analysis on tax payment data in multiple databases

Publications (1)

Publication Number Publication Date
CN105930516A true CN105930516A (en) 2016-09-07

Family

ID=56841506

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610333383.3A Pending CN105930516A (en) 2016-05-18 2016-05-18 Method for performing comprehensive analysis on tax payment data in multiple databases

Country Status (1)

Country Link
CN (1) CN105930516A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107391686A (en) * 2017-07-24 2017-11-24 威创软件南京有限公司 A kind of visual configuration data collecting system implementation method

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101145162A (en) * 2007-10-31 2008-03-19 金蝶软件(中国)有限公司 Data base dynamic inquiry method and system
CN101183371A (en) * 2007-12-12 2008-05-21 中兴通讯股份有限公司 Method for quick finishing large data-handling and reporting system
CN101556579A (en) * 2009-05-08 2009-10-14 用友软件股份有限公司 Formula processing system used for dynamic report areas and method thereof

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101145162A (en) * 2007-10-31 2008-03-19 金蝶软件(中国)有限公司 Data base dynamic inquiry method and system
CN101183371A (en) * 2007-12-12 2008-05-21 中兴通讯股份有限公司 Method for quick finishing large data-handling and reporting system
CN101556579A (en) * 2009-05-08 2009-10-14 用友软件股份有限公司 Formula processing system used for dynamic report areas and method thereof

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107391686A (en) * 2017-07-24 2017-11-24 威创软件南京有限公司 A kind of visual configuration data collecting system implementation method

Similar Documents

Publication Publication Date Title
KR102627690B1 (en) Dimensional context propagation techniques for optimizing SKB query plans
US10217256B2 (en) Visually exploring and analyzing event streams
EP2608074B1 (en) Systems and methods for merging source records in accordance with survivorship rules
US9747349B2 (en) System and method for distributing queries to a group of databases and expediting data access
Zhao A study on e-commerce recommender system based on big data
Ju et al. A novel method of interestingness measures for association rules mining based on profit
US20080288524A1 (en) Filtering of multi attribute data via on-demand indexing
US9223810B2 (en) Storage advisor for hybrid-store databases
US7640234B2 (en) Methods and systems to communicate information
US8972387B2 (en) Smarter search
EP3198479A1 (en) Enriching events with dynamically typed big data for event processing
JP2017523513A (en) Data storage method, data inquiry method, and apparatus thereof
US8463807B2 (en) Augmented search suggest
CN103049521A (en) Mechanism and method for indexing virtual table supporting multi-attribute compound condition query
Mishra et al. Structured and unstructured big data analytics
Bleifuß et al. DBChEx: Interactive Exploration of Data and Schema Change.
WO2010038082A1 (en) Apparatus for responding to a suspicious activity
US8396858B2 (en) Adding entries to an index based on use of the index
Mandl et al. Preference analytics in EXASolution
US20110302220A1 (en) Sql processing for data conversion
CN105930516A (en) Method for performing comprehensive analysis on tax payment data in multiple databases
US10019483B2 (en) Search system and search method
Lungu et al. Business intelligence tools for building the executive information systems
JP2017537398A (en) Generating unstructured search queries from a set of structured data terms
Esmail A survey of real-time data warehouse and ETL

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication

Application publication date: 20160907

RJ01 Rejection of invention patent application after publication